Miscellaneous Hacks - vbImposterBlock

This version is no longer active. Get eXtremeTim's 3.6.x version:
EWT - Block Users From Registering Similiar Usernames
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]

Originally Posted by 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?

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 sorry

[Sparks Kelly261]

ROFLMAO

Yea, that worked

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?