<?php
/**
 * iLP System Patch 2.1.2 -> 2.2
 * 
 * Autor:		Florian "ApoY2k" Peschka
 * Projekt:		iLP System
 * Paket:		apoy2k.ilp.wrynn
 * Lizenz:		CreativeCommons (by-nc-sa)
 * Kontakt:		hide@address.com
 * Version:		2.2
 */
require_once('lib/lib.config.db.php');

try {
	$db->exec("RENAME TABLE `es_ilp_actionlog` TO `ilp_actionlog`");
	$db->exec("RENAME TABLE `es_ilp_config` TO `ilp_config`");
	$db->exec("RENAME TABLE `es_ilp_events` TO `ilp_events`");
	$db->exec("RENAME TABLE `es_ilp_event_attends` TO `ilp_event_attends`");
	$db->exec("RENAME TABLE `es_ilp_event_types` TO `ilp_event_types`");
	$db->exec("RENAME TABLE `es_ilp_itemcache` TO `ilp_itemcache`");
	$db->exec("RENAME TABLE `es_ilp_items` TO `ilp_items`");
	$db->exec("RENAME TABLE `es_ilp_loots` TO `ilp_loots`");
	$db->exec("RENAME TABLE `es_ilp_reqs` TO `ilp_reqs`");
	$db->exec("RENAME TABLE `es_ilp_req_types` TO `ilp_req_types`");
	$db->exec("RENAME TABLE `es_ilp_users` TO `ilp_users`");
	
	$db->exec("UPDATE `ilp_config` SET `config_value` = '20100505' WHERE `config_type` = 'ilpversion_releasedate'");
	$db->exec("UPDATE `ilp_config` SET `config_value` = '2.2' WHERE `config_type` = 'ilpversion_id'");
	$db->exec("ALTER TABLE  `ilp_config` CHANGE  `name`  `name_de` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL");
	$db->exec("ALTER TABLE  `ilp_itemcache` ADD  `name_en` VARCHAR(255) NOT NULL AFTER  `quality`");
	$db->exec("ALTER TABLE  `ilp_itemcache` ADD  `name_es` VARCHAR(255) NOT NULL AFTER  `name_de`");
	$db->exec("ALTER TABLE  `ilp_itemcache` ADD  `name_fr` VARCHAR(255) NOT NULL AFTER  `name_es`");
	$db->exec("ALTER TABLE  `ilp_itemcache` ADD  `name_ru` VARCHAR(255) NOT NULL AFTER  `name_fr`");
	
	echo 'Patch <b>OK</b>.';
}
catch (PDOException $e)
{
	$e->getMessage();
}

?>