Quick question with php

[Iskib]

Sinario:

I have a banned user table in my database

When a user signs up I want to check the username against this list.

in database banned usernames
test
admin
mod

I can do this with:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



What is I wanted to check if any part of the username exsist in the database.

for example if the user tried to register
test1, test_now, testtaco
admin_me, admin1, adminme
mod1,mod_me,modme

What code would I use to pickup these partials ?

[MoT3rror]

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Iskib]

Hey,

Thanks for the quick response. This is for another app not vbulletin.

I know I can check the database for the username entered , but what if they use part of a username that exsist for example admin is banned

what if they try to register admin1 or adminMe

[MoT3rror]

Use mysql wildcards like this.



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Iskib]

Hey,

No that didn't work. It returned for example:

admin as a banned username , but when I tried admin1

it still let admin1 be registered as a user

[MoT3rror]

Sorry it should use a like then a equal sign.



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Iskib]

Hey still not working

Here is what I have full code..



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



--------------- Added 1204900783 at 1204900783 ---------------

Other then the mySQL wildcard is there anyway of matching any username that would have part of a banned username? maybe a reg expression ?

[Opserty]

Does AdminCP > vBulletin Options > vBulletin Options > User Registration Options > Illegal User Names not cover what you want to do?

[Iskib]

No. As I said in the third post in this thread. It is not a vbulletin site therefore the vbulletin option can not be used.

I am just asking for a little help

[Opserty]

No. As I said in the third post in this thread. It is not a vbulletin site therefore the vbulletin option can not be used.
Ah right must have missed that post.