Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Convert Several Gameobject scripts to SAI #26497

Open
dr-j opened this issue Apr 30, 2021 · 2 comments
Open

Convert Several Gameobject scripts to SAI #26497

dr-j opened this issue Apr 30, 2021 · 2 comments
Labels
Branch-3.3.5a Comp-Database Feedback-PatchFix

Comments

@dr-j
Copy link
Contributor

dr-j commented Apr 30, 2021

Working on scripts from https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/scripts/World/go_scripts.cpp

replaces: -

go_gilded_brazier
go_southfury_moonstone
go_resonite_cask
go_tablet_of_the_seven (using gossip rather than just on gossip hello which instantly triggered cast rather than via gossip option)
go_amberpine_outhouse
go_veil_skith_cage
go_blood_filled_orb

-- Gilded Brazier
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=181956;
DELETE FROM `smart_scripts` WHERE `entryorguid`=181956 AND `source_type`=1 AND `id`=0 AND `link`=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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(181956, 1, 0, 0, 70, 0, 100, 0, 2, 0, 0, 0, 0, 12, 17716, 1, 60000, 1, 0, 0, 8, 0, 0, 0, 0, 8106.11, -7542.06, 151.775, 3.02598, 0, 'Gilded Brazier - On Gossip Hello - Summon Sangrias Stillblade');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=181956 AND `SourceId`=1;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 181956, 1, 0, 29, 1, 17716, 200, 0, 1, 0, 0, '', 'SAI triggers only if Sangrias Stillblade is not already spawned');
-- Tablet of the Seven
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=169294;
DELETE FROM `smart_scripts` WHERE `entryorguid`=179879 AND `source_type`=1;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(169294, 1, 0, 1, 62, 0, 100, 0, 2187, 0, 0, 0, 0, 134, 15065, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tablet of The Severn - On Gossip Option Select - Player Cast Create Tablet Transcript'),
(169294, 1, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tablet of The Severn - On Gossip Option Select - Close Gossip');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=2187 AND `SourceEntry`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(15, 2187, 0, 0, 0, 9, 0, 4296, 0, 0, 0, 0, 0, '', 'Requires quest 4261 (Tablet of the Seven) taken');
-- Resonate Cask
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=178145;
DELETE FROM `smart_scripts` WHERE `entryorguid`=178145 AND `source_type`=1 AND `id`=0 AND `link`=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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(178145, 1, 0, 0, 70, 0, 100, 0, 2, 0, 0, 0, 0, 12, 11920, 1, 60000, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Resonite Cask - On Gossip Hello - Summon Goggeroc');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=178145 AND `SourceId`=1;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 178145, 1, 0, 29, 1, 11920, 200, 0, 1, 0, 0, '', 'SAI triggers only if Goggeroc is not already spawned');
-- Southfury Moonstone
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=185566;
DELETE FROM `smart_scripts` WHERE `entryorguid`=185566 AND `source_type`=1;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(185566, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 0, 134, 39866, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southfury Moonstone - On Gossip Hello - Cast Summon Rizzle '),
(185566, 1, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 134, 39865, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southfury Moonstone - On Gossip Hello - Cast Blackjack');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=185566 AND `SourceId`=1;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 185566, 1, 0, 29, 1, 23002, 200, 0, 1, 0, 0, '', 'SAI triggers only if rizzle is not already spawned');
-- Blood Filled Orb
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=182024;
DELETE FROM `smart_scripts` WHERE `entryorguid`=182024 AND `source_type`=1 AND `id`=0 AND `link`=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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(182024, 1, 0, 0, 70, 0, 100, 0, 2, 0, 0, 0, 0, 12, 17830, 1, 30000, 1, 0, 0, 8, 0, 0, 0, 0, -369.746, 166.759, -21.50, 5.235, 0, 'Blood filled Orb - On Gossip Hello - Summon Zelemar the Wrathful');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=182024 AND `SourceId`=1;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 182024, 1, 0, 29, 1, 17830, 200, 0, 1, 0, 0, '', 'SAI triggers only if Zelemar the Wrathful is not already spawned');
-- Amberpine Outhouse
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`=188666;
DELETE FROM `smart_scripts` WHERE `entryorguid`=188666 AND `source_type`=1;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(188666, 1, 0, 1, 62, 0, 100, 0, 9492, 0, 0, 0, 0, 45, 1, 1, 0, 9, 0, 0, 19, 27326, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Set Data to Outhouse Bunny'),
(188666, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 0, 85, 48341, 0, 0, 0, 0, 0, 19, 27326, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Cross Cast Indisposed III'),
(188666, 1, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 0, 134, 53017, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Cast Indisposed'),
(188666, 1, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Close Gossip'),
(188666, 1, 4, 5, 62, 0, 100, 0, 9492, 1, 0, 0, 0, 45, 2, 2, 0, 9, 0, 0, 19, 27326, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Set Data to Outhouse Bunny'),
(188666, 1, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 0, 85, 48341, 0, 0, 0, 0, 0, 19, 27326, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Cross Cast Indisposed III'),
(188666, 1, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 0, 134, 53017, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Cast Indisposed'),
(188666, 1, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Amberpine Outhouse - On Gossip Option Selected - Close Gossip');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`IN(14,15) AND `SourceGroup`=9492;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(14, 9492, 12775, 0, 0, 9, 0, 12227, 0, 0, 1, 0, 0, '', 'Show gossip text if doing your duty not taken '), -- Outhouse In Use
(14, 9492, 12779, 0, 0, 9, 0, 12227, 0, 0, 0, 0, 0, '', 'Show gossip text if doing your duty taken '), -- Outhouse avaiable
(15, 9492, 0, 0, 0, 9, 0, 12227, 0, 0, 0, 0, 0, '', 'Show gossip option if doing your duty taken '),
(15, 9492, 0, 0, 0, 2, 0, 37247, 1, 0, 0, 0, 0, '', 'Show gossip option if player has Anderhols Slider Cider '),
(15, 9492, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, '', 'Show gossip option if player is Male'),
(15, 9492, 1, 0, 0, 9, 0, 12227, 0, 0, 0, 0, 0, '', 'Show gossip option if doing your duty taken '),
(15, 9492, 1, 0, 0, 2, 0, 37247, 1, 0, 0, 0, 0, '', 'Show gossip option if player has Anderhols Slider Cider '),
(15, 9492, 1, 0, 0, 20, 0, 1, 0, 0, 0, 0, 0, '', 'Show gossip option if player is female');
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE  `entry`=27326;
DELETE FROM `smart_scripts` WHERE `entryorguid`=27326 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`IN(2732600,2732601) AND `source_type`=9;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(27326, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 80, 2732600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - On Data Set - Run Script'),
(27326, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 2732601, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - On Data Set - Set Phase 2'),
(2732600, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732600, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732600, 9, 2, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732600, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732600, 9, 4, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732600, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732600, 9, 6, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732600, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732600, 9, 8, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732600, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732600, 9, 10, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 47533, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Camera Shake'),
(2732600, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12670, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (Male)'),
(2732601, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732601, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)'),
(2732601, 9, 2, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732601, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)'),
(2732601, 9, 4, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732601, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)'),
(2732601, 9, 6, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732601, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)'),
(2732601, 9, 8, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 48329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Dustfield'),
(2732601, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)'),
(2732601, 9, 10, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 0, 11, 47533, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Cast Camera Shake'),
(2732601, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 4, 12671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Outhouse Bunny - Script - Play Sound (feMale)');
-- Veil Skith Cage
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=22314;
DELETE FROM `smart_scripts` WHERE `entryorguid`=2231400 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`=22314 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(22314, 0, 0, 0, 38, 0, 100, 1, 1, 1, 0, 0, 0, 80, 2231400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Captive Child - On Data Set - Run Script'),
(2231400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Captive Child - Script - Set Active'),
(2231400, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 5, 5, 0, 0, 0, 'Captive Child - Script - Move off set'),
(2231400, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captive Child - Script - Say'),
(2231400, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 33, 22314, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captive Child - Script - Kill credit'),
(2231400, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Captive Child - Script - Despawn');
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry` IN(185202, 185203, 185204, 185205);
DELETE FROM `smart_scripts` WHERE `entryorguid`IN(185202, 185203, 185204, 185205) AND `source_type`=1;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES
(185202, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Store Target'),
(185202, 1, 1, 2, 61, 0, 100, 0, 2, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Send Target'),
(185202, 1, 2, 0, 61, 0, 100, 0, 2, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Set Data'),
(185203, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Store Target'),
(185203, 1, 1, 2, 61, 0, 100, 0, 2, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Send Target'),
(185203, 1, 2, 0, 61, 0, 100, 0, 2, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Set Data'),
(185204, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Store Target'),
(185204, 1, 1, 2, 61, 0, 100, 0, 2, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Send Target'),
(185204, 1, 2, 0, 61, 0, 100, 0, 2, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Set Data'),
(185205, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Store Target'),
(185205, 1, 1, 2, 61, 0, 100, 0, 2, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Send Target'),
(185205, 1, 2, 0, 61, 0, 100, 0, 2, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 22314, 0, 10, 0, 0, 0, 0, 0, 0, 'Veil Skith Cage - On State Changed - Set Data');
@github-actions github-actions bot added Branch-3.3.5a Invalid-IncompleteData/OrNotTrinityCore Reporter deleted parts or all template or he is using a 3rd party unsupported core. labels Apr 30, 2021
@offl offl added Comp-Database Feedback-PatchFix and removed Invalid-IncompleteData/OrNotTrinityCore Reporter deleted parts or all template or he is using a 3rd party unsupported core. labels May 4, 2021
@Krutok
Copy link

Krutok commented Aug 25, 2023

It is a pity that the change has not been accepted until today. See the master branch takes precedence over the old 3.3.5 :( and unfortunately the coe doesn't import anymore today.

@jackpoz
Copy link
Member

jackpoz commented Aug 25, 2023

This change only moves code from C++ to SAI, just a refactor that doesn't really affect users other than possibly breaking working things if none tests what's getting changed

@dr-j dr-j mentioned this issue Sep 6, 2023
Open
@CraftedRO CraftedRO mentioned this issue Feb 24, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Branch-3.3.5a Comp-Database Feedback-PatchFix
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@jackpoz @dr-j @offl @Krutok