1 files changed, 69 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_07_00_world.sql b/sql/updates/world/3.3.5/2019_05_07_00_world.sql
new file mode 100644
index 00000000000..8c387c6f9ca
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_05_07_00_world.sql
@@ -0,0 +1,69 @@
+-- Burn Skorn, Burn!
+DELETE FROM `gameobject` WHERE `guid` IN (8198, 8199, 8200, 8201, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211, 8212, 8213, 8214, 8215, 8230, 8240, 8343, 8471, 8526, 8610, 8611, 8612, 8615, 8621, 8622, 8624, 8625, 8630, 8631, 8633, 8634, 8635, 8638, 8639, 8640, 8649, 8652, 8654, 8655, 8659, 8665, 8666, 8667, 8668, 8675, 8680, 8682, 8683, 8684, 8685);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(8198,186459,571,1,1,1985.689,-4199.646,211.9968,0.4014249,0,0,0.1993675,0.9799248,-1,255,1),
+(8199,186459,571,1,1,1987.45,-4208.759,211.8848,5.724681,0,0,-0.2756367,0.9612619,-1,255,1),
+(8200,186459,571,1,1,1979.066,-4205.462,212.0722,4.450591,0,0,-0.7933531,0.6087617,-1,255,1),
+(8201,186459,571,1,1,1974.21,-4191.979,225.8314,2.18166,0,0,0.8870106,0.4617491,-1,255,1),
+(8202,186459,571,1,1,1986.875,-4195.108,214.5936,3.979355,0,0,-0.9135447,0.4067384,-1,255,1),
+(8203,186459,571,1,1,1989.964,-4212.772,225.8019,5.707228,0,0,-0.2840147,0.9588199,-1,255,1),
+(8204,186459,571,1,1,1980.017,-4214.047,214.6267,1.186823,0,0,0.5591927,0.8290377,-1,255,1),
+(8205,186459,571,1,1,1970.038,-4200.726,214.6259,1.588249,0,0,0.7132502,0.7009096,-1,255,1),
+(8206,186459,571,1,1,1973.521,-4204.552,232.3648,4.747296,0,0,-0.6946583,0.7193398,-1,255,1),
+(8207,186459,571,1,1,1989.609,-4201.002,233.4986,2.007128,0,0,0.8433914,0.5372996,-1,255,1),
+(8208,186457,571,1,1,1974.424,-4204.193,232.9208,1.710422,0,0,0.7547092,0.6560594,-1,255,1),
+(8209,186457,571,1,1,1988.967,-4200.524,233.6839,2.670348,0,0,0.9723692,0.2334484,-1,255,1),
+(8210,186457,571,1,1,1970.146,-4200.552,214.6117,0.2967052,0,0,0.147809,0.9890159,-1,255,1),
+(8211,186457,571,1,1,1980.073,-4214.014,214.6223,0.2268925,0,0,0.113203,0.9935719,-1,255,1),
+(8212,186457,571,1,1,1989.981,-4212.988,225.7699,4.555311,0,0,-0.7604055,0.6494485,-1,255,1),
+(8213,186457,571,1,1,1986.889,-4195.113,214.5941,0.2094394,0,0,0.1045284,0.9945219,-1,255,1),
+(8214,186457,571,1,1,1986.17,-4199.75,212.0388,5.201083,0,0,-0.5150375,0.8571676,-1,255,1),
+(8215,186457,571,1,1,1987.377,-4209.118,211.8848,1.047198,0,0,0.5,0.8660254,-1,255,1),
+(8230,186457,571,1,1,1979.45,-4205.028,212.0634,0.7330382,0,0,0.3583679,0.9335805,-1,255,1),
+(8240,186457,571,1,1,1974.361,-4192.143,225.9106,2.897245,0,0,0.9925461,0.12187,-1,255,1),
+(8343,186459,571,1,1,1952.267,-4033.276,217.8552,3.054327,0,0,0.9990482,0.04361926,-1,255,1),
+(8471,186459,571,1,1,1961.97,-4031.802,218.0276,1.378809,0,0,0.6360779,0.7716249,-1,255,1),
+(8526,186459,571,1,1,1960.288,-4040.559,217.8866,0.7853968,0,0,0.3826828,0.9238798,-1,255,1),
+(8610,186459,571,1,1,1958.174,-4042.92,238.8269,5.93412,0,0,-0.1736479,0.9848078,-1,255,1),
+(8611,186459,571,1,1,1967.432,-4030.207,238.7342,2.216565,0,0,0.8949337,0.4461992,-1,255,1),
+(8612,186459,571,1,1,1973.135,-4040.292,231.8357,1.989672,0,0,0.8386698,0.5446402,-1,255,1),
+(8615,186459,571,1,1,1971.925,-4031.271,220.5622,0.4014249,0,0,0.1993675,0.9799248,-1,255,1),
+(8621,186459,571,1,1,1956.069,-4025.875,220.552,5.864307,0,0,-0.2079115,0.9781476,-1,255,1),
+(8622,186459,571,1,1,1949.085,-4031.797,231.966,3.47321,0,0,-0.9862852,0.1650499,-1,255,1),
+(8624,186459,571,1,1,1961.22,-4044.545,220.554,5.148723,0,0,-0.5372992,0.8433917,-1,255,1),
+(8625,186457,571,1,1,1952.2,-4032.804,217.8552,3.368496,0,0,-0.9935713,0.1132084,-1,255,1),
+(8630,186457,571,1,1,1962.005,-4032.224,218.013,5.550147,0,0,-0.3583679,0.9335805,-1,255,1),
+(8631,186457,571,1,1,1960.595,-4040.675,217.8862,2.216565,0,0,0.8949337,0.4461992,-1,255,1),
+(8633,186457,571,1,1,1959.969,-4043.445,239.0683,6.248279,0,0,-0.01745224,0.9998477,-1,255,1),
+(8634,186457,571,1,1,1968.123,-4030.516,238.8009,0.5934101,0,0,0.2923708,0.956305,-1,255,1),
+(8635,186457,571,1,1,1973.201,-4040.403,231.8186,0.4712385,0,0,0.2334452,0.97237,-1,255,1),
+(8638,186457,571,1,1,1971.925,-4031.236,220.5637,5.183629,0,0,-0.5224981,0.8526405,-1,255,1),
+(8639,186457,571,1,1,1956.29,-4025.705,220.5655,2.652894,0,0,0.970295,0.241925,-1,255,1),
+(8640,186457,571,1,1,1949.158,-4031.608,231.9414,4.32842,0,0,-0.8290367,0.5591941,-1,255,1),
+(8649,186457,571,1,1,1961.262,-4044.667,220.5596,3.68265,0,0,-0.9636297,0.267241,-1,255,1),
+(8652,186459,571,1,1,1866.938,-4185.141,213.6696,5.654869,0,0,-0.3090162,0.9510568,-1,255,1),
+(8654,186459,571,1,1,1891.681,-4164.53,237.93,0.3316107,0,0,0.1650467,0.9862857,-1,255,1),
+(8655,186459,571,1,1,1859.889,-4163.988,238.2612,3.612838,0,0,-0.9723692,0.2334484,-1,255,1),
+(8659,186459,571,1,1,1877.375,-4162.481,248.1042,1.483528,0,0,0.6755896,0.7372779,-1,255,1),
+(8665,186459,571,1,1,1865.444,-4184.342,249.9069,1.361356,0,0,0.6293201,0.7771462,-1,255,1),
+(8666,186459,571,1,1,1884.674,-4180.189,215.6538,5.777041,0,0,-0.2503796,0.9681478,-1,255,1),
+(8667,186459,571,1,1,1877.007,-4165.753,213.6561,3.892087,0,0,-0.9304171,0.3665025,-1,255,1),
+(8668,186457,571,1,1,1866.986,-4185.101,213.6696,3.211419,0,0,-0.9993906,0.03490613,-1,255,1),
+(8675,186457,571,1,1,1891.495,-4164.405,237.9458,3.752462,0,0,-0.9537163,0.3007079,-1,255,1),
+(8680,186457,571,1,1,1859.953,-4164.05,238.2811,4.031712,0,0,-0.902585,0.4305117,-1,255,1),
+(8682,186457,571,1,1,1877.91,-4162.997,248.5425,0.5585039,0,0,0.2756367,0.9612619,-1,255,1),
+(8683,186457,571,1,1,1865.41,-4184.668,249.7655,2.82743,0,0,0.9876881,0.1564362,-1,255,1),
+(8684,186457,571,1,1,1885.205,-4180.103,215.7042,0.3316107,0,0,0.1650467,0.9862857,-1,255,1),
+(8685,186457,571,1,1,1877.144,-4165.463,213.6467,2.268925,0,0,0.9063072,0.4226195,-1,255,1);
+
+DELETE FROM `smart_scripts`   WHERE `entryorguid` IN (24100,24098,24102) AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(24098, 0, 0, 1, 8, 0, 100, 512, 43057, 0, 0, 0, 11, 43058, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Skorn Longhouse NW Bunny - On Spellhit 'Torch' - Cast 'Burn Skorn,, Burn!: NW Kill Credit'"),
+(24098, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186457, 60, 0, 0, 0, 0, 0, "Skorn Longhouse NW Bunny - On Spellhit 'Torch' - Respawn game object'"),
+(24098, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186459, 60, 0, 0, 0, 0, 0, "Skorn Longhouse NW Bunny - On Spellhit 'Torch' - Respawn game object'"),
+(24100, 0, 0, 1, 8, 0, 100, 512, 43057, 0, 0, 0, 11, 43061, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Skorn Longhouse NE Bunny - On Spellhit 'Torch' - Cast 'Burn Skorn,, Burn!: NE Kill Credit'"),
+(24100, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186457, 60, 0, 0, 0, 0, 0, "Skorn Longhouse NE Bunny - On Spellhit 'Torch' - Respawn game object'"),
+(24100, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186459, 60, 0, 0, 0, 0, 0, "Skorn Longhouse NE Bunny - On Spellhit 'Torch' - Respawn game object'"),
+(24102, 0, 0, 1, 8, 0, 100, 512, 43057, 0, 0, 0, 11, 43065, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Skorn Barracks Bunny - On Spellhit 'Torch' - Cast 'Burn Skorn,, Burn!: Barracks Kill Credit'"),
+(24102, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186457, 60, 0, 0, 0, 0, 0, "Skorn Barracks Bunny - On Spellhit 'Torch' - Respawn game object'"),
+(24102, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 30, 0, 0, 0, 0, 0, 15, 186459, 60, 0, 0, 0, 0, 0, "Skorn Barracks Bunny - On Spellhit 'Torch' - Respawn game object'");