My news.php file:
<?php
$main_template = 'register';
define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');
//-----------------------------------------------------
//---Show Guestbook Comments---------------------------
//-----------------------------------------------------
if (isset($_POST['commentsetperpage']) || isset($_GET['commentsetperpage']))
{
$commentsetperpage = (intval($_POST['commentsetperpage']) ) ? intval($_POST['commentsetperpage']) : intval($_GET['commentsetperpage']);
if ($commentsetperpage)
{
$site_sess->set_session_var("commentperpage", $commentsetperpage);
$session_info['commentperpage'] = $commentsetperpage;
}
}
if (isset($session_info['commentperpage']))
{
$newsPerPage = $session_info['commentperpage'];
} else
{
$newsPerPage = 5;
}
$sql = "SELECT COUNT(news_id) AS news FROM ".NEWS_TABLE;
$result = $site_db->query_firstrow($sql);
$num_news = $result['news'];
$site_db->free_result();
$num_rows_all = (isset($num_news)) ? $num_news : 0;
$link_arg = $site_sess->url(ROOT_PATH."news.php");
include_once(ROOT_PATH.'includes/paging.php');
$getpaging = new Paging($page, $newsPerPage, $num_rows_all, $link_arg);
$offset = $getpaging->get_offset();
$site_template->register_vars(array(
"paging" => $getpaging->get_paging(),
"paging_stats" => $getpaging->get_paging_stats()
));
$sql = "SELECT news_id, news_title, news_text, user_name, news_date FROM ".NEWS_TABLE." ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
$result = $site_db->query($sql);
$news_row = array();
while ($row = $site_db->fetch_array($result))
{
$news_row[] = $row;
}
$site_db->free_result($result);
$num_news = sizeof($news_row);
$comments = "";
if ($num_news)
{
for ($i = 0; $i < $num_news; $i++)
{
$comment_user_name = htmlspecialchars($news_row[$i]['comment_user_name']);
$admin_links = "";
if ($user_info['user_level'] == ADMIN)
{
$admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/news.php?action=editnews&news_id=".$news_row[$i]['news_id'])."\" target=\"admin_edit\">".$lang['edit']."</a> ";
$admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/news.php?action=removenews&news_id=".$news_row[$i]['news_id'])."\" target=\"admin_edit\">".$lang['delete']."</a>";
}
$site_template->register_vars(array(
"news_title" => "<b>".$news_row[$i]['news_title']."</b>".sprintf($lang['news_posted_by'], $news_row[$i]['user_name'], format_date($config['date_format']." ".$config['time_format'], $news_row[$i]['news_date'])),
"news_text" => format_text($news_row[$i]['news_text'], ((isset($config['news_html']))?$config['news_html']:0), 0, ((isset($config['news_bbcode']))?$config['news_bbcode']:1), ((isset($config['news_bbcodeimg']))?$config['news_bbcodeimg']:1)),
"admin_links" => $admin_links,
));
$comments .= $site_template->parse_template("news_bit");
} // end for
}
else
{
$comments = $lang['no_news'];
}
//---End Show Guestbook Comments----
$contents = $site_template->parse_template("news_show");
$txt_clickstream = $lang['news_main'];
//-----------------------------------------------------
//---Clickstream---------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'];
if ($getpaging->page > 1)
{
$clickstream .= "<a href=\"".$site_sess->url(ROOT_PATH."news.php")."\">".$lang['news_main']."</a>".$config['category_separator'].$lang['page']." ".$getpaging->page."</span>";
}
else
$clickstream .= $txt_clickstream."</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"contents" => $contents,
"news_contents" => $comments,
"lang_register" => $lang['news'],
"clickstream" => $clickstream
));
unset($contents);
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>
Permissions 777