/admin/armory_data.php

<?php
/**
 * WoWRoster.net WoWRoster
 *
 * Roster upload rule config
 *
 *
 * @copyright  2002-2011 WoWRoster.net
 * @license    http://www.gnu.org/licenses/gpl.html   Licensed under the GNU General Public License v3.
 * @version    SVN: $Id: armory_data.php 2394 2012-02-15 22:05:03Z ulminia@gmail.com $
 * @link       http://www.wowroster.net
 * @since      File available since Release 1.8.0
 * @package    WoWRoster
 * @subpackage RosterCP
 */

if( !defined('IN_ROSTER') || !defined('IN_ROSTER_ADMIN') )
{
	exit('Detected invalid access to this file!');
}

if (isset($_POST['process']) && $_POST['process'] == 'process')
{
	$count=1;
	//	aprint($_POST);
	$classid = (isset($_POST['class_id']) ? $_POST['class_id'] : $_GET['class']);
	echo '<br>--[ '.$classid.' ]--<br>';
	$talents = $roster->api->Talents->getTalentInfo($classid);
	
	$querystr = "DELETE FROM `" . $roster->db->table('talents_data') . "` WHERE `class_id` = '" . $classid . "';";
	if (!$roster->db->query($querystr))
	{
		$roster->set_message('Talent Data Table could not be emptied.', '', 'error');
		$roster->set_message('<pre>' . $roster->db->error() . '</pre>', 'MySQL Said', 'error');
		return;
	}

	$querystr = "DELETE FROM `" . $roster->db->table('talenttree_data') . "` WHERE `class_id` = '" . $classid . "';";
	if (!$roster->db->query($querystr))
	{
		$roster->set_message('Talent Tree Data Table could not be emptied.', '', 'error');
		$roster->set_message('<pre>' . $roster->db->error() . '</pre>', 'MySQL Said', 'error');
		return;
	}
	//talent_mastery
	$querystr = "DELETE FROM `" . $roster->db->table('talent_mastery') . "` WHERE `class_id` = '" . $classid . "';";
	if (!$roster->db->query($querystr))
	{
		$roster->set_message('Talent Tree Data Table could not be emptied.', '', 'error');
		$roster->set_message('<pre>' . $roster->db->error() . '</pre>', 'MySQL Said', 'error');
		return;
	}
	$treenum = 1;

	foreach ($talents['talentData']['talentTrees'] as $a => $treedata)
	{

		foreach ($treedata['talents'] as $t => $talent)
		{
			$lvl = 1;
			foreach ($talent['ranks'] as $r => $ranks)
			{
				$values = array(
					'talent_id'  => $talent['id'],
					'talent_num' => $t,
					'tree_order' => $treenum,
					'class_id'   => $classid,
					'name'       => $talent['name'],
					'tree'       => $treedata['name'],
					'tooltip'    => tooltip($ranks['description']),
					'texture'    => $talent['icon'],
					'isspell'	 => ( !$talent['keyAbility'] ? false : true ),
					'row'        => ($talent['y'] + 1),
					'column'     => ($talent['x'] + 1),
					'rank'       => $lvl
				);
				$lvl++;
				
				$querystr = "INSERT INTO `" . $roster->db->table('talents_data') . "` "
					. $roster->db->build_query('INSERT', $values) . ";";
				$result = $roster->db->query($querystr);
				$count++;
			}
		}
		$role = '';
		foreach ($treedata['roles'] as $name => $h)
		{
			if ($h == 1)
			{
				$role = $name;
			}
		}
		$values = array(
			'tree'       => $treedata['name'],
			'order'      => $treenum,
			'class_id'   => $classid,
			'background' => strtolower($treedata['backgroundFile']),
			'icon'       => $treedata['icon'],
			'roles'		 => $role,
			'desc'		 => $treedata['description'],
			'tree_num'   => $treenum
		);
		$masterys = array(
			'class_id'	=>	$classid,
			'tree'		=>	$treedata['name'],
			'tree_num'	=>	$treenum,
			'icon'		=>	$treedata['masteries'][0]['icon'],
			'name'		=>	$treedata['masteries'][0]['name'],
			'desc'		=>	$treedata['masteries'][0]['description'],
			'spell_id'	=>	$treedata['masteries'][0]['spellId']
		);

		$mquerystr = "INSERT INTO `" . $roster->db->table('talent_mastery') . "` "
			. $roster->db->build_query('INSERT', $masterys) . "
			;";
		$mresult = $roster->db->query($mquerystr);
			
		$querystr = "INSERT INTO `" . $roster->db->table('talenttree_data') . "` "
			. $roster->db->build_query('INSERT', $values) . "
			;";
			$result = $roster->db->query($querystr);

		$count++;
		$treenum++;
	}


	$roster->set_message(sprintf($roster->locale->act['adata_update_class'], $roster->locale->act['id_to_class'][$classid]));
	$roster->set_message(sprintf($roster->locale->act['adata_update_row'], $count));
}
if (isset($_GET['parse']) && $_GET['parse'] == 'all'){

	$classes = array('1','2','3','4','5','6','7','8','9','11','0');
	
	foreach ($classes as $tid)
	{
	//$tid = $_GET['classid'];
	$i = $tid;
	$talents = $roster->api->Talents->getTalentInfo(''.$tid.'');
	
	$querystr = "DELETE FROM `" . $roster->db->table('talents_data') . "` WHERE `class_id` = '" . $tid . "';";
	if (!$roster->db->query($querystr))
	{
		$roster->set_message('Talent Data Table could not be emptied.', '', 'error');
		$roster->set_message('<pre>' . $roster->db->error() . '</pre>', 'MySQL Said', 'error');
		return;
	}

	$querystr = "DELETE FROM `" . $roster->db->table('talenttree_data') . "` WHERE `class_id` = '" . $tid . "';";
	if (!$roster->db->query($querystr))
	{
		$roster->set_message('Talent Tree Data Table could not be emptied.', '', 'error');
		$roster->set_message('<pre>' . $roster->db->error() . '</pre>', 'MySQL Said', 'error');
		return;
	}

	$count = 1;
	$treenum = 1;
//$i=$tid;
	foreach ($talents['talentData']['talentTrees'] as $a => $treedata)
	{
		

		foreach ($treedata['talents'] as $t => $talent)
		{
			$lvl = 1;
			foreach ($talent['ranks'] as $r => $ranks)
			{
				$values = array(
					'talent_id'  => $talent['id'],
					'talent_num' => $t,
					'tree_order' => $treenum,
					'class_id'   => $i,
					'name'       => $talent['name'],
					'tree'       => $treedata['name'],
					'tooltip'    => tooltip($ranks['description']),
					'texture'    => $talent['icon'],
					'row'        => ($talent['y'] + 1),
					'column'     => ($talent['x'] + 1),
					'rank'       => $lvl
				);
				$lvl++;
				
				$querystr = "INSERT INTO `" . $roster->db->table('talents_data') . "` "
					. $roster->db->build_query('INSERT', $values) . ";";
				$result = $roster->db->query($querystr);
				$count++;
			}
		}

		$values = array(
			'tree'       => $treedata['name'],
			'order'      => $treenum,
			'class_id'   => $i,
			'background' => strtolower($treedata['backgroundFile']),
			'icon'       => $treedata['icon'],
			'tree_num'   => $treenum
		);

		$querystr = "INSERT INTO `" . $roster->db->table('talenttree_data') . "` "
			. $roster->db->build_query('INSERT', $values) . "
			;";
			$result = $roster->db->query($querystr);

		$count++;
		$treenum++;
	}


	$roster->set_message(sprintf($roster->locale->act['adata_update_class'], $roster->locale->act['id_to_class'][$_POST['class_id']]));
	$roster->set_message(sprintf($roster->locale->act['adata_update_row'], $count));
	}
}
//echo 'will have update information for talents';
$array1 = $roster->locale->act['class_to_id'];
$array2 = array('Pets' => 0);
$classes = array_merge($array1, $array2);


foreach ($classes as $class => $num)
{
	$querystra = $classr = $resulta = 0;
	$querystra = "SELECT * FROM `" . $roster->db->table('talents_data') . "` WHERE `class_id` = '" . $num . "';";
	$resulta = $roster->db->query($querystra);
	$classr = $roster->db->num_rows($resulta);
	$i = 0;

	$roster->tpl->assign_block_vars('classes', array(
		'NAME'       => $class,
		'ID'         => $num,
		'UPDATELINK' => makelink('&amp;class=' . $num),
		'ROWS'       => $classr,
		'ROW'        => (($i % 2) + 1)
		)
	);
}

	$queryx = "SELECT * FROM `" . $roster->db->table('api_usage') . "` ORDER BY `date` DESC LIMIT 0,150;";
	$resultx = $roster->db->query($queryx);
	$usage = array();
	while ($row = $roster->db->fetch($resultx))
	{
		$usage[$row['date']][$row['type']]['total']=$row['total'];
	}

	
	foreach($usage as $date => $x)
	{
		$roster->tpl->assign_block_vars('apiusage', array(
				'DATE'	=> $date
			)
		);
		foreach($x as $type => $d)
		{
			$roster->tpl->assign_block_vars('apiusage.type', array(
					'TYPE'       => $type,
					'REQ'         => $d['total'],
					'PERCENT'       => ($d['total']/3000*100).'% (Based on daily limit of 3000 with no API key)',
					'ROW_CLASS'        => (($i % 2) + 1)
				)
			);
		}
	}
	
$roster->tpl->set_filenames(array('body' => 'admin/armory_data.html'));
$body = $roster->tpl->fetch('body');



/**
 * Format tooltips for insertion to the db
 *
 * @param mixed $tipdata
 * @return string
 */
function tooltip( $tipdata )
{
	$tooltip = '';

	if( is_array($tipdata) )
	{
		$tooltip = implode("\n",$tipdata);
	}
	else
	{
		$tooltip = str_replace('<br>',"\n",$tipdata);
	}
	return $tooltip;
}