Help with query to delete members if their username contains keywords

[glennybee]

Hi folks,

I was wondering if this is possible. I want to delete account that have certain keywords in them, i.e. viagra. Is there a query I can run which will allow me to do this?

Many thanks!

[Final Kaoss]

In your admin cp under Vbulletin Options --> User Registration Options

Illegal User Names
Enter names in here that you do not want people to be able to register.

If any of the names here are included within the username, the user will be told that there is an error. For example, if you make the name John illegal, the name Johnathan will also be disallowed.

Separate names by spaces

and to help prevent future bot signups try this, it has worked %100 for me.

Add an extra question to the registration to prevent bot registrations

This solution will only work for vBulletin 3.6.3 and higher. On the lower 3.6 versions it will allow for a blank response.

vBulletin already offers a lot of buildin protections against registrations by bots (automated) like CAPTCHA (Image Verification), Email Verification or Registration Moderation. These will however not always protect you against human-assisted bot registrations (registration process automated, a human provide the CAPTCHA verification).

Unfortunatly there is no way to block all human-assisted registrations, adding an extra question to the registration process can however frustrate this type and often they will simply skip your board because it is causing them too much work.

How to add an extra registration question to frustrate human-assisted bot registration?

AdminCP -> User Profile Fields -> Add New User Profile Field

Profile Field Type: Single-Line Text Field
<<Continue>>

Use the following information when creating the Profile Field:
Title: Can you spell?
(Note: Adjust the title to the question you want to ask)
Description: Enter the first character of the word "Monkey"
(Note: Adjust the question. Don't use this example as it would be quickly picked up by bot registrations)
Default Value: B
(Note: anything but a valid answer)
Field Required: Yes, at registration and profile updating
Field Editable by User: Only at registration
Private Field: Yes
Field Searchable on Members List: No
Show on Members List: No
Regular Expression: ^[mM]$
(Note: this expression would only allow a 'm' or 'M' as valid answers, adjust to your needs)

This is not a fool proof solution, but will probably limit the number of semi-automated registrations.