Hello help me ?

04/06/2012 15:32 xerex98#1
I want to do a top 100pvp/pk on my dekaron site.Can any1 help me :D??
04/06/2012 19:12 imissblood#2
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.