Big Conquer Servers Php Scripts!

[Virtue~]

Thanks to Scott For giving me a basic understanding of these codes :)
Just change your password if your using lotf

Total 135 Accounts

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT count(*) FROM characters WHERE Level=135;");
$val = mysql_fetch_array($res);
echo "<br /><center>Total Level 135 Accounts: ".$val[0]."</center>"; 

Total Offline Accounts

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT count(*) FROM accounts WHERE Online=0;");
$val = mysql_fetch_array($res);
echo "<br /><center>Total Accounts Offline: ".$val[0]."</center>"; 

Total Online Accounts

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT count(*) FROM accounts WHERE Online=1;");
$val = mysql_fetch_array($res);
echo "<br /><center>Total Accounts Online: ".$val[0]."</center>"; 

Total GM Accounts

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT count(*) FROM accounts WHERE Status=8;");
$val = mysql_fetch_array($res);
echo "<br /><center>Total GM Accounts: ".$val[0]."</center>"; 

Guild Holding Pole

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT GuildName FROM guilds WHERE HoldingPole=1;");
$val = mysql_fetch_array($res);
echo "<br /><center>Guild Holding Pole<br> ".$val[0]."</center>"; 

Top PkP Person

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT CharName FROM characters ORDER BY PkPoints DESC LIMIT 1;");
$res2 = mysql_query("SELECT PKPoints FROM characters ORDER BY PkPoints DESC LIMIT 1;");
$val = mysql_fetch_array($res);
$val2 = mysql_fetch_array($res2);
echo "<br /><center><b>Top Pker</b><br> ".$val[0]."<br>PkP:".$val2[0]."</center>"; 

Top Virtue

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT CharName FROM characters ORDER BY VP DESC LIMIT 1;");
$res2 = mysql_query("SELECT VP FROM characters ORDER BY VP DESC LIMIT 1;");
$val = mysql_fetch_array($res);
$val2 = mysql_fetch_array($res2);
echo "<br /><center><b>Top Virtue</b><br> ".$val[0]."<br>VPs:".$val2[0]."</center>"; 

Top Money Hog

$link=mysql_connect ("localhost", "root", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT CharName FROM characters ORDER BY Money DESC LIMIT 1;");
$res2 = mysql_query("SELECT Money FROM characters ORDER BY Money DESC LIMIT 1;");
$val = mysql_fetch_array($res);
$val2 = mysql_fetch_array($res2);
echo "<br /><center><b>Top Silvers Hog</b><br> ".$val[0]."<br>Silvers:".$val2[0]."</center>"; 

Top CPs Hog

$link=mysql_connect ("localhost", "root", "Password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");
$res = mysql_query("SELECT CharName FROM characters ORDER BY CPs DESC LIMIT 1;");
$res2 = mysql_query("SELECT CPs FROM characters ORDER BY CPs DESC LIMIT 1;");
$val = mysql_fetch_array($res);
$val2 = mysql_fetch_array($res2);
echo "<br /><center><b>Top Cps Hog</b><br> ".$val[0]."<br>Cps:".$val2[0]."</center>"; 

Thanks to me for edited scott's main script!

[MentaL]

[Scottdavey]

Nice dude good work

[stealarcher]

nice work virue.

for the noobs-
if you use more than one of these on one page, take out
$link=mysql_connect ("localhost", "root", "Password") or die ('Error: ' . mysql_error());
mysql_select_db ("coproj");

that way you dont get an error. You cant connect to the db twice

[XeroRecoil]

And once again releasing my coding without giving credits -.-

[Ne[o]x]

waaaaaa ty for this codes

[lizzio]

cool :)

dont really think its yurs

[Scottdavey]

And once again releasing my coding without giving credits -.-

How the fuck is this your coding, Its based off my coding which i did using a tutorial you douce, You did diddly squat.

[Virtue~]

Yes iced u didn't help, steal just help a bit, just cause im newer to php than him, and i did rest :P

[chris101]

And once again releasing my coding without giving credits -.-

get a life dont claim credits for stuff u didnt do