vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - vMail - Verify Mail before registration. (https://vborg.vbsupport.ru/showthread.php?t=162642)

realsumon 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 = '<script language='javascript'>' 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'>' AND location='register'' at line 1
Error Number : 1064
Date        : Monday, December 10th 2007 @ 08:55:23 AM
Script      : ****
Referrer    : ***
IP Address  : ***
Username    : <script language='javascript'>
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 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 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 12-11-2007 12:48 PM

Thanks

cbiweb 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 12-13-2007 05:44 PM

Quote:

Originally Posted by cbiweb (Post 1400500)
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 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 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 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 12-18-2007 12:08 PM

Quote:

Originally Posted by oatsy (Post 1400613)
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


All times are GMT. The time now is 08:07 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01316 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete