wod [FIX] Quest The King's Command (29547)

[MENZ411]

-- Added Quest The King's Command to Hero's Call Board
DELETE FROM `gameobject_questrelation` WHERE `id` IN (206111, 206294) AND `quest`=29547;
INSERT INTO `gameobject_questrelation` 
(`id`, `quest`) VALUES 
(206111, 29547),
(206294, 29547);

DELETE FROM `creature` WHERE `id`=55567;
INSERT INTO `creature` 
(`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES 
(@, 55567, 0, 1, 1, 0, -8436.23, 324.154, 144.706, 5.402, 300, 0, 0, 1, 0, 0);

-- Kill Credit: A King's Request SAI
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `KillCredit2`=0, `faction_A`=35,`faction_H`=35, `unit_flags`=33554432, `flags_extra`=0 WHERE `entry`=55567;
DELETE FROM `smart_scripts` WHERE `entryorguid`=55567 AND `source_type`=0;
INSERT INTO `smart_scripts` 
(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(55567, 0, 0, 0, 10, 0, 100, 0, 1, 40, 2000, 2000, 86, 130805, 2, 0, 7, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kill Credit: A King''s Request - OOC range - Cast MoP: Alliance Intro Movie PLAY'),
(55567, 0, 1, 0, 11, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kill Credit: A King''s Request - On respawn - Set unseen');

DELETE FROM `conditions` WHERE `SourceEntry`=55567 AND `SourceTypeOrReferenceId`=22;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 55567, 0, 0, 9, 0, 29547, 0, 0, 0, 0, '', 'Execute SAI if quest 29547 taken'),
(22, 1, 55567, 0, 0, 32, 0, 16, 0, 0, 0, 0, '', 'Execute SAI only if player');

 

[Hypnos]

On 1/2/2016 at 0:15 AM, MENZ411 said:

-- Added Quest The King's Command to Hero's Call Board
DELETE FROM `gameobject_questrelation` WHERE `id` IN (206111, 206294) AND `quest`=29547;
INSERT INTO `gameobject_questrelation` 
(`id`, `quest`) VALUES 
(206111, 29547),
(206294, 29547);

DELETE FROM `creature` WHERE `id`=55567;
INSERT INTO `creature` 
(`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES 
(@, 55567, 0, 1, 1, 0, -8436.23, 324.154, 144.706, 5.402, 300, 0, 0, 1, 0, 0);

-- Kill Credit: A King's Request SAI
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `KillCredit2`=0, `faction_A`=35,`faction_H`=35, `unit_flags`=33554432, `flags_extra`=0 WHERE `entry`=55567;
DELETE FROM `smart_scripts` WHERE `entryorguid`=55567 AND `source_type`=0;
INSERT INTO `smart_scripts` 
(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(55567, 0, 0, 0, 10, 0, 100, 0, 1, 40, 2000, 2000, 86, 130805, 2, 0, 7, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kill Credit: A King''s Request - OOC range - Cast MoP: Alliance Intro Movie PLAY'),
(55567, 0, 1, 0, 11, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kill Credit: A King''s Request - On respawn - Set unseen');

DELETE FROM `conditions` WHERE `SourceEntry`=55567 AND `SourceTypeOrReferenceId`=22;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 55567, 0, 0, 9, 0, 29547, 0, 0, 0, 0, '', 'Execute SAI if quest 29547 taken'),
(22, 1, 55567, 0, 0, 32, 0, 16, 0, 0, 0, 0, '', 'Execute SAI only if player');

 

One thing,you dont use a tag for wod if its for mop and viceverse. Table gameobject_questrelation only is in mop db. Or if you didnt know it, tables in wod are differents tables than in mop now (I guess you know it). You specific for which expansion its please.