Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Attachment Database Details »
Attachment Database
Mod Version: 1.00, by rake (Member) rake is offline
Developer Last Online: Oct 2012 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 45
Released: 17 Nov 2002 Last Update: Never Downloads: 4
Not Supported  

It's self-explanatory and easy to install. You can view a demo here: http://forums.ffdiscovery.com/attach.php


Instalation
===========

Installation is extremely easy. First open the attach.php file and check the configuration. It's designed to work with the private attachments hack and the attachment viewer. After checking the config, upload the file to your forums directory, create a new template called attachment with the contents of the attachment.txt file and a new template called attachmentbit with the contents of the attachmentbit.txt file. That's it.

Feedback is always appreciated. You can get assistance, if needed, either through an e-mail or through my forums.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
[attachment]id[/attachment] BBcode Benjy vBulletin 3.0 Full Releases 11 25 Jun 2005 13:57

Comments
  #2  
Old 17 Nov 2002, 19:19
SpeedStreet SpeedStreet is offline
 
Join Date: Aug 2002
Nice Idea!

Is it possible to grant moderators and admins delete privileges? This would be a great addon for managing the amount of attachments you currently have!

EDIT: Listing of file size would be pretty groovy too...
__________________
Charity Organization Charity Coder
Reply With Quote
  #3  
Old 17 Nov 2002, 19:21
KelteN KelteN is offline
 
Join Date: Nov 2002
Originally posted by SpeedStreet
Nice Idea!

Is it possible to grant moderators and admins delete privileges? This would be a great addon for managing the amount of attachments you currently have!

EDIT: Listing of file size would be pretty groovy too...
Nice ideas It would be nice to see them added into this hack
Reply With Quote
  #4  
Old 17 Nov 2002, 19:37
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
kool ive been lookin for something like this , cheers ... i have the hack thing "attactments : 112" and i was lookin 2 put a link on that to goto all the attatchment and this hack wood b perfect thanks alot.
Reply With Quote
  #5  
Old 17 Nov 2002, 19:46
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
damn im getting this error
Database error in vBulletin 2.2.8:

Invalid SQL: SELECT attachment.attachmentid,attachment.userid,attachment.dateline,attachment.filenam e,attachment.visible,attachment.private,attachment.counter,post.postid,post.thre adid,thread.title,user.username FROM attachment LEFT JOIN post on attachment.attachmentid=post.attachmentid LEFT JOIN thread USING(threadid) LEFT JOIN user on attachment.userid=user.userid WHERE attachment.visible=1 AND post.attachmentid<>0 LIMIT 0,15
mysql error: Unknown column 'attachment.private' in 'field list'

mysql error number: 1054

this is how i have set up the attatc.php file


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

please can you help me out ? thanks
Reply With Quote
  #6  
Old 17 Nov 2002, 19:47
Ninth Dimension's Avatar
Ninth Dimension Ninth Dimension is offline
 
Join Date: Oct 2001
Real name: Daniel Hollands
I'm using the attachments as files hack, is this compatabul with it?
__________________
Daniel Hollands - http://theworldofdan.co.uk/
Interactive Story Site - http://unknowntales.net/
TheICE.co.uk Network - http://theice.co.uk/
Arathor Realm Forums - http://arathor.net/
Reply With Quote
  #7  
Old 17 Nov 2002, 19:50
!!!'s Avatar
!!! !!! is offline
 
Join Date: Nov 2002
Re: Attachment Database

Originally posted by rake
It's self-explanatory and easy to install. You can view a demo here: http://forums.ffdiscovery.com/attach.php


Instalation
===========

Installation is extremely easy. First open the attach.php file and check the configuration. It's designed to work with the private attachments hack and the attachment viewer. After checking the config, upload the file to your forums directory, create a new template called attachment with the contents of the attachment.txt file and a new template called attachmentbit with the contents of the attachmentbit.txt file. That's it.

Feedback is always appreciated. You can get assistance, if needed, either through an e-mail or through my forums.
Private attachment? Attachment viewer?
Reply With Quote
  #8  
Old 17 Nov 2002, 19:52
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
they are other hacks


Private attachment : allows u 2 attactch files in a pm
Attachment viewer: shows the attachment within a page looking like your forum, ie includes the header/footer and shows who posted the attactment
Reply With Quote
  #9  
Old 17 Nov 2002, 19:58
rake's Avatar
rake rake is offline
 
Join Date: Nov 2002
Real name: Alex
Originally posted by corsacrazy
damn im getting this error



this is how i have set up the attatc.php file


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

please can you help me out ? thanks

sorry about that. re-download the file
Reply With Quote
  #10  
Old 17 Nov 2002, 20:03
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
same error
Reply With Quote
  #11  
Old 17 Nov 2002, 20:16
rake's Avatar
rake rake is offline
 
Join Date: Nov 2002
Real name: Alex
check for this line:

$getattach = $DB_site->query("SELECT attachment.attachmentid,attachment.userid,attachment.dateline,attachment.filenam e,attachment.visible ".iif($privattach,',attachment.private','').",attachment.counter,post.postid,pos t.threadid,thread.title,user.username FROM attachment LEFT JOIN post on attachment.attachmentid=post.attachmentid LEFT JOIN thread USING(threadid) LEFT JOIN user on attachment.userid=user.userid WHERE attachment.visible=1 AND post.attachmentid<>0 ".iif($privattach,'AND private=0','')." LIMIT $min,$perpage");
Reply With Quote
  #12  
Old 17 Nov 2002, 20:17
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
mine says

$getattach = $DB_site->query("SELECT attachment.attachmentid,attachment.userid,attachment.dateline,attachment.filenam e,attachment.visible,attachment.private,attachment.counter,post.postid,post.thre adid,thread.title,user.username FROM attachment LEFT JOIN post on attachment.attachmentid=post.attachmentid LEFT JOIN thread USING(threadid) LEFT JOIN user on attachment.userid=user.userid WHERE attachment.visible=1 AND post.attachmentid<>0 ".iif($privattach,'AND private=0','')." LIMIT $min,$perpage");
Reply With Quote
  #13  
Old 17 Nov 2002, 20:19
rake's Avatar
rake rake is offline
 
Join Date: Nov 2002
Real name: Alex
replace it with the one i posted above and it will work.
Reply With Quote
  #14  
Old 17 Nov 2002, 20:19
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
i replaced my code with the one you said and its working now , thanks alot
Reply With Quote
  #15  
Old 17 Nov 2002, 20:31
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Real name: Mike
Very nice, this is one I will be sure to install, but an even more efficient attachment database is one that categorizes the attachments by the forum they are in. I'll consider revising it with this improvement if you don't want to yourself, and then posting it.

/me clicks install
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:37.

Layout Options | Width: Wide Color: