Skip to content

Instantly share code, notes, and snippets.

@innesm4

innesm4/expression engine spam member wipeout

Created May 24, 2014 14:40
Show Gist options
  • Save innesm4/7d06dba76c1c12c270ba to your computer and use it in GitHub Desktop.
Save innesm4/7d06dba76c1c12c270ba to your computer and use it in GitHub Desktop.
Download ZIP
Expression Engine 1 Query to wipe out spam members - replace group id with correct group
Raw
expression engine spam member wipeout
DELETE exp_members, exp_member_data, exp_member_homepage FROM exp_members
INNER JOIN exp_member_data
INNER JOIN exp_member_homepage
WHERE exp_member_data.member_id = exp_members.member_id
AND exp_members.member_id = exp_member_homepage.member_id
AND exp_members.group_id = '5'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment