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.

[rake]

Today at 02:34 AM Boofo said this in Post #131
I just got this error when I ran the portattachments.php. What do I do?



Database error in vBulletin 2.2.9:

Invalid SQL: UPDATE attachment SET postid=193 WHERE attachmentid=56
mysql error: Unknown column 'postid' in 'field list'

mysql error number: 1054

Date: Wednesday 30th of April 2003 06:32:17 PM
Script: http://www.bearfacts2.com/forum/foru...ttachments.php
Referer:

You've missed a query.
Yes, i'll gladly help, Boofo.


Current TO DO List:
Fix the first two errors reported by 350Chevy.
Fix the Delete Error.

[Boofo]

I was starting to do a fresh install. I ran the queries in the part of the code for the new install. Do I need to run portattachments.php on a new install. If so, can you please tell which query I missed?

Thank you for the help. What files do I need to PM to you to do the code changes?

[Boofo]

I need to reverse the queries for this hack until I can get the code changes to get it installed. I can't post or make any new threads. Here is the error I am getting:

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT a.attachmentid
FROM attachment AS a
LEFT JOIN post ON (post.attachmentid = a.attachmentid)
LEFT JOIN privatemessage ON (privatemessage.attachmentid = a.attachmentid)
WHERE postid IS NULL AND privatemessageid IS NULL

mysql error: Column: 'postid' in where clause is ambiguous

mysql error number: 1052

Date: Thursday 01st of May 2003 07:11:40 AM
Script: http://www.bearfacts2.com/forum/foru...ead&forumid=11
Referer: http://www.bearfacts2.com/forum/foru...?s=&forumid=11

Can anyone please tell me how to revert the queries back to what they were before I ran them for this hack for now? These are the queries I think that need to be converted back to the originals until rake can help me with the coding.

ALTER TABLE `post` CHANGE `attachmentid` `attachmentid` VARCHAR( 50 ) DEFAULT '0' NOT NULL;
ALTER TABLE `post` ADD INDEX ( `attachmentid` );
ALTER TABLE `attachment` ADD `postid` INT NOT NULL;
ALTER TABLE `attachment` ADD INDEX ( `postid` );

[350Chevy]

Today at 11:58 AM rake said this in Post #141
You've missed a query.
Yes, i'll gladly help, Boofo.


Current TO DO List:
Fix the first two errors reported by 350Chevy.
Fix the Delete Error.

Thanks Rake... This is still probably the best hack out there. :classic: :banana:

[Boofo]

Can anyone please lend a hand with my problem (posted in Post # 143 above)? My forums are down until I can get this fixed.

[rake]

If you don't count the errors, that is. :nervous:
You have to try to see this from my point of view too. The hack makes changes in 4 of the most important vbulletin files. You never know when a new error might come up. I tested it on a few boards and everything seemed allright, so i thought putting it in the Full Releases forum was a good idea.



====================

Version 1.3

This new version fixes all of the reported bugs:

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

Please re-download the file in the first post. Thank you
https://vborg.vbsupport.ru/showthrea...561#post388561

Boofo: That isn't from my hack, but replacing:
WHERE postid IS NULL AND privatemessageid IS NULL
with
WHERE post.postid IS NULL AND privatemessageid IS NULL
should work

[Austin Dea]

I'm still getting the db error when trying to delete a post. I did all of the 1.3 updates..

[rake]

Today at 05:11 PM Austin Dea said this in Post #147
I'm still getting the db error when trying to delete a post. I did all of the 1.3 updates..

the two functions.php changes handle that.

[iggy123]

RAKE


Your latest update has fixed all of my problems - thnx for spending the time to fix it - i bet next time you wont offer support

[Austin Dea]

Sweet, cleared my cache and it works.