Add-On Releases - Farcaster's Event Attendance & vb Event Forums Integration

This is an add-on to the vB Event Forums hack by Evercraft that will allow it to work with Farcaster's Event Attendance. This hack disables two of the Event Forum plugins and adds two integrated versions of the plugins in their place.

Prerequisites:

• Farcaster's Event Attendance 1.2.0
• vB Event Forums 3.3

Installation Instructions:
- 1 XML upload

1. Use the Product Manager to import the product file product-rah_rsvp_forums_addon_1_1_1.xml

Upgrade Instructions:
1. Use the Product Manager to import the product file product-rah_rsvp_forums_addon_1_1_1.xml and allow overwrites.

Uninstallation Instructions:

1. Uninstall the Product.
2. If Event Forums are installed, re-enable the following two plugins:

• Display Event Details on Thread Page
• redirect links to individual events to their threads instead

Revision Log:
1.0.0 - Initial Release
1.0.1 - A bug that occured on some boards which caused incorrect dates to display on the RSVP form has been resolved.
1.1.0 - 02/20/07 - Minor Revision - Modified the add-on for version 1.2.0 of the Event Attendance modification.
1.1.1 - 07/13/07 - Bug Fix - Corrected fetch_phrase query problem that was causing excessive amounts of queries to be added to the showthread display.

This hack is provided completely free of charge. However, if you use this hack and are so moved, you may make a donation via PayPal:

[Farcaster]

Mithan,
I plan on uploading a fix for the "Farcaster's Event Attendance" mod tonight that will fix the uninstallation problem. This add-on hack though should uninstall without problems and does not make any database changes.

StuntFactoryX,
Yes, the problem was that my RSVP hack would not work with Evercraft's Event Forums hack. This add-on module integrates the two hacks so that they will work in conjunction.

[Farcaster]

Just a note for anyone who may be wondering how this works with ranged events:

Even though the Event Forums hack by Evercraft only creates a single thread for a recurring event, the RSVP system will still work with recurring events. Whenever someone opens the event they will always see the current or next upcoming event date. That does mean, however, that the next day, RSVPs will be cleared out for the next event date.

[jgommel]

Okay, It's not creating the table(s) in the database... I went into the DB to create the table myself, but I realized that I'd also have to create the fields. Can anyone elaborate on what's happening and why this won't install? I've installed many other mods that access my DB without a problem.

Database error in vBulletin 3.6.4:

Invalid SQL:

              SELECT    u.username, ea.userid, ea.response, ea.comment, ea.guests, ea.rsvp_date, u.avatarid, u.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
                  customavatar.width, customavatar.height
              FROM    vb_eventattendance ea
                  INNER JOIN vb_user u ON u.userid = ea.userid
                  LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = u.avatarid
                  LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = u.userid        
              WHERE    eventid = 033
                  AND ocdate = '1167609600'
              ORDER BY
                  ea.response, u.username;

MySQL Error  : Unknown column 'ea.userid' in 'field list'
Error Number : 1054
Date         : Thursday, December 14th 2006 @ 06:49:55 PM
Script       : http://www.domainname.com/vb/showthread.php?t=896
Referrer     : http://www.domainname.com/vb/calendar.php?do=manage&e=33
IP Address   : 
Username     : RodentX
Classname    : vb_database

[jgommel]

Nevermind, I fixed it. I just installed everything on my other website and copied the DB entries into my primary websites DB -- viola, back in business!

[HellRazor]

Farcaster - you rock.

[|oR|Greg]

I founds me a problem. I have 2 forums specified. If I create an event in the 2nd forum, the thread is created in the 1st forum instead.

[Farcaster]

Originally Posted by |oR|Greg

I founds me a problem. I have 2 forums specified. If I create an event in the 2nd forum, the thread is created in the 1st forum instead.

Does that only if the integration hack is installed? I didn't make any changes that should have effected thread and event creation. That may be a bug of vB Event Forums.

To find out, try disabling the integration hack and re-enabling the two disabled plugins under the Event Forums hack.

[|oR|Greg]

You're not the boss of me.

[|oR|Greg]

You're right, and I posted on the other dudes hack for help anyway, covering my bases. Oh Farcaster, is there anything you CAN'T do?

[AWJunkies]

I will test this out tomorrow and let you know how it goes. THANKS SO MUCH FOR PUTTING IN THE TIME TO MAKE THIS MOD!