[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.

[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!!!

[gemmagy]

Originally Posted by 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!!!

Here's the email I got from my database when one of the mods went into the GUI pm:

Database error in vBulletin 3.0.6:

Invalid SQL:
DELETE FROM jelsoft_attachment
WHERE postid = 0 AND private = 0 AND
dateline < 1108738351
mysql error: Unknown column 'private' in 'where clause'

mysql error number: 1054


and,,,,,,,,,,,,,,,,,,,,,

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT
pm.*, pmtext.*,
icon.title AS icontitle, icon.iconpath,
IF(ISNULL(pmreceipt.pmid), 0, 1) AS receipt, pmreceipt.readtime, pmreceipt.denied, attach
FROM jelsoft_pm AS pm
LEFT JOIN jelsoft_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN jelsoft_icon AS icon ON(icon.iconid = pmtext.iconid)
LEFT JOIN jelsoft_pmreceipt AS pmreceipt ON(pmreceipt.pmid = pm.pmid)
WHERE pm.userid=3 AND pm.pmid=128

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

mysql error number: 1054

[T3MEDIA]

Originally Posted by T3MEDIA

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.

bump?

[gemmagy]

Hi,

Can anyone please help me, my forum is down. Please see the other for posts I posted yesterday.

Please help!!
gemmagy

[gemmagy]

Bump!

Please read the previous four posts I posted.

Gemma

[BluPhoenix]

Maybe too late now but here goes..

in includes/cron/cleanup2.php find:

$attachments = $DB_site->query("
		SELECT attachmentid, userid
		FROM " . TABLE_PREFIX . "attachment
		WHERE postid = 0 AND private = 0 AND
		dateline < " . (TIMENOW - 3600)
	);

and change it to:

$attachments = $DB_site->query("
		SELECT attachmentid, userid
		FROM " . TABLE_PREFIX . "attachment AS pmattach
		WHERE pmattach.postid = 0 AND pmattach.private = 0 AND
		pmattach.dateline < " . (TIMENOW - 3600)
	);