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:
102:
103:
104:
105:
106:
|
<?php
$filename="team.php";
require("./global.php");
$users = $db->query("SELECT
u.userid, u.username, u.invisible, u.receivepm, u.lastactivity,
uf.*,
g.canuseacp
FROM bb".$n."_groups g, bb".$n."_users u
LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid)
WHERE u.groupid = g.groupid AND (g.canuseacp = 1 OR g.issupermod = 1) ORDER BY g.canuseacp DESC, u.username ASC");
$acount=1;
$scount=1;
while($user = $db->fetch_array($users)) {
$pm="";
$posts['userid']=$user['userid'];
$posts['username']=$user['username'];
if(($user['invisible']==0 || $wbbuserdata['canuseacp']==1) && $user['lastactivity']>=time()-$useronlinetimeout*60) eval ("\$user_online = "".$tpl->get("thread_user_online")."";");
else eval ("\$user_online = "".$tpl->get("thread_user_offline")."";");
if($wbbuserdata['canusepms']==1 && $user['receivepm']!=0) eval ("\$pm = "".$tpl->get("thread_pm")."";");
###### Username-Style Hack ######
$uname = $user['username'];
$grp_id_query = $db->query_first("SELECT groupid FROM bb".$n."_users WHERE username LIKE '".$uname."'");
$grp_id = $grp_id_query['groupid'];
$group_style_query = $db->query_first("SELECT groupstyle FROM bb".$n."_groups WHERE groupid LIKE '".$grp_id."'");
$group_style = $group_style_query['groupstyle'];
$user2['username'] = stripslashes(sprintf($group_style, $user['username']));
###### Username-Style Hack End ######
if($user['canuseacp']) {
$tdbgcolor=getone($acount,"{tablecolorb}","{tablecolora}");
$tdid=getone($acount,"tableb","tablea");
eval("\$adminbits .= "".$tpl->get("team_adminbit")."";");
$acount++;
}
else {
$tdbgcolor=getone($scount,"{tablecolorb}","{tablecolora}");
$tdid=getone($scount,"tableb","tablea");
eval("\$supermodbits .= "".$tpl->get("team_adminbit")."";");
$scount++;
}
}
$boardids="";
$boardcache=array();
$modcache=array();
$result = $db->query("SELECT b.boardid, b.title, b.invisible, p.boardpermission FROM bb".$n."_boards b LEFT JOIN bb".$n."_permissions p ON (b.boardid=p.boardid AND p.groupid='$wbbuserdata[groupid]')");
while($row=$db->fetch_array($result)) {
if($row['invisible']==1) continue;
$boardcache[$row['boardid']]=$row;
$boardids.=",".$row['boardid'];
}
$count=1;
$result = $db->query("SELECT userid, boardid FROM bb".$n."_moderators WHERE boardid IN (0$boardids) ORDER BY userid ASC");
while ($row = $db->fetch_array($result)) $modcache[$row['userid']][] = $row['boardid'];
$users = $db->query("SELECT
u.userid, u.username, u.invisible, u.receivepm, u.lastactivity,
uf.*
FROM bb".$n."_users u, bb".$n."_groups g
LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid)
WHERE u.groupid = g.groupid AND g.ismod=1 ORDER BY u.username ASC");
while ($user = $db->fetch_array($users)) {
$forumbits="";
$pm="";
$tdbgcolor=getone($count,"{tablecolorb}","{tablecolora}");
$tdid=getone($count,"tableb","tablea");
$posts['userid']=$user['userid'];
$posts['username']=$user['username'];
if(($user['invisible']==0 || $wbbuserdata['canuseacp']==1) && $user['lastactivity']>=time()-$useronlinetimeout*60) eval ("\$user_online = "".$tpl->get("thread_user_online")."";");
else eval ("\$user_online = "".$tpl->get("thread_user_offline")."";");
if($wbbuserdata['canusepms']==1 && $user['receivepm']!=0) eval ("\$pm = "".$tpl->get("thread_pm")."";");
for($i=0;$i<count($modcache[$user['userid']]);$i++) {
$boardid=$modcache[$user['userid']][$i];
if(!$boardcache[$boardid]['boardpermission'] && $boardcache[$boardid]['invisible']==1) continue;
$forumbits .= makehreftag("board.php?boardid=$boardid&sid=$session[hash]",$boardcache[$boardid]['title'])."<br>";
}
###### Username-Style Hack ######
$uname = $user['username'];
$grp_id_query = $db->query_first("SELECT groupid FROM bb".$n."_users WHERE username LIKE '".$uname."'");
$grp_id = $grp_id_query['groupid'];
$group_style_query = $db->query_first("SELECT groupstyle FROM bb".$n."_groups WHERE groupid LIKE '".$grp_id."'");
$group_style = $group_style_query['groupstyle'];
$user2['username'] = stripslashes(sprintf($group_style, $user['username']));
###### Username-Style Hack End ######
eval("\$moderatorbits .= "".$tpl->get("team_modbit")."";");
$count++;
}
unset($boardcache);
if($showboardjump==1) $boardjump=makeboardjump(0);
eval("\$tpl->output("".$tpl->get("team")."");");
?>
|