202740 Rich Pyrite Deposit Gilneas Fix

[eyerobot]

There were six ores, Which is wrong, And they were a hundred feet high in the air. This places them on the ground, and adds them in all listed areas.

-- 202740 Rich Pyrite Deposit

DELETE FROM `gameobject` WHERE `id`=202740;

INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -943.831, 1428.83, 52.3801, 1.21066, 0, 0, 0.569032, 0.822315, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1010.13, 1351.46, 48.1157, 0.67266, 0, 0, 0.330025, 0.943972, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1187.3, 1328.39, 26.0764, 6.09191, 0, 0, 0.0954936, -0.99543, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5434, 1, 65535, -1023.09, 1505.67, 46.538, 2.8757, 0, 0, 0.991176, 0.132554, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1183.66, 1596.13, 27.6937, 2.41624, 0, 0, 0.934951, 0.354776, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1026.44, 1700.43, 55.9808, 0.303522, 0, 0, 0.151179, 0.988506, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1119.7, 1839.32, 33.3079, 1.89788, 0, 0, 0.812799, 0.582544, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1214.82, 1924.58, 17.2966, 0.142516, 0, 0, 0.0711977, 0.997462, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -1007.84, 2035.28, 17.8332, 1.25385, 0, 0, 0.586659, 0.809834, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -819.481, 2022.43, 29.1184, 0.138582, 0, 0, 0.0692355, 0.9976, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -754.58, 1911.19, 42.5579, 1.83111, 0, 0, 0.792902, 0.609349, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5440, 1, 65535, -808.666, 1777.35, 70.0607, 5.89162, 0, 0, 0.194537, -0.980895, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5434, 1, 65535, -853.394, 1646.75, 58.2256, 0.228889, 0, 0, 0.114195, 0.993458, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1394.61, 2012.68, 22.5404, 5.95052, 0, 0, 0.165567, -0.986199, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1560.83, 2097.17, 33.5816, 2.10992, 0, 0, 0.869881, 0.493262, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1375.06, 2336.93, 53.6749, 1.68973, 0, 0, 0.747883, 0.663831, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1303.88, 2631.06, 94.2921, 1.09283, 0, 0, 0.519628, 0.854393, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1008.57, 2591.66, 55.0497, 1.52088, 0, 0, 0.68924, 0.724533, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -973.975, 2401.96, 46.9126, 4.05379, 0, 0, 0.897778, -0.440449, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1537.48, 2165.9, 35.2619, 3.43333, 0, 0, 0.98938, -0.14535, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1618.53, 1932.64, 19.1231, 3.70036, 0, 0, 0.961225, -0.275764, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1747.98, 1860.89, 18.0607, 3.33908, 0, 0, 0.995129, -0.0985825, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1835.36, 1721.28, 25.3514, 5.00019, 0, 0, 0.598395, -0.801201, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1986.63, 1702.84, 37.7142, 3.94384, 0, 0, 0.920623, -0.390452, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -2121.71, 1731.08, 8.84892, 5.5971, 0, 0, 0.336355, -0.941735, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -2316.96, 1829.45, 17.0155, 2.42016, 0, 0, 0.935644, 0.352944, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5712, 1, 65535, -2395.18, 1543.33, 1.16309, 5.67563, 0, 0, 0.299125, -0.954214, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5712, 1, 65535, -2285.48, 1264.63, 40.1712, 3.96739, 0, 0, 0.915962, -0.401266, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 5436, 1, 65535, -2057.95, 1027.79, 70.1215, 5.94266, 0, 0, 0.169441, -0.98554, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1795.3, 825.47, 117.035, 5.99371, 0, 0, 0.144234, -0.989544, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1735.58, 1024.51, 53.0531, 0.378111, 0, 0, 0.187931, 0.982182, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1508.55, 1010.64, 16.3602, 0.0325322, 0, 0, 0.0162654, 0.999868, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1365.75, 1139.64, 33.2229, 0.503771, 0, 0, 0.24923, 0.968444, 300, 0, 1);
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (202740, 0, 4706, 4706, 1, 65535, -1148.9, 975.138, 75.9531, 0.342765, 0, 0, 0.170545, 0.98535, 300, 0, 1);

They can be added to the gamobject pool for random spawning. But they have to be listed by guid number. At a later date when all ores guids are stable, I will add them all to the random spawn pools.

 

[ExO]

Executed thanks