Skip to content

Instantly share code, notes, and snippets.

@pral2a

pral2a/vanilla.sql

Forked from ziadoz/vanilla.sql
Last active August 29, 2015 14:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pral2a/3177f607cad7f0a2414e to your computer and use it in GitHub Desktop.
Save pral2a/3177f607cad7f0a2414e to your computer and use it in GitHub Desktop.
Download ZIP
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