| Author |
 Topic  |
|
CoarsefishAnton
New Member
73 Posts |
 Posted - 25 March 2003 : 14:58:20
|
Did anyone try this mod with access? and did it work? Superb bit of interface by the way BJH.
|
**************************
Explain it like I'm a five year old..... |
 |
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 25 March 2003 : 15:22:35
|
Ok, I'm going to give it a try, can anyone tell me how I achieve this?
Run the attachments.sql script in the MS Query Analyzer to create the FORUM_ATTACHMENTS table.
Thanks |
**************************
Explain it like I'm a five year old..... |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 30 March 2003 : 21:39:51
|
Many thanks onewaymule. I'll give this a try.
Much obliged |
**************************
Explain it like I'm a five year old..... |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 30 March 2003 : 21:58:30
|
One question of the stupid variety if I may?
How do I incorporate the ddbs file? |
**************************
Explain it like I'm a five year old..... |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 30 March 2003 : 22:06:58
|
| Thanks again. I'm not normally this dumb....honest! |
**************************
Explain it like I'm a five year old..... |
|
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 31 March 2003 : 13:30:35
|
OneWayMule, I installed this mod as per your instructions and nothing shows in the reply box (ie the upload file facility) Do you think that it's because Access is being used on the server instead of Sql?
If so, is there a way around it as my host charges $200 for sql?
Permissions were given to the attachment folder as specified |
**************************
Explain it like I'm a five year old..... |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 31 March 2003 : 13:54:57
|
Ok, I did that, still nothing. Here's what i got after updating
MOD: Ben's File Attachment (beta)
Creating table(s)...
CREATE TABLE FORUM_FORUM_ATTACHMENTS( FORUM_ID#INT#NOT NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL , TOPIC_ID int NOT NULL , REPLY_ID int NOT NULL , FILENAME text (216) NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Database setup finished
|
**************************
Explain it like I'm a five year old..... |
|
|
|
CoarsefishAnton
New Member
73 Posts |
Posted - 31 March 2003 : 13:56:22
|
| Thanks for the incredibly quick reply by the way. |
**************************
Explain it like I'm a five year old..... |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
mabril
Starting Member
5 Posts |
Posted - 03 April 2003 : 02:25:42
|
Any plans to document this mod so those of us who have already modded our forums can implement it?
Thanks,
Mario |
|
|
|
BJH
Starting Member
16 Posts |
Posted - 03 April 2003 : 14:11:58
|
wow, suddenly there's a lot of activity in this thread. sorry i've been gone so long.
i'm not quite sure what you guys are talking about with the dbs stuff, but the columns required in the FORUM_FORUM_ATTACHMENTS table are quite simple:
FORUM_ID (integer)
TOPIC_ID (integer)
REPLY_ID (integer)
FILENAME (varchar 216)
varchar is just a character datatype, if you don't know what that means. it needs to be 216 or larger because windows filenames can contain up to 216 characters.
if you're having trouble running the .sql script, just create the table manually. i think this mod will work in Access, but i haven't tested it. if anyone gets it to work, let us know.
as far as documenting the mod, i'm afraid there are simply too many little changes required. in most cases, i think it would be easier to install the mod on a fresh installation of snitz, then add your other mods afterward. however, if you are determined, you can search the source code for "<ben's attachment mod>". that will show you every spot where i modified or added to the snitz source code. then you would have to copy and paste the code into your current installation. if you do this, feel free to write the documentation as you go 
i'll start checking back here more often to answer questions. too bad we can't get email notifications  . this mod has been working well for me, and i haven't discovered any new bugs for a while now. it might be time to take it out of beta soon.
|
|
|
|
Topic |
|
Topic Locked
