Re: [v1] Updated Statistics Page
here it is for v2 am using oxidation code but i just convist it for the people who cant
<?php
include "globals.php";
$q=mysql_query("SELECT userid FROM users",$c);
$membs=mysql_num_rows($q);
$q=mysql_query("SELECT userid FROM users WHERE bankmoney>-1",$c);
$banks=mysql_num_rows($q);
$q=mysql_query("SELECT userid FROM users WHERE gender='Male'",$c);
$male=mysql_num_rows($q);
$q=mysql_query("SELECT userid FROM users WHERE gender='Female'",$c);
$fem=mysql_num_rows($q);
$total=0;
$q=mysql_query("SELECT money FROM users",$c);
while($r=mysql_fetch_array($q))
{
$total+=$r['money'];
}
$avg=(int) ($total/$membs);
$totalb=0;
$q=mysql_query("SELECT bankmoney FROM users WHERE bankmoney>-1",$c);
while($r=mysql_fetch_array($q))
{
$totalb+=$r['bankmoney'];
}
$avgb=(int) ($totalb/$banks);
$totalc=0;
$q=mysql_query("SELECT crystals FROM users",$c);
while($r=mysql_fetch_array($q))
{
$totalc+=$r['crystals'];
}
$totali=0;
$q=mysql_query("SELECT inv_qty FROM inventory",$c);
while($r=mysql_fetch_array($q))
{
$totali+=$r['inv_qty'];
}
$avgc=(int) ($totalc/$membs);
$q=mysql_query("SELECT mail_id FROM mail",$c);
$mail=mysql_num_rows($q);
$q=mysql_query("SELECT evID FROM events",$c);
$events=mysql_num_rows($q);
$nogender1=mysql_query("SELECT * FROM users WHERE gender=''",$c);
$nogender=mysql_num_rows($nogender1);
$maleperc=round($male/$membs*100).'%';
$femaleperc=round($fem/$membs*100).'%';
$nogenderperc=round($nogender/$membs*100).'%';
$highestdonator1=mysql_query("SELECT * FROM users ORDER BY donatordays DESC LIMIT 1;",$c);
$hd=mysql_fetch_array($highestdonator1);
print "<h3>Statistics Department</h3>
You walk through the statistics centre and stare at the boards.
<table width='90%' style='border:groove; border-color:chocolate;'><tr><th>Users</th><th>Houses</th><th><th>Cities</th></tr>
<tr><td>There are currently $membs members signed up
$male ($maleperc) males, $fem ($femaleperc) females and $nogender ($nogenderperc) multigenders.
There are ".mysql_num_rows(mysql_query("SELECT * FROM users WHERE donatordays>0",$c))." donators
";
if(mysql_num_rows($highestdonator1) != 0)
{
print "The highest current donator is {$hd['username']}
";
}
print "</td> <td>This how many members have amount of each house
";
$q=mysql_query("SELECT * FROM houses ORDER BY hPRICE,hWILL ASC",$c);
while($r=mysql_fetch_array($q))
{
$q3=mysql_num_rows(mysql_query("SELECT * FROM users WHERE maxwill={$r['hWILL']}",$c));
print "".$r['hNAME']." - $q3 users have it
";
}
print "..and ".mysql_num_rows(mysql_query("SELECT * FROM users WHERE maxwill<='100'",$c))." dont have a house.";
print "</td><td>";
$q=mysql_query("SELECT * FROM cities ORDER BY cityname ASC",$c);
while($r=mysql_fetch_array($q))
{
$q3=mysql_num_rows(mysql_query("SELECT * FROM users WHERE location={$r['cityid']}",$c));
$hmhi=round($q3/$membs*100).'%';
print "".$r['cityname']." - $q3 users have it ({$hmhi})
";
}
print "</td></tr>
<tr><th>Financial</th><th>Gangs</th><th>Mail/Events</th></tr>
<tr><td>
Amount of cash in circulation: \$".money_formatter($total,"").".
The average player has: \$".money_formatter($avg,"").".
Amount of cash in banks: \$".money_formatter($totalb,"").".
Amount of players with bank accounts: $banks
The average player has in their bank accnt: \$".money_formatter($avgb,"").".
Amount of crystals in circulation: ".money_formatter($totalc,"").".
The average player has: ".money_formatter($avgc,"")." crystals.</td> <td>";
$gangs=mysql_num_rows(mysql_query("SELECT gangID FROM gangs",$c));
$bg1=mysql_query("SELECT * FROM gangs ORDER BY gangRESPECT DESC LIMIT 1",$c);
$bg=mysql_fetch_array($bg1);
print "There are currently $gangs in circulation.
";
if(mysql_num_rows($bg1) != 0)
{
print "The best gang is {$bg['gangNAME']}
";
}
print "</td><td><u>Mails/Events</u>
".money_formatter($mail,"")." mails and ".money_formatter($events,"")." events have been sent.</td></tr>
<tr><th>Items</th><th> </th><th> </th></tr>
<tr><td>There are currently ".money_formatter($totali,"")." items in circulation.</td><td></td><td></td> </tr>
</table>
";
$h->endpage();
?>
