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 `forum`");
$id = mysql_num_rows($dbres);
$id = number_format($id,0);
?>
$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);
?>
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=-1");
$membersban = mysql_num_rows($dbres);
?>
Verbannen leden: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=5");
$membersban = mysql_num_rows($dbres);
?>
Betaalde leden: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=1000");
$membersban = mysql_num_rows($dbres);
?>
Administrator's: |
echo $membersban; ?> |
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `hulpadmin`=1");
$membersban = mysql_num_rows($dbres);
?>
$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);
?>
$select = mysql_query("SELECT * FROM `[users]` WHERE type=1 AND activated=1");
$admirals = mysql_num_rows($select);
$select = mysql_query("SELECT * FROM `[users]` WHERE type=2 AND activated=1");
$mafiabosses = mysql_num_rows($select);
$select = mysql_query("SELECT * FROM `[users]` WHERE type=3 AND activated=1");
$agents = mysql_num_rows($select);
?>
Clans |
Naam |
Owner |
Leden |
Recruiter? |
$select = mysql_query("SELECT * FROM `[clans]` ORDER BY started LIMIT 0,50");
echo " ";
while($list = mysql_fetch_object($select)) {
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='$list->name'");
$nummembers = mysql_num_rows($dbres);
$recruiting = ($list->recruiting == 1) ? "Ja" : "Nee";
echo "
$list->name |
$list->owner |
$nummembers |
$recruiting | ";
}
echo "";
?>
$dbres = mysql_query("SELECT `attack` FROM `[clans]`");
$totalcrews = mysql_num_rows($dbres);
$crews = round($totalcrews-1);
?>
| |
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 | ";
}
?>
Meeste Refferals |
$select = mysql_query("SELECT * FROM `[users]` WHERE `recruiters` > 0 ORDER BY recruiters DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
echo "
$list->login |
$list->recruiters | ";
}
?>
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 clicks |
$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; ?> |
|