Here is what the list section of my vbgarage.php looks like:
PHP Code:
if ($_REQUEST['do'] == 'list')
{
$vbulletin->input->clean_array_gpc('r', array(
'pagenumber' => TYPE_INT,
'perpage' => TYPE_INT
));
$pagenumber = &$vbulletin->GPC['pagenumber'];
$perpage = &$vbulletin->GPC['perpage'];
$perpage = intval($perpage);
if ($perpage == 0 or $perpage > 200) { $perpage = 25; }
if (intval($pagenumber) == 0) { $pagenumber = 1; }
$limitlower = ($pagenumber - 1) * $perpage + 1;
$limitupper = ($pagenumber) * $perpage;
$counter = 0;
$garagecount = $vbulletin->db->query_first("SELECT COUNT(*) AS garages FROM " . TABLE_PREFIX . "vbgarage_users");
$numberpages = $garagecount['garages'] / $perpage;
$numberpages = ceil($numberpages);
if (!isset($pagenumber) or ($pagenumber < 1) or ($pagenumber > $numberpages))
$pagenumber = 1;
$pos = ($pagenumber - 1) * $perpage;
$result_list = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbgarage_users ORDER BY userid ASC LIMIT $pos,$perpage");
$counter = 0;
$count = 0;
while ($list = $vbulletin->db->fetch_Array($result_list) AND $counter++ < $perpage)
{
$count++;
$list['year'] = unhtmlspecialchars($list['year']);
$list['make'] = unhtmlspecialchars($list['make']);
$list['model'] = unhtmlspecialchars($list['model']);
$list['text'] = unhtmlspecialchars($list['text']);
$list['lastactivity'] = vbdate($vbulletin->options['dateformat'],$list['lastactivity'],true);
$user = fetch_userinfo($list[userid]);
eval('$listbits .= "' . fetch_template('vbgarage_listbits') . '";');
}
$result_latest = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbgarage_images ORDER BY vbgarageid DESC LIMIT 5");
while ($latest = $vbulletin->db->fetch_Array($result_latest))
{
eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";');
}
$pagenav = construct_page_nav(
$pagenumber, $perpage, $garagecount[garages],
'vbgarage.php?' . $vbulletin->session->vars['sessionurl'] . 'do=$_REQUEST[do]', ''
. (!empty($vbulletin->GPC['perpage']) ? "&perpage=$perpage" : "")
);
$navbits = construct_navbits(array('' => 'vBGarage'));
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('vbgarage_listgarage') . '");');
}