<?php
include ( '../guvenlik/guvenlik.php' );
include('../guvenlik/security.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
<link rel="stylesheet" href="../stil.css" type="text/css" media="screen" />
</head>
<body>
<div align="center">
<font size="3"><? include("../ayarlar.php"); echo"$serveradi"; ?> Kullan?c? S?ralamas?</font>
<br />
<br />
</div>
<div align="center">
<?
include ("functions.php");
include ("../ayarlar.php");
$asd = 0;
$connect = odbc_connect("$dbname", "$dbuser", "$dbpass") or die("Sql Servera baglanilamiyor, odbc_error()");
$user_rank_job = odbc_exec($connect,"SELECT TOP " .$usergoster. " strUserID, Level, Nation, Class, Knights, Loyaltymonthly strCharID FROM USERDATA WHERE Authority =
'1' ORDER BY Loyaltymonthly DESC, Level DESC");
$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="#333333">
<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>Aylik NP (Leader Point)</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="style5">'.$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">'.$clan.'</div></td>
<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">'.$usergoster.'<span class="style3"> User Gösterilmekte </span> </div></td>
</tr>
</table> </td>
</tr>
</tbody>
</table>
';
echo $clan_rank_tablo_3;
?>
</div>
</body>
</html>
