What's new

Minor fixes v14 (Elwynn Forest - Darkmoon Fair Camp)

Stiga

Gold Supporter
Gold Supporter
Registered User
Veteran User
Joined
Aug 19, 2020
Messages
54
Reaction score
84
Location
France
Gender
Male
Issue:- Missing camp just south of Goldshire (same issue on v13.1) Note: Mulgore camp is spawned.

Spawned npcs, gameobjects (gates, wagons, tents etc) and the portal.

Please note that the exact layout of the camp is not exactly like Blizz, I don't have the time to do it exactly, but it looks fine.

SQL:
SELECT MAX(guid)+1 into @var FROM creature; -- https://www.wowhead.com/npc=55093/fire-juggler
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 55088, 0, 12, 87, 1, 65535, 0, 55088, -9557.07, 91.3424, 58.8819, 5.90421, 300, 0, 0, 4050, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature; -- https://www.wowhead.com/npc=55089/fire-juggler
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 55089, 0, 12, 87, 1, 65535, 0, 55089, -9526.31, 86.636, 58.8813, 1.59866, 300, 0, 0, 1651, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature; -- https://www.wowhead.com/npc=55088/fire-eater
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 55093, 0, 12, 87, 1, 65535, 0, 55093, -9526.79, 93.5744, 58.8952, 4.75595, 300, 0, 0, 2062, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature; -- https://www.wowhead.com/npc=54345/darkmoon-faire-greeter
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 54345, 0, 12, 87, 1, 65535, 0, 0, -9544.22, 73.9895, 58.885, 0.290959, 300, 0, 0, 61992, 19400, 0, 0, 0, 0, 0, 0);


SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9564.61, 103.884, 58.8815, 1.79499, 0, 0, 0.781767, 0.623571, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9557.16, 105.845, 58.8822, 1.91908, 0, 0, 0.818927, 0.573898, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9549.57, 108.366, 58.8947, 1.6756, 0, 0, 0.743174, 0.669098, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9542.16, 109.353, 58.9481, 1.54915, 0, 0, 0.699414, 0.714717, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9535.96, 110.828, 58.8819, 1.74236, 0, 0, 0.76509, 0.643923, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9520.48, 94.533, 59.6348, 0.0616102, 0, 0, 0.0308002, 0.999526, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 65535, -9518.47, 86.817, 59.4219, 6.2584, 0, 0, 0.0123921, -0.999923, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Post Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 179965, 0, 12, 87, 1, 1, -9518.34, 79.0077, 59.4511, 5.83664, 0, 0, 0.22142, -0.975178, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Gypsy Wagon --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 180045, 0, 12, 87, 1, 1, -9565.82, 96.3004, 58.8816, 4.84938, 0, 0, 0.657054, -0.753843, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Wagon --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209548, 0, 12, 87, 1, 1, -9563.94, 77.3524, 61.0442, 1.67244, 0, 0, 0.742113, 0.670274, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Ticket Master Tent --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 180034, 0, 12, 87, 1, 1, -9551.08, 72.2499, 58.9561, 1.16899, 0, 0, 0.551777, 0.833992, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 12, 1, 1, -9568.21, 101.97, 58.8813, 5.10069, 0, 0, 0.557396, -0.830247, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9566.45, 102.552, 58.8824, 5.09285, 0, 0, 0.560649, -0.828054, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9564.38, 103.095, 58.8815, 4.9829, 0, 0, 0.605302, -0.795996, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9562.28, 103.506, 58.8826, 5.06143, 0, 0, 0.573585, -0.819146, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9560.14, 104.12, 58.8807, 4.89729, 0, 0, 0.638808, -0.769366, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9558.26, 104.598, 58.8814, 5.10934, 0, 0, 0.5538, -0.83265, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9556.56, 105.449, 58.8819, 4.9185, 0, 0, 0.630614, -0.776097, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9554.58, 105.976, 58.8812, 5.1816, 0, 0, 0.523362, -0.85211, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9552.49, 107.079, 58.882, 5.11877, 0, 0, 0.549868, -0.835252, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9550.18, 107.666, 58.8881, 4.98919, 0, 0, 0.602795, -0.797896, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9548.27, 108.318, 58.9394, 4.93578, 0, 0, 0.623883, -0.781518, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9546.21, 108.164, 59.0171, 5.04574, 0, 0, 0.579994, -0.814621, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9544.19, 108.474, 58.995, 4.8494, 0, 0, 0.657047, -0.75385, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9542.1, 108.624, 58.9661, 5.00569, 0, 0, 0.596192, -0.802842, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9540.24, 108.947, 58.931, 5.08816, 0, 0, 0.562589, -0.826737, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9538.18, 109.523, 58.8814, 5.00569, 0, 0, 0.59619, -0.802844, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9536.25, 110.225, 58.8828, 4.96249, 0, 0, 0.613393, -0.789778, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9534.07, 110.288, 58.8952, 4.80148, 0, 0, 0.674916, -0.737894, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9532.08, 110.514, 59.0347, 4.42449, 0, 0, 0.80123, -0.598356, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9522.37, 98.8109, 59.3624, 3.52129, 0, 0, 0.982033, -0.188709, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9521.95, 96.8424, 59.4337, 3.48594, 0, 0, 0.985214, -0.171327, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9521.05, 94.8671, 59.5651, 3.2464, 0, 0, 0.998627, -0.0523788, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9520.69, 93.0291, 59.5059, 3.33279, 0, 0, 0.995434, -0.0954541, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9520.14, 91.4285, 59.4458, 3.38384, 0, 0, 0.992673, -0.120829, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9519.65, 89.4001, 59.3475, 3.32494, 0, 0, 0.995801, -0.0915444, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.98, 87.4721, 59.3662, 3.22284, 0, 0, 0.999175, -0.0406106, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.6, 85.7264, 59.439, 3.28567, 0, 0, 0.997406, -0.0719754, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.34, 83.7438, 59.3991, 3.19142, 0, 0, 0.99969, -0.0249113, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.09, 81.9548, 59.4658, 2.86941, 0, 0, 0.990754, 0.135673, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.56, 80.6782, 59.4414, 2.92831, 0, 0, 0.994319, 0.106438, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9518.94, 79.0792, 59.3844, 2.83014, 0, 0, 0.987899, 0.155099, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9520.83, 74.8418, 59.4567, 2.49242, 0, 0, 0.947782, 0.318919, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Fence --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209634, 0, 12, 87, 1, 1, -9519.36, 77.42, 59.4057, 2.63771, 0, 0, 0.968431, 0.249282, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Entrance Banner --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 180029, 0, 12, 87, 1, 1, -9526.81, 70.8827, 58.8939, 2.41388, 0, 0, 0.934531, 0.355883, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Portal Entrance --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 210177, 0, 12, 87, 1, 1, -9539.68, 92.4261, 58.8906, 2.34319, 0, 0, 0.921372, 0.388681, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject; -- Darkmoon Faire Portal --
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 209538, 0, 12, 87, 1, 1, -9539.45, 92.1098, 58.892, 2.38246, 0, 0, 0.928826, 0.370517, 300, 0, 1);
 

Jenniy

Gold Supporter
Gold Supporter
Supporter
Senior User
Joined
Jan 1, 2020
Messages
196
Reaction score
43
You're spoiling us! ? Thanks for all the work, even if this particular thing is a reiteration of something you already had made for the previous version!
 

CADIRETO

Gold Supporter
Gold Supporter
Veteran User
Senior User
Joined
May 15, 2015
Messages
150
Reaction score
28
thanks!!!! nice
 

ExO

Administrator
Staff Member
Admin
Mythical User
Joined
Mar 29, 2014
Messages
4,599
Reaction score
409
Executed in the upcoming V15 DB.
Thanks for your contribution!
 
Top