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)
 Admin Reminder - User awaiting email validation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

PPSSWeb
Junior Member

312 Posts

Posted - 05 April 2007 :  16:18:02  Show Profile  Reply with Quote
Admin Reminder - User awaiting email validation

This is a small mod to remind the forum admin that there are registered, approved users who have yet to validate their email address and complete their registration. It adds a link next to admin options in the header with a count or users whose registrations have been approved but the user has not validated their email address. I like to keep my pending members table clean, so I find this useful as I have a number of users who register and then forget the validation part of the process for a while if I don’t remind them. Obviously, this goes hand in hand with the email registration reminder mod. All changes are made in inc_header.asp.

Around line # 219 add (between the end if and the rs.close):

	strSql = "SELECT COUNT(MEMBER_ID) AS U_COUNT FROM " & strMemberTablePrefix & "MEMBERS_PENDING WHERE M_STATUS = " & 0 & " AND M_APPROVE = " & 1
	set rs = Server.CreateObject("ADODB.Recordset")
	rs.open strSql, my_Conn
	if not rs.EOF then
		vUser_Count = cLng(rs("U_COUNT"))
	else
		vUser_Count = 0
	end if


Around line # 415 add (between the if and the response.write):
		if mLev = 4 and (strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" and vUser_Count > 0) then Response.Write(" | <a href=""admin_accounts_pending.asp""" & dWStatus("(" & vUser_Count & ") Member(s) awaiting email validation") & " tabindex=""-1"">(" & vUser_Count & ") Member(s) awaiting email validation</a>")


Please let me know if anyone has any questions or finds any bugs in this little reminder mod.

Thanks<

Edited by - MarcelG on 06 April 2007 04:00:32

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 06 April 2007 :  04:01:52  Show Profile  Visit MarcelG's Homepage  Reply with Quote
Nice simple mod. I thought this was already there, but it seems not. Thanks!
BTW ; I've changed your post, so that the code doesn't stretch the topic to the side.<

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 06 April 2007 :  04:51:54  Show Profile  Visit HuwR's Homepage  Reply with Quote
if as admin you just go to admin_home then it does already tell you that there are still members pending, the current code in inc_header only infoms you when there are users requiring authentication<
Go to Top of Page

PPSSWeb
Junior Member

312 Posts

Posted - 06 April 2007 :  08:47:32  Show Profile  Reply with Quote
quote:
Originally posted by MarcelG

BTW ; I've changed your post, so that the code doesn't stretch the topic to the side.



Thanks, I will have to remember that tag. It is not in the forum code help to the left.

quote:
Originally posted by HuwR

if as admin you just go to admin_home then it does already tell you that there are still members pending, the current code in inc_header only infoms you when there are users requiring authentication



Exactly! I get a lot of people who start the registration and not finish, so this lets me know without entering the admin options how many there are. Then I can follow the link and send out reminder emails to those that I feel need them.<
Go to Top of Page

psmith32
Starting Member

Bhutan
36 Posts

Posted - 24 September 2007 :  20:13:36  Show Profile  Reply with Quote
Tried and tried but will not work..
there are a lot of if...response.write statments at line 415.
Can you give more of the if statment code so we know wereto incert?

Pat
<
Go to Top of Page

psmith32
Starting Member

Bhutan
36 Posts

Posted - 24 September 2007 :  20:21:03  Show Profile  Reply with Quote
OOOPS
Found it line 467 after "if mLev = 4......."

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