Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Need group 5:
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=11319;
- INSERT INTO `spell_group` VALUES (5, 11319);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=15231;
- INSERT INTO `spell_group` VALUES (5, 15231);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=15233;
- INSERT INTO `spell_group` VALUES (5, 15233);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16321;
- INSERT INTO `spell_group` VALUES (5, 16321);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16325;
- INSERT INTO `spell_group` VALUES (5, 16325);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16326;
- INSERT INTO `spell_group` VALUES (5, 16326);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=16327;
- INSERT INTO `spell_group` VALUES (5, 16327);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=60343;
- INSERT INTO `spell_group` VALUES (5, 60343);
- DELETE FROM `spell_group` WHERE `id`=5 AND `spell_id`=60347;
- INSERT INTO `spell_group` VALUES (5, 60347);
- #Need 2:
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=834;
- INSERT INTO `spell_group` VALUES (2, 834);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=2376;
- INSERT INTO `spell_group` VALUES (2, 2376);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3165;
- INSERT INTO `spell_group` VALUES (2, 3165);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3167;
- INSERT INTO `spell_group` VALUES (2, 3167);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3168;
- INSERT INTO `spell_group` VALUES (2, 3168);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=3221;
- INSERT INTO `spell_group` VALUES (2, 3221);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11393;
- INSERT INTO `spell_group` VALUES (2, 11393);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11394;
- INSERT INTO `spell_group` VALUES (2, 11394);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=11395;
- INSERT INTO `spell_group` VALUES (2, 11395);
- DELETE FROM `spell_group` WHERE `id`=2 AND `spell_id`=54497;
- INSERT INTO `spell_group` VALUES (2, 54497);
- #Needs 6
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16322;
- INSERT INTO `spell_group` VALUES (6, 16322);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16323;
- INSERT INTO `spell_group` VALUES (6, 16323);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=16329;
- INSERT INTO `spell_group` VALUES (6, 16329);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=28497;
- INSERT INTO `spell_group` VALUES (6, 28497);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=54494;
- INSERT INTO `spell_group` VALUES (6, 54494);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60340;
- INSERT INTO `spell_group` VALUES (6, 60340);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60341;
- INSERT INTO `spell_group` VALUES (6, 60341);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60344;
- INSERT INTO `spell_group` VALUES (6, 60344);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60345;
- INSERT INTO `spell_group` VALUES (6, 60345);
- DELETE FROM `spell_group` WHERE `id`=6 AND `spell_id`=60346;
- INSERT INTO `spell_group` VALUES (6, 60346);
- #Needs 1
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3157;
- INSERT INTO `spell_group` VALUES (1, 3157);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3158;
- INSERT INTO `spell_group` VALUES (1, 3158);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3159;
- INSERT INTO `spell_group` VALUES (1, 3159);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3161;
- INSERT INTO `spell_group` VALUES (1, 3161);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3162;
- INSERT INTO `spell_group` VALUES (1, 3162);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=3163;
- INSERT INTO `spell_group` VALUES (1, 3163);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11330;
- INSERT INTO `spell_group` VALUES (1, 11330);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11331;
- INSERT INTO `spell_group` VALUES (1, 11331);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11332;
- INSERT INTO `spell_group` VALUES (1, 11332);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11333;
- INSERT INTO `spell_group` VALUES (1, 11333);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=11404;
- INSERT INTO `spell_group` VALUES (1, 11404);
- DELETE FROM `spell_group` WHERE `id`=1 AND `spell_id`=50166;
- INSERT INTO `spell_group` VALUES (1, 50166);
- #regex control
- #DELETE FROM `spell_group` WHERE `id`=\d+ AND `spell_id`=\d+;\nINSERT INTO `spell_group` VALUES \(\d+, \d+\);
- #Control
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement