<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: xmlparse.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

// XML parsing by Swipe
// http://wowroster.net

if ( !defined('ROSTER_INSTALLED') )
{
    exit('Detected invalid access to this file!');
}

class xmlParser
{
	var $xml_obj = null;
	var $output = array();
	var $message;

	function xmlParser()
	{
		$this->xml_obj = xml_parser_create('');

		xml_set_object( $this->xml_obj, $this );
		xml_set_character_data_handler( $this->xml_obj, 'dataHandler' );
		xml_set_element_handler( $this->xml_obj, 'startHandler', 'endHandler' );
	}

	function parse( $path )
	{
		if (function_exists('curl_init'))
		{
			$fp = curl_init( $path );
			$ch = 1;
		}
		else
		{
			$fp = @fopen( $path, 'r' );
			$ch = 0;
		}

		if ( !$fp )
		{
			$this->message = "Cannot open XML data file: $path";
			return false;
		}

		if ( !$ch )
		{
			while ( $data = fread( $fp, 4096 ) )
			{
				if ( !xml_parse( $this->xml_obj, $data, feof( $fp ) ) )
				{
					$this->message = sprintf( "XML error: %s at line %d",
					xml_error_string( xml_get_error_code( $this->xml_obj ) ),
					xml_get_current_line_number( $this->xml_obj ) );

					xml_parser_free( $this->xml_obj );
					return false;
				}
			}
		}
		else
		{
			curl_setopt($fp, CURLOPT_HEADER, 0);
			curl_setopt($fp, CURLOPT_RETURNTRANSFER, 1);
			$data = curl_exec($fp);
			if ( curl_errno($fp) )
			{
				$ch_err = 1;
			}
			else
			{
				$ch_err = 0;
			}

			curl_close($fp);

			if( !xml_parse( $this->xml_obj, $data, $ch_err ) )
			{
					$this->message = sprintf( "XML error: %s at line %d",
					xml_error_string( xml_get_error_code( $this->xml_obj ) ),
					xml_get_current_line_number( $this->xml_obj ) );

					xml_parser_free( $this->xml_obj );
					return false;
			}
		}
		return true;
	}

	function startHandler( $parser, $name, $attribs )
	{
		$_content = array( 'name' => $name );
		if ( !empty( $attribs ) )
			$_content['attrs'] = $attribs;
		array_push( $this->output, $_content );
	}

	function dataHandler( $parser, $data )
	{
		if( !empty( $data ) )
		{
			$_output_idx = count( $this->output );
			$this->output[$_output_idx - 1]['content'] = $data;
		}
	}

	function endHandler( $parser, $name )
	{
		if ( count( $this->output ) > 1 )
		{
			$_data = array_pop( $this->output );
			$_output_idx = count( $this->output );
			$this->output[$_output_idx - 1]['child'][] = $_data;
		}
	}
}
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: wowdb.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

class wowdb
{
	var $db;			// Database resource id
	var $assignstr;		// Data to be inserted/updated to the db
	var $sqldebug;		//
	var $sqlstrings;	// Array of SQL strings passed to query()
	var $messages;		// Array of stored messages
	var $errors;		// Array of stored error messages
	var $membersadded=0;
	var $membersupdated=0;
	var $membersremoved=0;


	/**
	 * Connect to the database, and select it if $name is provided
	 *
	 * @param string $host MySQL server host name
	 * @param string $user MySQL server user name
	 * @param string $password MySQL server user password
	 * @param string $name MySQL server database name to select
	 * @return bool
	 */
	function connect( $host, $user, $password, $name=null )
	{
		$this->db = @mysql_connect($host, $user, $password);

		if( $this->db )
		{
			if ( !is_null($name) )
			{
				$db_selected = @mysql_select_db( $name,$this->db );
				if( $db_selected )
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			else
			{
				return true;
			}
		}
		else
		{
			return false;
		}
	}


	/**
	 * Front-end for SQL_query
	 *
	 * @param string $querystr
	 * @return mixed $result handle
	 */
	function query( $querystr )
	{
		$this->sqlstrings[] = $querystr;

		$result = @mysql_query($querystr,$this->db);
		return $result;
	}


	/**
	 * Get last SQL error
	 *
	 * @return string last SQL error
	 */
	function error()
	{
		$result = @mysql_errno().': '.mysql_error();
		return $result;
	}


	/**
	 * Front-end for SQL_fetch_assoc
	 *
	 * @param int $result handle
	 * @return array current db row
	 */
	function getrow( $result )
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return mysql_fetch_assoc( $result );
	}


	/**
	 * Front-end for SQL_fetch_assoc
	 *
	 * @param int $result handle
	 * @return array current db row
	 */
	function fetch_assoc( $result )
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return mysql_fetch_assoc( $result );
	}


	/**
	 * Front-end for SQL_fetch_array
	 *
	 * @param int $result handle
	 * @return array current db row
	 */
	function fetch_array( $result )
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return mysql_fetch_array( $result );
	}


	/**
	 * Front-end for SQL_fetch_row
	 *
	 * @param int $result handle
	 * @return array current db row
	 */
	function fetch_row( $result )
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return mysql_fetch_row( $result );
	}


	/**
	 * Front-end for SQL_num_rows
	 *
	 * @param int $result handle
	 * @return array current db row
	 */
	function num_rows( $result )
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return mysql_num_rows( $result );
	}


	/**
	 * Front-end to escape string for safe inserting
	 *
	 * @param string $string
	 * @return string escaped
	 */
	function escape( $string )
	{
		if( version_compare( phpversion(), '4.3.0', '>' ) )
			return mysql_real_escape_string( $string );
		else
			return mysql_escape_string( $string );
	}


	/**
	 * Closes the DB connection
	 *
	 * @return unknown
	 */
	function closeDb()
	{
		// Closing connection
		if( is_resource($this->db) )
			return @mysql_close($this->db);
	}


	/**
	 * Frees SQL result memory
	 *
	 * @param int $query_id handle
	 */
	function closeQuery($query_id)
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$query_id && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		// Free resultset
		return @mysql_free_result($query_id);
	}


	/**
	 * Frees SQL result memory
	 *
	 * @param int $query_id handle
	 */
	function free_result($query_id)
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$query_id && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		// Free resultset
		return @mysql_free_result($query_id);
	}


	/**
	 * Returns number of rows affected by an INSERT, UPDATE, or DELETE operation
	 *
	 * @param int $query_id handle
	 */
	function affected_rows()
	{
		return @mysql_affected_rows($this->db);
	}


	/**
	 * Move result pointer
	 *
	 * @param int $result handle
	 * @param int $num row number
	 * @return bool
	 */
	function data_seek($result,$num)
	{
		global $roster_conf;

		// die quietly if debugging is on and we've got an invalid result. The page may
		// render correctly with just an error printed, so if debugging is off we don't die.
		if (!$result && $roster_conf['debug_mode'])
		{
			die_quietly('Invalid query result passed','Roster DB Layer');
		}

		return @mysql_data_seek($result, $num);
	}


	/**
	 * Get the ID generated from the previous INSERT operation
	 *
	 * @return int
	 */
	function insert_id()
	{
		return @mysql_insert_id($this->db);
	}


	/**
	 * Sets the SQL Debug output flag
	 *
	 * @param bool $sqldebug
	 */
	function setSQLDebug($sqldebug)
	{
		$this->sqldebug = $sqldebug;
	}


	/**
	 * Returns all messages
	 *
	 * @return string
	 */
	function getSQLStrings()
	{
		$sqlstrings = $this->sqlstrings;
		$output = '';
		if( is_array($sqlstrings) )
		{
			foreach($sqlstrings as $sql)
			{
				$output .= "$sql\n";
			}
		}
		return $output;
	}


	/**
	 * Adds a message to the $messages array
	 *
	 * @param string $message
	 */
	function setMessage($message)
	{
		$this->messages[] = $message;
	}


	/**
	 * Returns all messages
	 *
	 * @return string
	 */
	function getMessages()
	{
		$messages = $this->messages;
		$output = '';
		if( is_array($messages) )
		{
			foreach($messages as $message)
			{
				$output .= "$message\n";
			}
		}
		return $output;
	}


	/**
	 * Resets the stored messages
	 *
	 */
	function resetMessages()
	{
		$this->messages = null;
	}


	/**
	 * Adds an error to the $errors array
	 *
	 * @param string $message
	 */
	function setError($message,$error)
	{
		$this->errors[] = array($message=>$error);
	}


	/**
	 * Gets the errors in wowdb
	 * Return is based on $mode
	 *
	 * @param string $mode
	 * @return mixed
	 */
	function getErrors( $mode='' )
	{
		if( $mode == 'a')
		{
			return $this->errors;
		}

		$output = '';

		$errors = $this->errors;
		if( is_array($errors) )
		{
			$output = '<table width="100%" class="bodyline" cellspacing="0">';
			$steps = 0;
			foreach($errors as $errorArray)
			{
				foreach ($errorArray as $message => $error)
				{
					if ( $steps == 1 )
						$steps = 2;
					else
						$steps = 1;

					$output .= "<tr><td class=\"membersRowRight$steps\">$message<br />\n".
						"$error</td></tr>\n";
				}
			}
			$output .= '</table>';
		}
		return $output;
	}


	/**
	 * Expand base table name to a full table name
	 *
	 * @param string $table the base table name
	 * @param string $addon the name of the addon, empty for a base roster table
	 * @param string $profile the name of the addon's config profile.
	 * @return string tablename as fit for MySQL queries
	 */
	function table($table, $addon='', $profile='')
	{
		global $db_prefix;

		if ($addon)
			return $db_prefix.'addons_'.$addon.'_'.$profile.'_'.$table;
		else
			return $db_prefix.$table;
	}


/************************
 * Updating Code
************************/


	/**
	 * Resets the SQL insert/update string holder
	 *
	 */
	function reset_values()
	{
		$this->assignstr = '';
	}


	/**
	 * Add a value to an INSERT or UPDATE SQL string
	 *
	 * @param string $row_name
	 * @param string $row_data
	 */
	function add_value( $row_name, $row_data )
	{
		if( $this->assignstr != '' )
			$this->assignstr .= ',';

		$row_data = "'" . $this->escape( $row_data ) . "'";

		$this->assignstr .= " `$row_name` = $row_data";
	}


	/**
	 * Add a time value to an INSERT or UPDATE SQL string
	 *
	 * @param string $row_name
	 * @param array $date
	 */
	function add_time( $row_name, $date )
	{
		if( $this->assignstr != '' )
			$this->assignstr .= ',';

		// 01/01/2000 23:00:00.000
		$row_data = "'".$date['year'].'-'.$date['mon'].'-'.$date['mday'].' '.$date['hours'].':'.$date['minutes'].':00'."'";
		$this->assignstr .= " `$row_name` = $row_data";
	}


	/**
	 * Add a time value to an INSERT or UPDATE SQL string for PVP table
	 *
	 * @param string $row_name
	 * @param string $date
	 */
	function add_pvp2time( $row_name, $date )
	{
		if( $this->assignstr != '' )
			$this->assignstr .= ',';

		$date_str = strtotime($date);
		$p2newdate = date('Y-m-d G:i:s',$date_str);
		$row_data = "'".$p2newdate."'";
		$this->assignstr .= " `$row_name` = $row_data";
	}


	/**
	 * Format tooltips for insertion to the db
	 *
	 * @param mixed $tipdata
	 * @return string
	 */
	function tooltip( $tipdata )
	{
		$tooltip = '';

		if( is_array( $tipdata ) )
		{
			$first=true;
			foreach( $tipdata as $tip )
			{
				if( $first )
				{
					$tooltip .= "$tip";
					$first=false;
				}
				else
				{
					$tooltip .= "\n$tip";
				}
			}
		}
		else
		{
			$tooltip = str_replace('<br>',"\n",$tipdata);;
		}
		return $tooltip;
	}


	/**
	 * Inserts an item into the datbase
	 *
	 * @param string $item
	 * @return bool
	 */
	function insert_item( $item,$locale )
	{
		global $wordings;

		$this->reset_values();
		$this->add_value('member_id', $item['member_id'] );
		$this->add_value('item_name', $item['item_name'] );
		$this->add_value('item_parent', $item['item_parent'] );
		$this->add_value('item_slot', $item['item_slot'] );
		$this->add_value('item_color', $item['item_color'] );
		$this->add_value('item_id', $item['item_id'] );
		$this->add_value('item_texture', $item['item_texture'] );
		$this->add_value('item_tooltip', $item['item_tooltip'] );

		if( preg_match($wordings[$locale]['requires_level'],$item['item_tooltip'],$level))
			$this->add_value('level',$level[1]);

		$this->add_value('item_quantity', $item['item_quantity'] );

		$querystr = "INSERT INTO `".ROSTER_ITEMSTABLE."` SET ".$this->assignstr;
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Item ['.$item['item_name'].'] could not be inserted',$this->error());
		}
	}


	/**
	 * Inserts mail into the Database
	 *
	 * @param array $mail
	 */
	function insert_mail( $mail )
	{
		$this->reset_values();
		$this->add_value('member_id', $mail['member_id'] );
		$this->add_value('mailbox_slot', $mail['mail_slot'] );
		$this->add_value('mailbox_coin', $mail['mail_coin'] );
		$this->add_value('mailbox_coin_icon', $mail['mail_coin_icon'] );
		$this->add_value('mailbox_days', $mail['mail_days'] );
		$this->add_value('mailbox_sender', $mail['mail_sender'] );
		$this->add_value('mailbox_subject', $mail['mail_subject'] );
		$this->add_value('item_icon', $mail['item_icon'] );
		$this->add_value('item_name', $mail['item_name'] );
		$this->add_value('item_tooltip', $mail['item_tooltip'] );
		$this->add_value('item_color', $mail['item_color'] );

		if( isset( $mail['item_quantity'] ) )
			$this->add_value('item_quantity', $mail['item_quantity'] );

		$querystr = "INSERT INTO `".ROSTER_MAILBOXTABLE."` SET ".$this->assignstr;
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Mail ['.$mail['mail_subject'].'] could not be inserted',$this->error());
		}
	}


	/**
	 * Inserts a quest into the Databse
	 *
	 * @param array $quest
	 */
	function insert_quest( $quest )
	{
		$this->reset_values();
		$this->add_value('member_id', $quest['member_id'] );
		$this->add_value('quest_name', $quest['quest_name'] );
		$this->add_value('quest_index', $quest['quest_index'] );
		$this->add_value('quest_level', $quest['quest_level'] );
		$this->add_value('zone', $quest['zone'] );
		$this->add_value('quest_tag', $quest['quest_tag'] );
		$this->add_value('is_complete', $quest['is_complete'] );

		$querystr = "INSERT INTO `".ROSTER_QUESTSTABLE."` SET ".$this->assignstr;
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Quest ['.$quest['quest_name'].'] could not be inserted',$this->error());
		}
	}


	/**
	 * Inserts a recipe into the Database
	 *
	 * @param array $recipe
	 * @param string $locale
	 */
	function insert_recipe( $recipe,$locale )
	{
		global $wordings;

		$this->reset_values();
		$this->add_value('member_id', $recipe['member_id'] );
		$this->add_value('recipe_name', $recipe['recipe_name'] );
		$this->add_value('recipe_type', $recipe['recipe_type'] );
		$this->add_value('skill_name', $recipe['skill_name'] );
		$this->add_value('difficulty', $recipe['difficulty'] );
		$this->add_value('item_color', $recipe['item_color'] );
		$this->add_value('reagents', $recipe['reagents'] );
		$this->add_value('recipe_texture', $recipe['recipe_texture'] );

		$this->add_value('recipe_tooltip', $recipe['recipe_tooltip'] );

		if( preg_match($wordings[$locale]['requires_level'],$recipe['recipe_tooltip'],$level))
			$this->add_value('level',$level[1]);

		$querystr = "INSERT INTO `".ROSTER_RECIPESTABLE."` SET ".$this->assignstr;
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Recipe ['.$recipe['recipe_name'].'] could not be inserted',$this->error());
		}
	}


	/**
	 * Update Memberlog function
	 *
	 */
	function updateMemberlog( $data , $type )
	{
		$this->reset_values();
		$this->add_value('member_id', $data['member_id'] );
		$this->add_value('name', $data['name'] );
		$this->add_value('guild_id', $data['guild_id'] );
		$this->add_value('class', $data['class'] );
		$this->add_value('level', $data['level'] );
		$this->add_value('note', $data['note'] );
		$this->add_value('guild_rank', $data['guild_rank'] );
		$this->add_value('guild_title', $data['guild_title'] );
		$this->add_value('officer_note', $data['officer_note'] );
		$this->add_value('update_time', $data['update_time'] );
		$this->add_value('type', $type );

		$querystr = "INSERT INTO `".ROSTER_MEMBERLOGTABLE."` SET ".$this->assignstr;
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Member Log ['.$data['name'].'] could not be inserted',$this->error());
		}
	}


	/**
	 * Formats quest data to be inserted to the db
	 *
	 * @param array $quest_data
	 * @param int $memberId
	 * @param string $zone
	 * @return array
	 */
	function make_quest( $quest_data, $memberId, $zone, $slot )
	{
		$quest = array();
		$quest['member_id'] = $memberId;

		//Fix quest name if too many 'quest' addons cause level number to be added to title
		while(substr($quest['quest_name'],0,1) == '[')
		{
			$quest['quest_name'] = ltrim(substr($quest['quest_name'],strpos($quest['quest_name'],']')+1));
		}
		$quest['quest_tag'] = $quest_data['Tag'];
		$quest['quest_index'] = $slot;
		$quest['quest_level'] = $quest_data['Level'];
		$quest['zone'] = $zone;

		if( isset($quest_data['Complete']) )
			$quest['is_complete'] = $quest_data['Complete'];
		else
			$quest['is_complete'] = 0;

		return $quest;
	}


	/**
	 * Formats mail data to be inserted to the db
	 *
	 * @param array $mail_data
	 * @param int $memberId
	 * @param string $slot_num
	 * @return array
	 */
	function make_mail( $mail_data, $memberId, $slot_num )
	{
		$mail = array();
		$mail['member_id'] = $memberId;
		$mail['mail_slot'] = $slot_num;
		$mail['mail_coin'] = $mail_data['Coin'];
		$mail['mail_coin_icon'] = 'Interface/Icons/'.$mail_data['CoinIcon'];
		$mail['mail_days'] = $mail_data['Days'];
		$mail['mail_sender'] = $mail_data['Sender'];
		$mail['mail_subject'] = $mail_data['Subject'];

		if( isset($mail_data['Item']) )
		{
			$item = $mail_data['Item'];

			$mail['item_icon'] = 'Interface/Icons/'.$item['Icon'];
			$mail['item_name'] = $item['Name'];
			$mail['item_color'] = $item['Color'];

			if( isset( $item['Quantity'] ) )
				$mail['item_quantity'] = $item['Quantity'];
			else
				$item['item_quantity'] = 1;

			if( !empty($item['Tooltip']) )
				$mail['item_tooltip'] = $this->tooltip( $item['Tooltip'] );
			else
				$mail['item_tooltip'] = $item['Name'];
		}
		return $mail;
	}


	/**
	 * Formats item data to be inserted into the db
	 *
	 * @param array $item_data
	 * @param int $memberId
	 * @param string $parent
	 * @param string $slot_name
	 * @return array
	 */
	function make_item( $item_data, $memberId, $parent, $slot_name )
	{
		$item = array();
		$item['member_id'] = $memberId;
		$item['item_name'] = $item_data['Name'];
		$item['item_parent'] = $parent;
		$item['item_slot'] = $slot_name;
		$item['item_color'] = $item_data['Color'];
		$item['item_id'] = $item_data['Item'];
		$item['item_texture'] = 'Interface/Icons/'.$item_data['Icon'];

		if( isset( $item_data['Quantity'] ) )
			$item['item_quantity'] = $item_data['Quantity'];
		else
			$item['item_quantity'] = 1;

		if( !empty($item_data['Tooltip']) )
			$item['item_tooltip'] = $this->tooltip( $item_data['Tooltip'] );
		else
			$item['item_tooltip'] = $item_data['Name'];

		return $item;
	}


	/**
	 * Formats recipe data to be inserted into the db
	 *
	 * @param array $recipe_data
	 * @param int $memberId
	 * @param string $parent
	 * @param string $recipe_type
	 * @param string $recipe_name
	 * @return array
	 */
	function make_recipe( $recipe_data, $memberId, $parent, $recipe_type, $recipe_name )
	{
		$recipe = array();
		$recipe['member_id'] = $memberId;
		$recipe['recipe_name'] = $recipe_name;
		$recipe['recipe_type'] = $recipe_type;
		$recipe['skill_name'] = $parent;
		$recipe['difficulty'] = $recipe_data['Difficulty'];
		$recipe['item_color'] = $recipe_data['Color'];

		$recipe['reagents'] = '';
		foreach( $recipe_data['Reagents'] as $reagent )
		{
			$recipe['reagents'] .= $reagent['Name'].' [x'.$reagent['Count'].']<br>';
		}
		$recipe['reagents'] = substr($recipe['reagents'],0,-4);

		$recipe['recipe_texture'] = 'Interface/Icons/'.$recipe_data['Icon'];

		if( !empty($recipe_data['Tooltip']) )
			$recipe['recipe_tooltip'] = $this->tooltip( $recipe_data['Tooltip'] );
		else
			$recipe['recipe_tooltip'] = $recipe_name;

		return $recipe;
	}


	/**
	 * Handles formating and insertion of buff data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_buffs( $data, $memberId )
	{
		$buffs = $data['Attributes']['Buffs'];
		if( !empty($buffs) && is_array($buffs) )
		{
			$this->setMessage('<li>Updating Buffs: ');

			// Delete the stale data
			$querystr = "DELETE FROM `".ROSTER_BUFFSTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Buffs could not be deleted',$this->error());
				return;
			}
			// Then process quests
			$buffsnum = 0;
			foreach( $buffs as $buff )
			{
				if( is_null($buff) || !is_array($buff) || empty($buff) )
				{
					continue;
				}
				$this->reset_values();

				$this->add_value('member_id', $memberId );
				$this->add_value('name', $buff['Name'] );

				if( isset( $buff['Icon'] ) )
					$this->add_value('icon', 'Interface/Icons/'.$buff['Icon'] );

				if( isset( $buff['Rank'] ) )
					$this->add_value('rank', $buff['Rank'] );

				if( isset( $buff['Rank'] ) )
					$buff_rank = $buff['Rank'];

				if( isset( $buff['Count'] ) )
					$this->add_value('count', $buff['Count'] );

				if( !empty($buff['Tooltip']) )
					$this->add_value('tooltip', $this->tooltip( $buff['Tooltip'] ) );
				else
					$this->add_value('tooltip', $buff['Name'] );

				$querystr = "INSERT INTO `".ROSTER_BUFFSTABLE."` SET ".$this->assignstr;
				$result = $this->query($querystr);
				if( !$result )
				{
					$this->setError('Buff ['.$buff['Name'].'] could not be inserted',$this->error());
				}

				$buffsnum++;
			}
			$this->setMessage($buffsnum.'</li>');
	   	}
		else
		{
			$this->setMessage('<li>No Buffs</li>');
		}
	}


	/**
	 * Handles formating and insertion of quest data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_quests( $data, $memberId )
	{
		$quests = $data['Quests'];

		if( !empty($quests) && is_array($quests) )
		{
			$this->setMessage('<li>Updating Quests: ');

			// Delete the stale data
			$querystr = "DELETE FROM `".ROSTER_QUESTSTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Quests could not be deleted',$this->error());
				return;
			}
			// Then process quests
			$questnum = 0;
			foreach( array_keys($quests) as $zone )
			{
				$zoneInfo = $quests[$zone];
				foreach( array_keys($zoneInfo) as $slot)
				{
					$slotInfo = $zoneInfo[$slot];
					if( is_null($slotInfo) || !is_array($slotInfo) || empty($slotInfo) )
					{
						continue;
					}
					$item = $this->make_quest( $slotInfo, $memberId, $zone, $slot );
					$this->insert_quest( $item );
					$questnum++;
				}
			}
			$this->setMessage($questnum.'</li>');
	   	}
		else
		{
			$this->setMessage('<li>No Quest Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of recipe data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_recipes( $data, $memberId )
	{
		$prof = $data['Professions'];

		if( !empty($prof) && is_array($prof) )
		{
			$this->setMessage('<li>Updating Professions');

			// Delete the stale data
			$querystr = "DELETE FROM `".ROSTER_RECIPESTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Professions could not be deleted',$this->error());
				return;
			}
			// Then process Professions
			foreach( array_keys($prof) as $skill_name )
			{
				$this->setMessage(" : $skill_name");

				$skill = $prof[$skill_name];
				foreach( array_keys( $skill) as $recipe_type )
				{
					$item = $skill[$recipe_type];
					foreach(array_keys($item) as $recipe_name)
					{
						$recipeDetails = $item[$recipe_name];
						if( is_null($recipeDetails) || !is_array($recipeDetails) || empty($recipeDetails) )
						{
							continue;
						}
						$recipe = $this->make_recipe( $recipeDetails, $memberId, $skill_name, $recipe_type, $recipe_name );
						$this->insert_recipe( $recipe,$data['Locale'] );
					}
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Recipe Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of equipment data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_equip( $data, $memberId )
	{
		// Update Equipment Inventory
		$equip = $data['Equipment'];
		if( !empty($equip) && is_array($equip) )
		{
			$this->setMessage('<li>Updating Equipment ');

			$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` = '$memberId' AND `item_parent` = 'equip'";
			if( !$this->query($querystr) )
			{
				$this->setError('Equipment could not be deleted',$this->error());
				return;
			}
			foreach( array_keys($equip) as $slot_name )
			{
				$this->setMessage('.');
				$slot = $equip[$slot_name];
				if( is_null($slot) || !is_array($slot) || empty($slot) )
				{
					continue;
				}
				$item = $this->make_item( $slot, $memberId, 'equip', $slot_name );
				$this->insert_item( $item,$data['Locale'] );
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Equipment Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of inventory data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_inventory( $data, $memberId )
	{
		// Update Bag Inventory
		$inv = $data['Inventory'];
		if( !empty($inv) && is_array($inv) )
		{
			$this->setMessage('<li>Updating Inventory');

			$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` = '$memberId' AND UPPER(`item_parent`) LIKE 'BAG%' AND `item_parent` != 'bags'";
			if( !$this->query($querystr) )
			{
				$this->setError('Inventory could not be deleted',$this->error());
				return;
			}

			$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` = '$memberId' AND `item_parent` = 'bags' AND UPPER(`item_slot`) LIKE 'BAG%'";
			if( !$this->query($querystr) )
			{
				$this->setError('Inventory could not be deleted',$this->error());
				return;
			}

			foreach( array_keys( $inv ) as $bag_name )
			{
				$this->setMessage(" : $bag_name");

				$bag = $inv[$bag_name];
				if( is_null($bag) || !is_array($bag) || empty($bag) )
				{
					continue;
				}
				$item = $this->make_item( $bag, $memberId, 'bags', $bag_name );

				// quantity for a bag means number of slots it has
				$item['item_quantity'] = $bag['Slots'];
				$this->insert_item( $item,$data['Locale'] );
				if (isset($bag['Contents']) && is_array($bag['Contents']))
				{
					foreach( array_keys( $bag['Contents'] ) as $slot_name )
					{
						$slot = $bag['Contents'][$slot_name];
						if( is_null($slot) || !is_array($slot) || empty($slot) )
						{
							continue;
						}
						$item = $this->make_item( $slot, $memberId, $bag_name, $slot_name );
						$this->insert_item( $item,$data['Locale'] );
					}
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Inventory Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of bank data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_bank( $data, $memberId )
	{
		// Update Bank Inventory
		$inv = $data['Bank'];
		if( !empty($inv) && is_array($inv) )
		{
			$this->setMessage('<li>Updating Bank');

			// Clearing out old items
			$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` = '$memberId' AND UPPER(`item_parent`) LIKE 'BANK%'";
			if( !$this->query($querystr) )
			{
				$this->setError('Bank could not be deleted',$this->error());
				return;
			}

			$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` = '$memberId' AND `item_parent` = 'bags' AND UPPER(`item_slot`) LIKE 'BANK%'";
			if( !$this->query($querystr) )
			{
				$this->setError('Bank could not be deleted',$this->error());
				return;
			}

			foreach( array_keys( $inv ) as $bag_name )
			{
				$this->setMessage(" : $bag_name");
				$bag = $inv[$bag_name];
				if( is_null($bag) || !is_array($bag) || empty($bag) )
				{
					continue;
				}

				$dbname = 'Bank '.$bag_name;
				$item = $this->make_item( $bag, $memberId, 'bags', $dbname );

				// Fix bank bag icon
				if( $bag_name == 'Bag0' )
				{
					$item['item_texture'] = 'Interface/Icons/INV_Misc_Bag_15';
				}

				// quantity for a bag means number of slots it has
				$item['item_quantity'] = $bag['Slots'];
				$this->insert_item( $item,$data['Locale'] );

				if (isset($bag['Contents']) && is_array($bag['Contents']))
				{
					foreach( array_keys( $bag['Contents'] ) as $slot_name )
					{
						$slot = $bag['Contents'][$slot_name];
						if( is_null($slot) || !is_array($slot) || empty($slot) )
						{
							continue;
						}
						$item = $this->make_item( $slot, $memberId, $dbname, $slot_name );
						$this->insert_item( $item,$data['Locale'] );
					}
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Bank Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of mailbox data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_mailbox( $data, $memberId )
	{
		$this->setMessage('<li>Updating Mailbox: ');

		$mailbox = $data['MailBox'];
		// If maildate is newer than the db value, wipe all mail from the db
		//if(  )
		//{
			$querystr = "DELETE FROM `".ROSTER_MAILBOXTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Mail could not be deleted',$this->error());
				return;
			}
		//}

		if( !empty($mailbox) && is_array($mailbox) )
		{
			foreach( array_keys($mailbox) as $slot_num )
			{
				$slot = $mailbox[$slot_num];
				if( is_null($slot) || !is_array($slot) || empty($slot) )
				{
					continue;
				}
				$mail = $this->make_mail( $slot, $memberId, $slot_num );
				$this->insert_mail( $mail );
			}
			$this->setMessage(count($mailbox).' Message'.(count($mailbox) > 1 ? 's' : '').'</li>');
		}
		else
		{
			$this->setMessage('No New Mail</li>');
		}
	}


	/**
	 * Handles formating and insertion of rep data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_reputation( $data, $memberId )
	{
		$repData = $data['Reputation'];

		if( !empty($repData) && is_array($repData) )
		{
			$this->setMessage('<li>Updating Reputation ');

			//first delete the stale data
			$querystr = "DELETE FROM `".ROSTER_REPUTATIONTABLE."` WHERE `member_id` = '$memberId'";

			if( !$this->query($querystr) )
			{
				$this->setError('Reputation could not be deleted',$this->error());
				return;
			}

			$count = $repData['Count'];

			foreach( array_keys( $repData ) as $factions )
			{
				$faction_name = $repData[$factions];
				if ($faction_name != $count)
				{
					foreach( array_keys( $faction_name ) as $faction )
					{
						$this->reset_values();
						if( !empty($memberId) )
							$this->add_value('member_id', $memberId );
						if( !empty($factions) )
							$this->add_value('faction', $factions );
						if( !empty($faction) )
							$this->add_value('name', $faction );
						if( !empty($repData[$factions][$faction]['Value']) )
						{
							list($level, $max) = explode(':',$repData[$factions][$faction]['Value']);
							$this->add_value('curr_rep', $level );
							$this->add_value('max_rep', $max );
						}
						if( !empty($repData[$factions][$faction]['AtWar']) )
							$this->add_value('AtWar', $repData[$factions][$faction]['AtWar'] );
						if( !empty($repData[$factions][$faction]['Standing']) )
							$this->add_value('Standing', $repData[$factions][$faction]['Standing']);

						$this->setMessage('.');
						$querystr = "INSERT INTO `".ROSTER_REPUTATIONTABLE."` SET ".$this->assignstr;

						$result = $this->query($querystr);
						if( !$result )
						{
							$this->setError('Reputation for '.$faction.' could not be inserted',$this->error());
						}
					}
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Reputation Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of skills data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_skills( $data, $memberId )
	{
		$skillData = $data['Skills'];

		if( !empty($skillData) && is_array($skillData) )
		{
			$this->setMessage('<li>Updating Skills ');

			//first delete the stale data
			$querystr = "DELETE FROM `".ROSTER_SKILLSTABLE."` WHERE `member_id` = '$memberId'";

			if( !$this->query($querystr) )
			{
				$this->setError('Skills could not be deleted',$this->error());
				return;
			}

			foreach( array_keys( $skillData ) as $skill_type )
			{
				$sub_skill = $skillData[$skill_type];
				$order = $sub_skill['Order'];
				foreach( array_keys( $sub_skill ) as $skill_name )
				{
					if( $skill_name != 'Order' )
					{
						$this->reset_values();
						if( !empty($memberId) )
							$this->add_value('member_id', $memberId );
						if( !empty($skill_type) )
							$this->add_value('skill_type', $skill_type );
						if( !empty($skill_name) )
							$this->add_value('skill_name', $skill_name );
						if( !empty($order) )
							$this->add_value('skill_order', $order );
						if( !empty($sub_skill[$skill_name]) )
							$this->add_value('skill_level', $sub_skill[$skill_name] );

						$this->setMessage('.');
						$querystr = "INSERT INTO `".ROSTER_SKILLSTABLE."` SET ".$this->assignstr;

						$result = $this->query($querystr);
						if( !$result )
						{
							$this->setError('Skill ['.$skill_name.'] could not be inserted',$this->error());
						}
					}
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Skill Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of spellbook data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_spellbook( $data, $memberId )
	{
		$spellbook = $data['SpellBook'];

		if( !empty($spellbook) && is_array($spellbook) )
		{
			$this->setMessage('<li>Updating Spellbook');

			// first delete the stale data
			$querystr = "DELETE FROM `".ROSTER_SPELLTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Spells could not be deleted',$this->error());
				return;
			}

			// then process Spellbook Tree
			$querystr = "DELETE FROM `".ROSTER_SPELLTREETABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Spell Trees could not be deleted',$this->error());
				return;
			}

			// then process spellbook
			foreach( array_keys( $spellbook ) as $spell_type )
			{
				$this->setMessage(" : $spell_type");

				$data_spell_type = $spellbook[$spell_type];
				foreach( array_keys( $data_spell_type ) as $spell )
				{
					$data_spell = $data_spell_type[$spell];

					if( is_array($data_spell) )
					{
						foreach( array_keys( $data_spell ) as $spell_name )
						{
							$data_spell_name = $data_spell[$spell_name];

							$this->reset_values();
							if( !empty($memberId) )
								$this->add_value('member_id', $memberId );
							if( !empty($spell_type) )
								$this->add_value('spell_type', $spell_type );
							if( !empty($spell_name) )
								$this->add_value('spell_name', $spell_name );
							if( !empty($data_spell_name['Icon']) )
								$this->add_value('spell_texture', 'Interface/Icons/'.$data_spell_name['Icon'] );
							if( !empty($data_spell_name['Rank']) )
								$this->add_value('spell_rank', $data_spell_name['Rank'] );

							if( !empty($data_spell_name['Tooltip']) )
							{
								$this->add_value('spell_tooltip', $this->tooltip($data_spell_name['Tooltip']) );
							}
							elseif( !empty($spell_name) || !empty($data_spell_name['Rank']) )
							{
								$this->add_value('spell_tooltip', $spell_name."\n".$data_spell_name['Rank'] );
							}

							$querystr = "INSERT INTO `".ROSTER_SPELLTABLE."` SET ".$this->assignstr;
							$result = $this->query($querystr);
							if( !$result )
							{
								$this->setError('Spell ['.$spell_name.'] could not be inserted',$this->error());
							}
						}
					}
				}
				$this->reset_values();
				$this->add_value('member_id', $memberId );
				$this->add_value('spell_type', $spell_type );
				$this->add_value('spell_texture', 'Interface/Icons/'.$data_spell_type['Icon'] );

				$querystr = "INSERT INTO `".ROSTER_SPELLTREETABLE."` SET ".$this->assignstr;
				$result = $this->query($querystr);
				if( !$result )
				{
					$this->setError('Spell Tree ['.$spell_type.'] could not be inserted',$this->error());
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Spellbook Data</li>');
		}
	}


	/**
	 * Handles formating and insertion of talent data
	 *
	 * @param array $data
	 * @param int $memberId
	 */
	function do_talents( $data, $memberId )
	{
		$talentData = $data['Talents'];

		if( !empty($talentData) && is_array($talentData) )
		{
			$this->setMessage('<li>Updating Talents');

			// first delete the stale data
			$querystr = "DELETE FROM `".ROSTER_TALENTSTABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Talents could not be deleted',$this->error());
				return;
			}

			// then process Talents
			$querystr = "DELETE FROM `".ROSTER_TALENTTREETABLE."` WHERE `member_id` = '$memberId'";
			if( !$this->query($querystr) )
			{
				$this->setError('Talent Trees could not be deleted',$this->error());
				return;
			}

			// Update Talents
			foreach( array_keys( $talentData ) as $talent_tree )
			{
				$this->setMessage(" : $talent_tree");

				$data_talent_tree = $talentData[$talent_tree];
				foreach( array_keys( $data_talent_tree ) as $talent_skill )
				{
					$data_talent_skill = $data_talent_tree[$talent_skill];
					if( $talent_skill == 'Order' )
					{
						$tree_order = $data_talent_skill;
					}
					elseif ( $talent_skill == 'PointsSpent' )
					{
						$tree_pointsspent = $data_talent_skill;
					}
					elseif ( $talent_skill == 'Background')
					{
						$tree_background = 'Interface/TalentFrame/'.$data_talent_skill;
					}
					else
					{
						$this->reset_values();
						if( !empty($memberId) )
							$this->add_value('member_id', $memberId );
						if( !empty($talent_skill) )
							$this->add_value('name', $talent_skill );
						if( !empty($talent_tree) )
							$this->add_value('tree', $talent_tree );

						if( !empty($data_talent_skill['Tooltip']) )
							$this->add_value('tooltip', $this->tooltip($data_talent_skill['Tooltip']) );
						else
							$this->add_value('tooltip', $talent_skill );

						if( !empty($data_talent_skill['Icon']) )
							$this->add_value('texture', 'Interface/Icons/'.$data_talent_skill['Icon'] );

						$this->add_value('row', substr($data_talent_skill['Location'], 0, 1) );
						$this->add_value('column', substr($data_talent_skill['Location'], 2, 1) );
						$this->add_value('rank', substr($data_talent_skill['Rank'], 0, 1) );
						$this->add_value('maxrank', substr($data_talent_skill['Rank'], 2, 1) );

						$querystr = "INSERT INTO `".ROSTER_TALENTSTABLE."` SET ".$this->assignstr;
						$result = $this->query($querystr);
						if( !$result )
						{
							$this->setError('Talent ['.$talent_skill.'] could not be inserted',$this->error());
						}
					}
				}
				$this->reset_values();
				if( !empty($memberId) )
					$this->add_value('member_id', $memberId );
				if( !empty($talent_tree) )
					$this->add_value('tree', $talent_tree );
				if( !empty($tree_background) )
					$this->add_value('background', $tree_background );
				if( !empty($tree_pointsspent) )
					$this->add_value('pointsspent', $tree_pointsspent );
				if( !empty($tree_order) )
					$this->add_value('order', $tree_order );

				$querystr = "INSERT INTO `".ROSTER_TALENTTREETABLE."` SET ".$this->assignstr;
				$result = $this->query($querystr);
				if( !$result )
				{
					$this->setError('Talent Tree ['.$talent_tree.'] could not be inserted',$this->error());
				}
			}
			$this->setMessage('</li>');
		}
		else
		{
			$this->setMessage('<li>No Talents Data</li>');
		}
	}


	/**
	 * Delete Members in database using inClause
	 * (comma separated list of member_id's to delete)
	 *
	 * @param string $inClause
	 */
	function deleteMembers( $inClause )
	{
		$this->setMessage('<li>');

		$this->setMessage('Character Data..');
		$querystr = "DELETE FROM `".ROSTER_MEMBERSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Member Data could not be deleted',$this->error());
		}

		$querystr = "DELETE FROM `".ROSTER_PLAYERSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Player Data could not be deleted',$this->error());
		}


		$this->setMessage('Skills..');
		$querystr = "DELETE FROM `".ROSTER_SKILLSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Skill Data could not be deleted',$this->error());
		}


		$this->setMessage('Items..');
		$querystr = "DELETE FROM `".ROSTER_ITEMSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Items Data could not be deleted',$this->error());
		}


		$this->setMessage('Quests..');
		$querystr = "DELETE FROM `".ROSTER_QUESTSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Quest Data could not be deleted',$this->error());
		}


		$this->setMessage('PvPLog Data..');
		$querystr = "DELETE FROM `".ROSTER_PVP2TABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('PvPLog Data could not be deleted',$this->error());
		}


		$this->setMessage('Professions..');
		$querystr = "DELETE FROM `".ROSTER_RECIPESTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Recipe Data could not be deleted',$this->error());
		}


		$this->setMessage('Talents..');
		$querystr = "DELETE FROM `".ROSTER_TALENTSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Talent Data could not be deleted',$this->error());
		}

		$querystr = "DELETE FROM `".ROSTER_TALENTTREETABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Talent Tree Data could not be deleted',$this->error());
		}


		$this->setMessage('Spellbook..');
		$querystr = "DELETE FROM `".ROSTER_SPELLTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Spell Data could not be deleted',$this->error());
		}

		$querystr = "DELETE FROM `".ROSTER_SPELLTREETABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Spell Tree Data could not be deleted',$this->error());
		}


		$this->setMessage('Pets..');
		$querystr = "DELETE FROM `".ROSTER_PETSTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Pet Data could not be deleted',$this->error());
		}


		$this->setMessage('Reputation..');
		$querystr = "DELETE FROM `".ROSTER_REPUTATIONTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Reputation Data could not be deleted',$this->error());
		}


		$this->setMessage('Mail..');
		$querystr = "DELETE FROM `".ROSTER_MAILBOXTABLE."` WHERE `member_id` IN ($inClause)";
		if( !$this->query($querystr) )
		{
			$this->setError('Mail Data could not be deleted',$this->error());
		}

		$this->setMessage('</li>');
	}


	/**
	 * Removes guild members with update_time < guild['update_time']
	 *
	 * @param int $guild_id
	 * @param array $date
	 */
	function remove_guild_members($guild_id, $date)
	{
		$querystr = "SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = '$guild_id' AND `update_time` <> '".
			$date['year'].'-'.$date['mon'].'-'.$date['mday'].' '.$date['hours'].':'.$date['minutes'].':00'."'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Members could not be selected for deletion',$this->error());
			return;
		}

		$num = $this->num_rows($result);

		$inClause = '';
		if ($num > 0)
		{
			while ( $row = $this->fetch_array($result) )
			{
				if ($inClause != '')
					$inClause .= ',';

				$inClause .= $row[0];
				$this->setMessage('<li><span class="red">[</span> '.$row[1].' <span class="red">] - Deleted</span></li>');
				$this->setMemberLog($row,0);

			}

			$this->setMessage('<li><span class="red">Deleted '.$num.' member'.($num > 1 ? 's' : '').'</span>');
			$this->setMessage('<ul>');

			// now that we have our inclause, time to do some deletes
			$this->deleteMembers($inClause);

			$this->setMessage('</ul></li>');
		}
		$this->closeQuery($result);
	}

	/**
	 * Removes members that do not match current guild_id
	 *
	 * @param int $guild_id
	 */
	function remove_guild_members_id($guild_id)
	{
		// Get a list of guild id's in the guild table to remove
		$querystr = "SELECT `guild_id`,`guild_name` FROM `".ROSTER_GUILDTABLE."` WHERE `guild_id` != '$guild_id'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Guild ID\'s could not be selected for deletion',$this->error());
			return;
		}

		$num = $this->num_rows($result);

		$inClause = '';
		if ($num > 0)
		{
			while ( $row = $this->fetch_array($result) )
			{
				if ($inClause != '')
					$inClause .= ',';

				$inClause .= $row[0];
				$this->setMessage('<li><span class="red">Guild [</span> '.$row[1].' <span class="red">] - Deleted</span></li>');
			}

			// now that we have our inclause, time to do some deletes
			$querystr = "DELETE FROM `".ROSTER_GUILDTABLE."` WHERE `guild_id` IN ($inClause)";
			if( !$this->query($querystr) )
			{
				$this->setError('Guild'.($num > 1 ? 's' : '').' with ID'.($num > 1 ? 's' : '').' '.$inClause.' could not be deleted',$this->error());
			}

			$this->setMessage('<li><span class="red">Deleted '.$num.' guild'.($num > 1 ? 's' : '').' with mis-matched guild-id'.($num > 1 ? '\s' : '').'</span></li>');
		}
		$this->closeQuery($result);


		// Get a list of members that don't match current guild id
		$querystr = "SELECT `member_id`,`name` FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` != '$guild_id'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Members could not be selected for deletion',$this->error());
			return;
		}

		$num = $this->num_rows($result);

		$inClause = '';
		if ($num > 0)
		{
			while ( $row = $this->fetch_array($result) )
			{
				if ($inClause != '')
					$inClause .= ',';

				$inClause .= $row[0];
				$this->setMessage('<li><span class="red">[</span> '.$row[1].' <span class="red">] Deleted since their guild-id does not match</span></li>');
				$this->setMemberLog($row,0);
			}

			$this->setMessage('<li><span class="red">Removing '.$num.' member'.($num > 1 ? 's' : '').' with mis-matched guild-id'.($num > 1 ? '\'s' : '').'</span>');
			$this->setMessage('<ul>');

			// now that we have our inclause, time to do some deletes
			$this->deleteMembers($inClause);

			$this->setMessage('</ul></li>');
		}
		$this->closeQuery($result);
	}

	/**
	 * Gets guild info from database
	 * Returns info as an array
	 *
	 * @param string $realmName
	 * @param string $guildName
	 * @return array
	 */
	function get_guild_info($realmName,$guildName)
	{
		$guild_name_escape = $this->escape( $guildName );
		$server_escape = $this->escape( $realmName );

		$querystr = "SELECT * FROM `".ROSTER_GUILDTABLE."` WHERE `guild_name` = '$guild_name_escape' AND `server` = '$server_escape'";
		$result = $this->query($querystr) or die_quietly($this->error(),'WowDB Error',basename(__FILE__).'<br />Function: '.(__FUNCTION__),__LINE__,$querystr);

		$retval = $this->fetch_array( $result );
		$this->closeQuery($result);

		return $retval;
	}


	/**
	 * Function to prepare the memberlog data
	 *
	 * @param array $data | Member info array
	 * @param multiple $type | Action to update ( 'rem','del,0 | 'add','new',1 )
	 */
	function setMemberLog( $data , $type )
	{
		if ( is_array($data) )
		{
			switch ($type)
			{
				case 'del':
				case 'rem':
				case 0:
					$this->membersremoved++;
					$this->updateMemberlog($data,0);
					break;

				case 'add':
				case 'new':
				case 1:
					$this->membersadded++;
					$this->updateMemberlog($data,1);
					break;
			}
		}
	}


	/**
	 * Updates or creates an entry in the guild table in the database
	 * Then returns the guild ID
	 *
	 * @param string $realmName
	 * @param string $guildName
	 * @param array $currentTime
	 * @param array $guild
	 * @return string
	 */
	function update_guild( $realmName, $guildName, $currentTime, $guild )
	{
		$guildInfo = $this->get_guild_info($realmName,$guildName);

		$this->reset_values();

		$this->add_value( 'guild_name', $guildName );

		$this->add_value( 'server', $realmName );
		$this->add_value( 'faction', $guild['Faction'] );
		$this->add_value( 'guild_motd', $guild['Motd'] );

		if( !empty($guild['NumMembers']) )
			$this->add_value( 'guild_num_members', $guild['NumMembers'] );
		if( !empty($guild['NumAccounts']) )
			$this->add_value( 'guild_num_accounts', $guild['NumAccounts'] );
		if( !empty($currentTime) )
			$this->add_time( 'update_time', $currentTime );

		if( !empty($guild['timestamp']['init']['DateUTC']) )
		{
			list($year,$month,$day,$hour,$minute,$second) = sscanf($guild['timestamp']['init']['DateUTC'],"%4s-%2s-%2s %2s:%2s:%2s");
			$this->add_value( 'guild_dateupdatedutc', "$month/$day/".substr($year,2,2)." $hour:$minute:$second" );
		}

		$this->add_value( 'GPversion', $guild['DBversion'] );
		$this->add_value( 'guild_info_text', str_replace('\n',"\n",$guild['Info']) );

		if ($guildInfo)
		{
			$guildId = $guildInfo['guild_id'];
			$querystr = "UPDATE `".ROSTER_GUILDTABLE."` SET ".$this->assignstr." WHERE `guild_id` = '$guildId'";
			$output = $guildId;
		}
		else
		{
			$querystr = "INSERT INTO `".ROSTER_GUILDTABLE."` SET ".$this->assignstr;
		}

		$this->query($querystr) or die_quietly($this->error(),'WowDB Error',basename(__FILE__).'<br />Function: '.(__FUNCTION__),__LINE__,$querystr);

		if( !$guildInfo )
		{
			$guildInfo = $this->get_guild_info($realmName,$guildName);
			$output = $guildInfo['guild_id'];
		}

		return $output;
	}


	/**
	 * Updates or adds guild members
	 *
	 * @param int $guildId
	 * @param string $name
	 * @param array $char
	 * @param array $currentTimestamp
	 */
	function update_guild_member( $guildId, $name, $char, $currentTimestamp, $guildRanks )
	{
		$name_escape = $this->escape( $name );

		$querystr = "SELECT `member_id` FROM `".ROSTER_MEMBERSTABLE."` WHERE `name` = '$name_escape' AND `guild_id` = '$guildId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Member could not be selected for update',$this->error());
			return;
		}

		$memberInfo = $this->fetch_assoc( $result );
		if ($memberInfo)
			$memberId = $memberInfo['member_id'];

		$this->closeQuery($result);

		$this->reset_values();

		$this->add_value( 'name', $name_escape);
		$this->add_value( 'class', $char['Class']);
		$this->add_value( 'level', $char['Level']);
		if( isset($char['Note']) )
			$this->add_value( 'note', $char['Note']);
		else
			$this->add_value( 'note', '');
		$this->add_value( 'guild_rank', $char['Rank']);
		$this->add_value( 'guild_title', $guildRanks[$char['Rank']]['Title']);
		if( isset($char['OfficerNote']) )
			$this->add_value( 'officer_note', $char['OfficerNote']);
		else
			$this->add_value( 'officer_note', '');
		$this->add_value( 'zone', $char['Zone']);
		if( isset($char['Status']) )
			$this->add_value( 'status', $char['Status']);
		else
			$this->add_value( 'status', '');
		$this->add_time( 'update_time', getDate($currentTimestamp));

		if( $char['Online'] == '1' )
		{
			$this->add_value( 'online', 1 );
			$this->add_time('last_online', getDate($currentTimestamp));
		}
		else
		{
			$this->add_value( 'online', 0 );
			list($lastOnlineYears,$lastOnlineMonths,$lastOnlineDays,$lastOnlineHours) = explode(':',$char['LastOnline']);

			# use strtotime instead
			#      $lastOnlineTime = $currentTimestamp - 365 * 24* 60 * 60 * $lastOnlineYears
			#                        - 30 * 24 * 60 * 60 * $lastOnlineMonths
			#                        - 24 * 60 * 60 * $lastOnlineDays
			#                        - 60 * 60 * $lastOnlineHours;
			$timeString = '-';
			if ($lastOnlineYears > 0)
				$timeString .= $lastOnlineYears.' Years ';
			if ($lastOnlineMonths > 0)
				$timeString .= $lastOnlineMonths.' Months ';
			if ($lastOnlineDays > 0)
				$timeString .= $lastOnlineDays.' Days ';
			$timeString .= max($lastOnlineHours,1).' Hours';

			$lastOnlineTime = strtotime($timeString,$currentTimestamp);
			$this->add_time( 'last_online', getDate($lastOnlineTime) );
		}

		if( $memberId )
		{
			$querystr = "UPDATE `".ROSTER_MEMBERSTABLE."` SET ".$this->assignstr." WHERE `member_id` = '$memberId' AND `guild_id` = '$guildId'";
			$this->setMessage('<li>[ '.$name.' ]</li>');
			$this->membersupdated++;

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError(''.$name.' could not be inserted',$this->error());
				return;
			}
		}
		else
		{
			// Add the guild Id first
			if( !empty($guildId) )
				$this->add_value( 'guild_id', $guildId);

			$querystr = "INSERT INTO `".ROSTER_MEMBERSTABLE."` SET ".$this->assignstr;
			$this->setMessage('<li><span class="green">[</span> '.$name.' <span class="green">] - Added</span></li>');

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError(''.$name_escape.' could not be inserted',$this->error());
				return;
			}

			$querystr = "SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = '$guildId' AND `name` = '$name_escape' AND `class` = '".$char['Class']."';";
			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Member could not be selected for MemberLog',$this->error());
			}
			else
			{
				$row = $this->fetch_array($result);
				$this->setMemberLog($row,1);
			}
		}
	}


	/**
	 * Updates pvp table
	 *
	 * @param int $guildId
	 * @param string $name
	 * @param array $data
	 */
	function update_pvp2($guildId, $name, $data )
	{
		$name_escape = $this->escape( $name );

		$querystr = "SELECT `member_id` FROM `".ROSTER_MEMBERSTABLE."` WHERE `name` = '$name_escape' AND `guild_id` = '$guildId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Member could not be selected for update',$this->error());
			return;
		}

		$memberInfo = $this->fetch_assoc( $result );
		$this->closeQuery($result);
		if ($memberInfo)
		{
			$memberId = $memberInfo['member_id'];
		}
		else
		{
			$this->setMessage('<li>'.$name.' is not in the list of guild members so PVP2 info will not be inserted.</li>');
			return;
		}
		// process pvp
		$this->setMessage('<li>Updating PvP data</li>');
		// loop through each index fought
		foreach( array_keys($data) as $index)
		{
			$playerInfo = $data[$index];
			$playerName = $playerInfo['name'];
			$playerDate = date('Y-m-d G:i:s', strtotime($playerInfo['date']));
			$playerRealm = $playerInfo['realm'];

			// skip if entry already there
			$querystr = "SELECT `guild` FROM `".ROSTER_PVP2TABLE."` WHERE `index` = '$index' AND `member_id` = '$memberId' AND `name` = '".$this->escape( $playerName )."' AND `date` = '".$this->escape( $playerDate )."'".( !empty($playerRealm) ? " AND `realm` = '".$this->escape( $playerRealm )."';" : ';' );

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('PvPLog cannot update',$this->error());
				return;
			}

			$memberInfo = $this->fetch_assoc( $result );
			$this->closeQuery($result);
			if ($memberInfo)
			{}
			else
			{
				$this->setMessage('<li>Adding pvp2 data for ['.$playerInfo['name'].']</li>');

				$this->reset_values();
				$this->add_value('member_id', $memberId);
				$this->add_value('index', $index);
				$this->add_pvp2time('date', $playerInfo['date']);
				$this->add_value('name', $playerInfo['name']);
				$this->add_value('guild', $playerInfo['guild']);
				$this->add_value('realm', $playerInfo['realm']);
				$this->add_value('race', $playerInfo['race']);
				$this->add_value('class', $playerInfo['class']);
				$this->add_value('zone', $playerInfo['zone']);
				$this->add_value('subzone', $playerInfo['subzone']);
				$this->add_value('leveldiff', $playerInfo['lvlDiff']);
				$this->add_value('enemy', $playerInfo['enemy']);
				$this->add_value('win', $playerInfo['win']);
				$this->add_value('bg', $playerInfo['bg']);
				$this->add_value('rank', $playerInfo['rank']);
				$this->add_value('honor', $playerInfo['honor']);

				$querystr = "INSERT INTO `".ROSTER_PVP2TABLE."` SET ".$this->assignstr;
				$result = $this->query($querystr);
				if( !$result )
				{
					$this->setError('PvPLog Data could not be inserted',$this->error());
				}
			}
		}

		// now calculate ratio
		$wins = 0;
		$querystr = "SELECT COUNT(`win`) AS wins FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '1' AND `member_id` = '$memberId' GROUP BY `win`";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('PvPLog cannot select wins',$this->error());
			return;
		}
		$memberInfo = $this->fetch_assoc( $result );
		$this->closeQuery($result);
		if ($memberInfo)
			$wins = $memberInfo['wins'];
		$this->setMessage('<li>Wins: '.$wins.'</li>');


		$losses = 0;
		$querystr = "SELECT COUNT(`win`) AS losses FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '0' AND `member_id` = '$memberId' GROUP BY `win`";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('PvPLog cannot select losses',$this->error());
			return;
		}
		$memberInfo = $this->fetch_assoc( $result );
		$this->closeQuery($result);
		if ($memberInfo)
			$losses = $memberInfo['losses'];
		$this->setMessage('<li>Losses: '.$losses.'</li>');


		if ($losses == 0 || $wins == 0)
		{
			if ($losses == 0 && $wins == 0)
				$ratio = 0;
			else
				$ratio = 99999;

		}
		else
			$ratio = $wins / $losses;

		$querystr = "UPDATE `".ROSTER_PLAYERSTABLE."` SET `pvp_ratio` = ".$ratio." WHERE `member_id` = '$memberId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('PvPLog ratio could not be updated',$this->error());
		}

		$this->setMessage('<li>Set PvP ratio to '.$ratio.'</li>');
	}


	/**
	 * Function to handle future account data
	 *
	 * @param int $memberId
	 * @param string $name
	 * @param array $data
	 */
	function update_account( $memberId, $name, $data )
	{
		if($data['Account'] == $name)
		{
			$name_escape = $this->escape( $name );
			$querystr = "SELECT `name` FROM `".ROSTER_ACCOUNTTABLE."`";
			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Cannot update Account Data',$this->error());
				return;
			}

			$update = $this->num_rows( $result ) == 1;
			$this->closeQuery($result);

			$this->reset_values();

			$this->add_value( 'name', $data['Account'] );
			$this->add_value( 'hash', $data['Hash'] );

			if( $update )
				$querystr = "UPDATE `".ROSTER_ACCOUNTTABLE."` SET ".$this->assignstr." WHERE `name` = '$name_escape'";
			else
				$querystr = "INSERT INTO `".ROSTER_ACCOUNTTABLE."` SET ".$this->assignstr;

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Could not set Account Data',$this->error());
				return;
			}

			$this->setMessage('<li>Assigning '.$name.' as Main Character</li>');
		}
		else
		{
			$this->setMessage('<li>Assigning '.$name.' as Alt Character</li>');
		}

		$name_escape = $this->escape( $data['Account'] );
		$querystr = "SELECT `account_id` FROM `".ROSTER_ACCOUNTTABLE."` WHERE `name` = '$name_escape'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot update Account Data',$this->error());
			return;
		}

		$accountInfo = $this->fetch_assoc( $result );

		if ($accountInfo)
		{
			$this->reset_values();

			$account_id = $accountInfo['account_id'];
			$this->add_value( 'account_id', $account_id );

			$display = $data['Display'];
			$this->add_value( 'inv', $display['Inventory'] );
			$this->add_value( 'talents', $display['Talents'] );
			$this->add_value( 'quests', $display['Quests'] );
			$this->add_value( 'bank', $display['Bank'] );

		}
		$this->closeQuery($result);

		$querystr = "UPDATE `".ROSTER_MEMBERSTABLE."` SET ".$this->assignstr." WHERE `member_id` = '$memberId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot update Account Data',$this->error());
			return;
		}
	}

	/**
	 * Updates/Inserts pets into the db
	 *
	 * @param int $memberId
	 * @param array $data
	 */
	function update_pets( $memberId, $data )
	{
		$petname = $data['Name'];
		$petname_escape = $this->escape($petname);

		if (!empty($petname))
		{
			$querystr = "SELECT `member_id`, `name` FROM `".ROSTER_PETSTABLE."` WHERE `member_id` = '$memberId' AND `name` LIKE  '".$petname_escape."'";

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Cannot select Pet Data',$this->error());
				return;
			}

			$update = $this->num_rows( $result ) == 1;
			$this->closeQuery($result);

			$this->reset_values();

			$this->add_value( 'member_id', $memberId );
			if( !empty($petname) )
				$this->add_value( 'name', $petname );
			if( !empty($data['Slot']) )
				$this->add_value( 'slot', $data['Slot'] );

			if( !empty($data['Attributes']['Stats']['Intellect']) )
				$this->add_value( 'stat_int', $data['Attributes']['Stats']['Intellect'] );
			if( !empty($data['Attributes']['Stats']['Agility']) )
				$this->add_value( 'stat_agl', $data['Attributes']['Stats']['Agility'] );
			if( !empty($data['Attributes']['Stats']['Stamina']) )
				$this->add_value( 'stat_sta', $data['Attributes']['Stats']['Stamina'] );
			if( !empty($data['Attributes']['Stats']['Strength']) )
				$this->add_value( 'stat_str', $data['Attributes']['Stats']['Strength'] );
			if( !empty($data['Attributes']['Stats']['Spirit']) )
				$this->add_value( 'stat_spr', $data['Attributes']['Stats']['Spirit'] );

			if( !empty($data['Attributes']['Resists']['Frost']) )
			{
				$resist = explode(':', $data['Attributes']['Resists']['Frost']);
				$this->add_value( 'res_frost', $resist[0]+$resist[1]+$resist[2] );
			}
			if( !empty($data['Attributes']['Resists']['Arcane']) )
			{
				$resist = explode(':', $data['Attributes']['Resists']['Arcane']);
				$this->add_value( 'res_arcane', $resist[0]+$resist[1]+$resist[2] );
			}
			if( !empty($data['Attributes']['Resists']['Fire']) )
			{
				$resist = explode(':', $data['Attributes']['Resists']['Fire']);
				$this->add_value( 'res_fire', $resist[0]+$resist[1]+$resist[2] );
			}
			if( !empty($data['Attributes']['Resists']['Shadow']) )
			{
				$resist = explode(':', $data['Attributes']['Resists']['Shadow']);
				$this->add_value( 'res_shadow', $resist[0]+$resist[1]+$resist[2] );
			}
			if( !empty($data['Attributes']['Resists']['Nature']) )
			{
				$resist = explode(':', $data['Attributes']['Resists']['Nature']);
				$this->add_value( 'res_nature', $resist[0]+$resist[1]+$resist[2] );
			}

			if( !empty($data['Level']) )
				$this->add_value( 'level', $data['Level'] );
			if( !empty($data['Health']) )
				$this->add_value( 'health', $data['Health'] );
			if( !empty($data['Mana']) )
				$this->add_value( 'mana', $data['Mana'] );
			if( !empty($data['Attributes']['Defense']['Armor']) )
				$this->add_value( 'armor', $data['Attributes']['Defense']['Armor'] );
			if( !empty($data['Attributes']['Defense']['Defense']) )
			{
				$defense = explode(':',$data['Attributes']['Defense']['Defense']);
				$this->add_value( 'defense', $defense[0]+$defense[1]+$defense[2] );
			}
			if( !empty($data['Experience']) )
				$this->add_value( 'xp', $data['Experience'] );
			if( !empty($data['TalentPointsUsed']) )
				$this->add_value( 'usedtp', $data['TalentPointsUsed'] );
			if( !empty($data['TalentPoints']) )
				$this->add_value( 'totaltp', $data['TalentPoints'] );
			if( !empty($data['Type']) )
				$this->add_value( 'type', $data['Type'] );
			if( !empty($data['Loyalty']) )
				$this->add_value( 'loyalty', $data['Loyalty']);
			if( !empty($data['Icon']) )
				$this->add_value( 'icon', 'Interface/Icons/'.$data['Icon']);

			$attack = $data['Attributes']['Melee'];

			if( isset($attack['AttackPower']) )
			{
				$power = explode(':',$attack['AttackPower']);
				$this->add_value( 'melee_power', $power[0]+$power[1]+$power[2] );
				unset($power);
			}

			if( !empty($attack['MainHand']['AttackSkill']) )
				$this->add_value( 'melee_rating', $attack['MainHand']['AttackSkill'] );
			if( !empty($attack['MainHand']['DamageRange']) )
				$this->add_value( 'melee_range', $attack['MainHand']['DamageRange'] );
			if( !empty($attack['DamageRangeTooltip']) )
				$this->add_value( 'melee_rangetooltip', $this->tooltip( $attack['DamageRangeTooltip'] ) );
			if( !empty($attack['AttackPowerTooltip']) )
				$this->add_value( 'melee_powertooltip', $this->tooltip( $attack['AttackPowerTooltip'] ) );

			$this->setMessage('<li>Updating pet ['.$petname_escape.']</li>');

			if( $update )
			{
				$querystr = "UPDATE `".ROSTER_PETSTABLE."` SET ".$this->assignstr." WHERE `member_id` = '$memberId' and name = '".$petname_escape."'";
			}
			else
			{
				$querystr = "INSERT INTO `".ROSTER_PETSTABLE."` SET ".$this->assignstr;
			}

			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Cannot update Pet Data',$this->error());
				return;
			}
		}
	}


	/**
	 * Handles formatting an insertion of Character Data
	 *
	 * @param int $guildId
	 * @param string $name
	 * @param array $data
	 */
	function update_char( $guildId, $name, $data )
	{
		//print '<pre>';
		//print_r( $data );
		//print '</pre>';

		$name_escape = $this->escape( $name );

		$querystr = "SELECT `member_id` FROM `".ROSTER_MEMBERSTABLE."` WHERE `name` = '$name_escape' AND `guild_id` = '$guildId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot select member_id for Character Data',$this->error());
			return;
		}

		$memberInfo = $this->fetch_assoc( $result );
		$this->closeQuery($result);
		if ($memberInfo)
		{
			$memberId = $memberInfo['member_id'];
		}
		else
		{
			$this->setMessage('<li>'.$name.' is not in the list of guild members so their data will not be inserted.</li>');
			return;
		}

		// update level in members table
		$querystr = "UPDATE `".ROSTER_MEMBERSTABLE."` SET `level` = '".$data['Level']."' WHERE `member_id` = $memberId LIMIT 1 ";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot update Level in Members Table',$this->error());
		}


		$querystr = "SELECT `member_id` FROM `".ROSTER_PLAYERSTABLE."` WHERE `member_id` = '$memberId'";
		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot select member_id for Character Data',$this->error());
			return;
		}

		$update = $this->num_rows( $result ) == 1;
		$this->closeQuery($result);

		$this->reset_values();

		$this->add_value( 'name', $name );
		$this->add_value( 'guild_id', $guildId );

		// CRIT, DODGE, MIT, PARRY VALUES FOR WOWROSTER
		$this->add_value( 'dodge',      ( isset($data['Attributes']['Defense']['DodgeChance']) ?    $data['Attributes']['Defense']['DodgeChance'] : 0 ) );
		$this->add_value( 'parry',      ( isset($data['Attributes']['Defense']['ParryChance']) ?    $data['Attributes']['Defense']['ParryChance'] : 0 ) );
		$this->add_value( 'block',      ( isset($data['Attributes']['Defense']['BlockChance']) ?    $data['Attributes']['Defense']['BlockChance'] : 0 ) );
		$this->add_value( 'mitigation', ( isset($data['Attributes']['Defense']['ArmorReduction']) ? $data['Attributes']['Defense']['ArmorReduction'] : 0 ) );
		$this->add_value( 'crit',       ( isset($data['Attributes']['Melee']['CritChance']) ?       $data['Attributes']['Melee']['CritChance'] : 0 ) );

		// BEGIN HONOR VALUES
		if( is_array($data['Honor']) )
		{
			$honor = $data['Honor'];
			if( isset($honor['Session']['HK']) )
				$this->add_value( 'sessionHK',             $honor['Session']['HK'] );
			else
				$this->add_value( 'sessionHK',0 );

			if( isset($honor['Session']['CP']) )
				$this->add_value( 'sessionCP',             $honor['Session']['CP'] );
			else
				$this->add_value( 'sessionCP',0 );

			if( isset($honor['Yesterday']['HK']) )
				$this->add_value( 'yesterdayHK',           $honor['Yesterday']['HK'] );
			else
				$this->add_value( 'yesterdayHK',0 );

			if( isset($honor['Yesterday']['CP']) )
				$this->add_value( 'yesterdayContribution', $honor['Yesterday']['CP'] );
			else
				$this->add_value( 'yesterdayContribution',0 );

			if( isset($honor['Lifetime']['HK']) )
				$this->add_value( 'lifetimeHK',            $honor['Lifetime']['HK'] );
			else
				$this->add_value( 'lifetimeHK',0 );

			if( isset($honor['Lifetime']['Rank']) )
				$this->add_value( 'lifetimeHighestRank',   $honor['Lifetime']['Rank'] );
			else
				$this->add_value( 'lifetimeHighestRank',0 );

			if( isset($honor['Lifetime']['Name']) )
				$this->add_value( 'lifetimeRankName',      $honor['Lifetime']['Name'] );
			else
				$this->add_value( 'lifetimeRankName','' );

			if( isset($honor['Current']['HonorPoints']) )
				$this->add_value( 'honorpoints',            $honor['Current']['HonorPoints'] );
			else
				$this->add_value( 'honorpoints',0 );

			if( isset($honor['Current']['ArenaPoints']) )
				$this->add_value( 'arenapoints',            $honor['Current']['ArenaPoints'] );
			else
				$this->add_value( 'arenapoints',0 );

			unset($honor);
		}
		// END HONOR VALUES

		// BEGIN STATS
		if( is_array($data['Attributes']['Stats']) )
		{
			$main_stats = $data['Attributes']['Stats'];

			$stats = explode(':',$main_stats['Intellect']);
			$this->add_value( 'stat_int', $stats[0] );
			$this->add_value( 'stat_int_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_int_b', $stats[1] );
			$this->add_value( 'stat_int_d', $stats[2] );

			$stats = explode(':',$main_stats['Agility']);
			$this->add_value( 'stat_agl', $stats[0] );
			$this->add_value( 'stat_agl_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_agl_b', $stats[1] );
			$this->add_value( 'stat_agl_d', $stats[2] );

			$stats = explode(':',$main_stats['Stamina']);
			$this->add_value( 'stat_sta', $stats[0] );
			$this->add_value( 'stat_sta_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_sta_b', $stats[1] );
			$this->add_value( 'stat_sta_d', $stats[2] );

			$stats = explode(':',$main_stats['Strength']);
			$this->add_value( 'stat_str', $stats[0] );
			$this->add_value( 'stat_str_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_str_b', $stats[1] );
			$this->add_value( 'stat_str_d', $stats[2] );

			$stats = explode(':',$main_stats['Spirit']);
			$this->add_value( 'stat_spr', $stats[0] );
			$this->add_value( 'stat_spr_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_spr_b', $stats[1] );
			$this->add_value( 'stat_spr_d', $stats[2] );

			$stats = explode(':',$data['Attributes']['Defense']['Armor']);
			$this->add_value( 'stat_armor', $stats[0] );
			$this->add_value( 'stat_armor_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_armor_b', $stats[1] );
			$this->add_value( 'stat_armor_d', $stats[2] );

			$stats = explode(':',$data['Attributes']['Defense']['Defense']);
			$this->add_value( 'stat_def', $stats[0] );
			$this->add_value( 'stat_def_c', $stats[0]+$stats[1]+$stats[2] );
			$this->add_value( 'stat_def_b', $stats[1] );
			$this->add_value( 'stat_def_d', $stats[2] );

			unset($main_stats,$stats);
		}
		// END STATS

		// BEGIN RESISTS
		if( is_array($data['Attributes']['Resists']) )
		{
			$main_res = $data['Attributes']['Resists'];

			$resist = explode(':',$main_res['Frost']);
			$this->add_value( 'res_frost', $resist[0] );
			$this->add_value( 'res_frost_c', $resist[0]+$resist[1]+$resist[2] );
			$this->add_value( 'res_frost_b', $resist[1] );
			$this->add_value( 'res_frost_d', $resist[2] );

			$resist = explode(':',$main_res['Arcane']);
			$this->add_value( 'res_arcane', $resist[0] );
			$this->add_value( 'res_arcane_c', $resist[0]+$resist[1]+$resist[2] );
			$this->add_value( 'res_arcane_b', $resist[1] );
			$this->add_value( 'res_arcane_d', $resist[2] );

			$resist = explode(':',$main_res['Fire']);
			$this->add_value( 'res_fire', $resist[0] );
			$this->add_value( 'res_fire_c', $resist[0]+$resist[1]+$resist[2] );
			$this->add_value( 'res_fire_b', $resist[1] );
			$this->add_value( 'res_fire_d', $resist[2] );

			$resist = explode(':',$main_res['Shadow']);
			$this->add_value( 'res_shadow', $resist[0] );
			$this->add_value( 'res_shadow_c', $resist[0]+$resist[1]+$resist[2] );
			$this->add_value( 'res_shadow_b', $resist[1] );
			$this->add_value( 'res_shadow_d', $resist[2] );

			$resist = explode(':',$main_res['Nature']);
			$this->add_value( 'res_nature', $resist[0] );
			$this->add_value( 'res_nature_c', $resist[0]+$resist[1]+$resist[2] );
			$this->add_value( 'res_nature_b', $resist[1] );
			$this->add_value( 'res_nature_d', $resist[2] );

			unset($main_res,$resist);
		}
		// END RESISTS

		$this->add_value( 'level', $data['Level'] );
		$this->add_value( 'server', $data['Server'] );

		if( isset($data['TalentPoints']) )
			$this->add_value( 'talent_points', $data['TalentPoints'] );

		$this->add_value( 'money_c', $data['Money']['Copper'] );
		$this->add_value( 'money_s', $data['Money']['Silver'] );
		$this->add_value( 'money_g', $data['Money']['Gold'] );

		$this->add_value( 'exp', $data['Experience'] );
		$this->add_value( 'race', $data['Race'] );
		$this->add_value( 'class', $data['Class'] );
		$this->add_value( 'health', $data['Health'] );
		$this->add_value( 'mana', $data['Mana'] );
		$this->add_value( 'sex', $data['Sex'] );
		$this->add_value( 'hearth', $data['Hearth'] );

		if( !empty($data['timestamp']['init']['DateUTC']) )
		{
			list($year,$month,$day,$hour,$minute,$second) = sscanf($data['timestamp']['init']['DateUTC'],"%4s-%2s-%2s %2s:%2s:%2s");
			$this->add_value( 'dateupdatedutc', "$month/$day/".substr($year,2,2)." $hour:$minute:$second" );
		}

		$this->add_value( 'CPversion', $data['DBversion'] );

		if ($data['TimePlayed'] < 0 )
		{
			$this->setMessage('<li>TimePlayed Null, Not updating</li>');
		}
		else
		{
			$this->add_value( 'timeplayed', $data['TimePlayed'] );
		}

		if ($data['TimeLevelPlayed'] < 0 )
		{
			$this->setMessage('<li>TimeLevelPlayed Null, Not updating</li>');
		}
		else
		{
			$this->add_value( 'timelevelplayed', $data['TimeLevelPlayed'] );
		}

		// Capture mailbox update time/date
		if( isset($data['timestamp']['MailBox']) )
			$this->add_value( 'maildateutc', date('m/d/y H:i:s',$data['timestamp']['MailBox']) );

		if( is_array($data['Attributes']['Melee']) )
		{
			$attack = $data['Attributes']['Melee'];

			if( isset($attack['AttackPower']) )
			{
				$power = explode(':',$attack['AttackPower']);
				$this->add_value( 'melee_power', $power[0]+$power[1]+$power[2] );
				unset($power);
			}
			if( isset($attack['MainHand']['AttackSkill']) )
				$this->add_value( 'melee_rating', $attack['MainHand']['AttackSkill'] );
			if( isset($attack['MainHand']['DamageRange']) )
				$this->add_value( 'melee_range', $attack['MainHand']['DamageRange'] );
			if( isset($attack['DamageRangeTooltip']) )
				$this->add_value( 'melee_range_tooltip', $this->tooltip( $attack['DamageRangeTooltip'] ) );
			if( isset($attack['AttackPowerTooltip']) )
				$this->add_value( 'melee_power_tooltip', $this->tooltip( $attack['AttackPowerTooltip'] ) );
			unset($attack);
		}

		if( is_array($data['Attributes']['Ranged']) )
		{
			$attack = $data['Attributes']['Ranged'];

			if( isset($attack['AttackPower']) )
			{
				$power = explode(':',$attack['AttackPower']);
				$this->add_value( 'ranged_power', $power[0]+$power[1]+$power[2] );
				unset($power);
			}
			if( isset($attack['AttackSkill']) )
				$this->add_value( 'ranged_rating', $attack['AttackSkill'] );
			if( isset($attack['DamageRange']) )
				$this->add_value( 'ranged_range', $attack['DamageRange'] );
			if( isset($attack['DamageRangeTooltip']) )
				$this->add_value( 'ranged_range_tooltip', $this->tooltip( $attack['DamageRangeTooltip'] ) );
			if( isset($attack['AttackPowerTooltip']) )
				$this->add_value( 'ranged_power_tooltip', $this->tooltip( $attack['AttackPowerTooltip'] ) );
			unset($attack);
		}

		// Capture client language
		$this->add_value( 'clientLocale', $data['Locale'] );

		$this->setMessage('<li>About to update player</li>');

		if( $update )
		{
			$querystr = "UPDATE `".ROSTER_PLAYERSTABLE."` SET ".$this->assignstr." WHERE `member_id` = '$memberId'";
		}
		else
		{
			$this->add_value( 'member_id', $memberId );
			$querystr = "INSERT INTO `".ROSTER_PLAYERSTABLE."` SET ".$this->assignstr;
		}

		$result = $this->query($querystr);
		if( !$result )
		{
			$this->setError('Cannot update Character Data',$this->error());
			return;
		}

		$this->do_equip( $data, $memberId );
		$this->do_inventory( $data, $memberId );
		$this->do_bank( $data, $memberId );
		$this->do_mailbox( $data, $memberId );
		$this->do_skills( $data, $memberId );
		$this->do_recipes( $data, $memberId );
		$this->do_spellbook( $data, $memberId );
		$this->do_talents( $data, $memberId );
		$this->do_reputation( $data, $memberId );
		$this->do_quests( $data, $memberId );
		$this->do_buffs( $data, $memberId );

		// Adding pet info
		if( !empty( $data['Pets'] ) )
		{
			$querystr = "DELETE FROM `".ROSTER_PETSTABLE."` WHERE `member_id` = '$memberId'";
			$result = $this->query($querystr);
			if( !$result )
			{
				$this->setError('Cannot delete Pet Data',$this->error());
			}

			$petsdata = $data['Pets'];
			foreach( array_keys( $petsdata ) as $pet )
			{
				$petinfo = $petsdata[$pet];
				//print_r( $petinfo );
				//print '</pre>';
				$this->update_pets( $memberId, $petinfo );
			}
		}

		// built in Auth system
		if( isset( $data['Roster'] ) )
		{
			$rosterdata = $data['Roster'];
			$this->update_account( $memberId, $name, $rosterdata);
		}
	} //-END function update_char()

} //-END CLASS

$wowdb = new wowdb;
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: tradeskills.php 603 2007-02-14 07:37:56Z zanix $
 * Completely rewritten by vgjunkie 2006-09-14
 *
 ******************************/

require_once( 'settings.php' );

//---[ Check for Guild Info ]------------
if( empty($guild_info) )
{
	message_die( $wordings[$roster_conf['roster_lang']]['nodata'] );
}

$header_title = $wordings[$roster_conf['roster_lang']]['professions'];
include_once(ROSTER_BASE.'roster_header.tpl');


// Get guild_id from guild info check above
$guildId = $guild_info['guild_id'];

include_once(ROSTER_BASE.'lib'.DIR_SEP.'menu.php');

// Build a list of "Skills" to look for
$inClause = "'";
foreach( $roster_conf['multilanguages'] as $lang )
{
	$inClause .= implode("', '",$tsArray[$lang]);
}
$inClause .= "'";

// If we don't want to show skills with a "1" value, uncomment this line (make option in config?)
$showNewSkill = " AND SUBSTRING_INDEX( s.skill_level, ':', 1 ) > 1 ";

// Gather a list of players that have the skills we are looking for
$query = "SELECT `s`.*, `p`.`name`, `p`.`clientLocale` FROM `".ROSTER_SKILLSTABLE."` s, `".ROSTER_PLAYERSTABLE."` p
	WHERE p.member_id = s.member_id
	AND p.guild_id = '".$guildId."'
	$showNewSkill
	AND skill_name IN ($inClause)
	ORDER BY s.skill_type,s.skill_name,(mid(skill_level FROM 1 FOR (locate(':', skill_level)-1)) + 0) DESC, p.name;";

//print $query;

$result = $wowdb->query($query) or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__,$query);


############################### START OUTPUT ##############################

// Counter for row striping
$striping_counter = 0;
$last_value = 'some obscurely random string to keep me lazy.';


if( $wowdb->num_rows($result) )
{
	$id = 0;
	while( $row = $wowdb->fetch_assoc($result) )
	{
		$skill_name = $row['skill_name'];
		$skill_image = 'Interface/Icons/'.$wordings[$row['clientLocale']]['ts_iconArray'][$skill_name];
		$skill_image = '<div style="display:inline;float:left;"><img width="17" height="17" src="'.$roster_conf['interface_url'].$skill_image.'.'.$roster_conf['img_suffix'].'" alt="" /></div>';
		$skill_output = '<div style="cursor:pointer;width:370px;" onclick="showHide(\'table_'.$id.'\',\'img_'.$id.'\',\''.$roster_conf['img_url'].'minus.gif\',\''.$roster_conf['img_url'].'plus.gif\');">
	'.$skill_image.'
	<div style="display:inline;float:right;"><img id="img_'.$id.'" src="'.$roster_conf['img_url'].'minus.gif" alt="" /></div>
'.$skill_name.'</div>';

		if( $last_value != $skill_name )
		{
			if( $striping_counter )
			{
				print '</table>';
				print border('sgray','end');
				print '<br />';
			}

			print border('sgray','start',$skill_output);
			print ('
<table border="0" cellpadding="0" cellspacing="0" class="bodyline" id="table_'.$id.'">
	<tr>
		<th class="membersHeader">'.$wordings[$roster_conf['roster_lang']]['level'].'</th>
		<th class="membersHeaderRight" width="150">'.$wordings[$roster_conf['roster_lang']]['name'].'</th>
	</tr>
');

			$striping_counter = 0;
			$last_value = $skill_name;
		}

		// Increment counter so rows are colored alternately
		$stripe_counter = ( ( $striping_counter++ % 2 ) + 1 );
		$stripe_class = 'membersRow'.$stripe_counter;
		$stripe_class_right =  'membersRowRight'.$stripe_counter;

		// Setup some user row data
		$level_array = explode (':',$row['skill_level']);
		$levelpct = $level_array[0] / $level_array[1] * 100 ;
		settype( $levelpct, 'integer' );

		if ( !$levelpct )
		{
			$levelpct = 1;
		}

		print  ('
	<tr>
	<td class="'.$stripe_class.'">
		<div class="levelbarParent" style="width:200px;">
			<div class="levelbarChild">'.$level_array[0].'/'.$level_array[1].'</div>
		</div>
		<table class="expOutline" border="0" cellpadding="0" cellspacing="0" width="100%">
			<tr>
				<td style="background-image: url(\''.$roster_conf['img_url'].'expbar-var2.gif\');" width="'.$levelpct.'%">
					<img src="'.$roster_conf['img_url'].'pixel.gif" height="14" width="1" alt="">
				</td>
				<td width="'.(100-$levelpct).'%"></td>
			</tr>
		</table>
	</td>
	<td class="'.$stripe_class_right.'">
		<a href="char.php?name='.$row['name'].'&amp;server='.$roster_conf['server_name'].'&amp;action=recipes">'.$row['name'].'</a>
	</td>
	</tr>
');
		$id++;
	}

	print '</table>';
	print border('sgray','end');
	print '<br />';
}

include_once(ROSTER_BASE.'roster_footer.tpl');

?>
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: skill.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

if ( !defined('ROSTER_INSTALLED') )
{
    exit('Detected invalid access to this file!');
}

class skill
{
  var $data;

  function skill( $data )
  {
    $this->data = $data;
  }

  function get( $field )
  {
    return $this->data[$field];
  }

  function outHeader()
  {
    return '<div class="skilltype">'.$this->data['skill_type'].' </div>';
  }
  function out()
  {
  	global $roster_conf;

    list($level, $max) = explode( ':', $this->data['skill_level'] );
    if( $max == 1 )
    {
      $bgImage = $roster_conf['img_url'].'bargrey.gif';
    }
    else
    {
      $bgImage = $roster_conf['img_url'].'barempty.gif';
    }

    $returnstring = '
<div class="skill">
  <div class="skillbox">
    <img class="bg" alt="" src="'.$bgImage.'" />';
    if( $max > 1 )
    {
      $width = intval(($level/$max) * 354);
      $returnstring .= '<img src="'.$roster_conf['img_url'].'barbit.gif" alt="" class="bit" width="'.$width.'" />';
    }

    $returnstring .= '
    <span class="name">'.$this->data['skill_name'].'</span>';

    if( $max > 1 )
    {
      $returnstring .= '<span class="level">'.$level.'/'.$max.'</span>';
    }
    $returnstring .= '
  </div>
</div>
';


#      echo '<img class="bgGrey" src="'.$roster_conf['img_url'].'bargrey.gif" />';
#    } else {
#      echo '<img class="bgGrey" src="'.$roster_conf['img_url'].'bargrey.gif" />';
#    }
#    echo '<div class="skill">'.$this->data['skill_name'].": ".$this->data['skill_level']."</div>\n";

		return $returnstring;
  }
}

function skill_get_many_by_type( $member_id, $type )
{
  global $wowdb;
  $type = $wowdb->escape( $type );

  return skill_get_many( $member_id, "`skill_type` = '$type'" );
}

function skill_get_many_by_order( $member_id, $order )
{
  global $wowdb;
  $order = $wowdb->escape( $order );

  return skill_get_many( $member_id, "`skill_order` = '$order'" );
}

function skill_get_many( $member_id, $search )
{
  global $wowdb;

  if (isset($char))
  {
  	$char = $wowdb->escape( $char );
  }
  if (isset($server))
  {
  	$server = $wowdb->escape( $server );
  }
  $query= "SELECT * FROM `".ROSTER_SKILLSTABLE."` WHERE `member_id` = '$member_id' AND $search";

  $result = $wowdb->query( $query );

  $skills = array();
  while( $data = $wowdb->fetch_assoc( $result ) )
  {
    $skill = new skill( $data );
    $skills[] = $skill;
  }
  return $skills;
}
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: settings.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

if( eregi(basename(__FILE__),$_SERVER['PHP_SELF']) )
{
	die("You can't access this file directly!");
}

/**
 * Set PHP error reporting
 */
error_reporting(E_ALL ^ E_NOTICE);



// Be paranoid with passed vars
// Destroy GET/POST/Cookie variables from the global scope
if (intval(ini_get('register_globals')) != 0)
{
	foreach ($_REQUEST AS $key => $val)
	{
		if (isset($$key))
			unset($$key);
	}
}


/**
 * Begin Roster Timing
 */
$starttime = explode(' ', microtime() );
define('ROSTER_STARTTIME',$starttime[1] + $starttime[0]);



/**
 * OS specific Directory Seperator
 */
define('DIR_SEP',DIRECTORY_SEPARATOR);

/**
 * Get the url
 */
$url = explode('/','http://'.$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']);
array_pop($url);

/**
 * URL to roster's root directory
 */
define('ROSTER_URL',implode('/',$url));


/**
 * Base, absolute roster directory
 */
define('ROSTER_BASE',dirname(__FILE__).DIR_SEP);


/**
 * Base, absolute roster library directory
 */
define('ROSTER_LIB',ROSTER_BASE.'lib'.DIR_SEP);


/**
 * Base, absolute roster admin directory
 */
define('ROSTER_ADMIN',ROSTER_BASE.'admin'.DIR_SEP);


/**
 * Base, absolute roster addons directory
 */
define('ROSTER_ADDONS',ROSTER_BASE.'addons'.DIR_SEP);


/**
 * Full path to roster config file
 */
define('ROSTER_CONF_FILE',ROSTER_BASE.'conf.php');


/**
 * If conf.php is not found, then die to installer link
 */
if ( !file_exists(ROSTER_CONF_FILE) )
{
    exit("<center>Roster is not installed<br />\n<a href=\"install.php\">INSTALL</a></center>");
}
else
{
	require_once (ROSTER_CONF_FILE);
}


/**
 * If ROSTER_INSTALLED is not defined, then die to installer link
 */
if ( !defined('ROSTER_INSTALLED') )
{
    exit("<center>Roster is not installed<br />\n<a href=\"install.php\">INSTALL</a></center>");
}

/**
 * Include roster db file
 */
require_once (ROSTER_LIB.'wowdb.php');



/**
 * Establish our connection and select our database
 */
$roster_dblink = $wowdb->connect($db_host, $db_user, $db_passwd, $db_name);
if( !$roster_dblink )
{
	die(basename(__FILE__).': line['.(__LINE__).']<br />'.'Could not connect to database "'.$db_name.'"<br />MySQL said:<br />'.$wowdb->error());
}


/**
 * NULL DB Connect Info for Safety
 */
$db_user = null;
$db_passwd = null;


/**
 * Include constants file
 */
require_once (ROSTER_LIB.'constants.php');



/**
 * Include common functions
 **/
require_once (ROSTER_LIB.'commonfunctions.lib.php');


/**
 * Slash global data if magic_quotes_gpc is off.
 */
if ( !get_magic_quotes_gpc() )
{
	$_GET = escape_array($_GET);
	$_POST = escape_array($_POST);
	$_COOKIE = escape_array($_COOKIE);
	$_REQUEST = escape_array($_REQUEST);
}


/**
 * Get the current config values
 */
$sql = "SELECT `config_name`, `config_value` FROM `".ROSTER_CONFIGTABLE."` ORDER BY `id` ASC;";
$results = $wowdb->query($sql);

if( !$results || $wowdb->num_rows($results) == 0 )
{
	die("Cannot get roster configuration from database<br />\nMySQL Said: ".$wowdb->error()."<br /><br />\nYou might not have roster installed<br />\n<a href=\"install.php\">INSTALL</a>");
}

/**
 * Fill the config array with values
 */
while( $row = $wowdb->fetch_assoc($results) )
{
	$roster_conf[$row['config_name']] = stripslashes($row['config_value']);
}
$wowdb->free_result($results);


/**
 * Set SQL debug value
 */
$wowdb->setSQLDebug($roster_conf['sqldebug']);



/**
 * Include locale files
 */
include(ROSTER_BASE.'localization'.DIR_SEP.'languages.php');


/**
 * If the version doesnt match the one in constants, redirect to upgrader
 */
if( empty($roster_conf['version']) || $roster_conf['version'] < ROSTER_VERSION )
{
	message_die('Looks like you\'ve loaded a new version of Roster<br />
<br />
Your Version: <span class="red">'.$roster_conf['version'].'</span><br />
New Version: <span class="green">'.ROSTER_VERSION.'</span><br />
<br />
<a href="upgrade.php" style="border:1px outset white;padding:2px 6px 2px 6px;">UPGRADE</a>','Upgrade Roster','sred');
}


/**
 * If the install directory or files exist, die()
 */
if( file_exists(ROSTER_BASE.'install.php') ||  file_exists(ROSTER_BASE.'install') || file_exists(ROSTER_BASE.'upgrade.php') )
{
	if( !file_exists(ROSTER_BASE.'version_match.php') )
	{
		message_die('Please remove the files <span class="green">install.php</span>, <span class="green">upgrade.php</span> and the folder <span class="green">/install/</span> in this directory','Remove Install Files','sred');
	}
}



/**
 * Include roster Login class
 */
require_once(ROSTER_LIB.'login.php');


/**
 * Get guild data from dataabse
 */
$guild_info = $wowdb->get_guild_info($roster_conf['server_name'],$roster_conf['guild_name']);
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: search_thot.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

if ( !defined('ROSTER_INSTALLED') )
{
    exit('Detected invalid access to this file!');
}

?>
<!-- BEGIN THOT SEARCH BOX -->
<?php print border('sblue','start'); ?>
<table cellspacing="0" cellpadding="4" border="0" class="bodyline">
  <tr>
    <td valign="middle" class="membersRowRight1">
      <div align="center">
        <img src="<?php print $roster_conf['img_url']; ?>thottbot.gif" alt="Thottbot" width="158" height="51" /><br />
        <br />
      <form method="post" action="http://www.thottbot.com/">
          <?php print $wordings[$roster_conf['roster_lang']]['search'] ?>:
          <input type="text" name="s" class="wowinput" />&nbsp;&nbsp;
          <input class="liteoption" type="submit" value="Go" onclick="win=window.open('','myWin',''); this.form.target='myWin'">
      </form>
      </div></td>
  </tr>
</table>
<?php print border('sblue','end'); ?>
<!-- END THOT SEARCH BOX -->
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: search_alla.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

if ( !defined('ROSTER_INSTALLED') )
{
    exit('Detected invalid access to this file!');
}

?>
<!-- BEGIN THOT SEARCH BOX -->
<?php print border('sorange','start'); ?>
<table cellspacing="0" cellpadding="4" border="0" class="bodyline">
  <tr>
    <td valign="middle" class="membersRowRight1">
      <div align="center">
        <img src="http://wow.allakhazam.com/images/wowex.png" alt="Allakhazam" width="158" height="51" /><br />
        <br />
      <form method="get" action="http://wow.allakhazam.com/search.html">
          <?php print $wordings[$roster_conf['roster_lang']]['search'] ?>:
          <input type="text" name="q" class="wowinput" />&nbsp;&nbsp;
          <input type="submit" value="Go" onclick="win=window.open('','myWin',''); this.form.target='myWin'">
      </form>
      </div></td>
  </tr>
</table>
<?php print border('sorange','end'); ?>
<!-- END THOT SEARCH BOX -->
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: search.php 603 2007-02-14 07:37:56Z zanix $
 *
 ******************************/

if ( !defined('ROSTER_INSTALLED') )
{
    exit('Detected invalid access to this file!');
}

require_once ROSTER_LIB.'item.php';
require_once ROSTER_LIB.'recipes.php';


//---[ Check for Guild Info ]------------
if( empty($guild_info) )
{
	message_die( $wordings[$roster_conf['roster_lang']]['nodata'] );
}
// Get guild info from guild info check above
$guildId = $guild_info['guild_id'];



include_once(ROSTER_LIB.'menu.php');
print "<br />\n";

if (isset($_GET['s']))
{
	$inputbox_value = $_GET['s'];
}
?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>">
  <?php print $wordings[$roster_conf['roster_lang']]['find'] ?>:<br />
  <input type="text" name="s" value="<?php print $inputbox_value; ?>" size="30" maxlength="30">
  <input type="submit" value="search">
</form>

<?php
if (isset($_GET['s']))
{
	// Set a ank for link to top of page
	echo '<a name="top">&nbsp;</a>
<div style="color:white;text-align;center">
  <a href="#items">'.$wordings[$roster_conf['roster_lang']]['items'].'</a>
  - <a href="#recipes">'.$wordings[$roster_conf['roster_lang']]['recipes'].'</a>
</div><br /><br />';

	$search = $_GET['s'];
	print border('sgray','start','<a name="items"></a><a href="#top">'.$wordings[$roster_conf['roster_lang']]['items'].'</a>').
		'<table cellpadding="0" cellspacing="0" width="600" class="bodyline">
  <tr>
    <td>';
	$query="SELECT players.name,players.server,items.* FROM `".ROSTER_ITEMSTABLE."` items,`".ROSTER_PLAYERSTABLE."` players WHERE items.member_id = players.member_id AND items.item_name LIKE '%$search%' ORDER BY players.name ASC";
	$result = $wowdb->query( $query );

	if( $wowdb->num_rows($result) != 0 )
	{
		$cid = '';
		$rc = 0;
		while ($data = $wowdb->fetch_assoc( $result ))
		{
			$row_st = (($rc%2)+1);
			$char_url = 'char.php?name='.$data['name'].'&amp;server='.$data['server'];

			if ( $cid != $data['member_id'] )
			{
				if ( $cid != '' )
				{
					print "</table>\n<br />\n";
				}
				print '<table cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <th colspan="2" class="membersRowRight2"><div style="font-size:12px;" align="center"><a href="'.$char_url.'">'.$data['name'].'</a></div></th>
  </tr>';
			}

			print '  <tr>
    <td width="45" valign="top" class="membersRow'.$row_st.'">';
			$item = new item($data);
			echo $item->out();
			print "</td>\n";
			print '    <td valign="middle" class="membersRowRight'.$row_st.'" style="white-space:normal;">';

			$first_line = true;
			$tooltip_out = '';
			$data['item_tooltip'] = stripslashes($data['item_tooltip']);
			foreach (explode("\n", $data['item_tooltip']) as $line )
			{
				$color = '';

				if( !empty($line) )
				{
					$line = preg_replace('|\\>|','&#8250;', $line );
					$line = preg_replace('|\\<|','&#8249;', $line );
					$line = preg_replace('|\|c[a-f0-9]{2}([a-f0-9]{6})(.+?)\|r|','<span style="color:#$1;">$2</span>',$line);

					// Do this on the first line
					// This is performed when $caption_color is set
					if( $first_line )
					{
						if( $data['item_color'] == '' )
							$data['item_color'] = 'ffffff';

						if( strlen($data['item_color']) > 6 )
							$color = substr( $data['item_color'], 2, 6 ) . ';font-size:12px;font-weight:bold';
						else
							$color = $data['item_color'] . ';font-size:12px;font-weight:bold';

						$first_line = false;
					}
					else
					{
						if ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_use'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_requires'],$line) )
							$color = 'ff0000;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_reinforced'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_equip'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_chance'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_enchant'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_soulbound'],$line) )
							$color = '00bbff;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_set'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( preg_match('|\([a-f0-9]\).'.$wordings[$roster_conf['roster_lang']]['tooltip_set'].'|',$line) )
							$color = '666666;font-size:10px';
						elseif ( ereg('^\\"',$line) )
							$color = 'ffd517;font-size:10px';
					}

					// Convert tabs to a formated table
					if( strpos($line,"\t") )
					{
						$line = str_replace("\t",'</td><td align="right" class="overlib_maintext">', $line);
						$line = '<table width="100%" cellspacing="0" cellpadding="0"><tr><td class="overlib_maintext">'.$line.'</td></tr></table>';
						$tooltip_out .= $line;
					}
					elseif( !empty($color) )
					{
						$tooltip_out .= '<span style="color:#'.$color.';">'.$line.'</span><br />';
					}
					else
					{
						$tooltip_out .= "$line<br />";
					}
				}
				else
				{
					$tooltip_out .= '<br />';
				}
			}
			print $tooltip_out;
			print "</td>\n  </tr>\n";
			$cid = $data['member_id'];
			$rc++;
		}

		if ( $cid != '' )
		{
			print "</table>\n";
		}
	}
	else
	{
		print '<table cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td class="membersRowRight1">No '.$wordings[$roster_conf['roster_lang']]['items'].'</td>
  </tr>'."</table>\n";
	}


	print "</td></tr></table>".border('sgray','end');

	print "<br />\n";

	print border('sgray','start','<a name="recipes"></a><a href="#top">'.$wordings[$roster_conf['roster_lang']]['recipes'].'</a>').
		'<table cellpadding="0" cellspacing="0" width="600" class="bodyline">
<tr>
  <td>';
	//$query="SELECT players.name,players.server,recipes.* FROM recipes,players WHERE recipes.member_id = players.member_id AND recipes.recipe_name LIKE '%$search%' OR recipes.recipe_tooltip LIKE '%$search%' OR recipes.reagents LIKE '%$search%' ORDER BY players.name ASC, recipes.recipe_name ASC";
	$query="SELECT players.name,players.server,recipes.* FROM `".ROSTER_RECIPESTABLE."` recipes,`".ROSTER_PLAYERSTABLE."` players WHERE recipes.member_id = players.member_id AND recipes.recipe_name LIKE '%$search%' ORDER BY players.name ASC, recipes.recipe_name ASC";
	$result = $wowdb->query( $query );

	if( $wowdb->num_rows($result) != 0 )
	{
		$cid = '';
	//name | server | member_id | recipe_name | skill_name | difficulty | reagents | recipe_texture | recipe_tooltip
		$rc = 0;
		while ($data = $wowdb->fetch_assoc( $result ))
		{
			$row_st = (($rc%2)+1);

			$char_url = 'char.php?name='.$data['name'].'&amp;server='.$data['server'].'&amp;action=recipes';
			if ( $cid != $data['member_id'] )
			{
				if ( $cid != '' )
				{
					print "</table>\n<br />\n";
				}
				print '<table border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <th colspan="3" class="membersRowRight1"><div style="font-size:12px;" align="center"><a href="'.$char_url.'">'.$data['name'].'</a></div></th>
  </tr>
  <tr>
    <th colspan="2" class="membersHeader">'.$wordings[$roster_conf['roster_lang']]['item'].'</th>
    <th class="membersHeaderRight">'.$wordings[$roster_conf['roster_lang']]['reagents'].'</th>';
			}

			print '<tr><td width="45" valign="top" align="center" class="membersRow'.$row_st.'">';

			$recipe = new recipe($data);
			echo $recipe->out();
				print '</td>'."\n";
			print '<td valign="top" class="membersRow'.$row_st.'" style="white-space:normal;">';

			$first_line = true;
			$tooltip_out = '';
			$data['item_tooltip'] = stripslashes($data['recipe_tooltip']);
			foreach (explode("\n", $data['recipe_tooltip']) as $line )
			{
				$color = '';

				if( !empty($line) )
				{
					$line = preg_replace('|\\>|','&#8250;', $line );
					$line = preg_replace('|\\<|','&#8249;', $line );
					$line = preg_replace('|\|c[a-f0-9]{2}([a-f0-9]{6})(.+?)\|r|','<span style="color:#$1;">$2</span>',$line);

					// Do this on the first line
					// This is performed when $caption_color is set
					if( $first_line )
					{
						if( $data['item_color'] == '' )
							$data['item_color'] = 'ffffff';

						if( strlen($data['item_color']) > 6 )
							$color = substr( $data['item_color'], 2, 6 ) . ';font-size:12px;font-weight:bold';
						else
							$color = $data['item_color'] . ';font-size:12px;font-weight:bold';

						$first_line = false;
					}
					else
					{
						if ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_use'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_requires'],$line) )
							$color = 'ff0000;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_reinforced'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_equip'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_chance'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_enchant'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_soulbound'],$line) )
							$color = '00bbff;font-size:10px';
						elseif ( ereg('^'.$wordings[$roster_conf['roster_lang']]['tooltip_set'],$line) )
							$color = '00ff00;font-size:10px';
						elseif ( preg_match('|\([a-f0-9]\).'.$wordings[$roster_conf['roster_lang']]['tooltip_set'].'|',$line) )
							$color = '666666;font-size:10px';
						elseif ( ereg('^\\"',$line) )
							$color = 'ffd517;font-size:10px';
					}

					// Convert tabs to a formated table
					if( strpos($line,"\t") )
					{
						$line = str_replace("\t",'</td><td align="right" class="overlib_maintext">', $line);
						$line = '<table width="100%" cellspacing="0" cellpadding="0"><tr><td class="overlib_maintext">'.$line.'</td></tr></table>';
						$tooltip_out .= $line;
					}
					elseif( !empty($color) )
					{
						$tooltip_out .= '<span style="color:#'.$color.';">'.$line.'</span><br />';
					}
					else
					{
						$tooltip_out .= "$line<br />";
					}
				}
				else
				{
					$tooltip_out .= '<br />';
				}
			}
			print $tooltip_out;

			print '</td>'."\n".'<td class="membersRowRight'.$row_st.'" width="50%" valign="top">';
			echo "<span class=\"tooltipline\" style=\"color:#ffffff\">".$data['reagents']."</span><br /><br />";
			print "</td></tr>\n";
			$cid = $data['member_id'];
			$rc++;
		}

		if ( $cid != '' )
		{
			print "</table>\n";
		}
	}
	else
	{
		print '<table cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td class="membersRowRight1">No '.$wordings[$roster_conf['roster_lang']]['recipes'].'</td>
  </tr>'."</table>\n";
	}

	print "</td></tr></table>".border('sgray','end');
}
?>
<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2007
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: rosterdiag_sql.php 603 2007-02-14 07:37:56Z zanix $
 *
 * This file contains and applies all SQL fixes from BETA till SQL BUILD[2]
 ******************************/

// This number must increment
$SQLBuild = 2;
$config_array_fixes = array();



// ALWAYS KEEP THIS TO UPDATE THE DB VERSION
$config_array_fixes['roster_dbver'] = "UPDATE `".ROSTER_CONFIGTABLE."` SET
`config_value` = '$SQLBuild'
WHERE `config_name` = 'roster_dbver' LIMIT 1 ;";


$errors=0;
if( $roster_conf['roster_dbver'] < $SQLBuild )
{
	$errors = apply_sql_fixes();
}

if ( $errors )
{
	// Something went wrong, otherwise we would have had no output
	echo "<br />".border('sred','start','SQL UPDATE ERROR Build['.$SQLBuild.']').'
	<table width="300" class="bodyline" cellspacing="0">'.
	$errors.
	'</table>'.
	border('sred','end')."<br />";
}


function apply_sql_fixes()
{
	global $roster_conf, $config_array_fixes, $wowdb;
	$returnvalue = 0;

	foreach ($config_array_fixes as $config_array_fix => $config_array_query)
	{
		if (!$config_fix_result = $wowdb->query($config_array_query))
		{
			$returnvalue = '<tr>
												<td class="membersRow'.((($rowstripe=0)%2)+1).'">$roster_conf[\''.$config_array_fix.'\']</td>
												<td class="membersRowRight'.((($rowstripe)%2)+1).'">'.$wowdb->error().'</td>
											</tr>';
		}
	}
	return $returnvalue;
}

?>