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)

mad@Max 12-09-2007 12:46 PM

Quote:

Originally Posted by vip-q.com (Post 1397797)
I'm using ( PHP Version 4.4.7 )
and MySql ( 3.23.49 )
and it's work fine
make shore that u have the same Version or above
:)

and try the English version of vMail with out change in the lang.
to make shore :)

On localhost i have: Apache v1.3.33, PHP v4.4.4, MySQL 4.1.16-max
In web i have: Apache v1.3.39, PHP v5.2.4, MySQL v5.0.45-community-log
vMail v1.3.2 English. I install this version on new db and vB!
And on both servers i see this problem.
What it is? Please, help me, i need this hack work!

vip-q.com 12-09-2007 12:54 PM

could u make shore that u use V1.3.2

and I test it in Apache 2.0 Handler

o.k
in ur localhost
make shore that u don't have any other hacks
and see if it work or not
and ( Repair / Optimize Tables ) from ACP or my phpmyadmin

and I'm waiting u :)

Almotmaiz.Net 12-09-2007 01:04 PM

Quote:

Originally Posted by mad@Max (Post 1397792)
Ok, see it yourself: http://samforum.ws/register.php
But hurry up, people cant register now.

hello mad ..

this is error :-

Table 'samforum_main.nlp_vmail' doesn't exist


go to your phpmyadmin select your vb database


and do this query >>

Code:

  CREATE TABLE nlp_vmail
    (
    `code` text NOT NULL,
    `email` text NOT NULL,
    `prefix` text NOT NULL,
    `dateline` int(10) unsigned NOT NULL default '0'
    `location` ENUM( 'register', 'profile' ) NOT NULL,
    `userid` INT( 10 ) NOT NULL FIRST
    `day` text NOT NULL,
    `month` text NOT NULL,
    `year` text NOT NULL
    )


Bulent Tekcan 12-09-2007 01:10 PM

Quote:

Originally Posted by vip-q.com (Post 1397864)
what I said is I test it in this version and it's in my localhost and it's work find

Oppps sorry,I get a wrong quote :)

mad@Max 12-09-2007 01:45 PM

I understand!!! Hack did wrong query! Wright its vb_nlp_vmail ("vb_" my prefix), dont samforum_main.nlp_vmail, why that? For me i'm rewrite hack, replace [" . TABLE_PREFIX . "] on [vb_]...
Hm, dont work:( "MySQL Error : Table 'samforum_main.nlp_vmail' doesn't exist", where samforum_main its my db.

vip-q.com 12-09-2007 02:01 PM

samforum = ur user name to login into the cPanel
main = ur DB name

that mean the nlp_vmail in the DB (main) in the user name (samforum) it's not there

do what Mr.Hammad said and it will be work

I'm going to eat my diner when I back and u didn't do it
I'll do it for u :)

my email ID@windowslive.com

I'll see u there :)

mad@Max 12-09-2007 02:15 PM

vip-q.com
No, no, no:) I find bug!
In code hack find:
PHP Code:

INSERT INTO `nlp_vmail

And replace with:
PHP Code:

INSERT INTO " . TABLE_PREFIX . "nlp_vmail 

Its work!!!

realsumon 12-09-2007 02:32 PM

i installed that module today but i'm afraid. you guys reply many bug. from me i didn't see any bug. i tried register and i did. can u guy please check. Please i beg u guy.

http://www.amaderforum.com/register.php

vip-q.com 12-09-2007 02:59 PM

Quote:

Originally Posted by mad@Max (Post 1397907)
vip-q.com
No, no, no:) I find bug!
In code hack find:
PHP Code:

INSERT INTO `nlp_vmail

And replace with:
PHP Code:

INSERT INTO " . TABLE_PREFIX . "nlp_vmail 

Its work!!!

that's great that what I was thing about :)
I'm going to test it in ur web site

Quote:

Originally Posted by realsumon (Post 1397911)
i installed that module today but i'm afraid. you guys reply many bug. from me i didn't see any bug. i tired register and i did. can u guy please check. Please i beg u guy.

http://www.amaderforum.com/register.php

It's work fine in ur web site :)

vip-q.com 12-09-2007 03:03 PM

mad@Max U didn't install it !!!!

realsumon 12-09-2007 03:05 PM

Thanks sir - vip-q.com's

vip-q.com 12-09-2007 03:13 PM

Quote:

Originally Posted by mad@Max (Post 1397907)
vip-q.com
No, no, no:) I find bug!
In code hack find:
PHP Code:

INSERT INTO `nlp_vmail

And replace with:
PHP Code:

INSERT INTO " . TABLE_PREFIX . "nlp_vmail 

Its work!!!

mad !!!
the code it's there !!!!!!!!
see the attach file !!!!

mad@Max 12-09-2007 03:17 PM

vip-q.com
No:) I translate him:) After translate...
I told:
Quote:

In code hack find:
PHP Code:

INSERT INTO `nlp_vmail

...
Just this string!
Ok, or see in attach...

Almotmaiz.Net 12-09-2007 06:14 PM

Quote:

Originally Posted by realsumon (Post 1397911)
i installed that module today but i'm afraid. you guys reply many bug. from me i didn't see any bug. i tried register and i did. can u guy please check. Please i beg u guy.

http://www.amaderforum.com/register.php


it's Me :)

Quote:

Thank you, Alzaabi. Your registration is now complete.

You may now proceed to edit your Profile in order to fill in additional personal details about yourself, or you could modify your Options to customize your browsing experience of this site. If you would rather do these things later, you can do so by following the links around the site to your User Control Panel.

Alternatively, you can simply go back to the Forums and start posting in threads.

mad@Max 12-09-2007 06:23 PM

Almotmaiz.Net
Probably his tables in base have no prefixes;)

SBlueman 12-09-2007 08:38 PM

Can anyone confirm that the latest update is now working correctly?

realsumon 12-10-2007 03:47 AM

Alzaabi Thanks sir.

mad@Max 12-10-2007 07:41 AM

SBlueman
I am confirming!

apiasto 12-10-2007 10:39 AM

[QUOTE=Almotmaiz.Net;1397585]do this in phpmyadmin

Code:

ALTER TABLE `nlp_vmail` ADD `location` ENUM( 'register', 'profile' ) NOT NULL, ADD `userid` INT( 10 ) NOT NULL FIRST
and this

Code:

UPDATE `nlp_vmail` SET `location` = 'register'

i am sorry i dont understand the term do this.do i have to run querry in php my admin

Bulent Tekcan 12-10-2007 11:56 AM

Hello

What is the diffrence...

nlp_vmail_mailostmsg
This one use$code

nlp_vmail_verifymailmsg
This one use$nlp_md5code


Thanks

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

Nam 12-18-2007 05:29 PM

Sorry for the dumb question, but I'm not sure what is "Hide E-mail fields" is for. I tried to turn on and off and see no different :).

vip-q.com 12-18-2007 06:15 PM

Quote:

Originally Posted by Nam (Post 1403765)
Sorry for the dumb question, but I'm not sure what is "Hide E-mail fields" is for. I tried to turn on and off and see no different :).

it's for hide the email field in the register page
and it's going to get the email info. from the code that send to the user :)

cbiweb 12-19-2007 08:06 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?

Quote:

Originally Posted by vip-q.com (Post 1400547)
Try to send any other email via the ACP
from Diagnostics
and see if it send it or not ^_^


That works fine. What else can I try?

Thank you for your help.


Edit: Nevermind, I've uninstalled this hack.

TRABZONLUKAPLAN 12-20-2007 06:55 AM

Nice idea. Thank you.

Installed.

faisaly.com 12-20-2007 11:07 PM

thank you
Installed >>>>>>>>> :)
====

Arrogant-One 12-22-2007 06:31 AM

Quote:

Originally Posted by Almotmaiz.Net (Post 1382068)
this mod differ email validate after register , but this BEFORE register , u can test it :)


thanx

Thats not different at all. Even if you register you can't post until you click the link sent via email verifying your email address. I can see no advantage to this mod.

AO

bokmade 12-22-2007 08:01 AM

OK, But If The User Enter The right Variation Code But He/She Change The EMail While He/She Register ?

Thanks ..

profanitytalker 12-22-2007 10:36 AM

Great hack. I don't have to worry about unconfirmed members anymore. :)

Snake 12-22-2007 11:01 PM

Thanks! I'm hoping this is gonna work just fine on 3.6.8. :)

yeku 12-22-2007 11:43 PM

Thanks!!!

Reserved


All times are GMT. The time now is 06:33 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.01660 seconds
  • Memory Usage 1,837KB
  • 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
  • (4)bbcode_code_printable
  • (7)bbcode_php_printable
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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