Файл: clan_journal.php
Строк: 173
<?php
require_once ('system/func.php');
auth(); // Закроем от не авторизованных
$clan = mysql_fetch_assoc(mysql_query("SELECT * FROM `clans` WHERE `id` = '".$user['id_clan']."'"));
switch($_GET['act']){
case 'exp_vse':
$title = 'Рейтинг по опыту 3 дня';
require_once ('system/header.php');
echo "<div class='block center'><a href='/clan/journal/exp/'>За сегодня</a> | <a href='/clan/journal/exp/vchera/'>За вчера</a> | <a href='/clan/journal/exp/pozavchera/'>Позавчера</a> | За 3 дня</div>";
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_72`+`clan_exp_48`+`clan_exp_24` > '0'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_72`+`clan_exp_48`+`clan_exp_24` > '0' ORDER BY `clan_exp_72`+`clan_exp_48`+`clan_exp_24` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни кого...";
while($post = mysql_fetch_assoc($q)){
echo icons_user($post['id'])." <a href='/profile/$post[id]'>$post[login]</a> - ".($post['clan_exp_72']+$post['clan_exp_48']+$post['clan_exp_24'])."<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
echo "<a href='/clan/journal/' class='link'>".ico('icons','arrow.png')." Вернуться назад</a>";
$clan = 0;
require_once ('system/footer.php');
break;
case 'exp_pozavchera':
$title = 'Рейтинг по опыту за позовчерашний день';
require_once ('system/header.php');
echo "<div class='block center'><a href='/clan/journal/exp/'>За сегодня</a> | <a href='/clan/journal/exp/vchera/'>За вчера</a> | Позавчера | <a href='/clan/journal/exp/vse/'>За 3 дня</a></div>";
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_72` > '0'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_72` > '0' ORDER BY `clan_exp_72` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни кого...";
while($post = mysql_fetch_assoc($q)){
echo icons_user($post['id'])." <a href='/profile/$post[id]'>$post[login]</a> - $post[clan_exp_72]<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
echo "<a href='/clan/journal/' class='link'>".ico('icons','arrow.png')." Вернуться назад</a>";
$clan = 0;
require_once ('system/footer.php');
break;
case 'exp_vchera':
$title = 'Рейтинг по опыту за вчерашний день';
require_once ('system/header.php');
echo "<div class='block center'><a href='/clan/journal/exp/'>За сегодня</a> | За вчера | <a href='/clan/journal/exp/pozavchera/'>Позавчера</a> | <a href='/clan/journal/exp/vse/'>За 3 дня</a></div>";
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_48` > '0'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_48` > '0' ORDER BY `clan_exp_48` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни кого...";
while($post = mysql_fetch_assoc($q)){
echo icons_user($post['id'])." <a href='/profile/$post[id]'>$post[login]</a> - $post[clan_exp_48]<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
echo "<a href='/clan/journal/' class='link'>".ico('icons','arrow.png')." Вернуться назад</a>";
$clan = 0;
require_once ('system/footer.php');
break;
case 'exp':
$title = 'Рейтинг по опыту';
require_once ('system/header.php');
echo "<div class='block center'>За сегодня | <a href='/clan/journal/exp/vchera/'>За вчера</a> | <a href='/clan/journal/exp/pozavchera/'>Позавчера</a> | <a href='/clan/journal/exp/vse/'>За 3 дня</a></div>";
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_24` > '0'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `clan_exp_24` > '0' ORDER BY `clan_exp_24` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни кого...";
while($post = mysql_fetch_assoc($q)){
echo icons_user($post['id'])." <a href='/profile/$post[id]'>$post[login]</a> - $post[clan_exp_24]<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
echo "<a href='/clan/journal/' class='link'>".ico('icons','arrow.png')." Вернуться назад</a>";
$clan = 0;
require_once ('system/footer.php');
break;
case 'online':
$title = 'Кто онлайн';
require_once ('system/header.php');
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id_clan` = '$clan[id]' AND `online` > '".(time()-300)."'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `online` > '".(time()-300)."' ORDER BY `id` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни кого...";
while($post = mysql_fetch_assoc($q)){
echo icons_user($post['id'])." <a href='/profile/$post[id]'>$post[login]</a> - ".fix_mesto($post['id'])."<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
echo "<a href='/clan/journal/' class='link'>".ico('icons','arrow.png')." Вернуться назад</a>";
$clan = 0;
require_once ('system/footer.php');
break;
default:
$title = 'Клановый журнал';
require_once ('system/header.php');
echo "<div class='block2'>";
$q = mysql_query("SELECT * FROM `clans` ORDER BY `level` DESC, `exp` DESC");
while($post = mysql_fetch_assoc($q)){
$a++;
if($post['id'] == $clan['id']){
echo "<li class='original'><a href='/clans/?page=".($a < 10 ? '1' : ceil($a/10))."'><span class='info'>".ico('icons','arrow.png')."Клан находится на <b>$a</b> месте в рейтинге!</span></a></li>";
}
}
echo "<li><a href='/clan/journal/online/'>".ico('icons','arrow.png')."Кто онлайн (".n_f(mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `id_clan` = '$clan[id]' AND `online`> '".(time()-300)."'")),1).")</a></li>";
echo "<li><a href='/clan/journal/exp/'>".ico('icons','arrow.png')."Рейтинг по опыту</a></li>";
echo "</div>";
$set['p_str'] = 15;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `clan_journal` WHERE `id_clan` = '$clan[id]'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `clan_journal` WHERE `id_clan` = '$clan[id]' ORDER BY `id` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
if($k_post == 0) echo "Нет ни одного действия...";
while($post = mysql_fetch_assoc($q)){
echo "<span class='info'>".vremja($post['time'])."</span> ".$post['text']."<br>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page);
echo "</div>";
$clan = 0;
require_once ('system/footer.php');
break;
}
?>