PM Attachments 3.5

Original Hack by Rigel Kentaurus (http://www.cemzoo.com)
Original Thread: https://vborg.vbsupport.ru/showthread.php?t=91220
See the original thread for details of the problems..

Basically everything has been fixed so this works with existing installs and not just clean ones, also no error message about a non-matching release anymore.. attachments are now correctly displayed as they would be in a thread and this hack No longer inteferes with non-pm attachments.. So all the good bits left (Attachments in Private Messages, using the existing usergroup permissions) and all the bad bits taken out.

Also I'm willing to support this hack, which is why I took the decision to start a new thread rather than use the existing one so I can easier support the hack and problems with this plugin not the old buggy one. (or at least that's the theory)

Please uninstall the old plugin first, thanks.

QuickFaq
I'm getting Invalid Post specified:
That means the plugin was unable to get attachments permissions for the user. The solution is to locate a thread in your forum (one that shouldn't be deleted in a long time, it doesn't matter if it's closed). Remember it's threadid
Go to Plugin Manager and click on "private attachments - get posthash and allow attachments"

Find: $_pmt = 1;


Replace the "1" with the threadid

[predatorkill]

I ve run this query:

ALTER TABLE xxxx_attachment add usedin varchar(30) not null;

AND

I get the following mysql error:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT attachmentid
FROM xxxx_attachment AS attachment
LEFT JOIN xxxx_pmtext AS pmtext ON attachment.usedin='pmtextid' AND attachment.itemid=pmtext.pmtextid
WHERE
pmtext.pmtextid IS NULL
AND usedin<>''
AND itemid<>'';

MySQL Error : Unknown column 'usedin' in 'where clause'
Error Number : 1054

any solutions?Thanks in advance!

How can i revert the table back to normal?

[Kuimera]

Originally Posted by lowandloudinc

the code your looking for is at the top of the template you need to look in
about 5 or 6th line i think

Hey m8, I put there the code I got, if you make a search, you will not find the "$_pmt = 1;"

Prob I?m dumb, dont know...

[WNxWakko]

Were do the attachments go? I attach to a PM, it lists it in the popup window, I submit. When I do it again, the popup window doesnt show it in my attach inventory, nor does it in my main attachment inventory. Is it just a floating attachment or something? Oh and where it would normally list my attach inventory, it says array and nothing more.

[Sychev_S]

I get this error when tryign to send pm with attachment:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='333';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Sunday, November 13th 2005 @ 01:54:34 PM
Script : http://www.talkinto.com/forums/private.php
Referrer : http://www.talkinto.com/forums/private.php?do=newpm&u=5
IP Address : 209.158.71.16
Username : Administrator
Classname : vb_database

I can also NO longer add regualr attachments to post...
anybody knows how to fix that?

[Sychev_S]

Nvermind.
I configured config.php to allow me run quiries from admincp (used to run form phpmyadmin).
I ran them, everything is back to normal but I still cannot send attachments. I attach them, but when other person opens pm he sees no attachments there. No errors.

[Sychev_S]

okey, I just deleted plugin and installed it again.
Works perfectly now! vb 3.5.0
Thank you!

[zendiver]

Will this work for 3.5.1?

[Snake]

Yes it will.

[zendiver]

Installed and works great.

[zendiver]

A little hasty I was. It works for me, BUT others get this error:

Close this window Manage Attachments
Upload Errors
Picture 23.jpg:
File system directory is not writable.

I thought this was storing the attachments to the same place the threads are? I checked my permissions there and they are set to 777