diff options
| author | Killyana <morphone1@gmail.com> | 2018-12-09 14:04:58 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-16 16:33:12 +0100 |
| commit | 1ec9a4d6281d482ab90d6f9277cceb5b89527a16 (patch) | |
| tree | ff0949aeb09f795b6b964ee101697ddb2c32daa6 | |
| parent | 0f55e07330553523f16f722a801228f31142bd81 (diff) | |
DB/Creature: Njorndar Proto-Drake
Closes #22853
(cherry picked from commit df641e993ac4e058c55ec97cceb19cf397a51105)
| -rw-r--r-- | sql/updates/world/master/2021_11_16_39_world_2018_12_09_03_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_16_39_world_2018_12_09_03_world.sql b/sql/updates/world/master/2021_11_16_39_world_2018_12_09_03_world.sql new file mode 100644 index 00000000000..84c66e45025 --- /dev/null +++ b/sql/updates/world/master/2021_11_16_39_world_2018_12_09_03_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (153,155); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(153,30272,571,0,0,'0',0,0,0,7819.851074, 3738.652588, 653.378479, 1.181855,300,0,0,37800,0,0,0,0,0,"",0), +(155,30272,571,0,0,'0',0,0,0,7793.105469, 3739.857178, 653.982361, 1.743578,300,0,0,37800,0,0,0,0,0,"",0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 18 AND `SourceGroup` = 30272 AND `SourceEntry` = 57401; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(18, 30272, 57401, 0, 0, 9, 0, 13071, 0, 0, 0, 0, 0, "", 'spellclick "Njorndar Proto-Drake" requires quest "Vile Like Fire!" active'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=30564 AND `ConditionTypeOrReference`=23; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(16,0,30564,0,0,23,0,4526,0,0,0,0,0,'','Dismount player in not intended area'), +(16,0,30564,0,1,23,0,4496,0,0,0,0,0,'','Dismount player in not intended area'); |