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.
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);