Файл: slando.icu/modules/game/news.php
Строк: 63
<?php
$mem_start = memory_get_usage();
require '../../system/func_for_game2.inc.php';
require '../../system/smiles.inc.php';
$sett=mysqli_fetch_assoc(mysqli_query($link,"SELECT * FROM `settings`"));
head2('Новости');
/*** фильтрация ***/
if (isset($_GET['act'])) {$mod=vvod($_GET['act']);} else {$mod="";}
switch($mod)
{
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
default:
if($user['adm']=='razrab' or $user['adm']=='admin'){echo'<a class="ssilki4" href="/panels/news?m=add">Добавить</a>';}
echo'<div class="block1">';
if ($sett['time_news'] !=$user['newsn']) {
mysqli_query($link,"UPDATE `users` SET `newsn`='".($sett['time_news'])."' WHERE `id`='".num($user['id'])."'");}
/** считаем количество новостей, страниц, текущую позицию **/
$kol_na_str=5;
$total = mysqli_num_rows(mysqli_query($link,"select id from `news`"));
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$query = mysqli_query($link,"select * from `news` order by `id` desc limit ".$start.",".$kol_na_str);
/** вывод ошибок **/
if (isset($_GET['err'])) {$err=vvod($_GET['err']);} else {$err="";}
$err_left = '<div class="error">'.img(100,'png').' ';
$err_left2 = '<div class="no_error">'.img(91,'png').' ';
$err_right = '</div>';
switch($err)
{
case 'c4ca4238a0b923820dcc509a6f75849b': echo $err_left.'Вы уже голосовали!'.$err_right; break;
case 'c81e728d9d4c2f636f067f89cc14862c': echo $err_left.'Новость не найдена!'.$err_right; break;
case 'eccbc87e4b5ce2fe28308fd9f2a7baf3': echo $err_left2.'Спасибо, ваш голос учтен!'.$err_right; break;
}
if ($total==0){echo '<span class="bold">Новостей нет!</span>';}
else
{
while($result = mysqli_fetch_assoc($query))
{
$search_user = mysqli_fetch_array(mysqli_query($link,"SELECT id,login,adm,sex FROM `users` WHERE `id`='".num($result['id_add'])."'"));
$result['data']=date("d.m.Y",num($result['data']));
$logsend=$search_user['adm'];$logadm=$search_user['login'];
$name = color_nick($search_user['login']);
echo '
<div class="block4">
<div class="clrt1">'.$result['name'].'</div>
<div class="clrt7 left">'.bbcode(nl2br(smile(vivod($result['text'])))).'
<div class="ssilki"><a href="/anketa?id='.num($search_user['id']).'">Добавил: '.sex($search_user['sex']).''.$name.'</a></div>
Добавлено: '.$result['data'].'<br>
';
$provtema =mysqli_fetch_array(mysqli_query($link,"SELECT id FROM `forum_theme` WHERE `id`='".num($result['thema_id'])."'"));
$theme_msg_tip1=mysqli_num_rows(mysqli_query($link,"SELECT id FROM `forum_msg` WHERE `id_theme`='".num($result['thema_id'])."'"));
echo '
<div class="ssilki"><a href="forum?r=1&id='.num($provtema['id']).'">Обсудить [<font color="green">'.$theme_msg_tip1.'</font>]</a></div></div>
</div>
<div class="razriv7"></div>
';
}
/** постраничная навигация **/
navi($page, $count_pages, '?page=');
}
break;
}
foot();
?>