diff options
| author | Vox <ndinosaur1213@Live.com> | 2021-02-14 12:36:51 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-02-14 18:36:51 +0100 |
| commit | c47a60ea57889074a5a5a45b45ea2ef522021ecc (patch) | |
| tree | 8a19febf878cefcee68fc678a5872e1d4e57819d | |
| parent | 5cd011bee0f0cddb76d28abd787ffc2361a0a1a9 (diff) | |
fix(DB/creature): Ham from Reese Langston position (#4564)
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1613242843051334000.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1613242843051334000.sql b/data/sql/updates/pending_db_world/rev_1613242843051334000.sql new file mode 100644 index 0000000000..75f30e0dda --- /dev/null +++ b/data/sql/updates/pending_db_world/rev_1613242843051334000.sql @@ -0,0 +1,11 @@ +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1613242843051334000'); + +/* Adjust Position and remove piece of Ham from Reese Langston + Source: https://wow.gamepedia.com/Reese_Langston +*/ + +UPDATE `creature_equip_template` SET `ItemID2` = 0 WHERE (`CreatureID` = 1327); + +DELETE FROM `creature` WHERE (`id` = 1327) AND (`guid` IN (79751)); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(79751, 1327, 0, 0, 0, 1, 1, 0, 1, -8606.001953, 383.925995, 102.923599, 3.79168, 310, 0, 0, 1003, 0, 0, 0, 0, 0, '', 0); |