diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/3870_mangos_7980_01_world_item_required_target.sql | 9 | ||||
| -rw-r--r-- | sql/updates/3873_world_spell_(dk).sql | 25 | ||||
| -rw-r--r-- | sql/updates/3877_world_spell_script_target.sql | 3 |
3 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/3870_mangos_7980_01_world_item_required_target.sql b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql new file mode 100644 index 00000000000..7853e496a2d --- /dev/null +++ b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql @@ -0,0 +1,9 @@ +-- ALTER TABLE db_version CHANGE COLUMN required_7945_01_mangos_quest_template required_7980_01_mangos_item_required_target bit; + +DROP TABLE IF EXISTS `item_required_target`; +CREATE TABLE `item_required_target` ( + `entry` mediumint(8) unsigned NOT NULL, + `type` tinyint(3) unsigned NOT NULL default '0', + `targetEntry` mediumint(8) unsigned NOT NULL default '0', + UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; diff --git a/sql/updates/3873_world_spell_(dk).sql b/sql/updates/3873_world_spell_(dk).sql new file mode 100644 index 00000000000..09d130a4f6b --- /dev/null +++ b/sql/updates/3873_world_spell_(dk).sql @@ -0,0 +1,25 @@ + +replace into creature_questrelation (id,quest) VALUES (28377,12701); +replace into creature_involvedrelation (id,quest) VALUES (28377,12701); +replace into creature_involvedrelation (id,quest) VALUES (28914,12723); +replace into creature_questrelation (id,quest) VALUES (28914,12724); +replace into creature_involvedrelation (id,quest) VALUES (28914,12724); +replace into creature_questrelation (id,quest) VALUES (28913,12725); +replace into creature_involvedrelation (id,quest) VALUES (28912,12725); +replace into creature_questrelation (id,quest) VALUES (28912,12727); +replace into creature_involvedrelation (id,quest) VALUES (28913,12727); + + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +(28833, 52447, 12701, 3, 3), +(28887, 52447, 12701, 3, 3); + +UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); +UPDATE creature_template SET spell1=52211 WHERE entry=28864; + +DELETE FROM `spell_script_target` WHERE entry IN +(52576); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52576,1,28834), +(52576,1,28886); diff --git a/sql/updates/3877_world_spell_script_target.sql b/sql/updates/3877_world_spell_script_target.sql new file mode 100644 index 00000000000..9778be52466 --- /dev/null +++ b/sql/updates/3877_world_spell_script_target.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_target` WHERE `entry` IN (48743); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +('48743', '1', '26125');
\ No newline at end of file |