Blog Documentation Try Vanilla Cloud
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Deleted bots through mysql

battersbatters New
edited July 2011 in Vanilla 2.0 - 2.8
how deleted many bots with same email jesperverefuj@gmail.com from forum
and how do forbid registration bots with same email
Tagged:

Best Answer

  • Options
    TimTim Operations Vanilla Staff
    Answer ✓
    That is not valid SQL. 
    DELETE FROM GDN_User WHERE Email='jesperverefuj@gmail.com';

    Vanilla Forums COO [GitHub, Twitter, About.me]

Answers

  • Options
    aeryaery Gtricks Forum in 2.2 :) ✭✭✭
    same question.

    There was an error rendering this rich post.

  • Options
    hyphyhyphy New
    You can't out of the box with Vanilla. Easiest way? Make a plugin. Easier way? Report the e-mail address to Google.
  • Options
    TimTim Operations Vanilla Staff
    2.0.18 has email-based banning which will allow you to blacklist email addresses.

    Vanilla Forums COO [GitHub, Twitter, About.me]

  • Options
    hyphyhyphy New
    2.0.18 has email-based banning which will allow you to blacklist email addresses.
    Ohhhh! I like.
  • Options
    battersbatters New
    edited July 2011
    I have 2.0.17 and I need something to remove at once as all the same by email bots.
    tried delete from GDN_User where jesperverefuj@gmail.com = 1;
    did not work
  • Options
    TimTim Operations Vanilla Staff
    Answer ✓
    That is not valid SQL. 
    DELETE FROM GDN_User WHERE Email='jesperverefuj@gmail.com';

    Vanilla Forums COO [GitHub, Twitter, About.me]

Sign In or Register to comment.