Morning all, I been subjected to spamming on my site and approved a Review by mistake therefore displaying emails on the review!
Can anyone advise how i may remove reviews from my site?
Any help would be great,
Michael
Hi Michael,
Here's a basic "Manage Reviews" script that will let you browse, search and delete reviews. Run it from your /admin/ folder....
manageReviews.php
<?php require("../includes/common.php"); require("../includes/admin.php"); $q = (isset($_GET["q"])?$_GET["q"]:""); $page = (isset($_GET["page"])?intval($_GET["page"]):1); if ($_GET["action"] == "delete") { $sql = "DELETE FROM `".$config_databaseTablePrefix."reviews` WHERE id='".$_GET["id"]."'"; database_queryModify($sql,$result); admin_importReviews(); header("Location: manageReviews.php"); exit(); } require("admin_header.php"); require("admin_menu.php"); print "<h2>Manage Reviews</h2>"; $sql = "SELECT * FROM `".$config_databaseTablePrefix."reviews` WHERE approved > 0"; if ($q) { $sql .= " AND comments LIKE '%".database_safe($q)."%'"; } $offset = ($page-1) * $config_resultsPerPage; $sql .= " LIMIT ".$offset.",".$config_resultsPerPage; if (database_querySelect($sql,$rows)) { foreach($rows as $review) { print "<h3>".$review["product_name"]."</h3>"; print "<blockquote>"; print htmlentities($review["comments"],ENT_QUOTES,$config_charset); print "<p><a href='?action=delete&id=".$review["id"]."'>Delete</a></p>"; print "</blockquote>"; } print "<p><a href='?q=".urlencode($q)."&page=".($page+1)."'>Next</a></p>"; print "<form method='get'>"; print "<input type='text' name='q' />"; print "<input type='submit' value='Search' />"; print "</form>"; } else { print "<p>There are no reviews to display.</p>"; } require("admin_footer.php");?>
Hope this helps! Cheers, David.
©2006-2024 IAAI Software | Contact Us | Privacy Policy
Hi Michael,
Here's a basic "Manage Reviews" script that will let you browse, search and delete reviews. Run it from your /admin/ folder....
manageReviews.php
<?phprequire("../includes/common.php");
require("../includes/admin.php");
$q = (isset($_GET["q"])?$_GET["q"]:"");
$page = (isset($_GET["page"])?intval($_GET["page"]):1);
if ($_GET["action"] == "delete")
{
$sql = "DELETE FROM `".$config_databaseTablePrefix."reviews` WHERE id='".$_GET["id"]."'";
database_queryModify($sql,$result);
admin_importReviews();
header("Location: manageReviews.php");
exit();
}
require("admin_header.php");
require("admin_menu.php");
print "<h2>Manage Reviews</h2>";
$sql = "SELECT * FROM `".$config_databaseTablePrefix."reviews` WHERE approved > 0";
if ($q)
{
$sql .= " AND comments LIKE '%".database_safe($q)."%'";
}
$offset = ($page-1) * $config_resultsPerPage;
$sql .= " LIMIT ".$offset.",".$config_resultsPerPage;
if (database_querySelect($sql,$rows))
{
foreach($rows as $review)
{
print "<h3>".$review["product_name"]."</h3>";
print "<blockquote>";
print htmlentities($review["comments"],ENT_QUOTES,$config_charset);
print "<p><a href='?action=delete&id=".$review["id"]."'>Delete</a></p>";
print "</blockquote>";
}
print "<p><a href='?q=".urlencode($q)."&page=".($page+1)."'>Next</a></p>";
print "<form method='get'>";
print "<input type='text' name='q' />";
print "<input type='submit' value='Search' />";
print "</form>";
}
else
{
print "<p>There are no reviews to display.</p>";
}
require("admin_footer.php");
?>
Hope this helps!
Cheers,
David.