vb.org Archive - Anti-Spam Options - Verify Email Before Registration

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Anti-Spam Options - Verify Email Before Registration (https://vborg.vbsupport.ru/showthread.php?t=294164)

Quote:

Originally Posted by funkyirishman (Post 2474129)

Have this installed and getting the below errors

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM userregcode WHERE userregemail = 'rosemary-o'hara@alphagenixblogs.com';

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 'hara@alphagenixblogs.com'' at line 1
Error Number : 1064
Request Date : Friday, January 10th 2014 @ 08:02:13 AM
Error Date : Friday, January 10th 2014 @ 08:02:15 AM
Script : http://www.worldeasy.com/forum/register.php
Referrer : http://www.worldeasy.com/forum/register.php?
IP Address : 50.115.165.86
Username : Unregistered
Classname : vB_Database
MySQL Version :

(Reply Posted via Ticket System)

Checked with v Bulletin and they said upload new version which I did and getting same errors and they said check with mod author.

Any help appreciated

Thanks

Uninstall any version you have. Then do a new fresh install of latest. I have it working fine on 4.2.2 ;)

Let me know how you get on

Thanks

How do you remove the old one?

I install but my footer links showing not correctly

i have just updated to the latest version i click register and the style has gone all funny. I have attached a photo to show. all other parts of the forum is fine just this email register has gone all funny.

Uninstalled until some sort of recaptcha is integrated with mod.

Quote:

Originally Posted by Alibass (Post 2477234)

Uninstalled until some sort of recaptcha is integrated with the mod.

Not needed as bots can bypass it anyway. Also you have this option built in, default vb settings

Quote:

Originally Posted by shots (Post 2474180)

This is due to a bot trying to use an email with a apostrophe in it. apparently, this ad-on does not per-qualify emails that well before submitting. I did PM the author and I know he did update.

After the update I have not received any more of these. when you updated the add-on did you remember to check the ove-write box?

I will note that I have gotten a few of these after the upgrade. I will try a complete uninstall and re-install...

Hi there,

This is a great mod, it has stopped about 90% of spammers and I don't get dead users any more.

There is one glitch that I have found though:

When a user types their email in and closes the page. If they come back it displays:

HTML Code:

Registration was done by this email, but the email was not activated.

We advice you to ensure that the activation code is not in your junk mail before requesting it again

And it shows three buttons below "Yes, I want to request the code again", "I found the code, thank you" and "Complete Registraton". The first two don't do anything at all and the third refreshes the page.

All 3 options do what they say for me

Quote:

Originally Posted by ForceHSS (Post 2478094)

All 3 options do what they say for me

Do you know what could possibly cause this? I would like to fix it.

Thank you.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01337 seconds Memory Usage 1,741KB 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 (1)bbcode_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages: