[Bug]Haggle missing waypoints and text

[Crysicle]

Bug:

1. Haggle doesn't have any waypoints or text.

Broadcast IDs of the text he should say: 9088 - "Spare some change?" as say 9089 - "I had it all! I had it all and then I lost it. Lost...all gone...like..my mind. My mind is like cheese... I like cheese." 9098 - "Forty-two... forty-two... forty-two what? It could be anything! Forty-two... hmmm..." 9141 - "%s sifts through the trash." as emote 9149 - "Rats everywhere. Everywhere I see rats. Always looking at me with their beedy little eyes. I'll show them. I'll show them all!" 9150 - "Rat-kabobs! Get your tasty rat-kabobs! Get them while they're hot!" Missing - "Cheese...I love cheese. If I only had cheese. If I only had cheese like before." Missing - "In the trash...always in the trash...that's where the money is!"

Needs someone to go to Deeprun Tram on retail to get all the texts.

Links: Haggle - http://www.wowhead.com/npc=14041

Core rev: b5f0b85

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

[Killyana]

@Rushor can you take a look to this ?

[ZenoX92]

I'm probably missing something here, since there's no much info, but here you are:

-- Haggle
UPDATE `creature` SET `position_x`=-18.9026, `position_y`=-19.7528, `position_z`=-4.29737, `orientation`=1.60221 WHERE `guid`=53788;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=14041;
DELETE FROM `smart_scripts` WHERE `entryorguid`=14041 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1404100,1404101,1404102,1404103,1404104,1404105,1404106) AND `source_type`=9;
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
(14041,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Spawn - Set Event Phase 1"),
(14041,0,1,0,11,0,100,0,0,0,0,0,89,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Spawn - Start Random Movement"),
(14041,0,2,0,1,1,100,0,1000,10000,60000,90000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - Out of Combat (Phase 1) - Say Line 0"),
(14041,0,3,0,1,0,100,0,300000,300000,900000,900000,80,1404100,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - Out of Combat - Run Script"),
(14041,0,4,5,40,0,100,0,2,14041,0,0,80,1404101,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 2 Reached - Run Script"),
(14041,0,5,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.0592928,"Haggle - On Point 2 Reached - Set Orientation"),
(14041,0,6,7,40,0,100,0,3,14041,0,0,80,1404101,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 3 Reached - Run Script"),
(14041,0,7,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.0671513,"Haggle - On Point 3 Reached - Set Orientation"),
(14041,0,8,9,40,0,100,0,7,14041,0,0,80,1404101,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 7 Reached - Run Script"),
(14041,0,9,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.11056,"Haggle - On Point 7 Reached - Set Orientation"),
(14041,0,10,11,40,0,100,0,8,14041,0,0,80,1404101,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 8 Reached - Run Script"),
(14041,0,11,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.17339,"Haggle - On Point 8 Reached - Set Orientation"),
(14041,0,12,0,40,0,100,0,10,14041,0,0,80,1404106,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 10 Reached - Run Script"),
(14041,0,13,0,1,0,100,0,600000,600000,900000,900000,80,1404102,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - Out of Combat - Run Script"),
(14041,0,14,15,40,0,100,0,3,1404100,0,0,80,1404103,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 3 Reached - Run Script"),
(14041,0,15,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.51672,"Haggle - On Point 3 Reached - Set Orientation"),
(14041,0,16,0,40,0,100,0,6,1404100,0,0,80,1404106,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 6 Reached - Run Script"),
(14041,0,17,0,1,0,100,0,900000,900000,900000,900000,80,1404104,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - Out of Combat - Run Script"),
(14041,0,18,0,40,0,100,0,5,1404101,0,0,80,1404105,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 5 Reached - Run Script"),
(14041,0,19,0,40,0,100,0,6,1404102,0,0,80,1404106,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Point 6 Reached - Run Script"),
(1404100,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Event Phase 0"),
(1404100,9,1,0,0,0,100,0,0,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Stop Random Movement"),
(1404100,9,2,0,0,0,100,0,1000,1000,0,0,53,0,14041,0,0,0,2,1,0,0,0,0,0,0,0,"Haggle - On Script - Start Waypoint"),
(1404101,9,0,0,0,0,100,0,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Pause Waypoint"),
(1404101,9,1,0,0,0,100,0,1000,1000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 2"),
(1404101,9,2,0,0,0,100,0,0,0,0,0,17,69,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Emote State 69"),
(1404101,9,3,0,0,0,100,0,13000,13000,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Emote State 0"),
(1404101,9,4,0,0,0,30,0,0,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 3"),
(1404102,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Event Phase 0"),
(1404102,9,1,0,0,0,100,0,0,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Stop Random Movement"),
(1404102,9,2,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 1"),
(1404102,9,3,0,0,0,100,0,1000,1000,0,0,53,0,1404100,0,0,0,2,1,0,0,0,0,0,0,0,"Haggle - On Script - Start Waypoint"),
(1404103,9,0,0,0,0,100,0,0,0,0,0,54,60000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Pause Waypoint"),
(1404103,9,1,0,0,0,100,0,1000,1000,0,0,90,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Flag Standstate 'Sleep'"),
(1404103,9,2,0,0,0,100,0,56000,56000,0,0,91,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Remove Flag Standstate 'Sleep'"),
(1404104,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Event Phase 0"),
(1404104,9,1,0,0,0,100,0,0,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Stop Random Movement"),
(1404104,9,2,0,0,0,100,0,1000,1000,0,0,53,0,1404101,0,0,0,2,1,0,0,0,0,0,0,0,"Haggle - On Script - Start Waypoint"),
(1404105,9,0,0,0,0,100,0,0,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 4"),
(1404105,9,1,0,0,0,100,0,4000,4000,0,0,29,0,0,0,0,0,0,10,94495,13016,0,0,0,0,0,"Haggle - On Script - Start Following Deeprun Rat"),
(1404105,9,2,0,0,0,100,0,0,0,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 5"),
(1404105,9,3,0,0,0,100,0,30000,30000,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Haggle - On Script - Stop Following"),
(1404105,9,4,0,0,0,100,0,0,0,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Say Line 6"),
(1404105,9,5,0,0,0,100,0,5000,5000,0,0,53,0,1404102,0,0,0,2,1,0,0,0,0,0,0,0,"Haggle - On Script - Start Waypoint"),
(1404106,9,0,0,0,0,100,0,0,0,0,0,89,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Start Random Movement"),
(1404106,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Haggle - On Script - Set Event Phase 1");

DELETE FROM `creature_text` WHERE `CreatureID`=14041;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(14041,0,0,"Rats everywhere.  Everywhere I see rats.  Always looking at me with their beady little eyes.  I'll show them.  I'll show them all!",12,7,100,1,0,0,9149,0,"Haggle"),
(14041,0,1,"Rat-kabobs!  Get your tasty Rat-kabobs here!  Get them while they last!",12,7,100,22,0,0,9150,0,"Haggle"),
(14041,0,2,"Spare some change?",12,7,100,6,0,0,9088,0,"Haggle"),
(14041,0,3,"I had it all!  I had it all and then I lost it.  Lost... all gone... like... my mind.  My mind is like... cheese.  I like cheese.",12,7,100,1,0,0,9089,0,"Haggle"),
(14041,0,4,"Forty-two... forty-two... forty-two what?  It could be anything!  Forty-two... hmmm...",12,7,100,1,0,0,9098,0,"Haggle"),
(14041,0,5,"Cheese... I love cheese. If I only had cheese. If I only had cheese like before.",12,7,100,1,0,0,0,0,"Haggle"),
(14041,0,6,"Clap your hands everybody, and everybody clap your hands!",12,7,100,4,0,0,9086,0,"Haggle"),
(14041,0,7,"Thank you, you're a great audience!  I'll be here all week!",12,7,100,2,0,0,9087,0,"Haggle"),
(14041,0,8,"Show your appreciation for the arts and drop some coins in my hat!",12,7,100,5,0,0,9090,0,"Haggle"),
(14041,1,0,"%s yawns.",16,0,100,0,0,0,9147,0,"Haggle"),
(14041,2,0,"%s sifts through the trash.",16,0,100,0,0,0,9141,0,"Haggle"),
(14041,3,0,"In the trash... always in the trash... that's where the money is!",12,7,100,0,0,0,0,0,"Haggle"),
(14041,4,0,"%s stares hungrily at a Deeprun Rat.",16,0,100,0,0,0,9095,0,"Haggle"),
(14041,5,0,"Mmmm... don't you look good enough to eat.",12,7,100,0,0,0,9096,0,"Haggle"),
(14041,6,0,"On second thought... I think I'll pass.",12,7,100,0,0,0,9097,0,"Haggle");

DELETE FROM `waypoints` WHERE `entry` IN (14041,1404100,1404101,1404102);
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
(14041,1,-21.6242,-15.9608,-4.29737,""),
(14041,2,-21.4995,-9.48447,-4.29737,""),
(14041,3,-20.906,20.9826,-4.29737,""),
(14041,4,-21.1492,33.1251,-4.29737,""),
(14041,5,-18.5923,34.7846,-4.29737,""),
(14041,6,-15.8688,33.3302,-4.29737,""),
(14041,7,-15.9896,26.9844,-4.29737,""),
(14041,8,-16.692,-3.31245,-4.29737,""),
(14041,9,-16.4994,-15.2884,-4.29737,""),
(14041,10,-18.9026,-19.7528,-4.29737,""),
(1404100,1,-16.4994,-15.2884,-4.29737,""),
(1404100,2,-16.692,-3.31245,-4.29737,""),
(1404100,3,-17.7995,-1.00968,-3.76211,""),
(1404100,4,-16.692,-3.31245,-4.29737,""),
(1404100,5,-16.4994,-15.2884,-4.29737,""),
(1404100,6,-18.9026,-19.7528,-4.29737,""),
(1404101,1,-9.1328,-23.418,-4.29737,""),
(1404101,2,-4.19966,-28.3455,-4.29737,""),
(1404101,3,12.4518,-28.7938,-4.29737,""),
(1404101,4,17.2085,-22.3988,-4.29737,""),
(1404101,5,32.4463,-23.0003,-4.29737,""),
(1404102,1,32.4463,-23.0003,-4.29737,""),
(1404102,2,17.2085,-22.3988,-4.29737,""),
(1404102,3,12.4518,-28.7938,-4.29737,""),
(1404102,4,-4.19966,-28.3455,-4.29737,""),
(1404102,5,-9.1328,-23.418,-4.29737,""),
(1404102,6,-18.9026,-19.7528,-4.29737,"");

[ZenoX92]

I noticed I couldn't stop the follow movement using this line: (1404105,9,3,0,0,0,100,0,30000,30000,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Haggle - On Script - Stop Following")

But since I'm not up to date with the core, not sure if it's still broken. @Killyana, could you check it?

[offl]

https://github.com/TrinityCore/TrinityCore/commit/f2c2210dbb88ffa3571344030d77f80c0a765591#diff-826db2c51e99684b63412f81253eae4cR54-R58

[Killyana]

There's also SMART_ACTION_PAUSE_MOVEMENT

[ZenoX92]

There's also SMART_ACTION_PAUSE_MOVEMENT

That didn't work either.

[ghost]

Maybe you need to use the hack suggested by offl ?