Skip to content

Instantly share code, notes, and snippets.

@ziadoz

ziadoz/vanilla.sql

Last active December 21, 2015 02:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ziadoz/6233358 to your computer and use it in GitHub Desktop.
Save ziadoz/6233358 to your computer and use it in GitHub Desktop.
Download ZIP
Mass Delete Vanilla Forum Spam Users
Raw
vanilla.sql
-- Delete Spammers.
delete from GDN_User where ((CountDiscussions = 0 and CountComments = 0) or About != '' or Name = '[Deleted User]') and Admin = 0;
delete from GDN_User where CountVisits = 0 and Admin = 0;
delete from GDN_UserRole where UserID not in (select UserID from GDN_User);
-- Cleanup Data.
delete from GDN_Discussion where InsertUserID not in (select UserID from GDN_User);
delete from GDN_Comment where InsertUserID not in (select UserID from GDN_User);
delete from GDN_UserDiscussion where UserID not in (select UserID from GDN_User);
delete from GDN_Session where UserID not in (select UserID from GDN_User);
delete from GDN_Activity where ActivityUserID not in (select UserID from GDN_User);
delete from GDN_AntiSpamLog where UserID not in (select UserID from GDN_User);
delete from GDN_Log where InsertUserID not in (select UserID from GDN_User);
-- Need to update GDN_Category CountDiscussions and CountComments values with SQL too.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment