| T O P I C R E V I E W |
| cripto9t |
Posted - 13 January 2008 : 10:54:26
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...
quote:
User Space Mod for Snitz Forums
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.
Any questions or problems, just ask .
< |
| 15 L A T E S T R E P L I E S (Newest First) |
| Carefree |
Posted - 20 April 2008 : 17:15:38
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.< |
| leatherlips |
Posted - 18 April 2008 : 11:25:51
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.  < |
| cripto9t |
Posted - 16 April 2008 : 09:50:07
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.
< |
| leatherlips |
Posted - 16 April 2008 : 07:57:23
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?< |
| Carefree |
Posted - 16 April 2008 : 02:04:18
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.< |
| leatherlips |
Posted - 15 April 2008 : 20:00:23
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?< |
| leatherlips |
Posted - 15 April 2008 : 16:05:03
When I run the database setup file here is the message:
Bookmarks
Creating table(s)...
CREATE TABLE FORUM_BOOKMARKS( BOOKMARK_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , B_MEMBER int (11) NOT NULL DEFAULT 0, B_URL text (255) NULL DEFAULT '', B_TITLE text (100) NULL DEFAULT '', B_CAT text (100) NULL DEFAULT '', B_DATE text (14) NULL DEFAULT '')
Table already exists
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRUSBOOKMARKSWITCH',1)
Value(s) updated successfully
--------------------------------------------------------------------------------
Database setup finished< |
| leatherlips |
Posted - 15 April 2008 : 15:59:34
Tried installing the Bookmarks mod. Here is what I get,
The Microsoft Jet database engine cannot find the input table or query 'FORUM_BOOKMARKS'. Make sure it exists and that its name is spelled correctly.
/forumtest/user_space.asp, line 386
That line is: rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText< |
| leatherlips |
Posted - 15 April 2008 : 14:55:03
OK, that was weird...
I went back in later and then it was suddenly there. I guess it is working now. I'll play around with it and see if I encounter any problems.< |
| leatherlips |
Posted - 15 April 2008 : 14:50:27
I logged back off and closed my browser and then logged back in. STRUSSWITCH is not listed. Ideas?< |
| cripto9t |
Posted - 15 April 2008 : 13:54:39
That means it can't find STRUSSWITCH, but your setup says it was added.
I've had problems like this before. I think it has something to do with the session.
Try logging off and and closing your session.
Then start another session and log back in.
After that look at "forum variables" in "admin options" and see if STRUSSWITCH listed.
< |
| leatherlips |
Posted - 15 April 2008 : 11:21:20
I tried installing this using Access Database. I made the changes to my files
but when it came time for the database here is what I see:
User Space
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTMAXSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTMAX',30)
Value(s) updated successfully
------------------------------
Database setup finished
Then when I go back to User Space Configuration it says this:
Database Needs Updated!
Run User Space Setup in Mod Setup.
It's as if I didn't do anything.
Any ideas how to get this to work with Access?
I would really like to try to use this mod as it looks pretty good.< |
| cripto9t |
Posted - 02 March 2008 : 09:22:33
No idea, I haven't had any feedback on access. The basic feature "User Posts" only adds 4 fields to the "config_new" table.
You could hardcode them on the user_space page to test that feature without changes to the database.
Something like this
Const strUSSwitch = 1
Const strUSPostSwitch = 1
Const strUSPostMaxSwitch = 1
Const strUSPostMax = 50 < |
| leatherlips |
Posted - 29 February 2008 : 21:36:45
Does this mod work with an access database? One of the addons says user_space_setup.asp (MYSQL and MS SQL users only)
I would like to try this mod but do not want to mess up my access database.
< |
| weeweeslap |
Posted - 27 February 2008 : 17:26:57
Oh that, yes I used that but for some reason something wasn't going right for the bookmarks add on. Friends one went on just fine.< |
