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

EerList

'$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']*30 : 0; if($_GET['s'] == "login") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`cash`,`bank`,`level`,`clan`,`vip`,`login` FROM `[users]` ORDER BY `login` LIMIT $begin,30"); } else if($_GET['s'] == "power") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`cash`,`bank`,`level`,`clan`,`vip`,`login` FROM `[users]` ORDER BY `attack`+`defence` DESC,`login` ASC LIMIT $begin,30"); } else if($_GET['s'] == "rank") { $dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`attack`,`defence`,`cash`,`bank`,`level`,`clan`,`vip`,`login` FROM `[users]` ORDER BY `rank` DESC,`login` ASC 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 (`respect`) 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->level == 200) ? "$login2" : $login2; $login2 = ($info->level ==50) ? "$login2" : $login2; $login2 = ($info->level == -1) ? "$login2" : $login2; $eer = number_format(round($info->respect)); $power = number_format(round(($info->attack+$info->defence)/2),0,",","."); print (" "); } if($_GET['s'] == "online") $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` & 200 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	Eerpunten	Power
$j	login\" width=\"400\">$login2	$eer	$power

\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 AND `showonline`=1"); $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); /* ------------------------- */ ?>