The Arcive of Official vBulletin Modifications Site.

Verify Email Before Registration · **Released**: 01-19-2013

Tested and working in vb 4.2.3

Product Description:

Verify Mail before registration , and during update profile information (changing mail for members from usercp)

This Product:

Stop spam at the first order, it works to prevent the registration with anonymous mails, in order to ensure Forum mail arrives (Newsletters - Subscriptions - Contact members .. etc.), to emails properly and effectively.

no member will be registered , or admitted to the database (both in group waiting activation or any other group), unless the mail is true. As if there was not a failed attempt to register.

What are the anonymous mails?

Are the emails that can not access by its owner, and browsed. Whether it was a mail already exists (used by another person), or not.

As long as no member can or the new Registrar (who wrote this mail), access to the inbox in the mail will be an anonymous mail, and reject his request.

Installation:

Just Import The product from AdminCP.

The product Will begin work as soon as the product installed.

You can manage the product settings from AdminCP > Settings > Options > Verify Mail before registration.

Enjoy

Big thanks to ForceHSS for his help with ironing out the spelling issues

To update, just import via Products in admincp, tick overwrite

PLEASE UPDATE

Last version had SQL issue, this is fixed now in this version

IMPORTANT

If you running Rename register.php by BOP5 you need to edit 2 templates

https://vborg.vbsupport.ru/showthread.php?t=297834

1st search in languages for

Code:

$vboptions[bburl]/register.php?so=1&emailcode=$emailcode

Edit register.php to what you renamed as

and save

2nd edit in template : reg_ver_start

Code:

<form id="registerform" action="register.php" name="register" method="post">

again look for register.php and change to what you renamed

After that all should be good

Note : CSS / FOOTER FIXED !!!

Mobile Theme Fix HERE

da_judge · #**212** 11-15-2014, 07:15 PM

Quote:

Originally Posted by iraqiboy90

Hi

Are you able to add an option to automatically allow whitelisted email domains to register as normal with this plugin, and the ones which isnt on the list will be put on manual moderation?

just ban domains you want from original settings.. job done

K!nG · #**213** 11-18-2014, 04:00 PM

Hi All,

I used to have a lot of spammers register on my forum, but once i start using this hack not a single bot/spammer was able to register. Starting last week i start getting database errors and at that point i was using version 2.0.5 and disbale the mod which stopped all database errors. Today i decided to update to version 2.0.7 by thinking may be it will fix the issue.
Once i update and enable the mod. I start receiving database errors again and from past 2 weeks i had 989 spammers registered and i am hating it.

below are some errors i am pasting and i will appreciate if someone can help me in fixing this

Thanks in advance.

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332758 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Error Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Script : http://www.*****.com/xperience.php?g...&sort=xn&pp=30
Referrer :
IP Address : 188.165.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Another one :

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332691 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:44:50 PM
Error Date : Tuesday, November 18th 2014 @ 12:44:51 PM
Script : http://www.****.com/activity.php
Referrer :
IP Address : 123.125.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Another one is:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO userregcode VALUES(NULL,'ennor86@proconview.com','9ce1a5a1e5a3 0b5cefd8ed1551f62d7f',1,1416165285,0);;

MySQL Error : Duplicate entry '93138' for key 'PRIMARY'
Error Number : 1062
Request Date : Tuesday, November 11th 2014 @ 02:14:44 PM
Error Date : Tuesday, November 11th 2014 @ 02:14:45 PM
Script : http://www.****.com/register.php
Referrer : http://www.****.com/register.php?
IP Address : 46.22.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Thanks.

Dave · #**214** 11-18-2014, 04:21 PM

@K!nG

AdminCP > Maintenance > Repair/Optimize Tables > look for the table userregcode, tick repair/optimize and click on continue.

ForceHSS · #**215** 11-18-2014, 04:22 PM

Quote:

Originally Posted by K!nG

Hi All,

I used to have a lot of spammers register on my forum, but once i start using this hack not a single bot/spammer was able to register. Starting last week i start getting database errors and at that point i was using version 2.0.5 and disbale the mod which stopped all database errors. Today i decided to update to version 2.0.7 by thinking may be it will fix the issue.
Once i update and enable the mod. I start receiving database errors again and from past 2 weeks i had 989 spammers registered and i am hating it.

below are some errors i am pasting and i will appreciate if someone can help me in fixing this

Thanks in advance.

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332758 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Error Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Script : http://www.*****.com/xperience.php?g...&sort=xn&pp=30
Referrer :
IP Address : 188.165.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Another one :

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332691 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:44:50 PM
Error Date : Tuesday, November 18th 2014 @ 12:44:51 PM
Script : http://www.****.com/activity.php
Referrer :
IP Address : 123.125.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Another one is:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO userregcode VALUES(NULL,'ennor86@proconview.com','9ce1a5a1e5a3 0b5cefd8ed1551f62d7f',1,1416165285,0);;

MySQL Error : Duplicate entry '93138' for key 'PRIMARY'
Error Number : 1062
Request Date : Tuesday, November 11th 2014 @ 02:14:44 PM
Error Date : Tuesday, November 11th 2014 @ 02:14:45 PM
Script : http://www.****.com/register.php
Referrer : http://www.****.com/register.php?
IP Address : 46.22.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Thanks.

You need to run repair on the table. Just take the time and read the error it does tell you what to do.

K!nG · #**216** 11-18-2014, 04:34 PM

I did see that for first two error messages, but third one is different and few mores i just didn't want to paste all of them in here. So you suggesting if i run repair table it will fix it completely or would that just take care of first 2 errors ?

Thanks.

Dave · #**217** 11-18-2014, 04:44 PM

Quote:

Originally Posted by K!nG

I did see that for first two error messages, but third one is different and few mores i just didn't want to paste all of them in here. So you suggesting if i run repair table it will fix it completely or would that just take care of first 2 errors ?

Thanks.

Possibly, yes.

ForceHSS · #**218** 11-18-2014, 06:57 PM

Quote:

Originally Posted by K!nG

I did see that for first two error messages, but third one is different and few mores i just didn't want to paste all of them in here. So you suggesting if i run repair table it will fix it completely or would that just take care of first 2 errors ?

Thanks.

Should do, but depends what the errors are run the repair if any more errors and if they are to do with this plugin post them all but put them in code quotes

K!nG · #**219** 11-20-2014, 06:20 PM

When i tried to do repair table i got these errors below.

Any help will be appreciated.

Thanks.

da_judge · #**220** 11-25-2014, 08:27 PM

do check from phpmyadmin

da_judge · #**221** 12-21-2014, 07:09 PM

I got this working for BOP5 great new plugin if anyone intrested

https://vborg.vbsupport.ru/showthread.php?t=297834

Let me know

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05202 seconds Memory Usage 2,366KB Queries Executed 28 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (12)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (3)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

12 благодарности(ей) от:
Delfi_r, EliasAlucard, ForceHSS, goxy63, gsmlover4u, josh_krz, kizy, nacaruncr, Normal, oneill, SaN-DeeP, sweetpotato

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!