diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-07-16 09:16:03 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-16 09:16:03 +0200 |
| commit | 030c0b21b721cdcbef12a09cc627adef3333b84f (patch) | |
| tree | efb933293e36ef2329dabd578e0ee6601970be67 | |
| parent | 8f9f1cc77ee9ea78268cd031a42f02f4ee047af8 (diff) | |
DB/Quest: Whitebark's Memory
Closes #16606, by tkrokli
| -rw-r--r-- | sql/updates/world/6.x/2016_07_16_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_07_16_00_world.sql b/sql/updates/world/6.x/2016_07_16_00_world.sql new file mode 100644 index 00000000000..17d8e51f40f --- /dev/null +++ b/sql/updates/world/6.x/2016_07_16_00_world.sql @@ -0,0 +1,8 @@ +-- Restore deleted gameobject 181260 (Scorched Grove Runestone) +DELETE FROM `gameobject_template` WHERE `entry`= 181260; +INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`IconName`,`castBarCaption`,`unk1`,`faction`,`flags`,`size`,`Data0`,`Data1`,`Data2`,`Data3`,`Data4`,`Data5`,`Data6`,`Data7`,`Data8`,`Data9`,`Data10`,`Data11`,`Data12`,`Data13`,`Data14`,`Data15`,`Data16`,`Data17`,`Data18`,`Data19`,`Data20`,`Data21`,`Data22`,`Data23`,`Data24`,`Data25`,`Data26`,`Data27`,`Data28`,`Data29`,`Data30`,`Data31`,`Data32`,`unkInt32`,`AIName`,`ScriptName`,`VerifiedBuild`) VALUES +(181260,8,0,'Scorched Grove Runestone','','','',0,0,1,1401,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',0); + +DELETE FROM `gameobject` WHERE `id`= 181260; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`PhaseGroup`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`VerifiedBuild`) VALUES +(99935, 181260, 530, 0, 0, 1, 0, 0, 8206.85, -6335.76, 64.5, 0, 0, 0, 0, 0, 180, 0, 1, 0); |