// Pagination scripting follows
if ($user->isFriend() OR $user->isAdmin()) {
$count_posts = mysql_query("SELECT `id` FROM `".$sql->prefix."posts` WHERE `pinned` != 'on' AND `draft` != 'on' AND `type` != 'page'");
} else {
$count_posts = mysql_query("SELECT `id` FROM `".$sql->prefix."posts` WHERE `pinned` != 'on' AND `draft` != 'on' AND `type` != 'page' AND `status` = 'public'");
}
$total_results = mysql_num_rows($count_posts);
if ($req[0] != "page") {
$page = "1";
} else {
$page = $req[1];
}
$limit = $config->portal_posts; // Posts per page
$total_pages = ceil($total_results / $limit); // Pages required
$prevpage = $page - 1;
$nextpage = $page + 1;
$offset = ($page - 1) * $limit;
echo "
";
// Grab & display regular posts
if ($user->isFriend() OR $user->isAdmin()) {
$get_posts = mysql_query("SELECT * FROM `".$sql->prefix."posts` WHERE `pinned` != 'on' AND `draft` != 'on' AND `type` != 'page' ORDER BY `id` DESC LIMIT ".$offset.", ".$limit) or die(mysql_error());
} else {
$get_posts = mysql_query("SELECT * FROM `".$sql->prefix."posts` WHERE `pinned` != 'on' AND `draft` != 'on' AND `type` != 'page' AND `status` = 'public' ORDER BY `id` DESC LIMIT ".$offset.", ".$limit);
}
-----------
function prevPage() {
global $config, $theme, $user, $show, $text, $page, $total_results, $limit, $total_pages, $prevpage, $nextpage, $offset, $theme;
if ($page != 1) {
echo str_replace("{LINK}",$config->site_url."/page/".$prevpage."/",$theme->prev_link);
}
}
function nextPage() {
global $config, $theme, $user, $show, $text, $req;
if ($req[0] != "page") {
$page = "1";
$nextpage = "2";
} else {
global $page, $nextpage;
}
global $total_results, $limit, $total_pages, $prevpage, $offset, $theme;
if ($page != $total_pages AND $total_results > $limit) {
echo str_replace("{LINK}",$config->site_url."/page/".$nextpage."/",$theme->next_link);
}
}