NickTyrer
128 lines
12 KiB
SQL
128 lines
12 KiB
SQL
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`='20260526133843');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260526133843');
|
|
-- Add your query below.
|
|
|
|
DELETE FROM `creature` WHERE `guid` IN (16480, 16552, 16555, 16550, 16548, 16542, 16540, 16537, 16528, 16521, 16512, 16505, 16504, 16503, 16497, 16388, 16380, 16369, 16367, 16360, 16346, 16328, 16330, 16311, 16546, 16533, 16515, 16499, 16491, 16306, 16558, 16393, 16391, 16389);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (16480, 16552);
|
|
|
|
SET @CGUID := 8127;
|
|
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 2248, 0, 0, -281.678924560546875, -415.949340820312500, 67.86560058593750000, 4.437731742858886718, 300, 480, 10, 1),
|
|
(@CGUID + 001, 2248, 0, 0, -316.470001220703125, -382.149322509765625, 64.87321472167968750, 5.511671066284179687, 300, 480, 10, 1),
|
|
(@CGUID + 002, 2248, 0, 0, -265.162200927734375, -383.891510009765625, 66.94466400146484375, 1.880924820899963378, 300, 480, 10, 1),
|
|
(@CGUID + 003, 2248, 0, 0, -284.295745849609375, -448.095672607421875, 64.27499389648437500, 5.312092304229736328, 300, 480, 10, 1),
|
|
(@CGUID + 004, 2248, 0, 0, -315.952911376953125, -415.509490966796875, 62.59800720214843750, 5.543312072753906250, 300, 480, 10, 1),
|
|
(@CGUID + 005, 2248, 0, 0, -252.410217285156250, -450.736663818359375, 65.71086120605468750, 5.107076644897460937, 300, 480, 10, 1),
|
|
(@CGUID + 006, 2248, 0, 0, -250.425506591796875, -421.264739990234375, 69.73593902587890625, 1.918177008628845214, 300, 480, 10, 1),
|
|
(@CGUID + 007, 2248, 2249, 0, -175.859542846679687, -341.292968750000000, 52.96933746337890625, 4.275863647460937500, 300, 480, 0, 2),
|
|
(@CGUID + 008, 2248, 2249, 0, -233.250839233398437, -349.458618164062500, 48.12525177001953125, 3.098870515823364257, 300, 480, 0, 2),
|
|
(@CGUID + 009, 2248, 2249, 0, -244.327423095703125, -299.697875976562500, 53.30650329589843750, 1.712427139282226562, 300, 480, 0, 2),
|
|
(@CGUID + 010, 2248, 2249, 0, -265.556579589843750, -360.219787597656250, 66.68646240234375000, 4.466641902923583984, 300, 480, 2, 1),
|
|
(@CGUID + 011, 2248, 2249, 0, -231.663925170898437, -382.126525878906250, 70.16932678222656250, 3.670102834701538085, 300, 480, 2, 1),
|
|
(@CGUID + 012, 2248, 2249, 0, -204.441116333007812, -368.950103759765625, 72.96348571777343750, 1.211269378662109375, 300, 480, 2, 1),
|
|
(@CGUID + 013, 2248, 2249, 0, -235.838134765625000, -327.896636962890625, 59.58116912841796875, 4.696682453155517578, 300, 480, 2, 1),
|
|
(@CGUID + 014, 2248, 2249, 0, -191.179321289062500, -346.088928222656250, 72.96348571777343750, 2.732425928115844726, 300, 480, 2, 1),
|
|
(@CGUID + 015, 2248, 2249, 0, -240.761291503906250, -368.050994873046875, 48.23273468017578125, 4.586112022399902343, 300, 480, 2, 1),
|
|
(@CGUID + 016, 2248, 2249, 0, -211.522033691406250, -339.075347900390625, 57.00561523437500000, 3.577924966812133789, 300, 480, 2, 1),
|
|
(@CGUID + 017, 2248, 2249, 0, -186.864639282226562, -322.342346191406250, 73.01432800292968750, 4.865082263946533203, 300, 480, 2, 1),
|
|
(@CGUID + 018, 2248, 2249, 0, -261.576538085937500, -339.489318847656250, 64.74534606933593750, 0.890117883682250976, 300, 480, 2, 1),
|
|
(@CGUID + 019, 2248, 2249, 0, -226.977355957031250, -357.353149414062500, 48.50907516479492187, 1.670808553695678710, 300, 480, 2, 1),
|
|
(@CGUID + 020, 2248, 2249, 0, -173.138183593750000, -329.957855224609375, 52.98387527465820312, 0.872664630413055419, 300, 480, 2, 1),
|
|
(@CGUID + 021, 2248, 2249, 0, -133.047821044921875, -353.998687744140625, 52.85220336914062500, 2.354539632797241210, 300, 480, 2, 1),
|
|
(@CGUID + 022, 2248, 2249, 0, -146.029861450195312, -324.174713134765625, 52.89397430419921875, 2.660317897796630859, 300, 480, 2, 1),
|
|
(@CGUID + 023, 2248, 2249, 0, -184.327331542968750, -339.421875000000000, 53.31945800781250000, 0.226892799139022827, 300, 480, 2, 1),
|
|
(@CGUID + 024, 2248, 2249, 0, -177.804580688476562, -377.701385498046875, 51.62563705444335937, 5.742647171020507812, 300, 480, 2, 1),
|
|
(@CGUID + 025, 2248, 2249, 0, -134.282608032226562, -369.066955566406250, 52.82077026367187500, 6.249055862426757812, 300, 480, 2, 1),
|
|
(@CGUID + 026, 2248, 2249, 0, -297.923919677734375, -300.809692382812500, 43.50025177001953125, 4.003170967102050781, 300, 480, 2, 1),
|
|
(@CGUID + 027, 2248, 2249, 0, -277.208953857421875, -303.783538818359375, 42.00616455078125000, 2.210766792297363281, 300, 480, 2, 1),
|
|
(@CGUID + 028, 2248, 2249, 0, -253.679794311523437, -323.699279785156250, 44.74136352539062500, 4.599831581115722656, 300, 480, 2, 1),
|
|
(@CGUID + 029, 2248, 2249, 0, -312.877929687500000, -304.696685791015625, 43.82530975341796875, 3.527936935424804687, 300, 480, 2, 1),
|
|
(@CGUID + 030, 2248, 2249, 0, -250.766311645507812, -287.362030029296875, 53.00169754028320312, 5.586233139038085937, 300, 480, 2, 1),
|
|
(@CGUID + 031, 2248, 2249, 0, -263.198120117187500, -280.612243652343750, 52.30828857421875000, 4.704873085021972656, 300, 480, 2, 1),
|
|
(@CGUID + 032, 2248, 2249, 0, -282.885040283203125, -283.577850341796875, 51.86797332763671875, 2.024581909179687500, 300, 480, 2, 1),
|
|
(@CGUID + 033, 2248, 2249, 0, -307.329345703125000, -277.534454345703125, 45.86845779418945312, 5.432825088500976562, 300, 480, 2, 1);
|
|
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(@CGUID + 007, 01, -176.071044921875000, -341.746307373046875, 53.03261947631835937, 100, 0, 0),
|
|
(@CGUID + 007, 02, -169.510147094726562, -323.047088623046875, 53.03994750976562500, 100, 0, 0),
|
|
(@CGUID + 007, 03, -148.502517700195312, -324.115142822265625, 52.93767929077148437, 100, 0, 0),
|
|
(@CGUID + 007, 04, -136.872909545898437, -334.441680908203125, 52.90792846679687500, 100, 0, 0),
|
|
(@CGUID + 007, 05, -135.521743774414062, -354.872680664062500, 53.01922988891601562, 100, 0, 0),
|
|
(@CGUID + 007, 06, -141.063400268554687, -366.048187255859375, 52.59134292602539062, 100, 0, 0),
|
|
(@CGUID + 007, 07, -158.928665161132812, -375.296661376953125, 51.99215698242187500, 100, 0, 0),
|
|
(@CGUID + 007, 08, -182.360549926757812, -378.166351318359375, 51.34747314453125000, 100, 0, 0),
|
|
(@CGUID + 007, 09, -208.201553344726562, -366.306640625000000, 49.28047943115234375, 100, 0, 0),
|
|
(@CGUID + 007, 10, -223.513870239257812, -369.434844970703125, 48.43597793579101562, 100, 0, 0),
|
|
(@CGUID + 007, 11, -232.354812622070312, -370.808715820312500, 48.39902496337890625, 100, 0, 0),
|
|
(@CGUID + 007, 12, -235.358474731445312, -360.675933837890625, 48.48664855957031250, 100, 0, 0),
|
|
(@CGUID + 007, 13, -245.574081420898437, -375.203948974609375, 47.76996231079101562, 100, 0, 0),
|
|
(@CGUID + 007, 14, -235.358474731445312, -360.675933837890625, 48.48664855957031250, 100, 0, 0),
|
|
(@CGUID + 007, 15, -232.354812622070312, -370.808715820312500, 48.39902496337890625, 100, 0, 0),
|
|
(@CGUID + 007, 16, -223.513870239257812, -369.434844970703125, 48.43597793579101562, 100, 0, 0),
|
|
(@CGUID + 007, 17, -208.201553344726562, -366.306640625000000, 49.28047943115234375, 100, 0, 0),
|
|
(@CGUID + 007, 18, -182.360549926757812, -378.166351318359375, 51.34747314453125000, 100, 0, 0),
|
|
(@CGUID + 007, 19, -158.928665161132812, -375.296661376953125, 51.99215698242187500, 100, 0, 0),
|
|
(@CGUID + 007, 20, -141.063400268554687, -366.048187255859375, 52.59134292602539062, 100, 0, 0),
|
|
(@CGUID + 007, 21, -135.521743774414062, -354.872680664062500, 53.01922988891601562, 100, 0, 0),
|
|
(@CGUID + 007, 22, -136.872909545898437, -334.441680908203125, 52.90792846679687500, 100, 0, 0),
|
|
(@CGUID + 007, 23, -148.502517700195312, -324.115142822265625, 52.93767929077148437, 100, 0, 0),
|
|
(@CGUID + 007, 24, -169.510147094726562, -323.047088623046875, 53.03994750976562500, 100, 0, 0),
|
|
(@CGUID + 008, 01, -236.804824829101562, -349.306701660156250, 48.25175476074218750, 100, 0, 0),
|
|
(@CGUID + 008, 02, -228.877761840820312, -371.909759521484375, 48.44144821166992187, 100, 0, 0),
|
|
(@CGUID + 008, 03, -209.409271240234375, -363.793853759765625, 49.65924835205078125, 100, 0, 0),
|
|
(@CGUID + 008, 04, -207.301223754882812, -344.808013916015625, 54.46499252319335937, 100, 0, 0),
|
|
(@CGUID + 008, 05, -213.468627929687500, -335.402984619140625, 58.03432846069335937, 100, 0, 0),
|
|
(@CGUID + 008, 06, -231.967285156250000, -325.832672119140625, 58.48109436035156250, 100, 0, 0),
|
|
(@CGUID + 008, 07, -254.434982299804687, -331.710083007812500, 62.94460296630859375, 100, 0, 0),
|
|
(@CGUID + 008, 08, -268.082427978515625, -353.103515625000000, 66.35244750976562500, 100, 0, 0),
|
|
(@CGUID + 008, 09, -265.553863525390625, -385.314575195312500, 67.09784698486328125, 100, 0, 0),
|
|
(@CGUID + 008, 10, -229.939025878906250, -385.830841064453125, 70.27935791015625000, 100, 0, 0),
|
|
(@CGUID + 008, 11, -204.791656494140625, -373.837951660156250, 72.90792846679687500, 100, 0, 0),
|
|
(@CGUID + 008, 12, -186.736389160156250, -352.406951904296875, 73.05039215087890625, 100, 0, 0),
|
|
(@CGUID + 008, 13, -188.906311035156250, -328.062316894531250, 72.90062713623046875, 100, 0, 0),
|
|
(@CGUID + 008, 14, -179.796081542968750, -321.778808593750000, 73.16043090820312500, 100, 0, 0),
|
|
(@CGUID + 008, 15, -205.624084472656250, -321.062896728515625, 73.01275634765625000, 100, 0, 0),
|
|
(@CGUID + 008, 16, -179.796081542968750, -321.778808593750000, 73.16043090820312500, 100, 0, 0),
|
|
(@CGUID + 008, 17, -188.906311035156250, -328.062316894531250, 72.90062713623046875, 100, 0, 0),
|
|
(@CGUID + 008, 18, -186.736389160156250, -352.406951904296875, 73.05039215087890625, 100, 0, 0),
|
|
(@CGUID + 008, 19, -204.791656494140625, -373.837951660156250, 72.90792846679687500, 100, 0, 0),
|
|
(@CGUID + 008, 20, -229.939025878906250, -385.830841064453125, 70.27935791015625000, 100, 0, 0),
|
|
(@CGUID + 008, 21, -265.553863525390625, -385.314575195312500, 67.09784698486328125, 100, 0, 0),
|
|
(@CGUID + 008, 22, -268.082427978515625, -353.103515625000000, 66.35244750976562500, 100, 0, 0),
|
|
(@CGUID + 008, 23, -254.434982299804687, -331.710083007812500, 62.94460296630859375, 100, 0, 0),
|
|
(@CGUID + 008, 24, -231.967285156250000, -325.832672119140625, 58.48109436035156250, 100, 0, 0),
|
|
(@CGUID + 008, 25, -213.468627929687500, -335.402984619140625, 58.03432846069335937, 100, 0, 0),
|
|
(@CGUID + 008, 26, -207.301223754882812, -344.808013916015625, 54.46499252319335937, 100, 0, 0),
|
|
(@CGUID + 008, 27, -209.409271240234375, -363.793853759765625, 49.65924835205078125, 100, 0, 0),
|
|
(@CGUID + 008, 28, -228.877761840820312, -371.909759521484375, 48.44144821166992187, 100, 0, 0),
|
|
(@CGUID + 009, 01, -244.510528564453125, -298.413696289062500, 53.29855728149414062, 100, 0, 0),
|
|
(@CGUID + 009, 02, -265.084594726562500, -280.246582031250000, 52.30096435546875000, 100, 0, 0),
|
|
(@CGUID + 009, 03, -285.181427001953125, -268.796997070312500, 50.19335556030273437, 100, 0, 0),
|
|
(@CGUID + 009, 04, -309.136871337890625, -276.407562255859375, 46.02527618408203125, 100, 0, 0),
|
|
(@CGUID + 009, 05, -307.904907226562500, -300.111694335937500, 43.77861785888671875, 100, 0, 0),
|
|
(@CGUID + 009, 06, -274.538513183593750, -305.921997070312500, 42.35778427124023437, 100, 0, 0),
|
|
(@CGUID + 009, 07, -260.400299072265625, -310.149902343750000, 43.08839416503906250, 100, 0, 0),
|
|
(@CGUID + 009, 08, -253.901931762695312, -326.765045166015625, 44.84787750244140625, 100, 0, 0),
|
|
(@CGUID + 009, 09, -237.012893676757812, -350.895446777343750, 48.30540084838867187, 100, 0, 0),
|
|
(@CGUID + 009, 10, -253.901931762695312, -326.765045166015625, 44.84787750244140625, 100, 0, 0),
|
|
(@CGUID + 009, 11, -260.400299072265625, -310.149902343750000, 43.08839416503906250, 100, 0, 0),
|
|
(@CGUID + 009, 12, -274.538513183593750, -305.921997070312500, 42.35778427124023437, 100, 0, 0),
|
|
(@CGUID + 009, 13, -307.904907226562500, -300.111694335937500, 43.77861785888671875, 100, 0, 0),
|
|
(@CGUID + 009, 14, -309.136871337890625, -276.407562255859375, 46.02527618408203125, 100, 0, 0),
|
|
(@CGUID + 009, 15, -285.181427001953125, -268.796997070312500, 50.19335556030273437, 100, 0, 0),
|
|
(@CGUID + 009, 16, -265.084594726562500, -280.246582031250000, 52.30096435546875000, 100, 0, 0);
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|