[v1] Updated Statistics Page

[oxidati0n]

This shows everything in your game, Males, females, donators, top donators, top gangs, how many people have a certain house, it all..

and it costs... NOTHING!

FREE TO ALL! Enjoy!

replace stats.php with this

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[John99]

Re: [v1] Updated Statistics Page

Nice :D +1 for atleast posting lol

[Godfather]

Re: [v1] Updated Statistics Page

new round here but nice one thats great for my game thanks

:-D+1

[KyleCrispy]

Re: [v1] Updated Statistics Page

i got to say my one is better tho and well all i need to add is the cities and the houses and mines the best

[Godfather]

Re: [v1] Updated Statistics Page

i know im late but +1 this is a great mod for my game thanks :-D

[Jawad]

Re: [v1] Updated Statistics Page

oxidation is one is the best for us if got your kyle thne post it here thanks 1+ for oxidation and 1+ for kyle when he posting his if wants too

[Jawad]

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();

?>

[Jawad]

Re: [v1] Updated Statistics Page

Sorry for wrong spelling guys lol :-D

[KyleCrispy]

Re: [v1] Updated Statistics Page

when i say mines better mines better! and go look on www.bornkillah.com if u dont trust me

[Z?v??]

Re: [v1] Updated Statistics Page

Jawadali, anyone can change the DBS headers and say it's converted. If you're going to take time to convert it, then why don't you convert the whole thing? :|

[oxidati0n]

Re: [v1] Updated Statistics Page

 

when i say mines better mines better! and go look on www.bornkillah.com if u dont trust me

1) That's a copy of my version just pimped out

2) I know for a fact you didn't do that, so stop trying to show off!

[Michael]

Re: [v1] Updated Statistics Page

Nice wee mod +1. Thats alot from me as i dont usually use free mods.Mostly pay for em. Also anyone i advise buying Oxidati0n's countries mod, works great and only $20

[-Matt-]

Re: [v1] Updated Statistics Page

nice mod +1

http://www.AWSurveys.com/HomeMain.cfm?RefID=matt2k6

[Godfather]

Re: [v1] Updated Statistics Page

nice one oxi +1!!!!

[Satans_Pimp]

Re: [v1] Updated Statistics Page

sorry but this is not converted right to v2

you need to change the :

mysql_num_rows====to ==$db->num_rows

you alson need to take out all the ,$c from all the $db->query lines

and mysql_fetch_array should be=$db->fetch_row

hope this helps you

 

here it is for v2 am using oxidation code but i just convist it for the people who cant

 

<?php

include "globals.php";

$q=$db->query("SELECT userid FROM users");

$membs=$db->num_rows($q);

$q=$db->query("SELECT userid FROM users WHERE bankmoney>-1");

$banks=$db->num_rows($q);

$q=$db->query("SELECT userid FROM users WHERE gender='Male'");

$male=$db->num_rows($q);

$q=$db->query("SELECT userid FROM users WHERE gender='Female'");

$fem=$db->num_rows($q);

$total=0;

$q=$db->query("SELECT money FROM users");

while($r=$db->etch_row($q))

{

$total+=$r['money'];

}

$avg=(int) ($total/$membs);

$totalb=0;

$q=$db->query("SELECT bankmoney FROM users WHERE bankmoney>-1");

while($r=$db->fetch_row($q))

{

$totalb+=$r['bankmoney'];

}

$avgb=(int) ($totalb/$banks);

$totalc=0;

$q=$db->query("SELECT crystals FROM users");

while($r=$db->fetch_row($q))

{

$totalc+=$r['crystals'];

}

$totali=0;

$q=$db->query("SELECT inv_qty FROM inventory");

while($r=$db->fetch_row($q))

{

$totali+=$r['inv_qty'];

}

$avgc=(int) ($totalc/$membs);

$q=$db->query("SELECT mail_id FROM mail");

$mail=$db->num_rows($q);

$q=$db->query("SELECT evID FROM events");

$events=$db->num_rows($q);

$nogender1=$db->query("SELECT * FROM users WHERE gender='');

$nogender=$db->num_rows($nogender1);

$maleperc=round($male/$membs*100).'%';

$femaleperc=round($fem/$membs*100).'%';

$nogenderperc=round($nogender/$membs*100).'%';

$highestdonator1=$db->query("SELECT * FROM users ORDER BY donatordays DESC LIMIT 1;");

$hd=$db->fetch_row($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 ".$db->num_rows($db->query("SELECT * FROM users WHERE donatordays>0"))." donators

";

if($db->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=$db->query("SELECT * FROM houses ORDER BY hPRICE,hWILL ASC");

while($r=$db->fetch_row($q))

{

$q3=$db->num_rows($db->query("SELECT * FROM users WHERE maxwill={$r['hWILL']}");

print "".$r['hNAME']." - $q3 users have it

";

}

print "..and ".$db->num_rows(mysql_query("SELECT * FROM users WHERE maxwill<='100'",$c))." dont have a house.";

print "</td><td>";

$q=$db->query("SELECT * FROM cities ORDER BY cityname ASC");

while($r=$db->fetch_row($q)

{

$q3=$db->num_rows($db->query("SELECT * FROM users WHERE location={$r['cityid']}");

$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=$db->num_rows($db->query("SELECT gangID FROM gangs",$c));

$bg1=mysql_query("SELECT * FROM gangs ORDER BY gangRESPECT DESC LIMIT 1");

$bg=$db->fetch_row($bg1);

print "There are currently $gangs in circulation.

";

if($db->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();

?>

 

[Note i didn't make this mo]

Re: [v1] Updated Statistics Page

lol good one Oxi Nice I'll Use That One |o| :-P

[HITMAN 17]

Re: [v1] Updated Statistics Page

can anyone make it work

Parse error: syntax error, unexpected T_STRING in /home/rydog/public_html/stats.php on line 50

[Danny]

Re: [v1] Updated Statistics Page

TRY

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[HITMAN 17]

Re: [v1] Updated Statistics Page

 

TRY

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

thnx danny it works +1

[dementor]

Re: [v1] Updated Statistics Page

nice mod

i got 1 error

but im guesing thats cause no one has a bank yet

[3XTR3M3]

Re: [v1] Updated Statistics Page

works great oxi

[hrabik1]

Re: [v1] Updated Statistics Page

+1