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:
Code:
<?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;
?>