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:

[Canis Firebrand]

Originally Posted by Farcaster

That is standard behavior for vBulletin.

Ah, okay then. Disregard. I could have sworn though that when there were no events, it still displayed the box.

Then again, I could be crazy from all the holiday stress.

In any case, thanks again for a reply and for the great product. My users love the ability to RSVP for events and such that people post to the calendar.

[Farcaster]

Originally Posted by JoeWho

Help!!!!

I un-installed it and when I reinstalled it again (Overwrite) I get an error. How do I get past the error OR how do I remove the (Duplicate column name 'rsvp') so I can reinstall it?


Database error in vBulletin 3.6.4:
Invalid SQL:
ALTER TABLE event ADD rsvp BOOL NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'rsvp'
Error Number : 1060
Date : Friday, December 15th 2006 @ 12:16:01 PM
Script : http://www.domain.net/forums/admincp...=productimport
Referrer : http://www.domain.net/forums/admincp...?do=productadd
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : Database

Thanks.

I have corrected the install code to handle existing columns left behind from previous installations. This error should no longer occur. But, please, do remember, that if you uninstall the product, all existing rsvps will be deleted.

This release only needs to be run by people who were receiving database errors when installing the product.

[elricstorm]

Edit:

Nevermind I have the calendar working and up and running now. I figured it all out on my own.

[elricstorm]

Using the examples here, I heavily modified and created new code to create a World of Warcraft raid calendar, changing the DB values to using postbit fields instead. I added two tables and color coded the classes and added additional ordering pairs.

Here's an example screenshot and I just want to say thanks to Farcaster for the initial ideas he provided as it just suddenly turned a lightbulb on in my head and I had to work on a gaming calendar for vbulletin.

[Farcaster]

Very cool, Ericstorm!

[elricstorm]

Thanks mate!

[MythoLogy]

Thanks Farcaster! Been needing for a long time now! Awesome job getting this to work for more than a single day.

[TitanPK]

installed and this is PERFECT for my needs.
Is there anyway way to set it up so that Mods, Admins or another user group can either Deny the RSVP or Change the RSVP from the regular users?

Also, is there a way to set up a max number of people that can respond "yes" for a specific event and then anyone responding after that go to a wait list?

[Farcaster]

Originally Posted by TitanPK

installed and this is PERFECT for my needs.
Is there anyway way to set it up so that Mods, Admins or another user group can either Deny the RSVP or Change the RSVP from the regular users?

Hmm.. That probably wouldn't be too hard to implement. I'll see what I can do.

Also, is there a way to set up a max number of people that can respond "yes" for a specific event and then anyone responding after that go to a wait list?

A few others have also requested the same modification. I'll be working on that soon.

Enjoy.

[TitanPK]

Originally Posted by Farcaster

Hmm.. That probably wouldn't be too hard to implement. I'll see what I can do.



A few others have also requested the same modification. I'll be working on that soon.

Enjoy.

Fantastic. What about if someone would like to be moved from YES to Maybe? Or Vice Versa automatically with a notification going out?

would it be possible to have a PM or EMAIL sent to the 1st person on the waitlist to confirm for the available spot?

Here is my application so you understand. I host a forum for home poker games and this hack is perfect. However, some people are not allowed in people's homes and sometimes things come up at the last min where people have to drop out, and then someone from the waitlist can get in the game.
We used to do all this manually before but this hack is SO close to nailing exactly what we need. (shoot I'll throw you a few bucks to do this)

T