vb.org Archive - [HTL] and [Normal] Save Prior Email

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - [HTL] and [Normal] Save Prior Email (https://vborg.vbsupport.ru/showthread.php?t=63745)

[HTL] and [Normal] Save Prior Email

Save Prior Email
Version: v1.0.1
vB-version: 3.0.0
Developer: Glenn H. Shelton III
Install difficulty: Easy
File edits: 3
Template edits: 0

Description of the Hack:
This hack allows you to save the prior email address of a user when they change it. This is one of the largest missing features I have found in vBulletin.

The issue I fought with is a user signing up using a legit email, trash posting, then changing the email address to a non-legit email account. This locks

them out as they can not activate the account, however, it does not let you find them easily. This will allow you to have a "legit" contact method.

Bug Fixes 04-11-2004
===========
Changed the original code to stop the "emailold" from being overwritten if the user was in "Awaiting Email Confirmation" group.

Files Have been updated.

HACK INSTALLATION DETAILS:
Files modified for this Hack:
profile.php
admin/user.php

New DB columns for this Hack:
user

Remember: If you use it, please click install! :)

Quote:

Originally Posted by AN-net

great idea!

Thank You.

I added a screen grab above.

Def. a good hack, I'll be installing this once I get my board ready. :)

What if the user changes their e-mail constantly? Does the original e-mail stay or is it over-written?

Quote:

Originally Posted by assassingod

What if the user changes their e-mail constantly? Does the original e-mail stay or is it over-written?

good question. I installed it anyways. :) it's a good addition

Quote:

Originally Posted by assassingod

What if the user changes their e-mail constantly? Does the original e-mail stay or is it over-written?

The "emailold" is over written by "email" each time the user changes email addresses.

I did not realize a user can change their email even when they are "awaiting email confirmation." I will fix this and post it asap. ;)

Thanks everyone!

Will this only save just the prior one or can it be set up to save ALL they change? Somewtimes they will do more than one if they are really trying to pull something. ;)

OK, here is the fix: (I updated the installer, but here is all you need to change.)

In the original install file, it says:

Code:

Find: (About Line: 330)



                $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]");



Replace With: (Make sure your "Awaiting Email Confirmation" usergroup id is equal to 3)



//Start Save Prior Email v1.0 // Written By: Glenn H. Shelton III

                $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail $oldemail usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]");

//End Save Prior Email v1.0 // Written By: Glenn H. Shelton III

But Now it reads:

Code:

Find: (About Line: 330)



                $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]");





Replace With: (Make sure your "Awaiting Email Confirmation" usergroup id is equal to 3)



//Start Save Prior Email v1.0 // Written By: Glenn H. Shelton III

                if ($bbuserinfo['usergroupid'] != 3)

                {

                $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail $oldemail usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]");

                } else {

                $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]");

                }

//End Save Prior Email v1.0 // Written By: Glenn H. Shelton III

@Bob: At this point it only stores the last confirmed email address. If there is enough of a request to store all email addresses of a user I will look into it. But the way it is now, once they confirm their account to post you know it is a valid email. When they change it the first time the "known good" email address is moved to the "emailold" spot and the new email is stored. If that account is not ever confirmed then the "known good" email stored in "emailold" will not be overwritten. If it is confirmed, it will over write the old "known good" with the new "known good" when they change it again.

Keep the feed back coming.

Might not be a bad idea to have it as a drop down then older email address could be added to it very easily in case you ever run into that. I ran into in on my vB2 board but haven't yet so far on vb3, but I'm sure it's coming. ;)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01118 seconds Memory Usage 1,740KB 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 (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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
Messages: