login}'"); // DEBUG CODE: // echo $_SESSION['login']; // s = kolomnaam // q = zoekterm ?>

Voorbeeld: "a*" zal een lijst geven van namen die beginnen met een A

'$power2'"); $info_jump1 = mysql_num_rows($query_jump1); $page = floor($info_jump1/30); if(!isset($_GET['p'])) { $_GET['p'] = $page; } } $begin = ($_GET['p'] >= 0) ? $_GET['p']*30 : 0; if($_GET['s'] == "login") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`hulpadmin`,`vermoord`,`vip`,`login` FROM `[users]` ORDER BY `login` LIMIT $begin,30"); } else if($_GET['s'] == "rank") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`rank`,`hulpadmin`,`vermoord`,`vip`,`login` FROM `[users]` ORDER BY `rank` DESC,`login` ASC LIMIT $begin,30"); } else if($_GET['s'] == "contant") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`hulpadmin`,`vermoord`,`vip`,`login` FROM `[users]` ORDER BY `cash` DESC,`login` ASC LIMIT $begin,30"); } else if($_GET['s'] == "online") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`vermoord`,`vip`,`hulpadmin`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`, `rank`,`hulpadmin`,`vermoord`,`vip`,`login` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30"); } else if($_GET['s'] == "clanonline") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`vermoord`,`vip`,`hulpadmin`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`, `rank`,`hulpadmin`,`vermoord`,`vip`,`login` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `clan`='$data->clan' ORDER BY `login` LIMIT $begin,30"); } else if($_GET['s'] == "clan") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`login` FROM `[users]` ORDER BY `login`,`clan` LIMIT $begin,30"); } else if($_GET['s'] == "search") { $_GET['q'] = preg_replace('/\*/','%',$_GET['q']); $_GET['q'] = htmlspecialchars($_GET['q']); $_GET['q'] = addslashes($_GET['q']); $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`login` FROM `[users]` WHERE `login` LIKE '{$_GET['q']}' ORDER BY `login` LIMIT $begin,30"); } else { $dbres = mysql_query("SELECT * FROM `[users]` ORDER BY (`attack`+`defence`)/2+`clicks`*5 DESC,`login` ASC LIMIT $begin,30"); } /* */ for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++) { $login2 = ($info->level > 0 && $data->level == 1000 && $_GET['s'] == "online") ? "{$info->login} *" : $info->login; $login2 = ($info->login == maffiaking) ? "$login2" : $login2; $login2 = ($info->login == danceswithwolves) ? "$login2" : $login2; $login2 = ($info->login == naamnaarkeuze) ? "$login2" : $login2; $login2 = ($info->login == naamnaarkeuze) ? "$login2" : $login2; $login2 = ($info->hulpadmin == 1) ? "$login2" : $login2; $login2 = ($info->level == -1) ? "$login2" : $login2; $login2 = ($info->vermoord > 0) ? "$login2 [overleden]" : $login2; $login2 = ($info->gebeltx == 1) ? "$login2" : $login2; $login2 = ($info->level == 1) ? "$login2" : $login2; $login2 = ($info->level == 100) ? "$login2" : $login2; $login2 = ($info->level == 10) ? "$login2" : $login2; $login2 = ($info->level == 20) ? "$login2" : $login2; $login2 = ($info->level == 30) ? "$login2" : $login2; $login2 = ($info->level == 40) ? "$login2" : $login2; $login2 = ($info->level == 80) ? "$login2" : $login2; $login2 = ($info->level == 70) ? "$login2" : $login2; $login2 = ($info->level == 170) ? "$login2" : $login2; $login2 = ($info->level == 180) ? "$login2" : $login2; $login2 = ($info->level == 190) ? "$login2" : $login2; $login2 = ($info->level == 200) ? "$login2" : $login2; $login2 = ($info->level == 210) ? "$login2" : $login2; $login2 = ($info->level== 220) ? "$login2 ^VIP^" : $login2; $login2 = ($info->level == 230) ? "$login2" : $login2; $clan = $clan[$info->clan]; $power = number_format(round(($info->attack+$info->defence)/2+$info->clicks*5),0,",","."); $money = number_format(round($info->bank),0,",","."); $contant = number_format(round($info->cash),0,",","."); $clan = ($info->clan == "") ? "Geen" : $info->clan; print (" "); print " \n\n"; } if($_GET['s'] == "online") { $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"); } else if($_GET['s'] == "clanleden") { $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan` ='{$data->clan}' 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 `login` LIKE '{$_GET['q']}' ORDER BY `login`"); $_GET['q'] = preg_replace('/%/','*',$_GET['q']); } else { $dbres = mysql_query("SELECT id FROM `[users]`"); print "

#	Nickname	Clan	Contant	Power
$j	login\" width=\"200\">$login2	$clan	€$contant	$power	login}\" width=\"40\">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); /* ------------------------- */ ?>
er zijn momenteel leden online

Legenda
Admins:	Dit zijn de makers van The others.
betaald account:	Deze mensen hebben een voordeel en steunen the others.
hulp-admin:	Dit zijn hulp-admins van the others.
verbannen account:	regels overtreden van the others.