<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * ExpressionEngine - by EllisLab
 *
 * @package		ExpressionEngine
 * @author		ExpressionEngine Dev Team
 * @copyright	Copyright (c) 2003 - 2011, EllisLab, Inc.
 * @license		http://expressionengine.com/user_guide/license.html
 * @link		http://expressionengine.com
 * @since		Version 2.0
 * @filesource
 */
 
// ------------------------------------------------------------------------

/**
 * ExpressionEngine IP To Nation Module
 *
 * @package		ExpressionEngine
 * @subpackage	Modules
 * @category	Update File
 * @author		ExpressionEngine Dev Team
 * @link		http://expressionengine.com
 */

class Ip_to_nation_upd {

	var $version = '2.3';

	/**
	  * Constructor
	  */
	function Ip_to_nation_upd()
	{
		// Make a local reference to the ExpressionEngine super object
		$this->EE =& get_instance();
		$this->EE->load->dbforge();
	}

	// --------------------------------------------------------------------

	/**
	 * Module Installer
	 *
	 * @access	public
	 * @return	bool
	 */
	function install()
	{
		if ( ! include_once($this->_ee_path.'modules/ip_to_nation/iptonation.php'))
		{
			$this->EE->lang->loadfile('ip_to_nation');
			show_error($this->EE->lang->line('iptonation_missing'));
		}

		$this->EE->dbforge->drop_table('ip2nation');

		$fields = array(
						'ip'	=> array(
													'type'			=> 'int',
													'constraint'	=> 11,
													'null'			=> FALSE,
													'default'		=> 0,
													'unsigned'		=> TRUE
												),
						'country'  => array(
													'type' 			=> 'char',
													'constraint'	=> 2,
													'null'			=> FALSE,
													'default'		=> ''
												),
		);

		$this->EE->dbforge->add_field('id');
		$this->EE->dbforge->add_field($fields);
		$this->EE->dbforge->add_key('ip');
		$this->EE->dbforge->create_table('ip2nation');

		$this->EE->dbforge->drop_table('ip2nation_countries');

		$fields = array(
						'code'	=> array(
													'type'			=> 'varchar',
													'constraint'	=> 2,
													'null'			=> FALSE,
													'default'		=> ''
												),
						'banned'  => array(
													'type' 			=> 'varchar',
													'constraint'	=> 1,
													'null'			=> FALSE,
													'default'		=> 'n'
												),
		);

		$this->EE->dbforge->add_field($fields);
		$this->EE->dbforge->add_key('code', TRUE);
		$this->EE->dbforge->create_table('ip2nation_countries');

		$data = array(
			'module_name' 	 => 'Ip_to_nation',
			'module_version' => $this->version,
			'has_cp_backend' => 'y'
		);

		$this->EE->db->insert('modules', $data);

		// Insert the massive number of records

		for ($i = 0, $total = count($cc); $i < $total; $i = $i + 100)
		{
			$this->EE->db->query("INSERT INTO exp_ip2nation_countries (code) VALUES ('".implode("'), ('", array_slice($cc, $i, 100))."')");
		}

		for ($i = 0, $total = count($ip); $i < $total; $i = $i + 100)
		{
			$this->EE->db->query("INSERT INTO exp_ip2nation (ip, country) VALUES (".implode("), (", array_slice($ip, $i, 100)).")");
		}

		$this->EE->config->_update_config(array('ip2nation' => 'y', 'ip2nation_db_date' => 1290177198));

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * Module Uninstaller
	 *
	 * @access	public
	 * @return	bool
	 */
	function uninstall()
	{
		$this->EE->db->select('module_id');
		$query = $this->EE->db->get_where('modules', array('module_name' => 'Ip_to_nation'));
		$module_id_row = $query->row();
		$module_id = $module_id_row->module_id;

		$this->EE->db->where('module_id', $module_id);
		$this->EE->db->delete('module_member_groups');

		$this->EE->db->where('module_name', 'Ip_to_nation');
		$this->EE->db->delete('modules');

		$this->EE->db->where('class', 'Ip_to_nation');
		$this->EE->db->delete('actions');

		$this->EE->db->where('class', 'Ip_to_nation');
		$this->EE->db->delete('actions');

		$this->EE->dbforge->drop_table('ip2nation');
		$this->EE->dbforge->drop_table('ip2nation_countries');

		//  Remove a couple items from the file
		
		$this->EE->config->_update_config(array(), array('ip2nation' => '', 'ip2nation_db_date' => ''));

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * Module Updater
	 *
	 * @access	public
	 * @return	bool
	 */
	function update($current='')
	{
		if ($current == '' OR $current == $this->version)
		{
			return FALSE;
		}

		if ($current < 2.0)
		{
			// can't use this column as a Primary Key because the ip2nation db has duplicate values in the ip column ::sigh::
//			$this->EE->db->query("ALTER TABLE `exp_ip2nation` DROP KEY `ip`");
//			$this->EE->db->query("ALTER TABLE `exp_ip2nation` ADD PRIMARY KEY `ip` (`ip`)");
			$this->EE->db->query("ALTER TABLE `exp_ip2nation_countries` DROP KEY `code`");
			$this->EE->db->query("ALTER TABLE `exp_ip2nation_countries` ADD PRIMARY KEY `code` (`code`)");
		}

		// Version 2.2 user data based on 02/27/2010 sql from ip2nation.com
		if ($current < 2.2)
		{
			if ( ! include_once($this->_ee_path.'modules/ip_to_nation/iptonation.php'))
			{
				$this->EE->lang->loadfile('ip_to_nation');
				show_error($this->EE->lang->line('iptonation_missing'));
			}

			// Fetch banned nations
			$query = $this->EE->db->get_where('ip2nation_countries', array('banned'=>'y'));

			// Truncate tables
			$this->EE->db->truncate('ip2nation_countries');
			$this->EE->db->truncate('ip2nation');

			// Re-insert the massive number of records
			for ($i = 0, $total = count($cc); $i < $total; $i = $i + 100)
			{
				$this->EE->db->query("INSERT INTO exp_ip2nation_countries (code) VALUES ('".implode("'), ('", array_slice($cc, $i, 100))."')");
			}

			for ($i = 0, $total = count($ip); $i < $total; $i = $i + 100)
			{
				$this->EE->db->query("INSERT INTO exp_ip2nation (ip, country) VALUES (".implode("), (", array_slice($ip, $i, 100)).")");
			}

			// update banned nations
			if ($query->num_rows() > 0)
			{
				foreach ($query->result_array() as $row)
				{
					$this->EE->db->query($this->EE->db->update_string('exp_ip2nation_countries', array('banned' => 'y'), array('code' => $row['code'])));
				}
			}
		}
		
		// Version 2.3 user data based on 11/19/2010 sql from ip2nation.com
		// Add dl date to config via $this->EE->localize->now which is 1290177198
		if ($current < 2.3)
		{
			if ( ! include_once($this->_ee_path.'modules/ip_to_nation/iptonation.php'))
			{
				$this->EE->lang->loadfile('ip_to_nation');
				show_error($this->EE->lang->line('iptonation_missing'));
			}

			// Fetch banned nations
			$query = $this->EE->db->get_where('ip2nation_countries', array('banned'=>'y'));

			// Truncate tables
			$this->EE->db->truncate('ip2nation_countries');
			$this->EE->db->truncate('ip2nation');

			// Re-insert the massive number of records
			for ($i = 0, $total = count($cc); $i < $total; $i = $i + 100)
			{
				$this->EE->db->query("INSERT INTO exp_ip2nation_countries (code) VALUES ('".implode("'), ('", array_slice($cc, $i, 100))."')");
			}

			for ($i = 0, $total = count($ip); $i < $total; $i = $i + 100)
			{
				$this->EE->db->query("INSERT INTO exp_ip2nation (ip, country) VALUES (".implode("), (", array_slice($ip, $i, 100)).")");
			}

			// update banned nations
			if ($query->num_rows() > 0)
			{
				foreach ($query->result_array() as $row)
				{
					$this->EE->db->query($this->EE->db->update_string('exp_ip2nation_countries', array('banned' => 'y'), array('code' => $row['code'])));
				}
			}
			
			$this->EE->config->_update_config(array('ip2nation_db_date' => 1290177198));
		}
		
		
		return TRUE;
	}

}
// END CLASS

/* End of file upd.ip_to_nation.php */
/* Location: ./system/expressionengine/modules/ip_to_nation/upd.ip_to_nation.php */