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?


All times are GMT. The time now is 09:23 AM.

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.01119 seconds
  • Memory Usage 1,737KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete