function manage_review_s($option, $sorting)
{
global $database, $mainframe, $mosConfig_list_limit;
global $table_prefix;
// for J 1.6
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
$database->setQuery("SELECT count(*) FROM #__booklibrary_review;");
$total = $database->loadResult();
echo $database->getErrorMsg();
$pageNav = new JPagination($total, $limitstart, $limit);
// for J 1.6
//******************** begin request for reviews manager **********************/
//if for sorting
if (isset($_COOKIE['TestCookie']) and $_COOKIE['TestCookie'] == $sorting) {
$sorting .= ' DESC';
setcookie("TestCookie", $sorting, time() - 3600);
} else {
setcookie("TestCookie", $sorting, time() + 3600);
}
if ($sorting != "") {
$request_string = "SELECT b.id as fk_bookid, a.id as review_id, b.isbn, b.title as title_book,\n GROUP_CONCAT(c.title SEPARATOR ', ') as title_catigory, a.title as title_review,\n a.comment, e.user_name, a.date, a.rating, a.published" . "\nFROM\n\t\t{$table_prefix}booklibrary_review as a,\n\t\t{$table_prefix}booklibrary as b,\n\t\t{$table_prefix}booklibrary_main_categories as c,\n\t\t{$table_prefix}booklibrary_categories AS w,\n (SELECT DISTINCT d.name as user_name, a.fk_userid\n\t FROM {$table_prefix}booklibrary_review as a,\n\t {$table_prefix}users as d\n\t WHERE d.id = a.fk_userid" . "\nunion all" . "\nSELECT DISTINCT 'anonymous' as user_name, a.fk_userid\n\t\tFROM {$table_prefix}booklibrary_review as a\n\t\tWHERE a.fk_userid = 0) as e" . "\nWHERE a.fk_bookid = b.id AND b.id = w.bookid AND w.catid = c.id AND a.fk_userid = e.fk_userid\n GROUP BY review_id\n ORDER by {$sorting}" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit};";
} else {
$request_string = "\n\t\t\tSELECT\n\t\t\t\tb.id AS fk_bookid, a.id AS review_id, b.isbn, b.title AS title_book,\n\t\t\t\tGROUP_CONCAT(c.title SEPARATOR ', ') AS title_catigory,\n\t\t\t\ta.title AS title_review, a.comment, e.user_name, a.date, a.rating, a.published" . "\n FROM\n\t\t\t\t#__booklibrary_review AS a,\n\t\t\t\t#__booklibrary AS b,\n\t\t\t\t#__booklibrary_main_categories AS c,\n\t\t\t\t#__booklibrary_categories AS w,\n\t\t\t ( SELECT DISTINCT d.name AS user_name, a.fk_userid\n\t\t\t\tFROM #__booklibrary_review AS a,\n\t\t\t\t\t #__users AS d\n\t\t\t\tWHERE d.id = a.fk_userid" . "\n UNION all \n" . "SELECT DISTINCT 'anonymous' AS user_name, a.fk_userid\n\t\t\t\tFROM #__booklibrary_review AS a\n\t\t\t\tWHERE a.fk_userid = 0) AS e" . "\n WHERE a.fk_bookid = b.id\n\t\t\tAND b.id = w.bookid AND w.catid = c.id AND a.fk_userid = e.fk_userid\n\n\t\t\tGROUP BY review_id\n\t\t\tORDER by date" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit};";
}
$database->setQuery($request_string);
$reviews = $database->loadObjectList();
//************** end request for reviews manager ***************************/
HTML_booklibrary::showManageReviews($option, $pageNav, $reviews);
}