", $review));
if (strlen($review) > MAX_REVIEW_LENGTH)
$errs[] = str_replace("%length%",MAX_REVIEW_LENGTH,CBE1_REVIEW_ERR2);
else if ($number_lines > 5)
$errs[] = CBE1_REVIEW_ERR3;
else if (stristr($review, 'http'))
$errs[] = CBE1_REVIEW_ERR4;
}
if (count($errs) == 0)
{
$review = substr($review, 0, MAX_REVIEW_LENGTH);
if (ONE_REVIEW == 1)
$check_review = mysqli_num_rows(smart_mysql_query("SELECT * FROM exchangerix_reviews WHERE exchange_id='$exchange_id' AND user_id='$userid'"));
else
$check_review = 0;
if ($check_review == 0)
{
(REVIEWS_APPROVE == 1) ? $status = "pending" : $status = "active";
$review_query = "INSERT INTO exchangerix_reviews SET exchange_id='$exchange_id', rating='$rating', user_id='$userid', review_title='$review_title', review='$review', status='$status', added=NOW()";
$review_result = smart_mysql_query($review_query);
$review_added = 1;
// send email notification //
if (NEW_REVIEW_ALERT == 1)
{
SendEmail(SITE_ALERTS_MAIL, CBE1_EMAIL_ALERT2, CBE1_EMAIL_ALERT2_MSG);
}
/////////////////////////////
header("Location: myreviews.php?msg=added");
exit();
}
else
{
$errormsg = CBE1_REVIEW_ERR5;
}
}
else
{
$errormsg = "";
foreach ($errs as $errorname)
$errormsg .= $errorname."
";
}
}
//////////////////////////////////////////////////////////////////////////////////////////
if (isset($_GET['act']) && $_GET['act'] == "del")
{
$del_query = "DELETE FROM exchangerix_reviews WHERE user_id='$userid' AND exchange_id='$exchange_id'";
if (smart_mysql_query($del_query))
{
header("Location: myreviews.php?msg=deleted");
exit();
}
}
$query = "SELECT r.*, e.* FROM exchangerix_reviews r, exchangerix_exchanges e WHERE r.user_id='$userid' AND r.exchange_id=e.exchange_id AND e.status='confirmed' ORDER BY e.created DESC";
$result = smart_mysql_query($query);
$total = mysqli_num_rows($result);
/////////////// Page config ///////////////
$PAGE_TITLE = CBE1_MYREVIEWS_TITLE;
require_once ("inc/header.inc.php");
?>
Please add your testimonial about our service.