Attachment Database

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.

[rake]

check for this line:

$getattach = $DB_site->query("SELECT attachment.attachmentid,attachment.userid,attachme nt.dateline,attachment.filenam e,attachment.visible ".iif($privattach,',attachment.private','').",atta chment.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");

[corsacrazy]

mine says

$getattach = $DB_site->query("SELECT attachment.attachmentid,attachment.userid,attachme nt.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");

[rake]

replace it with the one i posted above and it will work.

[corsacrazy]

i replaced my code with the one you said and its working now , thanks alot

[Velocd]

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.

[high]* Velocd clicks install [/high]

[Dean C]

Thats pretty damn cool...

- miSt

[corsacrazy]

wood there be a way to order the attactments by a value set in the attach.php file ie, order by filesize, number of times downloaded, or extension. ? ?

[Dark_Wizard]

Does this work with the "Attachments as Files" hack? Otherwise I would have to rewrite it and don't have the time to do it...

[dev]

Very cool Hack, great! thx

[Bison]

Originally posted by Velocd
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.

* Velocd clicks install

I await your modifications!