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.

[Keyser S?ze]

getting this error Database error in vBulletin 2.2.5:

Invalid SQL: SELECT privatemessage.*,icon.title as icontitle,icon.iconpath,attachment.attachmentid,at tachment.filename,attachment.counter
FROM privatemessage
LEFT JOIN icon ON (privatemessage.iconid = icon.iconid)
LEFT JOIN attachment ON (attachment.attachmentid = privatemessage.attachmentid)
WHERE privatemessageid=97729
mysql error: Unknown column 'privatemessage.attachmentid' in 'on clause'

mysql error number: 1054

Date: Thursday 02nd of May 2002 07:13:57 PM
Script: http://www.emusanet.com/forums/forum...essageid=97729
Referer: http://www.emusanet.com/forums/private.php?s=


i assume thats a problem with my private.php file, its attached, as far as i can tell everything is fine with it

----

Originally posted by sub
Awesome hack! Installed this for 2.2.5 had to improvise a template for it to work but other than that it went smoothly.

can u explain that pls?

[JagenSWPC]

Originally posted by FireFly
*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.

my txt is [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth]ed up

PHP Code:

<?php
// removed
?>

[Recluse]

any reason why when i delete the messages from the sender and reciver that the attachments are still in the database?

[tkeil69575]

Hallo fire,
I have a weird error with this one. All seems to be working but if I have a look at my pm sent box a day later, then the attachment is gone. The attachment Icon in the pm does not show up anymore and the amount of downloads also no longer. This attachment link is also gone.

Any Ideas what that might be. This happens on the sender als well as the recipient side.

greetings tina

[globalwin]

can anyone please help me get thisd hack working cause it still doesnt work with kidney's fix

[Keyser S?ze]

getting this error when i try to view a attachment

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT forumid FROM thread WHERE threadid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Saturday 22nd of June 2002 06:26:17 PM
Script: http://www.totalshock.net/forums/for...atemessageid=5
Referer: http://www.totalshock.net/forums/pri...atemessageid=5


any help pls

[dreamhost]

I am able to attach files to pm's however when a person goes to view them they get
Parse error: parse error in /home/xxxxxxxxxxxxxx/forums/attachment.php on line 67

I did this step correctly
In file attacment.php replace this: |
+-------------------------------------------------------------------------------------------------+
updateuserforum($getforuminfo['forumid']);
+-------------------------------------------------------------------------------------------------+
| |
+-------------------------------------------------------------------------------------------------+
| With this: |
+-------------------------------------------------------------------------------------------------+
if ($privateok==0) {
updateuserforum($getforuminfo['forumid']);
}

-----------------------------------------------------------------------
the updateuserforum line is line 67 in my file
here are the lines surrounding that part

if ($privateok==0) {
updateuserforum($getforuminfo['forumid']);
}
$getforuminfo['threadid']);

if ($noshutdownfunc) {

does anyone see any errors here?
thanks in advance.
p.s. it seems to have problems attachming anywhere even to posts.

[DrkFusion]

Nice work Chen

*clicks install*

[Admin]

Email me your attachment.php file by email.

[wot-Mike]

Oh bummer

This one is no longer working. Upgraded to vB2.2.6 a while ago, and changed php (register_globals = Off)

Now there's no more attachment in pm's. I've taken a peek with phpMyAdmin, and the private message that's supposed to have an attachment shows no attachmentid (= 0)

:ermm: