<?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
= 50;
$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
')."%'
" :
""
;
$regsek
=
mktime
( 0,0,0,
date
(
'm'
),
date
(
'd'
),
date
(
'Y'
) ) -
$row
[
'regist'
];
$regday
=
round
(
$regsek
/ 86400);
$postpday
= (
$regday
== 0 ? 0 :
round
(
$row
[
'posts'
] /
$regday
, 2 ) );
$newspday
= (
$regday
== 0 ? 0 :
round
(
$row
[
'newsposts'
] /
$regday
, 2 ) );
$class
=
''
;
$erg
= db_query("SELECT
realname,
posts,
fwarn,
icq,
staat,
clan,
star,
caclan,
status,
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="40" src="include/images/icons/na.gif" alt="n/a" border="0"/>'
;
elseif
(
$row
->geschlecht == 1)
$geschlecht
=
'<img height="20" width="40" src="include/images/icons/mann.gif" alt="männlich" border="0"/>'
;
else
$geschlecht
=
'<img height="20" width="40" src="include/images/icons/frau.gif" alt="weiblich" border="0"/>'
;
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
# onlineak. in farbe
$na
= (time()-
$row
->llogin)/(24*60*60);
if
(
$na
< 7) {
$tc
=
'#00BB00'
;
}
elseif
(
$na
< 14) {
$tc
=
'#F2A41B'
;
}
else
{
$tc
=
'red'
;
}
#ende
if
(
$row
->staat) {
$staat
=
'<img src="include/images/flags/'
.
$row
->staat.
'" alt="" border="0" />'
;}
else
{
$staat
=
'<img src="include/images/flags/na.png" alt="" border="0" />'
; }
if
(
$row
->star) {
$star
=
'<img src="include/images/user/'
.
$row
->star.
'" alt="" border="0" />'
;}
else
{
$star
=
'<img src="include/images/user/na.png" alt="" border="0" />'
; }
$rangcount
= rangcount(
$row
->id,
$row
->posts,
$row
->cpoints,
$row
->fwarn);
$ar
=
array
(
'NAME'
=>
$row
->name,
'REALNAME'
=>
$row
->realname,
'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'
=>
$staat
,
'CLAN'
=>
$row
->clan,
'STAR'
=>
$row
->star,
'CACLAN'
=>
$row
->caclan,
'STATUS'
=> getstate(
$row
->status,
$row
->id),
'EMAIL'
=>
$row
->email,
'LLOGIN'
=>
'<font color="'
.
$tc
.
'">'
.
date
(
'd.m.Y <b\r> H:i'
,
$row
->llogin).
' Uhr</font>'
,
'VERW'
=> verwarnstu(
$row
->fwarn,0),
);
$tpl
->set_ar_out(
$ar
,1);
}
#### Status abfragen ####
function
getstate(
$value
,
$id
){
$state
[
'0'
]=
'<a style="color:#D02090;">inaktiv</a>'
;
$state
[
'1'
]=
'<a style="color:#0000FF;">aktiv</a>'
;
$state
[
'2'
]=
'<a style="color:#FF0000;">gesperrt</a>'
;
$state
[
'3'
]=
'<a style="color:#FF5374;">ausgetreten</a>'
;
$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:#000000;">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();
?>