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.

[LostPhoenix]

Anyone else having an issue with the cron job failing?

[soothius]

Thanks for the mods gryphon! I managed to get the other two to work fine but am having trouble with this one. It seems it's installed and i can edit the options but when i go to create an event i have no options to use the mod. Currently i just go to calender and create event but am i supposed to do it antoher way? Thanks for any help.

Btw my modest board is located at www.wowdownunder.com .

[Gryphon]

Originally Posted by LostPhoenix

Anyone else having an issue with the cron job failing?

Going to need a bit more information to be able to help. Are there errors?


@soothius, just create an event and make sure to check the box to enable signup.

[LostPhoenix]

Originally Posted by Gryphon

Going to need a bit more information to be able to help. Are there errors?

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vb_gwowevents SET 
				`charurl` = 'r=Arygos&n=Censored',
				`level` = '70',
				`title` = '',
				`faction` = 'Horde',
				`factionid` = '1',
				`gender` = 'Male',
				`genderid` = '0',
				`race` = 'Undead',
				`raceid` = '5',
				`class` = 'Priest',
				`classid` = '5',
				`talentspec` = '20,41,0',
				`talent1` = '20',
				`talent2` = '41',
				`talent3` = '0',
				`guild` = '',
				`guildurl` = 'r=Arygos&n=&p=1',
				`hp` = '6891',
				`mp` = '10065',
				`str` = '38',
				`agi` = '43',
				`sta` = '368',
				`int` = '515',
				`spi` = '521',
				`arm` = '1359',
				`strbase` = '38',
				`agibase` = '43',
				`stabase` = '59',
				`intbase` = '143',
				`spibase` = '163',
				`armbase` = '1359',
				`prof1` = 'Engineering',
				`skill1` = '375',
				`prof2` = 'Mining',
				`skill2` = '375',
				`cooking` = '375',
				`firstaid` = '375',
				`fishing` = '375',
				`riding` = '300',
			 `armorydata` = '1' WHERE `realmchar` = 'Arygos.Censored';

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013
Date         : Thursday, February 21st 2008 @ 06:27:46 PM
Classname    : vb_database

If I run the same SQL call from phpmyadmin it goes fine. I think vBulletin is closing the connection to the database while the cron is running.

[Caerydd]

wewt, I have a test site now ^^

Will be trying this out on that over the weekend.

[jim6763nva]

How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

[LostPhoenix]

Originally Posted by jim6763nva

How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

Jim,

Looks like you have the same issue as me. Login to your admin and check your scheduled tasks. Select gWoWEvents and select run now. If you get an error then we are in the same boat.

[Foghorn Deadhor]

<i>Note: still haven't installed, so take it for what it's worth:</i>

The feature with the by-event stat pulling sounds cool, and having a "history" of stats is a neat idea, but I'm going to say that I personally would probably disable this as it's a feature that doesn't concern me personally and seems bound to have performance issues, especially with Armory's unreliable nature. Perhaps this could be a main-switch option, or perhaps it could be by-event.

I personally would vastly prefer that it pull from the same table as the roster.

Still waiting to hear that it will work with event forums :P

[Gooner]

Great mod, now i hope you do not abandon such a great mod like Elric did

[Gooner]

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

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE gwowevents SET
`charurl` = 'r=Shadowsong&n=Aloysius',
`level` = '70',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Orc',
`raceid` = '2',
`class` = 'Warrior',
`classid` = '1',
`talentspec` = '8,5,48',
`talent1` = '8',
`talent2` = '5',
`talent3` = '48',
`guild` = 'Ordo Templi Draconis',
`guildurl` = 'r=Shadowsong&n=Ordo+Templi+Draconis&p=1',
`hp` = '11394',
`mp` = '100',
`str` = '287',
`agi` = '147',
`sta` = '713',
`int` = '30',
`spi` = '54',
`arm` = '13691',
`strbase` = '162',
`agibase` = '93',
`stabase` = '141',
`intbase` = '30',
`spibase` = '54',
`armbase` = '13691',
`prof1` = 'Blacksmithing',
`skill1` = '250',
`prof2` = 'Mining',
`skill2` = '155',
`cooking` = '',
`firstaid` = '375',
`fishing` = '1',
`riding` = '225',
`armorydata` = '1' WHERE `realmchar` = 'Shadowsong.Aloysius';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Sunday, February 24th 2008 @ 08:43:47 AM
Script : http://www.********t/admincp/cronadm...cron&cronid=23
Referrer : http://www.********t/admincp/index.php
IP Address : 77.101.215.207
Username : ********
Classname : vB_Database