| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 19 December 2001 : 13:10:57
|
Email Validation Mod
Author: Davio
Version: 3.3.03 of the Snitz Forums
Ease of Installation (1 - Really Hard, 10 - Very Easy): 7
This mod is an alternative to my Email Random Password Mod. Instead of sending a random password to the users email when they register, this mod will send a link with a random 16 character activation key, to the user email address when they register. Until they access thier email and click on the link, thier account is put on hold or in waiting mode, until the user activates thier account. They cannot login or post until they activate their account.
The link generated will look like this:
http://www.yourwebsite.com/forum/register.asp?actkey=dzNun4LTmoP9LwJf
In the Admin section, you will be able to see all accounts that are waiting to be activated and how long (in days) the account has been on hold. You can delete the account if you feel it has been on hold for too many days. (maybe the user didn't get the email or used an invalid email address). You can also manually activate the account from the Admin section.
Just like my Email Random Password mod, when users change thier email address a randomly generated 16 charcter verification key (love saying that) is sent to thier new email address to confirm the change. The email won't be changed until they verify it by clicking on the link that was sent to thier new email address.
I prefer this mod over the random password, since it allows users to set thier own password to something they can remember. Instead of sending them a cryptic password.
Note: This mod will NOT work with the Email Random Password Mod. You have to choose either this mod or the Email Random Password Mod. If you already have the Email Random Password Mod installed, you will need to uninstall it before installing this mod.
Demo:
http://www.dsilvera.com/forum/
*To see how it works, you can try registering at my forum. You will see the link that is generated. You don't have to click on it, as your account will eventually be deleted if it hasn't been activated.* 
Downloads:
http://dsilvera.com/download.asp?file_id=60
http://www.ls3k.com/snitz/mods.asp ---> Email Validation
Recent Updates:
May 16
- Fixed security vunerabilites that existed.
- Files Modified: pop_profile.asp, register.asp.
February 19
- Fixed SQL bug when updating BLOB fields
- Fixed bug when using ' in profile fields
- Changed datatype fields in database setup file for M_QUOTE, M_LNEWS, M_HOBBIES and M_BIO from text to memo
- Added more code comments to register.asp file and config.asp files. Missed commenting some of the code.
- Added database uninstall file to uninstall the mod
- Files Modified: register.asp, dbs_email_val.asp, config.asp.
February 02
- Fixed bug in database setup file
- Files Modified: dbs_email_val.asp
January 24
- Fixed bug when editing profile
- Fixed bug when user clicks on the activation link, there will be an error on the registration page
- Files Modified: inc_profile.asp, register.asp
Installation:
Please read the readme.txt file that comes with the zip file.
If you have any comments or suggestions about this mod, please post your questions here.
If you need help with this mod, please post them in the "Help: MOD Implementation" forum. I will not help anyone if they post thier questions in this topic.
- David
Edited by - Davio on 04 June 2002 05:37:02 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 19 December 2001 : 13:44:33
|
Davio,
This is definately a better alternative to your Email Random Password Mod.
I have a suggestion.
1. Store the user info in a Dummy_Members Table until user clicks on the activation key sent to user. Once the user clicks on the activation key move the info from the Dummy_Members Table to the Members Table. This will help maintain the sequence of Member_ID in the Members table.
<img src="http://www.forumsquare.com/logo_forumsquare.gif" border=0>
www.forumSquare.com - GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 December 2001 : 13:50:26
|
hmm, thanks GauravBhabu.
That does sound like a good idea. I will consider it and see what I can come up with.
Just like to keep my mods small and not create any new tables and use less coding if possible.
- David |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 December 2001 : 18:13:31
|
Nice MOD Davio, it's going down as a must install on my new forums.
HALO - an EverQuest and Camelot Guild |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 22 December 2001 : 00:33:34
|
this is great! how do I uninstall my random password generator?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 22 December 2001 : 07:11:45
|
I just installed the MOD on my new forums. Looks good, but I found one very small bug in line 80 of admin_accounts_pending.asp. The colspan is 5 but should be 6 or you'll end up with a cell missing when there are no pending members.
I can't test the mod as it's running locally and I can't use the mail functions for some reason, but it sounds a lot nicer than the random password mod.
Roland |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 22 December 2001 : 12:06:31
|
great mod, I love it and agree this is better than the email password mod because the members can choose their own password right away. I've been having problems with members signing up, getting their random password, logging into the forum and not changing their passwords. If they log out or clear their cookies and don't come back for awhile or delete their email they don't get in that easily because they don't recall the password... even though there is an email lost password feature that everyone seems to overlook and then email me directly.. anyway I am getting long winded here...
Frutzle: if you are having problems sending email locally it is probably because you are having problems with SMTP services or don't have them at all. I found a componenet that works nicely on 9x/ME machines from http://www.dynu.com called DynuEmail you should check out. Works great.
____________
dayve@burningsouls.com
http://www.nineinchnailz.com - your source for everything nine inch nails ! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 December 2001 : 12:40:06
|
Thanks Frutzle, has been fixed.
I basically took the admin_emaillist.asp file and modified it for the admin_accounts_pending.asp page.
For email testing locally on my computer, I use Mercury for my email server and the JMail component. Mercury is free to use and it's easy to setup. If you know how to setup an email server.
- David |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 22 December 2001 : 15:21:11
|
I just got 50-some e-mails from my own computer sent to various e-mail accounts I created for local testing... lol I guess my Win2K's e-mail server was a little messed up or something. At least now I know the subscriptions are working 
Oh and I'm having a problem with this MOD which I'll post about in the MOD implementation forum.
Roland
*Common sense is the collection of prejudices acquired by age eighteen* |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 22 December 2001 : 15:49:47
|
David, one more problem after installing the MOD...
I can't get it working, but other than that I found the following:
pop_profile.asp line 1179:
'#################################### Email Validation Mod ###################################
if strEmailVal = "1" then
strSql = strSql & ", M_NEWEMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'"
else
strSql = strSql & ", M_EMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'"
end if
strSql = strSql & ", M_KEY = '" & chkString(verKey,"SQLString") & "'"
'#########################################################################################
strSql = strSql & ", M_EMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'"
Unless I remove the red code it won't let me change the e-mail address as it's specified twice.
I want to try a couple things before I come running for help to get the MOD working, but right now it doesn't do anything at all....
Roland |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 December 2001 : 19:48:07
|
Frutzle, this is what I have in the zip for pop_profile.asp:'#################################### Email Validation Mod ###################################
if strEmailVal = "1" then
strSql = strSql & ", M_NEWEMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'"
else
strSql = strSql & ", M_EMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'"
end if
strSql = strSql & ", M_KEY = '" & chkString(verKey,"SQLString") & "'"
'#########################################################################################
'strSql = strSql & ", M_EMAIL = '" & chkString(Request.Form("Email"),"SQLString") & "'" You need to comment it out.
- David |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 December 2001 : 19:51:58
|
Grrr, Frutzle see you have me helping you in the wrong forum.
If you have anymore problems, you know the forum to post it in.
Everyone, please don't ask for help here or post errors you are getting. The Help: MOD Implementation forum is there for that purpose. Frutzle just got away with it. 
- David |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 23 December 2001 : 07:49:11
|
I didn't mean to ask for help. I just thought it was a bug.... Guess I overlooked the apostrophe.
Roland
*bows his head in shame and quitely sneaks out of the room* |
|
|
|
dimitris
Starting Member
8 Posts |
Posted - 14 January 2002 : 17:29:35
|
I don't know if this behavior is by default.
If an administrator changes a user email that user is not shown at members pending page. So only the user can confirm the email change. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 January 2002 : 23:40:55
|
That is by behaviour. You want the user to be locked out of his account when he or the admin changes the email address? If he made a mistake in his email address, he wouldn't be able to get back into his account to correct it.
The email address won't change until the user confirms his email address. So he can continue using his account with the original email address.
- David |
|
|
|
Topic |
|
Topic Locked
