login}'"); /* ------------------------- */ ?> [( Criminals )] ">
Voorbeeld: "a*" zal een lijst geven van namen die beginnen met een A
= 0) ? $_GET['p']*30 : 0; if($_GET['s'] == "login") $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 ORDER BY `login` LIMIT $begin,30"); else if($_GET['s'] == "money") $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 ORDER BY `cash`+`bank` DESC,`login` ASC LIMIT $begin,30"); else if($_GET['s'] == "type") $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 ORDER BY `type`,`login` LIMIT $begin,30"); else if($_GET['s'] == "online" && $data->level & 0x80) $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level`,`showonline` FROM `[users]` WHERE `activated`=1 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30"); else if($_GET['s'] == "online") $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `showonline`=1 ORDER BY `login` LIMIT $begin,30"); else if($_GET['s'] == "admin") $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `level` & 0x80 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30"); else if($_GET['s'] == "search") { $_GET['q'] = preg_replace('/\*/','%',$_GET['q']); $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 AND `login` LIKE '{$_GET['q']}' ORDER BY `login` LIMIT $begin,30"); } else $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`type`,`level` FROM `[users]` WHERE `activated`=1 ORDER BY (`attack`+`defence`)/2+`clicks`*5 DESC,`login` ASC LIMIT $begin,30"); for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++) { $login = ($info->showonline == 0 && $data->level & 0x80 && $_GET['s'] == "online") ? "{$info->login} *" : $info->login; $login = ($info->level & 0x80) ? "$login" : $login; $type = Array("","Drugsdealer","Wetenschapper","Agent"); $type = $type[$info->type]; $power = round(($info->attack+$info->defence)/2+$info->clicks*5); $money = $info->cash+$info->bank; print << ENDHTML; if(($data->type != 3 || ($data->type == 3 && $info->type != 3)) && round($data->signup/3600-time()/3600) + 12 <= 0 && round($info->signup/3600-time()/3600) + 12 <= 0 && ($info->clan != $data->clan || $info->clan == "")) print " \n\n"; else print " \n\n"; } if($_GET['s'] == "online" && $data->level & 0x80) $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"); else if($_GET['s'] == "online") $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `showonline`=1"); else if($_GET['s'] == "admin") $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level` & 0x80 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30"); else if($_GET['s'] == "search") { $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `activated`=1 AND `login` LIKE '{$_GET['q']}' ORDER BY `login`"); $_GET['q'] = preg_replace('/%/','*',$_GET['q']); } else $dbres = mysql_query("SELECT id FROM `[users]` WHERE `activated`=1"); print "
# Nickname Type Geld Power
$j $login $type \$$money $powerlogin}\">Attack
\n\n\n
"; if(mysql_num_rows($dbres) <= 30) print "< 1 >
\n"; else { if($begin/30 == 0) print "<< "; else print "<< "; for($i=0; $i". ($i+1) ." "; } if($begin+30 >= mysql_num_rows($dbres)) print ">> "; else print ">>"; } $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"); $online = mysql_num_rows($dbres); $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `showonline`=0"); $anonymous = mysql_num_rows($dbres); /* ------------------------- */ ?>
leden online (waarvan anoniem)