Azerothcore-wotlk: Brewfest - unable to receive Synthebrew Goggles

[locus313]

CURRENT BEHAVIOUR:

When you click on the text "I'd like a pair of Synthebrew Goggles." it does nothing

EXPECTED BLIZZLIKE BEHAVIOUR:

When you click on the text above it should create the Synthebrew Goggles.
https://wowgaming.altervista.org/aowow/?item=46735
Looks like they are created from this spell:
https://wowgaming.altervista.org/aowow/?spell=66592

STEPS TO REPRODUCE THE PROBLEM:

1. Talk to Glodrak Huntsniper (horde) or Goldark Snipehunter (alliance)
2. Click on the text "What are Synthebrew Goggles?"
3. Then click on "I'd like a pair of Synthebrew Goggles." and see it does not create the item

EXTRA NOTES:

AC HASH/COMMIT:

https://github.com/azerothcore/azerothcore-wotlk/commit/4406830e36fc16e2fd79354a70f7650756bf6257

OPERATING SYSTEM:

Centos7

MODULES:

mod-ah-bot
mod-autobalance
mod-cfbg
mod-custom-login
mod-individual-xp
mod-transmog

OTHER CUSTOMIZATIONS:

[Kitzunu]

Super easy fix. If I remember I can do it tomorrow

[genion18]

/* Brewfest Horde and Allianz */
/* (C) Toxic/ICC 2020 */
/* Synthebrew Goggles and Ram Racing Reins Fix*/
DELETE FROM `smart_scripts` WHERE `entryorguid`= 24510 and `source_type` = 0 and `id` in (3,4,5,6);
INSERT INTO `smart_scripts` VALUES (24510, 0, 3, 4, 62, 0, 100, 0, 8958, 6, 0, 0, 0, 11, 44262, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Driz Tumblequick - On Gossip Option 0 Selected - Cast \"Create Item - Ram Racing Reins\"");
INSERT INTO `smart_scripts` VALUES (24510, 0, 4, 0, 61, 0, 100, 0, 8958, 6, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Driz Tumblequick - On Gossip Option 0 Selected - Close Gossip");
INSERT INTO `smart_scripts` VALUES (24510, 0, 5, 6, 62, 0, 100, 0, 8960, 0, 0, 0, 0, 11, 44262, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Driz Tumblequick - On Gossip Option 0 Selected - Cast \"Create Item - Ram Racing Reins\"");
INSERT INTO `smart_scripts` VALUES (24510, 0, 6, 0, 61, 0, 100, 0, 8960, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Driz Tumblequick - On Gossip Option 0 Selected - Close Gossip");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 15 and `SourceGroup` in (10603,10604) AND `SourceEntry`= 1 ;
INSERT INTO `conditions` VALUES (15, 10603, 1, 0, 0, 2, 0, 46735, 1, 1, 1, 0, 0, "", "Gossip Option when player has no item Synthebrew Goggles");
INSERT INTO `conditions` VALUES (15, 10604, 1, 0, 0, 2, 0, 46735, 1, 1, 1, 0, 0, "", "Gossip Option when player has no item Synthebrew Goggles");

DELETE FROM `smart_scripts` WHERE `entryorguid`= 24657 and `source_type` = 0 and `id` in (0,1,2,3,4,5,6);
INSERT INTO `smart_scripts` VALUES (24657, 0, 0, 0, 10, 0, 100, 0, 1, 25, 1000, 1000, 0, 11, 43714, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper <Ram Racing Apprentice> - Within 0-25 Range - Cast \"Brewfest - Throw Keg - DND\"");
INSERT INTO `smart_scripts` VALUES (24657, 0, 1, 2, 8, 0, 100, 0, 43662, 0, 0, 0, 0, 85, 44601, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper <Ram Racing Apprentice> - On SpellHit - Cast \"Brewfest - Relay Race - Intro - Assign Kill Credit\"");
INSERT INTO `smart_scripts` VALUES (24657, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 85, 43755, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper <Ram Racing Apprentice> - Within 0-25 Range - Cast \"Brewfest - Daily - Relay Race - Player - Increase Mount Duration - DND\"");
INSERT INTO `smart_scripts` VALUES (24657, 0, 3, 4, 62, 0, 100, 0, 10603, 0, 0, 0, 0, 11, 66592, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper - On Gossip Option 0 Selected - Cast \"Create Item - Synthebrew Goggles\"");
INSERT INTO `smart_scripts` VALUES (24657, 0, 4, 0, 61, 0, 100, 0, 10603, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper - On Gossip Option 0 Selected - Close Gossip");
INSERT INTO `smart_scripts` VALUES (24657, 0, 5, 6, 62, 0, 100, 0, 10604, 0, 0, 0, 0, 11, 66592, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper - On Gossip Option 0 Selected - Cast \"Create Item - Synthebrew Goggles\"");
INSERT INTO `smart_scripts` VALUES (24657, 0, 6, 0, 61, 0, 100, 0, 10604, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Glodrak Huntsniper - On Gossip Option 0 Selected - Close Gossip");

DELETE FROM `smart_scripts` WHERE `entryorguid`= 23486 and `source_type` = 0 and `id` in (1,2,3);
INSERT INTO `smart_scripts` VALUES (23486, 0, 1, 0, 61, 0, 100, 0, 10604, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Goldark Snipehunter - On Gossip Option 0 Selected - Close Gossip");
INSERT INTO `smart_scripts` VALUES (23486, 0, 2, 3, 62, 0, 100, 0, 10603, 0, 0, 0, 0, 11, 66592, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Goldark Snipehunter - On Gossip Option 0 Selected - Cast \"Create Item - Synthebrew Goggles\"");
INSERT INTO `smart_scripts` VALUES (23486, 0, 3, 0, 61, 0, 100, 0, 10603, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Goldark Snipehunter - On Gossip Option 0 Selected - Close Gossip");

DELETE FROM `gossip_menu_option` WHERE `MenuID` in (10603,10604) AND `OptionID`= 0 ;
INSERT INTO `gossip_menu_option` VALUES (10603, 0, 0, "I\d like a pair of Synthebrew Goggles.", 35220, 1, 1, 0, 0, 0, 0, "", 0, 0);
INSERT INTO `gossip_menu_option` VALUES (10604, 0, 0, "I\d like a pair of Synthebrew Goggles.", 35220, 1, 1, 0, 0, 0, 0, "", 0, 0);

Edited thit Bankcheck

[FrancescoBorzi]

@genion18 thanks for your fix, can you please open a PR with it?

[genion18]

This Fix are make for Trinitycore a770ad0 and have not Clone this Core.

For clone i missing the "Quest_Greetings" table here.

[locus313]

@genion18 Thanks, ill test the sql.

[genion18]

I forgot to write a 1 in ConditionValue3 For Bankscan.

[locus313]

@genion18 Thanks for the update. I have created a pr with the sql. including that change.

[genion18]

Thanks @locus313