Blackrock Depths The Tauren Chieftens

[tails2k]

Description

Go to Grim Guzzler in Blackrock Depths, see the Drums and talk to the right Guy. He Say that the Tauren Chieftens play at 8 PM. Wait for 8 PM... nothing happen...

Expected behaviour

The Taren Chietens must play at 8 PM in Blackrock Depths :)

Steps to reproduce the problem

Go to Blackrock Depths/Grim Guzzler
wait at 8 PM
nothing happen

Branch

3.3.5

TC rev. hash/commit

Last Version: Hope thats right (Dont have access at work now)
commit 9bb97a1

Operating system

Debian 10

Custom changes

no changes

[jackpoz]

wait at 8 PM

client time or server time ?

[dr-j]

Believe this was known when killyana committed sql for this would not work until of issue with updates to game events in already created instances as when you speak to the npc all what it’s meant to do is start a event which despawns a few npcs and spawns the chieftains it does not work if you speak to the npc who has option to request a concert either

[dr-j]

234674f

[jackpoz]

@dr-j sounds like the same issue as Karazhan bell

[tails2k]

wait at 8 PM

client time or server time ?

both, i wait server and client time for it

[acidmanifesto]

234674f

Line 44 shows it expiring/end in 2020. Meaning the event wont run as it is 2021 now. Is that the last current sql for the event?

[Jinnaix]

234674f

Line 44 shows it expiring/end in 2020. Meaning the event wont run as it is 2021 now. Is that the last current sql for the event?

No, current end date is 2030.
Its pretty much what @dr-j and @jackpoz already realized, the eventmgr cant handle linked spawns on instanced maps. Several other mechanics dont cover or dont fully cover instanced maps too (like pools #24437)

[offl]

Duplicate of #26659

[offl]

#18919 (comment) should be reworked to use game event not to spawn them but to make crew spawn them by using On Game Event Started event type in SAI. Same event should be triggered when player clicks on gossip or at 8:00 PM. To not trigger both events, event at 8:00 PM can be triggered only in phase 1. And yeah, that will not work if grid is not loaded.

[dr-j]

I previously writ this to solve this problem think should still work

DELETE FROM `game_event_creature` WHERE  `eventEntry`=81;
DELETE FROM `creature` WHERE `guid` IN (111035, 111037, 111039, 111040, 111074, 111076, 111077, 111078, 111079, 111080, 111081, 111082,111083);

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=23850;

DELETE FROM `smart_scripts` WHERE `entryorguid`=23850 AND `source_type`=0 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 
(23850, 0, 0, 0, 68, 0, 100, 0, 81, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '[DNT] L70ETC Concert Controller - On Event Start - Summon Spawn Group');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=23850 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 23850, 0, 0, 23, 1, 1584, 0, 0, 0, 0, 0, '', '[DNT] L70ETC Concert Controller - Only Run SAI in BRD');

DELETE FROM `creature_summon_groups` WHERE `summonerId`=23850;
INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES 
(23850, 0, 0, 23854, 843.4062, -178.1329, -49.66997, 2.042035, 1, 300000),
(23850, 0, 0, 23852, 842.7178, -181.5613, -49.66998, 1.937315, 1, 300000),
(23850, 0, 0, 23853, 847.6445, -175.8458, -49.67056, 2.076942, 1, 300000),
(23850, 0, 0, 23855, 847.5542, -180.6305, -49.67069, 2.042035, 1, 300000),
(23850, 0, 0, 23830, 846.5654, -178.9536, -49.67049, 2.076942, 1, 300000),
(23850, 0, 0, 23845, 851.3013, -177.1584, -49.67116, 2.146755, 1, 300000),
(23850, 0, 0, 23625, 847.6739, -175.8695, -49.67056, 2.111848, 1, 300000),
(23850, 0, 0, 23624, 842.7151, -181.571, -49.66998, 2.042035, 1, 300000),
(23850, 0, 0, 23626, 843.4564, -178.1454, -49.66998, 2.059489, 1, 300000),
(23850, 0, 0, 23623, 847.8387, -181.1154, -49.67075, 1.867502, 1, 300000),
(23850, 0, 0, 23619, 851.2717, -177.1259, -49.67115, 2.164208, 1, 300000),
(23850, 0, 0, 28210, 847.1571, -187.3589, -49.754269, 2.06561, 1, 300000),
(23850, 0, 0, 28209, 853.8105, -183.515, -49.7542, 2.117463, 1, 300000);

DELETE FROM `game_event_creature` WHERE  `guid`=86803 AND `eventEntry`=-81;

[opiums9]

I previously writ this to solve this problem think should still work

DELETE FROM `game_event_creature` WHERE  `eventEntry`=81;
DELETE FROM `creature` WHERE `guid` IN (111035, 111037, 111039, 111040, 111074, 111076, 111077, 111078, 111079, 111080, 111081, 111082,111083);

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=23850;

DELETE FROM `smart_scripts` WHERE `entryorguid`=23850 AND `source_type`=0 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 
(23850, 0, 0, 0, 68, 0, 100, 0, 81, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '[DNT] L70ETC Concert Controller - On Event Start - Summon Spawn Group');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=23850 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 23850, 0, 0, 23, 1, 1584, 0, 0, 0, 0, 0, '', '[DNT] L70ETC Concert Controller - Only Run SAI in BRD');

DELETE FROM `creature_summon_groups` WHERE `summonerId`=23850;
INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES 
(23850, 0, 0, 23854, 843.4062, -178.1329, -49.66997, 2.042035, 1, 300000),
(23850, 0, 0, 23852, 842.7178, -181.5613, -49.66998, 1.937315, 1, 300000),
(23850, 0, 0, 23853, 847.6445, -175.8458, -49.67056, 2.076942, 1, 300000),
(23850, 0, 0, 23855, 847.5542, -180.6305, -49.67069, 2.042035, 1, 300000),
(23850, 0, 0, 23830, 846.5654, -178.9536, -49.67049, 2.076942, 1, 300000),
(23850, 0, 0, 23845, 851.3013, -177.1584, -49.67116, 2.146755, 1, 300000),
(23850, 0, 0, 23625, 847.6739, -175.8695, -49.67056, 2.111848, 1, 300000),
(23850, 0, 0, 23624, 842.7151, -181.571, -49.66998, 2.042035, 1, 300000),
(23850, 0, 0, 23626, 843.4564, -178.1454, -49.66998, 2.059489, 1, 300000),
(23850, 0, 0, 23623, 847.8387, -181.1154, -49.67075, 1.867502, 1, 300000),
(23850, 0, 0, 23619, 851.2717, -177.1259, -49.67115, 2.164208, 1, 300000),
(23850, 0, 0, 28210, 847.1571, -187.3589, -49.754269, 2.06561, 1, 300000),
(23850, 0, 0, 28209, 853.8105, -183.515, -49.7542, 2.117463, 1, 300000);

DELETE FROM `game_event_creature` WHERE  `guid`=86803 AND `eventEntry`=-81;

big thanks!