<body>
<div align="center" class="matrax">
<?
include ("ayar.php");
include('gwn/security.php');
$connect = odbc_connect("$dbname", "$dbuser", "$dbpass") or die("Sql Servera baglanilamiyor, odbc_error()");
$asd = 0;
$user_rank_job = odbc_exec($connect,"SELECT TOP " .$ortakgoster. " strUserID, Level, Nation, Class, Knights, Loyalty strCharID FROM USERDATA WHERE Authority = '1' ORDER BY Loyalty DESC, Level DESC");
function getNation($nation) {
if ($nation == 1) {
$nation = '<img src="code/karus.gif">';
} elseif ($nation == 2) {
$nation = '<img src="code/elmo.gif">';
}
return $nation;
}
function getClass($class) {
global $lang;
$class3 = $class;
$class2 = $class;
if ($class == 105) {
$class2 = 'Warrior';
}
if ($class == 107) {
$class2 = 'Archer';
}
if ($class == 109) {
$class2 = 'Magician';
}
if ($class == 111) {
$class2 = 'Buffer';
}
if ($class == 205) {
$class2 = 'Warrior';
}
if ($class == 207) {
$class2 = 'Archer';
}
if ($class == 209) {
$class2 = 'Magician';
}
if ($class == 211) {
$class2 = 'Buffer';
}
if ($class2 == $class3) {
$class2 = 'Newbie';
}
return $class2;
}
$user_rank_tablo_1 = '
<table width="100%" border="0" align="center" cellpadding="6" cellspacing="1" bordercolor="#000000" class="tborder">
<tbody id="" style="">
<tr align="center">
<td width="100%" height="169" class="alt1"><table width="100%" bgcolor="#230000">
<tr class="textwhite">
<td width="4"><div align="left" class="style3">
<div align="center" class="style2"><strong>Sıra</div></strong>
</div></td>
<td width="22%"><div align="left" class="style3">
<div align="center" class="style2"><strong>İsim</div></strong>
</div></td>
<td width="13%"><div align="left" class="style3">
<div align="center" class="style2"><strong>Level</div></strong>
</div></td>
<td width="12%"><div align="left" class="style3">
<div align="center" class="style2"><strong>Irk</div></strong>
</div></td>
<td width="22%"><div align="left" class="style3">
<div align="center" class="style2"><strong>Clan</div></strong>
</div></td>
<td width="25%"><div align="left" class="style3">
<div align="center" class="style2"><strong>NP</div></strong>
</div></td>
</tr>
</table>
';
echo $user_rank_tablo_1;
while (odbc_fetch_row($user_rank_job)) {
$user = odbc_result($user_rank_job, 1);
$lvl_job=odbc_exec($connect,"SELECT Level FROM USERDATA WHERE strUserId = '".$user."'");
$lvl=odbc_result($lvl_job,1);
$nation = odbc_result($user_rank_job, 3);
$class = odbc_result($user_rank_job, 4);
$clan = odbc_result($user_rank_job, 5);
$clanid=odbc_result($user_rank_job, 5);
$clan_job=odbc_exec($connect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '".$clan."'");
$clan=odbc_result($clan_job, 1);
if ($clan == '') {
$clan = '';
}
$np = odbc_result($user_rank_job, 6);
$asd++;
$nation = getNation($nation);
$class = getClass($class);
$user_rank_tablo_2 = '
<table width="100%">
<tr class="textwhite">
<td width="3%"><div align="center" class="style5">'.$asd.'</div></td>
<td width="25%"><div align="center" class="Tips3" title="<img src=imza/mini.php?karakter='.htmlspecialchars(trim($user)).'>">'.$user.'</div></td>
<td width="13%"><div align="center" class="style5">'.$lvl.'</div></td>
<td width="12%"><div align="center" class="style5">'.$nation.'</div></td>
<td width="22%"><div align="center" class="style5"><a href="showclan.php?do='.$clanid.'">'.$clan.'</div></td></a>
<td width="25%"><div align="center" class="style5">'.$np.'</div></td>
</tr>
</table>
';echo $user_rank_tablo_2;
}
$clan_rank_tablo_3 = '
</p>
<table width="30%">
<tr class="textwhite">
<td width="22%"><div align="center" class="style3">'.$ortakgoster.' <span class="style3">User Gösterilmekte </span> </div></td>
</tr>
</table> </td>
</tr>
</tbody>
</table>
';
echo $clan_rank_tablo_3;
?>
</div>
</body>
