Anti-Spam Options - Verify Email Before Registration

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

$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

<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

[ForceHSS]

Originally Posted by josh_krz

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

Thank you.

Without checking your forum its hard to tell

[KidHTML]

Glitchy and messes up style. Uninstalling.

[funkyirishman]

Ok I downloaded the latest version and removed the previous version. Uploaded the new version and I keep on getting the below errors

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 'loughlin@onlimail.com'' at line 1
Error Number : 1064
Request Date : Monday, February 3rd 2014 @ 11:04:30 AM
Error Date : Monday, February 3rd 2014 @ 11:04:31 AM
Script : http://www.worldeasy.com/forum/register.php
Referrer : http://www.worldeasy.com/forum/register.php?
IP Address : 5.144.176.178
Username : Unregistered
Classname : vB_Database
MySQL Version :

Anything else I can do to stop receiving these errors as its like bots are registering?

[shots]

Originally Posted by funkyirishman

Ok I downloaded the latest version and removed the previous version. Uploaded the new version and I keep on getting the below errors

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 'loughlin@onlimail.com'' at line 1
Error Number : 1064
Request Date : Monday, February 3rd 2014 @ 11:04:30 AM
Error Date : Monday, February 3rd 2014 @ 11:04:31 AM
Script : http://www.worldeasy.com/forum/register.php
Referrer : http://www.worldeasy.com/forum/register.php?
IP Address : 5.144.176.178
Username : Unregistered
Classname : vB_Database
MySQL Version :

Anything else I can do to stop receiving these errors as its like bots are registering?

I will note that even after a rip out and re-install I am still getting these errors.

[josh_krz]

Originally Posted by KidHTML

Glitchy and messes up style. Uninstalling.

It is because it doesn't include the additional.css. You can add it manually in the templates.

[Alibass]

Originally Posted by ForceHSS

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

Mate I know how vB works I've been using it since '07. My post was to the author on why I was uninstalling!

[da_judge]

Originally Posted by josh_krz

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

Thank you.

Could be your browser.. you tried differant one

[da_judge]

Originally Posted by josh_krz

It is because it doesn't include the additional.css. You can add it manually in the templates.

I will get round to sorting this

[Naijasite]

it does not work with the mobile theme. www.mysite.com/register.php shows blank page.

please how do i fix the error

[K!nG]

I have been getting a lot of errors lately. As far as i can recall last time checked with vb.com and was told to update to latest version and i did and even after that i been getting errors ;

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM userregcode WHERE userregemail = 'georgiana-o'shanassy78@dgkoncept.com.pl';

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 'shanassy78@dgkoncept.com.pl'' at line 1
Error Number : 1064
Request Date : Tuesday, March 11th 2014 @ 07:21:07 PM
Error Date : Tuesday, March 11th 2014 @ 07:21:08 PM
Script : http://www.mysiteXXX.com/register.php
Referrer : http://www.mysiteXXX.com/register.php?
IP Address : 5.255.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

After reading last couple of posts i tried to uninstall and did the fresh install once again just to see if that will fix anything, however when i uninstalled it. I got an error email again which is as follows;

Database error in vBulletin 4.2.2:

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

MySQL Error : Table 'dxxxx_xxxxx.userregcode' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 11th 2014 @ 09:04:55 PM
Error Date : Tuesday, March 11th 2014 @ 09:04:56 PM
Script : http://www.mysiteXXX.com/threads/122...#65533;•
Referrer :
IP Address : 66.249.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :


I do understand 2nd error is for table because i removed it however wants to know what's the proper way to uninstall it in case fresh install still doesn't fix my issue and i ended up uninstalling it or any fix for both of them.

Thanks.