function manage_suggestion($option) { 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_suggestion;"); $total = $database->loadResult(); echo $database->getErrorMsg(); $pageNav = new JPagination($total, $limitstart, $limit); // for J 1.6 $request_suggestion = "select b.email, d.* from (SELECT a.id, a.title, a.comment, e.user_name, a.date, a.fk_userid\n FROM #__booklibrary_suggestion AS a, (SELECT DISTINCT d.name AS user_name, a.fk_userid FROM #__booklibrary_suggestion AS a, #__users AS d WHERE d.id = a.fk_userid union all SELECT DISTINCT 'anonymous' AS user_name, a.fk_userid FROM #__booklibrary_suggestion AS a WHERE a.fk_userid = 0) as e" . "\n WHERE a.fk_userid = e.fk_userid ORDER by date) as d left join #__users AS b on d.fk_userid = b.id" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit};"; $database->setQuery($request_suggestion); $suggestion = $database->loadObjectList(); HTML_booklibrary::showManageSuggestion($option, $pageNav, $suggestion); }