All pastes #1559480 Raw Edit

Finding the Survivors

public sql v1 · immutable
#1559480 ·published 2009-09-09 08:12 UTC
rendered paste body
DELETE FROM `gameobject` WHERE id IN(182484, 182486, 182487, 182488, 182489, 182490, 182491, 182492, 182493, 182494, 182495, 182496, 182497, 182498, 182499, 182500, 182501, 182502, 182503, 182504);INSERT INTO `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES(182484, 530, 1, 1, -1002.32, 9001.62, 94.0743, 2.25148, 0, 0, 0.902585, 0.430511, 181, 100, 1),(182484, 530, 1, 1, -976.394, 8933, 102.83, 0.558505, 0, 0, 0.275637, 0.961262, 181, 100, 1),(182484, 530, 1, 1, -1078.63, 8983.06, 102.114, -2.6529, 0, 0, 0.970296, -0.241922, 181, 100, 1),(182484, 530, 1, 1, -1130.24, 8993.68, 103.982, -2.49582, 0, 0, 0.948324, -0.317305, 181, 100, 1),(182484, 530, 1, 1, -854.94, 8862.32, 185.552, -0.663225, 0, 0, 0.325568, -0.945519, 181, 100, 1),(182484, 530, 1, 1, -826.163, 8827.27, 183.139, -1.37881, 0, 0, 0.636078, -0.771625, 181, 100, 1),(182484, 530, 1, 1, -883.099, 8901.59, 184.317, -2.30383, 0, 0, 0.913545, -0.406737, 181, 100, 1),(182484, 530, 1, 1, -684.823, 8833.48, 197.663, -2.16421, 0, 0, 0.882948, -0.469472, 181, 100, 1),(182484, 530, 1, 1, -677.885, 8744.59, 185.07, 1.6057, 0, 0, 0.71934, 0.694658, 181, 100, 1),(182484, 530, 1, 1, -851.533, 8895.55, 183.418, 2.72271, 0, 0, 0.978148, 0.207912, 181, 100, 1),(182484, 530, 1, 1, -890.341, 8702.54, 251.576, -1.98968, 0, 0, 0.838671, -0.544639, 181, 100, 1),(182484, 530, 1, 1, -862.766, 8671.43, 251.664, 0.959931, 0, 0, 0.461749, 0.887011, 181, 100, 1),(182484, 530, 1, 1, -892.697, 8751.08, 174.312, -2.30383, 0, 0, 0.913545, -0.406737, 181, 100, 1),(182484, 530, 1, 1, -872.349, 8721.33, 173.324, 0.558505, 0, 0, 0.275637, 0.961262, 181, 100, 1),(182484, 530, 1, 1, -867.616, 8741.48, 176.192, 2.28638, 0, 0, 0.909961, 0.414693, 181, 100, 1),(182484, 530, 1, 1, -910.733, 8695.83, 174.246, 2.9147, 0, 0, 0.993572, 0.113203, 181, 100, 1),(182484, 530, 1, 1, -914.359, 8658.68, 172.982, -0.366519, 0, 0, 0.182236, -0.983255, 181, 100, 1),(182484, 530, 1, 1, -925.915, 8680.9, 174.643, -1.0472, 0, 0, 0.5, -0.866025, 181, 100, 1),(182484, 530, 1, 1, -845.918, 8674.1, 176.428, -0.20944, 0, 0, 0.104528, -0.994522, 181, 100, 1),(182484, 530, 1, 1, -1039.04, 9016.87, 93.6303, -2.56563, 0, 0, 0.95882, -0.284015, 181, 100, 1);UPDATE quest_template SET ReqCreatureOrGOId1=-182484 WHERE entry=9948;UPDATE quest_template SET ReqSourceId1=25604 WHERE entry=9948;UPDATE quest_template SET ReqSourceId4=0 WHERE entry=9948;UPDATE creature_loot_template SET chanceOrQuestChance=-30 WHERE item=25604;