Vbadvanced Recent Thread pagination

[Admin]

This is one modification I made to recenthread.php to display a pagination as news.php


I'm no expert on this, in fact. I do not know anything. I'm sure someone with more knowledge, can upgrade.


Sorry my bad english


Modules/recentthreads.php
Find

if ($mod_options['portal_threads_maxthreads'])
{

Add after

/////PAGINATION By Felixthekat////////////
$perpage = 10;
$itemcount = $db->query_first("SELECT count(thread.threadid) as itemcount FROM " . TABLE_PREFIX . "thread as thread
$rthread_join
WHERE open != 10
AND thread.visible = 1 " .
iif($mod_options['portal_threads_cutoffdate'],
'AND thread.lastpost > ' . (TIMENOW - $mod_options['portal_threads_cutoffdate'] * 86400)
) .
iif($ignusers,
' AND thread.postuserid NOT IN(' . $ignusers . ')'
) . "$vba_threads_condition");


$pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT);
sanitize_pageresults($itemcount['itemcount'], $pagenumber, $perpage,$perpage,$perpage); 
$limitlower = ($pagenumber - 1) * $perpage + 1; 
$limitupper = $pagenumber * $perpage; 


if ($limitupper > $itemcount['itemcount'])
{
$limitupper = $itemcount['itemcount'];
if ($limitlower > $itemcount['itemcount'])
{
$limitlower = $itemcount['itemcount'] - $perpage;
}}


if ($limitlower <= 0)
{
$limitlower = 1;
}


$pagenav = construct_page_nav($pagenumber, $perpage, $itemcount['itemcount'], 'index.php?');
/////////////////////////////////

Find

LIMIT $mod_options[portal_threads_maxthreads]

Replace

LIMIT " . ($limitlower - 1) . ", $perpage

Go to Admincp > Styles and Templates > Your template > Templates of vbadvanced CMPS > adv_portal_recthreads_exp_head
add to the end

<tr>
<td>
$pagenav
</td>
</tr>

Enjoy!!