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:

[Caster]

Farcaster, a small question, I'm working on the script to add users from outside vBulletin, and I was just wondering in the

PHP Code:

if (cache_event_info($eventinfo, $todaydate['mon'], $todaydate['mday'], $todaydate['year'], 1, false)) 


What would $eventinfo be exactly? I checked in the functions_calendar.php and it just says,

PHP Code:

function cache_event_info(&$event, $month, $day, $year, $adjust = 1, $cache = true) 


is it just the eventid?

[Farcaster]

Originally Posted by Caster

Farcaster, a small question, I'm working on the script to add users from outside vBulletin, and I was just wondering in the

PHP Code:

if (cache_event_info($eventinfo, $todaydate['mon'], $todaydate['mday'], $todaydate['year'], 1, false)) 


What would $eventinfo be exactly? I checked in the functions_calendar.php and it just says,

PHP Code:

function cache_event_info(&$event, $month, $day, $year, $adjust = 1, $cache = true) 


is it just the eventid?

$eventinfo is an array of event variables. The array is populated from the fields in the event table and some additional computed fields are added during the processing of the event in calendar.php. If you look in the calendar.php file, you should find a place where $eventinfo is being populated with a database call. You can use that as a reference for creating your own call to create the $eventinfo array.

[Caster]

Thanks I'll check it out right now

[TitanPK]

Thanks for the upgrade, I was wondering if it could be tweaked so that the moderator groups or event creator could change the status of the RSVP as well as remove it.

for example, i sign up as maybe. can it be made so that the event creator changes my status to YES or NO?

also, can it be made so that when an RSVP is made or changed that the thread shows as new?

[Ted S]

I have encountered a bug with viewing events and character trimming. Basically on the vent display page the end character is often chopped off although this does not happen with all characters. Sentences ending an "n", "b" or "s" (and other letters) get chopped while sentences ending with "." or "k" do not. Editing the event shows the original text so it is clearly not getting lost in the database, just in the display.

[dknelson]

Do any of these event attendance hacks allow for the fact that maybe more than one person is coming from the same family? For example, my site is dedicated to motorcycle touring. We have a lot of members who sign up but their wife or somebody else is riding with them. Is there any way to add an option that people can sign up and indicate 2 people or whatever?

[stwilson]

Originally Posted by dknelson

Do any of these event attendance hacks allow for the fact that maybe more than one person is coming from the same family? For example, my site is dedicated to motorcycle touring. We have a lot of members who sign up but their wife or somebody else is riding with them. Is there any way to add an option that people can sign up and indicate 2 people or whatever?

Yes, this MOD does just that. The poster of an event can limit the amount of guests a member can bring but it does allow for guests on event signup.

[dknelson]

Thank you very much. Downloading and clicking installed.

[Toewalker]

Hi,

I think I've encountered a bug: after signing up for an event, changing my RSVP status results in a double-signup (the old status-entry is still there and additionally the new status-entry). Is this intended?
I'm using vbulletin 3.6.1 and your version 1.2.0... No problems during install and I followed the install instructions for 3.6.x...

Thanks,
Toewalker

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

2) localization issue; for example German vbulletin, if you choose "yes" which's translation would be "Ja", then it will not reselect your choice after you rsvp'd (because it compares $myrsvp which has the translated value to the hardcoded "yes" value).
Fixed template "calendar_rsvp_form":

<form action="calendar.php?do=getinfo&e=$eventinfo[eventid]&day=$rsvp_day" method="post">
<input type="hidden" name="do" value="getinfo" />
<input type="hidden" name="cdo" value="rsvp" />
<input type="hidden" name="day" value="$rsvp_day" />
<input type="hidden" name="e" value="$eventinfo[eventid]" />
<input type="hidden" name="s" value="" />


<if condition="$bbuserinfo['userid'] AND $expires[0]>=0">
	<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
	<tr><td class="alt2">
		
		<if condition="$expires[unixdate]">	

			<if condition="$myrsvp">
				<b><phrase 1="$rsvp_day_formatted" 2="$myrsvp">$vbphrase[calendar_rsvp_yoursvp]</phrase></b><br />
				<font class="smallfont"><i><phrase 1="$expires[date]">$vbphrase[calendar_rsvp_maychangeby]</phrase></i></font>

			<else />
				<b><phrase 1="$rsvp_day_formatted">$vbphrase[calendar_rsvp_attendquestion]</phrase></b><br />
				<font class="smallfont"><i><phrase 1="$expires[date]">$vbphrase[calendar_rsvp_changeby]</phrase></i></font>

			</if>
			<br/>
			
		<else />
		
			<if condition="$myrsvp">
				<b><phrase 1="$rsvp_day_formatted" 2="$myrsvp">$vbphrase[calendar_rsvp_yoursvp]</phrase></b><br />
				<font class="smallfont"><i>$vbphrase[calendar_rsvp_maychange]</i></font>

			<else />
				<b><phrase 1="$rsvp_day_formatted">$vbphrase[calendar_rsvp_attendquestion]</phrase></b><br />
				<font class="smallfont"><i>$vbphrase[calendar_rsvp_changelater]</i></font>

			</if>
			<br/>
		
		</if>

	<INPUT TYPE=RADIO NAME="response" VALUE="Yes" <if condition="$myrsvp==$vbphrase[yes]">checked="checked"</if>>$vbphrase[yes] 
	<INPUT TYPE=RADIO NAME="response" VALUE="Maybe" <if condition="$myrsvp==$vbphrase[maybe]">checked="checked"</if>>$vbphrase[maybe] 
	<INPUT TYPE=RADIO NAME="response" VALUE="No" <if condition="$myrsvp==$vbphrase[no]">checked="checked"</if>>$vbphrase[no]<br \>
	<if condition="$eventinfo['rsvp_max_guests']">
		<i>$vbphrase[calendar_rsvp_guests_prompt] <input type="text" name="guests" id="guests" size="3" value="$myguests"> 
		$vbphrase[calendar_rsvp_guests]. (<phrase 1="$eventinfo[rsvp_max_guests]">$vbphrase[calendar_rsvp_guest_limit]</phrase>)</i>
	</if>
	
	<if condition="$maxlength">
		<table>
			<tr>
				<td><b>$vbphrase[comment]:</b><br \>
				<td align="right"><font class="smallfont"><i>($vbphrase[calendar_rsvp_maxlength] = $maxlength)</i></font></td>
			</tr>
			<tr>
				<td colspan="2">
				<textarea name="comment" rows="2" cols="80">$mycomment</textarea>
				</td>
			
			</tr>
		</table>

	</if>
	<input type="submit" class="button" value="$vbphrase[submit]" />

	</td></tr>
	</table>
	</form>
</if>
<if condition="$expires[0]<0">
	<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
	<tr><td class="alt2" align="center" valign="center" height="75"><font size="2"><b>$vbphrase[calendar_rsvp_closed]</b></font></td></tr>
	</table>
</if>

voila, preselection of former posted rsvp's works on German vbulletins...