Advertisement
IcariumQA

Guardian/Battle elixir stack

Jan 24th, 2021
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.49 KB | None | 0 0
  1. #Need group 5:
  2. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=11319;
  3. INSERT INTO `spell_group` VALUES (5, 11319);
  4. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=15231;
  5. INSERT INTO `spell_group` VALUES (5, 15231);
  6. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=15233;
  7. INSERT INTO `spell_group` VALUES (5, 15233);
  8. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16321;
  9. INSERT INTO `spell_group` VALUES (5, 16321);
  10. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16325;
  11. INSERT INTO `spell_group` VALUES (5, 16325);
  12. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16326;
  13. INSERT INTO `spell_group` VALUES (5, 16326);
  14. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16327;
  15. INSERT INTO `spell_group` VALUES (5, 16327);
  16. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=60343;
  17. INSERT INTO `spell_group` VALUES (5, 60343);
  18. DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=60347;
  19. INSERT INTO `spell_group` VALUES (5, 60347);
  20.  
  21. #Need 2:
  22. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=834;
  23. INSERT INTO `spell_group` VALUES (2, 834);
  24. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=2376;
  25. INSERT INTO `spell_group` VALUES (2, 2376);
  26. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3165;
  27. INSERT INTO `spell_group` VALUES (2, 3165);
  28. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3167;
  29. INSERT INTO `spell_group` VALUES (2, 3167);
  30. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3168;
  31. INSERT INTO `spell_group` VALUES (2, 3168);
  32. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3221;
  33. INSERT INTO `spell_group` VALUES (2, 3221);
  34. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11393;
  35. INSERT INTO `spell_group` VALUES (2, 11393);
  36. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11394;
  37. INSERT INTO `spell_group` VALUES (2, 11394);
  38. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11395;
  39. INSERT INTO `spell_group` VALUES (2, 11395);
  40. DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=54497;
  41. INSERT INTO `spell_group` VALUES (2, 54497);
  42.  
  43.  
  44. #Needs 6    
  45. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16322;
  46. INSERT INTO `spell_group` VALUES (6, 16322);
  47. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16323;
  48. INSERT INTO `spell_group` VALUES (6, 16323);
  49. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16329;
  50. INSERT INTO `spell_group` VALUES (6, 16329);
  51. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=28497;
  52. INSERT INTO `spell_group` VALUES (6, 28497);
  53. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=54494;
  54. INSERT INTO `spell_group` VALUES (6, 54494);
  55. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60340;
  56. INSERT INTO `spell_group` VALUES (6, 60340);
  57. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60341;
  58. INSERT INTO `spell_group` VALUES (6, 60341);
  59. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60344;
  60. INSERT INTO `spell_group` VALUES (6, 60344);
  61. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60345;
  62. INSERT INTO `spell_group` VALUES (6, 60345);
  63. DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60346;
  64. INSERT INTO `spell_group` VALUES (6, 60346);
  65.  
  66.  
  67. #Needs 1
  68. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3157;
  69. INSERT INTO `spell_group` VALUES (1, 3157);
  70. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3158;
  71. INSERT INTO `spell_group` VALUES (1, 3158);
  72. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3159;
  73. INSERT INTO `spell_group` VALUES (1, 3159);
  74. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3161;
  75. INSERT INTO `spell_group` VALUES (1, 3161);
  76. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3162;
  77. INSERT INTO `spell_group` VALUES (1, 3162);
  78. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3163;
  79. INSERT INTO `spell_group` VALUES (1, 3163);
  80. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11330;
  81. INSERT INTO `spell_group` VALUES (1, 11330);
  82. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11331;
  83. INSERT INTO `spell_group` VALUES (1, 11331);
  84. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11332;
  85. INSERT INTO `spell_group` VALUES (1, 11332);
  86. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11333;
  87. INSERT INTO `spell_group` VALUES (1, 11333);
  88. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11404;
  89. INSERT INTO `spell_group` VALUES (1, 11404);
  90. DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=50166;
  91. INSERT INTO `spell_group` VALUES (1, 50166);
  92.  
  93. #regex control
  94. #DELETE FROM `spell_group` WHERE `id`=\d+ AND `spell_id`=\d+;\nINSERT INTO `spell_group` VALUES \(\d+, \d+\);
  95. #Control
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement