Private Attachments! (Attachments in Private Messages)

*drums*
This hack is now out of beta! Safe to use.

My latest and one of the more extensive hacks -- Private Attachments!
This huge (I ain't kidding, it's pretty big) hack will allow your members to send private messages with attachments in them, so they don't need to use e-mail for that.

Since this hack requires a large number of edits, this is how I recommend installing it:
(a) Run the queries.
(b) Edit all the files, offline.
(c) When you are done with (b) upload all the files at once.
(d) Perform the template edits.
If you do all actions in this order your users shouldn't notice you are installing the hack.

All feature requests (except for limiting this for usergroups -- if you want that do it yourself it's not hard but I'm tired of adding permissions to the dreaded usergroup.php) are welcome before this goes out of beta.

As always, have fun.

[Hellburn]

hmm is nobody here there can fix this hack?

I want that only mods and admins can posting attachements. Can everybody help me?

[grooveh]

Great hack!!! Thanks a ton!

[trainer]

Originally posted by Hellburn
hmm is nobody here there can fix this hack?

I want that only mods and admins can posting attachements. Can everybody help me?

it would be nice to specify the usergroup allowed to use PM attachments

[Bison]

Originally posted by Hellburn
hmm is nobody here there can fix this hack?

I want that only mods and admins can posting attachements. Can everybody help me?

You can probably do that yourself ... a simple "if ($usergroup=6 || $usergroup=7){ condition before all functions that does the attachment procedure ... when help is not given when you request it, somemight help you if you attempt to do it for yourself. You might get a quick response for trying yourself!

[TheComputerGuy]

Hi I am having the same problem as IceMalee...I get some database errors at line 1

PHP Code:

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid,receipt,attachmentid) VALUES (NULL,1,1,1,'test','test',1033217057,'0','0',0,0,1,)
mysql error: You have an error in your SQL syntax near ')' at line 1 


Any help would be great.

[ontherun]

I really want to install this Hack, but after reading all post and downloading the the text file, I have one question.

Has the install privattach.txt file been updated with all the changes I see in the 5 pages of post? Or do I have to follow the instructions and then come back and make the other changes I see posted here?

Thanks

[VAN]

Database error in vBulletin 2.2.6:

I'm getting the following error aftertrying to send a PM:

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,showsignature,iconid,messageread ,folderid,receipt,attachmentid) VALUES (NULL,1,1,1,'hahah','ahaha',1036464302,'1','0',0,0 ,1,)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064

Is Firefly still watching this thread?I Hope.

[ontherun]

Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,vi sible,private) VALUES
(NULL,1,1036510300,'java msg anim.txt','','1','1')

mysql error: Unknown column 'private' in 'field list'

mysql error number: 1054

Date: Tuesday 05th of November 2002 08:31:40 AM
Script: http://dev.********.com/private.php
Referer: http://dev.********.com/private.php?...age&userid=218

Hey FireFly Got your Wings On? Or is this now a unsupported HACK now that its out of Bata?

[Bison]

You forgot to add the field 'private' in your database ....

[Erwin]

Read the statement under the thread title:

"The hacker cannot guarantee to provide support for this hack."

Also, most of the problems are because the installer has not followed the instructions properly. For example, like Rolodex said, you didn't run the query to insert the column "private" in the "attachment" table.