vb3 Attachments - Including Multiple Attachments Option

Woo! Finally! I've been working on this for 10 straight hours now.

It's a replica of the vbulletin 3 attachment feature, which supports multiple uploads. We can't have vbulletin 3 yet, but at least we can copy it.


Files to edit: 5
Queries to run: 5
New Templates: 3

Just be sure to backup before trying anything.
You can see it live at my forums. Log in as test/test, if you want to see it in action.

And don't forget to click the Install button if you like the hack.



=-=-=-=-=-=-==-=-
UPDATE - Please re-download the file. Upgrading instructions are included in instructions.php. And sorry for the wait. I had to bribe my parents with 15 math exercises to let me use the computer. :knockedout:
=-=-=-=-=-=-=-==-

=-=-=-=-=-=-=-=-=-
SECOND UPDATE - Sorry for the previous non-functioning version, everyone. I did those modifications really late at night and some errors slipped in. This update fixes permission errors, allows you to specify a maximum number of attachments, fixes 65535 bytes error and includes repairing instructions for editpost.php
I have tested it on a clean 230 test board and it worked fine.
=-=-=-=-=-=-=-=-=-

=-=-=-=-=-=-=-=-=-=
THIRD REVISION - This update fixes the 3 largest errors reported so far:
1. The view image atachments option now works
2. Attaching more than one file with a new thread now works
3. Deleting a post with attachments now works
=-=-=-=-=-=-=-=-=-=

To everyone who used attachment.php from the old zip: Please replace it with your original one. attachment.php was added in the zip by mistake.

[squawell]

Today at 04:24 AM rake said this in Post #100
Not in my hack.



NOTE TO EVERYONE WHO USED THE ATTACHMENT.PHP FROM THE OLD ZIP:
Replace it with your original one.

i know that not about ur hack....

anyway i comment that and it works now

thankz rake.......this is a nice hack..... :classic:

find new problem when edit post and remove the multiple attachment files i got this

Invalid SQL: SELECT attachmentid FROM post WHERE attachmentid=233,234
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '234' at line 1

mysql error number: 1064

Date: Thursday 01st of May 2003 04:30:10 AM
Script: http:///forum/forum/editpost.php
Referer: http:///forum/editpost.php?s=&action=editpost&postid=1372

[iggy123]

NOTE TO EVERYONE WHO USED THE ATTACHMENT.PHP FROM THE OLD ZIP:
Replace it with your original one.

I don't have it anymore I have been trying for hours to get this too work, and can't uninstall it as i have no idea on how to delete the tables and get the attachments back to the way they were...

[rake]

I'm glad to see it finally works.

Edit: Wow, great timing. :lick:


To fix the editing error:

Replace
if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";
$DB_site->query("DELETE FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
updatethreadcount($threadinfo[threadid]);
}

With

if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";


$att = explode(",",$postinfo[attachmentid]);
foreach($att as $value) {
if(isset($qry)) {
$qry .= " OR attachmentid='$value'";
} else {
$qry = "attachmentid='$value'";
}
}

$DB_site->query("DELETE FROM attachment WHERE $qry");
updatethreadcount($threadinfo[threadid]);
}

[Link14716]

Today at 04:43 PM iggy123 said this in Post #102
I don't have it anymore I have been trying for hours to get this too work, and can't uninstall it as i have no idea on how to delete the tables and get the attachments back to the way they were...

Download a new ZIP from the member's area or make the changes to the attachment.php that I posted. If you make the changes I posted, that attachment.php will work

[Link14716]

Today at 04:45 PM rake said this in Post #103
I'm glad to see it finally works.

So are we, rake, so are we.

[Breaker]

i will be installing this when i get some free time

[iggy123]

Today at 09:45 PM rake said this in Post #103
I'm glad to see it finally works.

Edit: Wow, great timing. :lick:


To fix the editing error:

Replace
if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";
$DB_site->query("DELETE FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
updatethreadcount($threadinfo[threadid]);
}

With

if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";


$att = explode(",",$postinfo[attachmentid]);
foreach($att as $value) {
if(isset($qry)) {
$qry .= " OR attachmentid='$value'";
} else {
$qry = "attachmentid='$value'";
}
}

$DB_site->query("DELETE FROM attachment WHERE $qry");
updatethreadcount($threadinfo[threadid]);
}

which file is that from????

[iggy123]

Today at 09:47 PM Link14716 said this in Post #104
Download a new ZIP from the member's area or make the changes to the attachment.php that I posted. If you make the changes I posted, that attachment.php will work

I have applied the changes you made and it still doesn't work??? is there any chance you could post your attachment.php..... I am really getting depressed now! this should've gone into the beta release not here!

[rake]

The hack didn't work before because of small errors which slipped in because of tiredness. :sleep: The hack in it's current state will work fine.

[iggy123]

Is there any chance that you could send me - or post - a working attachment.php. I have tried altering the one on the post but i can now edit but i am still getting error when trying to view an attachment -

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT filename,filedata,dateline,visible
FROM attachment
WHERE attachmentid='50'AND private=0
mysql error: Unknown column 'private' in 'where clause'

mysql error number: 1054

Date: Wednesday 30th of April 2003 04:37:20 PM
Script: http://xxx/forums/forums/attachment.php?attachmentid=50
Referer: http://xxxxx/forums/showthread.php?threadid=459