function lend_requests($option, $bid)
{
global $database, $mainframe, $mosConfig_list_limit;
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", '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");
$total = $database->loadResult();
echo $database->getErrorMsg();
if ($database->getErrorNum()) {
echo $database->stderr();
}
$pageNav = new JPagination($total, $limitstart, $limit);
// for J 1.6
$database->setQuery("SELECT * FROM #__booklibrary AS a" . "\nLEFT JOIN #__booklibrary_lend_request AS l" . "\nON l.fk_bookid = a.id" . "\nWHERE l.status = 0" . "\nORDER BY l.lend_from, l.lend_until, l.user_name" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit};");
$lend_requests = $database->loadObjectList();
echo $database->getErrorMsg();
if ($database->getErrorNum()) {
echo $database->stderr();
}
HTML_booklibrary::showRequestLendBooks($option, $lend_requests, $pageNav);
}
