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.

[KrU$ty]

I'm getting an issue where the selected field is not getting picked up. Even though all settings are correct and the information entered into the field is also correct, i get "Add characters to your profile to singup for this event.".

Also notice the spelling mistake in the error message.

Edit: I fixed the error. So its just the spelling mistake i guess.

[Ammadar]

I am very new to vBulleting so maybe I am just blind but I have a question. I followed the installation instructions and I get to Step 4 (Fill in the gWoWEvents configuration options.) Where are these options? in the Admin Console? Edit a php file? I have must be blind but I have been reading the posts for the last two hours and I can't find the configuration options I know I need to change my userfield setting to fix the error below but I can't find the place to fix it.

Any help would be appreciated.

Thanks.

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 03
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 4th 2008 @ 04:01:46 PM
Error Date : Wednesday, June 4th 2008 @ 04:01:47 PM
Script : http://www.wowpara.com/calendar.php?...y=2008-6-4&c=1
Referrer : http://www.wowpara.com/calendar.php
IP Address : 10.64.2.3
Username : Viane
Classname : vb_database
MySQL Version : 4.1.20

[Ammadar]

<font size="3">Finally Found The Options Ignore My post it was in the third post on the site I must have read it 20 times...

For those that missed it like me it is :
vBulletin Options

at the very bottom you will see the configs.</font>

[ColossusCH]

Hi to all,
i get a problem with names like "Râul, Merlè, ect.)
gwowevent, can't find names like this in Armory.

can somebody help me?

PS, in gwowroster, those names are: Merlé Râul

thank you for help.

[Gryphon]

Originally Posted by ColossusCH

Hi to all,
i get a problem with names like "R?ul, Merl?, ect.)
gwowevent, can't find names like this in Armory.

can somebody help me?

PS, in gwowroster, those names are: Merlé Râul


thank you for help.

Yes, these characters is still an issue. There is no fix currently I am sorry to say.

[Sanctorum]

I filled out my config in Admin but I still get this error, I even did a fresh install of vBulletin 3.7.1, can someone tell me how to get this working for my guild?:

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 01
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 11th 2008 @ 03:38:22 PM
Error Date : Wednesday, June 11th 2008 @ 03:38:22 PM
Script : http://www.bloodorderguild.us/bogfor...8-6-11&e=1&c=1
Referrer : http://www.bloodorderguild.us/bogforum/index.php
IP Address : 204.249.195.240
Username : Sanctorum
Classname : vB_Database
MySQL Version : 5.1.24-rc

[Gryphon]

Originally Posted by Sanctorum

MySQL Error : Unknown column 'userfield.field0' in 'field list'

You need to change your field id from 0.

[Sanctorum]

Originally Posted by Gryphon

You need to change your field id from 0.

Oh, silly me... I figured it out after I posted. Thanks

Seems the Armory is down, otherwise it's a great mod, thanks for the good work. Marked as Installed.

[twitch]

awesome mod, thanks

[Sanctorum]

It works now, but it doesn't import the data from the Armory:

Aquilae Awaiting Armory data import...

Is there a fix for this or am I being stupid again? Yes, it's set to US.

*update*
It appears to update when the player logs off of wow, not sure if this is relevant.