From 60710d6116578a496a2684099dc7fbf516429531 Mon Sep 17 00:00:00 2001 From: Drahy Date: Sun, 29 Mar 2009 11:25:40 +0200 Subject: * Used trinity sql coding style for proper import --HG-- branch : trunk --- .../2280_mangos_7565_01_world_trinity_string.sql | 9 ++++ .../2284_mangos_7568_01_world_spell_proc_event.sql | 49 ++++++++++++++++++++++ sql/updates/2296_world.sql | 2 + sql/updates/2296_world_creature_template.sql | 2 - sql/updates/7565_01_mangos_mangos_string.sql | 9 ---- sql/updates/7568_01_mangos_spell_proc_event.sql | 49 ---------------------- 6 files changed, 60 insertions(+), 60 deletions(-) create mode 100644 sql/updates/2280_mangos_7565_01_world_trinity_string.sql create mode 100644 sql/updates/2284_mangos_7568_01_world_spell_proc_event.sql create mode 100644 sql/updates/2296_world.sql delete mode 100644 sql/updates/2296_world_creature_template.sql delete mode 100644 sql/updates/7565_01_mangos_mangos_string.sql delete mode 100644 sql/updates/7568_01_mangos_spell_proc_event.sql (limited to 'sql') diff --git a/sql/updates/2280_mangos_7565_01_world_trinity_string.sql b/sql/updates/2280_mangos_7565_01_world_trinity_string.sql new file mode 100644 index 00000000000..c7ec3aaf725 --- /dev/null +++ b/sql/updates/2280_mangos_7565_01_world_trinity_string.sql @@ -0,0 +1,9 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7560_01_mangos_gameobject_template required_7565_01_mangos_mangos_string bit;*/ + +DELETE FROM `trinity_string` WHERE `entry` IN (1010,1011,1012,1013,1014); +INSERT INTO `trinity_string` VALUES +(1010,'| Account | Character | IP | GM | Expansion |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(1011,'| | %20s | || |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(1012,'===========================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(1013,'|%15s| %20s | %15s |%4d| %9d |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(1014,'No online players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file diff --git a/sql/updates/2284_mangos_7568_01_world_spell_proc_event.sql b/sql/updates/2284_mangos_7568_01_world_spell_proc_event.sql new file mode 100644 index 00000000000..016b88eac27 --- /dev/null +++ b/sql/updates/2284_mangos_7568_01_world_spell_proc_event.sql @@ -0,0 +1,49 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7565_01_mangos_mangos_string required_7568_01_mangos_spell_proc_event bit;*/ + +-- (53569) Infusion of Light (Rank 1) +DELETE FROM `spell_proc_event` WHERE `entry` IN (53569); +INSERT INTO `spell_proc_event` VALUES (53569, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (53576) Infusion of Light (Rank 2) +DELETE FROM `spell_proc_event` WHERE `entry` IN (53576); +INSERT INTO `spell_proc_event` VALUES (53576, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (54149) Infusion of Light (Rank 2) +DELETE FROM `spell_proc_event` WHERE `entry` IN (54149); +INSERT INTO `spell_proc_event` VALUES (54149, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (55776) Swordguard Embroidery () +DELETE FROM `spell_proc_event` WHERE `entry` IN (55776); +INSERT INTO `spell_proc_event` VALUES (55776, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); + +-- (55768) Darkglow Embroidery () +DELETE FROM `spell_proc_event` WHERE `entry` IN (55768); +INSERT INTO `spell_proc_event` VALUES (55768, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); + +-- (55640) Lightweave Embroidery () +DELETE FROM `spell_proc_event` WHERE `entry` IN (55640); +INSERT INTO `spell_proc_event` VALUES (55640, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); + +-- (55380) Skyflare Swiftness () +DELETE FROM `spell_proc_event` WHERE `entry` IN (55380); +INSERT INTO `spell_proc_event` VALUES (55380, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); + +-- (56355) Titanium Shield Spike () +DELETE FROM `spell_proc_event` WHERE `entry` IN (56355); +INSERT INTO `spell_proc_event` VALUES (56355, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0.000000, 0.000000, 0); + +-- (61345) Natures Grace () +DELETE FROM `spell_proc_event` WHERE `entry` IN (61345); +INSERT INTO `spell_proc_event` VALUES (61345, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (61346) Natures Grace () +DELETE FROM `spell_proc_event` WHERE `entry` IN (61346); +INSERT INTO `spell_proc_event` VALUES (61346, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (61356) Invigorating Earthsiege Diamond Passive () +DELETE FROM `spell_proc_event` WHERE `entry` IN (61356); +INSERT INTO `spell_proc_event` VALUES (61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); + +-- (24905) Moonkin Form (Passive) (Passive) +DELETE FROM `spell_proc_event` WHERE `entry` IN (24905); +INSERT INTO `spell_proc_event` VALUES (24905, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 15.000000, 0.000000, 0); \ No newline at end of file diff --git a/sql/updates/2296_world.sql b/sql/updates/2296_world.sql new file mode 100644 index 00000000000..716d6be4b82 --- /dev/null +++ b/sql/updates/2296_world.sql @@ -0,0 +1,2 @@ +ALTER TABLE creature_template + ADD COLUMN `VehicleId` mediumint(8) unsigned NOT NULL default '0' AFTER `PetSpellDataId`; \ No newline at end of file diff --git a/sql/updates/2296_world_creature_template.sql b/sql/updates/2296_world_creature_template.sql deleted file mode 100644 index 716d6be4b82..00000000000 --- a/sql/updates/2296_world_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE creature_template - ADD COLUMN `VehicleId` mediumint(8) unsigned NOT NULL default '0' AFTER `PetSpellDataId`; \ No newline at end of file diff --git a/sql/updates/7565_01_mangos_mangos_string.sql b/sql/updates/7565_01_mangos_mangos_string.sql deleted file mode 100644 index 4557d196665..00000000000 --- a/sql/updates/7565_01_mangos_mangos_string.sql +++ /dev/null @@ -1,9 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7560_01_mangos_gameobject_template required_7565_01_mangos_mangos_string bit; - -DELETE FROM mangos_string WHERE entry IN(1010,1011,1012,1013,1014); -INSERT INTO mangos_string VALUES -(1010,'| Account | Character | IP | GM | Expansion |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1011,'| | %20s | || |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1012,'===========================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1013,'|%15s| %20s | %15s |%4d| %9d |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1014,'No online players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/updates/7568_01_mangos_spell_proc_event.sql b/sql/updates/7568_01_mangos_spell_proc_event.sql deleted file mode 100644 index 327e75c1e36..00000000000 --- a/sql/updates/7568_01_mangos_spell_proc_event.sql +++ /dev/null @@ -1,49 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7565_01_mangos_mangos_string required_7568_01_mangos_spell_proc_event bit; - --- (53569) Infusion of Light (Rank 1) -DELETE FROM `spell_proc_event` WHERE `entry` IN (53569); -INSERT INTO `spell_proc_event` VALUES (53569, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (53576) Infusion of Light (Rank 2) -DELETE FROM `spell_proc_event` WHERE `entry` IN (53576); -INSERT INTO `spell_proc_event` VALUES (53576, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (54149) Infusion of Light (Rank 2) -DELETE FROM `spell_proc_event` WHERE `entry` IN (54149); -INSERT INTO `spell_proc_event` VALUES (54149, 0x00, 10, 0x00200000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (55776) Swordguard Embroidery () -DELETE FROM `spell_proc_event` WHERE `entry` IN (55776); -INSERT INTO `spell_proc_event` VALUES (55776, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); - --- (55768) Darkglow Embroidery () -DELETE FROM `spell_proc_event` WHERE `entry` IN (55768); -INSERT INTO `spell_proc_event` VALUES (55768, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); - --- (55640) Lightweave Embroidery () -DELETE FROM `spell_proc_event` WHERE `entry` IN (55640); -INSERT INTO `spell_proc_event` VALUES (55640, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); - --- (55380) Skyflare Swiftness () -DELETE FROM `spell_proc_event` WHERE `entry` IN (55380); -INSERT INTO `spell_proc_event` VALUES (55380, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45); - --- (56355) Titanium Shield Spike () -DELETE FROM `spell_proc_event` WHERE `entry` IN (56355); -INSERT INTO `spell_proc_event` VALUES (56355, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0.000000, 0.000000, 0); - --- (61345) Natures Grace () -DELETE FROM `spell_proc_event` WHERE `entry` IN (61345); -INSERT INTO `spell_proc_event` VALUES (61345, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (61346) Natures Grace () -DELETE FROM `spell_proc_event` WHERE `entry` IN (61346); -INSERT INTO `spell_proc_event` VALUES (61346, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (61356) Invigorating Earthsiege Diamond Passive () -DELETE FROM `spell_proc_event` WHERE `entry` IN (61356); -INSERT INTO `spell_proc_event` VALUES (61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); - --- (24905) Moonkin Form (Passive) (Passive) -DELETE FROM `spell_proc_event` WHERE `entry` IN (24905); -INSERT INTO `spell_proc_event` VALUES (24905, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 15.000000, 0.000000, 0); \ No newline at end of file -- cgit v1.2.3