function run_upgrade()
{
global $db_prefix;
$info['name'] = 'tea_api';
$info['esam'] = 'esam_api';
$cs['GLOBAL_REQUIRED_API'] = array('tea_regreq', 1);
$cs['DISPLAY_EVE_NAME'] = array('tea_usecharname', 1);
$cs['ADD_CORP_TICKER'] = array('tea_custom_name', 1);
$cs['DISPLAY_EVE_PORTRAIT'] = array('tea_avatar_enabled', 1);
//$cs['DISPLAY_CORP_TITLES'] = array('tea_regreq', 1);
$check = esamup_check_table($db_prefix . $info['name']);
$esam = esamup_check_table($db_prefix . $info['esam']);
if ($check && $esam) {
// settings
$settings = esamup_select("SELECT NAME, VALUE FROM " . $db_prefix . "esam_settings");
if (!empty($settings)) {
foreach ($settings as $s) {
if (isset($cs[$s[0]]) && $s[1] == 'true') {
esamup_query("\n\t\t\t\t\t\tREPLACE INTO " . $db_prefix . "settings\n\t\t\t\t\t\t\t(variable, value)\n\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t('" . $cs[$s[0]][0] . "', '" . $cs[$s[0]][1] . "')");
}
}
}
// api's
$apis = esamup_select("SELECT ID_MEMBER, USER_ID, API_KEY FROM " . $db_prefix . "esam_api");
if (!empty($apis)) {
foreach ($apis as $api) {
esamup_query("\n\t\t\t\t\tREPLACE INTO " . $db_prefix . "tea_api\n\t\t\t\t\t\t(ID_MEMBER, userid, api)\n\t\t\t\t\tVALUES \n\t\t\t\t\t('" . $api[0] . "', '" . $api[1] . "', '" . $api[2] . "')");
}
}
// rules
$rules = esamup_select("SELECT ID_RULE, TYPE, ROLE, ROLE_ID, GROUP_ID, TITLE, SKILL_ID, SKILL_LVL FROM " . $db_prefix . "esam_rules");
if (!empty($rules)) {
global $sourcedir;
require_once $sourcedir . '/TEA_SkillDump.php';
$skills = getSkillArray();
foreach ($rules as $rule) {
$type = NULL;
$value = NULL;
$extra = NULL;
$id = esamup_select("SELECT ruleid FROM " . $db_prefix . "tea_rules ORDER BY ruleid DESC LIMIT 1");
if (!empty($id)) {
$id = $id[0][0] + 1;
} else {
$id = 1;
}
// elseif(is_numeric($_POST['id']))
// {
// $id = $_POST['id'];
// $exists = TRUE;
// }
// else
// die("error id");
$andor = 'AND';
//if($andor != "AND" && $andor != "OR")
// die("andor must be AND or OR");
$name = 'ESAM RULE ' . $rule[0];
// if($_POST['main'] == "main")
// $main = 1;
// else
$main = 0;
switch (strtoupper($rule[1])) {
case 'P':
// pilot rule, ignore entire rule
continue 2;
case 'C':
$type = "corp";
$value = $rule[3];
break;
case 'A':
$type = "alliance";
$value = $rule[3];
break;
case 'F':
$type = "militia";
switch ($rule[3]) {
case 500001:
$value = 'Caldari State';
break;
case 500002:
$value = 'Minmatar Republic';
break;
case 500003:
$value = 'Amarr Empire';
break;
case 500004:
$value = 'Gallente Federation';
break;
}
break;
default:
continue 2;
}
// if(isset($types[$_POST['type']]))
// $type = $_POST['type'];
// else
// die("Unknown Type");
// if($type == "corp" || $type == "alliance" || $type == "skill" || $type == "role" || $type == "title" || $type == "militia")
// $value = mysql_real_escape_string($_POST['value']);
// if($type == "skill")
$extra = '';
// if(isset($groups[$_POST['group']]))
$group = $rule[4];
// elseif(!$exists)
// die("Invalid Group");
//if(!$exists)
esamup_query("INSERT INTO " . $db_prefix . "tea_rules (ruleid, name, main, `group`, andor) VALUES ({$id}, '{$name}', {$main}, {$group}, '{$andor}')");
esamup_query("INSERT INTO " . $db_prefix . "tea_conditions (ruleid, type, value, extra) VALUES ({$id}, '{$type}', '{$value}', '{$extra}')");
//if(!isset($types[$_POST['type']]))
// error
//elseif(!is_numeric($_POST['id']) && $_POST['id'] != "new")
// error
//elseif(!is_numeric($_POST['group']))
// error
if ($rule[2] == 'roleDirector') {
$type = 'role';
$value = 'Director';
$extra = '';
esamup_query("INSERT INTO " . $db_prefix . "tea_conditions (ruleid, type, value, extra) VALUES ({$id}, '{$type}', '{$value}', '{$extra}')");
}
if ($rule[5] != 'null' && !empty($rule[5])) {
$type = 'title';
$value = $rule[5];
$extra = '';
esamup_query("INSERT INTO " . $db_prefix . "tea_conditions (ruleid, type, value, extra) VALUES ({$id}, '{$type}', '{$value}', '{$extra}')");
}
if (!empty($rule[6])) {
$type = 'skill';
$value = $skills[$rule[6]];
$extra = $rule[7];
esamup_query("INSERT INTO " . $db_prefix . "tea_conditions (ruleid, type, value, extra) VALUES ({$id}, '{$type}', '{$value}', '{$extra}')");
}
}
}
}
}
$tables[12]["id"] = "INT DEFAULT NULL AUTO_INCREMENT";
$tables[12]["smf"] = "INT DEFAULT 0";
$tables[12]["jabber"] = "VARCHAR(255) DEFAULT NULL";
$tables[12]["nf"] = "VARCHAR(255) DEFAULT NULL";
$info[13]['name'] = 'tea_jabber_groups';
$info[13]['primary'] = 'id';
$tables[13]["id"] = "VARCHAR(50) DEFAULT NULL";
$tables[13]["value"] = "INT(1) DEFAULT 1";
global $db_prefix;
require "esam_upgrade.php";
$esaminfo['old'] = 'eve_api';
$esaminfo['name'] = 'tea_api';
$esaminfo['esam'] = 'esam_api';
$checkold = esamup_check_table($db_prefix . $esaminfo['old']);
$check = esamup_check_table($db_prefix . $esaminfo['name']);
$esam = esamup_check_table($db_prefix . $esaminfo['esam']);
if (!$checkold && !$check && $esam) {
$esamupgrade = TRUE;
}
foreach ($tables as $i => $table) {
$checkold = tea_check_table($db_prefix . $info[$i]['old'], $table);
$check = tea_check_table($db_prefix . $info[$i]['name'], $table);
if (($checkold[0] || !$checkold[0] && $checkold[1]) && !$check[0] && !$check[1]) {
// if old table exists regardless of if needs changing and new doesnt then rename
tea_query("RENAME TABLE " . $db_prefix . $info[$i]['old'] . " TO " . $db_prefix . $info[$i]['name']);
}
$check = tea_check_table($db_prefix . $info[$i]['name'], $table);
if (!$check[0]) {
if ($check[1]) {
foreach ($check[1] as $f) {
tea_query("ALTER TABLE " . $db_prefix . $info[$i]['name'] . " ADD " . $f . " " . $table[$f]);
