Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Quest] The Smallest Creatures (Id 10720) (Horde) (335a) #11332

Open
Raszagal opened this issue Dec 18, 2013 · 18 comments · May be fixed by #28905
Open

[Quest] The Smallest Creatures (Id 10720) (Horde) (335a) #11332

Raszagal opened this issue Dec 18, 2013 · 18 comments · May be fixed by #28905

Comments

@Raszagal
Copy link

TrinityCore rev. b76d141

Apparently you are supposed to be turned into a Marmot (creature_template 22189 I THINK) and get an action bar with "Poison Keg" as an option to use...

http://www.wowhead.com/quest=10720

This doesn't happen.

You can use the "Kodohide Drum" (31141) at the Marmot Den (300117). BUT, you go into what appears to be some sort of "Shadow Realm" phase like in the DK area.

Did .lo sp poison keg and it returned:
38629 [Poison Keg, rank 1 enUS]
So the spell is in there...

Tested giving myself the spell and going to the Ripe Moonshine Keg (185213), Green Spot Grog Keg (185206), & Fermented Seed Beer Keg (185214) and tried to use the spell (38629) but it didn't work that way either.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@killradio
Copy link

It seems like marmot should be some kind of temporary pet? Here description and details: http://www.wowwiki.com/Quest:The_Smallest_Creatures

EDIT: http://www.youtube.com/watch?v=2BpXaKDOxEE

P.S. @Raszagal u post link to wrong quest ;p

@dr-j
Copy link
Contributor

dr-j commented Sep 8, 2014

Well some progress on this

UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` =22189;
DELETE FROM `smart_scripts` WHERE `entryorguid` =22189 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 
(22189, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 86, 38586, 2, 7, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Marmot - On Just Summoned - Invoker Cast [DND]Charm Rexxars Rodent');

The player now actually posseses a marmot, spells still dont work, problem is the invisibility aura from when player uses http://www.wowhead.com/spell=38544 remains on pocessed creature this aura should only be on player when marmot is possesed camera changes to be from perspective of marmot but retains the invisibility aura, this should only be on player while they are controlling marmot, also dont think sai is best way for this to be scripted either as entering into combat causes despawn when should not happen

ServerToClient: SMSG_SPELL_START (0x107A) Length: 48 ConnectionIndex: 2 Time: 09/03/2014 01:32:32.844 Number: 60293
bits44: 0
hasSplineElevation: 1
hasSourceLocation: 0
hasElevation: 1
hasTargetString: 1
hasAmmoInventoryType: 1
hasDestLocation: 0
hasDelayTime: 1
hasAmmoDisplayId: 1
hasTargetFlags: 1
hasPredictedHeal: 1
hasRunesStateBefore: 1
hasCastSchoolImmunities: 1
extraTargetCount: 0
hasRunesStateAfter: 1
hasUnkMovementField: 1
hasVisualChain: 0
hasPredictedType: 1
Guid3: 0x0
Guid7: 0x0
CastTime: 2639
Guid6: 0x0
Cast Flags: HasTrajectory, Unknown4, Unknown16 (262162)
CastCount: 216
Spell ID: 38544
Text: 

ServerToClient: SMSG_AURA_UPDATE (0x0072) Length: 37 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.485 Number: 60305
[0] Flags: NoCaster, Positive, Duration (7)
[0] Caster Level: 85
[0] Spell ID: 38544
[0] Max Duration: 300000
[0] Duration: 300000
[0] Charges: 1
[0] Effect Mask: 2
[0] Slot: 14
Guid: Full: 0x000000000000000 Type: Player Low: 000000000

ServerToClient: SMSG_SPELL_GO (0x09D8) Length: 71 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.485 Number: 60306
Target Flags: Unit, DestinationLocation (66)
[0] Guid8: Full: 0x000000000000000 Type: Player Low: 000000000
Int50: 958671861
Position: X: 3345.532 Y: 5789.803 Z: -5.197255
DestLocationTargetGUID: 0x0
Cast Flags: Unknown4, Unknown7, Unknown8, Unknown16 (262928)
Byte1A0: 5
CastCount: 216
Spell ID: 38544
casterUnitGUID: Full: 0x450000044B81AA5D Type: Item Low: 18446658141
CasterGUID: Full: 0x000000000000000 Type: Player Low: 000000000
targetGUID: 0x0
ItemTargetGUID: 0x0
UnkGUID: 0x0

ServerToClient: SMSG_SPELLLOGEXECUTE (0x00D8) Length: 41 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.485 Number: 60307
[0] [0] Summoned GUID: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
[0] Spell Effect: Summon (28)
Spell ID: 38544
Guid: Full: 0x000000000000000 Type: Player Low: 000000000

ClientToServer: CMSG_CREATURE_QUERY (0x0842) Length: 4 ConnectionIndex: 1 Time: 09/03/2014 01:32:35.500 Number: 60308
Entry: 22189

ServerToClient: SMSG_CREATURE_QUERY_RESPONSE (0x048B) Length: 89 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.625 Number: 60310
Entry: 22189
Racial Leader: 0
Expansion: WorldOfWarcraft (0)
Type: Critter (8)
Modifier 1: 0.5
Type Flags: None (0)
Creature Type Flags 2: 0
Rank: Normal (0)
Movement ID: 0
[0] Name: Marmot
Modifier 2: 1
Family: None (0)
[0] Display ID: 2838
[1] Display ID: 0
[2] Display ID: 0
[3] Display ID: 0
[0] Kill Credit: 0
[1] Kill Credit: 0

ServerToClient: SMSG_UPDATE_OBJECT (0x1792) Length: 745 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.750 Number: 60311
Map: 530
Count: 2
[0] UpdateType: Values
[0] GUID: Full: 0x000000000000000 Type: Player Low: 000000000
[0] UNIT_FIELD_BYTES_2: 1/1.401298E-45
[1] UpdateType: CreateObject2
[1] GUID: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
[1] Object Type: Unit (3)
[1] bit676: 0
[1] Has Anim Kits: 0
[1] Is Living: 1
[1] bit810: 0
[1] Transport Frames Count: 0
[1] Has Vehicle Data: 0
[1] bit1044: 0
[1] bit476: 0
[1] Has GameObject Rotation: 0
[1] bit680: 0
[1] Has Attacking Target: 0
[1] Has Scene Object Data: 0
[1] bit1064: 0
[1] bit668: 0
[1] Has Transport Position: 0
[1] bit681: 0
[1] Has Stationary Position: 0
[1] Has Pitch: 1
[1] Has Transport Data: 0
[1] bits98: 0
[1] Has SplineElevation: 1
[1] Has SplineData: 0
[1] Fly Speed: 7
[1] Turn Speed: 3.141593
[1] Time?: 958674759
[1] Swim Speed: 4.5
[1] Pitch Speed: 3.141593
[1] Orientation: 0.9590946
[1] Walk Speed: 2.5
[1] Fly Back Speed: 4.5
[1] Run Back Speed: 2.5
[1] Run Speed: 8
[1] Swim Back Speed: 4.72222
[1] Position: X: 3345.532 Y: 5789.803 Z: -5.113922
[1] OBJECT_FIELD_GUID: 8357578/1.171146E-38
[1] 1: 4046476973/-8.731863E+29
[1] OBJECT_FIELD_TYPE: 9/1.261169E-44
[1] OBJECT_FIELD_ENTRY: 22189/3.109341E-41
[1] OBJECT_FIELD_SCALE_X: 1065353216/1
[1] UNIT_FIELD_DEMON_CREATOR: 000000000/6.306248E-35
[1] 21: 83886080/6.018531E-36
[1] UNIT_FIELD_BYTES_0: 33556480/9.406251E-38
[1] UNIT_FIELD_HEALTH: 2688/3.76669E-42
[1] UNIT_FIELD_POWER: 6749/9.457363E-42
[1] UNIT_FIELD_MAXHEALTH: 2688/3.76669E-42
[1] UNIT_FIELD_MAXPOWER: 6749/9.457363E-42
[1] UNIT_FIELD_POWER_REGEN_FLAT_MODIFIER: 1096688703/13.88385
[1] UNIT_FIELD_LEVEL: 67/9.3887E-44
[1] UNIT_FIELD_FACTIONTEMPLATE: 2/2.802597E-45
[1] UNIT_FIELD_FLAGS_2: 2048/2.869859E-42
[1] UNIT_FIELD_BASEATTACKTIME: 2000/2.802597E-42
[1] 65: 2000/2.802597E-42
[1] UNIT_FIELD_BOUNDINGRADIUS: 1048173347/0.244
[1] UNIT_FIELD_COMBATREACH: 1073741824/2
[1] UNIT_FIELD_DISPLAYID: 2838/3.976885E-42
[1] UNIT_FIELD_NATIVEDISPLAYID: 2838/3.976885E-42
[1] UNIT_MOD_CAST_SPEED: 1065353216/1
[1] UNIT_MOD_CAST_HASTE: 1065353216/1
[1] UNIT_FIELD_MOD_HASTE: 1065353216/1
[1] UNIT_FIELD_MOD_RANGED_HASTE: 1065353216/1
[1] UNIT_FIELD_MOD_HASTE_REGEN: 1065353216/1
[1] UNIT_CREATED_BY_SPELL: 38544/5.401165E-41
[1] UNIT_FIELD_BASE_MANA: 7000/9.809089E-42
[1] UNIT_FIELD_BYTES_2: 1/1.401298E-45
[1] UNIT_FIELD_HOVERHEIGHT: 1065353216/1

ServerToClient: SMSG_SPELL_START (0x107A) Length: 57 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.750 Number: 60312
bits44: 0
hasSplineElevation: 1
hasSourceLocation: 0
hasElevation: 1
hasTargetString: 1
hasAmmoInventoryType: 1
hasDestLocation: 0
hasDelayTime: 1
hasAmmoDisplayId: 1
hasTargetFlags: 0
Target Flags: Unit (2)
hasPredictedHeal: 1
hasRunesStateBefore: 1
hasCastSchoolImmunities: 1
extraTargetCount: 0
hasRunesStateAfter: 1
hasUnkMovementField: 1
hasVisualChain: 0
hasPredictedType: 1
Guid3: 0x0
Guid7: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
CastTime: 0
Guid6: 0x0
Cast Flags: PendingCast, HasTrajectory, Unknown3 (11)
CastCount: 0
Spell ID: 38586
Text: 

ServerToClient: SMSG_SPELL_GO (0x09D8) Length: 65 ConnectionIndex: 2 Time: 09/03/2014 01:32:35.750 Number: 60313
Target Flags: Unit (2)
[0] Guid8: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
Int50: 958674760
Cast Flags: PendingCast, Unknown3, Unknown7 (265)
CastCount: 0
Spell ID: 38586
casterUnitGUID: Full: 0x000000000000000 Type: Player Low: 000000000
CasterGUID: Full: 0x000000000000000 Type: Player Low: 000000000
targetGUID: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
ItemTargetGUID: 0x0
UnkGUID: 0x0

ServerToClient: SMSG_UPDATE_OBJECT (0x1792) Length: 275 ConnectionIndex: 2 Time: 09/03/2014 01:32:36.125 Number: 60317
Map: 530
Count: 1
[0] UpdateType: Values
[0] GUID: Full: 0x000000000000000 Type: Player Low: 000000000
[0] UNIT_FIELD_BYTES_1: 65536/9.18355E-41

ServerToClient: SMSG_CANCEL_AUTO_REPEAT (0x1E0F) Length: 8 ConnectionIndex: 2 Time: 09/03/2014 01:32:36.125 Number: 60318
Guid: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578

ServerToClient: SMSG_AURA_UPDATE (0x0072) Length: 37 ConnectionIndex: 2 Time: 09/03/2014 01:32:36.125 Number: 60322
[0] CasterGUID: Full: 0x000000000000000 Type: Player Low: 000000000
[0] Flags: Positive (2)
[0] Caster Level: 85
[0] Spell ID: 38586
[0] Charges: 0
[0] Effect Mask: 1
[0] Slot: 0
Guid: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578

ServerToClient: SMSG_UPDATE_OBJECT (0x1792) Length: 650 ConnectionIndex: 2 Time: 09/03/2014 01:32:36.922 Number: 60332
Map: 530
Count: 2
[0] UpdateType: Values
[0] GUID: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578
[0] UNIT_FIELD_CHARMEDBY: 000000000/6.306248E-35
[0] 15: 83886080/6.018531E-36
[0] UNIT_FIELD_POWER_REGEN_FLAT_MODIFIER: 1096688703/13.88385
[0] 46: 0/0
[0] 47: 0/0
[0] 48: 0/0
[0] 49: 0/0
[0] UNIT_FIELD_POWER_REGEN_INTERRUPTED_FLAT_MODIFIER: 0/0
[0] 51: 0/0
[0] 52: 0/0
[0] 53: 0/0
[0] 54: 0/0
[0] UNIT_FIELD_FACTIONTEMPLATE: 5/7.006492E-45
[0] UNIT_FIELD_FLAGS: 16777224/2.350991E-38
[0] UNIT_FIELD_MINDAMAGE: 1133690620/293.4921
[0] UNIT_FIELD_MAXDAMAGE: 1137900008/421.9524
[0] UNIT_FIELD_MINOFFHANDDAMAGE: 1125302012/146.746
[0] UNIT_FIELD_MAXOFFHANDDAMAGE: 1129511400/210.9762
[0] UNIT_FIELD_PETEXPERIENCE: 0/0
[0] UNIT_FIELD_PETNEXTLEVELEXP: 2147483647/NaN
[0] UNIT_FIELD_STAT: 138/1.933792E-43
[0] 91: 37/5.184804E-44
[0] 92: 96/1.345247E-43
[0] 93: 306/4.287973E-43
[0] 94: 246/3.447194E-43
[0] UNIT_FIELD_POSSTAT: 0/0
[0] 96: 0/0
[0] 97: 0/0
[0] 98: 0/0
[0] 99: 0/0
[0] UNIT_FIELD_NEGSTAT: 0/0
[0] 101: 0/0
[0] 102: 0/0
[0] 103: 0/0
[0] 104: 0/0
[0] UNIT_FIELD_RESISTANCES: 4653/6.520242E-42
[0] 106: 0/0
[0] 107: 0/0
[0] 108: 0/0
[0] 109: 0/0
[0] 110: 0/0
[0] 111: 0/0
[0] UNIT_FIELD_RESISTANCEBUFFMODSPOSITIVE: 0/0
[0] 113: 0/0
[0] 114: 0/0
[0] 115: 0/0
[0] 116: 0/0
[0] 117: 0/0
[0] 118: 0/0
[0] UNIT_FIELD_RESISTANCEBUFFMODSNEGATIVE: 0/0
[0] 120: 0/0
[0] 121: 0/0
[0] 122: 0/0
[0] 123: 0/0
[0] 124: 0/0
[0] 125: 0/0
[0] UNIT_FIELD_BASE_HEALTH: 4253/5.959722E-42
[0] UNIT_FIELD_ATTACK_POWER: 256/3.587324E-43
[0] UNIT_FIELD_ATTACK_POWER_MOD_POS: 0/0
[0] UNIT_FIELD_ATTACK_POWER_MOD_NEG: 0/0
[0] UNIT_FIELD_ATTACK_POWER_MULTIPLIER: 0/0
[0] UNIT_FIELD_RANGED_ATTACK_POWER: 0/0
[0] UNIT_FIELD_RANGED_ATTACK_POWER_MOD_POS: 0/0
[0] UNIT_FIELD_RANGED_ATTACK_POWER_MOD_NEG: 0/0
[0] UNIT_FIELD_RANGED_ATTACK_POWER_MULTIPLIER: 0/0
[0] UNIT_FIELD_MINRANGEDDAMAGE: 1132492247/256.9206
[0] UNIT_FIELD_MAXRANGEDDAMAGE: 1136701635/385.381
[0] UNIT_FIELD_POWER_COST_MODIFIER: 0/0
[0] 140: 0/0
[0] 141: 0/0
[0] 142: 0/0
[0] 143: 0/0
[0] 144: 0/0
[0] 145: 0/0
[0] UNIT_FIELD_POWER_COST_MULTIPLIER: 0/0
[0] 147: 0/0
[0] 148: 0/0
[0] 149: 0/0
[0] 150: 0/0
[0] 151: 0/0
[0] 152: 0/0
[0] UNIT_FIELD_MAXHEALTHMODIFIER: 0/0
[1] UpdateType: Values
[1] GUID: Full: 0x000000000000000 Type: Player Low: 000000000
[1] UNIT_FIELD_CHARM: 8357578/1.171146E-38
[1] 9: 4046476973/-8.731863E+29
[1] PLAYER_FARSIGHT: 8357578/1.171146E-38
[1] 1138: 4046476973/-8.731863E+29

ServerToClient: SMSG_PET_SPELLS (0x095A) Length: 82 ConnectionIndex: 1 Time: 09/03/2014 01:32:37.078 Number: 60335
[0] Spell/Action: 2 slot: 7
[1] Spell/Action: 0 slot: 0
[2] Spell/Action: 0 slot: 0
[3] Spell/Action: 42347 slot: 8
[4] Spell/Action: 38605 slot: 9
[5] Spell/Action: 38629 slot: 10
[6] Spell/Action: 0 slot: 11
[7] Spell/Action: 0 slot: 0
[8] Spell/Action: 0 slot: 0
[9] Spell/Action: 0 slot: 0
[0] Int14: 0
[0] Int14: 38578
[0] Int14: 0
[0] Int14: 0
Int42: 0
Int40: 0
Int24: 298939
Int20: 257
Guid: Full: 0xF13056AD007F86CA Type: Unit Entry: 22189 Low: 8357578

@Killyana
Copy link
Member

This spell http://www.wowhead.com/spell=38629/poison-keg also require a spell_script

@ccrs
Copy link
Member

ccrs commented Aug 1, 2015

confirm 80ec3e1

I can create the spellscript if u tell me what it should do :)

@killradio
Copy link

@ccrs easy:
Once you use the drum, you will take control of a marmot. Your body will despawn so you won't have to worry about random people attacking you.

The marmot has 4 abilities:
Attack - Shouldn't be used
Stealth - You might need to activate this since it may not be on when you get control of the marmot. This allows you to sneak through the camp easier. However if you get too close to an ogre, it will see through the stealth and attack.
Throw Acorn - Similar to the rogue's Distract ability. You can toss an acorn to cause ogres to face away from you. This helps you to sneak by.
Poison Keg - When you are near a keg, use this to poison it. If you put your cursor over a keg, you will get the Use "cog" cursor. Right-clicking on the keg will not poison it.

@Aokromes
Copy link
Member

Aokromes commented Jun 14, 2016

@ccrs can you give love to this? :P

@ghost ghost changed the title [Quest] The Smallest Creatures (Id 10720) (Horde Sided) (335a) [Quest] The Smallest Creatures (Id 10720) (Horde) (335a) Aug 5, 2017
@ghost
Copy link

ghost commented Aug 5, 2017

TrinityCore rev. 906498e 2017-08-04 03:52:24 +0200 (3.3.5 branch) (Win64, Release, Static)
TDB 335.63 + updates up to and including 2017_08_04_06_world.sql

No improvements on this quest yet, have to complete quest with GM command.
@dr-j 's suggestion to use C++ scripts for all parts of the quest looks reasonable.

@Aokromes
Copy link
Member

any hope to fix this quest? it blocks horde to get outland quests achievement.

@dr-j
Copy link
Contributor

dr-j commented Jun 27, 2020

Well the issue is with the spell used to possess the marmot seems the possessed creature becomes invisible and gets killed by unseen mobs (ogres) only the player who summoned should be invisible

@ghost
Copy link

ghost commented Jun 28, 2020

Sounds like targeting issue in the spell script or the (scripted) spell itself?

@dr-j
Copy link
Contributor

dr-j commented Jul 13, 2021

Or maybe dbc spell I see in spell dbc there is spell 38578 [DND]Rexxar's Rodent Trigger but seems this spell has no effects as seems missing data

@dr-j
Copy link
Contributor

dr-j commented Jul 13, 2021

but still seems biggest issue is the hiding with the marmots you can see that marmot does not have this aura but player does but when charming marmot you still get the invisibility aura which makes all mobs invisible also when try poisoning the kegs you get told you are too far away if you spawn at the marmot den (where player is) and then click on it then you dont get error.

@dr-j
Copy link
Contributor

dr-j commented Jul 13, 2021

Apply the following and this makes the quest completable however you have to click the coax marmot aura off so you can see mobs and dont get killed by invisible mobs (due to marmot incorrectly having invisibility aura which should only be on player. Also the stealth ability used by the marmot does not appear to work well

UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(22189,22356,22367,22368);
DELETE FROM `smart_scripts` WHERE `entryorguid`  IN(22189,22356,22367,22368) 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 
(22189, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 86, 38586, 0, 7, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Marmot - On Just Summoned - Invoker Cast [DND]Charm Rexxars Rodent'),
(22189, 0, 1, 0, 8, 0, 100, 512, 38992, 0, 0, 0, 85, 38996, 2, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Marmot - On Spellhit [DND]Keg Credit Trigger - Invoker Cast  [DND]Green Eye Grog Credit'),
(22189, 0, 2, 0, 8, 0, 100, 512, 38992, 0, 0, 0, 85, 38997, 2, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Marmot - On Spellhit [DND]Keg Credit Trigger - Invoker Cast  [DND]Ripe Moonshine Credit'),
(22189, 0, 3, 0, 8, 0, 100, 512, 38992, 0, 0, 0, 85, 38998, 2, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Marmot - On Spellhit [DND]Keg Credit Trigger - Invoker Cast  [DND]Fermented Seed Beer Credit'),
(22189, 0, 4, 0, 54, 0, 100, 512, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Marmot - On Just Summoned - Store Target'),
(22356, 0, 0, 1, 8, 0, 100, 0, 38629, 0, 0, 0, 11, 38992, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '[DND]Green Spot Grog Keg Credit - On Spellhit Poison Keg - Cast [DND]Keg Credit Trigger'),
(22367, 0, 0, 1, 8, 0, 100, 0, 38629, 0, 0, 0, 11, 38992, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '[DND]Ripe Moonshine Keg Credit - On Spellhit Poison Keg - Cast [DND]Keg Credit Trigger'),
(22368, 0, 0, 1, 8, 0, 100, 0, 38629, 0, 0, 0, 11, 38992, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '[DND]Fermented Seed Beer Keg Credit - On Spellhit Poison Keg - Cast [DND]Keg Credit Trigger'),
(22356, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 20, 185206, 0, 0, 0, 0, 0, 0, '[DND]Green Spot Grog Keg Credit - On Spellhit Poison Keg - Activate Green Spot Grog Keg'),
(22367, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 20, 185213, 0, 0, 0, 0, 0, 0, '[DND]Ripe Moonshine Keg Credit - On Spellhit Poison Keg - Activate Ripe Moonshine Keg'),
(22368, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 20, 185214, 0, 0, 0, 0, 0, 0, '[DND]Fermented Seed Beer Keg Credit - On Spellhit Poison Keg - Activate Fermented Seed Beer Keg');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`IN(38629,38992);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 38629, 0, 0, 31, 0, 3, 22356, 0, 0, 0, 0, '', 'Poison Keg Targets [DND]Green Spot Grog Keg Credit'),
(13, 1, 38629, 0, 1, 31, 0, 3, 22367, 0, 0, 0, 0, '', 'Poison Keg Targets [DND]Ripe Moonshine Keg Credit'),
(13, 1, 38629, 0, 2, 31, 0, 3, 22368, 0, 0, 0, 0, '', 'Poison Keg Targets [DND]Fermented Seed Beer Keg Credit'),
(13, 1, 38992, 0, 2, 31, 0, 3, 22189, 0, 0, 0, 0, '', '[DND]Keg Credit Trigger targets Marmot');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` IN(2,3,4) AND `SourceEntry`=22189 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 2, 22189, 0, 0, 30, 1, 185206, 15, 0, 0, 0, 0, '', 'Run SAI script if invoker is nearby gameobject Green Spot Grog Keg'),
(22, 3, 22189, 0, 0, 30, 1, 185213, 15, 0, 0, 0, 0, '', 'Run SAI script if invoker is nearby gameobject Ripe Moonshine Keg'),
(22, 4, 22189, 0, 0, 30, 1, 185214, 15, 0, 0, 0, 0, '', 'Run SAI script if invoker is nearby gameobject Seed Beer Keg');

@dr-j
Copy link
Contributor

dr-j commented Jul 13, 2021

Some more about the coax marmot spell this aura is correctly only getting cast on player not marmot however seems screen effect from player been invisible is applied to marmot visually even though the marmot itself does not have this aura thats why if you use the marmot to run into camp with this aura even though you wont see any ogres on your screen due to the invisible screen effect (which should not be there while controlling marmot) but they can still see and kill marmot just you cant seems sight gets changed to that of marmot but the death/ghost effect remains from player aura even though you are controlling marmot (and ye marmot only has the charm aura)

@CraftedRO
Copy link
Contributor

6e07acb Ok I tested this quest and atm its completly broken (only gives some invis aura directly to player) no actionbar nothing.
But after aplying dr-j fix seems a lot better I get transformed into marmot I got some invisibility after using Stealth but the problem is that the main actionbar spell Poison Keg does nothing when Im near kegs , probably related to those dberrors that appear after importing the above sql :

SourceEntry 38992 SourceGroup 1 in condition table - spell 38992 does not have implicit targets of types: AREA, CONE, NEARBY, CHAIN or is not SPELL_EFFECT_PERSISTENT_AREA_AURA or SPELL_EFFECT_APPLY_AREA_AURA_* for effect 0, SourceGroup needs correction, ignoring.

@CraftedRO
Copy link
Contributor

I managed to clear dberror by changing Keg Credit Trigger targets Marmot SourceTypeOrReferenceId condition to 21(SOURCE_TYPE_VEHICLE_SPELL) - no clue if is right.
However I only coud take credit on kegs after removing Stealth 42347 (by pressing again on actionbar) and Coax Marmot 38544.

@grimgravy
Copy link

I wrote some code for this quest and the result was satisfactory, it is working. However, if you enter combat with a mob, you will return to the beginning of the invocation (evade). Link code a5b9f3f

@Aokromes
Copy link
Member

Aokromes commented Apr 7, 2023

@grimgravy can you make a pull request? maybe on that way someone can find a way to fix it.
suggestion, make a branch for the fix for more easy mergeability.

@grimgravy grimgravy linked a pull request Apr 8, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

8 participants