vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - vbImposterBlock (https://vborg.vbsupport.ru/showthread.php?t=110772)

hambil 03-18-2006 10:00 PM

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 03-19-2006 01:13 AM

Good idea.

Thanks,
Mat

Daniel 03-19-2006 01:18 AM

Nice idea. May install a bit later.

MentaL 03-19-2006 01:20 AM

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 03-19-2006 01:51 AM

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 03-19-2006 02:51 AM

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?
Quote:

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 03-19-2006 03:01 AM

Quote:

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 03-19-2006 03:10 AM

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 03-19-2006 03:50 AM

ROFLMAO

Yea, that worked :p

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

;)

Sparks Kelly261 03-19-2006 04:04 AM

but I do have a question.

Quote:

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 03-19-2006 04:08 AM

Quote:

Originally Posted by Sparks Kelly261
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 03-19-2006 04:11 AM

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 03-19-2006 08:16 AM

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

Snake 03-19-2006 04:03 PM

That's definitely a good idea, thanks!

Borgs8472 03-19-2006 09:14 PM

Borgs Dual 10 disagrees!

akanevsky 04-16-2006 05:00 PM

Interesting hack.

hambil 04-16-2006 05:02 PM

Thanks

akanevsky 04-16-2006 05:09 PM

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

hambil 04-16-2006 05:10 PM

Quote:

Originally Posted by Psionic Vision
lol, I figured that out... the question was up for like 2 seconds before I removed it.

I'm quick ;)

hambil 04-12-2007 11:44 PM

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.


All times are GMT. The time now is 04:28 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03200 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (20)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete