rendered paste body
-- reworked gameobject_template `entry` using a logic
-- also `name` should be changed in future
-- Silvermoon "Orb of Transportation"
DELETE FROM `gameobject_template` WHERE (`entry`=180911);
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `ScriptName`) VALUES (180911, 22, 7161, 'Orb of Translocation - Silvermoon', 1604, 0, 1, 17611, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE (`guid`=401419);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `loot`, `spawntimesecs`, `animprogress`, `dynflags`) VALUES (401419, 180911, 530, '10032.4', '-7000.29', '61.3098', '-1.57654', 0, 0, 0, 0, 0, 120, 100, 0);
-- Undercity "Orb of Transportation"
DELETE FROM `gameobject_template` WHERE (`entry`=180912);
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `ScriptName`) VALUES (180912, 22, 7161, 'Orb of Translocation - Undercity', 1604, 0, 1, 32270, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE (`guid`=403640);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `loot`, `spawntimesecs`, `animprogress`, `dynflags`) VALUES (403640, 180912, 0, '1806.16', '349.074', '70.7837', '4.71239', 0, 0, '0.707107', '-0.707107', 0, 25, 0, 0);