Add-On Releases - gWoWEvents - World of Warcraft Event Signup

What is it?
[hr]-[/hr]gWoWEvents is a modification for vBulletin which allows you to add World of Warcraft event sign ups to your forum calendar.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

Follow me on twitter!

Support
[hr]value[/hr]I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
[hr]-[/hr]

• Allows your users to enter multiple servers and characters
• Links to either US or EU WoW Armorys.
• Links icons to wiki.
• Choose calendar to use
• Limit use by usergroup
• Multiple server support
• Shows extended character data, skills, talents.
• Some features translated for French and German
• Character data is fetched by cron so calendar doesn't suffer slowdown
• Templated so you can direct links somewhere other than the Armory if you wish.
• Unified profilefield compatible with gWoWRoster and gWoWChar

Installation
[hr]-[/hr]

1. Download the latest version and upload all files.
2. Install the product.
3. Create a Multiple-Line Text Box User Profile Field.
   • /admincp/?loc=profilefield.php%3Fdo%3Dadd
   • Multiple-Line Text Box
   • Continue
   • Title: World of Warcraft Characters
   • Description:

     Enter one character per line.<br /><br />Format: US/EU|Realm|Faction|Name<br /><br />Example: US|Mal'Ganis|Alliance|Gryphen

   • Default Value: Leave Blank
   • Max length of allowed user input: 1000
   • Field Length: 50
   • Text Area Height: 6
   • Field Editable by User: Yes
   • Other options are optional.
   • Save
   • Look and see what the field name is for World of Warcraft Characters, example field25.
4. Fill in the gWoWEvents configuration options.
5. That is all, instruct people to fill in their profile.

Changes
[hr]-[/hr]
v1.0.10a - upload class_gwowarmory.php

• Quick fix for Armory import.

v1.0.10 - upload cron.gwowevents.charinfo.php, class_gwowarmory.php, import product with overwrite

• Quick fix for 3.1 armory changes.
• Secondary skills disabled for now.

v1.0.9 - upload cron.gwowevents.charinfo.php, upload images, import product with overwrite

• Death knight images, thanks SlompOchomp
• Fix special characters in player names

v1.0.8 - import product with overwrite enabled

• Fix spelling error
• Fix for signup allowance periods

v1.0.7 - Upload functions_gwowevents.php, images, import product with overwrite enabled

• Updated for WotLK

v1.0.5 - Import product with overwrite enabled.

• Used phrases for more text
• Added option to show who has viewed the event details.

v1.0.4 - Upload all files import product.

• Added a 4th, "Yes Late", signup option
• Comment minimum setting for Late and Maybe options

v1.0.3 - Import product.

• Update for 3.7.0 Gold, thank you Kinneas

v1.0.2 - Upload all files import product.

• Initial Release

Copyright
[hr]-[/hr]gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[Kaelon]

Hey there,

When creating an event (using the latest version, 1.0.8), I get a "Signup for this event is no longer available." if the event lands on the same day that a user tries to sign up. This seems to be regardless of when the signup allowance has been set in the gWoWEvents Configuration. Any thoughts?

[Tolas]

Originally Posted by Kaelon

Hey there,

When creating an event (using the latest version, 1.0.8), I get a "Signup for this event is no longer available." if the event lands on the same day that a user tries to sign up. This seems to be regardless of when the signup allowance has been set in the gWoWEvents Configuration. Any thoughts?

Discovered the same problem today.

Event is scheduled for tomorrow night, it disabled signups for the event, even though I have the options set to never disabled signups.

**Edit**

Seems to only affect one event now, the rest appear fine thus far. I will look into how my user created the event and see if maybe something was done differently. I'll post again if I continue to see this happen on more events.

[Tolas]

Seems the problem came back. I removed and re-installed again and same problem. All of our events are locking down signups about a day and a half before the event starts, regardless of any settings.

[Gryphon]

Currently our guild hasn't been utilizing the signup so I have not been able to tweak that feature correctly. I have also been busy with work and other projects.

I will look into this when I have available time.

[y2krazy]

Originally Posted by Renny

The icons you get with it. What are they for and how do i use them? like how do i make the icon the url on the calender page Like how this website has:

Furthermore, do you know how you can make a module in vbadvanced like the 2nd image? to show upcoming events like it has done?

Anyone come to any solutions for implementing this? Thanks in advance!

Also, after an Armory update on an event in my Calendar, why are my First Aid, Cooking, Fishing and Riding skills all set to 0?

~ Sean

[Dragonsys]

Originally Posted by y2krazy

Anyone come to any solutions for implementing this? Thanks in advance!

Also, after an Armory update on an event in my Calendar, why are my First Aid, Cooking, Fishing and Riding skills all set to 0?

~ Sean

The Armory does not have the secondary Skills info anymore.

[y2krazy]

Originally Posted by Dragonsys

The Armory does not have the secondary Skills info anymore.

It's not possible to retrieve them from the Skills page? I assume they were being pulled from the Character Sheet if that's the case. Ionno, just a thought?

~ Sean

[Dragonsys]

Originally Posted by y2krazy

It's not possible to retrieve them from the Skills page? I assume they were being pulled from the Character Sheet if that's the case. Ionno, just a thought?

~ Sean

What skills page? the US Armory does not have a skills page anymore, at least not that I can find... I wish it owuld. I would love to add those skills into my Roster.


EDIT: I found them. They are in the Stats. For example - http://www.wowarmory.com/character-s...sh&n=Dragonsys (under Skills -> Secondary Skills)
Just need to get the data pulled and added my DB...

[SlompOchomp]

I have resized the Death Knight Spec Icons.
Place these .PNGs in your DIR

images\misc\gwowevents\icons\spec

[SlompOchomp]

just started getting this error

gWoWEvents Armory Import


Fatal error: Cannot use string offset as an array in D:\Hosting\4072979\html\includes\cron\cron.gwoweve nts.charinfo.php on line 53

Any resolve to this issue ?

Update: I ended up doing this to resolve my issue and all seems to work.

Originally Posted by LostPhoenix

Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}

and change it to:

$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
} else {
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
}

Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.