Skip to content

Instantly share code, notes, and snippets.

@itsrachelfish

itsrachelfish/banned-users.sql

Created March 21, 2017 22:41
Show Gist options
  • Save itsrachelfish/9510b918a15bacc6bff19315bcc0d88f to your computer and use it in GitHub Desktop.
Save itsrachelfish/9510b918a15bacc6bff19315bcc0d88f to your computer and use it in GitHub Desktop.
Download ZIP
Update WFO database to mark banned users
Raw
banned-users.sql
Update `smf_members` set `is_activated` = '11'
where
`member_ip` in ('216.244.87.67', '87.206.142.169', '155.133.64.144', '155.133.38.210', '208.115.124.235', '208.115.124.211') or
`member_ip2` in ('216.244.87.67', '87.206.142.169', '155.133.64.144', '155.133.38.210', '208.115.124.235', '208.115.124.211')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment