need php scripts

11/12/2012 18:25 eziorav#1
hi all
i was just asking for ur help as u are known in all rappelz private servers as experts
i just wanted top 10 rank script for players
which contains level-job-guild-how many PK-Gold-online or offline
to resume just like that stars's online serve had
11/12/2012 18:30 Titania123#2
Player ranking is a php script btw :P
11/12/2012 18:43 eziorav#3
Quote:
Originally Posted by Titania123 View Post
Player ranking is a php script btw :P
thanks because that was php not html
11/12/2012 19:10 marekrndr#4
PHP Code:
<?php

<!-- include your db configurations here -->

if( 
$connect === false )
{
     echo 
"Could not connect.";
     die( 
print_rsqlsrv_errors(), true));
}
$select "SELECT TOP(10)name, lv, job, pkc, dkc, exp, jlv, sex, play_time FROM Character WHERE lv > 0 AND permission = '0' AND lv < 181 AND name NOT LIKE '%@%' ORDER BY name ASC";

$query sqlsrv_query$connect$select);

if ( 
$query )
{

else 
{
     echo 
"Error in statement execution.";
     die( 
print_rsqlsrv_errors(), true));
}
$counter 1;
while( 
$row sqlsrv_fetch_array$querySQLSRV_FETCH_NUMERIC))
{
 <!-- echo 
the resultse -->
 
$counter++;
}
sqlsrv_free_stmt$query);
sqlsrv_close$connect);
?>