1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40

//1 CTPOKA
$tmp_query1="select *from wc3_player_race ORDER BY `wc3_player_race`.`race_xp` DESC LIMIT 1, 1";
$query = mysql_query($tmp_query1) or die(mysql_error());
if(mysql_num_rows($query) < 1)
{
	echo "no results";
}

while ($data = mysql_fetch_array($query))

{
echo	"<table border='2' cellspacing='2' cellpadding='2' align='center'>
<tr height='10' align='left'><td width='240'><font face='Verdana' color='#EEEEEE' size=2>
Nickname:</font></td><td width='50'><font face='Verdana' color='#EEEEEE' size=2>ID:</font></td><td width='100'><font face='Verdana' color='#EEEEEE' size=2>Exp:</font></td><td width='50'><font face='Verdana' color='#EEEEEE' size=2>Level:</font></td> </tr></table><br>";
$pname=$data['player_id'];
$xp=$data['race_xp'];
if($xp>=9938625)$lvl="50lvl";
if($xp>=8688625 and $xp<9938625)$lvl="49lvl";

ТУТ СОБСНО ВСЕ ТАК  В ПОРЯДКЕ УБЫВАНИЯ ШАРАШИТ

if($xp>=1100 and $xp<3000)$lvl="1lvl";
if($xp<1100)$lvl="0lvl";

$tmp_query="select *from wc3_player WHERE player_id LIKE '$pname' LIMIT 10 ";
$query = mysql_query($tmp_query) or die(mysql_error());
if(mysql_num_rows($query) < 1)
{
	echo "no results";
}

while ($data = mysql_fetch_array($query))

{
echo	"<table border='2' cellspacing='2' cellpadding='2' align='center'>
<tr height='10' align='left'><td width='240'><b><font color='#FF5050' face='Verdana' size=2>" .$data['player_name']."</font></b> </td><td width='50'><font color='#50FF50' face='Verdana' size=2>".$data['player_id']."</font>
</td><td width='100'><font color='#FFFFFF' face='Verdana' size=2>".$xp."</font><br></td><td width='50'><font color='#FFFF50' face='Verdana' size=2>$lvl</font></td> </tr></table><br>";

}
}