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:

[Farcaster]

Originally Posted by Toewalker

1) solution for the problem descriped earlier in my post #209:

add unique key over eventid AND userid in table eventattendance, for EXAMPLE (use at your own risk! maybe the prefix "vb3_" has to be adjusted):

ALTER TABLE `vb3_eventattendance` ADD PRIMARY KEY ( `eventid` , `userid` );

this way, the "REPLACE" SQL statement should work as expected (hardly tested!!).

That would not be a correct primary key. The installation script already created a unique index. Perhaps it should have been a composite key, but unique key should work. In anycase, the unique key or composite primary key needs to be on eventid, ocdate, and userid. Otherwise, when you have a ranged or recurring event, the REPLACE INTO will overwrite any other RSVPs for that user on other days of the event.

The installation script makes this statement:

PHP Code:

        CREATE UNIQUE INDEX uq_eventattendance__eventuser ON ".TABLE_PREFIX."eventattendance (eventid,ocdate,userid); 


That should do it. Did your installation not have a unique key called uq_eventattendance__eventuser, as the one above?

[Toewalker]

No it didn't have that unique key. I checked your installation scripts with the product manager and I found the create-statement there. So that's really strange.
However, it works now, so everything's fine :-)
I'm using Mysql 4.0 and vBulletin 3.6.1, maybe that was the problem?!?

Thanks,
Toewalker

[ravencr]

Does anyone know if I could incorporate this hack with the form hack here:

https://vborg.vbsupport.ru/showthread.php?t=126676

Instead of people being able to post whatever they wanted in the new event, I'd like to use a form instead so every event is uniform and allows people to search for certain characteristics within an event.

Chris

[Farcaster]

Ravencr,

No, the form hack will not create a new event, so it will not work with this hack. Have you considered using calendar fields? That would allow you to setup certain standard fields for the event poster to fill in.

[ravencr]

Where do I find out more about Calendar Fields? Thanks so much for the help,

Chris

[adwade]

In AdminCP panel for this MOD the RSVP Expiration options reads:

"Do you want to prevent members from signing up for an event on or before the event date (specified at the time the event is created)?"

If this is toggled to NO, is there anyway to implement it after the event is posted, w/o having to re-create new events after toggling it to YES?

[TheBlackPoet]

why cant i uninstall this hack?? i can disable it, but i want to uninstall it... it gives me an error every time

[TheBlackPoet]

no worries... got it...

[ravencr]

Where do I find out more about Calendar Fields? Thanks so much for the help,

Chris

[ricker]

When showing multiple events on the same day at the same time I'm getting count errors.
Compare 9AM Run vs. the 9AM run here. It's not a huge deal but I thought I'd point it out. We love this mod, and thank you for all of your hard work.

ravencr: AdminCP > Calendars > Edit a Calendar