Δεν ξέρω πολύ καλα php γιατι δεν ασχολούμε πολυ με sites αλλα κάτι τετοιο νομίζω θα σε βοηθήσει..χωρίς να βάζω ομως τ χερι μ στ φωτια.
<?php
//---------CONFIGS---------//
$title="Title here"; // Page Title Here
$type="1"; //Type 1 for Top PvP or 2 for Top PK
$server="localhost"; // MySQL IP
$user="root"; //MySQL Username
$password=""; //MySQL Password
$database="l2jdb"; //MySQL Database
$top="10"; //Number of top PvP/PK Players
//-----END OF CONFIGS-----//
if ($title) {
print("<head><title>$title</title></head>");
}
else {
print("<head><title>No Page Title</title></head>");
}
mysql_connect("$server", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());
if($type == '1'){
$result = mysql_query("SELECT char_name,pvpkills FROM characters where pvpkills>0 and accesslevel=0 order by pvpkills desc")
or die(mysql_error());
echo "<center><h3>Top $top PvP Players</h3></center><table border=1 align=center><tr> <th>Character</th> <th>PvP Kills</th> </tr>";
$sum1=0;
while($row = mysql_fetch_array( $result )) {
$name = $row['char_name'];
$kills = $row['pvpkills'];
if ($sum1<$top) {
echo "<tr><td align=center>$name</td><td align=center>$kills</td></tr>";
$sum1++;
}
}
}
elseif($type == '2'){
$result2 = mysql_query("SELECT char_name,pkkills FROM characters where pkkills>0 and accesslevel=0 order by pkkills desc")
or die(mysql_error());
echo "<center><h3>Top $top PK Players</h3></center><table border=1 align=center><tr> <th>Character</th> <th>PK Kills</th> </tr>";
$sum2=0;
while($row2 = mysql_fetch_array( $result2 )) {
$name2 = $row2['char_name'];
$kills2 = $row2['pkkills'];
if ($sum2<$top) {
echo "<tr><td align=center>$name2</td><td align=center>$kills2</td></tr>";
$sum2++;
}
}
}
else {
echo "<center>Please config the variable $type. Make it <b>1</b> for Top PvP or <b>2</b> for Top PK.</center>";
}
?>