Calendar Enhancements - vB Event Forums

Introduction

This is a continuation of my Event Forums plugin/addon from 3.5. You can find the old version here. The original plugin was developed by Endquote, and I have since taken it over to bring it to what it is today. I hope you can find it useful!

What is this addon?

This is a plugin which allows you to create relationships between calendars and events, giving each event a thread of its own for users to discuss. I have tested this alot, and I am running it myself on a live board.

Sure, so whats it do?

Some examples of the features this plugin offers

• When a new event is created in a calendar, an associated thread is created in the linked forum.
• Links to events in the calendar are forwarded to the associated thread, or optionally a seperate New Event button can be added with a minor template edit.
• New thread links in the event forum are redirected to a new event form.
• A summary can be shown at the top of the event forum which shows the up and coming events over the next 'x' days.
• The date and time shown in the thread and post title, is calculated on the current viewing users timezone. In other words, times always show in the users timezone, not forced to GMT.
• Full moderation support.
• Editing a thread or event, will update its associated event/thread.

Screenshots

Some screenshots of this plugin

• Admin Options
• Event Thread
• Event Thread with Reply
• Thread List

How do I install it?

For upgrading, please see the section below.

Summary

• 1 xml import.
• 1 (optional) template change.
• 1 (optional) gif file upload.

Step 1

Install the product
Download the product XML file.

Goto your Admin CP at your forums, then goto Plugin System -> Manage Products. Click [Add/Import Product] at the bottom of the page. Browse to the location where you downloaded the xml file and then click the Import button.

Step 2

Calendar ID:
Goto your Admin CP at your forums, then goto Calendar Manager. Find the calendar you want to link to a forum, then click Edit.
Right at the top of the page you should see:

Calendar: NAME (id: ID)

Make a note of the ID, you will need this soon.

Forum ID:
Goto your Admin CP at your forums, then goto Forum Manager. Find the forum you want to activate as your event forum, then click Edit Forum.
Right at the top of the page you should see:

Forum: NAME (id: ID)

Make a note of the ID, you will need this soon.

Link a Calendar to a Forum:
Goto your Admin CP at your forums, then goto vBulletin Options and find Event Forums.
The first option you should see is Calendar/Forum Map.
Enter in your IDs into the box, as CALENDARID:FORUMID.
Example, my Calendar is 5 and my Forum is 14:

5:14

Click Save.

Step 3

Base permissions check:
You will need to check that users using the Event Forums, have basic permissions to both the Linked Forum AND Calendar.
Basic Permissions include: Can View Forum and Can Post Threads and possibly some others.

Step 4 (Optional template edit)

Add the New Event button:
You only need todo this if you want to show a seperate New Event button next to the New Thread button.

First of all, upload newevent.gif to your images/buttons folder. NOTE you will need to upload this to any custom image folders too for different styles you might have.

Second, open up FORUMDISPLAY template for each of your styles you want to show the button, find and add the highlighted code below:

<td class="smallfont"><if condition="$show['newthreadlink']">
<a href="newthread.php?$session[sessionurl]do=newthread&amp;f=$foruminfo[forumid]" rel="nofollow"><img src="$stylevar[imgdir_button]/newthread.gif" alt="$vbphrase[post_new_thread]" border="0" /></a>
<if condition="$show['neweventlink']">&nbsp;<a href="newthread.php?$session[sessionurl]do=newevent&amp;f=$foruminfo[forumid]" rel="nofollow"><img src="$stylevar[imgdir_button]/newevent.gif" alt="$vbphrase[lv_vb_eventforums_phrase_post_new_event]" border="0" /></a></if>
<else />&nbsp;</if></td>

Lastly, go into the Event Forums options, and change the option Show the New Event button on the thread list to yes.

Step 5

Install on VB.org:
Browse back to this thread, and click the INSTALL button so you can recieve updates whenever I update this plugin.

How do I upgrade it from an old version?

Step 1

Import xml
Download the product XML file.

Goto your Admin CP at your forums, then goto Plugin System -> Manage Products. Click [Add/Import Product] at the bottom of the page. Browse to the location where you downloaded the xml file. Make sure the overwrite option is set to ON and then click the Import button.

Can I give you money to make this?

This isn't a commercial plugin, and can be used by anyone for free. However, a few people have said to me that they would like to donate some money for my time working on the plugin and for picking it up and continuing the development of new features etc. If you do want to donate some money my way, then you can do so through paypal by clicking this link. Thanks!

Bugs / Support

If you find a bug, then please post in this thread and let me know. There are a few bugs that haven't been fixed since the old version, so i'm hoping that we can fix these soon. I will do my best to support the plugin as much as possible, however I also have a busy job which takes up alot of my time.

Known Bugs

Here is a list of known bugs to date

• Soft delete actually hard deletes the thread.
• Search doesn't search the first post of an event thread.
• Inline ajax edit bugs thread title. Need to remove date and time from it before edit.

Feature request list

Here is a list of the requested features. Please note that because it makes this list, doesn't mean it will be added.

• Intergration with the event attendance plugin.
• Customisation of the order of the custom fields in the thread title.
• An option to "import" all the previous events from a Calendar into threads.
• Extra post options support (Attachments, Post Icons, Sticky etc).
• Custom ordering of the %datetime variable.
• Custom ordering of %custom variable.
• Better handling of recurring events.

Credits

Thanks to endquote for originally creating the plugin.
Thanks to the Ninja :ninja: for helping me infiltrate the vb code and finding those hidden hooks!
Thanks to anybody that helps test this plugin.

Changelog

Version: 3.3

• Added Farcasters Event Attendance patch to the mod. I've added a self check so it will only run when the Event attendance mod is installed and active.

Version: 3.2

• Fixed a bug which was prevent the thread from being deleted when you try to delete an event.

Version: 3.1

• Fixed a bug which would cause an error with undefined function on the forum display page when summary is turned on.

Version: 3.0

• Version now compatible with 3.6. Please note this plugin will no longer install on a board older than 3.6. I would recommend you upgrade your board as soon as you can!
• Added an optional template edit to show a New Event button next to the New Thread button.
• Plugin no longer in BETA. I feel this has been running enough stablely to take this out of BETA. There are still some bugs which need fixing, but as a whole it works and is used by quite a few people.

Version: 2.7 and below

• See the old thread here

[Taragon]

Originally Posted by Gordita

So has the developer (Evercraft) officially abandoned this?

Yes, however: http://vbenhancer.com/evercraft-even...-mitchel/2500/

[BBR-APBT]

When you have sub forums it doesn't post to the correct forum. Any ideas how to fix this?
It only reads the top calendar id and forum id in the list. So it post all events in the very first forum in the list in the settings.

So I have:
1:9
1:34
1:35
1:36
1:37
1:38
1:39

It post the to the correct calendar. I guess thats cause its only one calendar I am using. But it makes all threads in forum id 9.


I know its in this code.

PHP Code:

// find the forum to add a thread to
$lv_vb_eventforums_map = preg_split('/[\n:]/', trim($this->registry->options['lv_vb_eventforums_map']));
for($lv_vb_eventforums_i = 0; $lv_vb_eventforums_i<count($lv_vb_eventforums_map); $lv_vb_eventforums_i+=2)
{
    if($this->fetch_field('calendarid') == intval($lv_vb_eventforums_map[$lv_vb_eventforums_i]))
    {
        $lv_vb_eventforums_forumid = $lv_vb_eventforums_map[$lv_vb_eventforums_i+1];
        break;
    }
}

if(isset($lv_vb_eventforums_forumid))
{
  if(isset($this->info['lv_vb_eventforums_linkeventtothread']) && ($this->info['lv_vb_eventforums_linkeventtothread'] > 0))
  {
    // add eventid to the thread
        $this->dbobject->query_write("
            UPDATE " . TABLE_PREFIX . "thread
            SET lv_vb_eventforums_eventid = " . intval($this->fetch_field('eventid')) . "
            WHERE threadid = " . intval($this->info['lv_vb_eventforums_linkeventtothread']) . "
        ");
        
        // add threadid to this event
        $this->set('lv_vb_eventforums_threadid', $this->info['lv_vb_eventforums_linkeventtothread']);
        $this->dbobject->query_write("
            UPDATE " . TABLE_PREFIX . "event
            SET lv_vb_eventforums_threadid = " . intval($this->info['lv_vb_eventforums_linkeventtothread']) . "
            WHERE eventid = " . intval($this->fetch_field('eventid')) . "
        ");
  }
} 


[VR-Fist]

Well, anyone solved the blank-page problem in 3.8.1?

[BBR-APBT]

Originally Posted by VR-Fist

Well, anyone solved the blank-page problem in 3.8.1?

its working on my 3.8.1 just fine.

[powerful_rogue]

Originally Posted by Taragon

Yes, however: http://vbenhancer.com/evercraft-even...-mitchel/2500/

Announcement was made back in Oct 2008 with no further news.

[seax19]

Tried to run this on 373 and find everythings working except theres no reply buttons in the threads first post in event forum, so it works for posting new calendar linked event threads from the forum section, but then no one has any way to reply to them. Anyone seen this issue before?

I also contacted the site linked above to ask who now supports this mod and was told:

i actually did not have time to have a look at this addon because the original author continued his development, so i had no need to look at it... sorry.

So hes out - looks like someone needs to go back to the original author and adopt this again...? Or if someone now 'owns' it, who?

[BBR-APBT]

Originally Posted by BBR-APBT

When you have sub forums it doesn't post to the correct forum. Any ideas how to fix this?
It only reads the top calendar id and forum id in the list. So it post all events in the very first forum in the list in the settings.

So I have:
1:9
1:34
1:35
1:36
1:37
1:38
1:39

It post the to the correct calendar. I guess thats cause its only one calendar I am using. But it makes all threads in forum id 9.


I know its in this code.

PHP Code:

// find the forum to add a thread to
$lv_vb_eventforums_map = preg_split('/[\n:]/', trim($this->registry->options['lv_vb_eventforums_map']));
for($lv_vb_eventforums_i = 0; $lv_vb_eventforums_i<count($lv_vb_eventforums_map); $lv_vb_eventforums_i+=2)
{
    if($this->fetch_field('calendarid') == intval($lv_vb_eventforums_map[$lv_vb_eventforums_i]))
    {
        $lv_vb_eventforums_forumid = $lv_vb_eventforums_map[$lv_vb_eventforums_i+1];
        break;
    }
}

if(isset($lv_vb_eventforums_forumid))
{
  if(isset($this->info['lv_vb_eventforums_linkeventtothread']) && ($this->info['lv_vb_eventforums_linkeventtothread'] > 0))
  {
    // add eventid to the thread
        $this->dbobject->query_write("
            UPDATE " . TABLE_PREFIX . "thread
            SET lv_vb_eventforums_eventid = " . intval($this->fetch_field('eventid')) . "
            WHERE threadid = " . intval($this->info['lv_vb_eventforums_linkeventtothread']) . "
        ");
        
        // add threadid to this event
        $this->set('lv_vb_eventforums_threadid', $this->info['lv_vb_eventforums_linkeventtothread']);
        $this->dbobject->query_write("
            UPDATE " . TABLE_PREFIX . "event
            SET lv_vb_eventforums_threadid = " . intval($this->info['lv_vb_eventforums_linkeventtothread']) . "
            WHERE eventid = " . intval($this->fetch_field('eventid')) . "
        ");
  }
} 


No one found a fix for this?

[benstillman]

FYI for you 3.8 users.... if you turn on error logging and display errors in php, you'll get this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /path/to/forums.php(67) : eval()'d code on line 194

Disable this plugin, and the error goes away.

[djsd]

I also want to post all events to google calendar and keep them in sync when editing (no editing will be done inside google), so that people get more options in how to subscribe to events and more importantly into how to get the event information into their desktop/mobile calendar clients or into blogs like wordpress.

I am quite new to vbulletin but very experienced in PHP/SQL development in general. I am worried that whatever I need to add could screw up this mod. Would this be a feature worth while adding to this mod itself and would such code contributions be accepted?

[RichieBoy67]

It would be great if someone could get these working with 3.8...these types of mods are few and needed..