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:

[TheMilkCarton]

I have 1.2.1 installed, and I have just noticed n's are still being truncated.

At what part in the code did you implement this code fix? I'd like to look in the plugins and make sure it's there correctly.

[chris1979]

Anyone going to respond to Elenna?

[y2krazy]

Is this compatible with 3.6.8?

[Farcaster]

Originally Posted by y2krazy

Is this compatible with 3.6.8?

Yes.

[Elenna]

Originally Posted by chris1979

Anyone going to respond to Elenna?

I keep checking, but I'm not holding my breath

[SVTCobraLTD]

Found my answer. Will be installing this shortly.

SVT

[USAMustangs.com]

Installed and it seems to be working fine for all newly created calendar events.

However, how can you get to add the RSVP to calendar events created prior to installing this feature?

Thanks.

[Elenna]

Originally Posted by USAMustangs.com

Installed and it seems to be working fine for all newly created calendar events.

However, how can you get to add the RSVP to calendar events created prior to installing this feature?

Thanks.

I haven't tested it, but you should be able to Edit the Event (where you would change description, etc) and check the Allow RSVP box.

[Elenna]

I believe I've figured out how to get custom userfields to display.

NOTE: This involved modifying the plugins used. This will pull the most current information in the database, as opposed to pulling that information at the time that the person RSVPd.

Step 1: In AdminCP, go to User Profile Fields and make note of the field names (i.e. field14) that you want to use.

Step 2: Go to Product Manager> Plugin Manager Scroll down until you see "Add RSVPs to Event Description"

FIND

// SELECT SQL for RSVPs for this event

IN LINE

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

ADD

, userfield.field14, userfield.field10

(add or remove ,userfield.field for each profile field you need to pull)

FIND

            LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON customavatar.userid = u.userid

ADD AFTER

  LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON userfield.userid = u.userid

Now you can modify your template (Style> Your Style> Edit Templates> Calendar> calendar_rsvp_bit)
You can use $rsvp[fieldXX] wherever you'd like that field to display, replacing XX with the field number, like you added to the select statement above.

Now, every time the event is viewed, it will pull the most current information from those profile fields and display them.



If you'd like to change the option to sort by one of the profile fields (for raids, etc) you can edit the following section:

In same Plugin above, FIND

    // Display RSVPs
    // Setup Sort Order
    switch($vbulletin->options['rah_rsvp_sort']) {
        case 0: $orderby = "u.username"; break;
        case 1: $orderby = "ea.rsvp_date";break;
    };

REPLACE with:

$orderby = "userfield.field14";

Be sure to REMOVE the ending };

Where field14 is the field that you wish to sort by.

[DJFriar]

Is there a way to disable the ability to select "No"??? I want people to just be able to say they are attending or they might be able to attend. We don't care who can't attend.