Blog Documentation Book a Demo

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

  • TimTim 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

  • aeryaery ✭✭✭
    same question.

    There was an error rendering this rich post.

  • 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.
  • TimTim Vanilla Staff
    2.0.18 has email-based banning which will allow you to blacklist email addresses.

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

  • hyphyhyphy New
    2.0.18 has email-based banning which will allow you to blacklist email addresses.
    Ohhhh! I like.
  • 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
  • TimTim 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.