diff options
Diffstat (limited to 'sql')
20 files changed, 95 insertions, 3 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index 4aa7b69c067..1055ffd0cf6 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_7643_02_mangos_mangos_string` bit(1) default NULL + `required_7662_02_mangos_spell_bonus_data` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -15785,6 +15785,16 @@ INSERT INTO spell_chain VALUES (53199,48505,48505,2,0), (53200,53199,48505,3,0), (53201,53200,48505,4,0), +/*Starfall AOE*/ +(50294,0,50294,1,0), +(53188,50294,50294,2,0), +(53189,53188,50294,3,0), +(53190,53189,50294,4,0), +/*Starfall Direct*/ +(50288,0,50288,1,0), +(53191,50288,50288,2,0), +(53194,53191,50288,3,0), +(53195,53194,50288,4,0), /*Starfire*/ (2912,0,2912,1,0), (8949,2912,2912,2,0), @@ -17570,6 +17580,8 @@ INSERT INTO `spell_bonus_data` VALUES ('33763', '0', '0.09518', '0', 'Druid - Lifebloom'), ('774', '0', '0.37604', '0', 'Druid - Rejuvenation'), ('8936', '0.539', '0.188', '0', 'Druid - Regrowth'), +('50288', '0.05', '0', '0', 'Druid - Starfall'), +('50294', '0.012', '0', '0', 'Druid - Starfall AOE'), ('18562', '0', '0', '0', 'Druid - Swiftmend'), ('44203', '0.538', '0', '0', 'Druid - Tranquility Triggered'), ('48438', '0', '0.11505', '0', 'Druid - Wild Growth'), diff --git a/sql/updates/1350_world_scripts.sql b/sql/updates/1350_world_scripts.sql new file mode 100644 index 00000000000..193c03394a6 --- /dev/null +++ b/sql/updates/1350_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `mindmg`=700, `maxdmg`=1200, `attackpower`=1000, `flags_extra`=196641 WHERE `entry`=23418;
\ No newline at end of file diff --git a/sql/updates/2551_world.sql b/sql/updates/2551_world_spell_bonus_data.sql index 531f248a2ef..531f248a2ef 100644 --- a/sql/updates/2551_world.sql +++ b/sql/updates/2551_world_spell_bonus_data.sql diff --git a/sql/updates/2559_world.sql b/sql/updates/2559_world_spell_proc_event.sql index 50ebcb09e96..50ebcb09e96 100644 --- a/sql/updates/2559_world.sql +++ b/sql/updates/2559_world_spell_proc_event.sql diff --git a/sql/updates/2565_world.sql b/sql/updates/2565_world_SD2_scripts.sql index 2b744ba549b..2b744ba549b 100644 --- a/sql/updates/2565_world.sql +++ b/sql/updates/2565_world_SD2_scripts.sql diff --git a/sql/updates/2570_world.sql b/sql/updates/2570_world_spell_linked_spell.sql index 0d87bfc80e8..0d87bfc80e8 100644 --- a/sql/updates/2570_world.sql +++ b/sql/updates/2570_world_spell_linked_spell.sql diff --git a/sql/updates/2586_world.sql b/sql/updates/2586_world_spell_linked_spell.sql index 489fe7bdb75..489fe7bdb75 100644 --- a/sql/updates/2586_world.sql +++ b/sql/updates/2586_world_spell_linked_spell.sql diff --git a/sql/updates/2591_world.sql b/sql/updates/2591_world_spell_linked_spell.sql index 63da911d5a4..63da911d5a4 100644 --- a/sql/updates/2591_world.sql +++ b/sql/updates/2591_world_spell_linked_spell.sql diff --git a/sql/updates/2626_world.sql b/sql/updates/2626_world.sql deleted file mode 100644 index 0866b52c428..00000000000 --- a/sql/updates/2626_world.sql +++ /dev/null @@ -1,2 +0,0 @@ -INSERT IGNORE INTO `spell_linked_spell` VALUES (47897, 47960, 0, 'Shadowflame Rank 1'); -INSERT IGNORE INTO `spell_linked_spell` VALUES (61290, 61291, 0, 'Shadowflame Rank 2'); diff --git a/sql/updates/2629_world_spell_linked_spell.sql b/sql/updates/2629_world_spell_linked_spell.sql new file mode 100644 index 00000000000..be4609b7d5e --- /dev/null +++ b/sql/updates/2629_world_spell_linked_spell.sql @@ -0,0 +1,2 @@ +INSERT IGNORE INTO `spell_linked_spell` VALUES (47897, 47960, 1, 'Shadowflame Rank 1'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (61290, 61291, 1, 'Shadowflame Rank 2'); diff --git a/sql/updates/2678_mangos_7662_01_world_spell_bonus_data.sql b/sql/updates/2678_mangos_7662_01_world_spell_bonus_data.sql new file mode 100644 index 00000000000..7950f336812 --- /dev/null +++ b/sql/updates/2678_mangos_7662_01_world_spell_bonus_data.sql @@ -0,0 +1,6 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7662_01_mangos_spell_chain required_7662_02_mangos_spell_bonus_data bit;*/ + +DELETE FROM `spell_bonus_data` WHERE entry IN (50288, 50294); +INSERT INTO `spell_bonus_data` VALUES +(50288, 0.05, 0, 0, "Druid - Starfall"), +(50294, 0.012, 0, 0, "Druid - Starfall AOE");
\ No newline at end of file diff --git a/sql/updates/2682_world_SD2_scripts.sql b/sql/updates/2682_world_SD2_scripts.sql new file mode 100644 index 00000000000..39ac367d097 --- /dev/null +++ b/sql/updates/2682_world_SD2_scripts.sql @@ -0,0 +1,46 @@ +DELETE FROM script_waypoint WHERE entry=3849; +INSERT INTO script_waypoint VALUES +(3849, 0, -250.923431, 2116.264160, 81.179, 0, 'SAY_FREE_AD'), +(3849, 1, -255.048538, 2119.392578, 81.179, 0, ''), +(3849, 2, -254.129105, 2123.454346, 81.179, 0, ''), +(3849, 3, -253.897552, 2130.873535, 81.179, 0, ''), +(3849, 4, -249.889435, 2142.307861, 86.972, 0, ''), +(3849, 5, -248.204926, 2144.017090, 87.013, 0, ''), +(3849, 6, -240.552826, 2140.552734, 87.012, 0, ''), +(3849, 7, -237.513916, 2142.066650, 87.012, 0, ''), +(3849, 8, -235.638138, 2149.231689, 90.587, 0, ''), +(3849, 9, -237.188019, 2151.946045, 90.624, 0, ''), +(3849, 10, -241.162064, 2153.649658, 90.624, 0, 'SAY_OPEN_DOOR_AD'), +(3849, 11, -241.129700, 2154.562988, 90.624, 5000, ''), +(3849, 12, -241.129700, 2154.562988, 90.624, 5000, 'SAY_POST1_DOOR_AD'), +(3849, 13, -241.129700, 2154.562988, 90.624, 25000, 'SAY_POST2_DOOR_AD'); + +DELETE FROM script_waypoint WHERE entry=3850; +INSERT INTO script_waypoint VALUES +(3850, 0, -241.816895, 2122.904053, 81.179, 0, 'SAY_FREE_AS'), +(3850, 1, -247.139297, 2124.886475, 81.179, 0, ''), +(3850, 2, -253.179184, 2127.406738, 81.179, 0, ''), +(3850, 3, -253.897552, 2130.873535, 81.179, 0, ''), +(3850, 4, -249.889435, 2142.307861, 86.972, 0, ''), +(3850, 5, -248.204926, 2144.017090, 87.013, 0, ''), +(3850, 6, -240.552826, 2140.552734, 87.012, 0, ''), +(3850, 7, -237.513916, 2142.066650, 87.012, 0, ''), +(3850, 8, -235.638138, 2149.231689, 90.587, 0, ''), +(3850, 9, -237.188019, 2151.946045, 90.624, 0, ''), +(3850, 10, -241.162064, 2153.649658, 90.624, 0, 'SAY_OPEN_DOOR_AS'), +(3850, 11, -241.129700, 2154.562988, 90.624, 5000, 'cast'), +(3850, 12, -241.129700, 2154.562988, 90.624, 5000, 'SAY_POST_DOOR_AS'), +(3850, 13, -241.129700, 2154.562988, 90.624, 25000, ''); + +UPDATE script_texts SET content_default='Follow me and I\'ll open the courtyard door for you.', language=7, comment='prisoner ashcrombe SAY_FREE_AS' WHERE entry=-1033000; + +DELETE FROM script_texts WHERE entry BETWEEN -1033008 AND -1033001; +INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES +(-1033001,'I have just the spell to get this door open. Too bad the cell doors weren\'t locked so haphazardly.',0,0,7,1,'prisoner ashcrombe SAY_OPEN_DOOR_AS'), +(-1033002,'There it is! Wide open. Good luck to you conquering what lies beyond. I must report back to the Kirin Tor at once!',0,0,7,1,'prisoner ashcrombe SAY_POST_DOOR_AS'), +(-1033003,'Free from this wretched cell at last! Let me show you to the courtyard....',0,0,1,1,'prisoner adamant SAY_FREE_AD'), +(-1033004,'You are indeed courageous for wanting to brave the horrors that lie beyond this door.',0,0,1,1,'prisoner adamant SAY_OPEN_DOOR_AD'), +(-1033005,'There we go!',0,0,1,1,'prisoner adamant SAY_POST1_DOOR_AD'), +(-1033006,'Good luck with Arugal. I must hurry back to Hadrec now.',0,0,1,1,'prisoner adamant SAY_POST2_DOOR_AD'), +(-1033007,'About time someone killed the wretch.',0,0,1,1,'prisoner adamant SAY_BOSS_DIE_AD'), +(-1033008,'For once I agree with you... scum.',0,0,7,1,'prisoner ashcrombe SAY_BOSS_DIE_AS');
\ No newline at end of file diff --git a/sql/updates/2683_characters_gm_tickets.sql b/sql/updates/2683_characters_gm_tickets.sql new file mode 100644 index 00000000000..d7a668c4b89 --- /dev/null +++ b/sql/updates/2683_characters_gm_tickets.sql @@ -0,0 +1 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`;
\ No newline at end of file diff --git a/sql/updates/2683_world_trinity_string.sql b/sql/updates/2683_world_trinity_string.sql new file mode 100644 index 00000000000..856f105c535 --- /dev/null +++ b/sql/updates/2683_world_trinity_string.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry`=2025; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +('2025','|cff00ff00Created|r:|cff00ccff %s ago|r ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/2685_world_spell_proc_event.sql b/sql/updates/2685_world_spell_proc_event.sql new file mode 100644 index 00000000000..9c4ea8c1d43 --- /dev/null +++ b/sql/updates/2685_world_spell_proc_event.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (56337, 56336, 56333); +INSERT INTO `spell_proc_event` VALUES +(56337, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00022200, 0x0000000, 0.000000, 0.000000, 0), +(56336, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00022200, 0x0000000, 0.000000, 0.000000, 0), +(56333, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00022200, 0x0000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/2686_characters_gm_tickets.sql b/sql/updates/2686_characters_gm_tickets.sql new file mode 100644 index 00000000000..11a1e1f1498 --- /dev/null +++ b/sql/updates/2686_characters_gm_tickets.sql @@ -0,0 +1,4 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `map` INT NOT NULL DEFAULT '0' AFTER `createtime`; +ALTER TABLE `gm_tickets` ADD COLUMN `posX` FLOAT NOT NULL DEFAULT '0' AFTER `map`; +ALTER TABLE `gm_tickets` ADD COLUMN `posY` FLOAT NOT NULL DEFAULT '0' AFTER `posX`; +ALTER TABLE `gm_tickets` ADD COLUMN `posZ` FLOAT NOT NULL DEFAULT '0' AFTER `posY`;
\ No newline at end of file diff --git a/sql/updates/2686_world_command.sql b/sql/updates/2686_world_command.sql new file mode 100644 index 00000000000..5d25225dfe4 --- /dev/null +++ b/sql/updates/2686_world_command.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` IN ('go ticket'); +INSERT INTO `command` VALUES +('go ticket','1','Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.');
\ No newline at end of file diff --git a/sql/updates/2687_world_spell_proc_event.sql b/sql/updates/2687_world_spell_proc_event.sql new file mode 100644 index 00000000000..fd8960d2714 --- /dev/null +++ b/sql/updates/2687_world_spell_proc_event.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (44545, 44543); +INSERT INTO `spell_proc_event` VALUES +(44545, 0x00, 3, 1049120, 4096, 0, 65536, 0x0000000, 0.000000, 15.000000, 0), +(44543, 0x00, 3, 1049120, 4096, 0, 65536, 0x0000000, 0.000000, 7.000000, 0);
\ No newline at end of file diff --git a/sql/updates/2689_world_spell_linked_spell.sql b/sql/updates/2689_world_spell_linked_spell.sql new file mode 100644 index 00000000000..8e077e70f01 --- /dev/null +++ b/sql/updates/2689_world_spell_linked_spell.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (51723); +INSERT INTO `spell_linked_spell` VALUES (51723, 52874, 0, 'Fan Of Knives');
\ No newline at end of file diff --git a/sql/updates/2702_world_spell_proc_event.sql b/sql/updates/2702_world_spell_proc_event.sql new file mode 100644 index 00000000000..a887d590c54 --- /dev/null +++ b/sql/updates/2702_world_spell_proc_event.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (56337, 56336, 56333); +INSERT INTO `spell_proc_event` VALUES +(56337, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0), +(56336, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0), +(56333, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0); |