vbImposterBlock

[hambil]

This version is no longer active. Get eXtremeTim's 3.6.x version:
EWT - Block Users From Registering Similiar Usernames (http://www.vbulletin.org/forum/showthread.php?t=145514)
It's also compatible with 3.5.x.
Enjoy!

[Nutz]

Good idea.

Thanks,
Mat

[Daniel]

Nice idea. May install a bit later.

[MentaL]

Good idea but overall i think it maybe a bit OTT simply being you get a guy named Dan, then someone makes Daniel and it basically turns around and says NO! I can see allot of problems, but a good and unique hack non the less.

[hambil]

With the default settings Dan and Danial won't match. However, Dan and Dann and Dan1, would. So far I've been pretty pleased with the matching, however, possible false positives are one of the reasons it's marked as beta.

[Sparks Kelly261]

Hey,
Im not sure what the issue is, but im fairly sure its on my end.
I just went to add the product and I recieve this error.

Any ideas?

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO imposter_lookup
( userid, soundex_value, metaphone_value )
VALUES (1,'S162','SPRKS')
ON DUPLICATE KEY UPDATE soundex_value = VALUES(soundex_value), metaphone_value = VALUES(metaphone_value);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE soundex_value = VALUES(soundex_value),
Error Number : 1064
Date : Saturday, March 18th 2006 @ 08:42:45 PM
Script : http://hacktonic.com/01869/plugin.php
Referrer : http://hacktonic.com/01869/plugin.php?do=productadd
IP Address : 63.168.32.34
Username : Sparks
Classname : vb_database

[hambil]

Hey,
Im not sure what the issue is, but im fairly sure its on my end.
I just went to add the product and I recieve this error.

Any ideas?
You must be running an older version of MySQL. The MySQL version on my board is 4.1.14-standard. I've removed the ON DUPLICATE KEY from the product file. That should help. Download the product file again, and reinstall. Make sure to check "allow overwrite".

[MThornback]

If your SQL version is older than 4.1.0 its likely that you won't be able to use this plugin....the Duplicate key update as I understand was added in that release. From what I see the code is clean, so I think you'll find that its your SQL....if i'm wrong :p sorry :o

[Sparks Kelly261]

ROFLMAO

Yea, that worked :p

And I never doubted your code, I doubted meh server.

;)

[Sparks Kelly261]

but I do have a question.

Set this to the percentage match required before username is blocked. Lower is stricter. Value: 70

You say lower is stricter, but its a percentage.

Isnt that kinda contradictory?

So by this, you mean if at 70 someone could register SPRKS and there is already a sparks, then I could lower the number rather than raise it?

[hambil]

but I do have a question.



You say lower is stricter, but its a percentage.

Isnt that kinda contradictory?

So by this, you mean if at 70 someone could register SPRKS and there is already a sparks, then I could lower the number rather than raise it?

Yes. The percentage represents how alike the two names must be (by similar_text() standards). So, 70 means the two names are 70% alike. If you lowered it to 50 them the names only need be 50% alike to get a reject.

[Sparks Kelly261]

oh noes, look out, big arse idiot incoming on runway 4. (me)

your right, now that i look at it i totally get it.

Thanks, this is probably the best and simplest plugin out here.

/installed 10billion times.

[projectego]

Sounds like a good idea for a plugin, I may have a use for it in the near future.

[Snake]

That's definitely a good idea, thanks!

[Borgs8472]

Borgs Dual 10 disagrees!

[akanevsky]

Interesting hack.

[hambil]

Thanks

[akanevsky]

lol, I figured that out... the question was up for like 2 seconds before I removed it.

[hambil]

lol, I figured that out... the question was up for like 2 seconds before I removed it.
I'm quick ;)

[hambil]

This hack is no longer supported and will not be ported to 3.6 by me. I leave it open for anyone in the community to take ownership of, as long as you have at least one hack so it is clear you can code. Just PM me.