[MSSQL][PHP]Top 1,2,3 Wyróżnieni Opcje

[meehow18]

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ć?

[PHP] pobierz, plaintext 
<?
/*-----------------------------------------------------*\
|                  SkyTeam MuPage file                   |
|  this file is connected with module $page["ranking"]   |
|                   File version 1.2                     |
|>1.1 Now form saves itself, and no longer display banned|
|>1.2 display guild name and guild master status         |
|                by Amelek (szklarzewicz@wp.pl)          |
|                   <a href="http://lorencia.com" target="_blank">http://lorencia.com</a>                  |
\*-----------------------------------------------------*/
if(!defined('SkyTeamPageRUNNING') OR !$page["ranking"])
{
die("Include error..");
}
if($page["use_overlib_in_ranking"])
	{
	echo '<div id="overDiv" style="position: absolute; visibility: hidden; z-index:1000;width:50;"></div><script src=grafika/overlib.js></script>';
	?>
	<script>
	function do_overlib(name,lvl,res,str,dex,vit,enr)
		{
		text = "<?=$lang_level?>: "+lvl+"<br><?=$lang_Reset?>: "+res+"<br>";
		text += "<?=$lang_Strength?>: "+str+"<br><?=$lang_Dexterity?>: "+dex+"<br>";
		text += "<?=$lang_Vitality?>: "+vit+"<br><?=$lang_Energy?>: "+enr;
		overlib(text, CAPTION, name);
		}
	</script>
	<?
	}
?>
 
<div style="text-align:center">
 
</div>
<table align=center style="margin:auto;">
<tr class=highlight>
<td align=left> Lp </td>
<td align=left> <? echo $lang_g2_guild; ?> </td>
<td> </td>
<td align=left> <? echo $lang_Name; ?> </td>
<td align=left> <? echo $lang_race; ?> </td>
<td align=left> <? echo $lang_level; ?> </td>
<?
if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
	{
	?><td align=left> <? echo $lang_Strength; ?> </td>
	<td align=left> <? echo $lang_Dexterity; ?> </td>
	<td align=left> <? echo $lang_Vitality; ?> </td>
	<td align=left> <? echo $lang_Energy; ?> </td>
	<?
	}
?>
<td align=left> <? echo $lang_Reset; ?> </td>
 
<br><tr></tr>
 
<?php
 
if(isset($_POST['prim']))
{
settype($_POST['start_from'],'int');
settype($_POST['count_result'],'int');
if($_POST['count_result'] > 300)
echo 'Too many requests';
else
{
$sql = array ('str' => 'Strength',
'agl' => 'Dexterity',
'vit' => 'Vitality',
'enr' => 'Energy',
'lvl' => 'cLevel',
'res' => $res_column_name);
 
$first = $sql[$_POST['prim']];
$second = $sql[$_POST['sec']];
if(empty($first)) echo 'sort error';
else
{
$first = 'Order By '.$first;
if($_POST['sortdir_prim'] == 'desc') $first .= ' Desc';
elseif($_POST['sortdir_prim'] == 'asc') $first .= ' Asc';
 
if(!empty($second) AND $second != $sql[$_POST['prim']])
{
$first .= ', '.$second;
if($_POST['sortdir_sec'] == 'desc') $first .= ' Desc';
elseif($_POST['sortdir_sec'] == 'desc') $first .= ' Asc';
 
}
 
$klasy = array (
'wizard' => ' Class = 0 OR Class = 1 ',
'knight' => ' Class = 16 OR Class = 17 ',
'elf' => ' Class = 32 OR Class = 33 ',
'gladiator' => ' Class = 48 ',
'lord' => ' Class = 64'
);
$class_add = null;
 
if(!empty($_POST['wizard']))
$class_add .= $klasy['wizard'];
 
if(!empty($_POST['knight']))
$class_add .= $klasy['knight'];
 
if(!empty($_POST['elf']))
$class_add .= $klasy['elf'];
 
if(!empty($_POST['gladiator']))
$class_add .= $klasy['gladiator'];
 
if(!empty($_POST['lord']))
$class_add .= $klasy['lord'];
 
$class_add = str_replace('  ',' OR ',$class_add);
 
if(empty($class_add))
echo 'Nie wybrano żadnej profesji!';
else
{
//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;";
$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');
}
}
}
}
else
$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');
 
if(!empty($result))
{
$a = $_POST['start_from'];
for($i=0;$i<mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
if($i >= $_POST['start_from'])
{
$row[0] = htmlspecialchars ($row[0]);
$row[9] = htmlspecialchars($row[9]);
if ($row[8] != 1)
{
$a = $a+1;
 echo '<tr>';
 echo '<td align=left>'.$a;
if(!empty($row[9]))
	{
	if($row[10] == 1) 
		$row[9] = '<img src=grafika/guild_master_mark.PNG><span class=serw_on>['.$row[9].']</span>';
	else
		$row[9] = '['.$row[9].']';
 	echo '<td align=left width=15% style="white-space:nowrap;">'.$row[9].'</td>'; 
	}
else
	{
 	echo '<td align=left width=15% style="white-space:nowrap;"></td>'; 
	}
if($row[11] == 1)
	{
	echo '<td><img src=grafika/pin_online.gif alt=online></td>';
	}
else
	{
	echo '<td><img src=grafika/pin_offline.gif alt=offline></td>';
	}
echo '<td align=left style="white-space:nowrap;"><b>'.$row[0].'</b></td>';
echo '<td align=left>' .$classes[$row[1]].'<b></td>';
echo '<td align=left> '.$row[2].'</td>';
if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
	{
 	echo '<td align=left> '.$row[3].'</td>';
 	echo '<td align=left> '.$row[4].'</td>';
 	echo '<td align=left> '.$row[5].'</td>';
 	echo '<td align=left> '.$row[6].'</td>';
	echo '<td align=left> '.$row[7].'</td>';
	}
else 
	{
	echo '<td align=left> '.$row[7].'</td>';
	}
echo '</tr>';
}
}
}
}
?>
</table>
[PHP] pobierz, plaintext 

Pozdrawiam i z góry dziekuje.