[VB3 RC3] Attachments in private messages

Unsupported. VB3.5 version is here:
https://vborg.vbsupport.ru/showthread.php?t=91220

Tested on 3.0.3

This hack enables you to send attachments in a private message. This feature was really useful to me in vb2 and I kind of missed it on vb3 so I rehacked it myself.

When a user writes a private message they will be given the option to add an attachment, the same as when writing a post. It uses the same rules you have defined for a convencional attachment including file types, quotas, etc. It is only an extension for attachments to be used in private messages.

As always it is advised to backup your files before hacking in case you want to go back, this is some big hack including modification of multiple files, some templates and adding two extra columns in the database tables.

Instructions are provided in the txt, and some screenshots on where the attachment option appears.

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

Edit by MarcoH64:
Because of multiple requests to make this hack work on vB3.0.7 i created upgrade instructions. These upgrade instructions can be followed after the original instructions (the 3.0.3 version). The original coder can not be held responsible for my modification.

[btappan]

uh, did you read any of this? its working for it now

[ezsouljahs]

Add a new phrase and make sure it is in the "posting" phrase type, otherwise it won't work

phrase: in_private_message
Text: Private Message

how do i add a new phrase

[h75]

I get an error, wenn i attach an txt-file an klick send. :nervous:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
UPDATE attachment
SET private = , posthash = ''
WHERE posthash = '7812b835551ecc43a34408135f1b1774' AND
userid = 1

mysql error: 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 ' posthash = ''
WHERE posthash = '7812b8

mysql error number: 1064

Datum: 10.11.2004 13:05:01
Skript: http://halloo.de/private.php
Referer: http://halloo.de/private.php?do=newpm&pmid=619
Benutzername: H75
IP-Adresse:

[h75]

and this:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage: INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (, 1, -1, 1)
mysql error: 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 ' 1, -1, 1)' at line 1

mysql error number: 1064

Datum: 10.11.2004 13:07:40
Skript: http://halloo.de/private.php
Referer: http://halloo.de/private.php?do=newpm&pmid=619
Benutzername: H75
IP-Adresse::

[seraphex]

ok.. I've installed this and reverted back to my original files (other than my template edits) like 4 times. It looks like everything works except the attachment does not show up in the pm when it's opened. I just noticed that I had the following line wrong in my pm_newpm template. And I'm curious if this would cause the attachment to not show up. I'm almost done removing it and I hate to redo everything again just to find out that this had no effect on things. Here's the line I had wrong (just missing the closing >):

<input type="hidden" name="poststarttime" value="$poststarttime" /

vs.

<input type="hidden" name="poststarttime" value="$poststarttime" />

[JKeats]

nm... fixed. sorry.

[Scerina]

I just upgraded to version 3.03 and I am having problems editing the attachment.php file cause it differs from 3.0 and am sure the other files are the same way. I manage to edit private.php file with no problem.

Is this hack compatiable with version 3.03 and if so, what are the file modification instructions for it? Thanx in advance

[T3MEDIA]

Thank god I read this last post.

I thought they said this was 3.0.3 compatable.
I really dont like the idea of this site. Its soo cool that users help and put up hacks but It feels like we are greedy lab rats. I wish they made it that once its 100% its like a install. you click enter what ever and "patch" your site.
keeps a record and ya set. that way if I make a hack that confilcts you will know. blah blah does not work with this patch.

Im I crazy or does that make sense? shoot I would pay for that.

[T3MEDIA]

Ok works like a charm. Thank you. Only down side is the attachments stay. If I send a private message it should be on his/hers quota not mine. so if they want to keep it they can. also what if you want to send 3 differn people a picture of youself. you already have it saved on the site. so you cant re upload it. you have to delte your attachments. it should be a bit more seperate in that sense from forums.

[BlasterT3]

thanks alot for this hack i love it but i think i might of found a bug

as u can see in the attached img the file i attached in a pm shows up twice

[T3MEDIA]

Originally Posted by T3MEDIA

Ok works like a charm. Thank you. Only down side is the attachments stay. If I send a private message it should be on his/hers quota not mine. so if they want to keep it they can. also what if you want to send 3 differn people a picture of youself. you already have it saved on the site. so you cant re upload it. you have to delte your attachments. it should be a bit more seperate in that sense from forums.

Agreed. Can someone get a work around on this? Just have it put on that users quota and its fixed. Also maybe a cronjob to check to see if the user doesnt exist remove the PM.

This hack isnt finished if you think about it.
BUT what a nice idea. its like internal email now.

[dookie]

Is this hack working in 3.0.6?

[gemmagy]

I am brand new at this, I just got my database and tried to load this. I followed the directions very carefully. When I got to the part where I query I got the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'scribble_forum.pmtext' doesn't exist

my forum is completely down now. Please help me.
Gemma

[gemmagy]

Originally Posted by gemmagy

I am brand new at this, I just got my database and tried to load this. I followed the directions very carefully. When I got to the part where I query I got the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'scribble_forum.pmtext' doesn't exist

my forum is completely down now. Please help me.
Gemma

One more thing to add. When I go to my database on the server the file pmtext is there but it's titled jelsoft_pmtext,,,, not scribble_forum.pmtext. Every file is titled that way, with the jelsoft in front of the files. Am i going to have this issue everytime i do a query?????

[gemmagy]

I tried to contact vbulletin to see if they could help me this is their answer:

It sounds like you are trying to install a resource from vBulletin.org. We do not give support for customizations as we aren't the author of that code. I suggest to contact the author of this resource. Ask him to update his code to take table prefixes into account. Your table prefix is jelsoft_ if I remember correctly.

please help!!!