rendered paste body-- go template
-- undercity go spell: 35727
-- silvermoon go spell: 35376
-- that other place, lower one go spell: 34448
-- upper one go spell: 34452
update gameobject_template set data10='26572' where entry='180912';
update gameobject_template set data10='26566' where entry='180911';
UPDATE `gameobject_template` SET `type`='10', `displayId`='7161', `name`='Orb of Translocation', `data0`='0', `data1`='0', `data2`='0', `data3`='0', `data4`='0', `data5`='0', `data6`='0', `data7`='0', `data8`='0', `data9`='0', `data11`='0', `data12`='0', `data13`='0', `data14`='0', `data15`='0', `data16`='0', `data17`='0', `data18`='0', `data19`='0', `data20`='0', `data21`='0', `data22`='0', `data23`='0' WHERE `entry` = '180912';
UPDATE `gameobject_template` SET `type`='10', `displayId`='7161', `name`='Orb of Translocation', `data0`='0', `data1`='0', `data2`='0', `data3`='0', `data4`='0', `data5`='0', `data6`='0', `data7`='0', `data8`='0', `data9`='0', `data11`='0', `data12`='0', `data13`='0', `data14`='0', `data15`='0', `data16`='0', `data17`='0', `data18`='0', `data19`='0', `data20`='0', `data21`='0', `data22`='0', `data23`='0' WHERE `entry` = '180911';
UPDATE `gameobject_template` SET `size` = '1.000000', `flags` = '0', `faction` = '1735' WHERE `entry` = '184503';
UPDATE `gameobject_template` SET `size` = '1.000000', `flags` = '0', `faction` = '1604' WHERE `entry` = '184502';
UPDATE `gameobject_template` SET `size` = '0.750000', `flags` = '0', `faction` = '1604' WHERE `entry` = '180912';
UPDATE `gameobject_template` SET `size` = '0.750000', `flags` = '0', `faction` = '1604' WHERE `entry` = '180911';
-- two areatriggers are teleporting you instead of orbs
delete from areatrigger_teleport where id in (4233, 4267);
-- new spawns
delete from gameobject where guid in (13209, 12608, 13210, 12932);
insert into `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('13209','184503','0','1805.85','348.865','70.8727','-0.008727','0','0','-0.004363','0.99999','180','100','1');
insert into `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('12608','184502','530','10032.4','-7000.29','61.3098','-1.57654','0','0','-0.709133','0.705074','180','100','1');
insert into `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('13210','180912','530','9286.04','-7916.09','176.13','-0.401426','0','0','0.199368','-0.979925','180','100','1');
insert into `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('12932','180911','530','9336.16','-7883.44','74.9095','2.1293','0','0','0.87462','0.48481','180','100','1');
-- teleport ...
delete from `spell_teleport` where `id` in (26566, 26572, 35376, 35727, 25649, 35730);
insert into `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) values('26566','530','9330.76','-7811.45','136.57','5.26268');
insert into `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) values('26572','530','9334.2','-7880.19','74.9102','2.18185');
insert into `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) values('25649','0','1804.87','326.886','70.3975','1.57473');
insert into `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) values('35730','530','10021','-7014.19','49.7164','3.90972');