<?php
/*
Plugin Name:  Affiliate Link Cloaker
Plugin URI:  http://www.brewsterware.com/affiliate-link-cloaker-wordpress-plugin.html
Version: 1.00.02
Description: Generates geo targetted cloaked affiliate links. Links can either be placed manually in the post/page content, or if a keyword/phrase is specified links will be inserted automatically.
Author: Joe Brewer
Author URI:  http://www.brewsterware.com/
*/

/*
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

// constants for the flag field in the link table
define('ALC_ACTIVE',         0x0001);
define('ALC_NOFOLLOW',       0x0002);
define('ALC_OPENNEWWINDOW',  0x0004);
define('ALC_COUNTREDIRECTS', 0x0008);

define('ALC_DEFAULTURLTRIGGER', 'recommends');

global $alc_db_version;
$alc_db_version = 2;

require_once('links.php');
require_once('redirect.php');
require_once('interface.php');

register_activation_hook(__FILE__, 'alc_install');
register_uninstall_hook(__FILE__, 'alc_uninstall');

/* run the upgrade function here for users that already have the
 * plugin installed and activated.
 */
alc_upgrade();

function alc_install()
{
	global $wpdb, $table_prefix;
	
	$tables["{$table_prefix}alc_link"] = "CREATE TABLE `{$table_prefix}alc_link` (
			`id` int(10) unsigned NOT NULL auto_increment,
			`redirectType` enum('300','301','302','303','307') NOT NULL default '302',
			`maxReplacements` smallint(5) unsigned NOT NULL default '0',
			`flags` tinyint(4) NOT NULL,
			`titleText` varchar(128) NOT NULL,
			`searchText` varchar(128) NOT NULL,
			`urlSuffix` varchar(128) NOT NULL,
			`replacementOrder` int(11) NOT NULL default '0',
			PRIMARY KEY (`id`),
			UNIQUE KEY `urlSuffix` (`urlSuffix`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";

	$tables["{$table_prefix}alc_address"] = "CREATE TABLE `{$table_prefix}alc_address` (
			`id` int(10) unsigned NOT NULL auto_increment,
			`linkId` int(10) unsigned NOT NULL,
			`default` enum('Yes','No') NOT NULL default 'No',
			`country` varchar(2) NOT NULL,
			`address` varchar(256) NOT NULL,
			PRIMARY KEY (`id`),
			KEY `linkId` (`linkId`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
	
	$tables["{$table_prefix}alc_redirectlog"] = "CREATE TABLE `{$table_prefix}alc_redirectlog` (
			`addressId` int(10) unsigned NOT NULL,
			`redirectDateTime` datetime NOT NULL
			) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	
	// create tables if they do not already exist
	foreach ($tables as $tableName => $tableDesign) {
		if ($wpdb->get_var("show tables like '$tableName'") != $tableName) {
			$wpdb->query($tableDesign);
		}
	}
	
	// run the upgrade function
	alc_upgrade();
	
	// do we need to add/set the url trigger ?
	if (!get_option('alc_url_trigger')) {
		add_option('alc_url_trigger', ALC_DEFAULTURLTRIGGER);
	}
}

function alc_uninstall()
{
	global $wpdb, $table_prefix;
	
	// remove data
	$wpdb->query("DELETE FROM {$table_prefix}alc_link");
	$wpdb->query("DELETE FROM {$table_prefix}alc_address");
	$wpdb->query("DELETE FROM {$table_prefix}alc_redirectlog");
	
	// remove db tables
	$wpdb->query("DROP TABLE {$table_prefix}alc_link");
	$wpdb->query("DROP TABLE {$table_prefix}alc_address");
	$wpdb->query("DROP TABLE {$table_prefix}alc_redirectlog");
	
	// remove options
	delete_option('alc_url_trigger');
	delete_option('alc_db_version');
}

function alc_upgrade()
{
	global $wpdb, $table_prefix, $alc_db_version;

	// TODO: dont run if the plugin is inactive..
	
	// dont try to upgrade if the tables are not installed
	if(!$wpdb->get_var("SHOW TABLES LIKE '{$table_prefix}alc_link'")) {
		return;
	}

	// get the current database version
	$currentDbVersion = (int)get_option('alc_db_version');
	
	// database updates
	$dbChanges = array();
	
	// version 2 change
	$dbChanges[2][] = "ALTER TABLE `{$table_prefix}alc_link` ADD `searchTextDelimiter` CHAR(1) NULL AFTER `searchText`;";
		
	// do we need to upgrade the database?
	if ($alc_db_version > $currentDbVersion) {
		// run through the upgrades version by version
		for ($version = $currentDbVersion ;
			 $version <= $alc_db_version ;
			 $version++) {
			// is this an array ?
			if (is_array($dbChanges[$version])) {
				// iterate through the changes for each version
				foreach ($dbChanges[$version] as $change) {
					if ($change) {
						$wpdb->query($change);
					}
				}
			}
		}
	
		// update the database version option
		update_option('alc_db_version', $alc_db_version);
	}
}

?>