Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Resend Email Confirmation
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

seven
Senior Member

USA
1037 Posts

Posted - 16 August 2002 :  14:07:16  Show Profile  Visit seven's Homepage
For odd reasons some people on my website register but never confirm their email address.
I modified the 'admin_accounts_pending.asp' file in Snitz version 3.3.05 to resend another confirmation email.

Here's the edits to the file: 'admin_accounts_pending.asp'
---------------------------------------------
Find:
<!--#INCLUDE file="inc_top.asp" -->


Paste Below:
<% Dim mode, member_id
mode = Request.QueryString("mode")
member_id = Request.QueryString("member_id")

If mode = "resend" and member_id <> "" Then

'## Forum_SQL - Find all records with the search criteria in them
strSql = "SELECT M_NAME, M_PASSWORD, M_EMAIL, MEMBER_ID, M_DATE, M_KEY "
strSql = strSql & " FROM " &strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_STATUS = " & 0
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_LEVEL = " & -1
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & member_id

set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize=20
rs.open strSql, my_Conn, 3

strRecipientsName = rs("M_NAME")
strRecipients = rs("M_EMAIL")
strFrom = strSender
strFromName = strForumTitle
strSubject = strForumTitle & " Registration Confirmation - Day " & DateDiff("d", ChkDate(rs("M_DATE")), strForumTimeAdjust)
strMessage = "You registered as a new member of " & strForumTitle & " " & DateDiff("d", ChkDate(rs("M_DATE")), strForumTimeAdjust) & " days ago, and you have " & vbNewline
strMessage = strMessage & "not yet confirmed your email address: '" & rs("M_EMAIL") & "'" & vbNewline & Vbnewline
strMessage = strMessage & "Click here to confirm your email and complete your registration: " & vbNewline
strMessage = strMessage & strForumURL & "register.asp?actkey=" & rs("M_KEY") & vbNewline & vbnewline
strMessage = strMessage & "Once you have confirmed your email address you can login at " & strForumURL & " using:" & vbNewline & vbNewline
strMessage = strMessage & "Username: " & lcase(rs("M_NAME")) & vbNewline
strMessage = strMessage & "Password: " & lcase(rs("M_PASSWORD")) & vbNewline & vbNewline
strMessage = strMessage & "------------------------------------------" & vbNewline
strMessage = strMessage & strForumTitle & vbNewline

%>
<!--#INCLUDE FILE="inc_mail.asp" -->
<%
rs.close
Response.Redirect("admin_accounts_pending.asp?mode=sent")
End If
%>
%>

---------------------------------------------
Find:
<% else
do until rs.EOF
days = DateDiff("d", ChkDate(rs("M_DATE")), strForumTimeAdjust)
if days >= 15 then
days2 = "<b>" & days & "</b>"
else
days2 = days
end if
%>


Paste Below:
<form name="formSend" method="post" action="admin_accounts_pending.asp?mode=resend&member_id=<% =rs("MEMBER_ID") %>">

---------------------------------------------
Find:
<img src="<%=strImageURL %>icon_trashcan.gif" alt="Delete Account" border="0" hspace="0"></a>


Paste Below:
<input type="image" border="0" name="submit" src="icon_email.gif" width="15" height="15" alt="Resend Email">

---------------------------------------------
Find:
<%	rs.MoveNext
loop
end if %>


Paste Before:
[code]</form>

---------------------------------------------
Find:
[code]<% WriteFooter


Paste Before:
[code]<%
If mode = "sent" Then
Response.Write ("<font face=" & strDefaultFontFace & " size=" & strDefaultFontSize & ">Registration Email has been resent to the requested member.</font><br><br>")
End If
%>[code]

----------------------------------------------
That's it! You can customize the email message by editing the 'strMessage' lines above.
You can download my version here: http://www.gowilmington.com/community/snitz.asp

-Airilm

Anacrusis
Junior Member

USA
219 Posts

Posted - 16 August 2002 :  21:35:31  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message
Excellant mod! I was going to do something like this myself as I have the same problem with people signing up and not confiming their email.
two things though:
1.) You need to change the select statement to select from the FORUM_MEMBERS_PENDING table as they have not yet been put into the FORUM_MEMBERS table.

2.) You should maybe think about adding a RESEND_DATE to the members_pending table and filling that in when a email confirmation is resent. That way you'll know if and when a confirmation has been resent, delete members that havn't responded to the resent confirmation after a long period of time.

again, great job!

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 16 August 2002 :  21:45:23  Show Profile  Visit seven's Homepage
The RESEND_DATE is a very good idea. I'll work on that...

The email confirmation MOD I have installed uses the FORUM_MEMBERS table only, and just makes the members status as -1.

Thanks!

Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 17 August 2002 :  14:29:46  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message
oh, ok.. the version I have uses two tables. Only having one table would work better... where did you get the version of the mod that uses one table?

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 17 August 2002 :  18:46:21  Show Profile  Visit seven's Homepage
I really can't remember, I found it by searching the forum
How does version 3.4 handle it?

quote:
Originally posted by Anacrusis

oh, ok.. the version I have uses two tables. Only having one table would work better... where did you get the version of the mod that uses one table?


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07