static function rent_requests_cb($option, $vid)
{
global $database, $my, $mainframe, $mosConfig_list_limit, $Itemid, $booklibrary_configuration;
PHP_booklibrary::addTitleAndMetaTags();
$limit = $booklibrary_configuration['page']['items'];
$limitstart = mosGetParam($_REQUEST, 'limitstart', 0);
$database->setQuery("SELECT count(*) FROM #__booklibrary AS a" . "\nLEFT JOIN #__booklibrary_lend_request AS l" . "\nON l.fk_bookid = a.id" . "\nWHERE l.status = 0 AND a.owneremail LIKE '{$my->email}'");
$total = $database->loadResult();
echo $database->getErrorMsg();
$pageNav = new JPagination($total, $limitstart, $limit);
// for J 1.6
$query = "SELECT * FROM #__booklibrary AS a" . "\nLEFT JOIN #__booklibrary_lend_request AS l" . "\nON l.fk_bookid = a.id" . "\nWHERE l.status = 0 AND a.owneremail LIKE '{$my->email}'" . "\nORDER BY l.lend_from, l.lend_until, l.user_name" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit};";
$database->setQuery($query);
$rent_requests = $database->loadObjectList();
echo $database->getErrorMsg();
// $menu = new mosMenu($database);
// $menu->load( $Itemid );
// $params = new mosParameters( $menu->params );
if (version_compare(JVERSION, '3.0', 'lt')) {
$menu = new JTableMenu($database);
// for 1.6
$menu->load($Itemid);
$params = new mosParameters($menu->params);
} else {
$menu = new JTableMenu($database);
$menu->load($Itemid);
$params = new JRegistry();
$params->loadString($menu->params);
}
HTML_booklibrary::showRequestRentBooksCB($option, $rent_requests, $pageNav, $params);
}
