Top 100 PVP.
Code:
<?php
//--------------------------------------
// Written by Janvier123
// Made for DK servers
//--------------------------------------
$msconnect = mssql_connect("localhost","sa","pass");
$msdb = mssql_select_db("character", $msconnect);
$plist = "SELECT TOP 100 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc";
$pplist = mssql_query($plist);
echo "<table width='400' height='1'><tr valign='top'>";
echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";
while($list = mssql_fetch_array($pplist)){
if($list[''] == "0"){
$char = "t";
}
elseif($list[''] == "1"){
$char = "";
}
else
$char = "Archer";
echo "<td width='5%'>";
echo "</td>";
echo "<td width='5%'>";
echo $list['character_name'];
echo "</td>";
echo "<td width='5%'>";
echo $list['dwPVPpoint'];
echo "</td></tr><tr>";
}
echo "</tr></table>";
?>
Top 100 Pk.
Code:
<?php
//--------------------------------------
// Written by Janvier123
// Made for DK servers
//--------------------------------------
$msconnect = mssql_connect("localhost","sa","pass");
$msdb = mssql_select_db("character", $msconnect);
$plist = "SELECT TOP 100 character_name, wPKCount FROM [user_character] WHERE wPKCount > '0'order by wPKCount desc";
$pplist = mssql_query($plist);
echo "<table width='400' height='1'><tr valign='top'>";
echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";
while($list = mssql_fetch_array($pplist)){
if($list[''] == "0"){
$char = "t";
}
elseif($list[''] == "1"){
$char = "";
}
else
$char = "Archer";
echo "<td width='5%'>";
echo "</td>";
echo "<td width='5%'>";
echo $list['character_name'];
echo "</td>";
echo "<td width='5%'>";
echo $list['wPKCount'];
echo "</td></tr><tr>";
}
echo "</tr></table>";
?>
Thx to Janvier123.