PHP Scripts - OdinMS - Statistics

SmartyX · Jul 6, 2008

Hey,

ive some small scripts for you to have more statistics.
You can insert them in any cms you like if you know some php and html.

These scripts show you:
Accounts
Characters
- Male
- Female
Guilds
Guildmembers
Guildboardthreads
Guildboardposts
Beginner
Warrior
Magician
Bowman
Thief
Banned Hackers
Quests in progress
Quests absolved
GM Commands
Famed
Friends
Level
Fame
EXP
Meso
Equipment
Items
HP
MP
STR
DEX
INT
LUK
AP
SP
Reborns

Have fun.

$result = mysql_query("SELECT * FROM accounts", $db);// Account section
$num_rows = mysql_num_rows($result);
$result2 = mysql_query("SELECT * FROM characters", $db);// Character section
$num_rowsc = mysql_num_rows($result2);
$result2y = mysql_query("SELECT * FROM characters WHERE gender = 0", $db);// Character section
$num_rowsc2 = mysql_num_rows($result2y);
$result2x = mysql_query("SELECT * FROM characters WHERE gender = 1", $db);// Character section
$num_rowsc3 = mysql_num_rows($result2x);
$result15 = mysql_query("SELECT * FROM guilds", $db);// Character section
$num_rowsg = mysql_num_rows($result15);
$result18 = mysql_query("SELECT * FROM characters WHERE guildid > 0", $db);// Character section
$num_rowsg4 = mysql_num_rows($result18);
$result16 = mysql_query("SELECT * FROM bbs_threads", $db);// Character section
$num_rowsg2 = mysql_num_rows($result16);
$result17 = mysql_query("SELECT * FROM bbs_replies", $db);// Character section
$num_rowsg3 = mysql_num_rows($result17);
$result3 = mysql_query("SELECT * FROM channelconfig", $db);// Channel section
$num_rowsd = mysql_num_rows($result3);
$result4 = mysql_query("SELECT * FROM macbans", $db);// Account section
$num_rowsb = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM accounts where loggedin = 2", $db);// Account section
$num_rowsl = mysql_num_rows($result5);
$result6 = mysql_query("SELECT * FROM characters where job = 000", $db);// Account section
$num_rows1 = mysql_num_rows($result6);
$result6 = mysql_query("SELECT * FROM characters where job = 100 or job = 110 or job = 120 or job = 130 or job = 111 or job = 121 or job = 131 or job = 112 or job = 122 or job = 132", $db);// Account section
$num_rows2 = mysql_num_rows($result6);
$result7 = mysql_query("SELECT * FROM characters where job = 200 or job = 210 or job = 220 or job = 230 or job = 211 or job = 221 or job = 231 or job = 212 or job = 222 or job = 232", $db);// Account section
$num_rows3 = mysql_num_rows($result7);
$result8 = mysql_query("SELECT * FROM characters where job = 300 or job = 310 or job = 320 or job = 330 or job = 311 or job = 321 or job = 331 or job = 312 or job = 322 or job = 332", $db);// Account section
$num_rows4 = mysql_num_rows($result8);
$result9 = mysql_query("SELECT * FROM characters where job = 400 or job = 410 or job = 420 or job = 430 or job = 411 or job = 421 or job = 431 or job = 412 or job = 422 or job = 432", $db);// Account section
$num_rows5 = mysql_num_rows($result9);
$result10 = mysql_query("SELECT * FROM queststatus where status = 2", $db);// Account section
$num_rows6 = mysql_num_rows($result10);
$result11 = mysql_query("SELECT * FROM queststatus where status = 1", $db);// Account section
$num_rows7 = mysql_num_rows($result11);
$result12 = mysql_query("SELECT * FROM gmlog", $db);// Account section
$num_rows8 = mysql_num_rows($result12);
$result13 = mysql_query("SELECT * FROM famelog", $db);// Account section
$num_rows9 = mysql_num_rows($result13);
$result14 = mysql_query("SELECT * FROM buddies", $db);// Account section
$num_rows10 = mysql_num_rows($result14);
$query = mysql_query("SELECT level FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query)){
$LevelVonAllen = $LevelVonAllen + $row[level];
}
$query2 = mysql_query("SELECT fame FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query2)){
$FameVonAllen = $FameVonAllen + $row[fame];
}
$query3 = mysql_query("SELECT exp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query3)){
$ExpVonAllen = $ExpVonAllen + $row[exp];
}
$query4 = mysql_query("SELECT meso FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query4)){
$MesoVonAllen = $MesoVonAllen + $row[meso];
}
$result21 = mysql_query("SELECT * FROM inventoryequipment", $db);// Account section
$num_rows11 = mysql_num_rows($result21);
$queryx = mysql_query("SELECT quantity FROM inventoryitems", $db);// Account section
while($row = mysql_fetch_array($queryx)){
$ItemsVonAllen = $ItemsVonAllen + $row[quantity];
}
$query5 = mysql_query("SELECT dex FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query5)){
$DexVonAllen = $DexVonAllen + $row[dex];
}
$query6 = mysql_query("SELECT str FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query6)){
$StrVonAllen = $StrVonAllen + $row[str];
}
$query7 = mysql_query("SELECT `int` FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query7)){
$IntVonAllen = $IntVonAllen + $row['int'];
}
$query8 = mysql_query("SELECT luk FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query8)){
$LukVonAllen = $LukVonAllen + $row[luk];
}
$query9 = mysql_query("SELECT rebirth FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query9)){
$RebVonAllen = $RebVonAllen + $row[rebirth];
}
$query10 = mysql_query("SELECT ap FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query10)){
$ApVonAllen = $ApVonAllen + $row[ap];
}
$query11 = mysql_query("SELECT sp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query11)){
$SpVonAllen = $SpVonAllen + $row[sp];
}
$query12 = mysql_query("SELECT maxhp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query12)){
$HpVonAllen = $HpVonAllen + $row[maxhp];
}
$query13 = mysql_query("SELECT maxmp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query13)){
$MpVonAllen = $MpVonAllen + $row[maxmp];
}

Code:

<b>'.number_format($num_rows, 0, ',', '.').'</b> Accounts<br>
<b>'.number_format($num_rowsc, 0, ',', '.').'</b> Characters<br>
<b>- '.number_format($num_rowsc2, 0, ',', '.').'</b> Male<br>
<b>- '.number_format($num_rowsc3, 0, ',', '.').'</b> Female<br><br>
<b>'.number_format($num_rowsg, 0, ',', '.').'</b> Guilds<br>
<b>'.number_format($num_rowsg4.'</b> Guildmembers<br>
<b>'.number_format($num_rowsg2, 0, ',', '.'), 0, ',', '.').'</b> Guildboardthreads<br>
<b>'.number_format($num_rowsg3, 0, ',', '.').'</b> Guildboardposts<br><br>
<b>'.number_format($num_rows1, 0, ',', '.').'</b> Beginner<br>
<b>'.number_format($num_rows2, 0, ',', '.').'</b> Warrior<br>
<b>'.number_format($num_rows3, 0, ',', '.').'</b> Magician<br>
<b>'.number_format($num_rows4, 0, ',', '.').'</b> Bowman<br>
<b>'.number_format($num_rows5, 0, ',', '.').'</b> Thief<br><br>
<b>'.number_format($num_rowsb, 0, ',', '.').'</b> Banned Hackers<br><br>
  <b>'.number_format($num_rows6, 0, ',', '.').'</b> Quests in progress<br>
<b>'.number_format($num_rows7, 0, ',', '.').'</b> Quests absolved<br>
<b>'.number_format($num_rows8, 0, ',', '.').'</b> GM Commands<br>
<b>'.number_format($num_rows9, 0, ',', '.').'</b> Famed<br>
<b>'.number_format(($num_rows10 * 2), 0, ',', '.').'</b> Friends<br><br>
<b>'.number_format($LevelVonAllen, 0, ',', '.').'</b> Level<br>
<b>'.number_format($FameVonAllen, 0, ',', '.').'</b> Fame<br>
<b>'.number_format($ExpVonAllen, 0, ',', '.').'</b> EXP<br>
<b>'.number_format($MesoVonAllen, 0, ',', '.').'</b> Meso<br>
<b>'.number_format($num_rows11, 0, ',', '.').'</b> Equipment<br>
<b>'.number_format($ItemsVonAllen, 0, ',', '.').'</b> Items<br><br>
<b>'.number_format($HpVonAllen, 0, ',', '.').'</b> HP<br>
<b>'.number_format($MpVonAllen, 0, ',', '.').'</b> MP<br>
<b>'.number_format($StrVonAllen, 0, ',', '.').'</b> STR<br>
<b>'.number_format($DexVonAllen, 0, ',', '.').'</b> DEX<br>
<b>'.number_format($IntVonAllen, 0, ',', '.').'</b> INT<br>
<b>'.number_format($LukVonAllen, 0, ',', '.').'</b> LUK<br>
<b>'.number_format($ApVonAllen, 0, ',', '.').'</b> AP<br>
<b>'.number_format($SpVonAllen, 0, ',', '.').'</b> SP<br><br>
<b>'.number_format($RebVonAllen, 0, ',', '.').'</b> Reborns<br><br>

braveboy · Jul 6, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

good

iMurad · Jul 8, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

braveboy said:
good

Oh yea, it's "good", but your spam isn't.

@Threadstarter Nice release ^^ I'm going to use it.

Giro · Jul 8, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

Nice release, This is most of the sql table itself.

farouq · Jul 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

lawl nice relese

GalaxyJoey · Jul 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

live demo =D?

SmartyX · Jul 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

To view the content, you need to sign in or register

Just in english for sure.

sekum · Jul 11, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

how to use this scripts i put it in the same php?

shajal · Aug 7, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

i dont know how to do it can anyone tell me how to edit it.

SaintsIan · Aug 7, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

Just use <?php
then paste the first codes
then use echo '
paste the second close it then done, for simple ones...

candyman3435 · Aug 7, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

lol nice release

dudeman10 · Aug 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

this is what i put.

Code:

<?php
$result = mysql_query("SELECT * FROM accounts", $db);// Account section
$num_rows = mysql_num_rows($result);
$result2 = mysql_query("SELECT * FROM characters", $db);// Character section
$num_rowsc = mysql_num_rows($result2);
$result2y = mysql_query("SELECT * FROM characters WHERE gender = 0", $db);// Character section
$num_rowsc2 = mysql_num_rows($result2y);
$result2x = mysql_query("SELECT * FROM characters WHERE gender = 1", $db);// Character section
$num_rowsc3 = mysql_num_rows($result2x);
$result15 = mysql_query("SELECT * FROM guilds", $db);// Character section
$num_rowsg = mysql_num_rows($result15);
$result18 = mysql_query("SELECT * FROM characters WHERE guildid > 0", $db);// Character section
$num_rowsg4 = mysql_num_rows($result18);
$result16 = mysql_query("SELECT * FROM bbs_threads", $db);// Character section
$num_rowsg2 = mysql_num_rows($result16);
$result17 = mysql_query("SELECT * FROM bbs_replies", $db);// Character section
$num_rowsg3 = mysql_num_rows($result17);
$result3 = mysql_query("SELECT * FROM channelconfig", $db);// Channel section
$num_rowsd = mysql_num_rows($result3);
$result4 = mysql_query("SELECT * FROM macbans", $db);// Account section
$num_rowsb = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM accounts where loggedin = 2", $db);// Account section
$num_rowsl = mysql_num_rows($result5);
$result6 = mysql_query("SELECT * FROM characters where job = 000", $db);// Account section
$num_rows1 = mysql_num_rows($result6);
$result6 = mysql_query("SELECT * FROM characters where job = 100 or job = 110 or job = 120 or job = 130 or job = 111 or job = 121 or job = 131 or job = 112 or job = 122 or job = 132", $db);// Account section
$num_rows2 = mysql_num_rows($result6);
$result7 = mysql_query("SELECT * FROM characters where job = 200 or job = 210 or job = 220 or job = 230 or job = 211 or job = 221 or job = 231 or job = 212 or job = 222 or job = 232", $db);// Account section
$num_rows3 = mysql_num_rows($result7);
$result8 = mysql_query("SELECT * FROM characters where job = 300 or job = 310 or job = 320 or job = 330 or job = 311 or job = 321 or job = 331 or job = 312 or job = 322 or job = 332", $db);// Account section
$num_rows4 = mysql_num_rows($result8);
$result9 = mysql_query("SELECT * FROM characters where job = 400 or job = 410 or job = 420 or job = 430 or job = 411 or job = 421 or job = 431 or job = 412 or job = 422 or job = 432", $db);// Account section
$num_rows5 = mysql_num_rows($result9);
$result10 = mysql_query("SELECT * FROM queststatus where status = 2", $db);// Account section
$num_rows6 = mysql_num_rows($result10);
$result11 = mysql_query("SELECT * FROM queststatus where status = 1", $db);// Account section
$num_rows7 = mysql_num_rows($result11);
$result12 = mysql_query("SELECT * FROM gmlog", $db);// Account section
$num_rows8 = mysql_num_rows($result12);
$result13 = mysql_query("SELECT * FROM famelog", $db);// Account section
$num_rows9 = mysql_num_rows($result13);
$result14 = mysql_query("SELECT * FROM buddies", $db);// Account section
$num_rows10 = mysql_num_rows($result14);
$query = mysql_query("SELECT level FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query)){
$LevelVonAllen = $LevelVonAllen + $row[level];
}
$query2 = mysql_query("SELECT fame FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query2)){
$FameVonAllen = $FameVonAllen + $row[fame];
}
$query3 = mysql_query("SELECT exp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query3)){
$ExpVonAllen = $ExpVonAllen + $row[exp];
}
$query4 = mysql_query("SELECT meso FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query4)){
$MesoVonAllen = $MesoVonAllen + $row[meso];
}
$result21 = mysql_query("SELECT * FROM inventoryequipment", $db);// Account section
$num_rows11 = mysql_num_rows($result21);
$queryx = mysql_query("SELECT quantity FROM inventoryitems", $db);// Account section
while($row = mysql_fetch_array($queryx)){
$ItemsVonAllen = $ItemsVonAllen + $row[quantity];
}
$query5 = mysql_query("SELECT dex FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query5)){
$DexVonAllen = $DexVonAllen + $row[dex];
}
$query6 = mysql_query("SELECT str FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query6)){
$StrVonAllen = $StrVonAllen + $row[str];
}
$query7 = mysql_query("SELECT `int` FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query7)){
$IntVonAllen = $IntVonAllen + $row['int'];
}
$query8 = mysql_query("SELECT luk FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query8)){
$LukVonAllen = $LukVonAllen + $row[luk];
}
$query9 = mysql_query("SELECT rebirth FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query9)){
$RebVonAllen = $RebVonAllen + $row[rebirth];
}
$query10 = mysql_query("SELECT ap FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query10)){
$ApVonAllen = $ApVonAllen + $row[ap];
}
$query11 = mysql_query("SELECT sp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query11)){
$SpVonAllen = $SpVonAllen + $row[sp];
}
$query12 = mysql_query("SELECT maxhp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query12)){
$HpVonAllen = $HpVonAllen + $row[maxhp];
}
$query13 = mysql_query("SELECT maxmp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query13)){
$MpVonAllen = $MpVonAllen + $row[maxmp];
} 
		echo '<b>'.number_format($num_rows, 0, ',', '.').'</b> Accounts<br>
<b>'.number_format($num_rowsc, 0, ',', '.').'</b> Characters<br>
<b>- '.number_format($num_rowsc2, 0, ',', '.').'</b> Male<br>
<b>- '.number_format($num_rowsc3, 0, ',', '.').'</b> Female<br><br>
<b>'.number_format($num_rowsg, 0, ',', '.').'</b> Guilds<br>
<b>'.number_format($num_rowsg4.'</b> Guildmembers<br>
<b>'.number_format($num_rowsg2, 0, ',', '.'), 0, ',', '.').'</b> Guildboardthreads<br>
<b>'.number_format($num_rowsg3, 0, ',', '.').'</b> Guildboardposts<br><br>
<b>'.number_format($num_rows1, 0, ',', '.').'</b> Beginner<br>
<b>'.number_format($num_rows2, 0, ',', '.').'</b> Warrior<br>
<b>'.number_format($num_rows3, 0, ',', '.').'</b> Magician<br>
<b>'.number_format($num_rows4, 0, ',', '.').'</b> Bowman<br>
<b>'.number_format($num_rows5, 0, ',', '.').'</b> Thief<br><br>
<b>'.number_format($num_rowsb, 0, ',', '.').'</b> Banned Hackers<br><br>
<b>'.number_format($num_rows6, 0, ',', '.').'</b> Quests in progress<br>
<b>'.number_format($num_rows7, 0, ',', '.').'</b> Quests absolved<br>
<b>'.number_format($num_rows8, 0, ',', '.').'</b> GM Commands<br>
<b>'.number_format($num_rows9, 0, ',', '.').'</b> Famed<br>
<b>'.number_format(($num_rows10 * 2), 0, ',', '.').'</b> Friends<br><br>
<b>'.number_format($LevelVonAllen, 0, ',', '.').'</b> Level<br>
<b>'.number_format($FameVonAllen, 0, ',', '.').'</b> Fame<br>
<b>'.number_format($ExpVonAllen, 0, ',', '.').'</b> EXP<br>
<b>'.number_format($MesoVonAllen, 0, ',', '.').'</b> Meso<br>
<b>'.number_format($num_rows11, 0, ',', '.').'</b> Equipment<br>
<b>'.number_format($ItemsVonAllen, 0, ',', '.').'</b> Items<br><br>
<b>'.number_format($HpVonAllen, 0, ',', '.').'</b> HP<br>
<b>'.number_format($MpVonAllen, 0, ',', '.').'</b> MP<br>
<b>'.number_format($StrVonAllen, 0, ',', '.').'</b> STR<br>
<b>'.number_format($DexVonAllen, 0, ',', '.').'</b> DEX<br>
<b>'.number_format($IntVonAllen, 0, ',', '.').'</b> INT<br>
<b>'.number_format($LukVonAllen, 0, ',', '.').'</b> LUK<br>
<b>'.number_format($ApVonAllen, 0, ',', '.').'</b> AP<br>
<b>'.number_format($SpVonAllen, 0, ',', '.').'</b> SP<br><br>
<b>'.number_format($RebVonAllen, 0, ',', '.').'</b> Reborns<br><br>
?>

Says

Code:

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in C:\Documents and Settings\Got Game\Desktop\xampp\htdocs\MScp\ranking2.php on line 138

Parse error: syntax error, unexpected '<' in C:\Documents and Settings\Got Game\Desktop\xampp\htdocs\MScp\ranking2.php on line 138

xcelinex33 · Aug 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

Lol nice release.

And isn't statistics a subject in school? XD

dudeman10 · Aug 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

helpers me with my post plz =[

XenZy · Aug 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

xcelinex33 said:
Lol nice release.

And isn't statistics a subject in school? XD

It is, but i believe its also the correct term for this.

holthelper · Aug 9, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

sorry but am i the only one that sees this as a pointless post. anyone that can make a simple query can do this basicly...

R0flC0pter · Sep 15, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

Nice release.

Psychopath · Sep 16, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

how can i add this into s0wh4ts cms ?

MSOlympics · Sep 16, 2008

Thanks lol. I don't really know those php html kinda stuff hehe..

DoxDos · Sep 17, 2008

Re: [Release] PHP Scripts - OdinMS - Statistics

dudeman10 said:

this is what i put.

Code:

<?php
$result = mysql_query("SELECT * FROM accounts", $db);// Account section
$num_rows = mysql_num_rows($result);
$result2 = mysql_query("SELECT * FROM characters", $db);// Character section
$num_rowsc = mysql_num_rows($result2);
$result2y = mysql_query("SELECT * FROM characters WHERE gender = 0", $db);// Character section
$num_rowsc2 = mysql_num_rows($result2y);
$result2x = mysql_query("SELECT * FROM characters WHERE gender = 1", $db);// Character section
$num_rowsc3 = mysql_num_rows($result2x);
$result15 = mysql_query("SELECT * FROM guilds", $db);// Character section
$num_rowsg = mysql_num_rows($result15);
$result18 = mysql_query("SELECT * FROM characters WHERE guildid > 0", $db);// Character section
$num_rowsg4 = mysql_num_rows($result18);
$result16 = mysql_query("SELECT * FROM bbs_threads", $db);// Character section
$num_rowsg2 = mysql_num_rows($result16);
$result17 = mysql_query("SELECT * FROM bbs_replies", $db);// Character section
$num_rowsg3 = mysql_num_rows($result17);
$result3 = mysql_query("SELECT * FROM channelconfig", $db);// Channel section
$num_rowsd = mysql_num_rows($result3);
$result4 = mysql_query("SELECT * FROM macbans", $db);// Account section
$num_rowsb = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM accounts where loggedin = 2", $db);// Account section
$num_rowsl = mysql_num_rows($result5);
$result6 = mysql_query("SELECT * FROM characters where job = 000", $db);// Account section
$num_rows1 = mysql_num_rows($result6);
$result6 = mysql_query("SELECT * FROM characters where job = 100 or job = 110 or job = 120 or job = 130 or job = 111 or job = 121 or job = 131 or job = 112 or job = 122 or job = 132", $db);// Account section
$num_rows2 = mysql_num_rows($result6);
$result7 = mysql_query("SELECT * FROM characters where job = 200 or job = 210 or job = 220 or job = 230 or job = 211 or job = 221 or job = 231 or job = 212 or job = 222 or job = 232", $db);// Account section
$num_rows3 = mysql_num_rows($result7);
$result8 = mysql_query("SELECT * FROM characters where job = 300 or job = 310 or job = 320 or job = 330 or job = 311 or job = 321 or job = 331 or job = 312 or job = 322 or job = 332", $db);// Account section
$num_rows4 = mysql_num_rows($result8);
$result9 = mysql_query("SELECT * FROM characters where job = 400 or job = 410 or job = 420 or job = 430 or job = 411 or job = 421 or job = 431 or job = 412 or job = 422 or job = 432", $db);// Account section
$num_rows5 = mysql_num_rows($result9);
$result10 = mysql_query("SELECT * FROM queststatus where status = 2", $db);// Account section
$num_rows6 = mysql_num_rows($result10);
$result11 = mysql_query("SELECT * FROM queststatus where status = 1", $db);// Account section
$num_rows7 = mysql_num_rows($result11);
$result12 = mysql_query("SELECT * FROM gmlog", $db);// Account section
$num_rows8 = mysql_num_rows($result12);
$result13 = mysql_query("SELECT * FROM famelog", $db);// Account section
$num_rows9 = mysql_num_rows($result13);
$result14 = mysql_query("SELECT * FROM buddies", $db);// Account section
$num_rows10 = mysql_num_rows($result14);
$query = mysql_query("SELECT level FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query)){
$LevelVonAllen = $LevelVonAllen + $row[level];
}
$query2 = mysql_query("SELECT fame FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query2)){
$FameVonAllen = $FameVonAllen + $row[fame];
}
$query3 = mysql_query("SELECT exp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query3)){
$ExpVonAllen = $ExpVonAllen + $row[exp];
}
$query4 = mysql_query("SELECT meso FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query4)){
$MesoVonAllen = $MesoVonAllen + $row[meso];
}
$result21 = mysql_query("SELECT * FROM inventoryequipment", $db);// Account section
$num_rows11 = mysql_num_rows($result21);
$queryx = mysql_query("SELECT quantity FROM inventoryitems", $db);// Account section
while($row = mysql_fetch_array($queryx)){
$ItemsVonAllen = $ItemsVonAllen + $row[quantity];
}
$query5 = mysql_query("SELECT dex FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query5)){
$DexVonAllen = $DexVonAllen + $row[dex];
}
$query6 = mysql_query("SELECT str FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query6)){
$StrVonAllen = $StrVonAllen + $row[str];
}
$query7 = mysql_query("SELECT `int` FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query7)){
$IntVonAllen = $IntVonAllen + $row['int'];
}
$query8 = mysql_query("SELECT luk FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query8)){
$LukVonAllen = $LukVonAllen + $row[luk];
}
$query9 = mysql_query("SELECT rebirth FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query9)){
$RebVonAllen = $RebVonAllen + $row[rebirth];
}
$query10 = mysql_query("SELECT ap FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query10)){
$ApVonAllen = $ApVonAllen + $row[ap];
}
$query11 = mysql_query("SELECT sp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query11)){
$SpVonAllen = $SpVonAllen + $row[sp];
}
$query12 = mysql_query("SELECT maxhp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query12)){
$HpVonAllen = $HpVonAllen + $row[maxhp];
}
$query13 = mysql_query("SELECT maxmp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query13)){
$MpVonAllen = $MpVonAllen + $row[maxmp];
} 
		echo '<b>'.number_format($num_rows, 0, ',', '.').'</b> Accounts<br>
<b>'.number_format($num_rowsc, 0, ',', '.').'</b> Characters<br>
<b>- '.number_format($num_rowsc2, 0, ',', '.').'</b> Male<br>
<b>- '.number_format($num_rowsc3, 0, ',', '.').'</b> Female<br><br>
<b>'.number_format($num_rowsg, 0, ',', '.').'</b> Guilds<br>
<b>'.number_format($num_rowsg4.'</b> Guildmembers<br>
<b>'.number_format($num_rowsg2, 0, ',', '.'), 0, ',', '.').'</b> Guildboardthreads<br>
<b>'.number_format($num_rowsg3, 0, ',', '.').'</b> Guildboardposts<br><br>
<b>'.number_format($num_rows1, 0, ',', '.').'</b> Beginner<br>
<b>'.number_format($num_rows2, 0, ',', '.').'</b> Warrior<br>
<b>'.number_format($num_rows3, 0, ',', '.').'</b> Magician<br>
<b>'.number_format($num_rows4, 0, ',', '.').'</b> Bowman<br>
<b>'.number_format($num_rows5, 0, ',', '.').'</b> Thief<br><br>
<b>'.number_format($num_rowsb, 0, ',', '.').'</b> Banned Hackers<br><br>
<b>'.number_format($num_rows6, 0, ',', '.').'</b> Quests in progress<br>
<b>'.number_format($num_rows7, 0, ',', '.').'</b> Quests absolved<br>
<b>'.number_format($num_rows8, 0, ',', '.').'</b> GM Commands<br>
<b>'.number_format($num_rows9, 0, ',', '.').'</b> Famed<br>
<b>'.number_format(($num_rows10 * 2), 0, ',', '.').'</b> Friends<br><br>
<b>'.number_format($LevelVonAllen, 0, ',', '.').'</b> Level<br>
<b>'.number_format($FameVonAllen, 0, ',', '.').'</b> Fame<br>
<b>'.number_format($ExpVonAllen, 0, ',', '.').'</b> EXP<br>
<b>'.number_format($MesoVonAllen, 0, ',', '.').'</b> Meso<br>
<b>'.number_format($num_rows11, 0, ',', '.').'</b> Equipment<br>
<b>'.number_format($ItemsVonAllen, 0, ',', '.').'</b> Items<br><br>
<b>'.number_format($HpVonAllen, 0, ',', '.').'</b> HP<br>
<b>'.number_format($MpVonAllen, 0, ',', '.').'</b> MP<br>
<b>'.number_format($StrVonAllen, 0, ',', '.').'</b> STR<br>
<b>'.number_format($DexVonAllen, 0, ',', '.').'</b> DEX<br>
<b>'.number_format($IntVonAllen, 0, ',', '.').'</b> INT<br>
<b>'.number_format($LukVonAllen, 0, ',', '.').'</b> LUK<br>
<b>'.number_format($ApVonAllen, 0, ',', '.').'</b> AP<br>
<b>'.number_format($SpVonAllen, 0, ',', '.').'</b> SP<br><br>
<b>'.number_format($RebVonAllen, 0, ',', '.').'</b> Reborns<br><br>
?>

Says

Code:

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in C:\Documents and Settings\Got Game\Desktop\xampp\htdocs\MScp\ranking2.php on line 138

Parse error: syntax error, unexpected '<' in C:\Documents and Settings\Got Game\Desktop\xampp\htdocs\MScp\ranking2.php on line 138

replace with that <_<

Code:

<?php
$result = mysql_query("SELECT * FROM accounts", $db);// Account section
$num_rows = mysql_num_rows($result);
$result2 = mysql_query("SELECT * FROM characters", $db);// Character section
$num_rowsc = mysql_num_rows($result2);
$result2y = mysql_query("SELECT * FROM characters WHERE gender = 0", $db);// Character section
$num_rowsc2 = mysql_num_rows($result2y);
$result2x = mysql_query("SELECT * FROM characters WHERE gender = 1", $db);// Character section
$num_rowsc3 = mysql_num_rows($result2x);
$result15 = mysql_query("SELECT * FROM guilds", $db);// Character section
$num_rowsg = mysql_num_rows($result15);
$result18 = mysql_query("SELECT * FROM characters WHERE guildid > 0", $db);// Character section
$num_rowsg4 = mysql_num_rows($result18);
$result16 = mysql_query("SELECT * FROM bbs_threads", $db);// Character section
$num_rowsg2 = mysql_num_rows($result16);
$result17 = mysql_query("SELECT * FROM bbs_replies", $db);// Character section
$num_rowsg3 = mysql_num_rows($result17);
$result3 = mysql_query("SELECT * FROM channelconfig", $db);// Channel section
$num_rowsd = mysql_num_rows($result3);
$result4 = mysql_query("SELECT * FROM macbans", $db);// Account section
$num_rowsb = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM accounts where loggedin = 2", $db);// Account section
$num_rowsl = mysql_num_rows($result5);
$result6 = mysql_query("SELECT * FROM characters where job = 000", $db);// Account section
$num_rows1 = mysql_num_rows($result6);
$result6 = mysql_query("SELECT * FROM characters where job = 100 or job = 110 or job = 120 or job = 130 or job = 111 or job = 121 or job = 131 or job = 112 or job = 122 or job = 132", $db);// Account section
$num_rows2 = mysql_num_rows($result6);
$result7 = mysql_query("SELECT * FROM characters where job = 200 or job = 210 or job = 220 or job = 230 or job = 211 or job = 221 or job = 231 or job = 212 or job = 222 or job = 232", $db);// Account section
$num_rows3 = mysql_num_rows($result7);
$result8 = mysql_query("SELECT * FROM characters where job = 300 or job = 310 or job = 320 or job = 330 or job = 311 or job = 321 or job = 331 or job = 312 or job = 322 or job = 332", $db);// Account section
$num_rows4 = mysql_num_rows($result8);
$result9 = mysql_query("SELECT * FROM characters where job = 400 or job = 410 or job = 420 or job = 430 or job = 411 or job = 421 or job = 431 or job = 412 or job = 422 or job = 432", $db);// Account section
$num_rows5 = mysql_num_rows($result9);
$result10 = mysql_query("SELECT * FROM queststatus where status = 2", $db);// Account section
$num_rows6 = mysql_num_rows($result10);
$result11 = mysql_query("SELECT * FROM queststatus where status = 1", $db);// Account section
$num_rows7 = mysql_num_rows($result11);
$result12 = mysql_query("SELECT * FROM gmlog", $db);// Account section
$num_rows8 = mysql_num_rows($result12);
$result13 = mysql_query("SELECT * FROM famelog", $db);// Account section
$num_rows9 = mysql_num_rows($result13);
$result14 = mysql_query("SELECT * FROM buddies", $db);// Account section
$num_rows10 = mysql_num_rows($result14);
$query = mysql_query("SELECT level FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query)){
$LevelVonAllen = $LevelVonAllen + $row[level];
}
$query2 = mysql_query("SELECT fame FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query2)){
$FameVonAllen = $FameVonAllen + $row[fame];
}
$query3 = mysql_query("SELECT exp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query3)){
$ExpVonAllen = $ExpVonAllen + $row[exp];
}
$query4 = mysql_query("SELECT meso FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query4)){
$MesoVonAllen = $MesoVonAllen + $row[meso];
}
$result21 = mysql_query("SELECT * FROM inventoryequipment", $db);// Account section
$num_rows11 = mysql_num_rows($result21);
$queryx = mysql_query("SELECT quantity FROM inventoryitems", $db);// Account section
while($row = mysql_fetch_array($queryx)){
$ItemsVonAllen = $ItemsVonAllen + $row[quantity];
}
$query5 = mysql_query("SELECT dex FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query5)){
$DexVonAllen = $DexVonAllen + $row[dex];
}
$query6 = mysql_query("SELECT str FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query6)){
$StrVonAllen = $StrVonAllen + $row[str];
}
$query7 = mysql_query("SELECT `int` FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query7)){
$IntVonAllen = $IntVonAllen + $row['int'];
}
$query8 = mysql_query("SELECT luk FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query8)){
$LukVonAllen = $LukVonAllen + $row[luk];
}
$query9 = mysql_query("SELECT rebirth FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query9)){
$RebVonAllen = $RebVonAllen + $row[rebirth];
}
$query10 = mysql_query("SELECT ap FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query10)){
$ApVonAllen = $ApVonAllen + $row[ap];
}
$query11 = mysql_query("SELECT sp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query11)){
$SpVonAllen = $SpVonAllen + $row[sp];
}
$query12 = mysql_query("SELECT maxhp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query12)){
$HpVonAllen = $HpVonAllen + $row[maxhp];
}
$query13 = mysql_query("SELECT maxmp FROM characters WHERE gm = 0", $db);// Account section
while($row = mysql_fetch_array($query13)){
$MpVonAllen = $MpVonAllen + $row[maxmp];
} 
echo "<b>'.number_format($num_rows, 0, ',', '.').'</b> Accounts<br>
<b>'.number_format($num_rowsc, 0, ',', '.').'</b> Characters<br>
<b>- '.number_format($num_rowsc2, 0, ',', '.').'</b> Male<br>
<b>- '.number_format($num_rowsc3, 0, ',', '.').'</b> Female<br><br>
<b>'.number_format($num_rowsg, 0, ',', '.').'</b> Guilds<br>
<b>'.number_format($num_rowsg4.'</b> Guildmembers<br>
<b>'.number_format($num_rowsg2, 0, ',', '.'), 0, ',', '.').'</b> Guildboardthreads<br>
<b>'.number_format($num_rowsg3, 0, ',', '.').'</b> Guildboardposts<br><br>
<b>'.number_format($num_rows1, 0, ',', '.').'</b> Beginner<br>
<b>'.number_format($num_rows2, 0, ',', '.').'</b> Warrior<br>
<b>'.number_format($num_rows3, 0, ',', '.').'</b> Magician<br>
<b>'.number_format($num_rows4, 0, ',', '.').'</b> Bowman<br>
<b>'.number_format($num_rows5, 0, ',', '.').'</b> Thief<br><br>
<b>'.number_format($num_rowsb, 0, ',', '.').'</b> Banned Hackers<br><br>
<b>'.number_format($num_rows6, 0, ',', '.').'</b> Quests in progress<br>
<b>'.number_format($num_rows7, 0, ',', '.').'</b> Quests absolved<br>
<b>'.number_format($num_rows8, 0, ',', '.').'</b> GM Commands<br>
<b>'.number_format($num_rows9, 0, ',', '.').'</b> Famed<br>
<b>'.number_format(($num_rows10 * 2), 0, ',', '.').'</b> Friends<br><br>
<b>'.number_format($LevelVonAllen, 0, ',', '.').'</b> Level<br>
<b>'.number_format($FameVonAllen, 0, ',', '.').'</b> Fame<br>
<b>'.number_format($ExpVonAllen, 0, ',', '.').'</b> EXP<br>
<b>'.number_format($MesoVonAllen, 0, ',', '.').'</b> Meso<br>
<b>'.number_format($num_rows11, 0, ',', '.').'</b> Equipment<br>
<b>'.number_format($ItemsVonAllen, 0, ',', '.').'</b> Items<br><br>
<b>'.number_format($HpVonAllen, 0, ',', '.').'</b> HP<br>
<b>'.number_format($MpVonAllen, 0, ',', '.').'</b> MP<br>
<b>'.number_format($StrVonAllen, 0, ',', '.').'</b> STR<br>
<b>'.number_format($DexVonAllen, 0, ',', '.').'</b> DEX<br>
<b>'.number_format($IntVonAllen, 0, ',', '.').'</b> INT<br>
<b>'.number_format($LukVonAllen, 0, ',', '.').'</b> LUK<br>
<b>'.number_format($ApVonAllen, 0, ',', '.').'</b> AP<br>
<b>'.number_format($SpVonAllen, 0, ',', '.').'</b> SP<br><br>
<b>'.number_format($RebVonAllen, 0, ',', '.').'</b> Reborns<br><br>"
?>

PHP Scripts - OdinMS - Statistics

Junior Spellweaver

Initiate Mage

🚫

Legendary Battlemage

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Mother effin' clouds

Legendary Battlemage

Newbie Spellweaver

Master Summoner

Newbie Spellweaver

Experienced Elementalist

Infraction Baɴɴed

Newbie Spellweaver

ASAPROCKY

Newbie Spellweaver

Initiate Mage

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners