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.

[Eviserator]

I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import


Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62

Spinochio
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ScoopjacksonArray
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ElyArray
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)

Can you help me understand what the actual error might be?

[Gryphon]

Originally Posted by 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.

Thanks, I was at a loss for why you were not getting updates. I urlencode the profile fields before fetching the armory data, so yes plain text is all that is needed.

I had some reasons for why it does what it does but no longer remember exactly why. Recently ran into this issue myself and will be re-evaluating the way the data is stored per previous suggestions.

Originally Posted by 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.

I am afraid that I do not have a solution for this, maybe someone else may have some input.

Originally Posted by 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?

Thank you. Yes it is possible, I will add this suggestion to my list.

Originally Posted by Gooner

are you going to fix this mod??

What is broken? Some features are requested, but the primary goal of the mod as it is released works.

Originally Posted by Eviserator

I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import

Please put code tags around such large data pastes in the future. I am not positive, but it appears that the Armory is telling you that there is no such character as Spinochio, Scoopjackson, or Ely. Ensure that the users profile fields are entered properly. I will see if I can recreate this error.

[Sarosh]

i am unable to find the event sign up?? i followed the instructions on the first post, and its not showing, only able to enter char information in profile field. thats all. nothing with event sign up??

[janthes]

After using PHPRaid to manage our sign-ups for so long, I want to try something a little more integrated into the main forums to handle sign-ups so I switched to this.

I got everything up and running in no time, and it seems to do the job well enough but I do have a couple of ideas that I didn't see posted earlier:

1. Is it possible to have a wider selection of what stats are displayed from the Armory data? I would prefer to know how much +healing my healers have versus how much strength they have, ya know?

2. The ability to sort the information presented by name, class, and date without having to go into the admin control panel to do it. It would also be nice to be able to sort by spec, if that is possible. The armory data gives you if a spec is demonology, protection, or holy, right? I don't know personally. :/

3. Maybe a piggyback onto the previous idea, changing the "total sign-up" part at the top to include more information? For example, in the Warlock box you could have it say "Warlocks (2)" and then beneath it list the names of the Warlocks who have signed up and their spec? That would actually take the need of sorting people by spec below out of the equation.

Other than that, the mod seems very well put together.

Thanks for the effort and keep up the good work.

[Gryphon]

@Sarosh I do not understand what you mean.

@janthes Thank you for the suggestions. 1) More data is on the list. 2) Named specs are not provided by the Armory, this mod determines them at the time of display by some math done with the talent point distribution. I could probably do this at the time of caching, I will look into it. 3) Nice idea, I will consider this.

[Mother_Dee]

Sarosh, the signup is on the calendar once a new event is added and the user "Allows for Signups."

Is that what you're looking for?

[Mother_Dee]

Same issue as previously posted, recurring events do not create separate signups, so I have to manually post every event even if recurring. That is a bit of a PITA (understatement.) Otherwise it seems to be working well and my users like how it works/looks.

[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.

[Ninok]

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.

I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.

[LostPhoenix]

Originally Posted by Ninok

I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.

If they have incorrect info put into the user friend it will give an error, but should just skip them and move on to the next one... I was able to update 200 users with my fix yesterday and the cron has been working fine since.

Are you getting the same error with my hack? Server has gone away?