Calendar Enhancements - Farcaster's Event Attendance

A BETA version 2.0 is now available in the 3.7 modification area.

This hack will allow your users to RSVP "Yes," "No," or "Maybe," for events posted on your forum calendar. You can configure which calendars RSVP should be enabled or excluded from, and on each event you can also specify whether this is an RSVP event. Unlike the old Event Attendance script, this hack will work on all types of events whether they are single day, ranged or recurring.

For ranged and recurring events, members are able to RSVP for a single day of the event. So, if the recurring event occurs every Monday, your members can RSVP separately for each recurrence. For ranged events that span more than one day, members can sign up for individual days of the event. Thus, if the event had a duration of 5 days, a member could signup for only one or two of the days, if he chose.

This hack is known to work with 3.6.x, and may work with 3.5.x, but no support is offered for this version at this time.

vB Event Forums Users:
You will need to install an additional module: https://vborg.vbsupport.ru/showthread.php?t=133970


Upgrade Instructions:
- 1 xml upload

1. Use the Product Manager to import the product file product-rah_calendar_rsvp_1_2_2.xml. Be sure to ALLOW OVERWRITE.

Installation Instructions
- 1 XML upload
- 1 template modification

1. Use the Product Manager to import the product file product-rah_calendar_rsvp_1_2_2.xml
2. Use the Style Manager to find and edit your calendar_showeventsbit:

Near the bottom of the calendar_showeventsbit, find:

     </form>

Below that add:

     $rsvp_form

That?s it. You should now configure any changes to the default options you like. If you previously used Event Attendance 2.0 by Arpy, you should disable it or uninstall it.

If you want to change any of the wording or need to enter translations, this hack uses the following phrases:

Calendar Phrases:
calendar_rsvp_allow
calendar_rsvp_attendquestion
calendar_rsvp_changelater
calendar_rsvp_maxlength
calendar_rsvp_maychange
calendar_rsvp_yoursvp
calendar_rsvpd
-- Added on 11/30/06:
calendar_rsvp_guest
calendar_rsvp_guest_limit
calendar_rsvp_guests_prompt
calendar_rsvp_max_guests
-- Added on 2/20/07
calendar_rsvp_changeby
calendar_rsvp_maychangeby
calendar_rsvp_closed
calendar_rsvp_expires

Standard Phrases:
yes
no
maybe
submit
comment
-- added on 2/20/07
minutes
seconds

Extra Instructions for 3.5.x Users:
This hack MAY work with 3.5.x, but you will need to add the standard global phrase "Comment"

Screenshots Attached.

If you use this hack, please be sure to click "Install" so that you can receive notifications of any updates.

Revision Log:
1.0.0 - 10/14/06 - Initial Release

1.0.1 - 10/19/06 - Maintenance Release.

• Updated to handle getting a link without the "day" parameter.
• Fixed timezone bug.
• Updated calendar_rsvp_yoursvp phrase to include date.
• Updated calendar_rsvp_attendquestion phrase to include date.
• Updated calendar_rsvp_form for changed phrases.

1.1.0 - 11/30/06 - Minor Revision

• Added ability for members to register guests in their RSVP. The guest system can be completely disabled, and is also configurable by event to limit the number of guests each member can bring.
• RSVPs are now time stamped. The date and time of the RSVP can be displayed on the RSVP form if desired from a setting in the admincp.
  RSVPs can now be sorted by the date the user signed up or by member name.
• The hack is now configured to work with the "Check Version" option for products in vBulletin.

1.1.1 - 12/15/06 - Maintenance Release.

• Fixed uninstallation code. The hack can now be uninstalled without error and will correctly remove all fields and tables added by this hack.

1.1.2 - 12/21/06 - Maintenance Release.

• Corrected install code to handle fields left behind by installations prior to version 1.1.1. You only need to install this update if you were recieving database errors when attempting to install the product.

1.2.0 - 02/20/07 - Minor Revision [Detailed Notes]

• Feature: Moderators and owners can remove member RSVPs from events.
• Feature: RSVP Expiration System added.
• Bug Fix: Changing the date or recurring options of an event now removes all RSVPs.

1.2.1 - 05/09/07 - Maintenance Release

• Bug Fix: Fixed problem with event description being truncated if it ended in the letter "n"
• Bug Fix: Fixed summary when multiple events on the same day are shown so that it no longer cumulatively adds the guests and member counts to the next event.

1.2.2 - 05/03/08 - Maintenance Release

• Added Security Token to be compatible with vBulletin 3.6.10 and 3.7.0.

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:

[GrandAmGuru]

Possible suggestion for a future release:
* set it so admins can go in and edit other members RSVP or comments

Right now I can do it with another hack that lets me login as a member, but it would be nice to be able to edit the RSVP's from the event listing page.

[Caster]

I tried search the thread, but I wasn't able to find anything. I'm trying to let my members RSVP to an event from outside the calendar. I figrued I would just insert the fields into the database myself, but I'm having a little trouble figuring out what "ocdate" is exactly. I was able to find this part in the XML script and I found that that the ocdate field is inserted into the db by the $rsvpdate variable.

PHP Code:

// If the parameter wasn't passed, and this is recurring, get next event from today.
    if ($eventinfo['recurring'] AND !$rsvpdate) {
        DEVDEBUG('Fetching date from next event date');
    
        $gettime = TIMENOW  - $vbulletin->options['hourdiff']; 

        // find next occurence within one year.
        while ($iterations < 365)
        {
            $addcache = false;
            $todaydate = getdate($gettime);
            
            if (cache_event_info($eventinfo, $todaydate['mon'], $todaydate['mday'], $todaydate['year'], 1, false))
            {
                $rsvpdate = gmmktime(0, 0, 0, $todaydate['mon'], $todaydate['mday'], $todaydate['year']);
                $iterations = 999999;
                DEVDEBUG('Fetched - '.$rsvpdate);
            }

            $iterations++;
            $gettime += 86400;
        } // end while loop
    
    } 


I figured that the $gettime is the time and the hour difference, the getdate function puts the unix time into an array and is then converted using gmmktime. What I don't understand is the if statement

PHP Code:

if (cache_event_info($eventinfo, $todaydate['mon'], $todaydate['mday'], $todaydate['year'], 1, false)) 


and how you're able to find out the next event date (if that matters at all or has anything to do with the "ocdate").

Thanks for the great mod!

[Farcaster]

Caster,

ocDate means "Occurrence Date". Since events can be ranged or recurring, the ocDate field is used to determine what date the member was looking at when they RSVP'd. That uniquely ties an RSVP to a day of an event. ocDate is always set to midnight GMT of the day the event, or instance of the event, occurs. Normally, the ocDate can be determined by looking at the "day" parameter from the query string, but if the day isn't passed, the code then attempts to get the date by a couple different methods:

• If the event is recurring, it looks at the present date and then goes out up to 365 days looking for a recurrence of the event. The first future date the event recurs on will be used.
• If it is a single day event, then it uses the dateline_from, which is already set to midnight GMT.
• If the event is ranged, then it is set to midnight GMT of the first day of the event.

All of those methods are only used of a specific day is not specified in the query string.

I hope that helps.

[Caster]

The thing is the events that the members will be rsvping to are all recurring events and I didn't figure out how you found out what day the next event is going to be on.

Edit: Well since they're weekly events, could I figure it out by just multiplying 86400 by 7 (days a week) and adding that to the $gettime?

Thanks for the quick reply as well!

[Farcaster]

Originally Posted by Caster

I figured that the $gettime is the time and the hour difference, the getdate function puts the unix time into an array and is then converted using gmmktime. What I don't understand is the if statement

PHP Code:

if (cache_event_info($eventinfo, $todaydate['mon'], $todaydate['mday'], $todaydate['year'], 1, false)) 


In this statement, I am piggybacking on the existing vBulletin functionality. cache_event_info returns true if the event the event array that is passed ($eventinfo) is found to occur on the specified month, day and year that are passed from $todaydate. In order to use this function, you will need to include "functions_calendar.php" in your program.

[Caster]

Oooo okay, I'll give it a shot. Thanks for the help and the mod! =]

[Farcaster]

A new version of the RSVP hack is now available for download. I wish I had the time to get to all of your requests, but I did implement a couple of features which have been heavily requested.

NOTE: This hack may or may not work for 3.5.x. I am no longer supporting that version as I do not have a 3.5.x test board to work with. Only 3.6.x is supported.

Feature: RSVP Moderation
This new feature allows selected user groups and event owners to delete RSVPs from an event. There are two new settings in the options menu that support this feature. "Owner Moderation" allows you to configure whether or not the original event poster will be able to remove RSVPs from their own event, and the option "Moderator Groups" allows you to specify user groups that can remove RSVPs from any event. Sorry, this is not specific to the calendar.

Feature: RSVP Expiration System
By setting the option "RSVP Expiration" to yes (default), event posters can setup the RSVP form to close within a certain time frame before the event start time. The poster can specify a number of days, minutes, hours and seconds. If not otherwise specified, the RSVP will close once the event has started. For single day events, the RSVP form defaults to remain available until the end of the day (11:59pm) and the event expire time will work backwards from that time.

If you do not want events to ever expire, you can turn the entire system off in the options window.

Bug Fix: Changing the date or recurring options of an event now removes all RSVPs.
This resolves a problem where the Email Addon might send a user a false notification about an upcoming event after the event date options had been modified.

ADDED GLOBAL PHRASES
- minutes
- seconds

ADDED CALENDAR PHRASES
- calendar_rsvp_changeby
- calendar_rsvp_maychangeby
- calendar_rsvp_closed
- calendar_rsvp_expires

TEMPLATE CHANGES
- calendar_rsvp_form
- calendar_rsvp_bit

[Quantnet]

updated

[WATRD]

Okay, I am not seeing it, where do I go to moderate RSVP's?

Also, when setting the RSVP expiration, it looks like the word "hours" is missing. I see:

"Time Before Event to Close RSVP: Days Minutes Seconds"

There's a box, but no legend for it. It might be confusing to users.

[Farcaster]

Originally Posted by WATRD

Okay, I am not seeing it, where do I go to moderate RSVP's?

Also, when setting the RSVP expiration, it looks like the word "hours" is missing. I see:

"Time Before Event to Close RSVP: Days Minutes Seconds"

There's a box, but no legend for it. It might be confusing to users.

WATRD, what version of vBulletin do you run? And, you should see the option to remove RSVPs on the event display screen next to each name.