Bard Bot Bug

[Uleat]

Bear with me...


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

And running..

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

..should return one entry - 'Bard Bot'

Conversely, running..

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

..should return one entry - '3008'


Checking the saved bot entries..

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

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

..returning zero entries and..

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]

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