public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_2201' => 'EQdkp Plus 2.2.0 Update 1', 1 => 'Alter member profilefields table'), 'german' => array('update_2201' => 'EQdkp Plus 2.2.0 Update 1', 'update_function' => 'Führe einige Updates wichtige updates durch', 1 => 'Ändere die Charakter Profilfeld-Tabelle'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__member_profilefields` ADD COLUMN `id` INT NOT NULL AUTO_INCREMENT FIRST, DROP PRIMARY KEY, ADD PRIMARY KEY (`id`);");
}
*/
if (!defined('EQDKP_INC')) {
header('HTTP/1.0 Not Found');
exit;
}
include_once registry::get_const('root_path') . 'maintenance/includes/sql_update_task.class.php';
if (!class_exists('update_raidlogimport_0602')) {
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_2202' => 'EQdkp Plus 2.2.0 Update 2', 1 => 'Alter notification_types table'), 'german' => array('update_2202' => 'EQdkp Plus 2.2.0 Update 2', 1 => 'Ändere die Benachrichtigungstypen-Tabelle'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__notification_types` CHANGE COLUMN `default` `default` VARCHAR(50) NOT NULL DEFAULT '0'");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_feedposter_032' => 'FeedPoster 0.3.2 Update Package', 1 => 'Alter FeedPoster Table', 2 => 'Alter FeedPoster Table'), 'german' => array('update_feedposter_032' => 'FeedPoster 0.3.2 Update Paket', 1 => 'Erweitere FeedPoster Tabelle', 2 => 'Erweitere FeedPoster Tabelle'));
$this->sqls = array(1 => 'ALTER TABLE `__plugin_feedposter_feeds` ADD COLUMN `removeHtml` TINYINT(1) UNSIGNED NOT NULL DEFAULT \'0\';', 2 => "ALTER TABLE `__plugin_feedposter_feeds` ADD COLUMN `errorMessage` VARCHAR(255) NULL COLLATE 'utf8_bin';");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_feedposter_020' => 'FeedPoster 0.2.0 Update Package', 1 => 'Alter FeedPoster Table', 2 => 'Alter FeedPoster Table'), 'german' => array('update_feedposter_020' => 'FeedPoster 0.2.0 Update Paket', 1 => 'Erweitere FeedPoster Tabelle', 2 => 'Erweitere FeedPoster Tabelle'));
$this->sqls = array(1 => 'ALTER TABLE `__plugin_feedposter_feeds` ADD COLUMN `featured` TINYINT(1) UNSIGNED NOT NULL DEFAULT \'0\';', 2 => 'ALTER TABLE `__plugin_feedposter_feeds` ADD COLUMN `showForDays` INT(11) UNSIGNED NOT NULL DEFAULT \'0\';');
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_shoutbox_031' => 'Shoutbox 0.3.1 Update Package', 'update_function' => 'Set new user or character setting', 1 => 'Insert new user or character setting', 2 => 'Change to user or character field'), 'german' => array('update_shoutbox_031' => 'Shoutbox 0.3.1 Update Paket', 'update_function' => 'Setze neue Benutzer oder Charakter Einstellung', 1 => 'Füge neuen Benutzer oder Charakter Einstellung hinzu', 2 => 'Ändere in Benutzer oder Charakter Eintrag'));
// init SQL querys
$this->sqls = array(1 => 'INSERT INTO `__backup_cnf` (config_name, config_value, config_plugin) VALUES(\'sb_use_users\', \'0\', \'shoutbox\');', 2 => 'ALTER TABLE `__shoutbox` CHANGE `member_id` `user_or_member_id` SMALLINT(5) NOT NULL DEFAULT \'-1\';');
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildbank_103' => 'Guild Banker 1.0.3 Update Package', 1 => 'Add table field for type to transaction table'), 'german' => array('update_guildbank_103' => 'Guild Banker 1.0.3 Update Paket', 1 => 'Add table field for type to transaction table'));
// init SQL querys
$this->sqls = array(1 => 'ALTER TABLE __guildbank_transactions ADD COLUMN `ta_type` tinyint(1) default 0 AFTER `ta_id`;');
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_shoutbox_031' => 'Shoutbox 0.3.1 Update Package', 'update_function' => 'Set new user or character setting', 2 => 'Change to user or character field'), 'german' => array('update_shoutbox_031' => 'Shoutbox 0.3.1 Update Paket', 'update_function' => 'Setze neue Benutzer oder Charakter Einstellung', 2 => 'Ändere in Benutzer oder Charakter Eintrag'));
// init SQL querys
$this->sqls = array(2 => 'ALTER TABLE `__shoutbox` CHANGE `member_id` `user_or_member_id` SMALLINT(5) NOT NULL DEFAULT \'-1\';');
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_shoutbox_033' => 'Shoutbox 0.3.3 Update Package', 'update_function' => 'Insert new max text length setting'), 'german' => array('update_shoutbox_033' => 'Shoutbox 0.3.3 Update Paket', 'update_function' => 'Füge Einstellung für die Maximale Textlänge hinzu'));
// init SQL querys
$this->sqls = array();
}
include_once registry::get_const('root_path') . 'maintenance/includes/sql_update_task.class.php';
if (!class_exists('update_raidlogimport_0600')) {
class update_raidlogimport_0600 extends sql_update_task
{
public static function __shortcuts()
{
$shortcuts = array('db', 'config');
return array_merge(parent::__shortcuts(), $shortcuts);
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildrequest_013' => 'GuildRequest 0.1.3 Update Package', 1 => 'Add help field'), 'german' => array('update_guildrequest_013' => 'GuildRequest 0.1.3 Update Paket', 1 => 'Füge Hilfe-Feld hinzu'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__guildrequest_fields` ADD COLUMN `help` TEXT COLLATE utf8_bin NULL;");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildbank_200' => 'Guild Banker 2.0.0 Update Package', 1 => 'Add auctions table', 2 => 'Add auction bid table', 3 => 'Add item shop table', 4 => 'Add auth option for guildbank admin auction management', 5 => 'Add auth option for guildbank auctions'), 'german' => array('update_guildbank_200' => 'Guild Banker 2.0.0 Update Paket', 1 => 'Füge Auktionstabelle hinzu', 2 => 'Füge Auktions-Bitertabelle hinzu', 3 => 'Fügt Verkaufstabelle hinzu', 4 => 'Fügt eine auth-Option für die Auktionsverwaltung im Adminbereich hinzu', 5 => 'Fügt eine auth-Option für die Auktionen hinzu'));
// init SQL querys
$this->sqls = array(1 => "CREATE TABLE IF NOT EXISTS __guildbank_auctions (\n\t\t\t\t\t\tauction_id mediumint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\tauction_item varchar(255) default NULL,\n\t\t\t\t\t\tauction_startdate int(11) default NULL,\n\t\t\t\t\t\tauction_duration int(11) default NULL,\n\t\t\t\t\t\tauction_bidsteps int(11) default NULL,\n\t\t\t\t\t\tauction_note varchar(255) default NULL,\n\t\t\t\t\t\tauction_startvalue int(11) default NULL,\n\t\t\t\t\t\tauction_raidattendance int(11) default NULL,\n\t\t\t\t\t\tauction_multidkppool int(11) default NULL,\n\t\t\t\t\t\tauction_active tinyint(1) default 0,\n\t\t\t\t\t\tPRIMARY KEY (auction_id)\n\t\t\t\t\t) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;", 2 => "CREATE TABLE IF NOT EXISTS __guildbank_auction_bids (\n\t\t\t\t\t\tbid_id mediumint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\tbid_auctionid int(11) default NULL,\n\t\t\t\t\t\tbid_date int(11) default NULL,\n\t\t\t\t\t\tbid_memberid int(11) default NULL,\n\t\t\t\t\t\tbid_bidvalue int(11) default NULL,\n\t\t\t\t\t\tPRIMARY KEY (bid_id)\n\t\t\t\t\t) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;", 3 => "CREATE TABLE IF NOT EXISTS __guildbank_shop_ta (\n\t\t\t\t\t\tst_id mediumint(8) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\tst_itemid mediumint(8) default 0,\n\t\t\t\t\t\tst_date int(11) default 0,\n\t\t\t\t\t\tst_value BIGINT(20) default 0,\n\t\t\t\t\t\tst_amount mediumint(8) default 0,\n\t\t\t\t\t\tst_buyer mediumint(8) default 0,\n\t\t\t\t\t\tPRIMARY KEY (st_id)\n\t\t\t\t\t) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;", 4 => "INSERT INTO `__auth_options` (`auth_value`, `auth_default`) VALUES ('a_guildbank_auctions', 'N');", 5 => "INSERT INTO `__auth_options` (`auth_value`, `auth_default`) VALUES ('u_guildbank_auction', 'Y');");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_shoutbox_034' => 'Shoutbox 0.3.4 Update Package', 1 => 'Add new permission'), 'german' => array('update_shoutbox_034' => 'Shoutbox 0.3.4 Update Paket', 1 => 'Füge neue Berechtigung hinzu'));
// init SQL querys
$this->sqls = array(1 => "INSERT INTO `__auth_options` (`auth_value`, `auth_default`) VALUES ('u_shoutbox_view', 'Y');");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildrequest_020' => 'GuildRequest 0.2.0 Update Package', 1 => 'Alter guildrequest_fields table', 2 => 'Alter guildrequest_fields table'), 'german' => array('update_guildrequest_020' => 'GuildRequest 0.2.0 Update Paket', 1 => 'Ändere guildrequest_fields Tabelle', 2 => 'Ändere guildrequest_fields Tabelle'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__guildrequest_fields` ADD COLUMN `dep_value` TEXT COLLATE utf8_bin NULL;", 2 => "ALTER TABLE `__guildrequest_fields` ADD COLUMN `dep_field` INT(10) UNSIGNED NULL DEFAULT '0';");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_shoutbox_030' => 'Shoutbox 0.3.0 Update Package', 'update_function' => 'Copy config', 1 => 'Delete guest setting', 2 => 'Delete location setting'), 'german' => array('update_shoutbox_030' => 'Shoutbox 0.3.0 Update Paket', 'update_function' => 'Kopiere Einstellungen', 1 => 'Entferne Gast Einstellung', 2 => 'Entferne Positions Einstellung'));
// init SQL querys
$this->sqls = array(1 => 'DELETE FROM `__config` WHERE `config_name`=\'sb_invisible_to_guests\';', 2 => 'DELETE FROM `__config` WHERE `config_name`=\'sb_input_box_below\';');
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_dynamictemplate_210' => 'Dynamic Template 2.1.0 Update Package', 1 => 'Alter dynamictemplate table'), 'german' => array('update_dynamictemplate_210' => 'Dynamic Template 2.1.0 Update Paket', 1 => 'Ändere dynamictemplate Tabelle'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__dynamictemplate` ADD `listener` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `name`;");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildbank_220' => 'Guild Banker 2.2.0 Update Package', 1 => 'Add currency field to item shop transaction table'), 'german' => array('update_guildbank_200' => 'Guild Banker 2.2.0 Update Paket', 1 => 'Füge Währungsfeld zu itemshop transaction Tabelle hinzu'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE __guildbank_shop_ta ADD `st_currency` INT(2) NULL DEFAULT '1' AFTER `st_buyer`;");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildrequest_019' => 'GuildRequest 0.1.9 Update Package', 1 => 'Change guildrequest_visists table'), 'german' => array('update_guildrequest_019' => 'GuildRequest 0.1.9 Update Paket', 1 => 'Ändere guildrequest_visists Tabelle'));
// init SQL querys
$this->sqls = array(1 => "ALTER TABLE `__guildrequest_visits`\n\tDROP PRIMARY KEY,\n\tADD PRIMARY KEY (`request_id`, `user_id`);");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_localitembase_110' => 'Localitembase 1.1.0 Update Package', 'update_function' => 'Add Permission'), 'german' => array('update_localitembase_110' => 'Localitembase 1.1.0 Update Paket', 'update_function' => 'Füge Berechtigung hinzu'));
}
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_1011' => 'EQdkp Plus 1.0 RC4 Update 1', 'task01' => 'Alter repository table'), 'german' => array('update_1011' => 'EQdkp Plus 1.0 RC4 Update 1', 'task01' => 'Alter repository table'));
$this->sqls = array('task01' => "ALTER TABLE `__repository` CHANGE COLUMN `build` `dep_php` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_bin';");
}
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_07069' => 'eqDKP Plus 0.7.0.69 Developer-Update package', 'task01' => 'Alter links table', 'task02' => 'Alter links table'), 'german' => array('update_07069' => 'eqDKP Plus 0.7.0.69 Developer-Update package', 'task01' => 'Alter links table', 'task02' => 'Alter links table'));
$this->sqls = array('task01' => "ALTER TABLE `__plus_links` RENAME TO `__links`;", 'task02' => "ALTER TABLE `__links` ADD COLUMN `link_height` INT(10) NOT NULL DEFAULT '4024';");
}
include_once registry::get_const('root_path') . 'maintenance/includes/sql_update_task.class.php';
if (!class_exists('update_raidlogimport_0601')) {
class update_raidlogimport_0601 extends sql_update_task
{
public static function __shortcuts()
{
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_108' => 'EQdkp Plus 1.0 RC2 Update 1', 'update_function' => 'Alter birthday field'), 'german' => array('update_108' => 'EQdkp Plus 1.0 RC2 Update 1', 'update_function' => 'Verändere birthday Feld'));
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildrequest_100' => 'GuildRequest 1.0.0 Update Package', 'update_function' => 'Add Notifications'), 'german' => array('update_guildrequest_100' => 'GuildRequest 1.0.0 Update Paket', 'update_function' => 'Füge Benachrichtigungen hinzu'));
}
public static function __shortcuts()
{
$shortcuts = array('config');
return array_merge(parent::__shortcuts(), $shortcuts);
}
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_104' => 'EQdkp Plus 1.0 beta 5 Update', 'task01' => 'Add new permission for managing raid event confirmations'), 'german' => array('update_104' => 'EQdkp Plus 1.0 beta 5 Update', 'task01' => 'Füge ein neues Recht hinzu um die Raidevents besser verwalten zu können'));
$this->sqls = array('task01' => "INSERT INTO __auth_options (auth_value, auth_default) VALUES ('a_cal_revent_conf','N');");
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_localitembase_103' => 'Localitembase 1.0.3 Update Package', 'update_function' => 'Update Parser'), 'german' => array('update_localitembase_103' => 'Localitembase 1.0.3 Update Paket', 'update_function' => 'Aktualisiere Parser'));
}
public function __construct()
{
parent::__construct();
$this->langs = array('english' => array('update_107' => 'EQdkp Plus 1.0 RC1 Update', 'task01' => 'Alter item table'), 'german' => array('update_107' => 'EQdkp Plus 1.0 RC1 Update', 'task01' => 'Verändere item Tabelle'));
$this->sqls = array('task01' => "ALTER TABLE `__items`CHANGE COLUMN `item_value` `item_value` FLOAT(10,2) NULL DEFAULT NULL;");
}
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_raidlogimport_0603' => 'Raidlogimport 0.6.0.3 Update Package', 'update_function' => 'New config: No delete warning'), 'german' => array('update_raidlogimport_0603' => 'Raidlogimport 0.6.0.3 Update Package', 'update_function' => 'Neue Einstellung: keine Löschen-Warnung'));
}
/**
* Constructor
*/
public function __construct()
{
parent::__construct();
// init language
$this->langs = array('english' => array('update_guildrequest_110' => 'GuildRequest 1.0.0 Update Package', 'update_function' => 'Add Permission'), 'german' => array('update_guildrequest_110' => 'GuildRequest 1.0.0 Update Paket', 'update_function' => 'Füge Berechtigung hinzu'));
}