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)
 User Options MOD advice		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 26 February 2005 :  20:13:41  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Over the last few months I have been installing a lot of MODs on my forum, and I've done a fair share of my own code modifications. I think that there are 2 major things I still need to do:

1) Improve the design/style
2) Give users more options to customize the forum to their wants/needs

I'm not very good at graphics with ASP (or any type of coding language), so I've decided to save that for later - Right now what I would like to work on is number 2 in the list above.

I have been outlining this in my head for some time, but I would like some input from other Snitz users on this. Here's what I've come up with so far:

- Create a table to store user preferences (i.e. FORUM_USEROPTIONS)
- Create a page for users to set their preferences from (i.e. preferences.asp)
- Some options I want users to be able to set:
* Show/Hide avatars
* Show/Hide member post count
* Show/Hide member rank/title
* Show/Hide member country
* Move "View Signatures in Posts" and other options that are currently set from the profile page to the user options page
* Move options set for implemented MODs, like the PM MOD, to the user options page

And I'm sure that going along I'll think of more to add.

Some things I need help/advice on:

- How to load the preferences? Include a sub in inc_func_common and load the preferences when a user logs in?
- Is the above going to present problems when a user uses the save password feature? (i.e. preferences will not be loaded if there is no need to log in)
- What format to use for a loaded preference? (i.e. strUOShowAvatars, str UOShowCountry etc.)
- What function to use to check whether a value for a preference is true? Something like CheckPreferenceValue(strPreference,UserID) ?

Thanks in advance for any input/tips/help you can give me!
eXtremeGossip

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 04 March 2005 :  22:46:29  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Since nobody seems to have any advice () I started out without it, and believe it or not, I'm stuck already

I have this SQL statement to check if there is a record for the user accessing the UserOptions page in the database, and if not, add one (this is the part where it checks for a record):

	'## Check for existing record in UserOptions table
	strSql = "SELECT UO_MNAME FROM " & strMemberTablePrefix & "USEROPTIONS WHERE UO_MNAME= '" & strDBNTUserName & "'"

	set rs = my_Conn.Execute (strSql)
	
strCurrentRecord = rs("UO_MNAME")

if strCurrentRecord = "" Then
	Response.Write "<br>Not Found"
else
	Response.Write "<br>" & rs("UO_NAME")
end if
This is obviously not working because I get a rs.BOF/rs.EOF error when there is no record... If somebody could fix this or suggest a better way of doing this it would help a lot
eXtremeGossip
Edited by - Jorrit787 on 04 March 2005 22:47:10
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 04 March 2005 :  23:21:32  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Nevermind, I figured it out.
eXtremeGossip
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.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07