Пасиб)) Уже достал))
ПЫСЫ:
Незнаю насколько правильный пхп скрипт в плане написания получился.
Но он в принципе работает, причем срабатывает как надо.
Код:
<?php
$mysql_link = mysql_connect("localhost", "root", "root") or die ("Could not connect.");
mysql_query("SET NAMES 'utf8'");
mysql_select_db("characters", $mysql_link) or die ("Unknown DB.");
define('honor_highest_rank', 1517); // for 2.4.3 use 1517, for 3.0.3 use 1602
?>
<html http-equiv="content-type" content="text/html;charset=utf-8">
<table align='center' border='0'>
<font face="Scurri">
<tr>
<td width='125' align='center'> <b>Имя </b></td>
<td width='125' align='center'> <b>Звание </b></td>
<td width='125' align='center'> <b>Почетные<br>убийства</b></td>
</tr>
<?php
$pvpquery = mysql_query("SELECT `name`, `race`, `class`, `honor_highest_rank`, `stored_honorable_kills` FROM `characters`
WHERE CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`honor_highest_rank`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) >0
ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`honor_highest_rank`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) DESC LIMIT 5");
while($chardata = mysql_fetch_assoc($pvpquery)){
echo "<tr><td align='center'>".$chardata["name"]."</td>";
echo "<td align='center'>";
if ($chardata["honor_highest_rank"] == 1 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_1'>";
if ($chardata["honor_highest_rank"] == 1 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_1'>";
if ($chardata["honor_highest_rank"] == 2 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_2'>";
if ($chardata["honor_highest_rank"] == 2 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_2'>";
if ($chardata["honor_highest_rank"] == 3 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_3'>";
if ($chardata["honor_highest_rank"] == 3 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_3'>";
if ($chardata["honor_highest_rank"] == 4 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_4'>";
if ($chardata["honor_highest_rank"] == 4 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_4'>";
if ($chardata["honor_highest_rank"] == 5 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_5'>";
if ($chardata["honor_highest_rank"] == 5 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_5'>";
if ($chardata["honor_highest_rank"] == 6 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_6'>";
if ($chardata["honor_highest_rank"] == 6 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_6'>";
if ($chardata["honor_highest_rank"] == 7 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_7'>";
if ($chardata["honor_highest_rank"] == 7 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_7'>";
if ($chardata["honor_highest_rank"] == 8 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_8'>";
if ($chardata["honor_highest_rank"] == 8 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_8'>";
if ($chardata["honor_highest_rank"] == 9 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_9'>";
if ($chardata["honor_highest_rank"] == 9 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_9'>";
if ($chardata["honor_highest_rank"] == 10 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_10'>";
if ($chardata["honor_highest_rank"] == 10 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_10'>";
if ($chardata["honor_highest_rank"] == 11 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_11'>";
if ($chardata["honor_highest_rank"] == 11 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_11'>";
if ($chardata["honor_highest_rank"] == 12 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_12'>";
if ($chardata["honor_highest_rank"] == 12 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_12'>";
if ($chardata["honor_highest_rank"] == 13 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_13'>";
if ($chardata["honor_highest_rank"] == 13 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_13'>";
if ($chardata["honor_highest_rank"] > 13 and $chardata["race"] == 1 || $chardata["race"] == 3 || $chardata["race"] == 5 || $chardata["race"] == 7) echo "<img src='images/arank_14'>";
if ($chardata["honor_highest_rank"] > 13 and $chardata["race"] == 2 || $chardata["race"] == 4 || $chardata["race"] == 6 || $chardata["race"] == 8) echo "<img src='images/hrank_14'>";
echo "</td>";
echo "<td align='center'>".$chardata["stored_honorable_kills"]."</td></tr>";
}
?>
</font>
</table>