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/O Code)
 Forcing profile updates		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

philsbbs
Junior Member

United Kingdom
397 Posts
Posted - 03 March 2008 :  11:10:30  Show Profile  Reply with Quote
Hi,

I've applied the password mod (min/max/numberic) to my forum and also made more fields required fields.

I need to get all members where m_profile_update = 1 to redirect to the profile page when they next log on. Once they update there profile with the new requirements I need the m_profile_update field to change to 0 so they are not prompted again. The trick is they must complete the requirements and not be able just go into the forum.

Hope this makes sense.

I could send private message and emails to this members but half will not do anything.

<
Phil

muzishun
Senior Member

United States
1079 Posts
Posted - 03 March 2008 :  14:40:35  Show Profile  Visit muzishun's Homepage  Reply with Quote
What you're talking about isn't possible without writing a new MOD, as there is no m_profile_update field in the base version.<
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

cripto9t
Average Member

USA
881 Posts
Posted - 03 March 2008 :  14:50:38  Show Profile  Reply with Quote
edit - I'm assuming you have added the new field .
Save this as "whatever.asp" and include it at the end of inc_header.asp.
<%

strSql = "SELECT M_PROFILE_UPDATE FROM " & strMembersTablePrefix & "MEMBERS " & _
         "WHERE MEMBER_ID = " & MemberID

set rs = my_Conn.Execute(strSql)

if rs.EOF or rs.BOF then
    'ID doesn't exist??
else
    blnUpdateStatus = rs("M_PROFILE_UPDATE")
end if

rs.close
set rs = nothing

if cLng(blnUpdateStatus) < 1 then
    'Do Nothing
else
    Response.Write "WRITE YOUR MESSAGE HERE" & vbNewLine & _
                   "<meta http-equiv=""Refresh"" content=""15; URL=pop_profile.asp?mode=Edit"">" & vbNewLine
    WriteFooter
    Response.End
end if

%>
You'll have to add m_profile_update to the update statement in pop_profile.asp, after the required fields checks.
Remove it when you think everyones updated.
<
    _-/Cripto9t\-_
Edited by - cripto9t on 03 March 2008 14:52:19
Go to Top of Page

philsbbs
Junior Member

United Kingdom
397 Posts
Posted - 03 March 2008 :  16:12:44  Show Profile  Reply with Quote
==
You'll have to add m_profile_update to the update statement in pop_profile.asp, after the required fields checks.
Remove it when you think everyones updated
==

Can you show me a few lines before I need to add it.
Thanks for your help.
<
Phil
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 04 March 2008 :  04:00:05  Show Profile  Reply with Quote
Alternatively, dim a new variable to hold the value of M_PROFILE_UPDATE and assign the value using the chkUser function (see how the value of MemberID is assigned as an example) and then add a simple if check to redirect them to edit their profile if the value of that variable isn't as it should be (don't forget to add a condition to the if statement that excludes pop_profile.asp from the redirect or they'll be stuck in an endless loop). It might be an idea to add a message to the pop_profile login form informing them of why they've been redirected in case they think your forum's just banjaxed.

<
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
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.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.07