The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I missed my due date by a few weeks but better late than never 
.
Let me just say that coding is a hobby of mine that I do when its to wet or cold to get outside and make my money. So any code that I post is "use at your own risk".
1.1.02 - User posts sql bug fixed. Now uses date as a delimiter instead of a max value. To update replace "user_space.asp" and "admin_user_space.asp" with the new files. All other bugs pointed out so far and then some have been addressed. Also added some more constants to "user_space.asp" to make customization a little easier.
1.1.01 - updated with numerous bug fixes and contains the addon features drafts, bookmarks and friends/buddies. It also looks a little neater than the last one.
1.1.00 - Initial release
From the readme....
<
.
Let me just say that coding is a hobby of mine that I do when its to wet or cold to get outside and make my money. So any code that I post is "use at your own risk"
. 1.1.02 - User posts sql bug fixed. Now uses date as a delimiter instead of a max value. To update replace "user_space.asp" and "admin_user_space.asp" with the new files. All other bugs pointed out so far and then some have been addressed. Also added some more constants to "user_space.asp" to make customization a little easier.
1.1.01 - updated with numerous bug fixes and contains the addon features drafts, bookmarks and friends/buddies. It also looks a little neater than the last one.
1.1.00 - Initial release
From the readme...
User Space Mod for Snitz ForumsAny questions or problems, just ask
Author: cripto9t
Version: 1.1.01
Date Released: 15 January 2008
History
----------------
Version: 1.1.01 01/15/08
Bookmarks dbs typing error - Fixed
Issue with Friends db table setup in user space setup - Fixed
Reply draft quote issue - Fixed
Version: 1.1.00 01/10/08
Bookmark manager (unfinished in ver. 1.0.00) - Finished
New feature - Friends/Buddies List
Security issue with bookmarks addon - Fixed
Security issue with drafts addon - Fixed
Flood control issue with drafts addon - Fixed
Drafts causing error when creating new forum - Fixed
Reworked the code in "user_space.asp" and "pop_user_space.asp" to make it easier to add new features
Some issues with admin editing members space - Fixed
Made some new icons for the user space page
Redid the subhead table (menu tree, etc...) menu tree looks alot nicer
Admin link to view a members "User Space" page (missing in ver. 1.0.00) - Added to "members" and "admin search" pages
New Drafts feature - If Draft auto-delete is "On" a message is displayed informing members
New Drafts feature - If Draft auto-delete is "On" drafts close to being auto-deleted are marked
Check for maximum bookmarks (missing in ver. 1.0.00) - Hard coded in pop_user_space
Top to bottom redo on user_space_setup. Making it alot easier to read.
Another security issue with bookmarks found - Fixed
Bookmark # issue when adding an outside url - Fixed
Version: 1.0.00 11/16/07 - Initial Release
----------------
Description:
This mod adds a link in the forum menu that takes forum members to a private personal page
viewable only by the member and the forum administrator(s). The mod consists of "features" that
you add to it.
The default feature "User Posts" shows recent topics that the member has participated in. Other
features can be added later. Meaning that you don't have to add a feature if you don't want it.
Version 1.1.00 supports these addon features:
User Drafts 1.0.01: Allows members to save posts as drafts to be posted later.
User Bookmarks 1.0.01: Allows members to bookmark topics, replies and outside urls for later reference.
User Friends 1.0.00: Allows members to add other members to a friends/buddies list with thier
forum contact information. Saves member from having to look for contact info
through a post or the members page.
.
<
Postet den
Good job!
I did find one problem though.
If there is a single, or double, quote in the subject line of the post, it will produce an error when you try to save it as a draft. (This only applies when you are replying to a post with quotes in it.)
It shows the error at line 229 in inc_draft_info.asp.
It took a while to track it down. Some posts saved as drafts and other posts gave the error.
<
I did find one problem though.
If there is a single, or double, quote in the subject line of the post, it will produce an error when you try to save it as a draft. (This only applies when you are replying to a post with quotes in it.)
It shows the error at line 229 in inc_draft_info.asp.
It took a while to track it down. Some posts saved as drafts and other posts gave the error.
<
Postet den
Thanks codeman, I'll give it a look when todays games are over.
Go Colts! I hope<
Postet den
I can't believe I missed this 
.
needs to be
<
.
Code:
else
txtSubject = "re: " & rs("T_SUBJECT")
end if
Code:
else
txtSubject = chkString("re: " & rs("T_SUBJECT"),"sqlstring")
end if
Postet den
Thanks Cripto9t!
That did the trick.
Sorry about the Colts. At least they looked better than my Cowboys. <
That did the trick.
Sorry about the Colts. At least they looked better than my Cowboys. <
Postet den
I am getting this error in Friends addon:
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_FRIENDS'.
/user_space.asp, line 356
That line is: rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
Any idea what the problem is? I am using MS SQL
Also, the links in User Space Management do not work i.e. Add Feature and Trim Friends.
Here is the database update msg:
Friends
Creating table(s)... CREATE TABLE FORUM_FRIENDS( FRIEND_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , F_MEMBER int (11) NOT NULL DEFAULT 0, F_FRIEND int (11) NOT NULL DEFAULT 0, F_LEVEL smallint (6) NOT NULL DEFAULT 0, F_DATE nvarchar (14) NOT NULL DEFAULT '')
Table already exists
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRUSFRIENDSWITCH','1')
Value(s) updated successfully
--------------------------------------------------------------------------------
Database setup finished
Thanks
<
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_FRIENDS'.
/user_space.asp, line 356
That line is: rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
Any idea what the problem is? I am using MS SQL
Also, the links in User Space Management do not work i.e. Add Feature and Trim Friends.
Here is the database update msg:
Friends
Creating table(s)... CREATE TABLE FORUM_FRIENDS( FRIEND_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , F_MEMBER int (11) NOT NULL DEFAULT 0, F_FRIEND int (11) NOT NULL DEFAULT 0, F_LEVEL smallint (6) NOT NULL DEFAULT 0, F_DATE nvarchar (14) NOT NULL DEFAULT '')
Table already exists
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRUSFRIENDSWITCH','1')
Value(s) updated successfully
--------------------------------------------------------------------------------
Database setup finished
Thanks
<