[Release] Working "Top Players" Page for MySql

[.Beatz]

Hey guys been working on this for my site and I thought I would share it with the community.
It is a working Top Players page for MySql sources.

PLEASE DO NOT flame me for this I am NOT an expert in php or html I have really only just started, but a few people want this so please hit the thanks if it helps you.

I am very sure someone could clean up this code alot as it is very messy but I think for a noob in php its pretty good.

 Spoiler

Okay first of we will need to change the database to match yours.
Search for "// DataBase Information".
Change everything to match your database in that section.

Next search for "// Variables".
You will see this under it //$LEAVE = $_POST['CHANGE'];
Basically do not change the parts that have $ next to them, just change everything in ['HERE']'; to match your database.

Just under that you will see
mysql_query("SELECT Name FROM cq_users");

Change Name and cq_users to match your database table.

Keep scrolling down and you will see stuff like this.
$name=mysql_result($result,$i,"[COLOR="RoyalBlue"]Name[/COLOR]");
change what is in blue (again) to match your database.

You will keep seeing stuff like this just make sure it matches your database.
Once you have finished save your work and view the page.

Any comments on how to clean up the code or any problems leave a comment.

EDIT > Quick note, this will support upto 10 players in each table, the tables will auto add/take away rows depending on the amount of players you have.

e.g If you have 8 players it will only show 8 rows on the table, if you have 3 players then it will only show 3 rows.



I only have 1 request... Please leave the Credits at the bottom of the page

[CØĐ£Ř||Mã©hÍñє]

awesome :P lemme thank you

[†he Knight]

Dude I believe 90 % of people won't add credits as well , You shouldn't release great thing as this one
and Yeah , Anthony Loves men..

[.Beatz]

Originally Posted by JuiceDCodeR

Dude I believe 90 % of people won't add credits as well , You shouldn't release great thing as this one
and Yeah , Anthony Loves men..

It doesn't bother me too much if people don't leave the credits. Also I haven't released anything good in a while so I thought hey lets release this lmao.

It's not exactly hard to make tbh, but people are just far to lazy to google stuff and learn lol.

Saying that I read about 20 tuts on MySql and php to be able to make this
Also people will have to do a bit of work, this does not ORDER BY Name, level etc. It just takes the first 1,2,3,4,5 etc from the table.

I can add it by special request if anyone NEEDS it that badly and google can't find how to do it.

[SYSTEM 32]

This is nice!

[.Beatz]

 Spoiler

// Variables

$name = $_POST['Name'];
$level = $_POST['Level'];
$silvers = $_POST['Silvers'];
$whsilvers = $_POST['WHSilvers'];
$cps = $_POST['CPs'];
$pkpoints = $_POST['PKPoints'];
$nobilitydonation = $_POST['NobilityDonation'];

//ORDER BY "column_name" [ASC, DESC]

mysql_query("SELECT Name FROM cq_users");
$query="SELECT * FROM cq_users ORDER BY Level DESC";
$result=mysql_query($query);
mysql_query("SELECT CPs FROM cq_users");
$query1="SELECT * FROM cq_users ORDER BY CPs DESC";
$result1=mysql_query($query1);
mysql_query("SELECT Silvers FROM cq_users");
$query2="SELECT * FROM cq_users ORDER BY Silvers DESC";
$result2=mysql_query($query2);
mysql_query("SELECT PKPoints FROM cq_users");
$query3="SELECT * FROM cq_users ORDER BY PKPoints DESC";
$result3=mysql_query($query3);
mysql_query("SELECT NobilityDonation FROM cq_users");
$query4="SELECT * FROM cq_users ORDER BY NobilityDonation DESC";
$result4=mysql_query($query4);


//$Results
$num=mysql_numrows($result);
$num1=mysql_numrows($result1);
$num2=mysql_numrows($result2);
$num3=mysql_numrows($result3);
$num4=mysql_numrows($result4);
mysql_close();
				  

//print "\t<td>$result</td>\n";
//Top Players
echo "<b><center></center></b>";
echo "<center><p>Top Players</p></center>";
print "<center><table width=400 border=1></center>\n";
print "<tr>\n";
$i=0;
while ($i < $num) 
{
if ($num > 10)
$num=10;
"<b>Highest Levels</b><br>";
$name=mysql_result($result,$i,"Name");
$level=mysql_result($result,$i,"Level");

if ($level > 0)
{
print "\t<td><p>Name: $name</p></td><td><p>Level: $level</p></td>\n";
print "</tr>\n";
print "</tr>\n";
$i++;
}
else 
//print "\t<td><p>Name:</p></td><td><p>CPs:</p></td>\n";
//print "</tr>\n";
$i++;
}
print "</table>\n";

//Top Moneybags
echo "<br><p>Top Moneybags</p>";
print "<table width=400 border=1>\n";
print "<tr>\n";
$i=0;
while ($i < $num2) 
{
if ($num2 > 10)
$num2=10;
"<b>Highest Levels</b><br>";
$name=mysql_result($result2,$i,"Name");
$whsilvers=mysql_result($result2,$i,"WHSilvers");
$silvers=mysql_result($result2,$i,"Silvers");
($money = $silvers + $whsilvers);

if ($money > 0)
{
print "\t<td><p>Name: $name</p></td><td><p>Silvers: $money</p></td>\n";
print "</tr>\n";
print "</tr>\n";
$i++;
}
else 
//print "\t<td><p>Name:</p></td><td><p>CPs:</p></td>\n";
//print "</tr>\n";
$i++;
}
print "</table>\n";


//Top CP carrier
echo "<br><p>Top CP carrier</p>";
print "<table width=400 border=1>\n";
print "<tr>\n";
$i=0;
while ($i < $num1) 
{
if ($num1 > 10)
$num1=10;
"<b><p>Highest Levels</p></b><br>";
$name=mysql_result($result1,$i,"Name");
$cps=mysql_result($result1,$i,"CPs");
if ($cps > 0)
{
print "\t<td><p>Name: $name</p></td><td><p>CPs: $cps</p></td>\n";
print "</tr>\n";
print "</tr>\n";
$i++;
}
else 
//print "\t<td><p>Name:</p></td><td><p>CPs:</p></td>\n";
//print "</tr>\n";
$i++;
}
print "</table>\n";


//Top Devil
echo "<br><p>Top Devil</p>";
print "<table width=400 border=1>\n";
print "<tr>\n";
$i=0;
while ($i < $num3) 
{
if ($num3 > 10)
$num3=10;
"<b><p>Highest Levels</p></b><br>";
$name=mysql_result($result3,$i,"Name");
$pkpoints=mysql_result($result3,$i,"PKPoints");
if ($pkpoints > 0)
{
print "\t<td><p>Name: $name</p></td><td><p>PKPoints: $pkpoints</p></td>\n";
print "</tr>\n";
print "</tr>\n";
$i++;
}
else 
//print "\t<td><p>Name:</p></td><td><p>CPs:</p></td>\n";
//print "</tr>\n";
$i++;
}
print "</table>\n";



//Top Nobility
echo "<br><p>Top Nobility</p>";
print "<table width=400 border=1>\n";
print "<tr>\n";
$i=0;
while ($i < $num4) 
{
if ($num4 > 10)
$num4=10;
"<b><p>Highest Levels</p></b><br>";
$name=mysql_result($result4,$i,"Name");
$nobilitydonation=mysql_result($result4,$i,"NobilityDonation");
if ($nobilitydonation > 0)
{
print "\t<td><p>Name: $name</p></td><td><p>Donation: $nobilitydonation</p></td>\n";
print "</tr>\n";
print "</tr>\n";
$i++;
}
else 
//print "\t<td><p>Name:</p></td><td><p>Donation:</p></td>\n";
//print "</tr>\n";
$i++;
}
print "</table>\n";

echo "<br><br>Credits to .Beatz<br>www.elitepvpers.com";
?>

That will make it sort by Level, Name etc. Please dont ask where to add it, it is very self explanitory

Most things commented out you can take out if you feel you need too.

[FrontBoy]

wow coool ;D