PHP Scripts - OdinMS - Statistics

**SmartyX** · 06-07-08

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>

**MentaL**

**braveboy** · 06-07-08

good

**iMurad** · 08-07-08

Originally Posted by braveboy

good

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

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

**Giro** · 08-07-08

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

**farouq** · 09-07-08

lawl nice relese

**GalaxyJoey** · 09-07-08

live demo =D?

**SmartyX** · 09-07-08

http://bcmsfun.de/stats.php

Just in english for sure.

**sekum** · 11-07-08

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

**shajal** · 07-08-08

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

**SaintsIan** · 07-08-08

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

**candyman3435** · 07-08-08

lol nice release

**dudeman10** · 09-08-08

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** · 09-08-08

Lol nice release.

And isn't statistics a subject in school? XD

**dudeman10** · 09-08-08

helpers me with my post plz =[

**XenZy** · 09-08-08

Originally Posted by xcelinex33

Lol nice release.

And isn't statistics a subject in school? XD

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

PHP Scripts - OdinMS - Statistics

Thread Tools

PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Re: [Release] PHP Scripts - OdinMS - Statistics

Advertisement