<?php
defined (
'main'
)
or
die
(
'no direct access'
);
$title
=
$allgAr
[
'title'
].
' :: User :: '
.
$lang
[
'listofmembers'
];
$hmenu
=
$extented_forum_menu
.
'User <b> » </b> '
.
$lang
[
'listofmembers'
].
$extented_forum_menu_sufix
;
$design
=
new
design (
$title
,
$hmenu
, 1);
$design
->header();
$limit
= 30;
$mema
= @db_result(db_query(
"SELECT COUNT(id) FROM prefix_user WHERE recht < -2 AND status = 1"
),0);
$memi
= @db_result(db_query(
"SELECT COUNT(id) FROM prefix_user WHERE recht < -2 AND status = 0"
),0);
$user
= @db_result(db_query(
"SELECT COUNT(id) FROM prefix_user WHERE recht > -2"
),0);
$emem
= @db_result(db_query(
"SELECT COUNT(id) FROM prefix_user WHERE recht = -2"
),0);
$var
=
array
(
$mema
=>
'WHERE recht < -2 AND status = 1'
,
$memi
=>
'WHERE recht < -2 AND status = 0'
,
$user
=>
'WHERE recht > -2'
,
$emem
=>
'WHERE recht = -2'
,);
$max
=
$var
[max(
$mema
,
$memi
,
$user
,
$emem
)];
$page
= (
$menu
->getA(1) ==
'p'
?
$menu
->getE(1) : 1 );
$MPL
= db_make_sites (
$page
,
$max
,
$limit
,
'?user'
,
'user'
);
$anfang
= (
$page
- 1) *
$limit
;
$tpl
=
new
tpl (
'user/memb_list.htm'
);
$tpl
->set_out (
'SITELINK'
,
$MPL
, 0);
if
(
$anfang
<
$mema
)
echo
'<tr><td colspan="5" align="left">Clanmitglieder (aktiv)</td></tr>'
;
$class
=
''
;
$erg
= db_query(
"SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht < -2 AND status = 1 ORDER by recht,prefix_user.posts ASC LIMIT "
.
$anfang
.
","
.
$limit
);
while
(
$row
= db_fetch_object(
$erg
)) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$ar
=
array
(
'NAME'
=>
$row
->name,
'RANG'
=> userrang(
$row
->posts,
$row
->id),
'CLASS'
=>
$class
,
'POSTS'
=>
$row
->posts,
'UID'
=>
$row
->id,
'DATE'
=>
date
(
'd.m.Y'
,
$row
->regist),
'GRUPE'
=>
$row
->recht_name,);
$tpl
->set_ar_out(
$ar
,1);
}
if
(
$anfang
<
$memi
)
echo
'<tr><td colspan="5" align="left">Clanmitglieder (inaktiv)</td></tr>'
;
$class
=
''
;
$erg2
= db_query(
"SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht < -2 AND status = 0 ORDER by recht,prefix_user.posts ASC LIMIT "
.
$anfang
.
","
.
$limit
);
while
(
$row
= db_fetch_object(
$erg2
)) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$ar
=
array
(
'INAME'
=>
$row
->name,
'IRANG'
=> userrang(
$row
->posts,
$row
->id),
'ICLASS'
=>
$class
,
'IPOSTS'
=>
$row
->posts,
'IUID'
=>
$row
->id,
'IDATE'
=>
date
(
'd.m.Y'
,
$row
->regist),
'IGRUPE'
=>
$row
->recht_name,);
$tpl
->set_ar_out(
$ar
,2);
}
if
(
$anfang
<
$user
)
echo
'<tr><td colspan="5" align="left">User</td></tr>'
;
$class
=
''
;
$erg5
= db_query(
"SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht > -2 ORDER by recht,prefix_user.posts ASC LIMIT "
.
$anfang
.
","
.
$limit
);
while
(
$row
= db_fetch_object(
$erg5
)) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$ar
=
array
(
'UNAME'
=>
$row
->name,
'URANG'
=> userrang(
$row
->posts,
$row
->id),
'UCLASS'
=>
$class
,
'UPOSTS'
=>
$row
->posts,
'UUID'
=>
$row
->id,
'UDATE'
=>
date
(
'd.m.Y'
,
$row
->regist),
'UGRUPE'
=>
$row
->recht_name,);
$tpl
->set_ar_out(
$ar
,3);
}
if
(
$anfang
<
$emem
)
echo
'<tr><td colspan="5" align="left">Ehrennmitglieder</td></tr>'
;
$class
=
''
;
$erg3
= db_query(
"SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht = -2 ORDER by recht,prefix_user.posts ASC LIMIT "
.
$anfang
.
","
.
$limit
);
while
(
$row
= db_fetch_object(
$erg3
)) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$ar
=
array
(
'ENAME'
=>
$row
->name,
'ERANG'
=> userrang(
$row
->posts,
$row
->id),
'ECLASS'
=>
$class
,
'EPOSTS'
=>
$row
->posts,
'EUID'
=>
$row
->id,
'EDATE'
=>
date
(
'd.m.Y'
,
$row
->regist),
'EGRUPE'
=>
$row
->recht_name,);
$tpl
->set_ar_out(
$ar
,4);
}
$tpl
->out(5);
$design
->footer();
?>