Файл: clan_count.php
Строк: 74
<?
include './system/common.php';
include './system/functions.php';
include './system/user.php';
if(!$user) {
header('location: /');
exit;
}
$id = _string(_num($_GET['id']));
if(!$id && $clan) {
$id = $clan['id'];
}
$i = mysql_query('SELECT * FROM `clans` WHERE `id` = "'.$id.'"');
$i = mysql_fetch_array($i);
if(!$i) {
header('location: /clans/');
exit;
}
$title = 'Состав клана';
include './system/h.php';
?>
<div class="title-top"><?=$title?></div>
<div class='line'></div>
<?
?>
<?
$max = 20;
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `clan_memb` WHERE `clan` = "'.$i['id'].'"'),0);
$pages = ceil($count/$max);
$page = _string(_num($_GET['page']));
if($page > $pages) {
$page = $pages;
}
if($page < 1) {
$page = 1;
}
$start = $page * $max - $max;
?>
<?
if($count > 0) {
?>
<?
?>
<?
$q = mysql_query('SELECT * FROM `clan_memb` WHERE `clan` = "'.$i['id'].'" ORDER BY `rank` DESC,`exp` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
$memb = mysql_query('SELECT * FROM `users` WHERE `id` = "'.$row['user'].'"');
$memb = mysql_fetch_array($memb);
switch($row['rank']) {
case 0:
$rank = 'Новобранец';
break;
case 1:
$rank = 'Послушник';
break;
case 2:
$rank = 'Солдат';
break;
case 3:
$rank = 'Воин';
break;
case 4:
$rank = 'Рыцарь';
break;
case 5:
$rank = 'Лорд';
break;
case 6:
$rank = 'Привратник';
break;
case 7:
$rank = 'Казначей';
break;
case 8:
$rank = 'Верховный Магистр';
break;
case 9:
$rank = 'Верховный Магистр';
break;
}
?>
<?
?>
<div class="list"><a href="/user/<?=$row['user']?>/" class="menu_link" style="color:#a5a5a5"><img src="http://213.239.195.28/xaos/style2/user_gladiator_20.png" alt=""> <span style="color:khaki"><?=$memb['login']?></span>, <?=$rank?><div><img src="http://213.239.195.28/xaos/16x16/arrow_up.png" alt=""> <span><?=$memb['level']?> ур.</span> <img src="http://213.239.195.28/xaos/icons_old/exp2.png" alt=""> <span class="alpha"><?=numi($row['exp'])?></span> <img src="http://213.239.195.28/xaos/style2/money.png" alt=""> <span class="alpha"><?=$row['gold']?></span> <img src="http://213.239.195.28/xaos/16x16/purse.png" alt=""> <span class="alpha"><?=$row['money']?></span> <img src="http://213.239.195.28/xaos/16x16/diamond.png" alt=""> <span class="alpha"><?=$memb['k']?></span></div></a>
<?
}
?>
<?
}
?>
<div class="separ3"></div><div class="menu_link2"><div class="div_hr2"></div><center><div class="navi">
<?=pages('/clan/'.$i['id'].'/'.($_GET['adm'] == true ? '?adm=true&':'?'))?>
</div></div>
<div class="separ"></div><a href="" class="menu_link"><img src="http://213.239.195.28/xaos/16x16/cross.png" alt=""> Обнулить</a><div class="separ3"></div>
<?
include './system/f.php';
?>