cmangos / wotlk-db

A content database for mangos-wotlk, and World of Warcraft Client Patch 3.3.5
GNU General Public License v3.0
112 stars 97 forks source link

Captain Kromcrush - Extra ability and missing 2 combat spawns #1128

Open al3xc1985 opened 11 months ago

al3xc1985 commented 11 months ago

I see that he has an other Frightening Shout with a different Id ,should he use that 2? https://www.wowhead.com/wotlk/spell=29544/frightening-shout I mean it's a 6 sec fear. The one we got him scrioted with has 8 sec fear.

Should he use this one 2?

al3xc1985 commented 11 months ago

Also a question image

Do we have this texts implemented? I guess is an event

al3xc1985 commented 11 months ago

He does not spawn 2 guards at 50%

image

Also

image

insunaa commented 11 months ago

For what do we have a DB if you don't look at it?

                      id = 1432501
             creature_id = 14325
              event_type = 4
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 0
            event_param1 = 0
            event_param2 = 0
            event_param3 = 0
            event_param4 = 0
            event_param5 = 0
            event_param6 = 0
            action1_type = 1
          action1_param1 = 9418
          action1_param2 = 0
          action1_param3 = 0
            action2_type = 0
          action2_param1 = 0
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Yell on Aggro

                      id = 1432502
             creature_id = 14325
              event_type = 9
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 1025
            event_param1 = 0
            event_param2 = 5
            event_param3 = 9800
            event_param4 = 9800
            event_param5 = 0
            event_param6 = 0
            action1_type = 11
          action1_param1 = 22859
          action1_param2 = 4
          action1_param3 = 0
            action2_type = 0
          action2_param1 = 0
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Cast Mortal Cleave

                      id = 1432503
             creature_id = 14325
              event_type = 0
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 1025
            event_param1 = 19100
            event_param2 = 19100
            event_param3 = 25000
            event_param4 = 35000
            event_param5 = 0
            event_param6 = 0
            action1_type = 11
          action1_param1 = 22857
          action1_param2 = 0
          action1_param3 = 0
            action2_type = 0
          action2_param1 = 0
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Cast Retaliation

                      id = 1432504
             creature_id = 14325
              event_type = 0
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 1025
            event_param1 = 9000
            event_param2 = 18000
            event_param3 = 15000
            event_param4 = 19000
            event_param5 = 0
            event_param6 = 0
            action1_type = 11
          action1_param1 = 19134
          action1_param2 = 5
          action1_param3 = 0
            action2_type = 0
          action2_param1 = 0
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Cast Frightening Shout

                      id = 1432505
             creature_id = 14325
              event_type = 2
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 1024
            event_param1 = 50
            event_param2 = 0
            event_param3 = 0
            event_param4 = 0
            event_param5 = 0
            event_param6 = 0
            action1_type = 11
          action1_param1 = 22860
          action1_param2 = 0
          action1_param3 = 0
            action2_type = 1
          action2_param1 = 9478
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Cast Call Reavers and Yell at 50% HP

                      id = 1432506
             creature_id = 14325
              event_type = 2
event_inverse_phase_mask = 0
            event_chance = 100
             event_flags = 1024
            event_param1 = 30
            event_param2 = 0
            event_param3 = 0
            event_param4 = 0
            event_param5 = 0
            event_param6 = 0
            action1_type = 11
          action1_param1 = 8599
          action1_param2 = 0
          action1_param3 = 0
            action2_type = 1
          action2_param1 = 9477
          action2_param2 = 0
          action2_param3 = 0
            action3_type = 0
          action3_param1 = 0
          action3_param2 = 0
          action3_param3 = 0
                 comment = Captain Kromcrush - Cast Enrage and Text Emote at 30% HP
al3xc1985 commented 11 months ago

I guess u missunderstood my point, I am sorry If I didn't made myself clear in my statements

I am looking at it, I found the rest of the spells and yells, but my concern was about that specific spell id that wowhead is givving me,

Also I wanted to ask about the event with him, cause he has 2 yells involved in a specific event, I think the one with costume suit one.

And wanted to give a more specific aproach where he misses his 2 adds spawned at 50% where he does have that yell, but summones are missing

insunaa commented 11 months ago

The 2 missing adds is a database+core issue (database because it's missing the script target

INSERT INTO `spell_script_target` VALUES (22860,1,14325,0);

and core because like this both summons are spawned at the exact same coordinates facing the wrong direction) And the yells are for the event yes, those should be handled in dbscripts_on_gossip

image image

Edit: I dunno... If I set EffectRadiusIndex1 to 10 and EffectImplicitTargetA1 to 73 it works fine in WotLK but 73 doesn't work in Vanilla

al3xc1985 commented 11 months ago

I tested the fight and yes it's an issue cause they do not spawn