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.

[350Chevy]

Something in functions.. I just added my old functions and the old attachments show again.. but multiple ones do not.. Just the first picture in a multiple attachment thread.

[350Chevy]

BTW... Thnx for the fix for the editpost.php still doesn't work right though.. It will delete all content out of a post if I click on edit post. I think it has to do with the recycle bin mod.. (not worried about that ATM.) Still wondering why functions.php wont show any images.. :disappointed:

[Link14716]

Today at 09:12 PM 350Chevy said this in Post #62
BTW... Thnx for the fix for the editpost.php.. Works fine on posts with single attachments or no attachments..

Whoops...

Change

PHP Code:

       if(isset($qry)) {
        $qry .= " OR attachmentid='$value'";
       } else {
        $qry = "attachmentid='$value'";
       } 


To

PHP Code:

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


Even still, when I submit the edited post, it gives me a blank page and I look at the post and it is now completely blank...

EDIT: Whoops, I made anopther mistake in the above code. Re-apply that change if you have already applied it.

[350Chevy]

That seemed to fix editpost.. thnx.. I'm quite tired.. going to bed.. I'm confused on why the old functions shows the first image attached while the edited one shows nothing.. Oh well..

Thnx for all the help..

[translucent]

I'm getting blank pages whenever I hit showpost.php, editpost.php, etc. During the install process, was I supposed to use sections labeled 'Find - This works with the "add attachment on edit post" hack' if I don't have that hack installed?

[350Chevy]

Today at 02:26 AM translucent said this in Post #65
was I supposed to use sections labeled 'Find - This works with the "add attachment on edit post" hack' if I don't have that hack installed?

No.. You weren't..

I was a little confused with that part of the hack as well (due to the type of wording he used.) Just skip anything that references "add attachment". I think there are only 2 instances of it and they're both in editpost.php.

That shouldn't effect they way you view posts. It's just the editpost part of it.

[350Chevy]

Today at 02:18 AM Link14716 said this in Post #63
Whoops...

Change

PHP Code:

       if(isset($qry)) {
        $qry .= " OR attachmentid='$value'";
       } else {
        $qry = "attachmentid='$value'";
       } 


To

PHP Code:

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


Even still, when I submit the edited post, it gives me a blank page and I look at the post and it is now completely blank...

EDIT: Whoops, I made anopther mistake in the above code. Re-apply that change if you have already applied it.

That works fine for editing posts with one attachment or no attachments.. but I get this when trying to edit a post with multiple attachments:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT filename FROM attachment WHERE attachmentid=2940,2941,2942
mysql error: You have an error in your SQL syntax near '2941,2942' at line 1

mysql error number: 1064

Date: Tuesday 29th of April 2003 09:37:55 PM
Script: http://www.ls6.com/forums/forums/edi...xxxxxxxxxxxxxx
Referer: http://www.ls6.com/forums/showthread...xxxxxxxxxxxxxx

[Hobbes]

could be that you didnt change ,'attachmentid' to 'attid' in one of the edits....dunno know...>.>

also, i was veryyyy confused on the editpost.php file edits....i still havent gotten it to work....i think i'll try again soon :bunny:

[Boofo]

Does this work with the old attachments we already have now?

[Link14716]

Yes, but I wouldn't recommend installing this right now. This has so many errors in it. This should be in Beta Hacks...