query("$query$where ORDER BY name", MYSQL_ASSOC);
if($sort=='reg') $users1=$sql->query("$query$where ORDER BY regdate DESC", MYSQL_ASSOC);
if($sort=='act') $users1=$sql->query("$query$where ORDER BY lastactivity DESC", MYSQL_ASSOC);
if($sort=='exp') $users1=$sql->query("$query$where", MYSQL_ASSOC);
if($sort=='age') $users1=$sql->query("$query$where AND birthday ORDER BY birthday", MYSQL_ASSOC);
if($sort=='posts') $users1=$sql->query("$query$where ORDER BY posts DESC", MYSQL_ASSOC);
$numusers=mysql_num_rows($users1);
for ($i = 0; $user = $sql->fetch($users1); $i++) {
$user['days'] = (ctime() - $user['regdate']) / 86400;
$user['exp'] = calcexp($user['posts'], $user['days']);
$user['lvl'] = calclvl($user['exp']);
$users[] = $user;
}
if($sort=='exp')
usort($users,'sortbyexp');
$pagelinks=$smallfont.'Pages:';
for($i=0;$i<($numusers/$ppp);$i++)
$pagelinks.=($i==$page?' '.($i+1):" ".($i+1).'');
$lnk='$tblstart
$tccellh colspan=2>$numusers user". ($numusers != 1 ? "s" : "") ." found.
$tccell1s> Sort by:
$tccell2s>
$lnk=posts$qpow$qsex>Total posts |
$lnk=exp$qpow$qsex>EXP |
$lnk=name$qpow$qsex>User name |
$lnk=reg$qpow$qsex>Registration date |
$lnk=act$qpow$qsex>Last activity |
$lnk=age$qpow$qsex>Age
$tccell1s> Sex:
$tccell2s>
$lnk=$sort$qpow&sex=m>Male |
$lnk=$sort$qpow&sex=f>Female |
$lnk=$sort$qpow&sex=n>N/A |
$lnk=$sort$qpow>All
$tccell1s> Powerlevel:
$tccell2s>
$lnk=$sort$qsex&pow=-1>Banned |
$lnk=$sort$qsex&pow=0>Normal |
". ($loguser['powerlevel'] >= 1 ? "$lnk=$sort$qsex&pow=1>Normal + | " : "") ."
$lnk=$sort$qsex&pow=2>Moderator |
$lnk=$sort$qsex&pow=3>Administrator |
$lnk=$sort$qsex>All
$tblend
$tblstart
$tccellh width=30>#
$tccellh width=16>
$tccellh>Username
";
if (!$rpg) {
print "
$tccellh width=200>Registered on
$tccellh width=200>Last active
$tccellh width=60>Posts
$tccellh width=35>Level
$tccellh width=100>EXP
";
} else {
$items = $sql->getarraybykey("SELECT * FROM items", 'id');
$classes = $sql->getarraybykey("SELECT * FROM rpg_classes", 'id');
print "$tccellh width=35>Level";
print "$tccellh width=90>Class";
for($i=0;$i<9;$i++) print "$tccellh width=65>".$stat[$i].'';
print "$tccellh width=80>
";
print "$tccellh width=60>
";
print "";
}
$s = $ppp*$page;
$ulist = "";
for($u=0;$u < $ppp;$u++) {
$i = $s + $u;
$user = $users[$i] ?? null;
if (!$user) break;
$ulist.="";
$userpicture=' ';
if ($user['minipic'])
$userpicture="![](".str_replace()
','>',$user['minipic'])."'>";
$userlink = getuserlink($user);
$ulist.="
$tccell2>".($i+1)."
$tccell1l>{$userpicture}
$tccell2l>{$userlink}
";
if(!$rpg){
$ulist.="
$tccell2>".date($dateformat,$user['regdate']+$tzoff)."
$tccell2>".date($dateformat,$user['lastactivity']+$tzoff)."
$tccell1r>{$user['posts']}
$tccell1r>{$user['lvl']}
$tccell1r>{$user['exp']}
";
}
else {
if (!($class = ($classes[$user['class']] ?? null)))
$class = array('name'=>'None');
$stats=getstats($user,$items,$class);
$ulist.="$tccell1>$user[lvl]";
$ulist.="$tccell1>$class[name]";
for($k=0;$k<9;$k++) $ulist.="$tccell1s>".$stats[$stat[$k]].'';
$ulist.="$tccell1s>$stats[GP]";
$ulist.="$tccell1s>$user[gcoins]";
}
$ulist.="
";
}
print "$ulist$tblend$pagelinks$footer";
printtimedif($startingtime);