0) $results_per_page = (int)$_GET['show']; else $results_per_page = 10; // Approve reviews // if (isset($_POST['approve']) && $_POST['approve'] != "") { $ids_arr = array(); $ids_arr = $_POST['id_arr']; if (count($ids_arr) > 0) { foreach ($ids_arr as $v) { $rid = (int)$v; smart_mysql_query("UPDATE exchangerix_reviews SET status='active' WHERE review_id='$rid'"); } header("Location: reviews.php?msg=approved"); exit(); } } // Delete reviews // if (isset($_POST['delete']) && $_POST['delete'] != "") { $ids_arr = array(); $ids_arr = $_POST['id_arr']; if (count($ids_arr) > 0) { foreach ($ids_arr as $v) { $reviewid = (int)$v; DeleteReview($reviewid); } header("Location: reviews.php?msg=deleted"); exit(); } } $where = "1=1"; ////////////////// filter ////////////////////// if (isset($_GET['column']) && $_GET['column'] != "") { switch ($_GET['column']) { case "user_id": $rrorder = "user_id"; break; case "added": $rrorder = "added"; break; case "exchange_id": $rrorder = "exchange_id"; break; case "rating": $rrorder = "rating"; break; case "review": $rrorder = "review"; break; case "status": $rrorder = "status"; break; default: $rrorder = "added"; break; } } else { $rrorder = "added"; } if (isset($_GET['order']) && $_GET['order'] != "") { switch ($_GET['order']) { case "asc": $rorder = "asc"; break; case "desc": $rorder = "desc"; break; default: $rorder = "desc"; break; } } else { $rorder = "desc"; } /////////////////////////////////////////////////////// if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; } $from = ($page-1)*$results_per_page; if (isset($_GET['store']) && is_numeric($_GET['store'])) { $store = (int)$_GET['store']; $where .= " AND exchange_id='$store' "; $title2 = GetStoreName($store); } if (isset($_GET['user']) && is_numeric($_GET['user'])) { $user = (int)$_GET['user']; $where .= " AND user_id='$user' "; $title2 = GetUsername($user)."'s"; } $query = "SELECT *, DATE_FORMAT(added, '".DATE_FORMAT." %h:%i %p') AS date_added FROM exchangerix_reviews WHERE $where ORDER BY $rrorder $rorder LIMIT $from, $results_per_page"; $result = smart_mysql_query($query); $total_on_page = mysqli_num_rows($result); $query2 = "SELECT * FROM exchangerix_reviews WHERE ".$where; $result2 = smart_mysql_query($query2); $total = mysqli_num_rows($result2); $cc = 0; $title = $title2." Testimonials"; require_once ("inc/header.inc.php"); ?>
Add Testimonial

Testimonials 0) { ?>

0) { ?>
Sort by:   Results:
Showing - of
">
Testimonial Status Actions
0) { ?>
0) { ?> exchange #
">

350) echo substr($row['review'], 0, 350)."..."; else echo $row['review']; ?>

pending"; break; case "active": echo "".$row['status'].""; break; case "inactive": echo "".$row['status'].""; break; default: echo "".$row['status'].""; break; } ?> View Edit Delete
There are no testimonials at this time.