Mystiq.org - forum: Where the Wild Things Roam -> Dragonblight -> Bugreport

Where the Wild Things Roam
http://old.wowhead.com/quest=12111
Vakcina zvirata healuje, ale nezapisuje se do questu.

bump

nefunguje po hozeni quest itemu se to nezapocita jako splneno

Oprava

DELETE FROM `creature_ai_scripts` WHERE `creature_ai_scripts`.`creature_id` = 26615; --Snowfall Elk delete eventAI
DELETE FROM `creature_ai_scripts` WHERE `creature_ai_scripts`.`creature_id` = 26482; --Arctic Grizzly delete eventAI
UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `creature_template`.`entry` =26615; --Snowfall Elk eventAI->SmartScript
UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `creature_template`.`entry` =26482; --Arctic Grizzly eventAI->SmartScript


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
(26615, 0, 0, 0, 23, 0, 100, 0, 47628, 1, 0, 0, 11, 47675, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - Cast Recently Inoculated on Wildlife Inoculation aura'),
(26615, 0, 1, 0, 23, 0, 100, 1, 47675, 1, 0, 0, 11, 47664, 0, 0, 0, 0, 0, 17, 1, 15, 0, 0, 0, 0, 0, 'Snowfall Elk - Cast Snowfall Elk Credit'),
(26615, 0, 2, 0, 23, 0, 100, 0, 47675, 0, 0, 0, 78, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - After Wildlife Inoculation fade reser script'),
(26615, 0, 3, 0, 0, 0, 100, 0, 8000, 12000, 8000, 12000, 11, 15976, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - Cast Puncture');

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
(26482, 0, 0, 0, 23, 0, 100, 0, 47628, 1, 0, 0, 11, 47675, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Arctic Grizzly - Cast Recently Inoculated on Wildlife Inoculation aura'),
(26482, 0, 1, 0, 23, 0, 100, 1, 47675, 1, 0, 0, 11, 47665, 0, 0, 0, 0, 0, 17, 1, 25, 0, 0, 0, 0, 0, 'Arctic Grizzly - Cast Snowfall Elk Credit'),
(26482, 0, 2, 0, 23, 0, 100, 0, 47675, 0, 0, 0, 78, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Arctic Grizzly - After Wildlife Inoculation fade reser script');

 

Updating status to: Opraví nová revize
Updating severity to: 2 - Fair

codestyle hroznej, ale jinak diky za opravu :-D.. dalsi podrobnosti jsme uz poresili v PM

Code style tak jak to na mě vybleje editor :).

no, priste to uz nevemu :-)... ma to vypadat takhle:

-- Where the Wild Things Roam
SET @SPELL_WILDLIFE := 47628;
SET @SPELL_INOCULATED := 47675;
-- Snowfall Elk SAI
SET @ENTRY := 26615;
SET @SPELL_KC := 47664;
SET @SPELL_PUNCTURE := 15976;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
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
(@ENTRY, 0, 0, 0, 23, 0, 100, 0, @SPELL_WILDLIFE, 1, 0, 0, 11, @SPELL_INOCULATED, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - On Wildlife Inoculation Aura - Cast Recently Inoculated'),
(@ENTRY, 0, 1, 0, 23, 0, 100, 1, @SPELL_INOCULATED, 1, 0, 0, 11, @SPELL_KC, 0, 0, 0, 0, 0, 17, 1, 15, 0, 0, 0, 0, 0, 'Snowfall Elk - On Recently Inoculated Aura - Cast Snowfall Elk Credit'),
(@ENTRY, 0, 2, 0, 23, 0, 100, 0, @SPELL_INOCULATED, 0, 0, 0, 78, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - On Recently Inoculated Aura - Reset script'),
(@ENTRY, 0, 3, 0, 0, 0, 100, 0, 8000, 12000, 8000, 12000, 11, @SPELL_PUNCTURE, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - In Combat - Cast Puncture');
-- Arctic Grizzly SAI
SET @ENTRY := 26615;
SET @SPELL_KC := 47665;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
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
(@ENTRY, 0, 0, 0, 23, 0, 100, 0, @SPELL_WILDLIFE, 1, 0, 0, 11, @SPELL_INOCULATED, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Arctic Grizzly - On Wildlife Inoculation Aura - Cast Recently Inoculated'),
(@ENTRY, 0, 1, 0, 23, 0, 100, 1, @SPELL_INOCULATED, 1, 0, 0, 11, @SPELL_KC, 0, 0, 0, 0, 0, 17, 1, 25, 0, 0, 0, 0, 0, 'Arctic Grizzly - On Recently Inoculated Aura - Cast Arctic Grizzly Credit'),
(@ENTRY, 0, 2, 0, 23, 0, 100, 0, @SPELL_INOCULATED, 0, 0, 0, 78, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Snowfall Elk - On Recently Inoculated Aura - Reset script');

Updating status to: Opravené