The Arcive of Official vBulletin Modifications Site.

vMail - Verify Mail before registration. · **Released**: 11-13-2007

this product can be founded in this thread https://vborg.vbsupport.ru/showthread.php?t=201466

realsumon · #**182** 12-10-2007, 01:48 PM

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT code, email, prefix FROM nlp_vmail WHERE  email = '&lt;script language='javascript'&gt;' AND location='register';

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 'javascript'&gt;' AND location='register'' at line 1
Error Number : 1064
Date         : Monday, December 10th 2007 @ 08:55:23 AM
Script       : ****
Referrer     : ***
IP Address   : ***
Username     : &lt;script language='javascript'&gt;
Classname    : vB_Database

Today i got that email - database error. can anybody tell me please. how to fix it.

Still user can register. i received that error from one ip. did he tried to do something.

vip-q.com · #**183** 12-10-2007, 03:20 PM

He is trying to use javascript code in the e-mail filed

the problem from the user himself

realsumon · #**184** 12-10-2007, 03:26 PM

yeah u are right. after that error still user can register. so i think that stupid have own problem. Thanks vip-q.com's for reply.

T?RKMEN · #**185** 12-11-2007, 12:48 PM

Thanks

cbiweb · #**186** 12-13-2007, 03:25 PM

Nice hack, but it's not sending the verification code. I've been waiting almost 30 minutes but it hasn't come yet. Any idea what's wrong?

vip-q.com · #**187** 12-13-2007, 05:44 PM

Quote:

Originally Posted by cbiweb

Nice hack, but it's not sending the verification code. I've been waiting almost 30 minutes but it hasn't come yet. Any idea what's wrong?

Try to send any other email via the ACP
from Diagnostics
and see if it send it or not ^_^

realsumon · #**188** 12-13-2007, 06:32 PM

Only Problem with HOTMAIL. it's not script problem - hotmail to hotmail - email send junk. so user confused where is email. Next update one suggestion - Please add that line -

Hotmail user please check - Junk Box

Note: when i installed that module .. i had 19,000 Register members. now i have 20k+ register member - means that script working perfect without bug.

oatsy · #**189** 12-13-2007, 08:12 PM

Tried a previous version of this but was getting a db error. This one went straight in. I've been getting 10 fake email registrations a day for the last 4 weeks, so I'm REALLY looking forward to this saving a lot of admin.

Thanks

fringehead · #**190** 12-13-2007, 08:15 PM

I find most my spammers are validating their emails... I am not using this mod but it's a cool idea for all the bad email address users!

Sean

oatsy · #**191** 12-18-2007, 12:08 PM

Quote:

Originally Posted by oatsy

Tried a previous version of this but was getting a db error. This one went straight in. I've been getting 10 fake email registrations a day for the last 4 weeks, so I'm REALLY looking forward to this saving a lot of admin.

Thanks

Had it installed for 5 days now and haven't had a single spammer register since it went in. Genuine users still registering each day, so job done so far. i.e. one less time wasting job to do.

Voted for it in MOTM poll

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04880 seconds Memory Usage 2,306KB 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 (1)bbcode_code (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete 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:

The Arcive of Official vBulletin Modifications Site.

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