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

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_r( sqlsrv_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_r( sqlsrv_errors(), true));

}

$counter = 1;

while( $row = sqlsrv_fetch_array( $query, SQLSRV_FETCH_NUMERIC))

{

 <!-- echo the resultse -->

 $counter++;

}

sqlsrv_free_stmt( $query);

sqlsrv_close( $connect);

?>