Trinitycore: DB/Creature: Gravis Slipknot

[LEO33SoFo]

Description:

This mob's body does not appear. Only a sword is visible. (even that sword is not correct, is from Cataclysm, according to Wowpedia).

Expected behaviour:

Visible body I guess? :laughing:

Steps to reproduce the problem:

1. .npc add temp 14221
2. Check his appearance.

Branch(es):

3.3.5

TC rev. hash/commit:

43986954fddc05e0fe1f225b0cf38a7b01f775bb

Operating system: Windows 7 Enterprise 64bit

[illfated]

I suspect that the issue is similar, if not identical, to #22293 DB/Creature: George Candarte (2698) is invisible :

SELECT * FROM `creature_template` WHERE `entry`= 14221;

entry  difficulty_entry_1  difficulty_entry_2  difficulty_entry_3  KillCredit1  KillCredit2  modelid1  modelid2  modelid3  modelid4  name             subname  IconName  gossip_menu_id  minlevel  maxlevel     exp  faction  npcflag  speed_walk  speed_run   scale    rank  dmgschool  BaseAttackTime  RangeAttackTime  BaseVariance  RangeVariance  unit_class  unit_flags  unit_flags2  dynamicflags  family    type  type_flags  lootid  pickpocketloot  skinloot  PetSpellDataId  VehicleId  mingold  maxgold  AIName   MovementType  HoverHeight  HealthModifier  ManaModifier  ArmorModifier  DamageModifier  ExperienceModifier  RacialLeader  movementId  RegenHealth  mechanic_immune_mask  spell_school_immune_mask  flags_extra  ScriptName  VerifiedBuild
-----  ------------------  ------------------  ------------------  -----------  -----------  --------  --------  --------  --------  ---------------  -------  --------  --------------  --------  --------  ------  -------  -------  ----------  ---------  ------  ------  ---------  --------------  ---------------  ------------  -------------  ----------  ----------  -----------  ------------  ------  ------  ----------  ------  --------------  --------  --------------  ---------  -------  -------  -------  ------------  -----------  --------------  ------------  -------------  --------------  ------------------  ------------  ----------  -----------  --------------------  ------------------------  -----------  ----------  -------------
14221                   0                   0                   0            0            0      2582         0         0         0  Gravis Slipknot  (NULL)   (NULL)                 0        36        36       0       87        0        1.59    1.14286       1       4          0            1350             1485             1              1           1           0         2048             0       0       7           0   14221           14221         0               0          0       59       83  SmartAI             0            1            1.15             1              1               1                   1             0           0            1                     0                         0            0                      12340



md5-a1ee5071cd1178fb5875d01325d42849

DisplayID BoundingRadius CombatReach Gender DisplayID_Other_Gender

---

 2582          0.3825        1.875       2                   15880

**So far, it looks like we only need to do the following:**

```sql
-- Gravis Slipknot (entry 14221, DisplayID 2582)
UPDATE `creature_model_info` SET `DisplayID_Other_Gender`= 0 WHERE `DisplayID`= 2582;

Test this query, see if the weapon becomes correct at the same time as he reappears.

[Rushor]

-- Gravis Slipknot SAI
SET @ENTRY := 14221;
UPDATE `creature_template` SET `AIName`="SmartAI" , `scriptname` ="" WHERE `entry`= @ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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`,`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,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gravis Slipknot - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gravis Slipknot - On Aggro - Say Line 0 for duration 0 not using Talktarget"),
(@ENTRY,0,2,0,0,0,100,0,3000,5000,7000,9000,11,18501,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gravis Slipknot - In Combat - Cast 'Enrage' with CastFlag: 0 and TriggerFlag: 0 (TargetLimit: 0)");

DELETE FROM `creature_text` WHERE `creatureid`=14221;
INSERT INTO `creature_text` (`creatureid`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(14221, 0, 0, 'Greetings, hapless adventurer.  I ask only that you wait a moment...and BLEED!', 12, 0, 100, 0, 0, 0, 50896, 'Gravis Slipknot');

SET @NPC := 86756;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `wander_distance`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, 710.176, -847.23, 158.978), 
(@PATH, 2, 700.134, -853.063, 158.516),
(@PATH, 3, 684.42, -847.68, 158.498),
(@PATH, 4, 666.937, -858.739, 158.498),
(@PATH, 5, 663.885, -866.644, 158.499),
(@PATH, 6, 662.637, -879.389, 158.291), 
(@PATH, 7, 659.842, -884.845, 158.61),
(@PATH, 8, 666.729, -899.79, 164.624),
(@PATH, 9, 669.022, -904.201, 164.414), 
(@PATH, 10, 667.229, -921.961, 164.414),
(@PATH, 11, 666.778, -939.546, 164.85), 
(@PATH, 12, 673.587, -950.274, 164.35),
(@PATH, 13, 684.347, -959.261, 164.35), 
(@PATH, 14, 698.708, -966.321, 164.653),
(@PATH, 15, 708.321, -976.576, 165.562),
(@PATH, 16, 700.121, -957.096, 164.68), 
(@PATH, 17, 715.224, -933.369, 164.344),
(@PATH, 18, 716.543, -899.917, 166.366),
(@PATH, 19, 715.204, -866.595, 161.66), 
(@PATH, 20, 717.657, -846.403, 160.754),
(@PATH, 21, 717.657, -846.403, 160.754);

[offl]

DELETE FROM `creature_text` WHERE `creatureid`=14221;
INSERT INTO `creature_text` (`creatureid`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(14221, 0, 0, 'Greetings, hapless adventurer.  I ask only that you wait a moment...and BLEED!', 12, 0, 100, 0, 0, 0, 50896, 'Gravis Slipknot');

Eww, Cataclysm texts

[illfated]

SELECT * FROM `smart_scripts` WHERE `entryorguid` LIKE "14221%";

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                                                 
-----------  -----------  ------  ------  ----------  ----------------  ------------  -----------  ------------  ------------  ------------  ------------  ------------  -----------  -------------  -------------  -------------  -------------  -------------  -------------  -----------  -------------  -------------  -------------  -------------  --------  --------  --------  --------  --------------------------------------------------------
      14221            0       0       0           2                 0           100            1             0            15             0             0             0           25              1              0              0              0              0              0            0              0              0              0              0         0         0         0         0  Gravis Slipknot - Between 0-15% Health - Flee For Assist

---

edit: creature_template.entry 14221 is already defined as a SmartAI creature.

[illfated]

[22:44:32] Welcome to a Trinity Core server.
[22:44:32] TrinityCore rev. ef564c0c5cea 2020-08-21 20:58:37 +0300 (3.3.5 branch) (Win64, Release, Static)

Nope, he is still carrying the Cataclysm fire blade, not the Classic Cutlass (someone on wowhead.com suggested that he looted Cruel Barb from Edwin VanCleef, but it is more likely just a standard Cutlass model blade, like in the image) -- maybe https://classic.wowhead.com/item=4560/fine-scimitar

[github-actions[bot]]

ce2c250d3afa4d817708ca8ade8d9293bbf891d6

[offl]

This one is too for Cata

(@ENTRY,0,2,0,0,0,100,0,3000,5000,7000,9000,11,18501,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gravis Slipknot - In Combat - Cast 'Enrage' with CastFlag: 0 and TriggerFlag: 0 (TargetLimit: 0)");