sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20251117213153_world.sql
T

106 lines
10 KiB
SQL
Raw Permalink Blame History

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20251117213153');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20251117213153');
-- Add your query below.
-- Add fire and smoke gameobjects for quest When Smokey Sings, I Get Violent (6041).
-- 177669 = Plaguewood Fire (Small)
-- 177670 = Plaguewood Fire (Large)
-- 177671 = Plaguewood Smoke
DELETE FROM `gameobject` WHERE `id` IN (177669, 177670, 177671);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(35881, 177669, 0, 3091.68, -3867.72, 142.11, 1.90241, 0, 0, 0.814116, 0.580703, -180, -180, 100, 1, 0, 0, 0, 10),
(35882, 177670, 0, 3118.58, -3886.65, 138.364, 4.2237, 0, 0, -0.857167, 0.515038, -180, -180, 100, 1, 0, 0, 0, 10),
(35883, 177671, 0, 3133.35, -3872.26, 161.275, 3.56047, 0, 0, -0.978148, 0.207912, -180, -180, 100, 1, 0, 0, 0, 10),
(35884, 177669, 0, 3119.05, -3857.19, 165.627, 4.90438, 0, 0, -0.636078, 0.771625, -180, -180, 100, 1, 0, 0, 0, 10),
(35885, 177670, 0, 3103.11, -3872.83, 138.363, 1.98967, 0, 0, 0.83867, 0.54464, -180, -180, 100, 1, 0, 0, 0, 10),
(35886, 177671, 0, 3111.18, -3870.99, 152.691, 4.41568, 0, 0, -0.803857, 0.594823, -180, -180, 100, 1, 0, 0, 0, 10),
(35887, 177670, 0, 3113.72, -3852.81, 138.364, 0.139624, 0, 0, 0.0697556, 0.997564, -180, -180, 100, 1, 0, 0, 0, 10),
(35888, 177669, 0, 3127.08, -3880.09, 166.313, 4.64258, 0, 0, -0.731354, 0.681998, -180, -180, 100, 1, 0, 0, 0, 10),
(35889, 177670, 0, 3112.65, -3873.08, 163.543, 3.4034, 0, 0, -0.991445, 0.130528, -180, -180, 100, 1, 0, 0, 0, 10),
(35890, 177671, 0, 3121.56, -3845.08, 138.364, 6.14356, 0, 0, -0.0697556, 0.997564, -180, -180, 100, 1, 0, 0, 0, 10),
(35892, 177670, 0, 2816.53, -3774.73, 125.424, 3.78737, 0, 0, -0.948323, 0.317306, -180, -180, 100, 1, 0, 0, 0, 10),
(35893, 177671, 0, 2803.39, -3750.83, 150.657, 4.81711, 0, 0, -0.66913, 0.743145, -180, -180, 100, 1, 0, 0, 0, 10),
(35894, 177669, 0, 2797.07, -3756.1, 146.486, 4.88692, 0, 0, -0.642787, 0.766045, -180, -180, 100, 1, 0, 0, 0, 10),
(35895, 177670, 0, 2796.34, -3778.98, 125.424, 3.12412, 0, 0, 0.999962, 0.00873464, -180, -180, 100, 1, 0, 0, 0, 10),
(35896, 177671, 0, 2823.36, -3754.3, 130.373, 0.506145, 0, 0, 0.25038, 0.968148, -180, -180, 100, 1, 0, 0, 0, 10),
(35897, 177670, 0, 2814.97, -3755.91, 146.494, 0.942477, 0, 0, 0.45399, 0.891007, -180, -180, 100, 1, 0, 0, 0, 10),
(35898, 177669, 0, 2790.2, -3772.12, 125.424, 1.37881, 0, 0, 0.636078, 0.771625, -180, -180, 100, 1, 0, 0, 0, 10),
(35899, 177670, 0, 2779.1, -3769.18, 133.583, 5.91667, 0, 0, -0.182235, 0.983255, -180, -180, 100, 1, 0, 0, 0, 10),
(35900, 177671, 0, 2779.57, -3773.03, 125.424, 3.03684, 0, 0, 0.998629, 0.0523532, -180, -180, 100, 1, 0, 0, 0, 10),
(35901, 177669, 0, 2821.02, -3767.79, 126.122, 5.60251, 0, 0, -0.333807, 0.942641, -180, -180, 100, 1, 0, 0, 0, 10),
(35903, 177669, 0, 3292.82, -3675.85, 165.162, 3.35105, 0, 0, -0.994521, 0.104536, -180, -180, 100, 1, 0, 0, 0, 10),
(35904, 177670, 0, 3290.02, -3652.11, 192.079, 0.191985, 0, 0, 0.0958452, 0.995396, -180, -180, 100, 1, 0, 0, 0, 10),
(35905, 177671, 0, 3265.39, -3639.19, 170.059, 0.209439, 0, 0, 0.104528, 0.994522, -180, -180, 100, 1, 0, 0, 0, 10),
(35906, 177669, 0, 3287.85, -3640.42, 195.397, 0.715585, 0, 0, 0.350207, 0.936672, -180, -180, 100, 1, 0, 0, 0, 10),
(35907, 177670, 0, 3282.7, -3676.78, 153.539, 2.82743, 0, 0, 0.987688, 0.156436, -180, -180, 100, 1, 0, 0, 0, 10),
(35908, 177671, 0, 3285.12, -3672.72, 165.542, 1.39626, 0, 0, 0.642787, 0.766045, -180, -180, 100, 1, 0, 0, 0, 10),
(35909, 177670, 0, 3292.67, -3667.09, 181.697, 3.49067, 0, 0, -0.984807, 0.173652, -180, -180, 100, 1, 0, 0, 0, 10),
(35910, 177669, 0, 3272.65, -3663.09, 170.495, 2.68781, 0, 0, 0.97437, 0.224951, -180, -180, 100, 1, 0, 0, 0, 10),
(35911, 177670, 0, 3276.24, -3673.22, 172.374, 4.83456, 0, 0, -0.66262, 0.748956, -180, -180, 100, 1, 0, 0, 0, 10),
(35912, 177671, 0, 3294.22, -3652.75, 225.385, 3.33359, 0, 0, -0.995396, 0.0958512, -180, -180, 100, 1, 0, 0, 0, 10),
(35914, 177669, 0, 3176.61, -3476.86, 176.948, 4.08407, 0, 0, -0.891006, 0.453991, -180, -180, 100, 1, 0, 0, 0, 10),
(35915, 177670, 0, 3186.29, -3471.16, 188.102, 4.20625, 0, 0, -0.861629, 0.507539, -180, -180, 100, 1, 0, 0, 0, 10),
(35916, 177671, 0, 3166.15, -3469.6, 167.395, 0.296705, 0, 0, 0.147809, 0.989016, -180, -180, 100, 1, 0, 0, 0, 10),
(35917, 177669, 0, 3186, -3453.13, 186.468, 5.81195, 0, 0, -0.233445, 0.97237, -180, -180, 100, 1, 0, 0, 0, 10),
(35918, 177670, 0, 3167.99, -3486.61, 167.396, 0.296705, 0, 0, 0.147809, 0.989016, -180, -180, 100, 1, 0, 0, 0, 10),
(35919, 177671, 0, 3190.83, -3457.39, 189.258, 2.63544, 0, 0, 0.968147, 0.250381, -180, -180, 100, 1, 0, 0, 0, 10),
(35920, 177670, 0, 3164.25, -3449.4, 169.784, 4.34587, 0, 0, -0.824126, 0.566406, -180, -180, 100, 1, 0, 0, 0, 10),
(35921, 177669, 0, 3193.17, -3478.93, 167.395, 5.16618, 0, 0, -0.529919, 0.848048, -180, -180, 100, 1, 0, 0, 0, 10),
(35922, 177670, 0, 3170.16, -3468.82, 175.793, 1.74533, 0, 0, 0.766044, 0.642789, -180, -180, 100, 1, 0, 0, 0, 10),
(35923, 177671, 0, 3174.19, -3443.14, 167.395, 5.89921, 0, 0, -0.190808, 0.981627, -180, -180, 100, 1, 0, 0, 0, 10),
(35925, 177669, 0, 3189.52, -3318.71, 190.234, 5.65487, 0, 0, -0.309016, 0.951057, -180, -180, 100, 1, 0, 0, 0, 10),
(35926, 177670, 0, 3161.49, -3299.35, 165.161, 2.77507, 0, 0, 0.983254, 0.182238, -180, -180, 100, 1, 0, 0, 0, 10),
(35927, 177671, 0, 3163.98, -3296.08, 165.161, 0.401425, 0, 0, 0.199368, 0.979925, -180, -180, 100, 1, 0, 0, 0, 10),
(35928, 177670, 0, 3184.14, -3329.16, 183.744, 5.65487, 0, 0, -0.309016, 0.951057, -180, -180, 100, 1, 0, 0, 0, 10),
(35929, 177669, 0, 3164.01, -3340.87, 165.161, 1.67551, 0, 0, 0.743144, 0.669131, -180, -180, 100, 1, 0, 0, 0, 10),
(35930, 177670, 0, 3159.63, -3313.99, 165.161, 0.279252, 0, 0, 0.139173, 0.990268, -180, -180, 100, 1, 0, 0, 0, 10),
(35931, 177671, 0, 3175.83, -3340.91, 165.161, 1.3439, 0, 0, 0.622514, 0.782609, -180, -180, 100, 1, 0, 0, 0, 10),
(35932, 177669, 0, 3162.49, -3325.19, 165.161, 0.0174525, 0, 0, 0.00872612, 0.999962, -180, -180, 100, 1, 0, 0, 0, 10),
(35933, 177670, 0, 3165.36, -3308.71, 174.548, 1.13446, 0, 0, 0.537299, 0.843392, -180, -180, 100, 1, 0, 0, 0, 10),
(35934, 177671, 0, 3179.02, -3313.52, 189.259, 2.19911, 0, 0, 0.891006, 0.453991, -180, -180, 100, 1, 0, 0, 0, 10),
(35936, 177669, 0, 3010.52, -3437.65, 196.405, 1.98967, 0, 0, 0.83867, 0.54464, -180, -180, 100, 1, 0, 0, 0, 10),
(35937, 177670, 0, 3027.19, -3456.36, 154.389, 3.49067, 0, 0, -0.984807, 0.173652, -180, -180, 100, 1, 0, 0, 0, 10),
(35938, 177671, 0, 3014.54, -3431.19, 226.297, 4.31097, 0, 0, -0.833885, 0.551938, -180, -180, 100, 1, 0, 0, 0, 10),
(35939, 177669, 0, 3016.2, -3459.41, 171.35, 5.09636, 0, 0, -0.559193, 0.829038, -180, -180, 100, 1, 0, 0, 0, 10),
(35940, 177670, 0, 3004.38, -3466.35, 165.798, 1.43117, 0, 0, 0.656058, 0.75471, -180, -180, 100, 1, 0, 0, 0, 10),
(35941, 177671, 0, 3000.21, -3435.53, 196.536, 3.35105, 0, 0, -0.994521, 0.104536, -180, -180, 100, 1, 0, 0, 0, 10),
(35942, 177670, 0, 3005.87, -3445.04, 191.677, 2.96704, 0, 0, 0.996194, 0.087165, -180, -180, 100, 1, 0, 0, 0, 10),
(35943, 177669, 0, 2984.74, -3452.45, 170.912, 2.04204, 0, 0, 0.85264, 0.522499, -180, -180, 100, 1, 0, 0, 0, 10),
(35944, 177670, 0, 3000.63, -3457.54, 154.401, 3.10665, 0, 0, 0.999847, 0.0174693, -180, -180, 100, 1, 0, 0, 0, 10),
(35945, 177671, 0, 3026.23, -3454.13, 170.912, 2.14675, 0, 0, 0.878817, 0.47716, -180, -180, 100, 1, 0, 0, 0, 10),
(35947, 177669, 0, 2861.53, -3224.66, 152.042, 2.86234, 0, 0, 0.990268, 0.139175, -180, -180, 100, 1, 0, 0, 0, 10),
(35948, 177670, 0, 2862.17, -3236.17, 158.296, 2.47837, 0, 0, 0.945518, 0.325568, -180, -180, 100, 1, 0, 0, 0, 10),
(35949, 177671, 0, 2855.67, -3211.72, 138.963, 3.194, 0, 0, -0.999657, 0.0262016, -180, -180, 100, 1, 0, 0, 0, 10),
(35950, 177669, 0, 2873.78, -3239.24, 143.623, 0.767944, 0, 0, 0.374606, 0.927184, -180, -180, 100, 1, 0, 0, 0, 10),
(35951, 177670, 0, 2884.44, -3237.57, 134.187, 4.01426, 0, 0, -0.906307, 0.422619, -180, -180, 100, 1, 0, 0, 0, 10),
(35952, 177671, 0, 2846.68, -3232.52, 152.483, 3.97935, 0, 0, -0.913545, 0.406738, -180, -180, 100, 1, 0, 0, 0, 10),
(35953, 177670, 0, 2882.18, -3224.65, 142.176, 2.3911, 0, 0, 0.930417, 0.366502, -180, -180, 100, 1, 0, 0, 0, 10),
(35954, 177669, 0, 2861.7, -3239.81, 155.107, 4.15388, 0, 0, -0.874619, 0.48481, -180, -180, 100, 1, 0, 0, 0, 10),
(35955, 177670, 0, 2871.11, -3231.73, 143.74, 4.60767, 0, 0, -0.743144, 0.669131, -180, -180, 100, 1, 0, 0, 0, 10),
(35956, 177671, 0, 2860.95, -3245.75, 142.392, 0.890117, 0, 0, 0.430511, 0.902586, -180, -180, 100, 1, 0, 0, 0, 10),
(35958, 177670, 0, 3236.63, -3087.24, 183.912, 0.279252, 0, 0, 0.139173, 0.990268, -180, -180, 100, 1, 0, 0, 0, 10),
(35959, 177669, 0, 3238.88, -3103.21, 184.533, 3.3685, 0, 0, -0.993571, 0.113208, -180, -180, 100, 1, 0, 0, 0, 10),
(35960, 177670, 0, 3220.86, -3089.26, 168.905, 2.09439, 0, 0, 0.866025, 0.500001, -180, -180, 100, 1, 0, 0, 0, 10),
(35961, 177671, 0, 3218.95, -3097.26, 171.276, 0.157079, 0, 0, 0.0784588, 0.996917, -180, -180, 100, 1, 0, 0, 0, 10),
(35962, 177669, 0, 3239.17, -3087.38, 186.353, 6.03884, 0, 0, -0.121869, 0.992546, -180, -180, 100, 1, 0, 0, 0, 10),
(35963, 177670, 0, 3217.76, -3098.61, 170.9, 5.00909, 0, 0, -0.594823, 0.803857, -180, -180, 100, 1, 0, 0, 0, 10),
(35964, 177671, 0, 3243.33, -3095.95, 181.775, 2.51327, 0, 0, 0.951056, 0.309017, -180, -180, 100, 1, 0, 0, 0, 10),
(35965, 177669, 0, 3226.67, -3085.05, 171.56, 4.92183, 0, 0, -0.62932, 0.777146, -180, -180, 100, 1, 0, 0, 0, 10),
(35966, 177670, 0, 3220.2, -3096.96, 173.28, 5.37562, 0, 0, -0.438371, 0.898794, -180, -180, 100, 1, 0, 0, 0, 10),
(35967, 177671, 0, 3220.62, -3105.57, 163.417, 0.296705, 0, 0, 0.147809, 0.989016, -180, -180, 100, 1, 0, 0, 0, 10);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink