<?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
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
= 100;
$page
= (
$menu
->getA(1) ==
'p'
?
$menu
->getE(1) : 1 );
$MPL
= db_make_sites (
$page
,
""
,
$limit
,
'?user'
,
'user'
);
$anfang
= (
$page
- 1) *
$limit
;
$tpl
=
new
tpl (
'user/memb_list.htm'
);
$tpl
->set_out (
'SITELINK'
,
$MPL
, 0);
$filtername
= isset(
$_GET
[
'filtername'
]) ?
"WHERE prefix_user.name LIKE '%"
.escape(
$_GET
['filtername
'],'
string
')."%'
" :
""
;
$class
=
''
;
$erg
= db_query("SELECT
posts,
icq,
staat,
clan,
email,
llogin,
geschlecht,
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
$filtername
ORDER by recht,prefix_user.posts DESC LIMIT
".$anfang."
,".
$limit
);
while
(
$row
= db_fetch_object(
$erg
)) {
if
(
$row
->icq ==
""
){
$icq
=
""
;
}
else
{
}
if
(
$row
->geschlecht == 0)
$geschlecht
=
'<img height="20" width="20" src="include/images/icons/na.gif" alt="n/a" border="0"/>'
;
elseif
(
$row
->geschlecht == 1)
$geschlecht
=
'<img height="20" width="20" src="include/images/icons/mann.gif" alt="männlich" border="0"/>'
;
else
$geschlecht
=
'<img height="20" width="20" src="include/images/icons/frau.gif" alt="weiblich" border="0"/>'
;
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$ar
=
array
(
'NAME'
=>
$row
->name,
'RANG'
=> userrang(
$row
->posts,
$row
->id),
'CLASS'
=>
$class
,
'POSTS'
=>
$row
->posts,
'ICQ'
=>
$icq
,
'GESCHLECHT'
=>
$geschlecht
,
'UID'
=>
$row
->id,
'DATE'
=>
date
(
'd.m.Y'
,
$row
->regist),
'GRUPE'
=>
$row
->recht_name,
'STAAT'
=>
$row
->staat,
'CLAN'
=>
$row
->clan,
'EMAIL'
=>
$row
->email,
'LLOGIN'
=>
date
(
'd.m.Y <b\r> H:i'
,
$row
->llogin).
' Uhr'
);
$tpl
->set_ar_out(
$ar
,1);
}
#Status abfragen
function
getstate(
$value
,
$id
){
$state
[
'0'
]=
'inaktiv'
;
$state
[
'1'
]=
'aktiv'
;
$state
[
'2'
]=
'gesperrt'
;
$state
[
'3'
]=
'ausgetreten'
;
$ergResul
=@db_result(db_query(
'SELECT COUNT(`uid`) FROM `prefix_awaycal` WHERE uid = "'
.
$id
.
'" AND von<="'
.
date
(
'Y-m-d'
).
'" AND bis>="'
.
date
(
'Y-m-d'
).
'"'
),0);
if
(
$ergResul
>=1){
$allowed
=@db_result(db_query(
'SELECT pruef FROM `prefix_awaycal` WHERE uid = "'
.
$id
.
'" AND von<="'
.
date
(
'Y-m-d'
).
'" AND bis>="'
.
date
(
'Y-m-d'
).
'"'
),0);
if
(
$allowed
==1){
$away
=
'<br><a href="index.php?awaycal" style="color:#FF0000;">Away</a>'
;
}
elseif
(
$allowed
==2){
$away
=
'<br><a href="index.php?awaycal" style="color:#FF7F00;">Away</a>'
;
}
elseif
(
$allowed
==3){
$away
=
'<br><a href="index.php?awaycal" style="color:#00FF00;">Away</a>'
;
}
}
else
{
$away
=
''
;
}
$aus
=
$state
[
$value
].
$away
;
return
$aus
;
}
$tpl
->set_out(
'filtername'
,escape(isset(
$_GET
[
'filtername'
])?
$_GET
[
'filtername'
]:
''
,
'string'
),2);
$design
->footer();
?>