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

[gemmagy]

Originally Posted by 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)
	);

Thanks, I restored my forum back to wait for an answer. Will this take care of the naming of the tables? Support said I need to add a prefix to the name of the tables.

I really appreciate your help, I will give this a try in the next day or two.
gemmagy

[msimplay]

Originally Posted by 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)
	);

would this work on vb3.0 ?

[paulomt1]

I had installed this hack in VB 3.0.7 but I have a problem!
When I click in the button Manage Attachments in new PM screen, opens the window for manage attachments but only say this:
Sorry! This forum is not accepting new posts.

Please help, I have lot's of PM with attachments and I need this working in this new version.

Thanks
Sorry my English.

[smess]

Does anyone have a clue as how to make this work for 3.0.3. I now have broken pictures and pm's that don't get attachements

[DivisionByZero]

Originally Posted by paulomt1

I had installed this hack in VB 3.0.7 but I have a problem!
When I click in the button Manage Attachments in new PM screen, opens the window for manage attachments but only say this:
Sorry! This forum is not accepting new posts.

yeah me too... same error!

[DivisionByZero]

hello????

[josian]

Im using file system for attachments storage, how can I use this hack if the code is written only for db storage type?

Also, can I limit the extensions to be allowed in the PM? apart from the regular forum extensions.

thanks!!

[bkaul]

Hmm... looks like an interesting hack; I might try it if I see verification that it works in 3.0.7...

[jbell]

what would be the syntax to uninstall should I ever need to?

[paulomt1]

Anyone can fix this hack for working in vb 3.0.7?
I really need this one. I can pay for it.

Thanks
Thinking Games