Witam, mam następujący skrypt php który działa na bazie MSSQL i chciałbym aby pierwsze 3 osoby z tego rankingu były odpowiednio wyróżnione. Nadać im złoty,srebny i brązowy medal. Pomógł by mi ktoś to zrobić?

  1. <?
  2. /*-----------------------------------------------------*\
  3. | SkyTeam MuPage file |
  4. | this file is connected with module $page["ranking"] |
  5. | File version 1.2 |
  6. |>1.1 Now form saves itself, and no longer display banned|
  7. |>1.2 display guild name and guild master status |
  8. | by Amelek (szklarzewicz@wp.pl) |
  9. | <a href="http://lorencia.com" target="_blank">http://lorencia.com</a> |
  10. \*-----------------------------------------------------*/
  11. if(!defined('SkyTeamPageRUNNING') OR !$page["ranking"])
  12. {
  13. die("Include error..");
  14. }
  15. if($page["use_overlib_in_ranking"])
  16. {
  17. echo '<div id="overDiv" style="position: absolute; visibility: hidden; z-index:1000;width:50;"></div><script src=grafika/overlib.js></script>';
  18. ?>
  19. <script>
  20. function do_overlib(name,lvl,res,str,dex,vit,enr)
  21. {
  22. text = "<?=$lang_level?>: "+lvl+"<br><?=$lang_Reset?>: "+res+"<br>";
  23. text += "<?=$lang_Strength?>: "+str+"<br><?=$lang_Dexterity?>: "+dex+"<br>";
  24. text += "<?=$lang_Vitality?>: "+vit+"<br><?=$lang_Energy?>: "+enr;
  25. overlib(text, CAPTION, name);
  26. }
  27. </script>
  28. <?
  29. }
  30. ?>
  31.  
  32. <div style="text-align:center">
  33.  
  34. </div>
  35. <table align=center style="margin:auto;">
  36. <tr class=highlight>
  37. <td align=left> Lp </td>
  38. <td align=left> <? echo $lang_g2_guild; ?> </td>
  39. <td> </td>
  40. <td align=left> <? echo $lang_Name; ?> </td>
  41. <td align=left> <? echo $lang_race; ?> </td>
  42. <td align=left> <? echo $lang_level; ?> </td>
  43. <?
  44. if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
  45. {
  46. ?><td align=left> <? echo $lang_Strength; ?> </td>
  47. <td align=left> <? echo $lang_Dexterity; ?> </td>
  48. <td align=left> <? echo $lang_Vitality; ?> </td>
  49. <td align=left> <? echo $lang_Energy; ?> </td>
  50. <?
  51. }
  52. ?>
  53. <td align=left> <? echo $lang_Reset; ?> </td>
  54.  
  55. <br><tr></tr>
  56.  
  57. <?php
  58.  
  59. if(isset($_POST['prim']))
  60. {
  61. settype($_POST['start_from'],'int');
  62. settype($_POST['count_result'],'int');
  63. if($_POST['count_result'] > 300)
  64. echo 'Too many requests';
  65. else
  66. {
  67. $sql = array ('str' => 'Strength',
  68. 'agl' => 'Dexterity',
  69. 'vit' => 'Vitality',
  70. 'enr' => 'Energy',
  71. 'lvl' => 'cLevel',
  72. 'res' => $res_column_name);
  73.  
  74. $first = $sql[$_POST['prim']];
  75. $second = $sql[$_POST['sec']];
  76. if(empty($first)) echo 'sort error';
  77. else
  78. {
  79. $first = 'Order By '.$first;
  80. if($_POST['sortdir_prim'] == 'desc') $first .= ' Desc';
  81. elseif($_POST['sortdir_prim'] == 'asc') $first .= ' Asc';
  82.  
  83. if(!empty($second) AND $second != $sql[$_POST['prim']])
  84. {
  85. $first .= ', '.$second;
  86. if($_POST['sortdir_sec'] == 'desc') $first .= ' Desc';
  87. elseif($_POST['sortdir_sec'] == 'desc') $first .= ' Asc';
  88.  
  89. }
  90.  
  91. $klasy = array (
  92. 'wizard' => ' Class = 0 OR Class = 1 ',
  93. 'knight' => ' Class = 16 OR Class = 17 ',
  94. 'elf' => ' Class = 32 OR Class = 33 ',
  95. 'gladiator' => ' Class = 48 ',
  96. 'lord' => ' Class = 64'
  97. );
  98. $class_add = null;
  99.  
  100. if(!empty($_POST['wizard']))
  101. $class_add .= $klasy['wizard'];
  102.  
  103. if(!empty($_POST['knight']))
  104. $class_add .= $klasy['knight'];
  105.  
  106. if(!empty($_POST['elf']))
  107. $class_add .= $klasy['elf'];
  108.  
  109. if(!empty($_POST['gladiator']))
  110. $class_add .= $klasy['gladiator'];
  111.  
  112. if(!empty($_POST['lord']))
  113. $class_add .= $klasy['lord'];
  114.  
  115. $class_add = str_replace(' ',' OR ',$class_add);
  116.  
  117. if(empty($class_add))
  118. echo 'Nie wybrano żadnej profesji!';
  119. else
  120. {
  121. //echo "SELECT TOP ".($_POST['start_from']+$_POST['count_result'])." Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name FROM Character WHERE (".$class_add.") AND $isadmin_column_name != 1 $first;";
  122. $result = mssql_query("SELECT TOP ".($_POST['start_from']+$_POST['count_result'])." Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE (".$class_add.") AND $isadmin_column_name <> 1 AND (CtlCode != 1 OR CtlCode IS null) $first;") OR die('Query FAILED');
  123. }
  124. }
  125. }
  126. }
  127. else
  128. $result = mssql_query("SELECT TOP 100 Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE $isadmin_column_name != 1 AND (CtlCode != 1 OR CtlCode IS null) Order By $res_column_name desc, CLevel desc") OR die('Query FAILED');
  129.  
  130. if(!empty($result))
  131. {
  132. $a = $_POST['start_from'];
  133. for($i=0;$i<mssql_num_rows($result);++$i)
  134. {
  135. $row = mssql_fetch_row($result);
  136. if($i >= $_POST['start_from'])
  137. {
  138. $row[0] = htmlspecialchars ($row[0]);
  139. $row[9] = htmlspecialchars($row[9]);
  140. if ($row[8] != 1)
  141. {
  142. $a = $a+1;
  143. echo '<tr>';
  144. echo '<td align=left>'.$a;
  145. if(!empty($row[9]))
  146. {
  147. if($row[10] == 1)
  148. $row[9] = '<img src=grafika/guild_master_mark.PNG><span class=serw_on>['.$row[9].']</span>';
  149. else
  150. $row[9] = '['.$row[9].']';
  151. echo '<td align=left width=15% style="white-space:nowrap;">'.$row[9].'</td>';
  152. }
  153. else
  154. {
  155. echo '<td align=left width=15% style="white-space:nowrap;"></td>';
  156. }
  157. if($row[11] == 1)
  158. {
  159. echo '<td><img src=grafika/pin_online.gif alt=online></td>';
  160. }
  161. else
  162. {
  163. echo '<td><img src=grafika/pin_offline.gif alt=offline></td>';
  164. }
  165. echo '<td align=left style="white-space:nowrap;"><b>'.$row[0].'</b></td>';
  166. echo '<td align=left>' .$classes[$row[1]].'<b></td>';
  167. echo '<td align=left> '.$row[2].'</td>';
  168. if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
  169. {
  170. echo '<td align=left> '.$row[3].'</td>';
  171. echo '<td align=left> '.$row[4].'</td>';
  172. echo '<td align=left> '.$row[5].'</td>';
  173. echo '<td align=left> '.$row[6].'</td>';
  174. echo '<td align=left> '.$row[7].'</td>';
  175. }
  176. else
  177. {
  178. echo '<td align=left> '.$row[7].'</td>';
  179. }
  180. echo '</tr>';
  181. }
  182. }
  183. }
  184. }
  185. ?>
  186. </table>


Pozdrawiam i z góry dziekuje.