PDA

View Full Version : Miscellaneous Hacks - vbImposterBlock


hambil
19 Mar 2006, 02:57
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
19 Mar 2006, 03:13
Good idea.

Thanks,
Mat

Daniel
19 Mar 2006, 03:18
Nice idea. May install a bit later.

MentaL
19 Mar 2006, 03:20
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
19 Mar 2006, 03:51
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
19 Mar 2006, 04:51
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
19 Mar 2006, 05:01
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
19 Mar 2006, 05:10
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
19 Mar 2006, 05:50
ROFLMAO

Yea, that worked :p

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

;)

Sparks Kelly261
19 Mar 2006, 06:04
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
19 Mar 2006, 06:08
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
19 Mar 2006, 06:11
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
19 Mar 2006, 10:16
Sounds like a good idea for a plugin, I may have a use for it in the near future.

Snake
19 Mar 2006, 18:03
That's definitely a good idea, thanks!

Borgs8472
19 Mar 2006, 23:14
Borgs Dual 10 disagrees!

akanevsky
16 Apr 2006, 19:00
Interesting hack.

hambil
16 Apr 2006, 19:02
Thanks

akanevsky
16 Apr 2006, 19:09
lol, I figured that out... the question was up for like 2 seconds before I removed it.

hambil
16 Apr 2006, 19:10
lol, I figured that out... the question was up for like 2 seconds before I removed it.
I'm quick ;)

hambil
13 Apr 2007, 01:44
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.