Bard Bot Bug

Mistmaker · #1 04-02-2017, 04:30 AM

Bard bots only play one song now. Niv's Harmonic.

Tested with GM account and player account. This changed after last update.

Created new bots and used ones I already had. Also used different race/combos. They do the same spell in combat and out of combat.

**Uleat** · #2 04-02-2017, 02:28 PM

I haven't changed anything with that since it was working...

But, I will take a look as soon as I can

**Uleat** · #3 04-02-2017, 04:58 PM

What level is your test?

Mistmaker · #4 04-03-2017, 01:45 AM

I only tested with level 70.

**Uleat** · #5 04-03-2017, 03:36 PM

I tested last night at level 70 with my main (monk) and a bard bot.

All songs were correctly cast depending on out-of-combat/pre-combat/in-combat mode.

You were having issues with the server boot-up process before, right? (circular updating)

I can post a few queries for you to test with to make sure your bard songs are the correct ones.

Mistmaker · #6 04-03-2017, 06:14 PM

OK thanks! Yes, I had circular updating. That's gone now though.

**Uleat** · #7 04-03-2017, 06:59 PM

Bear with me...

This is where we assign the npc_spell_id: https://github.com/EQEmu/Server/blob...e/bot.cpp#L487

And running..

Code:

SELECT `name` FROM `npc_spells` WHERE `id` = '3008';

..should return one entry - 'Bard Bot'

Conversely, running..

Code:

SELECT `id` FROM `npc_spells` WHERE `name` = 'Bard Bot';

..should return one entry - '3008'

Checking the saved bot entries..

Code:

SELECT `spells_id` FROM `bot_data` WHERE `spells_id` < '3001' OR `spells_id` > '3016';

..should return zero (0) entries.

Finally, check the spell entries tables with..

Code:

SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` < '3001' OR `npc_spells_id` > '3016';

..returning zero entries and..

Code:

SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';

returning 132 entries.

If these queries don't produce the expected results, don't delete anything and we'll go from there.

Mistmaker · #8 04-04-2017, 12:47 AM

MariaDB [peq]> SELECT `name` FROM `npc_spells` WHERE `id` = '3008';
+----------+
| name |
+----------+
| Bard Bot |
+----------+
1 row in set (0.00 sec)

MariaDB [peq]> SELECT `id` FROM `npc_spells` WHERE `name` = 'Bard Bot';
+------+
| id |
+------+
| 3008 |
+------+
1 row in set (0.00 sec)

MariaDB [peq]> SELECT `spells_id` FROM `bot_data` WHERE `spells_id` < '3001' OR `spells_id` > '3016';
Empty set (0.00 sec)

MariaDB [peq]> SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` < '3001' OR `npc_spells_id` > '3016';
Empty set (0.00 sec)

MariaDB [peq]> SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';
+---------------+
| npc_spells_id |
+---------------+
| 3008 |
| 3008 |
<...>
| 3008 |
| 3008 |
+---------------+
2508 rows in set (0.00 sec)

MariaDB [peq]>

**Uleat** · #9 04-04-2017, 11:49 AM

That last query was a mistake on my part..really should have been:

Code:

SELECT * FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';

..you don't need to re-run that or post new results.

Since you have 2508 entries, rather than the 132 I expected, I think we can start there.

Taking 2508 and dividing by 132 - which gives 19 - I'd say that you have at least an 18-fold duplication problem.

Try running this and see what you get:

Code:

SELECT COUNT(*) FROM `bot_spells_entries`;

I have 1347 entries..but, I expect you to have 3723 entries.

In that case you just have an over-applied bard bot spells update. If you have more, then the other spells may be (somehow) over-updated as well.

Let me know and we can go from there.

Mistmaker · #10 04-04-2017, 12:02 PM

Here are the new results...

Current database: peq

+----------+
| COUNT(*) |
+----------+
| 3723 |
+----------+
1 row in set (0.01 sec)

MariaDB [peq]>

**Uleat** · #11 04-04-2017, 12:12 PM

Ok, gimme a few minutes here and I'll export my entries for that table so you can just re-insert them without any complicated update process..

**Uleat** · #12 04-04-2017, 12:23 PM

Try this:

Code:

DELETE FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';

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);

Mistmaker · #13 04-04-2017, 12:41 PM

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]>

**Uleat** · #14 04-04-2017, 12:45 PM

Let me know if that solves the problem.

If not, we can dig some more.

Mistmaker · #15 04-04-2017, 12:48 PM

Tested with a newly created Bard and it's still just doing the same spell. :(