This is my first ranking page feel free to use it but leave the credits thnx.
Its coded 99% by ME and 1% to Wizkid for the Rank Column.
Edit the password and the host to yours. And Credits to Sneakers for a small help on the users online.
Screenshot:
Here it is:
PHP Code:
<html>
<style type="text/css">
<!--
body,td,th {
color: #FFF;
}
body {
background-color: #252627;
}
-->
</html>
</style>
<body text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF"><center>
<hr>
<html>
<head>
<title>Gunz Ranking Page</title>
</head>
<body>
<center>
<?php
//MSSQL Connection
$con = mssql_connect("pclol\SQLEXPRESS","sa","pass");
if (!$con)
{
die('Couldnt not connect: ' . mssql_error());
}
mssql_select_db("GunzDB");
//Users Online
$getcurp = mssql_query("SELECT CurrPlayer,MaxPlayer FROM ServerStatus");
$getcur = mssql_fetch_array($getcurp);
Echo "<span style=\"color:#f27800\">Users online on Gunz: </span>";
echo $getcur['CurrPlayer'];
echo "/";
echo $getcur['MaxPlayer'];
//Navbar- Below change google.com to your links
?>
<center>
<table border="0">
<tr>
<td>
<a href="http://www.google.com">- Gunz Register-</a>
</td>
<td>
<a href="http://www.miraclegamerz.net/home">-Homepage-</a>
</td>
<td>
<a href="http://www.miraclegamerz.net/forum">-Forums-</a>
</td>
</tr>
</table>
</center>
<hr>
<?php
//Player Ranking- It will display top 100 players if you want lower or higher look 1 line down and change 100 to your number.
$result = mssql_query("SELECT TOP 100* FROM Character ORDER BY Level DESC");
echo "<center><table border='1'>
<tr>
<th>Rank</th>
<th>Character Name</th>
<th>Level</th>
<th>Experience</th>
<th>Kills</th>
<th>Deaths</th>
<th>Play Time</th>
</tr>";
$x = 1;
while($row = mssql_fetch_array($result))
{
echo "<tr>";
echo "<td>#" . $x . "</td>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Level'] . "</td>";
echo "<td>" . $row['XP'] . "</td>";
echo "<td>" . $row['KillCount'] . "</td>";
echo "<td>" . $row['DeathCount'] . "</td>";
echo "<td>" . $row['PlayTime'] . "</td>";
echo "</tr>";
$x++;
}
echo "</center></table>";
mssql_close($con);
?>
<!-- OMG WTFBBQ HAX Copyright no waiii Dont fucking remove that.-->
<font size="2">Copyright 2009 by:Antimony: and Credits to Wizkid for Rank Column.</font>
</center>
</body>
</html>
Reply With Quote
Originally Posted by Abstrakt
