static function rent_history($option) { global $database, $my, $Itemid, $booklibrary_configuration, $mainframe, $mosConfig_list_limit; PHP_booklibrary::addTitleAndMetaTags(); // $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); } $database->setQuery("SELECT id FROM #__menu WHERE link='index.php?option=com_booklibrary'"); if ($database->loadResult() != $Itemid) { $params->def('wrongitemid', '1'); } if ($my->email == null) { echo "\n <script type=\"text/JavaScript\" language = \"JavaScript\">\n alert('You cannot view My Books that were not authorizated!');\n window.history.go(-1);\n </script>"; exit; } $limit = $booklibrary_configuration['page']['items']; $limitstart = mosGetParam($_REQUEST, 'limitstart', 0); $database->setQuery("SELECT count(*) FROM #__booklibrary_lend AS l" . "\nLEFT JOIN #__booklibrary AS a ON a.id = l. fk_bookid" . "\nWHERE l.fk_userid = '{$my->id}'"); $total = $database->loadResult(); echo $database->getErrorMsg(); $pageNav = new JPagination($total, $limitstart, $limit); // for J 1.6 $query = "SELECT l.*,a.* FROM #__booklibrary_lend AS l" . "\nLEFT JOIN #__booklibrary AS a ON a.id = l. fk_bookid " . "\nWHERE l.fk_userid = '" . $my->id . "' LIMIT {$pageNav->limitstart},{$pageNav->limit};"; $database->setQuery($query); $books = $database->loadObjectList(); HTML_booklibrary::showRentHistory($option, $books, $pageNav, $params); }