[HELP]problems with web script L2J 

Initiate Mage
Joined
Apr 18, 2007
Messages
3
Reaction score
0
i need help to remake this web script to show top pvp player and show their pvp count. i want like in the picture
acmux - [HELP]problems with web script - RaGEZONE Forums

acmux - [HELP]problems with web script - RaGEZONE Forums
i using this script
PHP:
<?php
mysql_connect($L2JBS_config["mysql_host"],$L2JBS_config["mysql_login"],$L2JBS_config["mysql_password"]) or die('Cannot connet to MySQL Server. Please edit the config .');
mysql_select_db($L2JBS_config["mysql_db"]) or dir('Cannot find chusen databse. Please edit the config.');

$data=mysql_query("SELECT * FROM characters WHERE $where and accesslevel<50 ORDER BY  pvpkills  DESC LIMIT 10") or die('Cannot take the info from database.');

echo "<table><thead><tr><th><center>Nick</center></th><tr></thead>\n";

$result2 = mysql_query("SELECT clan_id,clan_name FROM clan_data", $link)
    or die ("Error: ".mysql_error());
  while ($row2=mysql_fetch_row($result2))
$n=1;
while ($top=mysql_fetch_array($data))
{    
if ($top['sex']==0) { $name='<font color=#8080FF>'.$top[char_name].'</font>'; } else { $name='<font color=#FF8080>' .$top[char_name].'</font>'; }
echo "<tr><td><b><center>$n</center></b></td><td>$name</td><td><center></td></tr>\n";
$n++;
}

echo '</table>';
?>
it only show top 10 player but dont shows pvp count.it must show like this:
1.player 1000pvp
2.player2 500pvp
like this format ;]
plz help guys ;] and sory for bad english
 
Back