echo '<a href="' . $url . '">2</a> ... ';
}
$low = $page - 4;
$high = $page + 8;
for ($i = 1; $i <= $total_pages; $i++) {
if ($i > $low && $i < $high) {
if ($page == $i) {
echo '<b><a href="#">' . $i . '</a></b> ';
} else {
$url = NewsPagesUrl($i);
echo '<a href="' . $url . '">' . $i . '</a> ';
}
}
}
if ($page < $total_pages - 8) {
$penultimate = $total_pages - 1;
$url = NewsPagesUrl($penultimate);
echo ' ... <a href="' . $url . '">' . $penultimate . '</a> ';
}
if ($page < $total_pages - 7) {
$url = NewsPagesUrl($total_pages);
echo '<a href="' . $url . '">' . $total_pages . '</a> ';
}
if ($page < $total_pages) {
$next = $page + 1;
$url = NewsPagesUrl($next);
echo '<a href="' . $url . '">' . NEXT . ' »</a> ';
}
echo '</div>';
}
}
public function main($user)
{
//loadLanguageFile('play');
include '../lang/English.php';
include '../lang/sk/play.php';
$news_item = array();
$news['newses'] = array();
//if (isset($_GET['id']) || isset($_GET['name'])) {
if (isset($this->request[0])) {
/*if (isset($_GET['id'])) {
$id = intval($_GET['id']);
$sql = mysql_query("SELECT * FROM news WHERE id=".$id." LIMIT 1");
}
else {
$name = mysql_secure($_GET['name']);
$sql = mysql_query("SELECT * FROM news WHERE seo_url= '$name'");
}*/
$id = intval($this->request[0]);
$count = Query::query("SELECT * FROM news WHERE id=" . $id . " LIMIT 1")->num_rows;
if (!$count) {
header("HTTP/1.0 404 Not Found");
include 'includes/misc/404.php';
exit;
}
$this->set('id', $id);
}
$news['rss_icon'] = '<a href="rss.php"><img valign="middle" src="img/rss_small.png" /></a>';
// If id isn't set, get the 10 newest news items.
//if ((!isset($_GET['id'])) && (!isset($_GET['name']))) {
if (!isset($this->request[0])) {
if (!isset($_GET['page'])) {
$page = 1;
} else {
$page = $_GET['page'];
}
$npp = 5;
$from = $page * $npp - $npp;
$sql = Query::query("SELECT * FROM news ORDER BY id DESC LIMIT {$from}, {$npp}");
} else {
/*if (isset($_GET['id'])) {
$sql = Query::query("SELECT * FROM news WHERE id=" . $id . " LIMIT 1");
} else {
$name = Utils::secure($_GET['name']);
$sql = Query::query("SELECT * FROM news WHERE seo_url= '$name' LIMIT 1");
}*/
$id = intval($this->request[0]);
$sql = Query::query("SELECT * FROM news WHERE id=" . $id . " LIMIT 1");
}
while ($row = $sql->fetch_assoc()) {
$id = $row['id'];
$sql2 = Query::query("SELECT * FROM tbl_users WHERE id='" . $row['user'] . "' LIMIT 1");
while ($row2 = $sql2->fetch_assoc()) {
// Assign items to 'news' array for use in the template
$news_item = array('title' => $row['title'], 'author' => $row2['username'], 'date' => $row['date'], 'main' => $row['content']);
$news_item['user_url'] = Utils::ProfileUrl($row2['id'], $row2['seo_url']);
$news_item['news_url'] = Utils::NewsUrl($row['id'], $row['seo_url']);
$news_item['comments'] = Query::query("SELECT COUNT(*) as Num FROM NewsComments WHERE link_id={$row['id']}")->fetch_assoc()['Num'];
$news_item['image_url'] = 'uploads/news_icons/' . $row['image'];
// Include the template for news items
//include $setting['template'] . '/' . $template['news_item'];
array_push($news['newses'], $news_item);
//$this->set('newses', $news_item);
}
}
$this->set('newses', $news['newses']);
//if ((!isset($_GET['id'])) && (!isset($_GET['name']))) {
if (!isset($this->request[0])) {
$total_results = Query::query("SELECT COUNT(*) as Num FROM news")->fetch_assoc()['Num'];
$total_pages = ceil($total_results / $npp);
if ($total_pages > 1) {
echo '<div class="category_pages">';
if ($page > 1) {
$prev = $page - 1;
$url = NewsPagesUrl($prev);
echo '<a href="' . $url . '"><< ' . PREVIOUS . '</a> ';
}
for ($i = 1; $i <= $total_pages; $i++) {
$url = NewsPagesUrl($i);
if ($page == $i) {
echo '<b><a href="#">' . $i . '</a></b>';
} else {
echo '<a href="' . $url . '">' . $i . '</a> ';
}
}
if ($page < $total_pages) {
$next = $page + 1;
$url = NewsPagesUrl($next);
echo '<a href="' . $url . '">' . NEXT . ' >></a> ';
}
echo '</div>';
}
}
$this->set('game_id', $id);
$this->set('admin', $user['admin']);
$this->set('login_status', $user['login_status']);
$this->render('News');
}
