Create New User [MySQL]
 

Greetings,

Like most boards, I'm being plagued by good old fashioned spambots, even with the best efforts of a few well chosen hacks, manual approval of new members and ReCaptcha.

Luckily, I run a car site with a couple of thousand cars stored, all of which have multiple pictures, and their colour, so, it's very easy for me to build an Asirra style hack for my site based on "Click On The Red Car To Register" type questioning.

I doubt they'll bother write a custom spambot for just one site :)

However, I also intend building my own user registration page, which just creates a new user in the VBulletin database via good old fashioned MySQL commands.

Is this documented anywhere? Ie. Is it just a matter of creating a single new entry in the users table or is it more complex?

If anyone has any other suggestions, I'm all ears :D

Go team! :)

You can use the user datamanager to handle the details. If I were going to do it I'd probably just use the existing code as a guide. In admincp/user.php there's the code that adds a user when you do it from the admincp (starts around line 285).