- 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
i using this script
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
![acmux - [HELP]problems with web script - RaGEZONE Forums acmux - [HELP]problems with web script - RaGEZONE Forums](https://forum.ragezone.com/images/404_image.png)
![acmux - [HELP]problems with web script - RaGEZONE Forums acmux - [HELP]problems with web script - RaGEZONE Forums](https://forum.ragezone.com/images/404_image.png)
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>';
?>
1.player 1000pvp
2.player2 500pvp
like this format ;]
plz help guys ;] and sory for bad english