Bard Bot Bug

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