ratkosrb
23 lines
4.9 KiB
SQL
23 lines
4.9 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`='20240125045513');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20240125045513');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Make these In Combat Timer events with Spell Casts only go on cooldown when cast succeeds.
|
|
UPDATE `creature_ai_events` SET `event_flags`=(`event_flags` | 12) WHERE `id` IN (51305, 56806, 64602, 64603, 64604, 104805, 104806, 105306, 105307, 116706, 117506, 128412, 185304, 193906, 203803, 226905, 260705, 337405, 373905, 375402, 427505, 427506, 432802, 462306, 485202, 485204, 485702, 560105, 584105, 584106, 591504, 604701, 606905, 620602, 707302, 707602, 710101, 780001, 780002, 820501, 830005, 883601, 883602, 903505, 903506, 903507, 926201, 969205, 981902, 981903, 1012001, 1040801, 1041802, 1041803, 1047201, 1047202, 1048905, 1049801, 1049802, 1082206, 1082605, 1144102, 1144702, 1144703, 1145005, 1145006, 1148301, 1148302, 1148602, 1148604, 1148701, 1148702, 1148703, 1148704, 1149001, 1149002, 1149601, 1149602, 1149603, 1149604, 1149705, 1149706, 1149802, 1149803, 1149804, 1150102, 1150103, 1150104, 1150105, 1159802, 1159803, 1159804, 1159805, 1159807, 1160305, 1166801, 1166802, 1174601, 1180401, 1187802, 1194601, 1194602, 1194701, 1194702, 1194703, 1194802, 1194910, 1194911, 1194912, 1224105, 1238005, 1246001, 1246002, 1246101, 1246102, 1246401, 1246402, 1246702, 1246703, 1309610, 1309611, 1309910, 1309911, 1319604, 1319606, 1319608, 1319610, 1319614, 1319615, 1319616, 1319617, 1323609, 1323610, 1325609, 1325610, 1325611, 1325612, 1328402, 1430802, 1432102, 1432104, 1432108, 1432302, 1432304, 1432310, 1432501, 1432502, 1432503, 1432602, 1432604, 1432608, 1435106, 1435107, 1443403, 1443405, 1476202, 1476203, 1476204, 1476302, 1476303, 1476304, 1476402, 1476403, 1476404, 1476502, 1476503, 1476504, 1477202, 1477203, 1477204, 1477302, 1477303, 1477304, 1477602, 1477603, 1477604, 1477702, 1477703, 1477704, 1494301, 1494601, 1520001, 1520004, 1524006, 1524007, 1524601, 1524602, 1524603, 1524604, 1527703, 1527704, 1527705, 1527706, 1530801, 1531102, 1531103, 1531104, 1531105, 1531106, 1531107, 1531108, 1531109, 1531110, 1532402, 1532403, 1532703, 1532704, 1533501, 1533502, 1538601, 1538602, 1538805, 1538806, 1538905, 1538906, 1539005, 1539006, 1539105, 1539106, 1546101, 1546102, 1557103, 1557104, 1557105, 1557106, 1562503, 1562504, 1604203, 1604205, 1608004, 1608005, 1608008, 1608009, 1608011, 1608012, 1608013, 1608014, 1608015, 1608016, 1608017, 1608018, 1608019, 1608022, 1608024, 1616401, 1616801, 1644601);
|
|
UPDATE `creature_ai_scripts` SET `data_flags`=(`data_flags` | 8) WHERE `id` IN (51305, 56806, 64602, 64603, 64604, 104805, 104806, 105306, 105307, 116706, 117506, 128412, 185304, 193906, 203803, 226905, 260705, 337405, 373905, 375402, 427505, 427506, 432802, 462306, 485202, 485204, 485702, 560105, 584105, 584106, 591504, 604701, 606905, 620602, 707302, 707602, 710101, 780001, 780002, 820501, 830005, 883601, 883602, 903505, 903506, 903507, 926201, 969205, 981902, 981903, 1012001, 1040801, 1041802, 1041803, 1047201, 1047202, 1048905, 1049801, 1049802, 1082206, 1082605, 1144102, 1144702, 1144703, 1145005, 1145006, 1148301, 1148302, 1148602, 1148604, 1148701, 1148702, 1148703, 1148704, 1149001, 1149002, 1149601, 1149602, 1149603, 1149604, 1149705, 1149706, 1149802, 1149803, 1149804, 1150102, 1150103, 1150104, 1150105, 1159802, 1159803, 1159804, 1159805, 1159807, 1160305, 1166801, 1166802, 1174601, 1180401, 1187802, 1194601, 1194602, 1194701, 1194702, 1194703, 1194802, 1194910, 1194911, 1194912, 1224105, 1238005, 1246001, 1246002, 1246101, 1246102, 1246401, 1246402, 1246702, 1246703, 1309610, 1309611, 1309910, 1309911, 1319604, 1319606, 1319608, 1319610, 1319614, 1319615, 1319616, 1319617, 1323609, 1323610, 1325609, 1325610, 1325611, 1325612, 1328402, 1430802, 1432102, 1432104, 1432108, 1432302, 1432304, 1432310, 1432501, 1432502, 1432503, 1432602, 1432604, 1432608, 1435106, 1435107, 1443402, 1476202, 1476203, 1476204, 1476302, 1476303, 1476304, 1476402, 1476403, 1476404, 1476502, 1476503, 1476504, 1477202, 1477203, 1477204, 1477302, 1477303, 1477304, 1477602, 1477603, 1477604, 1477702, 1477703, 1477704, 1494301, 1494601, 1520001, 1520004, 1524006, 1524007, 1524601, 1524602, 1524603, 1524604, 1527703, 1527704, 1527705, 1527706, 1530801, 1531102, 1531103, 1531104, 1531105, 1531106, 1531107, 1531108, 1531109, 1531110, 1532402, 1532403, 1532703, 1532704, 1533501, 1533502, 1538601, 1538602, 1538805, 1538806, 1538905, 1538906, 1539005, 1539006, 1539105, 1539106, 1546101, 1546102, 1557103, 1557104, 1557105, 1557106, 1562503, 1562504, 1604203, 1604205, 1608004, 1608005, 1608008, 1608009, 1608011, 1608012, 1608013, 1608014, 1608015, 1608016, 1608017, 1608018, 1608019, 1608022, 1608024, 1616401, 1616801, 1644601);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|