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