1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
|
<?php
$filename="memberslist.php";
require("./global.php");
if($wbbuserdata['canviewmblist']==0) access_error();
if(isset($_GET['sortby'])) $sortby=$_GET['sortby'];
else $sortby="userposts";
if(isset($_GET['order'])) $order=$_GET['order'];
else $order="DESC";
switch($sortby) {
case "username": break;
case "regdate": break;
case "userposts": break;
default: $sortby = "userposts"; break;
}
switch($order) {
case "ASC": break;
case "DESC": break;
default: $order = "DESC"; break;
}
$sel_sortby[$sortby]=" selected";
$sel_order[$order]=" selected";
$letteroptions="";
$alpha="#ABCDEFGHIJKLMNOPQRSTUVWXYZ";
if(!isset($_GET['letter']) || ($_GET['letter'] && !strstr($alpha,$_GET['letter']))) $letter="";
else $letter=urldecode($_GET['letter']);
for($i=0;$i<strlen($alpha);$i++) $letteroptions.=makeoption($alpha[$i],$alpha[$i],$letter,1);
if($letter=="#") $memberscount=$db->query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE SUBSTRING(username,1,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') AND activation=1");
else $memberscount=$db->query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE".ifelse($letter," username LIKE '$letter%' AND")." activation=1");
if(isset($_GET['page'])) {
$page=intval($_GET['page']);
if($page==0) $page=1;
}
else $page=1;
$pages = ceil($memberscount[0]/$membersperpage);
if($pages>1) $pagelink=makepagelink("memberslist.php?order=$order&sortby=$sortby&letter=".urlencode($letter)."&sid=$session[hash]",$page,$pages,$showpagelinks-1);
if($letter=="#") $result = $db->query("SELECT userid, username, email, homepage, regdate, userposts, showemail, usercanemail, receivepm, lastactivity FROM bb".$n."_users WHERE SUBSTRING(username,1,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') AND activation=1 ORDER BY $sortby $order LIMIT ".($membersperpage*($page-1)).",".$membersperpage);
else $result = $db->query("SELECT userid, username, email, homepage, regdate, userposts, showemail, usercanemail, receivepm, lastactivity FROM bb".$n."_users WHERE".ifelse($letter," username LIKE '$letter%' AND")." activation=1 ORDER BY $sortby $order LIMIT ".($membersperpage*($page-1)).",".$membersperpage);
$membersbit="";
while($members = $db->fetch_array($result)) {
$members['regdate'] = formatdate($dateformat,$members['regdate']);
if($members['showemail']==1) eval ("\$members_email = " ".$tpl->get("memberslist_email")."";");
elseif($members['usercanemail']==1) eval ("\$members_email = " ".$tpl->get("memberslist_formmail")."";");
else $members_email=" ";
if($members['homepage']) eval ("\$members_homepage = " ".$tpl->get("memberslist_homepage")."";");
else $members_homepage=" ";
if($members['receivepm'] && $wbbuserdata[canusepms]==1) eval ("\$members_pm = " ".$tpl->get("memberslist_pm")."";");
else $members_pm=" ";
if($members['userposts']) eval ("\$members_search = " ".$tpl->get("memberslist_search")."";");
else $members_search=" ";
$q = $db->query_first("SELECT threadid, posttime FROM bb".$n."_posts WHERE userid LIKE '".$members['userid']."' ORDER BY posttime DESC LIMIT 1");
if($q) {
$q2 = $db->query_first("SELECT topic, visible FROM bb".$n."_threads WHERE threadid LIKE '".$q['threadid']."'");
$posttime = formatdate($dateformat,$q['posttime']);
if($q2['visible'] != 1) {
$lastpostbit = "Unbekannt (".$posttime.")";
} else {
$lastpostbit = '<a href="thread.php?threadid='.$q['threadid'].'&sid='.$session[hash].'">'.$q2['topic'].'</a> ('.$posttime.')';
}
} else {
$lastpostbit = "-";
}
$la_d = formatdate($dateformat,$members['lastactivity'],1);
$la_t = formatdate($timeformat,$members['lastactivity']);
$members_avatar = $db->query_first("SELECT
u.*,
a.avatarextension, a.width, a.height
FROM bb".$n."_users u
LEFT JOIN bb".$n."_avatars a ON (a.avatarid=u.avatarid)
WHERE u.userid='$members[userid]'");
if($members_avatar['avatarid'] && $showavatar==1 && $members_avatar['showavatars']==1) {
$avatarname1="images/avatars/avatar-$members_avatar[avatarid].$members_avatar[avatarextension]";
$avatarwidth1=$members_avatar['width'];
$avatarheight1=$members_avatar['height'];
eval ("\$memberavatar = "".$tpl->get("avatar_image")."";");
}else{
eval ("\$memberavatar = "".$tpl->get("noavatar_image")."";");
}
eval ("\$membersbit .= " ".$tpl->get("memberslist_membersbit")."";");
}
$db->free_result($result);
eval("\$tpl->output("".$tpl->get("memberslist")."");");
?>
|
.