diff options
| -rw-r--r-- | sql/updates/3873_world_spell_(dk).sql | 25 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 27 | ||||
| -rw-r--r-- | src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp | 3 |
3 files changed, 55 insertions, 0 deletions
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/world_spell_full.sql b/sql/world_spell_full.sql index 54577ff975e..602be1dd526 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1623,6 +1623,33 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52479,1,28819), (52479,1,28822); + +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); + +-- ship cannon +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); + + -- frostbrood vanquisher update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; diff --git a/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp b/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp index 560d9196d95..4790bf1f97d 100644 --- a/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp +++ b/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp @@ -598,6 +598,7 @@ CreatureAI* GetAI_npc_ros_dark_rider(Creature *_Creature) return new npc_ros_dark_riderAI(_Creature); } +// correct way: 52312 52314 52555 ... struct TRINITY_DLL_DECL npc_dkc1_gothikAI : public ScriptedAI { npc_dkc1_gothikAI(Creature *c) : ScriptedAI(c) {} @@ -628,6 +629,8 @@ CreatureAI* GetAI_npc_dkc1_gothik(Creature *_Creature) return new npc_dkc1_gothikAI(_Creature); } +// npc 28912 quest 17217 boss 29001 go 191092 + void AddSC_the_scarlet_enclave() { Script *newscript; |