Beste Spelers:
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `type`=1 AND `activated`=1");
$type1 = mysql_num_rows($dbres);
$dbres2 = mysql_query("SELECT `id` FROM `[users]` WHERE `type`=2 AND `activated`=1");
$type2 = mysql_num_rows($dbres2);
$dbres3 = mysql_query("SELECT `id` FROM `[users]` WHERE `type`=3 AND `activated`=1");
$type3 = mysql_num_rows($dbres3);
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 ORDER BY attack DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
$power = round(($list->attack+$list->defence)/2+$list->clicks*5);
echo "- $list->login
($power Power) ";
}
echo " ";
?>
|
Beste Clans:
$select = mysql_query("SELECT * FROM `[clans]` ORDER BY clicks DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->name
(Owner: $list->owner) ";
}
echo " ";
?>
|
Nieuwste Leden:
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY signup DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->signup) ";
}
echo " ";
?>
|
Meeste recruits:
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY recruiter DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->recruiter) ";
}
echo " ";
?>
|
Meeste kliks:
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 ORDER BY clicks DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->clicks clicks) ";
}
echo " ";
?>
|
Meest geëerde speler:
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY honourpoints DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->honourpoints eerpunten)";
}
echo " ";
?>
|
Meeste bij cash:
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 ORDER BY cash DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->cash cash bij zich) ";
}
echo " ";
?>
|
Meest op bank:
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY bank DESC LIMIT 0,5");
echo "";
while($list = mysql_fetch_object($select)) {
echo "- $list->login
($list->bank op de bank)";
}
echo " ";
?>
|
$select = mysql_query("SELECT * FROM `[users]` WHERE type=1 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
Aantal drugsdealers: echo $type1; ?> |
|
$select = mysql_query("SELECT * FROM `[users]` WHERE type=2 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
Aantal wetenschappers: echo $type2; ?> |
|
$select = mysql_query("SELECT * FROM `[users]` WHERE type=3 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
Aantal politie agenten: echo $type3; ?> |
|
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 AND id != '0' ORDER BY signup DESC LIMIT 0,1");
$aantal = mysql_fetch_object($select);
?>
Nieuwste member: echo "login\">$aantal->login"; ?> |
|
$dbres = mysql_query("SELECT `cash` FROM `[users]` WHERE `level` > '0' AND `level` < '256'");
$cash = 0;
while($user1 = mysql_fetch_object($dbres))
$cash += $user1->cash;
$cash1 = number_format($cash,0);
?>
Totaal Cash: $ echo $cash1; ?> |
|
$dbres = mysql_query("SELECT `bank` FROM `[users]` WHERE `level` > '0' AND `level` < '256'");
$bank = 0;
while($user = mysql_fetch_object($dbres))
$bank += $user->bank;
$bank1 = number_format($bank,0);
?>
Totaal Bank: $ echo $bank1; ?> |
|
$select = mysql_query("SELECT * FROM `[users]`");
$members = mysql_num_rows($select);
$total1 = round($bank+$cash);
$total = number_format($total1,0);
$totalplayer = round($total1/$members);
$totalplayer = number_format($totalplayer,0);
?>
Totaal Bank: $ echo $total; ?> per speler: $ echo $totalplayer; ?> |
|
$select = mysql_query("SELECT * FROM `[users]`");
$member = mysql_num_rows($select);
$members = number_format($member,0);
?>
Totaal leden: echo $members; ?> |
|