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.

[Tazz_1962]

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.

Unfortunately wow armory and your website are not talking the same language. I had this issue with our guild name and with some of our member names. I posted how I fixed it for the guild name earlier. If you have your users with the non traditional lettering have them copy and paste the name as they are shown in gwowroster. Merlé instead of Merl? into there userCP where they list their chars US/EU|server|faction|Merlé the system will work for them and pull their stats.

[ColossusCH]

Hi Gryphon, hi Tazz 1962

Thank you for your reply.
i will try your solution

[Dsru123]

Originally Posted by Mother_Dee

Same issue. Previously posted fix by another user gave me an error on another line, reverted file and back to the issue with line 50. Still hoping for a fix. <3

Same issue. I am trying to figure it out when it statred, I think with Version 3.7.1
PL2........... 6/19/08 is when I updated and anybody after that shows "Awaiting Armory Import".

Going to try and revert and see if its it.

EDIT*****
was a shot, reverted all the way back to 3.7.1 and still same error, back at PL2.

EDIT 2 *****
Host upgraded to PHP 5.2.6 and I believe that is where it puked. Still trying.

[Dsru123]

now getting data from the armory, almost all of it, no more error.

but, the root of the problem is that it is incorrectly accessing the parsed XML data. I commented out the problem lines and its "working" now, but the profession name and skill level information will not be present. I tried fetching the XML data my self so I could see where the problem was and fix the fetch, but any way I try to fetch the XML data it comes back as a HTML page instead of an XML blob, so I'm not sure what other special stuff it is doing to fetch the raw data instead of the pretty html version.

Maybe another mind can fix this part and we will be good to go?

<?php
	// ########################################################################
	//
	// gWoWEvents, Copyright ? 2006, Ryan Snook (www.gryphonllc.com )
	//
	// If you have fixes, improvements or other additions to make to
	// gWoWEvents, please contact me at rsnook@gmail.com for collaboration.
	// I appreciate your kind consideration.
	//
	// This work is licensed under the Creative Commons
	// Attribution-Noncommercial-No Derivative Works 3.0 United States License.
	// To view a copy of this license, visit
	// http://creativecommons.org/licenses/by-nc-nd/3.0/us/ or send a letter to
	// Creative Commons, 171 Second Street, Suite 300,
	// San Francisco, California, 94105, USA.
	//
	// ########################### SVN info ###################################
	// $Id: cron.gwowevents.charinfo.php 830 2008-01-23 20:18:51Z gryphon $
	// $Rev: 830 $
	// $LastChangedBy: gryphon $
	// $Date: 2008-01-23 12:18:51 -0800 (Wed, 23 Jan 2008) $

	// ######################## SET PHP ENVIRONMENT ###########################
	error_reporting(E_ALL & ~E_NOTICE);
	if (!is_object($vbulletin->db))
	{
		exit;
	}

	// ########################## REQUIRE BACK-END ############################
	require_once('./includes/functions_gwowevents.php');

	$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' ORDER BY `armorydata` ASC");

	while ($char = $vbulletin->db->fetch_array($res))
	{
		require_once('./includes/class_gwowarmory.php');
		$x = new gWoWArmory;
		$x->SetLocale($char['locale']);
		$x->SetRealmName($char['realm']);
		$x->SetCharName($char['character']);

		sleep(10);
		$character = $x->FetchCharacterSheet();
		sleep(10);
		$character_skills = $x->FetchCharacterSkills();

		if ($character != false)
		{
      /*
			if ($character['characterInfo']['characterTab']['professions']['skill']['0'])
			{
				$character['prof1'] = $character['characterInfo']['characterTab']['professions']['skill']['0']['name'];
				$character['skill1'] = $character['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'];
			}
			else
			{
				$character['prof1'] = $character['characterInfo']['characterTab']['professions']['skill']['name'];
				$character['skill1'] = $character['characterInfo']['characterTab']['professions']['skill']['value']['0'];
			}
       */

      /*
			$secondaryskill = array();
			foreach($character_skills['characterInfo']['skillTab']['skillCategory']['1']['skill'] as $skill)
			{
				$secondaryskill[$skill['key']] = $skill['value']['0'];
			}
       */

			$charinfo_query = "
				`charurl` = '" . $character['characterInfo']['character']['charUrl'] . "',
				`level` = '" . $character['characterInfo']['character']['level'] . "',
				`title` = '" . $character['characterInfo']['character']['title'] . "',
				`faction` = '" . $character['characterInfo']['character']['faction'] . "',
				`factionid` = '" . $character['characterInfo']['character']['factionId'] . "',
				`gender` = '" . $character['characterInfo']['character']['gender'] . "',
				`genderid` = '" . $character['characterInfo']['character']['genderId'] . "',
				`race` = '" . $character['characterInfo']['character']['race'] . "',
				`raceid` = '" . $character['characterInfo']['character']['raceId'] . "',
				`class` = '" . $character['characterInfo']['character']['class'] . "',
				`classid` = '" . $character['characterInfo']['character']['classId'] . "',
				`talentspec` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," . $character['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," . $character['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
				`talent1` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
				`talent2` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
				`talent3` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
				`guild` = '" . $character['characterInfo']['character']['guildName'] . "',
				`guildurl` = '" . $character['characterInfo']['character']['guildUrl'] . "',
				`hp` = '" . $character['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
				`mp` = '" . $character['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
				`str` = '" . $character['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
				`agi` = '" . $character['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
				`sta` = '" . $character['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
				`int` = '" . $character['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
				`spi` = '" . $character['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
				`arm` = '" . $character['characterInfo']['characterTab']['baseStats']['armor']['effective'] . "',
				`strbase` = '" . $character['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
				`agibase` = '" . $character['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
				`stabase` = '" . $character['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
				`intbase` = '" . $character['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
				`spibase` = '" . $character['characterInfo']['characterTab']['baseStats']['spirit']['base'] . "',
				`armbase` = '" . $character['characterInfo']['characterTab']['baseStats']['armor']['base'] . "',
				`prof1` = '" . $character['prof1'] . "',
				`skill1` = '" . $character['skill1'] . "',
       " 
       /* There seems to be something wrong with the $character structure that is supposed to 
        * fill in all of this info */
				. "`prof2` = '" . $character['prof2']. "',"
				. "`skill2` = '" . $character['skill2']. "',"
       /*
				. "`prof2` = '" . $character['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',"
				. "`skill2` = '" . $character['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',"
        */

       ." 
				`cooking` = '" . $secondaryskill['cooking'] . "',
				`firstaid` = '" . $secondaryskill['firstaid'] . "',
				`fishing` = '" . $secondaryskill['fishing'] . "',
				`riding` = '" .$secondaryskill['riding'] . "',
			";

			$char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);

			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'] . "'");
			}
		}

		if (VB_AREA == 'AdminCP')
		{
			echo $char['character'] . '<pre>';
			print_r($character);
			print_r($character_skills);
			echo '<pre><hr />';
		}

		$char_updated .= $char['character'] . ", ";

	}

	echo $char_updated;
?>

[LostPhoenix]

Originally Posted by Gryphon

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

Gryphon have you tired rawurlencode instead of urlencode to fix the problem with accented characters?

[KURTZ]

ok now i understand how it works ...

however, gryphon, i use EU|Crushridge but after 10 mins i haven't imported the char data into my event ... it's normal?

[Sanctorum]

lately since the recent updates, the character data is not being imported into the events.

I did upgrade to php-5.2.6, I'm wondering if it's the same issue as stated above.

*Edit*

Found the problem, it was cURL, it wasn't compiled in when I upgraded PHP.

[Renny]

The icons you get with it. What are they for and how do i use them? like how do i make the icon the url on the calender page Like how this website has:

Furthermore, do you know how you can make a module in vbadvanced like the 2nd image? to show upcoming events like it has done?

[Sedition-Guild]

I uploaded this for our guild website, followed all the instructions, when I went to add a test event to our calender I got the following error:

Warning: require_once(./includes/functions_gwowevents.php) [function.require-once]: failed to open stream: No such file or directory in [path]/calendar.php(1218) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_gwowevents.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/wrecl/public_html/forums/calendar.php(1218) : eval()'d code on line 1

Help?
Thanks!

[Kinneas]

Originally Posted by Sedition-Guild

I uploaded this for our guild website, followed all the instructions, when I went to add a test event to our calender I got the following error:

Warning: require_once(./includes/functions_gwowevents.php) [function.require-once]: failed to open stream: No such file or directory in [path]/calendar.php(1218) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_gwowevents.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/wrecl/public_html/forums/calendar.php(1218) : eval()'d code on line 1

Help?
Thanks!

Did you upload all the files to the correct place? That error indicates it can't find /includes/functions_gwowevents.php