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

crazyboy1661 · #82 07-26-2013, 05:48 AM

Hello da_judge, can you please help me!

Quote:

Originally Posted by crazyboy1661

Hello there, This mod is fantastic and was working fine before to restore my sql database. But now I am facing some problem with my DBase. While I am trying to upload this mod, i am getting the following error. Kindly guide me to rectify this error.

I have no technical knowledge to handle this.

Thanks in advance.

Error Showing:

Database Error Database error
The mysite database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the mysite.com home page, then try to open another page.
Click the Back button to try another link.

The mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

PHP Code:


			
Database error in vBulletin 4.2.1:



Invalid SQL:

CREATE TABLE vb4_userregcode (

`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`userregemail` VARCHAR( 100 ) NOT NULL ,

`userregcode` VARCHAR( 100 ) NOT NULL,

`counted` INT( 10 ) NOT NULL,

`dayscounter` INT( 100 ) NOT NULL,

`wheretoapply` BOOL NOT NULL

) ENGINE = MYISAM ;;



MySQL Error   : Table 'vb4_userregcode' already exists

Error Number  : 1050

Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM

Error Date    : Thursday, July 25th 2013 @ 06:52:23 AM

Script        : http://mysite.com/admincp/plugin.php?do=productimport

Referrer      : http://mysite.com/admincp/plugin.php?do=productadd

IP Address    : 0.0.0.0

Username      : admin

Classname     : vB_Database

MySQL Version : 5.5.32-log

Light Peak · #83 07-29-2013, 06:28 AM

any idea to put a note below "Make sure to write the correct email email to receive the verification code"? because hotmail rejects email sent from my mail server so i'd like to put a note so users will be informed

EDIT: got it already. Btw, hope recaptcha verification can be added in

fxdigi-cash · #84 08-01-2013, 07:07 AM

does this mod use Keycaptcha by any chance???

smirkley · #85 08-04-2013, 04:59 AM

No, it doesnt use any human verification options.

The one reason I dont use it unfortunatly, as I like it.

Ary Braga · #86 08-07-2013, 11:37 PM

Quote:

Originally Posted by crazyboy1661

Hello there, This mod is fantastic and was working fine before to restore my sql database. But now I am facing some problem with my DBase. While I am trying to upload this mod, i am getting the following error. Kindly guide me to rectify this error.

Other plugins are working fine.

I have very less technical knowledge to handle this.

Thanks in advance.

Error Showing:

Database Error Database error
The mysite database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the mysite.com home page, then try to open another page.
Click the Back button to try another link.

The mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

PHP Code:


			
Database error in vBulletin 4.2.1:



Invalid SQL:

CREATE TABLE vb4_userregcode (

`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`userregemail` VARCHAR( 100 ) NOT NULL ,

`userregcode` VARCHAR( 100 ) NOT NULL,

`counted` INT( 10 ) NOT NULL,

`dayscounter` INT( 100 ) NOT NULL,

`wheretoapply` BOOL NOT NULL

) ENGINE = MYISAM ;;



MySQL Error   : Table 'vb4_userregcode' already exists

Error Number  : 1050

Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM

Error Date    : Thursday, July 25th 2013 @ 06:52:23 AM

Script        : http://mysite.com/admincp/plugin.php?do=productimport

Referrer      : http://mysite.com/admincp/plugin.php?do=productadd

IP Address    : 0.0.0.0

Username      : admin

Classname     : vB_Database

MySQL Version : 5.5.32-log

Bro. make this.

Open notepad and

Copy and paste this code below.

Code:

DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.

tommythejoat · #87 08-15-2013, 12:20 AM

Quote:

Originally Posted by Ary Braga

Bro. make this.

Open notepad and

Copy and paste this code below.

Code:

DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.

So, clicking the allow overwrite option does not work?

ForceHSS · #88 08-15-2013, 01:16 AM

Quote:

Originally Posted by crazyboy1661

Hello there, This mod is fantastic and was working fine before to restore my sql database. But now I am facing some problem with my DBase. While I am trying to upload this mod, i am getting the following error. Kindly guide me to rectify this error.

Other plugins are working fine.

I have very less technical knowledge to handle this.

Thanks in advance.

Error Showing:

Database Error Database error
The mysite database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the mysite.com home page, then try to open another page.
Click the Back button to try another link.

The mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

PHP Code:


			
Database error in vBulletin 4.2.1:

Invalid SQL:
CREATE TABLE vb4_userregcode (
`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userregemail` VARCHAR( 100 ) NOT NULL ,
`userregcode` VARCHAR( 100 ) NOT NULL,
`counted` INT( 10 ) NOT NULL,
`dayscounter` INT( 100 ) NOT NULL,
`wheretoapply` BOOL NOT NULL
) ENGINE = MYISAM ;;

MySQL Error   : Table 'vb4_userregcode' already exists
Error Number  : 1050
Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM
Error Date    : Thursday, July 25th 2013 @ 06:52:23 AM
Script        : http://mysite.com/admincp/plugin.php?do=productimport
Referrer      : http://mysite.com/admincp/plugin.php?do=productadd
IP Address    : 0.0.0.0
Username      : admin
Classname     : vB_Database
MySQL Version : 5.5.32-log

go to your forum admin panel scroll down to Maintenance/Execute SQL Query/Manual Query put the code below into the box then click continue

Code:

CREATE TABLE `userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) NOT NULL,
  `userregcode` varchar(100) NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM AUTO_INCREMENT=661 DEFAULT CHARSET=utf8;

If the above does not work run this code first

Code:

DROP TABLE IF EXISTS `userregcode`;

This will fix your problem

crazyboy1661 · #89 08-15-2013, 06:59 AM

First of all I am very thankful for your reply. I did it but no use. Still I am getting the same reply/message.

Also when I tried to Execute SQL query, the following message is shown.

PHP Code:

You are not authorized to execute SQL queries

Quote:

Originally Posted by Ary Braga

Bro. make this.

Open notepad and

Copy and paste this code below.

Code:

DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.

ForceHSS · #90 08-15-2013, 11:31 AM

Quote:

Originally Posted by crazyboy1661

First of all I am very thankful for your reply. I did it but no use. Still I am getting the same reply/message.

Also when I tried to Execute SQL query, the following message is shown.

PHP Code:

You are not authorized to execute SQL queries

You need to add your userid into the config file then you can run them. If you are still having a problem after you run this pm me will have a look

da_judge · #91 09-01-2013, 07:20 PM

Correct edit you config.php and add your member id to following line, i have put userid 1 so change to what yours is and save...

$config['SpecialUsers']['canrunqueries'] = '1';

or you could do it via phpmyadmin

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05127 seconds Memory Usage 2,407KB Queries Executed 26 (?)
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 (7)bbcode_code (5)bbcode_php (6)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 (1)pagenav_pagelinkrel (11)post_thanks_box (14)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)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_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!