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:

[Cocko]

thanks to Farcaster for great support!
issue with wrong date is fixed.

[smoknz28]

Originally Posted by Cocko

thanks to Farcaster for great support!
issue with wrong date is fixed.

What was the fix?

Thanks

[Farcaster]

There was a common variable that may have been conflicting with another modification. I'm not sure what the conflicting mod was, but it should be fixed now with the latest version of the Integration Add-On.

[smoknz28]

Originally Posted by Farcaster

There was a common variable that may have been conflicting with another modification. I'm not sure what the conflicting mod was, but it should be fixed now with the latest version of the Integration Add-On.

Thanks for the PM as well Farcaster. I ran the updated script and added a new event to the calendar. Looks like you did manage to fix the issue. Thanks for your hard work on this one for us. :banana:

By the way, Farcaster and the rest...if you guys don't mind, please go to my other post in helping me better manage the calendar associated hacks and my events forums.

https://vborg.vbsupport.ru/showthrea...123416&page=14

Thanks....

[Farcaster]

Originally Posted by Mithan

Farcaster, did you get a chance to look at the uninstall part of the script?

It isn't uninstalling properly.

Version 1.1.1 should resolve the uninstall problem. Just remember that if you do uninstall, all RSVPs will be lost.

[Cocko]

Originally Posted by Farcaster

The hack uses the pre-existing standard phrase, "Yes". You'll need to find that phrase in the phrase manager and provide a german translation.

i was nicely surprised about your support /w the new integration version.

so this little issue still exists. as i asked for default set radio button the
phrases were added yet. after this that issue was present.

changing to language with pre-existing phrase (yes,no,maybe) the default
set is done. changing to german phrase (which are added yet) no default
set is done. submitting comments / RSVP will change to system message
that will discourage users than attending.

[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.

[JohnK]

Hi

I've just installed it and it looks great, but I have a couple of issues/requests.

It looks like you are using the global phrase "x_members_and_y_guests" on the calendar page, which gives a screwy result if you've edited that phrase (see attachment!)

I'd like to be able to have unlimited guests, and remove the various references to a limit. Is that something that could be done without too much trouble?

Finally, one for the wish list: it would be great if I could include some of the user's profile fields (memberinfo_customfields) in the list of attendees. Any chance of adding that sometime?

Thanks!

[Canis Firebrand]

Is there any reason that when I upgraded to the current version my forumhome stopped displaying upcoming events? The block is completely gone from the What's Going on section.

I had also been using the Event on Forumhome mod.

Before upgrading, the events box was at the bottom, and I had another events box at the top of my forumhome.

After upgrading, both disappeared. I uninstalled this plugin to test, and they still do not show up.

I'm not sure what would have caused this.

forum.8bitbrigade.com

It is like it is ignoring the options I have in the calendar section telling it to display birthdays and events.

For a test, I removed the <if condition="$show['upcomingevents']"> line and the </if> from the forumhome template and it showed the events.
All of the calendar permissions are all set to yes.

The only change yesterday was uploading this new mod. I hadn't changed anything else at my site.

Why would it ignore that setting now that I have upgraded this mod?

**EDIT** Okay. I had my calendar set to show 2 days of upcoming events. There are no events until Monday. When i set it to show days, the events box showed up again. I can't recall if on previous weekends it disappeared. I don't think it would, it should still be there and just not have any events, I would imagine. I really want only 2 days of events shown at most.

Is that standard VB behavior when there are no events to not show the events box? I thought it was always there and if there were no events, it would say No Upcoming Events, or something like that.

[JoeWho]

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.

Does anybody know where I can get some help on removing the duplicate column name?

Thank you.