Site Statistieken |
$select = mysql_query("SELECT * FROM `[users]`");
$member = mysql_num_rows($select);
$members = number_format($member,0);
?>
Totaal leden: |
echo $members; ?> |
$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 contant: |
€ 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);
?>
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 geld: |
€ echo $total; ?> (€ echo $totalplayer; ?> per
speler) |
$dbres = mysql_query("SELECT * FROM `[auto]`");
$id = mysql_num_rows($dbres);
$id2 = number_format($id,0);
?>
Auto's in het spel: |
echo $id2; ?> |
$dbres = mysql_query("SELECT * FROM `[messages]`");
$messages = mysql_num_rows($dbres);
$messages = number_format($messages,0);
?>
Totaal berichten verstuurd: |
echo $messages; ?> |
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `level` < '0'");
$dead = mysql_num_rows($dbres);
$percdead = round($dead/$members*100);
?>
Verbannen leden: |
echo $dead; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `vipdagen`>0");
$membersban = mysql_num_rows($dbres);
?>
Betaalde leden: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=255");
$membersban = mysql_num_rows($dbres);
?>
Administrator's: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `hulpadmin`=1");
$membersban = mysql_num_rows($dbres);
?>
Hulp admins: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `level` > '0'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Levende leden: |
echo $alive4; ?> |
Clans |
Naam |
Owner |
Leden |
$select = mysql_query("SELECT * FROM `[clans]` ORDER BY started LIMIT 0,50");
while($list = mysql_fetch_object($select)) {
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='$list->name'");
$nummembers = mysql_num_rows($dbres);
echo "
$list->name |
$list->owner |
$nummembers | ";
}
?>
| |
Beste spelers |
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 AND level<255 AND level>-1 ORDER BY round((attack+defence)/2+clicks*5) DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
$power = round(($list->attack+$list->defence)/2+$list->clicks*5);
$power2 = number_format($power,0);
echo "$list->login | Power: $power2 | ";
}
?>
Rijkste spelers |
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 AND level<255 ORDER BY round(cash+bank) DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
$money = round($list->cash+$list->bank);
$money2 = number_format($money,0);
echo "$list->login | € $money2 | ";
}
?>
Nieuwste leden |
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY signup DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
echo "
$list->login |
$list->signup | ";
}
?>
Meeste junkies |
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY clicks DESC LIMIT 0,5");
while($list = mysql_fetch_object($select)) {
echo "
$list->login |
$list->clicks | ";
}
?>
Auto's in het spel |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '1'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Mini Cooper: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '2'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Volkswagen Polo: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '3'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Opel Astra: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '4'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Mitsubishi Eclipse: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '5'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
BMW Z3: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '6'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Mercedes Vision CLS: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '7'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Porsche Carrera GT: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '8'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Lostus Elise: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '9'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Lamborgini: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]` WHERE `soort` = '10'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
Ferrari Enzo: |
echo $alive4; ?> |
$dbres = mysql_query("SELECT * FROM `[auto]`");
$id = mysql_num_rows($dbres);
$id2 = number_format($id,0);
?>
Totaal aantal auto's in het spel: |
echo $id2; ?> |
|