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);
}
