[HELP] L2 OFF - Rankings - TOP-PVP/PK .. Online Players etc..!

[qqsage]

Hello, as the title says, i would really love if someone could share this things, or explain how to make them, ty!

[mcbigmac]

make a query to lin2world.

 

display result of said query in raw textform or super fancy artsy fartsy way.

Really up to your design skills.

 

Suggest looking into BASIC PHP and MSSQL queries.

and/or finding probably several already made shiz floating around.

[sandeagle]

make a query to lin2world.

 

display result of said query in raw textform or super fancy artsy fartsy way.

Really up to your design skills.

 

Suggest looking into BASIC PHP and MSSQL queries.

and/or finding probably several already made shiz floating around.

 

bravo!

[l2Storm]

There is php code for TOP 50 PVP, PK

 

<?

$ip = "your database ip or name";

$user = "user";

$pass = "password";

$db = "lin2world";

 

if($_GET['orderby']) $orderby = (int)$_GET['orderby']; // Forced to int to prevent SQL injection

else $orderby = 2; // Default order

 

$query = " SELECT TOP 50 char_name,duel,pk FROM user_data WHERE builder = 0 AND account_id > 0 ORDER BY $orderby DESC ";

 

$dbh = connect($ip,$user,$pass,$db);

$PVPlist = do_query($dbh,$query);

 

echo "

<table border='0' width='500'>

<tr class='tr0'>

<td align='center' width='50'><b>Rank</b></td>

<td align='center' width='150'><b>Player Name</b></td>

<td align='center' width='90'><b><a href='?orderby=2'>PVP Points</a></b></td>

<td align='center' width='90'><b><a href='?orderby=3'>PK Points</a></b></td>

</tr>

";

 

$i=1;

foreach($PVPlist as $p)

{

echo "

<tr class='tr".($i%2)."'>

<td align='center'>".$i."</td>

<td align='center'>".$p['char_name']."</td>

<td align='center'>".$p['duel']."</td>

<td align='center'>".$p['pk']."</td>

</tr>

";

$i++;

}

echo "</tr></table>";

 

function do_query($dbh=NULL,$query)

{

$arr = array();

$result = @mssql_query($query,$dbh);

for ($x=0; $arr[$x] = @mssql_fetch_assoc($result); $x++);

unset($arr[count($arr)-1]);

return $arr;

}

 

function connect($ip,$user,$pass,$db)

{

$dbh = mssql_connect($ip,$user,$pass);

mssql_select_db($db,$dbh);

return $dbh;

}

 

?>

[michael9ufo]

contact me to explain you better :)