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]

rake i redownload the zip file and redo the editpost.php adn i got this error

Parse error: parse error, unexpected '}' in /home/forum/editpost.php on line 421

and in ur txt file u say

PHP Code:

================
Find - This works with the "add attachment on edit post" hack
================

    eval("\$editattachment = \"".gettemplate("newpost_attachment")."\";");


==================
Replace With
==================

    $maxattachsize_temp = getmaxattachsize ();
    mt_srand ((double) microtime() * 1000000);
    $posthash = md5(mt_rand());
    $poststarttime = time();
    $forumid = $threadinfo[forumid];
    eval("\$editattachment = \"".gettemplate("newpost_attachment")."\";"); 


above this

eval("\$editattachment = \"".gettemplate("newpost_attachment")."\";");

already have this

$maxattachsize_temp = getmaxattachsize ();

so i think it should be

PHP Code:

 $maxattachsize_temp = getmaxattachsize ();
eval("\$editattachment = \"".gettemplate("newpost_attachment")."\";");

==================
Replace With
==================

 $maxattachsize_temp = getmaxattachsize ();
    mt_srand ((double) microtime() * 1000000);
    $posthash = md5(mt_rand());
    $poststarttime = time();
    $forumid = $threadinfo[forumid];
    eval("\$editattachment = \"".gettemplate("newpost_attachment")."\";"); 


and i have install custom prefix hack i dont know if that will effect this hack...

[rake]

iggy: You must have have done the hacking incorrectly.

squawell:

PHP Code:

=============
Still in editpost.php, find:
      $attids = implode(",", $attid);
      $attids = iif($attids=="",0,$attids);
      $attachmentsql=",attachmentid='$attids'";
            }
And replace with:
      $attids = implode(",", $attid);
      $attids = iif($attids=="",0,$attids);
      $attachmentsql=",attachmentid='$attids'"; 


This part deals with that error.

[iggy123]

Ok i have gone through the code and found an extra } in the code, when i deleted that everything worked fine (ish)

Now the dreeded "you don't have permission to access this page" is back LOL

ok found the fix for the permissions problem....


https://vborg.vbsupport.ru/showthrea...160#post389160

if you apply the changes in that post it works fine Until you try to edit the posts and then i get the following error message:

PHP Code:

Database error in vBulletin 2.3.0:

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

mysql error number: 1064

Date: Wednesday 30th of April 2003 03:10:42 PM
Script: [url]http://xxxxx/forums/forums/editpost.php?action=editpost&postid=3361[/url]
Referer: [url]http://xxxxxx/forums/showthread.php?threadid=459[/url]
Repair Report: This type of error cannot be automatically repaired. 


[squawell]

Today at 03:42 AM rake said this in Post #92
iggy: You must have have done the hacking incorrectly.

squawell:

PHP Code:

=============
Still in editpost.php, find:
      $attids = implode(",", $attid);
      $attids = iif($attids=="",0,$attids);
      $attachmentsql=",attachmentid='$attids'";
            }
And replace with:
      $attids = implode(",", $attid);
      $attids = iif($attids=="",0,$attids);
      $attachmentsql=",attachmentid='$attids'"; 


This part deals with that error.

ok i got that work~~~but when i click the post where have multiple attachment files and i got this error

Invalid SQL: SELECT licensedviewforum,licensedattach FROM forum WHERE forumid=
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 '' at line 1

mysql error number: 1064

[rake]

Well, i've removed every instance of that in the updated zip. What file does that appear in?

[rake]

Today at 08:55 PM iggy123 said this in Post #93
Ok i have gone through the code and found an extra } in the code, when i deleted that everything worked fine (ish)

Now the dreeded "you don't have permission to access this page" is back LOL

ok found the fix for the permissions problem....


https://vborg.vbsupport.ru/showthrea...160#post389160

if you apply the changes in that post it works fine Until you try to edit the posts and then i get the following error message:

PHP Code:

Database error in vBulletin 2.3.0:

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

mysql error number: 1064

Date: Wednesday 30th of April 2003 03:10:42 PM
Script: [url]http://xxxxx/forums/forums/editpost.php?action=editpost&postid=3361[/url]
Referer: [url]http://xxxxxx/forums/showthread.php?threadid=459[/url]
Repair Report: This type of error cannot be automatically repaired. 


first post. :speechless:

[squawell]

Today at 04:17 AM rake said this in Post #95
Well, i've removed every instance of that in the updated zip. What file does that appear in?

rake in my case

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT licensedviewforum,licensedattach FROM forum WHERE forumid=
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 '' at line 1

mysql error number: 1064

Date: Thursday 01st of May 2003 04:16:28 AM
Script: http://xxxx/forum/forum/attachment.p...tachmentid=234
Referer: http://xxxx/forum/showthread.php?s=&...=1382#post1382

[iggy123]

If i delete the attatchment.php it works fine - kind of, I can edit the post , add new files but can't view them.
If i keep the attachment.php i get the sql error so I assume its something in there that is causing the errors..

[GaleForce]

Good job! I may install this later if I have some time

[rake]

Today at 09:20 PM squawell said this in Post #97
rake in my case

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT licensedviewforum,licensedattach FROM forum WHERE forumid=
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 '' at line 1

mysql error number: 1064

Date: Thursday 01st of May 2003 04:16:28 AM
Script: http://xxxx/forum/forum/attachment.p...tachmentid=234
Referer: http://xxxx/forum/showthread.php?s=&...=1382#post1382

Not in my hack.



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