Attachments in calendar events

Why isn't there a category for calendar hacks? Oh well..

This was originally developed for Davelogic, with this hack you can add attachments to your calendar events. The attachment will show up at the end of the event.

In any event you add (single event, recurrent or ranged) you can
add attachments the same way you can add them to a post (ie, a pop-up
will appear asking you for the attachments). Then the attachments
will show in the event once submitted.



The installation instructions are for a non-hacked RC4 board, instructions would vary if you have other hacks intalled, and would be really different if you have any other attachment hacks installed.

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.

[Lee Wilde]

Thank you! Installed in minutes without a single hitch. Very impressed.

[Lee Wilde]

Kentaurus, I'm surprised more people haven't installed this hack. I myself came across it a couple of weeks ago but didn't realise exactly what it was, so I didn't bother installing it at the time.

Perhaps if the name of the hack was "Images in Calendar Event".....or...."Add Images to Calendar Events"?

[moonclamp]

Worked first time, I can see this being very useful

*clicks install*

!ping ...

is there an update to come for 3.0.3+ ???
there is not much to change, maybe just the attachement.php file to verify

[spence2]

So, this will not work in 3.03 "as is"?

[D|ver]

now i installed this. a really great hack

i also don't understand why just a few people installed it. this is really a great addon

but i have a little problem:
holidays are shown with all attachments of the whole forum...

anybody got the same problem?

[Mattius]

Towards the end of the instruction file it says to modify this part in attachments.php

-------------------------------------------------------------------
search for this code:
-------------------------------------------------------------------

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

-------------------------------------------------------------------
replace it with:
-------------------------------------------------------------------

if (!$attachmentinfo['calendar']) {
$postid = verify_id('post', $attachmentinfo['postid']);

-------------------------------------------------------------------
search for this code:
-------------------------------------------------------------------

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

------------------------------------------------------------------
replace it with:
-------------------------------------------------------------------

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

Im using 3.0.3 btw. Now the modification of the query just above it is there and can be modified ok, but i cant find this code for the life of me.

Looked in both a fresh attachments.php
and my hacked version and.....nudda.

Please help

[Mattius]

OK strange i got the attachment in calendars to work now, but not pm's

[theArchitect]

Originally Posted by Mattius

OK strange i got the attachment in calendars to work now, but not pm's

We really should stop meeting like this.

I only just found this hack and given my issues with the missing code in 3.0.3 for the PM hack am wondering if I will have similar problems with this one. Did you have to make any modifications to get this working?

[robert_2004]

here's the first part fixed for forum/attachment.php

PHP Code:


// attachments for event calendar mod - START
/*
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") . "
"))
*/
if (!$attachmentinfo = $DB_site->query_first("
    SELECT filename, attachment.postid, attachment.userid, attachmentid, filesize,
        " . iif(!$vboptions['attachfile'] AND !$thumb, 'filedata,') . "
        " . 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, visible, calendar
        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") . "
"))

// attachments for event calendar mod - END 


i haven't tried it yet, though. i can't get the next steps done myself.