Verify Email Before Registration

[da_judge]

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/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 : [B]CSS / FOOTER FIXED !!!

Mobile Theme Fix HERE (https://vborg.vbsupport.ru/showpost.php?p=2545139&postcount=268)

[ForceHSS]

works well

[Krusty1231]

I'll try. Thanks for sharing!

Here is a screen of what the new member will see upon registration.

[kfyonur]

it is perfect.

[ForceHSS]

small typo line 873
The verification code is important, You can not register withou using it.
should be
The verification code is important, You can not register without using it.

and line 875
Make sure to write a correct mail to recive the verification code
should be
Make sure to write the correct email to receive the verification code

[ForceHSS]

line 871
The <b>verification code</b> will be sent to the mail above¡
should be
The <b>verification code</b> will be sent to the mail above.

way to many spelling mistakes or other mistakes in this not going to post them all would be here all day

apart from that works well

[gsmlover4u]

i was waiting this for vb4 from long time

[gsmlover4u]

wocking fine on vb 4.2 and vb 4.1.11

[da_judge]

I will go through code... run spell checker...

[ForceHSS]

I will go through code... run spell checker... as i pointed out not my work :)

np but it is not just the spelling I am sure you will see when you look at the coding

[djbaxter]

- delete -

I was wrong. :o

[v123shine]

can you make this plugin for vb.3.8 ???

[synseal]

It does work but doesn't look right on my style, it doesn't seem to pick up the additional.css for my footer and header.

See pics.

With modification on header and footer does not appear correctly probably due to custom style.

[Hornstar]

This mod isn't needed in vBulletin 4.x.

AdminCP >> Settings >> User Registration Options

Verify Email address in Registration = Yes

This mod is needed as it is different. This mod verifies the email before registration is complete which stops spammers/useless accounts/wrong emails from becoming members and just staying in the unverified email user group.

[vap0r-7]

It does work but doesn't look right on my style, it doesn't seem to pick up the additional.css for my footer and header.

See pics.

With modification on header and footer does not appear correctly probably due to custom style.

Same here

[ForceHSS]

It does work but doesn't look right on my style, it doesn't seem to pick up the additional.css for my footer and header.

See pics.

With modification on header and footer does not appear correctly probably due to custom style.

Looks ok to me and why does it matter it is only used the once it is not like it shows all the time

[vap0r-7]

Looks ok to me and why does it matter it is only used the once it is not like it shows all the time

It completely messes our header and footer up, and even though it is only once when users see it, we do not want to sacrifice our look for a mod that works.

With the site altering that much it could be construed as our site has been hacked.

[vap0r-7]

Disabled until styling issues resolved

[vap0r-7]

It also does not work with the mobile styles

[ForceHSS]

It completely messes our header and footer up, and even though it is only once when users see it, we do not want to sacrifice our look for a mod that works.

With the site altering that much it could be construed as our site has been hacked.

It messes it up because of the bad coding in it I fixed my coding seems to work better now

[vap0r-7]

It messes it up because of the bad coding in it I fixed my coding seems to work better now
Can you go into detail how you fixed it, and is the mobile theme working?

[ForceHSS]

I don't use the mobile so never looked at it. I will pm u mine see if it is any better I am not sure if it will fix your footer problem as I don't have all what you have on your footer

[da_judge]

I will go through it tonight... and repost fixed version ;)

[da_judge]

can you make this plugin for vb.3.8 ???

look for plugin called vmail on vb3... its what you are looking for :)

[da_judge]

Updated !!!!

With thanks to ForceHSS :)

[vap0r-7]

Updated !!!!

With thanks to ForceHSS :)

Ok it is still causing issues, it is not pulling in additional.css on our regular theme and the default mobile theme is blank

Thanks for trying, we will just uninstall.

[gsmlover4u]

its working fine for me on deafault and custom theme

[sweetpotato]

Nice Idea but it does not take care of Facebook user. It should skip Facebook user because verify facebook user is not necessary.

[ForceHSS]

Nice Idea but it does not take care of Facebook user. It should skip Facebook user because verify facebook user is not necessary.

Don't let users register from fb then there is no problem

[djbaxter]

- delete -

I was wrong. :o

[ForceHSS]

Better idea: Don't install this add-on.

That's up to you

[elfenny]

then it works or not?
I'm interested

[ForceHSS]

then it works or not?
I'm interested

yes

[elfenny]

yes
I've installed it. try with kkkkkk@hotmail.com and accept
I think you can not do anything with fake mails...

[da_judge]

I've installed it. try with kkkkkk@hotmail.com and accept
I think you can not do anything with fake mails...

Well no a fake email.. you wont get code needed lol :S

[synseal]

Yes as the other posted it is still the same, header and footer doesn't read the additional.css so it looks a bit naf.

Shame as this would be very handy.

[da_judge]

Sorry guys been really busy...

Will get it working 'better'

:)

[Guru Samrat]

dear coader can provide this vb 4.0.3 ?????? plz reply

[ForceHSS]

dear coader can provide this vb 4.0.3 ?????? plz reply

have you tried installing it to see if it works for 4.0.3

[goxy63]

Looks like in registration form after installing this modification "Receive Email from Administrators" is not ticked by default ?

Maybe I changed something in VB options, but I don't remember that I did

Someone else have same problem, its not a big deal but...

Installed, rated, great mod

Thank you

[dollar1]

Is anyone else still having style issues?

[ForceHSS]

Is anyone else still having style issues?

No, must be only you

[Bluemax712]

To help cut down on temp email addresses
could this Mod be extended to send out a 2nd email a few days later.

Initially after signing up and then confirming email
users will be placed in the "Email Registered " group
with some limited permissions

Then 3 days later - send out 2nd email confirmation
to place them in the "Fully Qualified Email" group?

[RichieBoy67]

CSS is still messed up..

[da_judge]

CSS is only cosmetics... i will fix.. had few personal issues... but give me some time to fix... it works though :D

[goxy63]

Ya, it works great.
Nominated, this option should be default in VB. Thanks once again.

[shots]

This is a great mod! Only thing missing is logging. Nominated!

[RFViet]

I'm using vB4.2 p3 and having problem with this mod. After providing email address it sends me back to the beginning like a loop. Anyone knows what problem is ?

[TheSupportForum]

I'm using vB4.2 p3 and having problem with this mod. After providing email address it sends me back to the beginning like a loop. Anyone knows what problem is ?

it works fine with it, i am using vb 4.2 p3 myself, maybe you have a product that interferer, or you haven't enable the required option in admincp for it to work as designed too

[PrivateFTA]

does not work with gmail.com

[ForceHSS]

does not work with gmail.com

works on mine, make sure you dont have email in your blocked list

[da_judge]

CSS / Styles all working now guys... check updates ;)

Sorry for delay been busy

[ForceHSS]

CSS / Styles all working now guys... check updates ;)

Sorry for delay been busy

Never had a problem with that. Could be because I fixed that problem in the first version just forgot to give it to you

[vinkodante]

This mod is so interesting but need screenshots demo :)

[da_judge]

This mod is so interesting but need screenshots demo :)

Added as requested ;)

[DoumDoum5058]

Hi,

its working fine for me on VBulletin 4.2.1
Thanks you da_judge for this work
Nominated!

[tanzeelniazi]

thanks for the Update

[readjono]

Still having styling problems and also my custom URL I tried prevented me from registering so not much use.

[da_judge]

Still having styling problems and also my custom URL I tried prevented me from registering so not much use.

PM me m8 issues.. more info ie screen shots i will have a look for u :)

[civicf]

I have problem with this mod after upgrade vbulletin to version 4.2.1.
If users try change email address don't see input box for code (email code was sent to new address).
I don't have idea where is problem.

[ForceHSS]

I have a problem with this mod after upgrade vbulletin to version 4.2.1.
If users try to change their email address I don't see an input box for the code (email code was sent to the new address).
I don't have any idea where the problem is.

Once you put new email then click save changes the box comes up you don't see that. Screenshot to show what it looks like. I am also running 4.2.1 works for me.

[Light Peak]

causes broken SSL at register.php

[da_judge]

causes broken SSL at register.php

Why do u need SSL to register lol

[da_judge]

I have problem with this mod after upgrade vbulletin to version 4.2.1.
If users try change email address don't see input box for code (email code was sent to new address).
I don't have idea where is problem.

Try reinstall and make sure u over write button selected ;)

[Light Peak]

Why do u need SSL to register lol

why not? i implemented full ssl for all my sites

[da_judge]

why not? i implemented full ssl for all my sites

vbulletin and apache will still show same info so why lol.. makes no sence at all.. you been miss advisded

[Light Peak]

vbulletin and apache will still show same info so why lol.. makes no sence at all.. you been miss advisded

and by saying "will still show same info", what'd you mean? if Google search implements ssl even for their search engine and Facebook can implement ssl for their sites, are they mis-advised too?

[da_judge]

thing is... you aint google or facebook... you carry on sir ;) but not really needed on vbulletin site

[root2012]

top mod unfortunately moved header and fodder broken
vb4.2

[ForceHSS]

top mod unfortunately moved header and fodder broken
vb4.2

Dont see anything boken in that ss

[jompom]

any luck to get this for vb5 ?

[smirkley]

I have a question....

I have my vb instance set for cron emails and metered, and vb automatically sends registration and password request instantly regardless of this setting as a normal process of vb.

Does this mod follow this standard?

[Code Geass]

Can you Add Captcha ( Image Verification) when someone want to register to stop spamming & sending emails for nothing

Here in This Add Captcha !
https://vborg.vbsupport.ru/attachment.php?attachmentid=144936&d=1368221692

[mikez006]

Can you Add Captcha ( Image Verification) when someone want to register to stop spamming & sending emails for nothing

Here in This Add Captcha !
https://vborg.vbsupport.ru/attachment.php?attachmentid=144936&d=1368221692

thats a great idea!

[da_judge]

Can you Add Captcha ( Image Verification) when someone want to register to stop spamming & sending emails for nothing

Here in This Add Captcha !
https://vborg.vbsupport.ru/attachment.php?attachmentid=144936&d=1368221692

I cant see why this would be needed... it stops spamming as bots dont get this system lol

[puertoblack2003]

I cant see why this would be needed... it stops spamming as bots dont get this system lol

no it's happening to me as well. i had to filter my email so i don't get that undeliverable email address.

[smirkley]

Bots like muling vB, I cannot use send email to friend feature for the same reasons.

And if you are getting undeliverable emails returned due to above, or this mod, you must be very careful as your ip and domain may end up on blacklists.

[mikez006]

basically what smirkley said. bots will enter thousands of emails into the form and even though no accounts are created, hotmail, gmail, yahoo, etc will see a massive amount of emails being sent by your server and will assume you're spamming. Then you're site and IP will get blacklisted.

This mod needs a good Captcha system on the first step to prevent that type of abuse.

[smirkley]

Or at least a system that conforms with your human verification settings in ACP.

[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.

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

[crazyboy1661]

Hello da_judge, can you please help me!

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.

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]

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]

does this mod use Keycaptcha by any chance???

[smirkley]

No, it doesnt use any human verification options.

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

[Ary Braga]

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.

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.


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]

Bro. make this.

Open notepad and

Copy and paste this code below.


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? :confused:

[ForceHSS]

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.

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

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
DROP TABLE IF EXISTS `userregcode`;
This will fix your problem

[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.

You are not authorized to execute SQL queries

Bro. make this.

Open notepad and

Copy and paste this code below.


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]

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.

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]

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 :)

[LgsOfChampions]

I really want to use this mod, I get this when I use it. Is there a way to fix this or should i delete it?

[ForceHSS]

I really want to use this mod, I get this when I use it. Is there a way to fix this or should i delete it?

If you are talking about the example link thing on the footer thats from a custom mod and you would need to ask in that mod how to hide it in that page

[da_judge]

I really want to use this mod, I get this when I use it. Is there a way to fix this or should i delete it?

You have CSS issue there... must be using custom css somewhere...

i updated it a while back to work with most default CSS... pm me your skype i will try help you ;)

[Light Peak]

please add in recaptcha/keycaptcha before sending mails to prevent ip being blackholed/blacklisted by remote servers.

[Bubble #5]

I seem to be having issues with this mod NOT forwarding the persons birthdate.

After they register and you go into ACP > Users and look them up, their birthdate is not recorded. Can someone please look into this?

[fly]

Tagged in case CAPTCHA is added. Excellent idea tho.

[Bubble #5]

Tagged in case CAPTCHA is added. Excellent idea tho.

There's already CAPTCHA in registration. Why would you want it twice? :confused:

[fly]

There's already CAPTCHA in registration. Why would you want it twice? :confused:

Read the thread. You'll get a ton of bots signing up. Then your server sends out a ton of bad email. Then you get blacklisted. Not good...

[Bubble #5]

Read the thread. You'll get a ton of bots signing. Then your server sends out a ton of bad email. Then you get blacklisted. Not good...

OK pardon me for my ignorance, but why would a bot want to register on a forum?

How can you tell if its a bot that registered, verses a person?

I have noticed that almost everyone that has signed up since this has been installed does not have a birth date registered, could those be bots?

How are they getting pass the built-in captcha? :confused:

[smirkley]

There are millions of spam-bots that go out and look for cataloged registration mechanisms they can exploit and register, same bots can also post posts as well as inject home page links in accounts. The bot senders can send these out much more effeciently that human spammers.

You really cant tell if they are bots, but after awhile you tend to be able to recognise them.

The birthdays dont necessarily mean anything.

The built-in captcha, even recaptcha, is flawed and bots can brute force them or recognise the captcha text to get in.

If you have used vbresults spam blocker, you can see that most bots register in 5 seconds or less. Can you type that fast on the registration form?

[fly]

OK pardon me for my ignorance, but why would a bot want to register on a forum?

How can you tell if its a bot that registered, verses a person?

I have noticed that almost everyone that has signed up since this has been installed does not have a birth date registered, could those be bots?

How are they getting pass the built-in captcha? :confused:

I don't care why they want to. They are.

And there is no built in CAPTCHA with this mod. So if I were to install it, I'd be sending out a ton of email that would bounce, which is bad for me.

[crazyboy1661]

Hello da_judge, can you please help me!

I am getting the same error. I don't know where is the Mistake? I am missing this MOD.

[Disco_Dave]

Does this mod work ok with this mod: Rename register.php by BOP5 (https://vborg.vbsupport.ru/showthread.php?t=297834)?

[ForceHSS]

Does this mod work ok with this mod: Rename register.php by BOP5 (https://vborg.vbsupport.ru/showthread.php?t=297834)?
Yes but you need to rename the register.php in the xml

[Bubble #5]

Does this mod work ok with this mod: Rename register.php by BOP5 (https://vborg.vbsupport.ru/showthread.php?t=297834)?

Both are working fine on my site using 4.2.1.

[hoplomachus]

I just moved my site and get a Database error. When I enable it, i cannot access my forums but I cannot uninstall it.. only disable it. But when I disable it, my site works fine. If anyone can give assistance, it would be greatly appreciated. Thank you!

Database error in vBulletin 4.2.1:

Invalid SQL:
DROP TABLE userregcode;;

MySQL Error : Unknown table 'userregcode'
Error Number : 1051
Request Date : Thursday, September 26th 2013 @ 06:40:39 PM
Error Date : Thursday, September 26th 2013 @ 06:40:39 PM
Script : admincp/plugin.php?do=productkill
Referrer : admincp/plugin.php?do=productdelete&productid=verfiy_email_bb4_reg&s=
IP Address : XXX
Username : XXX
Classname : vB_Database
MySQL Version : 5.5.30-30.2

[ForceHSS]

Try installing it again

[hoplomachus]

I did reinstall it, but same thing above. It gives me the DB error.

[hoplomachus]

Database error in vBulletin 4.2.1:

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

MySQL Error : Table 'database.userregcode' doesn't exist
Error Number : 1146
Request Date : Thursday, September 26th 2013 @ 07:04:47 PM
Error Date : Thursday, September 26th 2013 @ 07:04:47 PM
Script : xxx/forum.php
Referrer : xxx/content.php
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.5.30-30.2

[ozzy47]

I did reinstall it, but same thing above. It gives me the DB error.

Are you using the English version?

[ForceHSS]

run this query from your admin cp

CREATE TABLE `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;


and if it says it is already there run this
DROP TABLE IF EXISTS `userregcode`;

[hoplomachus]

first one stated this... have not ran the second one...

Affected Rows: 0 (0.0186s)

[hoplomachus]

it worked! Love you man. Thanks for your help!

[ForceHSS]

Happy to help

[civicf]

Once you put new email then click save changes the box comes up you don't see that. Screenshot to show what it looks like. I am also running 4.2.1 works for me.

After click save changes I don't see box. Please see my screenshot.

146669

I have tried fixing mod by uninstall and reinstall that didn't work. I still get the same problem.
I have tried analyzing source code and compare it with another forum but I don't see any diffierences.

[ForceHSS]

After click save changes I don't see box. Please see my screenshot.

146669

I have tried fixing mod by uninstall and reinstall that didn't work. I still get the same problem.
I have tried analyzing source code and compare it with another forum but I don't see any diffierences.

It only comes up when you try to change your email or password

[civicf]

It only comes up when you try to change your email or password

Yes, I know. If I will change email nothing happens when I clik save button . I recivied code to my new email but I don't see box to enter it. When I will enter wrong password I get error messegae from java script code.
I don't have idea how I can debug this mod.

[da_judge]

Yes, I know. If I will change email nothing happens when I clik save button . I recivied code to my new email but I don't see box to enter it. When I will enter wrong password I get error messegae from java script code.
I don't have idea how I can debug this mod.

are you using ie10 by any chance ?

[webspider]

This is a great mod and has really reduced problem registrations.

Can I suggest that you incorporate the "Banned Email Addresses" prior to the email form is sent.

[da_judge]

This is a great mod and has really reduced problem registrations.

Can I suggest that you incorporate the "Banned Email Addresses" prior to the email form is sent.

They cant join if banned email..

[webspider]

But the bad email is still sent and the return failed error messages occur for days.

[NAZIA]

It is working thanks..
hope, In sha Allah, it will stop bulk registration at my forum..

[john7911]

Thank you for sharing ;)

[Lightly_Toasted]

Have had this mod installed for quite sometime, tried others but by far this has worked the best on my forum!

LT

[da_judge]

But the bad email is still sent and the return failed error messages occur for days.

you have forum set up wrong then m8 ;)

[leemart44]

Best spammer stopper ever, no more having to use Stop forum spam

[ForceHSS]

Best spammer stopper ever, no more having to use Stop forum spam
this plugin does not stop spammers registering on your forums

[da_judge]

i just stops the members awaiting email... if they get no email... no join :)

[ForceHSS]

i just stops the members awaiting email... if they get no email... no join :)
There are 1000's of spammers out there that can confirm their email this alone won't stop them

[maupassant]

I have just installed the product. When I go to AdminCP > Settings > Options, there is no "Verify Mail Before Registration" listed.

vBulletin version : 4.2.2

[WEBDosser]

I have just installed the product. When I go to AdminCP > Settings > Options, there is no "Verify Mail Before Registration" listed.

vBulletin version : 4.2.2

There is for me and I use 4.2.2?.

[maupassant]

Too bad. I assume there must be a conflict with another mod I have installed.

[shots]

Is there a way to add human verification to this to help reduce the bot initiated bounce backs?

EDT: BTW, working fine for me on 4.2.2... other things are not working (quickreply) but that is not the fault of the addon
EDT2: I would be willing to pay a bounty to get the built in Human verification system working with this addon... anyone else willing to pitch in?
EDT3: I would also love to see a loggin feature similar to the Stop Form Spam addon that lists date/time, email address attempted, and ipadress. That way as people try to use bogus addresses we can ban ip's. I would put this after human verification in priority of features added.

[BirdOPrey5]

Mod restored from quarantine- all new downloads in first post.

[maupassant]

I have just installed the product. When I go to AdminCP > Settings > Options, there is no "Verify Mail Before Registration" listed.

vBulletin version : 4.2.2

And now it works. :)

[goxy63]

Updated to latest version 2.0.6 works...
Only in adminCP it still says 2.0.5 version

[da_judge]

hahaha i forgot to update that part.. ignore m8

[ForceHSS]

Have some fixes to the latest xml if you want me to pm u a link to it

[funkyirishman]

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

[shots]

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

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?

[da_judge]

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

[funkyirishman]

Thanks

How do you remove the old one?

[tanzeelniazi]

I install but my footer links showing not correctly

[bennzy]

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.

[Alibass]

Uninstalled until some sort of recaptcha is integrated with mod.

[ForceHSS]

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

[shots]

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...

[josh_krz]

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:

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.

[ForceHSS]

All 3 options do what they say for me

[josh_krz]

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.

[ForceHSS]

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]

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]

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]

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]

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]

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 :D

[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/12271-��?*(?-�?)*?-Congrats-Dictator-on-8-000-Po-ts�?*(�?-?)*��•
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.

[ForceHSS]

Have you tried uninstalling it from the plugin manager? Dont understand why you would delete that table for

[K!nG]

I didn't delete the table. All i did is went to Plugin manager and uninstalled it and the moment i uninstalled i got 2nd error email in my inbox and when i said "I do understand 2nd error is for table because i removed it ..... " Sorry i meant to say removed the mod not the table. I guess that made a confusion may be ?

anyways hope its clear now.

[ForceHSS]

For some reason it did not install the table when first installed or got removed will give you a sql to install it but first try to install it again over writing it

Go to admincp/Maintenance/Execute SQL Query
In the Manual Query box, put the code below
First, make sure you have added your userid to the config file
Login to your FTP (https://filezilla-project.org/) to to includes/config.php file, download it to your desktop, open it with notepad ++ (http://notepad-plus-plus.org/download/v6.5.5.html) find the line
$config['SpecialUsers']['canrunqueries'] = '1'; default is 1 but change or add to it if your userid is different like this
$config['SpecialUsers']['canrunqueries'] = '1,2';
Then run this

DROP TABLE IF EXISTS `userregcode`;

Then this after

CREATE TABLE `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

[john7911]

Thanks for sharing ;)

[angeljs]

Very, very pleased with this mod...the one I one using on my old vb3 forums didn't work so I was reluctant to try it. So glad I did as it works perfectly! Thank you. :)

[K!nG]

Hi,

This mod is interfering with mobile devices on my forum. When on mobile device and if someone click on REGISTER only get blank/white page and nothing else.

In this thread;
https://vborg.vbsupport.ru/showthread.php?p=2493584#post2493584

I asked for help and found out this mod was causing it and when i disabled it, now i do see proper registration page on mobile devices as well.

Thanks

[ForceHSS]

Are you useing forumrunner, some other software or default mobile skin

[K!nG]

I also have tapatalk option available for mobile devices. This happens on default mobile skin.

[ForceHSS]

So are you using tapatalk and forum runner at the same time?

[K!nG]

Sorry for making myself not clear. No i am not running forum runner at all. It's disabled.
Believe it or not in past 2 months i barely had 2-3 spammers, but in past 2 hours since i disabled this mod i had 19 spammers/bots (whatever you wanna call them) registered. So i will definitely love to have this mod if we can sort this out.

Thanks.

[ForceHSS]

As tapatalk is a stand alone plugin you would need to talk to them about problems with there plugin. Also a screenshot of what you have set for mobile styles if you could upload and the settings for this mod but even know all settings might be correct the first part of my post still stands

[K!nG]

Hi Force,

Here is what i just did. I completely removed tapatalk.
Enabled "Verify Email before registration"
Now i tried to register and blank page again. So this makes it a bit clear that it wasn't tapatalk.

[ForceHSS]

Do you have default style still installed and are allowing uses the option to pick it

[K!nG]

Yes. Here are my settings.

https://vborg.vbsupport.ru/external/2014/04/31.jpg

[synseal]

Something I noticed earlier in your other thread (k!ng) is that when you enable this modification your URL for the registration page changes.

Your registration page with this modification turned off is the normal registration page

yourforum/register.php

With the modification enabled I remember it being something like this

yourforum/register.phpf1b0f2ba94a2db504cf33b29ab5314f5

Could that be causing this issue?

[K!nG]

Hmmm that's a bit weird because i just tried with mod being enabled & disabled and in both ways it goes to myforum.com/register.php, however like you suggested in other thread when i disable this mod. Registration on mobile works fine.

[ForceHSS]

Yes. Here are my settings.

https://vborg.vbsupport.ru/external/2014/04/31.jpg

Try old moble to none
Even know without looking closer to your forums its hard to know
Can you post some ss of your tapatalk settings

[K!nG]

Try old moble to none
Even know without looking closer to your forums its hard to know
Can you post some ss of your tapatalk settings

Hi Force,

I just tried old mobile option to None and still the same issue. I have completely removed tapatalk from my forum.

[ForceHSS]

Read pm sent

[K!nG]

That still didn't resolve my issue. I would hate to let go of this mod, but i guess that will be my last resort. :(

[ForceHSS]

This mod will not stop spammers use this one https://vborg.vbsupport.ru/showthread.php?t=294633

[K!nG]

I won't disagree with you, but for me this mod was a life saver. Like i said earlier in past 3-4 months i barely had 5 false registrations, but since yesterday number is over 50. lol

[EliasAlucard]

I agree with K!nG, this plugin definitely helps against spammers. It's not bulletproof, but it makes a huge difference. This one is also excellent against spambots:

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

But it too, doesn't detect every spambot, and sometimes, it blocks legitimate usernames from registering because it was commonly used by some spambot.

[Naijasite]

it dose not work with mobile style. site.com/register.php is blank.... how can i fix this error.

[K4GAP]

I agree with K!nG, this plugin definitely helps against spammers. It's not bulletproof, but it makes a huge difference. This one is also excellent against spambots:

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

But it too, doesn't detect every spambot, and sometimes, it blocks legitimate usernames from registering because it was commonly used by some spambot.

Amen! same here.
No comparison should even be considered. It DOES NOT hurt to have layers of security. No ONE process is going to be the absolute cure.

This is just another level to help keep the low lifes from succeeding in whatever it is they plan on doing by gaining access to your site.

[hterrag]

Working great on 4.2.0!

[da_judge]

I will be working on human verification in next few weeks... i cant give time line... so dont nag me... im busy :P

[da_judge]

it dose not work with mobile style. site.com/register.php is blank.... how can i fix this error.


I guess it didnt install the required template... send me a backup of your mobile theme i will have a look for you ;)

[warrichpk@gmail]

I tried it but users were not getting email code.
will you help me?

[ForceHSS]

I tried it, but users were not getting email code.
Will you help me?
Hard to help without looking at your site admincp and see where the problem is

[da_judge]

I tried it but users were not getting email code.
will you help me?

Thats to do with your mail server...

Goto

Admincp > Maintenance > Diagnostics

Then in Email section put email address of your email and test it..

[DreadsUK]

I believe its all installed correctly but for some reason, people are still able to register and post/create threads without verifying email at all. Do i have an incorrect setting

https://vborg.vbsupport.ru/external/2014/06/4.png
https://vborg.vbsupport.ru/external/2014/06/5.png

[da_judge]

verify mail provider before sending needs to be yes ;)

[Inferno Dragon]

I am having an issue with this modification, spam bots started to target my registration form and today my whole server went down because someone spammed the "verify email before registration mod" as there's no captcha or flood protection available in the two displayed fields i-e email and verify email and sent about 10,000+ fake emails. :(

I liked this mod, is there anyway we can add captach support on the initial registration page or a flood control?

[badawidollah]

hello,
not work in vb 4.2.2 patch level 1

[ForceHSS]

hello,
not work in vb 4.2.2 patch level 1
Works for me

[da_judge]

I am having an issue with this modification, spam bots started to target my registration form and today my whole server went down because someone spammed the "verify email before registration mod" as there's no captcha or flood protection available in the two displayed fields i-e email and verify email and sent about 10,000+ fake emails. :(

I liked this mod, is there anyway we can add captach support on the initial registration page or a flood control?

Im working on that ;)

hello,
not work in vb 4.2.2 patch level 1

Works perfect for me and many others... what error are you getting :)

[Dave]

This mod is vulnerable > SQL injection.
I PMed the author of this mod and reported this mod, if no action is being taken, I will publish the vulnerability with a CVE.

[BirdOPrey5]

The mod has been restored from quarantine. Please be sure to upgrade to the latest version. The mod author was quick to issue a fix- I was a little backed up and didn't get a chance to review it until today- sorry for the delay.

[root2012]

would the SQL injection eliminated now?

[ozzy47]

Yes, that is why it is out of quarantine.

[goxy63]

@da_judge thanks for update, great mod

thanks guys

cheers

[da_judge]

This mod is vulnerable > SQL injection.
I PMed the author of this mod and reported this mod, if no action is being taken, I will publish the vulnerability with a CVE.

Many thanks dave for your help ;)

Should all be good now..

[fxdigi-cash]

Thanks for the update. I get an error message when I insert the verification code in the registration form.

I go to my mail box to click the verification code and it says that the link is incorrect or used an old link...

when I copy the code from the email and insert it directly into the registration form and finish the rest of the fields there and click complete registration, I get again the same message that verification code is incorrect!!

any idea what is wrong in here???

Update: I just noticed that the previous version works fine English Verify Mail before registration vb4_v2.0.6, but the latest version vb4_v2.0.7 doesn't seem to work since it causes issues with verification code being incorrect!!

is there a solution for this??

[da_judge]

Thanks for the update. I get an error message when I insert the verification code in the registration form.

I go to my mail box to click the verification code and it says that the link is incorrect or used an old link...

when I copy the code from the email and insert it directly into the registration form and finish the rest of the fields there and click complete registration, I get again the same message that verification code is incorrect!!

any idea what is wrong in here???

Update: I just noticed that the previous version works fine English Verify Mail before registration vb4_v2.0.6, but the latest version vb4_v2.0.7 doesn't seem to work since it causes issues with verification code being incorrect!!

is there a solution for this??

did you uninstall old version 1st... if not i suggest that PM me if you still having issues mate

[stevieb]

Looks good. :)

[Paul Butler]

Does this work alongside Spam-o-matic?

[ozzy47]

Yes it should work without any issues. :)

[Paul Butler]

Yes it should work without any issues. :)Top man, thank you.

[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?

[da_judge]

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]

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?go=ranking&order=asc&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]

@K!nG

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

[ForceHSS]

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?go=ranking&order=asc&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]

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]

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]

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]

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

https://vborg.vbsupport.ru/external/2014/11/10.jpg

Any help will be appreciated.

Thanks.

[da_judge]

do check from phpmyadmin :D

[da_judge]

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

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

Let me know ;)

[Alibass]

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

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

Let me know ;)
What's different, I might be interested.

[da_judge]

BOP5's plugin allows you to change the name of register.php to anything you like.. thus stops auto reg bots even more ;)

[Alibass]

BOP5's plugin allows you to change the name of register.php to anything you like.. thus stops auto reg bots even more ;)
Thanks I already have that installed. Your post made it sound like you had modified it.

[YOODA230]

uninstall read here
http://www.exploit-db.com/exploits/34717/

[ozzy47]

That was already reported, and has been fixed on th 28th of September.

[Normal]

I still have problem with header and footer in my style I am use the last one v2.0.7, I am not sure how can fix it! There any one can be help. to told me how to fix the problem with header and footer..

Thanks

[da_judge]

I still have problem with header and footer in my style I am use the last one v2.0.7, I am not sure how can fix it! There any one can be help. to told me how to fix the problem with header and footer..

Thanks

PM me bud, i will help you :D

[da_judge]

Thanks I already have that installed. Your post made it sound like you had modified it.

I have and it works.. its a simple edit.. will add to the plugin home page ;)

[da_judge]

fixed with BOP5 rename register.php rename :)

[JesWhite]

i have css problem:(((

[da_judge]

im guessing footer... you have custom skin.. i will look at it as see if i can improve

[da_judge]

Fixed footer/css issue.. version 2.0.8 should be fine now.. let me know of any issues you may have

da_judge

[Delfi_r]

It's possible to translate this mod?

[ozzy47]

Sure, edit the phrases.

[Delfi_r]

I'v installed it and didn't found the product phrases, or I were missing something?

[ForceHSS]

I'v installed it and didn't found the product phrases, or I were missing something?
Edit the xml with notepad++ and change them there

phrases[0] = "{vb:rawphrase emailalreadyregisterd}";
phrases[1] = "{vb:rawphrase you_cant_leave_this_field_empty}";
phrases[2] = "{vb:rawphrase invalid_email_form}";
phrases[3] = "{vb:rawphrase emails_do_not_match}";
phrases[4] = "{vb:rawphrase youhaveuseditall}";
phrases[5] = "vb:rawphrase reg_ver_confirm_code}";
phrases[6] = "{vb:rawphrase badpasswordspecified}";
phrases[7] = "{vb:rawphrase youhaveuseditallsame}";
phrases[8] = "{vb:rawphrase pingerror}";
phrases[9] = "{vb:rawphrase messagehasbeensent}";
phrases[10] = "{vb:rawphrase emailalreadyregisterd}";
phrases[11] = "{vb:rawphrase emailalreadyusednotconfirmed}";

[Delfi_r]

there is another: your_emailconfirmationcode_x_y_z

I'll post the spanish language file

[ForceHSS]

there is another: your_emailconfirmationcode_x_y_z

I'll post the spanish language file
I only gave you samples of some you will need to go over the whole file and find them all
here is another
your_emailconfirmationcode_x_y_z_profile
you will find many from line 843 to 917

[Delfi_r]

I've completed as long I have found them. The configuration phrases are included

[ForceHSS]

I've completed as long I have found them. The configuration phrases are included
You have missed a lot not sure if that is what you wanted to do, but many phrases have not been changed to your language

[Alibass]

@da_judge

I don't see register.php on the line of reg_ver_start

I'm using 4.2.2 PL4

[da_judge]

@da_judge

I don't see register.php on the line of reg_ver_start

I'm using 4.2.2 PL4

Assuming you are using Rename register.php by BOP5

in reg_ver_start look fot this line

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

change register.php to what you have chosen ;)

[Alibass]

Assuming you are using Rename register.php by BOP5

in reg_ver_start look fot this line

<form id="registerform" action="register.php" name="register" method="post">change register.php to what you have chosen ;)
Thanks mate, I found it on line 338 which is a long ways from line 818 when you're searching for reg_ver_start using notepad++
I didn't see anything around that line [338] that was remotely close to reg_ver_start
Guess I could have searched for all the register.php and replace those but was focus on the other. :erm:

[Delfi_r]

You have missed a lot not sure if that is what you wanted to do, but many phrases have not been changed to your language

Sorry I was tired.

There is something more complete as long as I can see. I can't find how you have coded the pull-down menus (boolean is good but Days/Months... sould have phrases).

With a language file it's easy to update the mod if it's the case.

[ForceHSS]

Sorry I was tired.

There is something more complete as long as I can see. I can't find how you have coded the pull-down menus (boolean is good but Days/Months... sould have phrases).

With a language file it's easy to update the mod if it's the case.
The only thing you have done is messed up the coding and it is still English

[Alibass]

Assuming you are using Rename register.php by BOP5

in reg_ver_start look fot this line

<form id="registerform" action="register.php" name="register" method="post">change register.php to what you have chosen ;)
Perhaps it would be a little less confusing if you would post these two lines in your first post. :)
Line 338: <form id="registerform" action="register.php" name="register" method="post">

Line 833: $vboptions[bburl]/register.php?so=1&emailcode=$emailcodeI found the second line without any problems, it was the first line I couldn't find by your instructions in your first post. Cheers and thanks again for the quick reply and this great mod.

[da_judge]

tbh all you had to do was search register.php in templates... i was making it easier :s

[Delfi_r]

Pleas forgive my errors, Now I expect all is right, the language file for spanish

[Alibass]

@da_judge

Seems there maybe a bug in 2.0.8

When you register with your email address but do not finish registration and comeback at a later time and enter your email address again the system gives you the error message:

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

You also get the options to have the code sent again and "I found the code, Thank you". If you click on the I found the code again and go to the registration form the

"Receive Email from Administrators" has become unchecked even though you have it defaulted in registration options to be checked during registration.

[da_judge]

@da_judge

Seems there maybe a bug in 2.0.8

When you register with your email address but do not finish registration and comeback at a later time and enter your email address again the system gives you the error message:

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

You also get the options to have the code sent again and "I found the code, Thank you". If you click on the I found the code again and go to the registration form the

"Receive Email from Administrators" has become unchecked even though you have it defaulted in registration options to be checked during registration.

Why would you start to register then come back later lol.. i just registered.. only issue i found was all your emails go to spam... thats not a fault in the plugin... it means your email is blacklisted by hotmail ;)