Event Forums

Note: This plugin has been discontinued and taken over here. Installing this plugin is *not* recommended.

The plugin creates a tight integration between a calendar and a forum.

• When an event is created in a calendar, a corresponding thread is created in its forum.
• When an event is deleted, its thread is deleted.
• When a thread is deleted, its event is deleted.
• When an event is edited, its thread is edited.
• When a thread is edited via quick edit, its event is edited.
• Links to event details are redirected to the thread.
• New post links in event forums are redirected to new event forms, except for moderators.
• Advanced editing on a thread is redirected to event edit.

To set up your calendar/forum pairs, look under "Event Forums" in "vBulletin Options" in admincp.

There is also one template change. In calendar_showeventsbit, change:

PHP Code:

<td class="tcat">$eventinfo[title]</td> 


to:

PHP Code:

<td class="tcat"><if condition="$eventinfo[nwt_threadid]"><a href="showthread.php?t=$eventinfo[nwt_threadid]"></if>$eventinfo[title]<if condition="$eventinfo[nwt_threadid]"></a></if></td> 


I run a forum at http://nwtekno.org/ that is heavily oriented to calendar data, so this is useful to me, though I'm not sure how useful it will be to others. Mostly I'm putting this up for critique by people who know more than me.

One thing I'm wondering is how to get the included template (nwteventforums_calendar_showeventsbit) to replace calendar_showeventsbit when installed. Or should I just tell people to copy/paste from one to another?

[FD929]

Originally Posted by endquote

You could change the call to date() in eventdata_postsave. I suppose I should make that a config option.

Yeah I was confused when I saw something posted. What exactly would I have to do to get it month-day-year?

Originally Posted by endquote

It should do that automatically, but not if you're a moderator of that forum, or an administrator.

Aw that sucks ... why not?

[endquote]

Originally Posted by FD929

Yeah I was confused when I saw something posted. What exactly would I have to do to get it month-day-year?

Just change "y-m-d" to "m-d-y".

Originally Posted by FD929

Aw that sucks ... why not?

The thinking was that admins/mods might want to post announcements and things, but no one else should be able to post anything but events. You could change newthread_start to make it happen for everyone if you wanted.

[FD929]

Originally Posted by endquote

The thinking was that admins/mods might want to post announcements and things, but no one else should be able to post anything but events. You could change newthread_start to make it happen for everyone if you wanted.

Ah I see. Well thanks again for this, I've wondered why vBulletin hasn't better implemented the calendar system for some time now.

[Neal-UK]

Originally Posted by FD929

Ah I see. Well thanks again for this, I've wondered why vBulletin hasn't better implemented the calendar system for some time now.

any way i can remove this from my forum totally? I try to unistall via plugin manager and get db errors

[FD929]

Overwriting the product with the updated xml should take care of any problems you are having Neal. Then once overwritten, you should be able to uninstall if you choose to.

[Neal-UK]

Originally Posted by FD929

Overwriting the product with the updated xml should take care of any problems you are having Neal. Then once overwritten, you should be able to uninstall if you choose to.

ok, i tried last time but got db errors. I'll try again.

[FD929]

1 more problem. All posted events by normal members are being moderated however all permissions are set to allow posting.

[Neal-UK]

Originally Posted by FD929

1 more problem. All posted events by normal members are being moderated however all permissions are set to allow posting.

Still get the error when posting an event in the calendar even thought the event get's posted in the correct forum. Same errors if I trry to delete the post:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

UPDATE FORUMthread
SET nwt_eventid = 4
WHERE threadid = 1672;

MySQL Error : Unknown column 'nwt_eventid' in 'field list'
Error Number : 1054
Date : Monday, August 8th 2005 @ 07:50:53 PM
Script : http://www.burnleyweb.com/forum/calendar.php
Referrer : http://www.burnleyweb.com/forum/cale...ype=single&c=1
IP Address : ***.***.***.***
Username : ****************
Classname : vb_database

[FD929]

I think maybe the sql queries still aren't running properly. I ran mine manually so that may be why we're having different issues. Are you using a table prefix and do you have access to run sql queries from the admincp or phpmyadmin?

[Neal-UK]

Originally Posted by FD929

I think maybe the sql queries still aren't running properly. I ran mine manually so that may be why we're having different issues. Are you using a table prefix and do you have access to run sql queries from the admincp or phpmyadmin?

Yeah I have the prefix FORUMtable_name, but im pretty new (a year or 2) to database stuff so what do I need to type exactly in the run sql queries box?