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:

[edfig]

Hmmm....

As I posted in the integration thread (integration to Evercrafts Event Forum Hack) I can't get this to work... I'm posting here now because I uninstalled everything in an attempt to trouble shoot this thing.... So here's where I am.

1) Uninstalled Evercrafts Event Forum Hack....

2) Uninstalled the Bridge Hack....

3) Uninstalled the Attendance hack....

4) Reinstalled the Attendance hack (Overwrite for safe measure)...

5) Create an event in the calendar with RSVP checked (I can see the RSVP options when I create the event)

6) Click on the event I created and note there is no RSVP option for users to interact with.

7) It should be noted that I have all forums with RSVP enabled within the ADMIN options....

I assume why it is not working here might be why it is not working when I have all of the previously uninstalled hacks applied. *shrugs*

I am using vB 3.6.8

[kai3k]

How can it be done, to display the amount of people who want to attend ("yes") to an event, on the weekly and monthly calendar view?

like done here:
http://www.future-music.net/forum/calendar.php
http://www.future-music.net/forum/ca...o=displaymonth

that would be a great feature

[IvyKeepMommy]

I'm using this with the forum events mod and when any recurring event is RSVP'd to it rsvp's to the entire sequence instead of individual events. Do I have a setting wrong someplace?

[SnoozerD]

I am having some issues with people using IE and signing up for an event. When they do it takes them back to the login. I have uninstalled and reinstalled the addon and nothing seems to work.

Any ideas?
(you can check at: eternaldestinyguild.com)

[Elenna]

Originally Posted by kai3k

How can it be done, to display the amount of people who want to attend ("yes") to an event, on the weekly and monthly calendar view?

like done here:
http://www.future-music.net/forum/calendar.php
http://www.future-music.net/forum/ca...o=displaymonth

that would be a great feature

I agree, that would be a very nice add-on. I tried adding the "total number of yeses" variable (that is used in the event description) into the Weekly template, but it didn't display. It pulled in the "Yes" phrase, but that's it.

[crkgb]

Hi. I just installed this mod to my test site. Thank you very much for hard work.

I have the following problem.

After the install and adding RSVP to an event I can no longer edit or delit an event.

I get a message displayed that I do not have enough permissions for editing. And for deleting I just get the page reloading. Once the RSVP mod gets disabled everything starts to work normal again.

Please help.

Thank You

[Elenna]

I have an issue with this interferring with custom holidays.

If a user event and a custom holiday appear on the same day, it tries to treat the holiday as a regular calendar event, and returns a SQL error.

Anyone know how to turn this off for custom holidays? Other holidays, on days that don't have a user event, are just fine.

Here are some examples:
Regular holiday with no user event: http://www.graceofthevalar.com/calen...=2007-10-3&c=1
Event and holiday on same day: http://www.graceofthevalar.com/calen...2007-10-20&c=1
(since I get all the emails about the SQL error, please only click if you are trying to help me Thank you!)

[Farcaster]

Originally Posted by Elenna

http://www.graceofthevalar.com/calen...2007-10-20&c=1
(since I get all the emails about the SQL error, please only click if you are trying to help me Thank you!)

Elenna,

I cannot see the underlying SQL error when I open the link you gave. Can you PM or post the error?

BTW, I'm a LotRO player as well, but I'm on the Brandywine server.

[Elenna]

Originally Posted by Farcaster

Elenna,

I cannot see the underlying SQL error when I open the link you gave. Can you PM or post the error?

BTW, I'm a LotRO player as well, but I'm on the Brandywine server.

Bah, you chose the wrong server! Too bad, would have been fun to adventure with a vB coding god. LOL

Here's the error message. Note that I did modify the plugin to pull some profile fields so that might account for it? Boy I'll feel dumb if I messed it up myself!

For the edits I did, scroll up a few pages (2-3), I posed the edits I did.

On the standard "Database Error" page (meaning no vB "wrap"):

Database error in vBulletin 3.6.8:
Invalid SQL:
        SELECT    u.username, ea.userid, ea.response , ea.comment, ea.guests, ea.rsvp_date, u.avatarid, , userfield.field8, userfield.field9, u.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
            customavatar.width, customavatar.height
        FROM    eventattendance ea
            INNER JOIN user u ON u.userid = ea.userid
            LEFT JOIN avatar AS avatar ON avatar.avatarid = u.avatarid
            LEFT JOIN customavatar AS customavatar ON customavatar.userid = u.userid        
  LEFT JOIN userfield AS userfield ON userfield.userid = u.userid
        WHERE    eventid = 04
            AND ocdate = '1192838400'
        ORDER BY
            ea.response , u.username;
MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' userfield.field8, userfield.field9, u.avatarrevision, avatarpath, NOT ISNULL(cu' at line 1
Error Number : 1064
Date         : Monday, October 15th 2007 @ 07:34:07 PM
Script       : http://www.graceofthevalar.com/calen...2007-10-20&c=1
Referrer     : http://www.graceofthevalar.com/calendar.php
Classname    : vb_database

[Farcaster]

Elenna, the error in the SQL is right here:

[SQL]u.avatarid, , userfield.field8[/SQL]

There is no column specified between u.avatarid and userfield.field8. I think this has something to do with your custom modification, because I cannot reproduce this problem using the unmodified version on my forums.

Originally Posted by Elenna

Bah, you chose the wrong server! Too bad, would have been fun to adventure with a vB coding god. LOL

Far from a god. I am but a pattawan learner, as it were