Admin, Helpdesk, VIP, Lid,
'$power2'"); $info_jump1 = mysql_num_rows($query_jump1); $page = floor($info_jump1/20); if(!isset($_GET['p'])){ $_GET['p'] = $page; } } $begin = ($_GET['p'] >= 0) ? $_GET['p'] * 20 : 0; if(isset($_GET['s']) && $_GET['s'] == "login"){ $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`vipdagen`, admin `login` FROM `[users]` ORDER BY `login` LIMIT $begin,20"); } elseif(isset($_GET['s']) && $_GET['s'] == "contant") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`,`vipdagen`, `login` FROM `[users]` ORDER BY `cash` DESC,`login` ASC LIMIT $begin,20"); } elseif(isset($_GET['s']) && $_GET['s'] == "online") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`clicks`,`cash`,`bank`,`level`,`clan`, `rank`,`vipdagen`, `login` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,20"); } else if(isset($_GET['s']) && $_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`,`vipdagen`, `login` FROM `[users]` WHERE `login` LIKE '{$_GET['q']}' ORDER BY `login` LIMIT $begin,20"); } else { $dbres = mysql_query("SELECT * FROM `[users]` ORDER BY (`attack`+`defence`) DESC,`login` ASC LIMIT $begin,20"); } for($j = $begin + 1; $info = mysql_fetch_assoc($dbres); $j++){ $queryBescherming = mysql_query("SELECT *,UNIX_TIMESTAMP(`bescherming`) AS `bescherming`,0 FROM `[users]` WHERE login='".$login2."'"); $aBescherming = mysql_fetch_assoc($queryBescherming); $sBescherming = $aBescherming['bescherming'] + $aBescherming['beschermingtijd'] - time() - 3600; if($aBescherming['bescherming'] + $aBescherming['beschermingtijd'] < time()) { $login2 = "".$login2.""; } else { echo $login2; } $login2 = ($info['level'] > 0 && $info['level'] == 1000 && $_GET['s'] == "online") ? "".$info['login']." *" : $info['login']; $login2 = ($info['level'] == 1000 || $info['admin'] == 1) ? "$login2" : $login2; $login2 = ($info['vipdagen'] > 0) ? "$login2" : $login2; $login2 = ($info['login'] == Randhir) ? "$login2" : $login2; $login2 = ($info['login'] == Playbunny) ? "$login2" : $login2; $login2 = ($info['level'] == -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'] == 230) ? "".$login2."" : $login2; $login2 = ($info['level'] == -1) ? "".$login2."" : $login2; $clan = $info['clan']; $power = number_format(round(($info['attack'] + $info['defence'])),0,",","."); $money = number_format(round($info['bank']),0,",","."); $contant = number_format(round($info['cash']),0,",","."); $clan = ($info['clan'] == "") ? "Geen" : " ".$info['clan'].""; ?> type != 3 || ($data->type == 3 && $info['type'] != 3)) && ($info['clan'] != $data->clan || $info['clan'] == "")) print " \n\n"; } if(isset($_GET['s']) && $_GET['s'] == "online") { $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"); } else if(isset($_GET['s']) && $_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,20"); } else if(isset($_GET['s']) && $_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]`"); } ?>

Zoeken
Voorbeeld: a* zal een lijst geven van namen die beginnen met een A
#	Naam	Clan	Contant	Power	Attack
			€		Attack
Navigatie
<< "; } for($i=0; $i < mysql_num_rows($dbres)/20; $i++) { echo "".($i+1)." "; } if($begin + 20 >= mysql_num_rows($dbres)){ echo ">> "; } else { echo ">>"; } } $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