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!

[elricstorm]

Originally Posted by Gooner

I cannot say it enough but you are a great coder and great help, And i will do what you have sugested, I have thought of a small feature which might be of goodness...

A key legend, Because the calander descriptions space isnt enough for full instance names (Mutliple) so instances names need to be made smaller [Karazhan - Kara] and such, Maybe a box someware which tells the members which each one means, Key legend.

Mag - Magtheridon
BT - Black Temple
Kara - Karazkan
SSC - Serpent Shrine Caverns
EOTS - Eye of the storm

This list could be modified by the officers, kinda like the Recruitment status system but in the calander.

Good suggestion. I'm working on separate code that will modify the add/edit events sections so that you can choose all of the instances, max counts of classes allowed, etc. and then modifying the small section that appears above the event description and the event signups so that the new table goes there. I'm definitely going to template this with a table appearance as it will be easier to view. It's just going to take some work to finish.

The problem I'm currently facing is that I don't want to modify the customcalendarfield table but instead create a duplicate of it called wowcustomcalendarfield table. I can then add all of the structures for the calendar fields for description, etc. in here and allow people to decide what calendars they apply to. The reason why I want to do this really goes back to uninstalling the product.

If someone uninstalls the product I don't want to leave anything behind that reflects the product. Call it my tidiness routine. In addition, I don't want to mess with calendars that a person doesn't want the events calendar working on. And, adding customcalendarfields is a tricky thing to implement. But, I'm making progress.

Now, hopefully, the armorydata issues are behind me.

[Gooner]

This is allready becomming a much better alternative to PHPRaider for guilds which use VBulletin websites. I allready prefer this raid management system to PHPRaider for the simple fact, Everything is built into one if you know what i mean, Forums, Raid Signup and the website skin is matching all round.... all on one login/database, I realise this is still in its beta stage and im sure you got more big plans for it, But its allready oozing sweet juice. Im only the Webmaster for my guild and our Guild Leader loves the signup system, as do all the members, Very professional and tidy, I can only wait and be excited for the future features. I will most definatly be advertising your work of art everyware i go.

[Hyrel]

Could not agree more Gooner. VB is awesome and being able to have all the needed things for a guild website getting along is marvelous. Now if I can just get it to work heh.

[elricstorm]

Originally Posted by Hyrel

Could not agree more Gooner. VB is awesome and being able to have all the needed things for a guild website getting along is marvelous. Now if I can just get it to work heh.

Anything else you need help with mate?

Here's a quick list for you to check:

• Check and make sure you created the custom profile fields for main class, alternate1, and alternate2.
• Write down the IDs for the three new custom user profile fields.
• Go into your own usercp and edit -> profile and fill in the fields for your characters.
• Install the product -> current version 1.2.0 (overwrite if necessary)
• Check and make sure all vboptions for the product are filled out and that your custom fields are pointing to the right field IDs you created above
• Go to your calendar and create a new test event and allow user signups.
• You should see your character names in the drop down fields (if you do then you have your custom fields working right)
• Click Yes and submit.
• Everything should look correct now.

Troubleshooting quick list for you to check:

• Check your phpmyadmin and make sure your wowraid and your armorydata tables exist on your forum database
• If both are there, browse your armorydata table and check what data is inside there.

Make sure that all of this is done "without" altering the product.

Thanks.

[Hyrel]

At first i thought I had the same error as NightPhoenix, but I guess it isn't. I'm running on a MySQL 5.0 server.

PHP Code:

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., userfield.
        FROM    forumwowraid ea
            LEFT JOIN forumuserfield AS userfield ON userfield.userid = ea.userid
            LEFT JOIN forumarmorydata arm ON arm.userid = ea.userid
        WHERE    eventid = 010
            AND ocdate = '1181088000'
        ORDER BY
            ea.response, ea.signup_date;

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.
        FROM    forumwowraid ea
            LEFT JOIN forumuserfield AS userfield ON' at line 3
Error Number : 1064
Date         : Wednesday, June 6th 2007 @ 03:58:54 PM
Script       : http://www.rivalnation.com/forums/calendar.php?do=getinfo&e=10&day=2007-6-6&c=1
Referrer     : http://www.rivalnation.com/forums/calendar.php
IP Address   : 76.174.139.167
Username     : CruelAngel
Classname    : vB_Database 


[Masked Crusader]

Been a long time since I have trolled this thread.

I just got around to creating a new guild and have found need for this mod again.

However, I am having ONE issue with it at the moment.

It is the SAME SQL error that everyone else is getting. I believe that everyone is getting this error because the Armory is acting up BADLY.

Of course, it may be something else that I do not know of. Here is the error I am getting:

Database error in vBulletin 3.6.5:

Invalid SQL:

			SELECT field11,,
			FROM userfield
			WHERE userid = 1;

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 '
			FROM userfield
			WHERE userid = 1' at line 1
Error Number : 1064
Date         : Wednesday, June 6th 2007 @ 04:28:10 PM
Script       : http://www.deivictorae.com/calendar.php?do=getinfo&e=3&day=2007-6-7
Referrer     : http://www.deivictorae.com/calendar.php?do=add&c=3&day=2007-6-7
IP Address   : 24.251.140.121
Username     : Protspec
Classname    : vb_database

[elricstorm]

Originally Posted by Hyrel

...

Yours is an easy fix.

Do you see where you have:

PHP Code:

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., userfield. 


Notice it says userfield.x and the (x) is missing? That's pointing to $field5, $field9, and $field10, which are the custom userfields. You either haven't created them and pointed them to the right numbers in vboptions.., or you created them and haven't pointed them to the right numbers in vboptions.

Do you understand how to create custom userfield options? And, if so, do you know how to find the IDs of those fields?

Check my attachments for visual examples.

Remember that if you have a bunch of customfields, yours might be field22, field23, field24, etc. That's why you need to plugin the IDs correctly.

[elricstorm]

Originally Posted by shanejeffery86

Been a long time since I have trolled this thread.

I just got around to creating a new guild and have found need for this mod again.

However, I am having ONE issue with it at the moment.

It is the SAME SQL error that everyone else is getting. I believe that everyone is getting this error because the Armory is acting up BADLY.

Of course, it may be something else that I do not know of. Here is the error I am getting:

First, upgrade to 1.2.0 which fixes some of the bad behavior the timeout settings caused. See if that works. Post back if you have a similar issue. I also see that you are using 3.6.5 and I've only tested this with 3.6.0 and 3.6.7 so I'm not sure what type of behavior it will exhibit on 3.6.5.

Try the upgrade first and I'll try to work with you on your issue and see if we can figure out what's going on. Only a very few people are having issues though. I have similar friends that are using this code on a 3.6.0, 3.6.4, 3.6.5 and I'm using it on a 3.6.7 main and test site.

The armorydata code really does not affect the sql inserts and queries. The armorydata code is just a retrieval mechanism that stores variables that are then used by the queries. The query structure has been in place for all versions. I've only had to slightly modify it.

Just an fyi..

EDIT: Just noticed - you have an "extra" (comma) right after your field11. I can almost bet you a big juicy hamburger that you accidentally placed a comma in vboptions when entering the field ID number. Check vboptions and make sure you didn't place field11, in the option field. That's a "free" field that you can type anything in.

[Masked Crusader]

No extra comma in there...

No idea where the hell it is coming from.

Need help trying to figure out what is going on.

[Hyrel]

hahah I do I was afraid it might be that though, I thought I'd be all cool and just customize it in the xml for what I had. Guess I messed up instead, lets try not doing that and see what happens.