The Arcive of Official vBulletin Modifications Site.

[VB3 RC3] Attachments in private messages · **Released**: 01-06-2004

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.

sketch42 · #**197** 07-04-2004, 01:04 AM

Quote:

Originally Posted by Boofo

I don't run 3.0.1. I still run RC3. Sorry.

can someone update this for 3.0.1??

Ganon · #**198** 07-09-2004, 02:43 AM

The hack worked fine for me on 3.0.0, but I've recently upgraded to 3.0.3, and it is incompatable. Some of the file edits no longer work (searching for the code brings no result), and my best guesses to fix it don't work. I can attach files to PM's, but it brings up an error message when the user tries to view those files.

luroca · #**199** 07-09-2004, 09:57 AM

Yes, this very useful hack is not compatible with 3.0.3

PKRWUD · #**200** 07-14-2004, 03:06 PM

I am using 3.0.0, and am getting the following error when I try to view the attachment (both in the PM and in my CP)...

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/pkrwud/public_html/vbulletin/attachment.php on line 79

Any thoughts?

TTG · #**201** 07-15-2004, 10:48 AM

Was hoping to get this working in 3.0.1 :ermm:

Got stuck with this :-

# Code modifications in file "attachment.php"
search for this code:

Code:

if (!$attachmentinfo = $DB_site->query_first("
	SELECT filename, filesize, postid, attachment.userid,
		" . iif(!$vboptions['attachfile'] AND !$thumb, 'filedata,') . "
		" . iif($thumb, 'thumbnail, thumbnail_dateline AS dateline,', 'dateline,') . "
		visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted
	FROM " . TABLE_PREFIX . "attachment AS attachment
	LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
	LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
	WHERE attachmentid = $attachmentid
"))

Here's the nearest I could find in attachment.php

Code:

if (!$attachmentinfo = $DB_site->query_first("
	SELECT filename, attachment.postid, attachment.userid, attachmentid,
		" . iif($thumb, 'thumbnail AS filedata, thumbnail_dateline AS dateline, thumbnail_filesize AS filesize,', 'attachment.dateline, filedata, filesize,') . "
		attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,
		thread.forumid, forum.password, thread.threadid
	FROM " . TABLE_PREFIX . "attachment AS attachment
	LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
	LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
	LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = attachment.postid)
	LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
	LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)
	" . iif($postid, "WHERE attachment.postid = $postid", "WHERE attachmentid = $attachmentid") . "
"))

Keyser S?ze · #**202** 07-22-2004, 10:52 PM

ok this works fine for me in 3.0.1 BUT, when i load a PM with a attachment, takes forever, like a full 2 minutes to load the PM

thats the only problem, other PMs load very fast, almost instantly

moley · #**203** 07-25-2004, 12:12 PM

when i used it on 3.0.1 i got an error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE pmtext add attach int not null;
ALTER TABLE att

anyone know how to fix it?

Datenpapst · #**204** 07-26-2004, 01:27 PM

aren't privat messages privat and only for the users themselfs?

moley · #**205** 07-27-2004, 03:19 PM

a private message is from one person to another this hack can be used in this sorta of case user 1 made a new wallpaper and he wants to show his friend user 2. Instead of making a thread user 1 goes and makes a pm with the image attahment so that way the only two people who will see it are user 1 and user 2.

Also on your sites portal you seem to have latest thread replies twince once on the left hand colum and once under the latest news. justing pointing out.

weaver · #**206** 08-02-2004, 03:28 PM

I can't find either of these pieces of code in private.php. I'm running 3.0.3.

Quote:

$postid = verify_id('post', $attachmentinfo['postid']);

Quote:

verify_forum_password($foruminfo['forumid'], $foruminfo['password']);

Weasel · #**207** 08-24-2004, 03:32 AM

snobbymom, in that last piece of code just replace foruminfo with attachmentinfo everywhere you see it in the edit.

As for the " $postid = ..." I'm wondering the same thing myself. Its possible that that edit could be skipped.

Otherwise all of the edits are fairly straightforward even if they dont match the new 3.0.3 code exactly. Can anyone get this working in 3.0.3?

RobinHood · #**208** 09-12-2004, 12:37 AM

Oh, guess what? I got this working for VB 3.0.3!

Took me an hour, but I got it!

A working demo of it is at http://www.generazn.com.

I will post a fix for this hack very soon.

RobinHood · #**209** 09-12-2004, 01:13 AM

Okay, here is the fix!

First,

Open attachment.php:

Find:

PHP Code:


			
if (!$attachmentinfo = $DB_site->query_first("

    SELECT filename, attachment.postid, attachment.userid, attachmentid,

        " . iif($thumb, 'thumbnail AS filedata, thumbnail_dateline AS dateline, thumbnail_filesize AS filesize,', 'attachment.dateline, filedata, filesize,') . "

        attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,

        thread.forumid, forum.password, thread.threadid

    FROM " . TABLE_PREFIX . "attachment AS attachment

    LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))

    LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')

    LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = attachment.postid)

    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)

    " . iif($postid, "WHERE attachment.postid = $postid", "WHERE attachmentid = $attachmentid") . "

"))

Replace with:

PHP Code:


			
if (!$attachmentinfo = $DB_site->query_first("

    SELECT filename, attachment.postid, attachment.userid, attachmentid,

        " . iif($thumb, 'thumbnail AS filedata, thumbnail_dateline AS dateline, thumbnail_filesize AS filesize,', 'attachment.dateline, filedata, filesize,') . "

        attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted, private, 

        thread.forumid, forum.password, thread.threadid

    FROM " . TABLE_PREFIX . "attachment AS attachment

    LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))

    LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')

    LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = attachment.postid)

    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)

    " . iif($postid, "WHERE attachment.postid = $postid", "WHERE attachmentid = $attachmentid") . "

"))

Next, find:

PHP Code:


			
if ($attachment['postid'] == 0 AND $bbuserinfo['userid'] == $attachmentinfo['userid'])

On top of that, add the following:

PHP Code:


			
if (!$attachmentinfo['private']) {

    $postid = verify_id('post', $attachmentinfo['postid']);

}

Next, find:

PHP Code:


			
if (!($forumperms & CANVIEW) OR !($forumperms & CANGETATTACHMENT))

    {

        print_no_permission();

    }



    // check if there is a forum password and if so, ensure the user has it set

    verify_forum_password($attachmentinfo['forumid'], $attachmentinfo['password']);

Replace it with the following:

PHP Code:


			
if (!($forumperms & CANGETATTACHMENT))

{

    $vboptions['viewattachedimages'] = 0;

    $vboptions['attachthumbs'] = 0;

}



// check if there is a forum password and if so, ensure the user has it set

    verify_forum_password($attachmentinfo['forumid'], $attachmentinfo['password']);



$pmUsers = $DB_site->query_first("SELECT toUserArray FROM ".TABLE_PREFIX."pmtext WHERE pmtextid='".$attachmentinfo['private']."'");

    $toUserArray = unserialize($pmUsers['toUserArray']);         

    if ($toUserArray[$bbuserinfo['userid']] != $bbuserinfo['username'] && $attachmentinfo['userid'] != $bbuserinfo['userid']) {

            print_no_permission();        

           }

THAT'S IT! YOU'RE DONE!

It should be working now. If not, let me know because it is working for me.

btappan · #**210** 09-12-2004, 08:34 PM

Props to RobinHood! up and working on my forums, no problems thus far! man does this hack take a while to install though!

Weasel · #**211** 09-14-2004, 02:00 AM

I'm having problems with your code RobinHood, it seems to break the permissions of normal attachments, i.e. no one can view them now.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05888 seconds Memory Usage 2,394KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (6)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!