Trinitycore: [3.3.5] DB/Gameobject: add SAI for Shaffar's Stasis Chamber

[Nefertumm]

Description: Yor couldn't be spawned when you used the key. With this fix, he will spawn.

Branch(es): 3.3.5

TC hash/commit: 2db9269

TDB version: 335.61

Tried on my local, works well :)

SQL Fix:

UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE entry = 185522;
DELETE FROM `smart_scripts` WHERE entryorguid IN (185522,18552200);
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(185522,1,0,0,70,0,100,0,2,0,0,0,80,18552200,0,0,0,0,0,1,0,0,0,0,0,0,0,'Shaffar''s Stasis Chamber - On Gameobject State Changed - Run Script'),
(18552200,9,0,0,0,0,100,0,1000,1000,0,0,12,22930,6,180000,0,0,0,1,0,0,0,0,0,0,0,'Shaffar''s Stasis Chamber - On Script - Summon Creature Yor');

[ghost]

Pro tip: add ```sql on top of the code block to show the SQL syntax and not wrap the text. :-)

---

edit: and please remove the apostrophes around numbers, TC SQL does not use ' ' around numbers.

[Killyana]

The Sai is wrong also the gob spawn is missing.

[Elarose]

Missing two stasis chambers here.
Object: http://mop-shoot.tauri.hu/?object=185519
Quest involved.
http://www.wowhead.com/quest=10977/stasis-chambers-of-the-mana-tombs
What it should do: https://youtu.be/aofPbby4ca0?t=144

Object: http://mop-shoot.tauri.hu/?object=185522
Yors chamber. https://youtu.be/aofPbby4ca0

[TerrorBringer]

Still missing in https://github.com/TrinityCore/TrinityCore/commit/ca8953a0ec8356345147b2bbc7bbdf0fa97cd625.

[offl]

Switch dungeon mode to heroic
.additem 32079 10
.go game 9502
Use the object

--
DELETE FROM `gameobject` WHERE `guid` IN (9502,9503);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`,`animprogress`, `state`) VALUES
(9502,185460,557,2,-235.8613,-12.97968,17.05966,1.553341,0,0,0.7009087,0.7132511,600000,255,1),
(9503,185522,557,2,-235.7991,-13.00704,17.05684,1.361356,0,0,0.6293201,0.7771462,600000,100,1);

UPDATE `gameobject_template` SET `AIName` = "SmartGameObjectAI" WHERE `entry` = 185522;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 185522 AND `source_type` = 1;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 18552200 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`,`comment`) VALUES
(185522,1,0,0,70,0,100,0,2,0,0,0,0,80,18552200,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shaffar's Stasis Chamber - On Gameobject State Changed - Run Script"),
(18552200,9,0,0,0,0,100,0,0,0,0,0,0,12,22930,8,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shaffar's Stasis Chamber - On Script - Summon Creature 'Yor'"),
(18552200,9,1,0,0,0,100,0,1500,1500,0,0,0,2,16,0,0,0,0,0,19,22930,0,0,0,0,0,0,0,"Shaffar's Stasis Chamber - On Script - Set Faction 'Yor'");

1. The spawns are from CMaNGOS, they look correct but may be not from sniffs
2. Yor's orientation is incorrect comparing to https://youtu.be/sYvyFqk31Ok?t=37
   Maybe due to 1.
3. Yor's faction is 35 in the DB, it was ported from 4.xx fix and may be correct since if I'm not mistaken all creatures summoned from such Outland objects have faction 35 and pre-attack event(creature becomes attackable after 1500ms after spawn)

[dr-j]

Data for this also originated from cmangos but may as well kill two birds with one stone as literally identical except no combat

https://www.wowhead.com/quest=10977/stasis-chambers-of-the-mana-tombs
~~~sql
DELETE FROM gameobject WHERE guid IN (4000706,4000707);
INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
-- Ethereum Prison Base Group (Global)
(4000706,185460,557,2,1,8.73419, -223.864, -0.954936, 0.284522, 0, 0, 0.141782, 0.989898, 14440, 255, 1),
-- Mana-Tombs Stasis Chamber
(4000707,185519,557,2,1,8.73419, -223.864, -0.954936, 0.284522, 0, 0, 0.141782, 0.989898, 14440, 255, 1);

UPDATE gameobject_template SET AIName='SmartGameObjectAI' WHERE entry=185519;
DELETE FROM smart_scripts WHERE entryorguid=185519 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, 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
(185519, 1, 0, 0, 64, 0, 100, 0, 2, 0, 0, 0, 15, 10977, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mana Tombs Stasis Chamber - On Gameobject State Changed - Complete quest'),
(185519, 1, 1, 0, 64, 0, 100, 0, 2, 0, 0, 0, 12, 22928, 8, 0, 0, 0, 0, 8, 0, 0, 0, 0, 8.73419,-223.864,-0.427713,2.64365, 0, 'Mana Tombs Stasis Chamber - On Gameobject State Changed - summon Ambassador Pax ivi');

DELETE FROM creature_text WHERE CreatureID=22928;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22928, 0, 0, "I... I am free! The Ethereum were planning on torturing me until I gave in to their requests. I fear that, had you not come along, I would have surely given in to their torment.", 12, 0, 100, 0, 0, 0, 20633, 0, 'Pax ivi');

UPDATE creature_template SET AIName='SmartAI' WHERE entry =22928;
DELETE FROM smart_scripts WHERE entryorguid=22928 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=2292800 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, 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
(22928, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 80, 2292800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Pax ivi - On Just Summoned - Run Script'),
(2292800, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Pax ivi - Script - Say Line 0'),
(2292800, 9, 1, 0, 0, 0, 100, 0, 14000, 14000, 0, 0, 11, 34427, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Pax ivi - Script - Cast Teleport'),
(2292800, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Pax ivi - Script - Despawn');