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.

[hunteds911]

Originally Posted by Gryphon

I am not sure what you mean by long retrieval times? Imports are done every 10 minutes (05, 15, 25, 35, 45, 55). If they take longer than that, the Armory may unreachable.

When a person signs up on the calendar for an event it sits there on the sign up list with next to their names with Awaiting Armory data import... . Eventually they show up, but it seems to be a long wait process. I figured if it is automatically going out and acessing the armory ever 10, 15 min and so on then it should cahce it so it doesn't take so long to grab data for on the calendar events. Does the Gwowevent and the Gwowroster character info share the same data that gets pulled/polled every 10, 15, etc. min.?

Just curious if there is a way around the long "Awaiting Armory data import..." on the event calendar really or is it working as intended?

Not complaining just trying to get an idea on how it works and if there is a way to get it to pull data faster if not by caching locally to a data base, maybe bypass the armory for the calendar events or something?

I love the hacks/mods they are awesome. Just curious.

[Gryphon]

It takes a snapshot for a character per event, it does not user prior cache for new events. The reason for a snapshot per event is for historical data not yet implemented, it is working as intended.

[hunteds911]

Originally Posted by Gryphon

It takes a snapshot for a character per event, it does not user prior cache for new events. The reason for a snapshot per event is for historical data not yet implemented, it is working as intended.

Ah ok just figured I would ask seeing I don't know alot about this. It has been educational. BTW again nice addons and thank you for going through and making the time to help me understand how this works.

[Mithan]

Will this work with vB Advanced?
Does it come with the template or do I need to create my own?

Thanks!

[Kinneas]

Originally Posted by Mithan

Will this work with vB Advanced?
Does it come with the template or do I need to create my own?

Thanks!

I'm not sure what you mean by "works with" it, but I'm guessing you could write/use a module with it. I currently use an "Upcoming Events" module which also displays these events.

[Kinneas]

Found a small issue. If someone signs up who at the time was untalented, then although it shows up correctly there is a missing image where there would normally be a graphic icon representing their spec. The file it is looking for, which isn't present on my site or in the latest zip, is \images\misc\gwowevents\icons\spec\11-None.gif

[JaimeJr]

just downloaded this, one question how do you setup events and what not? cant seem to figure it out

[Mithan]

I tried installing this today and I get an immediate error:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE event ADD gwe_signup BOOL NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'gwe_signup'
Error Number : 1060
Request Date : Tuesday, October 21st 2008 @ 09:30:50 AM
Error Date : Tuesday, October 21st 2008 @ 09:30:51 AM
Script : http://www.wowhq.com/forum2/admincp/...=productimport
Referrer : http://www.wowhq.com/forum2/admincp/...?do=productadd
IP Address : 67.225.32.128
Username : Mithan
Classname : vB_Database
MySQL Version : 4.1.21-log

Any idea?

I even wiped the forum and re-installed this and get the same problem.

Thanks.

[Gryphon]

@Mithan not sure how it happened. But use phpMyAdmin to delete the gwe_signup column from the event table then install the mod.

[Mithan]

Originally Posted by Gryphon

@Mithan not sure how it happened. But use phpMyAdmin to delete the gwe_signup column from the event table then install the mod.

I've done that and it still wont work

It just refuses to install for some reason.


Do you think it could be do to some setting with mysql?