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!

[wolfman]

Originally Posted by Caerydd

Is there a mac friendly version of the instructions? My usual 'open everything in TextWrangler' didn't work with it >>

Is an old fashion .txt so bad *puppy dog eyes*

*emails self a copy of the file, and opens on PC* Good thing I'm at home >>

I did find a mac application that can read .chm files http://chmox.sourceforge.net/

[Synth]

Originally Posted by Stabatha

Hi there,

I am receiving this error when trying to create a new raid... I have tried uninstalling and reinstalling the product 6 times too!

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT field5,,
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

I'm having this same issue as well when I use 1.2.6 and click on the created event. When I try to install 1.2.7 i get:

PHP Code:

Database error in vBulletin 3.6.2:

Invalid SQL:

                INSERT INTO setting
                    (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
                VALUES
                    (
                    'wow_font_style',
                    'wow_calendar_style',
                    'Verdana',
                    'Verdana',
                    'free',
                    '',
                    11,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_fontsize_style',
                    'wow_calendar_style',
                    '8pt',
                    '8pt',
                    'free',
                    '',
                    21,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_druid_color',
                    'wow_calendar_style',
                    '#FF3300',
                    '#FF3300',
                    'free',
                    '',
                    71,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_hunter_color',
                    'wow_calendar_style',
                    '#33FF33',
                    '#33FF33',
                    'free',
                    '',
                    82,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_mage_color',
                    'wow_calendar_style',
                    '#33FFFF',
                    '#33FFFF',
                    'free',
                    '',
                    83,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_paladin_color',
                    'wow_calendar_style',
                    '#FF66CC',
                    '#FF66CC',
                    'free',
                    '',
                    84,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_priest_color',
                    'wow_calendar_style',
                    '#FFFFFF',
                    '#FFFFFF',
                    'free',
                    '',
                    85,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_rogue_color',
                    'wow_calendar_style',
                    '#FFFF66',
                    '#FFFF66',
                    'free',
                    '',
                    86,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_shaman_color',
                    'wow_calendar_style',
                    '#FF3333',
                    '#3366FF',
                    'free',
                    '',
                    87,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_warlock_color',
                    'wow_calendar_style',
                    '#CC9966',
                    '#CC66CC',
                    'free',
                    '',
                    88,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_warrior_color',
                    'wow_calendar_style',
                    '#CC66CC',
                    '#CC9966',
                    'free',
                    '',
                    89,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_table_width',
                    'wow_calendar_style',
                    '100%',
                    '100%',
                    'free',
                    '',
                    90,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_time_width',
                    'wow_calendar_style',
                    '18%',
                    '18%',
                    'free',
                    '',
                    91,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_name_width',
                    'wow_calendar_style',
                    '12%',
                    '12%',
                    'free',
                    '',
                    92,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_level_width',
                    'wow_calendar_style',
                    '7%',
                    '7%',
                    'free',
                    '',
                    93,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_class_width',
                    'wow_calendar_style',
                    '8%',
                    '8%',
                    'free',
                    '',
                    94,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_talents_width',
                    'wow_calendar_style',
                    '10%',
                    '10%',
                    'free',
                    '',
                    95,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_gender_width',
                    'wow_calendar_style',
                    '5%',
                    '5%',
                    'free',
                    '',
                    96,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_race_width',
                    'wow_calendar_style',
                    '8%',
                    '8%',
                    'free',
                    '',
                    97,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_genrace_width',
                    'wow_calendar_style',
                    '9%',
                    '9%',
                    'free',
                    '',
                    98,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_comments_width',
                    'wow_calendar_style',
                    '28%',
                    '28%',
                    'free',
                    '',
                    99,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    );

MySQL Error  : Duplicate entry 'wow_font_style' for key 1
Error Number : 1062
Date         : Tuesday, October 30th 2007 @ 03:17:31 PM
Script       : [url]http://hop-guild.com/forum/admincp/plugin.php?do=productimport[/url]
Referrer     : [url]http://hop-guild.com/forum/admincp/plugin.php?do=productadd[/url]
IP Address   : 74.142.45.149
Username     : Onixx
Classname    : vb_database 


[Jrain157]

Got it to work on www.tamalesguild.com, but the load time for the signups takes FOREVER. Are there any settings that can be changed to improve performance?

[SocialNetworkBuzz]

Originally Posted by Stabatha

Hi there,

I am receiving this error when trying to create a new raid... I have tried uninstalling and reinstalling the product 6 times too!

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT field5,,
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

Still getting this error. Has anyone gotten this to work with vb 3.6.8?

Still getting this error

[Lord Doys]

Originally Posted by Disi

The other thing is, you schould cache the armory side and just update it once a day. its sometime so slow that i could me a cap of cofee . A secound advantage is that if you cache it you got a working version if armory is down

Was thinking about this as well, members are complaining alot that the calendar is SOOO slow. (while it is actually the armory that is the bugger.)

So i agree with Disi.
Cache the characters like once per day (maybe even week..variable?) with a cron job.

And when people sign up, pull data straight from cache.

[atomhead]

Originally Posted by Lord Doys

Was thinking about this as well, members are complaining alot that the calendar is SOOO slow. (while it is actually the armory that is the bugger.)

So i agree with Disi.
Cache the characters like once per day (maybe even week..variable?) with a cron job.

And when people sign up, pull data straight from cache.

Yeah I'd have to agree, currently way too slow pulling data into the list. Had just one character and it took like 30 seconds. Looking for other alternatives until that's fixed =\

[LostPhoenix]

I was toying around with this mod and found that if you have two events for the same day (and view by day instead of event) you will get signed up for both events. Anyone else ran into this problem?

I did some more testing, and it seem the problem comes when reading from the database on the calendar date pages (not specific event). I checked the database, and each signup is only in for the correct event. Does this mean the strings aren't clearing?

[Collyn]

I'm not experiencing those errors on mine. It seems to be working fine with multiple sign ups on the same day. Other than the slowness that everyone else seems to be experiencing.

Risking duplicate entries if this happens I apologize we are 24+ pages deep now.
In our guild I have the issue where I have people with multiple raiding 70's more than 3 the issue with selectable names was fixed by adding the following.

in calendar_signup_form
find:

PHP Code:

<if condition="$alternates">
                    <if condition="!$mycharacter[1]==''"><option value="$mycharacter[1]" <if condition="$mysignupname == $mycharacter[1]">selected</if>>$mycharacter[1]</option></if>
                    <if condition="!$mycharacter[2]==''"><option value="$mycharacter[2]" <if condition="$mysignupname == $mycharacter[2]">selected</if>>$mycharacter[2]</option></if> 


Understand that your 1st character is 0, second is 1, 3rd is 2, and so on. Max characters that you can have on a server is 10. So after the above code add.

PHP Code:

                    <if condition="!$mycharacter[3]==''"><option value="$mycharacter[3]" <if condition="$mysignupname == $mycharacter[3]">selected</if>>$mycharacter[3]</option></if>
                    <if condition="!$mycharacter[4]==''"><option value="$mycharacter[4]" <if condition="$mysignupname == $mycharacter[4]">selected</if>>$mycharacter[4]</option></if>
                    <if condition="!$mycharacter[5]==''"><option value="$mycharacter[5]" <if condition="$mysignupname == $mycharacter[5]">selected</if>>$mycharacter[5]</option></if>
                    <if condition="!$mycharacter[6]==''"><option value="$mycharacter[6]" <if condition="$mysignupname == $mycharacter[6]">selected</if>>$mycharacter[6]</option></if>
                    <if condition="!$mycharacter[7]==''"><option value="$mycharacter[7]" <if condition="$mysignupname == $mycharacter[7]">selected</if>>$mycharacter[7]</option></if>
                    <if condition="!$mycharacter[8]==''"><option value="$mycharacter[8]" <if condition="$mysignupname == $mycharacter[8]">selected</if>>$mycharacter[8]</option></if>
                    <if condition="!$mycharacter[9]==''"><option value="$mycharacter[9]" <if condition="$mysignupname == $mycharacter[9]">selected</if>>$mycharacter[9]</option></if> 


this will extend the drop down and allow more selectable charaters for those guildies that have no life

[cgootgeld]

I too am having load time issues with the calendar. I've made sure that the Database is optimized and working properly but still experience long page load times. I thought this was an armory issue but the strange thing is that when I'm logged in as a Admin the calendar loads instantaneous, only when I'm logged in as a registered/member user do I have these problems. Could this be related to user permissions with the calendar and since we have over 100 members and only 1 admin be the cause of this?

[ranmasao12]

has anyone figured out how to address the speed issues when your linked into the armory. I figure the armory is slow so the calendar is slow. i would still like to link the character info but I dont want the system to hit the armory page on every load. If we could schedule a job to cache the info into the database then pull from there that would be great!