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:
|
$filename="liste.php";
require("./global.php");
if(isset($_GET['sortby'])) $sortby=$_GET['sortby'];
else $sortby="username";
if(isset($_GET['order'])) $order=$_GET['order'];
else $order="ASC";
$limit = 200;
$checktable=$db->query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE activation=1");
if(isset($_GET['page'])) {
$page=intval($_GET['page']);
if($page==0) $page=1;
}
else $page=1;
$pages = ceil($checktable[0]/$limit);
if($pages>1) $pagelink=makepagelink("liste.php?order=$order&sortby=$sortby&sid=$session[hash]",$page,$pages,$showpagelinks-1);
$alphabet = array();
//Alle Großbuchstaben des Alphabets in das Array holen
for($i=65; $i < 91; $i++) {
$alphabet[] = chr($i);
}
foreach($alphabet AS $buchstabe){
$listebit =" ";
$get_entries = $db->query("SELECT userid, username, avatarid, groupid, liste_status, liste_grund, liste_info FROM bb".$n."_users ORDER BY $sortby $order LIMIT ".($limit*($page-1)).",".$limit);
while ($row=$db->fetch_array($get_entries)){
if(!$row['liste_status']) eval ("\$row[liste_status] = \"".$tpl->get("liste_nodatum")."\";");
if(!$row['liste_grund']) eval ("\$row[liste_grund] = \"".$tpl->get("liste_nogrund")."\";");
if(!$row['liste_info']) eval ("\$row[liste_info] = \"".$tpl->get("liste_noinfo")."\";");
/*UserOnline Hover-Ava*/
$showava="";
$avaqry = $db->query_first("SELECT * FROM bb".$n."_avatars WHERE avatarid='$row[avatarid]'");
if($avaqry['avatarid'] && $showavatar==1 && $wbbuserdata['userid']>0) {
$showava=" onMouseOver=\"return overlib('<img src=images/avatars/avatar-$avaqry[avatarid].$avaqry[avatarextension] width=120 height=200>',RIGHT,ol_fgcolor='{tabletitlecolor}',ol_bgcolor='{tableinbordercolor}',ol_width='$avaqry 50px');\" onMouseOut=\"return nd();\"";
}
eval ("\$listebit.= \"".$tpl->get("liste_bit")."\";");
}
}
eval("\$tpl->output(\"".$tpl->get("liste")."\");"); |