Quest & Spawns for quest
https://www.wowhead.com/quest=27069/steel-thunder
There are sea dog crates (gameobjects) spawned but the quest according to the DB info and wowhead requires a npc Orc Crate.
Therefore modified the faction and spawned 5 crates. Tested & working fine. Just seems strange...
quests
https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer -- missing npc https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer (pc will rephase later but not spawned in first phase)
https://www.wowhead.com/quest=27462/to-take-the-barracks -- missing npc...
I deleted the character in question and used a backup restoration from a previous week so a little loss of progress. Problem solved. Thx for the return.
Not working yet as the smart script fix for some reason is not working - posting to see if better/cleverer people can spot the problem and fix it.
I posted a temp work-a-round solution below
Quest *** NOT WORKING fix for the moment ***
https://www.wowhead.com/quest=27089/ace-in-the-hole -- no...
Quest
https://www.wowhead.com/quest=25758/a-gap-in-their-armor -- quest loot missing https://www.wowhead.com/item=55809/twilight-armor-plate from https://www.wowhead.com/npc=41030/twilight-dragonkin-armorer
Not important as armor items are also on the ground.
--...
I'm playing questing etc. and then when I encounter something I check and try to rectify it.
Apart from spawns most changes are done via HeidiSQL and even with spawns I then use HeidiSQL to export the SQL code.
Apart from that, I use wowhead as reference and my own memeory from the official (I...
Missing NPC spawn https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest as you can fly directly, but npc missing nevertheless)
-- https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest but missing nevertheless)
SELECT MAX(guid)+1 into @var FROM creature...
Corrected. Small typo DSELECT instead of SELECT.
You may want to delete the new spawns (highest GUID, map 564) from the creature table before re-runnning or you'll have doubles.
https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest
Quest worked before just that the markers were reversed.
-- https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest
UPDATE creature...