Файл: Dvig/forum/new.php
Строк: 24
<?php
####################
## Автор - USER-X ##
## Copyright 2013 ##
## xcms.mcdir.ru ##
####################
define( 'xcms_pro', 1 ) ;
$path = '../' ;
$title = 'Последние';
include_once ( $path . 'core/core.php' ) ;
include_once( $path.'core/head.php');
#########
switch($act){
case 'theme24':
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_themes` where `time` > (".time() . "-86400)"), 0);
$k_page=k_page($total,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($total) {
echo'<div id="razd">'.$title.' темы за : <a href="?act=theme48">48 часов</a> / <b>[24 часа]</b></div>';
$mys = mysql_query("SELECT * FROM `forum_themes` where `time` > (" .time() . "-86400) order by `time` DESC LIMIT $start, $set[p_str]");
while ($res = mysql_fetch_array($mys)) {
$podr = mysql_fetch_array(mysql_query('SELECT * FROM `forum_podrazdel` WHERE `id`='.$res['podrazdel'].''));
$uses = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$res['author_id'].''));
echo '<div id="body">
<a href="forum'.$podr['id'].'">'.$podr['name'].'</a> >
<a href="theme'.$res['id'].'/page=end">'.check($res['name']).'</a> >
<a href="/'.$res['author_id'].'">'.$uses['login'].'</a> ('.clock($res['time']).')
</div>
';}
if ($k_page>1)str('?act=theme24&',$k_page,$page); // Вывод страниц
} else {echo '<div id="razd">Тем нет</div>';}
break;
case 'theme48':
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_themes` where `time` > (".time() . "-172800)"), 0);
$k_page=k_page($total,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($total) {
echo'<div id="razd">'.$title.' темы за : <b>[48 часов]</b> / <a href="?act=theme24">24 часа</a></div>';
$mys = mysql_query("SELECT * FROM `forum_themes` where `time` > (" .time() . "-172800) order by `time` DESC LIMIT $start, $set[p_str]");
while ($res = mysql_fetch_array($mys)) {
$podr = mysql_fetch_array(mysql_query('SELECT * FROM `forum_podrazdel` WHERE `id`='.$res['podrazdel'].''));
$uses = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$res['author_id'].''));
echo '<div id="body">
<a href="forum'.$podr['id'].'">'.$podr['name'].'</a> >
<a href="theme'.$res['id'].'/page=end">'.check($res['name']).'</a> >
<a href="/'.$res['author_id'].'">'.$uses['login'].'</a> ('.clock($res['time']).')
</div>
';}
if ($k_page>1)str('?act=theme48&',$k_page,$page); // Вывод страниц
} else {echo '<div id="razd">Тем нет</div>';}
break;
case '24':
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_posts` where `time` > (".time() . "-86400)"), 0);
$k_page=k_page($total,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($total) {
echo'<div id="razd">'.$title.' посты за : <a href="?">48 часов</a> / <b>[24 часа]</b></div>';
$mys = mysql_query("SELECT * FROM `forum_posts` where `time` > (" .time() . "-86400) order by `time` DESC LIMIT $start, $set[p_str]");
while ($res = mysql_fetch_array($mys)) {
$them = mysql_fetch_array(mysql_query('SELECT * FROM `forum_themes` WHERE `id`='.$res['theme'].''));
$podr = mysql_fetch_array(mysql_query('SELECT * FROM `forum_podrazdel` WHERE `id`='.$them['podrazdel'].''));
$uses = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$res['author'].''));
echo '<div id="body">
<a href="forum'.$podr['id'].'">'.$podr['name'].'</a> >
<a href="theme'.$them['id'].'/page=end">'.check($them['name']).'</a> >
<a href="/'.$res['author'].'">'.$uses['login'].'</a> ('.clock($res['time']).')
</div>
';}
if ($k_page>1)str('?act=24&',$k_page,$page); // Вывод страниц
} else {echo '<div id="razd">Постов нет</div>';}
break;
default:
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_posts` where `time` > (".time() . "-172800)"), 0);
$k_page=k_page($total,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($total) {
echo'<div id="razd">'.$title.' посты за : <b>[48 часов]</b> / <a href="?act=24">24 часа</a></div>';
$mys = mysql_query("SELECT * FROM `forum_posts` where `time` > (" .time() . "-172800) order by `time` DESC LIMIT $start, $set[p_str]");
while ($res = mysql_fetch_array($mys)) {
$them = mysql_fetch_array(mysql_query('SELECT * FROM `forum_themes` WHERE `id`='.$res['theme'].''));
$podr = mysql_fetch_array(mysql_query('SELECT * FROM `forum_podrazdel` WHERE `id`='.$them['podrazdel'].''));
$uses = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$res['author'].''));
echo '<div id="body">
<a href="forum'.$podr['id'].'">'.$podr['name'].'</a> >
<a href="theme'.$them['id'].'/page=end">'.check($them['name']).'</a> >
<a href="/'.$res['author'].'">'.$uses['login'].'</a> ('.clock($res['time']).')
</div>
';}
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
} else {echo '<div id="razd">Постов нет</div>';}
}
#########
include_once ( $path . 'core/foot.php' ) ;
?>