Quest don't work with last YTDB.
2) DB have no EventAI script 2876806 so update this do nothing...
3) If to add NPC 28768 into world - they without horse.
SO:
1) Need add spawn 28768 into SQL screept or report to YTDB.
2) Need add script 2876806 for NPC 28768, not update.
Look like npc 28782 has own script but I can't found it... I can't understand why 28782 on spawn is mounted by 28768... And can't found script where 28782 change faction if he was summoned by 28768 dead...
- Code:
UPDATE `creature_template` SET `unit_flags` = 0 WHERE `entry` = 28782;
DELETE FROM `creature_spell` WHERE `guid` IN (28782);
INSERT INTO `creature_spell` (`guid`, `spell`, `index`) VALUES
(28782, 52362, 0);
UPDATE `quest_template` SET `SrcSpell` = 52359, `ReqCreatureOrGOId1` = 28768, `ReqCreatureOrGOCount1` = 1, `ReqSpellCast1` = 0 WHERE `entry` = 12687;
-- DELETE FROM creature_involvedrelation WHERE quest IN (12687); -- this cause drop id 28653 from YTDB
INSERT IGNORE INTO creature_involvedrelation (id, quest) VALUES (28788, 12687);
UPDATE creature_template SET npcflag = 2 WHERE entry = 28788;
-- replace for one action
UPDATE creature_ai_scripts SET
action1_type = '11',
action1_param1 = '52361',
action1_param2 = '6',
action1_param3 = '16',
action2_type = '11',
action2_param1 = '52357',
action2_param2 = '6',
action2_param3 = '16',
action3_type = '0'
WHERE id = 2876806;
DELETE FROM `creature` WHERE id = 28782;
DELETE FROM `creature_template_addon` WHERE entry = 28782;
UPDATE `npc_spellclick_spells` SET `spell_id` = 46598, `quest_start` = 0, `quest_start_active` = 0, `quest_end` = 0 WHERE `npc_entry` = 28782;
2) DB have no EventAI script 2876806 so update this do nothing...
3) If to add NPC 28768 into world - they without horse.
SO:
1) Need add spawn 28768 into SQL screept or report to YTDB.
2) Need add script 2876806 for NPC 28768, not update.
- Code:
REPLACE INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_param1`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`) VALUES ('2876806', '28768', '6', '0', '11', '52361', '6', '16', '11', '52357', '6', '16');
Look like npc 28782 has own script but I can't found it... I can't understand why 28782 on spawn is mounted by 28768... And can't found script where 28782 change faction if he was summoned by 28768 dead...