function view_suggestion($option, $id)
{
global $database;
if (count($id) > 1) {
echo "<script> alert('Please select one suggestion for view!!!'); window.history.go(-1); </script>\n";
} else {
$request_suggestions = "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;";
$database->setQuery($request_suggestions);
$suggestions = $database->loadObjectList();
$suggestion = "";
//select one item suggestion
for ($i = 0; $i < count($suggestions); $i++) {
if ($suggestions[$i]->id == $id[0]) {
$suggestion = $suggestions[$i];
}
}
if ($suggestion != "") {
HTML_booklibrary::showViewSuggestion($option, $suggestion);
} else {
mosRedirect('index.php?option=com_booklibrary&task=manage_suggestion');
}
}
//end else
}