search

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 99 forks source link

[Q4512,4513] A Little Slime Goes a Long Way #273

Closed NeatElves closed 6 years ago

NeatElves commented 6 years ago

https://www.wowhead.com/quest=4512 https://www.wowhead.com/quest=4513

  1. Quest item's is used at all, fix: 
    DELETE FROM  `item_required_target` WHERE  `entry` IN (11953, 11914, 11948);
INSERT INTO `item_required_target` (`entry`, `type`, `targetEntry`) VALUES
(11914, 1, 7086),
(11948, 1, 7092),
(11953, 1, 2655),
(11953, 1, 2656),
(11953, 1, 6556),
(11953, 1, 6557),
(11953, 1, 6559);
  2. When using an item, the monster dies, see spell description:

    WARNING! Will likely destroy the creature's body.

INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param6`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
(708601, 7086, 8, 0, 100, 1, 15698, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cursed Ooze - cast Filling Empty Jar(Q 4512) - die Cursed Ooze'),
(709202, 7092, 8, 0, 100, 1, 15699, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tainted Ooze - cast Filling Empty Jar(Q 4512) - die Tainted Ooze'),
(265502, 2655, 8, 0, 100, 1, 15702, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Green Sludge - cast Filling Empty Jar(Q 4513) - die Green Sludge'),
(265602, 2656, 8, 0, 100, 1, 15702, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jade Ooze - cast Filling Empty Jar(Q 4513) - die Jade Ooze'),
(655601, 6556, 8, 0, 100, 1, 15702, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muculent Ooze - cast Filling Empty Jar(Q 4513) - die Muculent Ooze'),
(655703, 6557, 8, 0, 100, 1, 15702, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Primal Ooze - cast Filling Empty Jar(Q 4513) - die Primal Ooze'),
(655902, 6559, 8, 0, 100, 1, 15702, -1, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Glutinous Ooze - cast Filling Empty Jar(Q 4513) - die Glutinous Ooze');

p.s. mob numbers are taken from comments))

AnonXS commented 6 years ago

Except thats not how it works... they dont die on spellhit that Warning is for Looting because their corpse will Delayed Despawn on Spellhit. 3 Seconds.

https://www.wowhead.com/quest=4512/a-little-slime-goes-a-long-way#comments:id=2355

https://www.wowhead.com/quest=4512/a-little-slime-goes-a-long-way#videos:id=126794 - only on corpse

ServerToClient: SMSG_SPELL_GO (0x0132) Length: 55 ConnectionIndex: 0 Time: 03/26/2009 14:55:49.000 Number: 1228030
Caster  Unit/Player/Item  GUID: Full: 0x4000000117CE6D61 TypeMask: Object, Item UInt64: 4611686023121759585
Caster Unit/Player GUID: Full: 0x01EB7A21 UInt64: 32209441 Guid: Holybob
Cast Count: 134
Spell ID: 15702
Cast Flags: Unknown4, Unknown7 (272)
Time: 1125166347
Hit Count: 2
[0] Hit GUID: Full: 0xF13000199D044CB1 TypeMask: Object, Unit Entry: 6557 UInt64: 17379391072031231153
[1] Hit GUID: Full: 0x01EB7A21 UInt64: 32209441 Guid: Holybob
Miss Count: 0
Target Flags: Unit (2)
Target Guid: Full: 0xF13000199D044CB1 TypeMask: Object, Unit Entry: 6557 UInt64: 17379391072031231153
ServerToClient: SMSG_DESTROY_OBJECT (0x00AA) Length: 9 ConnectionIndex: 0 Time: 03/26/2009 14:55:52.000 Number: 1228061
GUID: Full: 0xF13000199D044CB1 TypeMask: Object, Unit Entry: 6557 UInt64: 17379391072031231153
Despawn Animation: True

some npcs might be a wrong pick for being able to complete the quest as wotlk client quest zones show, but as comments suggest we should not stick to that:

1

0


@@ -6858,6 +6858,7 @@ INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_invers
 ('265501','2655','11','0','100','0','0','0','0','0','0','0','11','9460','0','34','0','0','0','0','0','0','0','0','Green Sludge - Cast Corrosive Ooze on Spawn'),
 -- Jade Ooze 2656
 ('265601','2656','0','0','100','1','6800','8300','37900','46300','0','0','11','6907','1','32','0','0','0','0','0','0','0','0','Jade Ooze - Cast Diseased Slime'),
+('265602','2656','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Jade Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
 -- Trained Razorbeak
 ('265701','2657','9','0','100','1','0','5','15000','19000','0','0','11','3147','1','0','0','0','0','0','0','0','0','0','Trained Razorbeak - Cast Rend Flesh'),
 -- Razorbeak Gryphon (2658) - NSR
@@ -10165,8 +10166,9 @@ INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_invers
 ('876302','8763','9','0','100','1025','0','40','3400','4800','0','0','11','9532','1','256','0','0','0','0','0','0','0','0','Mistwing Rogue - Cast Lightning Bolt'),
 -- Mistwing Ravager
 ('876401','8764','9','0','100','1','0','30','14000','19000','0','0','11','8806','4','0','0','0','0','0','0','0','0','0','Mistwing Ravager - Cast Poisoned Shot'),
--- Forest Ooze
+-- Forest Ooze 8766
 ('876601','8766','9','0','100','1','0','5','12000','16000','0','0','11','6907','4','32','0','0','0','0','0','0','0','0','Forest Ooze - Cast Diseased Slime'),
+('876602','8766','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Forest Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
 -- Gruul Darkblade (10361) - NSR
 -- Azshara Sentinel (11276) - NSR
 -- Loh'atu (11548) - NSR
@@ -12720,13 +12722,16 @@ INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_invers
 -- Kaerbrus
 ('550101','5501','2','0','100','0','15','0','0','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Kaerbrus - Flee at 15% HP'),
 -- Spirit Healer (6491) - NSR
--- Cursed Ooze (7086) - NSR
--- Tainted Ooze
+-- Cursed Ooze 7086
+('708601','7086','8','0','100','1','15698','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Cursed Ooze - Delayed Despawn on Filling Empty Jar (q.4512) Spellhit'),
+-- Tainted Ooze 7092
 ('709201','7092','9','0','100','1','0','5','180000','180000','0','0','11','3335','1','0','0','0','0','0','0','0','0','0','Tainted Ooze - Cast Dark Sludge'),
+('709202','7092','8','0','100','1','15699','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Tainted Ooze - Delayed Despawn on Filling Empty Jar (q.4512) Spellhit'),
 -- Vile Ooze 7093
 ('709301','7093','4','0','100','0','0','0','0','0','0','0','57','2','25','0','0','0','0','0','0','0','0','0','Vile Ooze - Enable Caster Mode on Aggro'),
 ('709302','7093','9','0','100','1025','0','5','11000','14000','0','0','11','22595','1','0','0','0','0','0','0','0','0','0','Vile Ooze - Cast Poison Shock'),
 ('709303','7093','9','0','100','1025','5','30','3800','5200','0','0','11','21067','1','256','0','0','0','0','0','0','0','0','Vile Ooze - Cast Poison Bolt'),
+('709304','7093','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Vile Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
 -- Ironbeak Owl
 ('709701','7097','9','0','100','1','0','5','8000','11000','0','0','11','5708','1','0','0','0','0','0','0','0','0','0','Ironbeak Owl - Cast Swoop'),
 -- Ironbeak Screecher
@@ -16451,11 +16456,15 @@ INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_invers
 ('655503','6555','24','5','100','1','14120','5','5000','5000','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Gorishi Tunneler - Set Phase 2 on Target Max Tunneler Acid Aura Stack (Phase 1)'),
 ('655504','6555','28','3','100','1','14120','1','5000','5000','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Gorishi Tunneler - Set Phase 1 on Target Missing Tunneler Acid Aura Stack (Phase 2)'),
 ('655505','6555','0','0','100','1','10000','25000','12700','24800','0','0','11','8137','1','32','0','0','0','0','0','0','0','0','Gorishi Tunneler - Cast Silithid Pox'),
--- Primal Ooze
+-- Muculent Ooze 6556
+('655601','6556','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Muculent Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
+-- Primal Ooze 6557
 ('655701','6557','2','0','100','0','10','0','0','0','0','0','11','14146','0','0','0','0','0','0','0','0','0','0','Primal Ooze - Cast Clone at 10% HP'),
 ('655702','6557','30','0','100','1','5','10290','0','0','0','0','11','16032','0','16','36','9621','0','0','0','0','0','0','Primal Ooze - Cast Merging Oozes AND Transform into Gargantuan Ooze on Receive AI Event A'),
--- Glutinous Ooze
+('655703','6557','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Primal Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
+-- Glutinous Ooze 6559
 ('655901','6559','6','0','100','0','0','0','0','0','0','0','11','14147','0','7','0','0','0','0','0','0','0','0','Glutinous Ooze - Cast Acid Slime'),
+('655902','6559','8','0','100','1','15702','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Glutinous Ooze - Delayed Despawn on Filling Empty Jar (q.4513) Spellhit'),
 -- Ravasaur Matriarch
 ('658101','6581','0','0','100','1','8000','8000','20000','20000','0','0','11','13445','1','0','0','0','0','0','0','0','0','0','Ravasaur Matriarch - Cast Rend'),
 -- Clutchmother Zavas


DELETE FROM  `item_required_target` WHERE  `entry` IN (11953, 11914, 11948);
INSERT INTO `item_required_target` (`entry`, `type`, `targetEntry`) VALUES
(11914, 2, 7086), -- https://www.wowhead.com/quest=4512/a-little-slime-goes-a-long-way#comments:id=42411:reply=56995
(11948, 2, 7092), -- https://www.wowhead.com/quest=4512/a-little-slime-goes-a-long-way#comments:id=42411:reply=56995
-- 2655 https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=936798
(11953, 2, 2656), -- https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=936798
(11953, 2, 8766), -- https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=998607
(11953, 2, 7093), https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=1064287
(11953, 2, 6556), -- https://www.wowhead.com/quest=4512/a-little-slime-goes-a-long-way#comments:id=936518
(11953, 2, 6557), -- https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=1683069
(11953, 2, 6559); -- https://www.wowhead.com/quest=4513/a-little-slime-goes-a-long-way#comments:id=390641
NeatElves commented 6 years ago

typo) ('709202','7092','8','0','100','1','15699','-1','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','Tainted Ooze - Delayed Despawn on Filling Empty Jar (q.4512) Spellhit'),

Grz3s commented 6 years ago

are you guys planning to add this? or you want me to do it?

AnonXS commented 6 years ago

No plan, i just investigated real quick as i thought something was wrong about the way this intended to add it. Just go ahead, else i‘ll soonish

Grz3s commented 6 years ago

hmm ... issue was added in wotlk issue section... fix wasnt added in wotlk yet ..so why did you close it?