Add-On Releases - World of Warcraft Event Calendar

What does this Mod do?
[hr].[/hr]

This is a calendar mod that supports events created for World of Warcraft that allows signups for mains and alternates. Data for mains and alternates are pulled from the world of warcraft armory automatically and listed/displayed in a table format based on the style of your current site.

Current Version
[hr].[/hr]

Current beta version = 1.2.7 (recommended)
Current stable version = 1.2.6

Whether you are upgrading or installing from new, you ALL need to download the instructions and read them. There is a section for New Installs and a section for Upgrading. Inside there is also a NEW .CHM file (help file) that will also make it easier to read. I kept the instructions file in there as well but it's renamed to wowcalendar.txt instead. Review wowcalendar.chm if you are able to. It works better.

What is required?
[hr].[/hr]

You will essentially need to perform:

• One product XML import
• Two PHP file uploads
• One Profile addition for User Profiles
• One Template Modification
• Uploading image files to the specified path listed in the instructions

Review the "instructions" contained in the zip file before installing this product.

Creating a Calendar Entry
[hr].[/hr]

When you create a calendar entry, single, recurring, etc. - make sure you enable users to signup (located at the bottom of the new calendar event form) (see the screenshot listed in this post). By default, it should place an automatic signup checkmark in that box. Once you submit, users will be able to signup.

Alternates
[hr].[/hr]

If you have alternates on, alternates can be used to signup with (only if people have added additional characters to their user profile. At this time, the calendar only reads the top 3 lines in the profile box so any more characters listed will not be usable in the calendar.

(i.e. if you have 7 characters listed, only the first 3 will be usable.

Armory Data
[hr].[/hr]

Armory Data is pulled as soon as a "registered" user checks the calendar event. This data is then replaced into the armorydata table for use later on with the signups. Remember to set your server and your locale as well. If your server has two words (ex. Scarlet Crusade) you would input Scarlet+Crusade in the server box. If you play on a US server you would put US in the locale box. If you play on a European Server you would input EU in the locale box. Make sure you set all appropriate options.

Options for your Calendar System
[hr].[/hr]

Go into your vb options and you will find two separate sections for setting options - one is for settings and one is for styles. You can change any options in here. Future revisions will include more substitutions/changes in this area.

SPECIAL THANKS TO:
[hr].[/hr]
[name]Farcaster[/name]:
For his initial MOD and ideas which got me started and into customizing the entire calendar. Farcaster's Event Attendance can be found at: https://vborg.vbsupport.ru/showthread.php?t=129088

[name]Gryphon[/name]:
For helping with the original wow parser code and for giving me some tips/advice for working to implement it with the calendar system. In addition, Gryphon, formerly Blackjack, worked with me deeply to allow both this calendar and his current gWoWCharacter mod to be cross-compatible. He also helped with localization. Many thanks!

[Noxious]

hmm can't seem to download it, keeps coming up with a site unavailable message but i can still download the instructions.txt file which wasn't changed

by any chance is this a corrupt upload?

o and no need to thank me, thank you for making an awesome mod

[elricstorm]

Just checked and I see no issues with the file. I'm able to download it fine and it's the correct file size and I even checked and verified all of the code. You might want to make sure you are viewing a new page and not pulling from an old download link. Clear out your offline files and refresh your browser. Also, I see that 4 people have downloaded the new version so don't see an issue here.

[Noxious]

sorted

[elricstorm]

great!

[elricstorm]

Fixed a small coding issue in 1.1.6 which affected class counts not working for 4 alternate class types. All counts are now working properly in 1.1.7. Hopefully this should fix the remainder of the tweaks and revisions for the alternates system now.

[Nrf_Tivoli]

I'm getting this error after adding checking Allow Signups to an event.

Database error in vBulletin 3.6.7:

Invalid SQL:

		SELECT	ea.userid, ea.response, ea.signupname, ea.comment, ea.signup_date, 
			arm.m_name,arm.m_class,arm.m_race,arm.m_level,arm.ai_name,arm.ai_class,arm.ai_race,arm.ai_level,arm.aii_name,arm.aii_class,arm.aii_race,arm.aii_level,
			userfield.field5, userfield.field9
		FROM	vb_wowraid ea
			LEFT JOIN userfield AS userfield ON userfield.userid = ea.userid
			LEFT JOIN armorydata arm ON arm.userid = ea.userid
		WHERE	eventid = 031
			AND ocdate = '1180828800'
		ORDER BY
			ea.response, ea.signup_date;

MySQL Error  : Table 'xxxxxxxxx.userfield' doesn't exist
Error Number : 1146
Date         : Sunday, June 3rd 2007 @ 10:19:51 AM
Script       : http://forums.nurfed.com/calendar.php?do=getinfo&e=31&day=2007-6-3
Referrer     : http://forums.nurfed.com/calendar.php?do=manage&e=31
IP Address   : XXXXXXXX
Username     : Tivoli
Classname    : vb_database

I've tried uninstalling the product and reinstalling, same issue. I can add events fine, it only happens after checking signups, and then i can't even select the event without getting this error.

[elricstorm]

The userfield table is a standard table that holds all of the profile information and comes default with all vbulletin packages. The error you are receiving is stating that your "xxxx.userfield" table does not exist. I'm guessing that you changed what the real database name is and masked it by placing in the xxxx yourself? For instance, if I named my default VB database "vbtestdatabase", my custom profile fields would be stored in 'vbtestdatabase.userfield'.

The first thing you should do is make sure that "xxxxxxxxx" is referencing your real forum database, and secondly, if that is true, go into phpmyadmin or a similar utility and check to verify that your userfield table exists in that. If it does not, you need to work on figuring out why you are missing that table. This table is not altered/modified by the product itself. The only thing you are doing with this table is creating the custom fields from your own admincp. Did you do this? Did you follow all of the instructions?

I hope that helps answer your question.

[Nrf_Tivoli]

Actually, i figured it out. Lines 651 to 663, that sql statement is missing TABLE_PREFIX, so it can't find the tables ^^. Should look like this.

	// SELECT SQL for signups for this event
	$signups = $db->query_read("
		SELECT	ea.userid, ea.response, ea.signupname, ea.comment, ea.signup_date, 
			arm.m_name,arm.m_class,arm.m_race,arm.m_level,arm.ai_name,arm.ai_class,arm.ai_race,arm.ai_level,arm.aii_name,arm.aii_class,arm.aii_race,arm.aii_level,
			userfield.$field5, userfield.$field9
		FROM	".TABLE_PREFIX."wowraid ea
			LEFT JOIN ".TABLE_PREFIX."userfield AS userfield ON userfield.userid = ea.userid
			LEFT JOIN ".TABLE_PREFIX."armorydata arm ON arm.userid = ea.userid
		WHERE	eventid = 0".$eventinfo['eventid']."
			AND ocdate = '".$signupdate."'
		ORDER BY
			ea.response, ".$orderby."
		");

[Gooner]

it would be cool to add something similar to the "Todays Birthdays" module but instead "Todays Raids" so guild members can see straight away from the CMPS which raids are happening today.

[Gooner]

Is it possible to add an option to sort the signed up list by "Class", its good to know what members of each class can attend the raid. Sorting by class made this mod better, Please re-add it someware

in 1.1.2 with the class field, it was possible, but now with armory update its not possible