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.

[Ninok]

Originally Posted by LostPhoenix

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?

Yea, its the same error, lost connection to mysql server. I find this odd as each user is making 1 call. Is there a way you can set it to update just 1 user? Or break it down to that level for testing?

[Mother_Dee]

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

[Mother_Dee]

I've been hung up suddenly with a fatal error and no cron running since the 12th. Before that, character imports were doing fine. See above. Any thoughts?

[Collyn]

I'm getting the same error. *shrugs* I'm not sure what's generating the error since nothing in cron.gwowevents.charinfo.php has changed.

[Eviserator]

I am getting the following error:

gWoWEvents Armory Import 
Fatal error: Cannot use string offset as an array in /data/6/0/97/80/423406/user/431220/htdocs/pandemicfear/forums/includes/cron/cron.gwowevents.charinfo.php on line 64

This seems to have started after PHP was upgraded to version 5.2.5.

[Eviserator]

Originally Posted by Gryphon

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.

Sorry about the code tag, I am new and did not know about them but I corrected my previous message. Anyway, I figure that the issue for this problem listed in my previous email was that the REALM name in the user added field CAN NOT have a plus (+) sign in it:

US|Shattered+Hand|Alliance|Eviserator <======= Faulty Entry

US|Shattered Hand|Alliance|Eviserator <======= Good Entry

[Eviserator]

If you are receiving the following error:

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

I have rewritten the CRON process and it is working fine for me now.

Try replacing ALL of the code in your cron.gwowevents.charinfo.php file with the following:

<?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');
                // Following line provided by LostPhoenix  
	$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' GROUP BY `realmchar` 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(5);
		$character['sheet'] = $x->FetchCharacterSheet();
		sleep(5);
		$character['skills'] = $x->FetchCharacterSkills();

		if ($character['characterInfo']['errCode'] != 'noCharacter')
		{
                   $charinfo_query = "
                   `charurl` = '" . $character['sheet']['characterInfo']['character']['charUrl'] . "',
		   `level` = '" . $character['sheet']['characterInfo']['character']['level'] . "',
	   	   `title` = '" . $character['sheet']['characterInfo']['character']['prefix'] . "',
		   `faction` = '" . $character['sheet']['characterInfo']['character']['faction'] . "',
		   `factionid` = '" . $character['sheet']['characterInfo']['character']['factionId'] . "',
		   `gender` = '" . $character['sheet']['characterInfo']['character']['gender'] . "',
		   `genderid` = '" . $character['sheet']['characterInfo']['character']['genderId'] . "',
		   `race` = '" . $character['sheet']['characterInfo']['character']['race'] . "',
		   `raceid` = '" . $character['sheet']['characterInfo']['character']['raceId'] . "',
		   `class` = '" . $character['sheet']['characterInfo']['character']['class'] . "',
		   `classid` = '" . $character['sheet']['characterInfo']['character']['classId'] . "',
		   `talentspec` = '" . 
                     $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," . 
                     $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," . 
                     $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
		   `talent1` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
		   `talent2` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
		   `talent3` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] . 

"',
		   `guild` = '" . $character['sheet']['characterInfo']['character']['guildName'] . "',
		   `guildurl` = '" . $character['sheet']['characterInfo']['character']['guildUrl'] . "',
		   `hp` = '" . 

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
		   `mp` = '" . 

$character['sheet']['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
		   `str` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
		   `agi` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
		   `sta` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
		   `int` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
		   `spi` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
		   `arm` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['effective'] 

. "',
		   `strbase` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
		   `agibase` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
		   `stabase` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
		   `intbase` = '" . 

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
		   `spibase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['base'] 

. "',
		   `armbase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['base'] 

. "',
		   `prof1` = '" . 

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['name'] . "',
		   `skill1` = '" . 

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'] . "',
		   `prof2` = '" . 

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',
		   `skill2` = '" . 

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',
                   `cooking` = '" . 

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['0']['value']['0'] . "',
                   `firstaid` = '" . 

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['1']['value']['0'] . "',
                   `fishing` = '" . 

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['2']['value']['0'] . "',
                   `riding` = '" . 

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['3']['value']['0'] . "',
		   ";
		   $char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);
		   if ($character['sheet']['characterInfo'] && 

$character['sheet']['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['skills']);
		    echo '<pre><hr />';
		}
		$char_updated .= $char['character'] . ", ";
	}
	echo $char_updated;
?>

[stevewwm]

Getting this error when trying to add an event to the calendar.

Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error  : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Date         : Thursday, March 20th 2008 @ 04:01:35 PM
Script       : http://WEBSITENAME.com/forum/calendar.php?do=getinfo&e=7&day=2008-12-20
Referrer     : http://WEBSITENAME.com/forum/calendar.php?do=add&type=single&c=1
IP Address   : 
Username     : 
Classname    : vB_Database

[LostPhoenix]

If found by grouping by character name you put a lot less stress on the armory. The current SQL Call to get the array of characters that needs to be updated will put the same character in multiple times.

By changing:

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

to:

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

It will only put each character to be updated once, but it will update the info for all events the character is signed up for.

[Gryphon]

@stevewwm You need to update the field id in the options.

@LostPhoenix, @Eviserator I will look in these changes.