Big Conquer Servers Php Scripts!
Thanks to Scott For giving me a basic understanding of these codes :)
Just change your password if your using lotf
Total 135 Accounts
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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
PHP Code:
$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!
Re: Big Conquer Servers Php Scripts!
Re: Big Conquer Servers Php Scripts!
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
Re: Big Conquer Servers Php Scripts!
And once again releasing my coding without giving credits -.-
Re: Big Conquer Servers Php Scripts!
waaaaaa ty for this codes
Re: Big Conquer Servers Php Scripts!
cool :)
dont really think its yurs
Re: Big Conquer Servers Php Scripts!
Quote:
Originally Posted by
XeroRecoil
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.
Re: Big Conquer Servers Php Scripts!
Yes iced u didn't help, steal just help a bit, just cause im newer to php than him, and i did rest :P
Re: Big Conquer Servers Php Scripts!
Quote:
Originally Posted by
XeroRecoil
And once again releasing my coding without giving credits -.-
get a life dont claim credits for stuff u didnt do
