*DB script table stucture change. Source Mangos. Also fix some bugs. Hopefully this rev will make program usable again.

--HG--
branch : trunk

4 files changed, 108 insertions, 0 deletions

diff --git a/sql/updates/262_characters.sql b/sql/updates/262_characters.sql
new file mode 100644
index 00000000000..9e9fbc1caf7
--- /dev/null
+++ b/sql/updates/262_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `guild_bank_tab`

+  CHANGE COLUMN `TabText` `TabText` text;

+

+ALTER TABLE `character_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ;

+ALTER TABLE `pet_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ;
\ No newline at end of file
diff --git a/sql/updates/262_realmd.sql b/sql/updates/262_realmd.sql
new file mode 100644
index 00000000000..62e5c050c4a
--- /dev/null
+++ b/sql/updates/262_realmd.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `account`

+  CHANGE COLUMN  `email` `email` text;
\ No newline at end of file
diff --git a/sql/updates/262_world.sql b/sql/updates/262_world.sql
new file mode 100644
index 00000000000..8e9d8b47687
--- /dev/null
+++ b/sql/updates/262_world.sql
@@ -0,0 +1,70 @@
+DELETE FROM trinity_string WHERE entry IN (1119,1120,1121);

+

+INSERT INTO trinity_string VALUES

+(1119,'You must use male or female as gender.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),

+(1120,'You change gender of %s to %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),

+(1121,'Your gender changed to %s by %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

+

+

+DELETE FROM command WHERE name IN ('modify gender');

+

+INSERT INTO command VALUES

+('modify gender',2,'Syntax: .modify gender male/female\r\n\r\nChange gender of selected player.');

+

+

+delete from `command` where `name` IN ('senditems','sendmail');

+insert into `command` (`name`, `security`, `help`) values

+('senditems',3,'Syntax: .senditems #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'),

+('sendmail',1,'Syntax: .sendmail #playername "#subject" "#text"\r\n\r\nSend a mail to a player. Subject and mail text must be in "".');

+

+

+delete from `command` where `name` = 'sendmoney';

+insert into `command` (`name`, `security`, `help`) values

+('sendmoney',3,'Syntax: .sendmoney #playername "#subject" "#text" #money\r\n\r\nSend mail with money to a player. Subject and mail text must be in "".');

+

+

+DELETE FROM trinity_string WHERE entry IN (453);

+

+

+DROP TABLE IF EXISTS `db_script_string`;

+CREATE TABLE `db_script_string` (

+  `entry` int(11) unsigned NOT NULL default '0',

+  `content_default` text NOT NULL,

+  `content_loc1` text,

+  `content_loc2` text,

+  `content_loc3` text,

+  `content_loc4` text,

+  `content_loc5` text,

+  `content_loc6` text,

+  `content_loc7` text,

+  `content_loc8` text,

+  PRIMARY KEY  (`entry`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+

+DELETE FROM `command` WHERE `name` IN (

+  'server exit',

+  'server idleshutdown',

+  'server idleshutdown cancel',

+  'server idlerestart',

+  'server idlerestart cancel',

+  'server restart',

+  'server restart cancel',

+  'server shutdown',

+  'server shutdown cancel'

+);

+

+INSERT INTO `command` (`name`, `security`, `help`) VALUES

+('server exit',4,'Syntax: .server exit\r\n\r\nTerminate mangosd NOW. Exit code 0.'),

+('server idleshutdown',3,'Syntax: .server idleshutdown #delay [#exist_code]\r\n\r\nShut the server down after #delay seconds if no active connections are present (no players). Use #exist_code or 0 as program exist code.'),

+('server idleshutdown cancel',3,'Syntax: .server idleshutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'),

+('server idlerestart',3,'Syntax: .server idlerestart #delay\r\n\r\nRestart the server after #delay seconds if no active connections are present (no players). Use #exist_code or 2 as program exist code.'),

+('server idlerestart cancel',3,'Syntax: .server idlerestart cancel\r\n\r\nCancel the restart/shutdown timer if any.'),

+('server restart',3,'Syntax: .server restart #delay\r\n\r\nRestart the server after #delay seconds. Use #exist_code or 2 as program exist code.'),

+('server restart cancel',3,'Syntax: .server restart cancel\r\n\r\nCancel the restart/shutdown timer if any.'),

+('server shutdown',3,'Syntax: .server shutdown #delay [#exist_code]\r\n\r\nShut the server down after #delay seconds. Use #exist_code or 0 as program exist code.'),

+('server shutdown cancel',3,'Syntax: .server shutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.');

+

+DELETE FROM trinity_string WHERE entry IN (251);

+INSERT INTO trinity_string VALUES

+(251,'Text%d (ID: %i): %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file
diff --git a/sql/updates/262_world_runthisonlyonce.sql b/sql/updates/262_world_runthisonlyonce.sql
new file mode 100644
index 00000000000..31926c3a4d1
--- /dev/null
+++ b/sql/updates/262_world_runthisonlyonce.sql
@@ -0,0 +1,31 @@
+ALTER TABLE event_scripts

+  DROP datatext,

+  ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; 

+

+ALTER TABLE gameobject_scripts

+  DROP datatext,

+  ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; 

+

+ALTER TABLE quest_end_scripts

+  DROP datatext,

+  ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; 

+

+ALTER TABLE quest_start_scripts

+  DROP datatext,

+  ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; 

+

+ALTER TABLE spell_scripts

+  DROP datatext,

+  ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; 

+

+ALTER TABLE creature_movement

+  DROP `text1`,

+  DROP `text2`,

+  DROP `text3`,

+  DROP `text4`,

+  DROP `text5`,

+  ADD COLUMN textid1 int(11) NOT NULL default '0' AFTER waittime,

+  ADD COLUMN textid2 int(11) NOT NULL default '0' AFTER textid1,

+  ADD COLUMN textid3 int(11) NOT NULL default '0' AFTER textid2,

+  ADD COLUMN textid4 int(11) NOT NULL default '0' AFTER textid3,

+  ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4;
\ No newline at end of file