|
|
21.03.2011, 19:17
|
#11 |
|
Ученый
Регистрация: 08.05.2010
Адрес: Новокузнецк
Сообщений: 141
Сказал(а) спасибо: 32
Поблагодарили 21 раз(а) в 9 сообщениях
 |
Пасиб)) Уже достал))
ПЫСЫ: Незнаю насколько правильный пхп скрипт в плане написания получился. Но он в принципе работает, причем срабатывает как надо. Код:
<?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>
|
|
|
|
|
Похожие темы
|
||||
| Тема | Автор | Раздел | Ответов | Последнее сообщение |
| [10719][FIX] Quest honor reward | KiriX | Принятые патчи | 7 | 10.11.2010 23:00 |
| [script] Обмен Арена-Хонор пойнтов (npc arena honor) | tempura | Патчи | 9 | 18.09.2010 12:33 |
| Now BG honor marks not reawrded in BG | newsbot | CMaNGOS Commits | 0 | 08.04.2010 03:40 |
| [9666] Check max. honor points on characteacter login. | newsbot | CMaNGOS Commits | 0 | 03.04.2010 12:30 |
Древовидный вид