telsamat
31.10.2011, 15:10
ytdb 609
tc core from date 31.10.2011
original author : WishToDie
quest http://www.wowhead.com/quest=12244 not it is not working, if you bring the "robot" to Synipus aand click on deliver icon nothing happens
I just made a little correction for YTDB, it is working well
-- Shredder Repair (12244)
SET @ENTRY := 27354; -- Broken-down Shredder
SET @ENTRY2 := 27371; -- Synipus
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@ENTRY;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`, `aura_required`, `aura_forbidden`, `user_type`) VALUES
(@ENTRY, 60944, 12244, 1, 0, 1, 0, 0, 0); -- Ride Shredder
DELETE FROM `conditions` WHERE `SourceEntry`=48610;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEn try`,`ElseGroup`,`ConditionTypeOrReference`,`Condi tionValue1`,`ConditionValue2`,`ConditionValue3`,`E rrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,48610,0,29,@ENTRY2,5,0,0,'', "Use spell Shredder Delivery only near Synipus - 5 yards"),
(13,0,48610,0,18,1,@ENTRY,0,0,'', "Spell Shredder Delivery target vehicle Broken-down Shredder ");
DELETE FROM `spell_scripts` WHERE `id`=48610;
INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`dat along2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
(48610,2,0,18,3,@ENTRY,2,0,0,0,0); -- Despawn vehicle
tc core from date 31.10.2011
original author : WishToDie
quest http://www.wowhead.com/quest=12244 not it is not working, if you bring the "robot" to Synipus aand click on deliver icon nothing happens
I just made a little correction for YTDB, it is working well
-- Shredder Repair (12244)
SET @ENTRY := 27354; -- Broken-down Shredder
SET @ENTRY2 := 27371; -- Synipus
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@ENTRY;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`, `aura_required`, `aura_forbidden`, `user_type`) VALUES
(@ENTRY, 60944, 12244, 1, 0, 1, 0, 0, 0); -- Ride Shredder
DELETE FROM `conditions` WHERE `SourceEntry`=48610;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEn try`,`ElseGroup`,`ConditionTypeOrReference`,`Condi tionValue1`,`ConditionValue2`,`ConditionValue3`,`E rrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,48610,0,29,@ENTRY2,5,0,0,'', "Use spell Shredder Delivery only near Synipus - 5 yards"),
(13,0,48610,0,18,1,@ENTRY,0,0,'', "Spell Shredder Delivery target vehicle Broken-down Shredder ");
DELETE FROM `spell_scripts` WHERE `id`=48610;
INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`dat along2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
(48610,2,0,18,3,@ENTRY,2,0,0,0,0); -- Despawn vehicle