exit; } if (isset($_GET['msg'])) { $message = $_GET['msg']; } //delete product review if ($_GET['delete_permanent'] == 'Y') { $feedback_id = $_REQUEST['feedback_id']; $message = Userdashboard::updateVendorFeedbackStatus($feedback_id); $url = "list_vendor_feedbacks.php?msg=" . $message; generalMethods::redirect($url); } //get currency $currency_attributes = displayCurrencyType(); //get all product reviews $vendor_feedbacks = Userdashboard::listVendorFeedbacks($userid); $totalrows = count($vendor_feedbacks); //get pagination results $limit = getPaginationLimit(); if ($limit == 0) { $limit = 10; } $page = isset($_GET['page']) ? trim($_GET['page']) : 1; if (empty($page)) { $page = 1; } $sql = " SELECT f.*, u.user_name, a.first_name ,a.last_name,u.email FROM " . $tableprefix . "artist_feedbacks f\n\t\tINNER JOIN " . $tableprefix . "users u ON f.user_id = u.user_id\n\t\tINNER JOIN " . $tableprefix . "artists a ON f.artist_id = a.artist_id\n WHERE f.user_id = " . $userid . "\n AND f.published = 'Y' AND f.deleted = 0\n \t ORDER BY date_added DESC "; $vendor_feedbacks_records = Userdashboard::getPaginationResult($sql, $limit, $page); /*display the active template*/ $active_template = displayTemplate(); include "includes/htmltop.php";