This update should fix
Only thing I am unsure of is the creature GUID. This is the guid for my db and If players spawn in their own creature then that guid could already be used. I'm not sure about how to insert the creature without override/giving duplicate error. If anyone can provide a better way please let me know.
Code:
-- Adds in missing quest give in Hellfire Peninsula
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (889238, 16885, 530, 3483, 3808, 1, 1, 0, 16885, -314.819, 4711.44, 18.4204, 2.51488, 300, 0, 0, 6633, 2620, 0, 0, 0, 0, 0, 0);
Only thing I am unsure of is the creature GUID. This is the guid for my db and If players spawn in their own creature then that guid could already be used. I'm not sure about how to insert the creature without override/giving duplicate error. If anyone can provide a better way please let me know.