View Full Version : mass delete comments??
October 17th, 2011, 11:20 PM
I had guest allowed to post comments for some dumb reason...
I was spammed with over a million comments in the gallery...
October 17th, 2011, 11:30 PM
Used this code and successfully delete 1,095,321 anonymous comments!
$sql = "DELETE FROM pp_comments WHERE userid = '0'"; //Change pp_ prefix if needed
echo "$numDeleted records deleted";
October 18th, 2011, 07:58 AM
well yes issuing a query against the comments table to delete comments with a userid of 0 would delete all guest comments. There is no mass delete.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.