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

[LincolnForums]

couldnt get to work on my php5 and mysql5 server, could it be just an issue with that?

[DruidToolz]

I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

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

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

[Kimah72]

Hi, I got everything changed but when I went to do the SQL Queries, I ran into

error number: 1146
error desc: Table 'momswit_Forum.attachment' doesn't exist

also when running all of them at the same time, I get this error.

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

I don't know what I am missing. Could you please help? This would be a nice hack to have on my board. Thanks!

[dsotmoon]

is this working ok in 3.5.4 ?

[DruidToolz]

Well i have all the modifications setup up on 3.5.4 I just wish there was an easier way then editing the sql query tables.. The reason i say this is i got a failed message which i didn't want to try it again unless i either backup my database or write over it and hope it doesn't mess up.. So please can someone help me with this.. Thnx

[GoodKarmaKid]

I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

[Rickie3]

Originally Posted by GoodKarmaKid

I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

you need to edit your config.php with your id to allow to run queries,go to your server where your forum is installed then find includes folder inside the includes folder you will find config.php look for this code note in my code id is set at 1,edit to your user id then save you will now be able to run queries from your admin CP hope that helps

//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

[gcphost]

Hey all I am able to upload images and possibly other items but im trying to upload a tar.gz, it uploads with no problem (so it seems) but when adding to mysql its adding the content of the binary to the db causing this:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO vb_attachment
	(dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)
VALUES
	(1143537565, 1143537565, 1, 1, 'gz', 'GameCP-Master-Stable-0.9.9.85.tar.gz', 'd59e42333cabdd9a8beefd91d82bc5c3', '46ed6412a916564e3579c79019515e88', 1135938, '‹\0<’$D\0?Z	xU?Š@J?(*?M?!,?5d%K?H\',K*?•?\"?UEUuw:,2+#?€ˆ

Any thoughts?

[Rickie3]

installed and working great thanx

[defcon_420]

Originally Posted by DruidToolz

I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

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

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

i'm using 3.5.4 and get the same error as well... looks like there is no support for this one