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'); }