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

[Andreas]

That's not the problem. newattachment.php is

[akanevsky]

Umm... Doesn't newattachment.php receive something like posthash or something of that kind that identifies whether what it's for? I am not sure, but when I did the "attachment in calendar" hack, I did something like that to distinguish between attachment that were intended for posts and attachments that were intended for calendar entries

EDIT:

Oh... I remember - the way I did it was I added a new field to the attachment table that identified where the attachment had to belong.. didn't use permissions for threads... I'm sure this can be done for PMs too

[Mastar]

I ran this:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid)

And got this:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE attachment add itemid int not null;
ALTER TABLE

Any Ideas??

[BluPhoenix]

Originally Posted by Dark Visor

Hey bro, are you sure this should use thread permissions for whether they can attach or not? I think this should be separate

Yes the true 3.5 Gold Version allows for seperate quotes and permissions for attachments in pm's than to threads.. So you can have a user set to no for pm attachments but yes for threads, and vice versa.. also a usergroup can have an unlimited quota for threads, but only 100Mb for PMs.. pm attachments are now stored in a seperate table or directory (depending on your file storage settings) right now it does require a number of edits but they are slowly being worked out of the final product..

A "Lite" Version (Zend Encoded and with a max of fifty pm attachments sent. so you can get a feel for how the system works) will be available shortly.

A "FULL" Version (Not Encoded and no Limits) is available now but due to the amount of work that has gone into this isn't free. As all commercial talk is a no-no. PM me for details.

[BluPhoenix]

Originally Posted by Mastar

I ran this:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid)

And got this:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE attachment add itemid int not null;
ALTER TABLE


Any Ideas??

I assume your using the SQL Queries option in the AdminCP? If so Each Query must be run seperately one at a time.

[Mastar]

Originally Posted by BluPhoenix

I assume your using the SQL Queries option in the AdminCP? If so Each Query must be run seperately one at a time.

Yes, thank you! No errors and everything seem to work great so far. Will post if anything changes. Thanks again!

[Robru]

version 3.5.0 GOLD

Please, see attachments. How I can showing the image?

[BluPhoenix]

Originally Posted by Robru

version 3.5.0 GOLD

Please, see attachments. How I can showing the image?

You need to add a zip.gif file to your images/attach folder.

[BluPhoenix]

Installs: 69

*childish giggle*

[davidw]

ALTER TABLE pmtext add attach int not null; would not work (the others did)
#1060 - Duplicate column name 'attach'

Also, attachments can be uploaded, but none will be sent or displayed in pm.