Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

PHP Scripts - OdinMS - Statistics

Junior Spellweaver
Joined
Apr 3, 2008
Messages
156
Reaction score
1
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>
 
Initiate Mage
Joined
Jun 21, 2008
Messages
3
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

good
 
Legendary Battlemage
Loyal Member
Joined
May 4, 2008
Messages
644
Reaction score
19
Re: [Release] PHP Scripts - OdinMS - Statistics

Nice release, This is most of the sql table itself.
 
Newbie Spellweaver
Joined
Jun 20, 2008
Messages
7
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

lawl nice relese
 
Newbie Spellweaver
Joined
Jun 30, 2008
Messages
46
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

live demo =D?
 
Junior Spellweaver
Joined
Apr 3, 2008
Messages
156
Reaction score
1
Re: [Release] PHP Scripts - OdinMS - Statistics



Just in english for sure.
 
Newbie Spellweaver
Joined
Jun 29, 2008
Messages
26
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

how to use this scripts i put it in the same php?
 
Junior Spellweaver
Joined
Jul 7, 2008
Messages
110
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

i dont know how to do it can anyone tell me how to edit it.
 
Mother effin' clouds
Loyal Member
Joined
Apr 13, 2008
Messages
1,534
Reaction score
448
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...
 
Legendary Battlemage
Loyal Member
Joined
May 18, 2008
Messages
614
Reaction score
53
Re: [Release] PHP Scripts - OdinMS - Statistics

lol nice release
 
Newbie Spellweaver
Joined
Apr 10, 2008
Messages
52
Reaction score
0
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
 
Master Summoner
Joined
Apr 29, 2008
Messages
534
Reaction score
3
Re: [Release] PHP Scripts - OdinMS - Statistics

Lol nice release.

And isn't statistics a subject in school? XD
 
Newbie Spellweaver
Joined
Apr 10, 2008
Messages
52
Reaction score
0
Re: [Release] PHP Scripts - OdinMS - Statistics

helpers me with my post plz =[
 
Infraction Baɴɴed
Loyal Member
Joined
Apr 9, 2008
Messages
1,416
Reaction score
169
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...
 
Newbie Spellweaver
Joined
Sep 13, 2008
Messages
68
Reaction score
0
Thanks lol. I don't really know those php html kinda stuff hehe..
 
Initiate Mage
Joined
Jun 25, 2008
Messages
2
Reaction score
0
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

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>"
?>
 
Back
Top