Thread: Bard Bot Bug
View Single Post
  #13  
Old 04-04-2017, 12:41 PM
Mistmaker's Avatar
Mistmaker
Sarnak
 
Join Date: Feb 2014
Posts: 77
Default

OK ran the commands. Thanks for helping with this!


Code:
MariaDB [peq]> DELETE FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';
Query OK, 2508 rows affected (0.01 sec)

MariaDB [peq]> INSERT INTO `bot_spells_entries` (`npc_spells_id`, `spellid`, `type`, `minlevel`, `maxlevel`, `manacost`, `recast_delay`, `priority`, `resist_adjust`) VALUES
    ->
    -> (3008, 0, 4294901760, 0, 0, -1, -1, 0, NULL),
    ->
    -> (3008, 704, 1, 12, 54, -1, -1, 1, NULL),
    ->
    -> (3008, 1747, 1, 55, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 1749, 16, 60, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 743, 256, 38, 64, -1, -1, 1, NULL),
    ->
    -> (3008, 3367, 256, 65, 69, -1, -1, 1, NULL),
    ->
    -> (3008, 5385, 256, 70, 79, -1, -1, 1, NULL),
    ->
    -> (3008, 14074, 256, 80, 84, -1, -1, 1, NULL),
    ->
    -> (3008, 18059, 256, 85, 89, -1, -1, 1, NULL),
    ->
    -> (3008, 26084, 256, 90, 94, -1, -1, 1, NULL),
    ->
    -> (3008, 29182, 256, 95, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 3566, 256, 50, 62, -1, -1, 2, NULL),
    ->
    -> (3008, 3370, 256, 63, 67, -1, -1, 2, NULL),
    ->
    -> (3008, 5378, 256, 68, 77, -1, -1, 2, NULL),
    ->
    -> (3008, 14071, 256, 78, 82, -1, -1, 2, NULL),
    ->
    -> (3008, 18056, 256, 83, 87, -1, -1, 2, NULL),
    ->
    -> (3008, 26033, 256, 88, 92, -1, -1, 2, NULL),
    ->
    -> (3008, 29128, 256, 93, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 744, 256, 46, 62, -1, -1, 3, NULL),
    ->
    -> (3008, 3373, 256, 63, 66, -1, -1, 3, NULL),
    ->
    -> (3008, 5379, 256, 67, 76, -1, -1, 3, NULL),
    ->
    -> (3008, 14068, 256, 77, 81, -1, -1, 3, NULL),
    ->
    -> (3008, 18053, 256, 82, 86, -1, -1, 3, NULL),
    ->
    -> (3008, 26003, 256, 87, 91, -1, -1, 3, NULL),
    ->
    -> (3008, 29101, 256, 92, 127, -1, -1, 3, NULL),
    ->
    -> (3008, 3567, 256, 42, 60, -1, -1, 4, NULL),
    ->
    -> (3008, 3363, 256, 61, 65, -1, -1, 4, NULL),
    ->
    -> (3008, 5371, 256, 66, 75, -1, -1, 4, NULL),
    ->
    -> (3008, 14065, 256, 76, 80, -1, -1, 4, NULL),
    ->
    -> (3008, 18050, 256, 81, 85, -1, -1, 4, NULL),
    ->
    -> (3008, 25976, 256, 86, 90, -1, -1, 4, NULL),
    ->
    -> (3008, 29077, 256, 91, 127, -1, -1, 4, NULL),
    ->
    -> (3008, 707, 256, 30, 59, -1, -1, 5, NULL),
    ->
    -> (3008, 4210, 256, 60, 127, -1, -1, 5, NULL),
    ->
    -> (3008, 738, 8192, 23, 50, -1, -1, 1, NULL),
    ->
    -> (3008, 1751, 8192, 51, 59, -1, -1, 1, NULL),
    ->
    -> (3008, 1748, 8192, 60, 63, -1, -1, 1, NULL),
    ->
    -> (3008, 3066, 8192, 64, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 738, 8192, 51, 63, -1, -1, 2, NULL),
    ->
    -> (3008, 1751, 8192, 64, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 738, 8192, 64, 127, -1, -1, 3, NULL),
    ->
    -> (3008, 3682, 32768, 45, 85, -1, -1, 1, NULL),
    ->
    -> (3008, 25958, 32768, 86, 90, -1, -1, 1, NULL),
    ->
    -> (3008, 29059, 32768, 91, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 3681, 32768, 52, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 10448, 32768, 74, 78, -1, -1, 3, NULL),
    ->
    -> (3008, 14029, 32768, 79, 83, -1, -1, 3, NULL),
    ->
    -> (3008, 18023, 32768, 84, 127, -1, -1, 3, NULL),
    ->
    -> (3008, 1754, 131072, 53, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 10436, 131072, 73, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 2606, 262144, 52, 59, -1, -1, 1, NULL),
    ->
    -> (3008, 2610, 262144, 60, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 700, 262144, 1, 9, -1, -1, 2, NULL),
    ->
    -> (3008, 701, 262144, 10, 35, -1, -1, 2, NULL),
    ->
    -> (3008, 740, 262144, 36, 41, -1, -1, 2, NULL),
    ->
    -> (3008, 702, 262144, 42, 49, -1, -1, 2, NULL),
    ->
    -> (3008, 747, 262144, 50, 61, -1, -1, 2, NULL),
    ->
    -> (3008, 3374, 262144, 62, 64, -1, -1, 2, NULL),
    ->
    -> (3008, 4871, 262144, 65, 67, -1, -1, 2, NULL),
    ->
    -> (3008, 5376, 262144, 68, 78, -1, -1, 2, NULL),
    ->
    -> (3008, 14080, 262144, 79, 83, -1, -1, 2, NULL),
    ->
    -> (3008, 18065, 262144, 84, 88, -1, -1, 2, NULL),
    ->
    -> (3008, 26042, 262144, 89, 93, -1, -1, 2, NULL),
    ->
    -> (3008, 29143, 262144, 94, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 7, 262144, 6, 19, -1, -1, 2, NULL),
    ->
    -> (3008, 1287, 262144, 20, 31, -1, -1, 3, NULL),
    ->
    -> (3008, 723, 262144, 32, 33, -1, -1, 3, NULL),
    ->
    -> (3008, 1448, 262144, 34, 54, -1, -1, 3, NULL),
    ->
    -> (3008, 1759, 262144, 55, 61, -1, -1, 3, NULL),
    ->
    -> (3008, 3651, 262144, 62, 66, -1, -1, 3, NULL),
    ->
    -> (3008, 5377, 262144, 67, 70, -1, -1, 3, NULL),
    ->
    -> (3008, 10421, 262144, 71, 75, -1, -1, 3, NULL),
    ->
    -> (3008, 14008, 262144, 76, 80, -1, -1, 3, NULL),
    ->
    -> (3008, 18008, 262144, 81, 87, -1, -1, 3, NULL),
    ->
    -> (3008, 26015, 262144, 88, 92, -1, -1, 3, NULL),
    ->
    -> (3008, 29107, 262144, 93, 127, -1, -1, 3, NULL),
    ->
    -> (3008, 734, 262144, 7, 8, -1, -1, 4, NULL),
    ->
    -> (3008, 710, 262144, 9, 12, -1, -1, 4, NULL),
    ->
    -> (3008, 711, 262144, 13, 16, -1, -1, 4, NULL),
    ->
    -> (3008, 709, 262144, 17, 40, -1, -1, 4, NULL),
    ->
    -> (3008, 714, 262144, 41, 46, -1, -1, 4, NULL),
    ->
    -> (3008, 748, 262144, 47, 57, -1, -1, 4, NULL),
    ->
    -> (3008, 1763, 262144, 58, 72, -1, -1, 4, NULL),
    ->
    -> (3008, 11881, 262144, 73, 77, -1, -1, 4, NULL),
    ->
    -> (3008, 14056, 262144, 78, 82, -1, -1, 4, NULL),
    ->
    -> (3008, 18041, 262144, 83, 87, -1, -1, 4, NULL),
    ->
    -> (3008, 26027, 262144, 88, 92, -1, -1, 4, NULL),
    ->
    -> (3008, 29122, 262144, 93, 127, -1, -1, 4, NULL),
    ->
    -> (3008, 734, 262144, 9, 24, -1, -1, 5, NULL),
    ->
    -> (3008, 712, 262144, 25, 28, -1, -1, 5, NULL),
    ->
    -> (3008, 715, 262144, 29, 32, -1, -1, 5, NULL),
    ->
    -> (3008, 713, 262144, 33, 36, -1, -1, 5, NULL),
    ->
    -> (3008, 716, 262144, 37, 44, -1, -1, 5, NULL),
    ->
    -> (3008, 4083, 262144, 45, 52, -1, -1, 5, NULL),
    ->
    -> (3008, 4084, 262144, 53, 63, -1, -1, 5, NULL),
    ->
    -> (3008, 3362, 262144, 64, 64, -1, -1, 5, NULL),
    ->
    -> (3008, 4872, 262144, 65, 68, -1, -1, 5, NULL),
    ->
    -> (3008, 5382, 262144, 69, 75, -1, -1, 5, NULL),
    ->
    -> (3008, 14062, 262144, 76, 80, -1, -1, 5, NULL),
    ->
    -> (3008, 18047, 262144, 81, 85, -1, -1, 5, NULL),
    ->
    -> (3008, 25961, 262144, 86, 90, -1, -1, 5, NULL),
    ->
    -> (3008, 29062, 262144, 91, 127, -1, -1, 5, NULL),
    ->
    -> (3008, 734, 262144, 25, 43, -1, -1, 6, NULL),
    ->
    -> (3008, 4085, 262144, 44, 51, -1, -1, 6, NULL),
    ->
    -> (3008, 4086, 262144, 52, 62, -1, -1, 6, NULL),
    ->
    -> (3008, 4087, 262144, 63, 68, -1, -1, 6, NULL),
    ->
    -> (3008, 5374, 262144, 69, 71, -1, -1, 6, NULL),
    ->
    -> (3008, 10439, 262144, 72, 76, -1, -1, 6, NULL),
    ->
    -> (3008, 14020, 262144, 77, 81, -1, -1, 6, NULL),
    ->
    -> (3008, 18014, 262144, 82, 86, -1, -1, 6, NULL),
    ->
    -> (3008, 25991, 262144, 87, 127, -1, -1, 6, NULL),
    ->
    -> (3008, 734, 262144, 30, 82, -1, -1, 7, NULL),
    ->
    -> (3008, 18020, 262144, 83, 127, -1, -1, 7, NULL),
    ->
    -> (3008, 734, 262144, 83, 127, -1, -1, 8, NULL),
    ->
    -> (3008, 2603, 262144, 30, 127, -1, -1, 9, NULL),
    ->
    -> (3008, 7, 524288, 6, 19, -1, -1, 1, NULL),
    ->
    -> (3008, 1287, 524288, 20, 31, -1, -1, 1, NULL),
    ->
    -> (3008, 723, 524288, 32, 33, -1, -1, 1, NULL),
    ->
    -> (3008, 1448, 524288, 34, 54, -1, -1, 1, NULL),
    ->
    -> (3008, 1759, 524288, 55, 61, -1, -1, 1, NULL),
    ->
    -> (3008, 3651, 524288, 62, 66, -1, -1, 1, NULL),
    ->
    -> (3008, 5377, 524288, 67, 70, -1, -1, 1, NULL),
    ->
    -> (3008, 10421, 524288, 71, 75, -1, -1, 1, NULL),
    ->
    -> (3008, 14008, 524288, 76, 80, -1, -1, 1, NULL),
    ->
    -> (3008, 18008, 524288, 81, 87, -1, -1, 1, NULL),
    ->
    -> (3008, 26015, 524288, 88, 92, -1, -1, 1, NULL),
    ->
    -> (3008, 29107, 524288, 93, 127, -1, -1, 1, NULL),
    ->
    -> (3008, 717, 524288, 5, 29, -1, -1, 2, NULL),
    ->
    -> (3008, 2603, 524288, 30, 127, -1, -1, 2, NULL),
    ->
    -> (3008, 717, 524288, 30, 48, -1, -1, 3, NULL),
    ->
    -> (3008, 2605, 524288, 49, 127, -1, -1, 3, NULL),
    ->
    -> (3008, 2602, 524288, 15, 127, -1, -1, 4, NULL);
Query OK, 132 rows affected (0.01 sec)
Records: 132  Duplicates: 0  Warnings: 0

MariaDB [peq]>
__________________
~ Mr. Gold ~ Pillage and Plunder ~

Last edited by Uleat; 04-04-2017 at 12:48 PM.. Reason: added code tags
Reply With Quote