[RELEASE]PHP Ranking Script base using API

[ADM-U307]

It's a Simple List for the pvp ranking and reputation of the players script.
The same uses own connection from the server API.

A SS from this script:

Tutorial check C://innetpub/wwwroot/api/php/dbinfo.inc.php
and open and edit the line:

echo "Connection Could be established. \ n";

and edit

echo "";

Open Notepad and put this on.

<?php require "../api/php/dbinfo.inc.php" ?>
<title>Ranking</title>
<?PHP
// Especificar tabela a usar
    $table = 'UsersChars';


    // Query
    $strSQL = "SELECT TOP 10 *
    FROM UsersChars 
    ORDER BY Stat01 DESC
        
                
                ";
?>
<table border="1" style="width:300px">
<tr>
<td>Nome</td>
<td>Kills</td>
<td>Reputacao</td>
</tr>


<?php
    $objQuery = sqlsrv_query($conn, $strSQL) or die ("Erro ao executar a query: [".$strSQL."]");
    while($objResult = sqlsrv_fetch_array($objQuery))
    
    {
    $tag = $objResult["Gamertag"];
    $kills = $objResult["Stat01"];
    $rep = $objResult["Reputation"];
    ?>
    <?php
    /*echo "<tr><td>";
    echo $tag;
    echo "</td><td> | Kills = <font color=red>";
    echo $objResult["Stat01"];
    echo "</font></td></tr>";*/
    ?>
    <tr>
<td><?PHP echo $tag?></td>
<td><?PHP echo $kills?></td>
<td><?PHP echo $rep?></td>
</tr>
    
    <?php
    }
    ?>
</table>

Note:
This is a base of a rankking


Modify the will to your liking.

To change the number of players move in this line

$ strSQL = "SELECT TOP 10 *

Change 10 to the amount of your choice

 

[Oosmar02]

It is all but its how it is but?

 

[ADM-U307]

As I said this is a base of rank script accessed by the database API.
I am even more scripts based programming and soon others will post here as: changing password
add gc
ban
among others ...

 

[MrGrimm]

Appreicate the post.....This is what I got so far for my Leaderboard Nothing crazy but figured id share.

You must be registered to see links

 

[KlausVander]

Error :S
Erro ao executar a query: [SELECT TOP 10 * FROM UsersChars ORDER BY Stat01 DESC ]
Can you help me?

 

[ADM-U307]

which source do you use?


check up on your DB exists UsersChars table and if there are Stat00, Stat01, Stat02, Gamertag and Reputation fields.

 

[MrGrimm]

Fixed