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.
.
<
Posted
I've went ahead and made all of the code changes but it appears that none of the database entries were added: bookmarks, friends or drafts even though it said they were created. How do I create them manually or fix the included database files?<
Posted
Everyone is having to manually create the table using Access, the table's title is "FORUM_BOOKMARKS". Within that table,
Column 1 "BOOKMARK_ID", set to autonumber.
Column 2 "B_MEMBER", set to integer (not long integer), the format should be 11, the number of decimal points should be 0.
Column 3 "B_URL", set to text, length 255.
Column 4 "B_TITLE", set to text, length 100.
Column 5 "B_CAT", set to text, length 100. Column 6 "B_DATE", set to text, length 14. Save.
If you tried to run the dbs file more than once, you'll need to remove the additional lines from the "FORUM_CONFIG_NEW" table. Open it up and look at the very end. If you have more than one entry "STRUSBOOKMARKSWITCH", delete all but one. Save. Exit Access. Do not rerun the dbs file but go ahead and use bookmarks.<
Column 1 "BOOKMARK_ID", set to autonumber.
Column 2 "B_MEMBER", set to integer (not long integer), the format should be 11, the number of decimal points should be 0.
Column 3 "B_URL", set to text, length 255.
Column 4 "B_TITLE", set to text, length 100.
Column 5 "B_CAT", set to text, length 100. Column 6 "B_DATE", set to text, length 14. Save.
If you tried to run the dbs file more than once, you'll need to remove the additional lines from the "FORUM_CONFIG_NEW" table. Open it up and look at the very end. If you have more than one entry "STRUSBOOKMARKSWITCH", delete all but one. Save. Exit Access. Do not rerun the dbs file but go ahead and use bookmarks.<
Posted
I've never set up a database manually before. I guess it's time I learn. 
I also need to know how to manually update the Friends and Drafts database.
Incidentally, why do the files not seem to work when other dbs files with other mods do?<
I also need to know how to manually update the Friends and Drafts database.
Incidentally, why do the files not seem to work when other dbs files with other mods do?<
Posted
I once had a similar issue (not with this mod), using mod setup to create a table, with mysql.
I even tryed renaming the table and was still told "table already exists"?!?!
I couldn't even create it manually until I dropped it.
I don't know why the dbs files arn't working with access. I tested them with mysql and ms sql with no problems. <
I don't know why the dbs files arn't working with access. I tested them with mysql and ms sql with no problems. <
Posted
Can anyone figure out how to make the dbs files work with Access? I've tried creating the tables manually but keep having issues.
Is it possible to have someone update my access database manually?
I wish the dbs files worked.
<
Is it possible to have someone update my access database manually?
I wish the dbs files worked.
<
Posted
I have been doing this for some time and I eventually gave up on the dbs files. No idea why they aren't working with Access. But the database isn't that difficult to modify, so I can make the required tables for you if you want me to.
Tell me how to get in touch with you and we'll get it done.<
Tell me how to get in touch with you and we'll get it done.<