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.

[Collyn]

Ok, so I posted a little earlier about how sign ups span across multiple events. My original thought was it did the to ranged events because essentially they were all the same event as the sign up mod saw it.
So as much of a pain in the..... as it is We corrected it by posting indivdual events on each day. The issue however still persists when you have more than one event on the same day. The sign up for one event will span over to the next.

www.shadowwalkersguild.com Wed 2-27 would be a good example of this.

[Kinneas]

Originally Posted by Gooner

i also am getting error when running cron job...

I got this problem because of a timeout limit I think. Try increasing the timeout value for MySQL queries (or ask your host to).

[Tolas]

I have the same issue with the armory imports just going and going and going. I ran the job manually from the admin panel, got no error, it said it completed the job and showed the characters it imported. Back to calendar and still acting like its hung on importing, no info is shown at all.

[Mother_Dee]

I would love to see perhaps icons, say if an event has a trigger word in the title such as "Black Temple", "BT", "Temple", etc.) it would show the BT icon on the calendar. It would also be very cool to be able to set the number of signups or the classes necessary, etcetera, though that becomes massively complicated, I know.

Finally, it would be neat to see it perhaps even tied in with a bit of a revamped "Upcoming Events Module" for vBadvanced to also show the corresponding icon (BT, TK, MH, etc.), perhaps even number of attendees (20/25, etc...) and the like.

This is a far superior mod to the previous, I really enjoy seeing you and Sweede compete for most WoW mods, it makes for a some great Guild Forums.

[Gryphon]

Originally Posted by Tolas

I have the same issue with the armory imports just going and going and going. I ran the job manually from the admin panel, got no error, it said it completed the job and showed the characters it imported. Back to calendar and still acting like its hung on importing, no info is shown at all.

Hopefully it eventually went through? This is common when the Armory is unreachable.

Originally Posted by Mother_Dee

I would love to see perhaps icons, say if an event has a trigger word in the title such as "Black Temple", "BT", "Temple", etc.) it would show the BT icon on the calendar. It would also be very cool to be able to set the number of signups or the classes necessary, etcetera, though that becomes massively complicated, I know.

Finally, it would be neat to see it perhaps even tied in with a bit of a revamped "Upcoming Events Module" for vBadvanced to also show the corresponding icon (BT, TK, MH, etc.), perhaps even number of attendees (20/25, etc...) and the like.

This is a far superior mod to the previous, I really enjoy seeing you and Sweede compete for most WoW mods, it makes for a some great Guild Forums.

Thanks, some of these suggestions have also been requested by my guild and are on my see-if-I-can-do list.

[Tolas]

Originally Posted by Gryphon

Hopefully it eventually went through? This is common when the Armory is unreachable.

Unfortunately no.

I installed the mod yesterday and still I just have the spinning circles on everyone's names saying Awaiting Armory data import... The actual signup works fine, just no info being imported.

Odd thing is that your gWoWRoster plugin and Sweede's WoW BBCode plugin both are pulling data from the armory and I can view the profiles of any of our characters if I go to the Armory directly. I installed all 3 around the same time.

Not sure what else might be wrong?

Edit:

I think I may have figured it out,

I changed from Argent+Dawn in my profile field and in the gwowevent options to Argent Dawn.

It pulled all three characters I had entered on different dates. Previously I used Elric's calendar mod and all my guildmates have entered using Argent+Dawn.

could this be why? if so I will have to have folks change their profiles to get it going I guess. I also noticed I forgot to set the Calendar from 0 to 1 (the id of my calendar I am using). I changed it, changed my settings and my own profile back to Argent+Dawn and re-ran the job and got no data for anyone, including my characters (after re-signing up my own)

[Tolas]

heh, I guess I answered my own question. I left it overnight and no armory data. So I will change the setting and have folks remove the + from the server name and hopefully should be working better.

One other question, is there a way the data can be cached? I noticed if I switch from Yes to Tentative or No it starts to re-import.

[Ninok]

I'm also getting the Cron job errors while trying to pull the data from the Armory. I have increased the Timeout value etc, I get the error no matter what I do.

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE gwowevents SET 
				`charurl` = 'r=Blackhand&n=Ninnok',
				`level` = '70',
				`title` = '',
				`faction` = 'Horde',
				`factionid` = '1',
				`gender` = 'Male',
				`genderid` = '0',
				`race` = 'Blood Elf',
				`raceid` = '10',
				`class` = 'Paladin',
				`classid` = '2',
				`talentspec` = '42,19,0',
				`talent1` = '42',
				`talent2` = '19',
				`talent3` = '0',
				`guild` = 'Mithril',
				`guildurl` = 'r=Blackhand&n=Mithril&p=1',
				`hp` = '7717',
				`mp` = '8943',
				`str` = '123',
				`agi` = '79',
				`sta` = '452',
				`int` = '418',
				`spi` = '125',
				`arm` = '14557',
				`strbase` = '123',
				`agibase` = '79',
				`stabase` = '118',
				`intbase` = '95',
				`spibase` = '88',
				`armbase` = '14557',
				`prof1` = 'Engineering',
				`skill1` = '358',
				`prof2` = '',
				`skill2` = '',
				`cooking` = '6',
				`firstaid` = '375',
				`fishing` = '',
				`riding` = '225',
			 `armorydata` = '1' WHERE `realmchar` = 'Blackhand.Ninnok';

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013
Date         : Saturday, March 1st 2008 @ 04:45:17 PM

[quedex]

Hi!

First of all thanks for a great mod!
Now to the question, is it possible to make the mod pull Spell dmg, armor, defence info
also/instead of pure stats per class basis?

[Gooner]

are you going to fix this mod??