splinecl

I have made the following local workaround.

delete from mangos0.db_scripts where script_guid in (1403,1798);

These scripts remove and add the UNIT_NPC_FLAG_GOSSIP and UNIT_NPC_FLAG_QUESTGIVER from "Hegnar Rumbleshot". This makes it possible to complete the quest without having to wait for all the mortar team scripts to complete.

I still think the triggers for the mortar team are wrong, but can not figure out how to make it trigger from completing the quest. So this is the only workaround I have been able to come out with for now.

Shouldn't the script 

select * from db_scripts where id=1061003;

Be triggered by the end of the quest "Ammo for Rumbleshot"?

SELECT * FROM mangos0.quest_template where entry=5541;

And not start playing just because players are near?

It looks like the script controlling the group of dwarves around "Hegnar Rumbleshot" is interfering with the CMSG_QUESTGIVER_STATUS_QUERY message. As soon as the scripted event with the mortar crew ends, then the CMSG_QUESTGIVER_STATUS_QUERY opcode is received and handled. This also fits with what the log shows.

2018-10-11 22:09:24 DB-SCRIPTS: Process table `db_scripts [type = 3]` id 1061003, command 29 for source Creature (Entry: 10610 Guid: 269) (in world), target Creature (Entry: 10610 Guid: 269) (in world)
2018-10-11 22:09:24 WORLD: Received opcode CMSG_QUESTGIVER_STATUS_QUERY - for Player Oldtoxo (Guid: 8) to Creature (Entry: 1243 Guid: 265)
2018-10-11 22:09:24 WORLD: Sent SMSG_QUESTGIVER_STATUS for Creature (Entry: 1243 Guid: 265)
2018-10-11 22:09:35 Respawning...
2018-10-11 22:09:35 Creature (Entry: 721 Guid: 3611) enters grid[20,31]

Here you can see the script 1061003 ends with command 29 right before CMSG_QUESTGIVER_STATUS_QUERY is handled.

I downgraded my database to MySQL 5.7, as I presume that MySQL 8.0 is not supported yet. But I could not really find any specific MySQL version requirements anywhere.