diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/2706_world_SD2_scripts.sql | 6 | ||||
| -rw-r--r-- | sql/updates/TC1_1362_world_creature_linked_respawn.sql | 10 | ||||
| -rw-r--r-- | sql/updates/TC1_world_1371_script.sql | 1 |
3 files changed, 14 insertions, 3 deletions
diff --git a/sql/updates/2706_world_SD2_scripts.sql b/sql/updates/2706_world_SD2_scripts.sql index cd9c4ea3b19..71f97997461 100644 --- a/sql/updates/2706_world_SD2_scripts.sql +++ b/sql/updates/2706_world_SD2_scripts.sql @@ -1,4 +1,4 @@ -UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162);
-DELETE FROM spell_target_position WHERE id=53360;
-INSERT INTO spell_target_position VALUES
+UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162); +DELETE FROM spell_target_position WHERE id=53360; +INSERT INTO spell_target_position VALUES (53360, 571, 5807.829, 587.960, 660.939, 1.663);
\ No newline at end of file diff --git a/sql/updates/TC1_1362_world_creature_linked_respawn.sql b/sql/updates/TC1_1362_world_creature_linked_respawn.sql new file mode 100644 index 00000000000..a6d786871d6 --- /dev/null +++ b/sql/updates/TC1_1362_world_creature_linked_respawn.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS `creature_linked_respawn`; +CREATE TABLE `creature_linked_respawn` ( + `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature', + `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System'; + +DELETE FROM `trinity_string` WHERE `entry` = '750'; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +('750', 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/TC1_world_1371_script.sql b/sql/updates/TC1_world_1371_script.sql new file mode 100644 index 00000000000..39dab9882d0 --- /dev/null +++ b/sql/updates/TC1_world_1371_script.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName` = 'mob_unkor_the_ruthless' WHERE `entry` = 18262; |