DB/Creature: update some Stormwind vendors

+ SAI script for Bernard Gump
Closes #28367

1 files changed, 173 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_10_21_02_world.sql b/sql/updates/world/master/2022_10_21_02_world.sql
new file mode 100644
index 00000000000..1b565da77fa
--- /dev/null
+++ b/sql/updates/world/master/2022_10_21_02_world.sql
@@ -0,0 +1,173 @@
+ -- Bernard Gump smart ai
+SET @ENTRY := 1302;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+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, 10, 0, 100, 0, 1, 8, 180000, 300000, 1, 0, 0, 1, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On only non hostile unit in line of sight (OOC) - Self: Talk Greetings. (0) to Unit in LOS');
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 1302;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(1302, 0, 0, 'Greetings.', 12, 7, 100, 3, 0, 0, 30620, 0, 'Bernard Gump to Player'), -- BroadcastTextID: 30620 - 32935 - 33692 - 43337 - 43344 - 67987 - 113432 - 113724 - 113743 - 116805 - 116848 - 116855 - 116862 - 116869 - 116876 - 116883 - 116891 - 118963 - 119094 - 122350 - 125597 - 128601 - 131095 - 132552 - 140147 - 140149 - 142445 - 142489 - 144213 - 145447 - 145856 - 147420 - 176298 - 181403 - 181457 - 182009 - 182946 - 183959 - 189421 - 189817 - 189841 - 189877 - 189904 - 192271 - 192272 - 195237 - 209103 - 216530
+(1302, 0, 1, 'Greetings! Please have a look around.', 12, 7, 100, 3, 0, 0, 32809, 0, 'Bernard Gump to Player'), -- BroadcastTextID: 32809 - 43333 - 43341
+(1302, 0, 2, 'Greetings, $c.', 12, 7, 100, 3, 0, 0, 32808, 0, 'Bernard Gump to Player'), -- BroadcastTextID: 7130 - 7131 - 7132 - 13306 - 29493 - 32808 - 43330 - 43340 - 49696 - 50721
+(1302, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 7, 100, 3, 0, 0, 32810, 0, 'Bernard Gump to Player'); -- BroadcastTextID: 32810 - 43335 - 43342
+
+DELETE FROM `npc_vendor` WHERE `entry` IN (5494, 1299, 44583, 49877, 1257, 1286, 179896, 1298, 1275);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(5494, 8, 6330, 0, 0, 1, 0, 0, 45745), -- Recipe: Bristle Whisker Catfish
+(5494, 7, 6368, 0, 0, 1, 0, 0, 45745), -- Recipe: Rainbow Fin Albacore
+(5494, 6, 6325, 0, 0, 1, 0, 0, 45745), -- Recipe: Brilliant Smallfish
+(5494, 5, 6532, 0, 0, 1, 0, 0, 45745), -- Bright Baubles
+(5494, 4, 6530, 0, 0, 1, 0, 0, 45745), -- Nightcrawlers
+(5494, 3, 6529, 0, 0, 1, 0, 0, 45745), -- Shiny Bauble
+(5494, 2, 136377, 0, 0, 1, 0, 0, 45745), -- Oversized Bobber
+(5494, 1, 6256, 0, 0, 1, 0, 0, 45745), -- Fishing Pole
+(1299, 12, 13898, 0, 0, 1, 0, 0, 45745), -- Royal Dangui
+(1299, 11, 13896, 0, 0, 1, 0, 0, 45745), -- Dark Green Wedding Hanbok
+(1299, 10, 13897, 0, 0, 1, 0, 0, 45745), -- White Traditional Hanbok
+(1299, 3, 3427, 0, 0, 1, 0, 0, 45745), -- Stylish Black Shirt
+(1299, 2, 3426, 0, 0, 1, 0, 0, 45745), -- Bold Yellow Shirt
+(1299, 1, 3428, 0, 0, 1, 0, 0, 45745), -- Common Gray Shirt
+(44583, 92, 52466, 0, 2973, 1, 0, 0, 45745), -- Design: Eye of Many Deaths
+(44583, 91, 52464, 0, 2973, 1, 0, 0, 45745), -- Design: Brazen Elementium Medallion
+(44583, 90, 52465, 0, 2973, 1, 0, 0, 45745), -- Design: Entwined Elementium Choker
+(44583, 89, 52467, 0, 2973, 1, 0, 0, 45745), -- Design: Elementium Guardian
+(44583, 88, 52462, 0, 2973, 1, 0, 0, 45745), -- Design: Ring of Warring Elements
+(44583, 87, 52463, 0, 2973, 1, 0, 0, 45745), -- Design: Elementium Moebius Band
+(44583, 86, 52461, 0, 2973, 1, 0, 0, 45745), -- Design: Band of Blades
+(44583, 85, 52460, 0, 2973, 1, 0, 0, 45745), -- Design: Elementium Destroyer's Ring
+(44583, 84, 69853, 0, 2973, 1, 0, 0, 45745), -- Design: Punisher's Band
+(44583, 83, 52440, 0, 2971, 1, 0, 0, 45745), -- Design: Revitalizing Shadowspirit Diamond
+(44583, 82, 52442, 0, 2971, 1, 0, 0, 45745), -- Design: Powerful Shadowspirit Diamond
+(44583, 81, 52444, 0, 2971, 1, 0, 0, 45745), -- Design: Impassive Shadowspirit Diamond
+(44583, 80, 52445, 0, 2971, 1, 0, 0, 45745), -- Design: Forlorn Shadowspirit Diamond
+(44583, 79, 52433, 0, 2971, 1, 0, 0, 45745), -- Design: Fleet Shadowspirit Diamond
+(44583, 78, 52436, 0, 2971, 1, 0, 0, 45745), -- Design: Eternal Shadowspirit Diamond
+(44583, 77, 52443, 0, 2971, 1, 0, 0, 45745), -- Design: Enigmatic Shadowspirit Diamond
+(44583, 76, 52439, 0, 2971, 1, 0, 0, 45745), -- Design: Ember Shadowspirit Diamond
+(44583, 75, 52438, 0, 2971, 1, 0, 0, 45745), -- Design: Effulgent Shadowspirit Diamond
+(44583, 74, 52441, 0, 2971, 1, 0, 0, 45745), -- Design: Destructive Shadowspirit Diamond
+(44583, 73, 52434, 0, 2971, 1, 0, 0, 45745), -- Design: Chaotic Shadowspirit Diamond
+(44583, 72, 52435, 0, 2971, 1, 0, 0, 45745), -- Design: Bracing Shadowspirit Diamond
+(44583, 71, 52437, 0, 2971, 1, 0, 0, 45745), -- Design: Austere Shadowspirit Diamond
+(44583, 70, 52392, 0, 2970, 1, 0, 0, 45745), -- Design: Stormy Ocean Sapphire
+(44583, 69, 52391, 0, 2970, 1, 0, 0, 45745), -- Design: Sparkling Ocean Sapphire
+(44583, 68, 52390, 0, 2970, 1, 0, 0, 45745), -- Design: Solid Ocean Sapphire
+(44583, 67, 52393, 0, 2970, 1, 0, 0, 45745), -- Design: Rigid Ocean Sapphire
+(44583, 66, 52389, 0, 2970, 1, 0, 0, 45745), -- Design: Precise Inferno Ruby
+(44583, 65, 52384, 0, 2970, 1, 0, 0, 45745), -- Design: Flashing Inferno Ruby
+(44583, 64, 52380, 0, 2970, 1, 0, 0, 45745), -- Design: Delicate Inferno Ruby
+(44583, 63, 52387, 0, 2970, 1, 0, 0, 45745), -- Design: Brilliant Inferno Ruby
+(44583, 62, 52362, 0, 2970, 1, 0, 0, 45745), -- Design: Bold Inferno Ruby
+(44583, 61, 68359, 0, 2970, 1, 0, 0, 45745), -- Design: Willful Ember Topaz
+(44583, 60, 68361, 0, 2970, 1, 0, 0, 45745), -- Design: Resplendent Ember Topaz
+(44583, 59, 52411, 0, 2970, 1, 0, 0, 45745), -- Design: Resolute Ember Topaz
+(44583, 58, 52418, 0, 2970, 1, 0, 0, 45745), -- Design: Skillful Ember Topaz
+(44583, 57, 52414, 0, 2970, 1, 0, 0, 45745), -- Design: Potent Ember Topaz
+(44583, 56, 52410, 0, 2970, 1, 0, 0, 45745), -- Design: Polished Ember Topaz
+(44583, 55, 68360, 0, 2970, 1, 0, 0, 45745), -- Design: Lucent Ember Topaz
+(44583, 54, 52422, 0, 2970, 1, 0, 0, 45745), -- Design: Keen Ember Topaz
+(44583, 53, 52412, 0, 2970, 1, 0, 0, 45745), -- Design: Inscribed Ember Topaz
+(44583, 52, 52420, 0, 2970, 1, 0, 0, 45745), -- Design: Fine Ember Topaz
+(44583, 51, 52415, 0, 2970, 1, 0, 0, 45745), -- Design: Fierce Ember Topaz
+(44583, 50, 52416, 0, 2970, 1, 0, 0, 45745), -- Design: Deft Ember Topaz
+(44583, 49, 52413, 0, 2970, 1, 0, 0, 45745), -- Design: Deadly Ember Topaz
+(44583, 48, 52417, 0, 2970, 1, 0, 0, 45745), -- Design: Reckless Ember Topaz
+(44583, 47, 52421, 0, 2970, 1, 0, 0, 45745), -- Design: Artful Ember Topaz
+(44583, 46, 52419, 0, 2970, 1, 0, 0, 45745), -- Design: Adept Ember Topaz
+(44583, 45, 52431, 0, 2970, 1, 0, 0, 45745), -- Design: Zen Dream Emerald
+(44583, 44, 68742, 0, 2970, 1, 0, 0, 45745), -- Design: Vivid Dream Emerald
+(44583, 43, 52427, 0, 2970, 1, 0, 0, 45745), -- Design: Steady Dream Emerald
+(44583, 42, 52432, 0, 2970, 1, 0, 0, 45745), -- Design: Sensei's Dream Emerald
+(44583, 41, 52423, 0, 2970, 1, 0, 0, 45745), -- Design: Regal Dream Emerald
+(44583, 40, 52430, 0, 2970, 1, 0, 0, 45745), -- Design: Puissant Dream Emerald
+(44583, 39, 52426, 0, 2970, 1, 0, 0, 45745), -- Design: Piercing Dream Emerald
+(44583, 38, 52424, 0, 2970, 1, 0, 0, 45745), -- Design: Nimble Dream Emerald
+(44583, 37, 52429, 0, 2970, 1, 0, 0, 45745), -- Design: Lightning Dream Emerald
+(44583, 36, 52425, 0, 2970, 1, 0, 0, 45745), -- Design: Jagged Dream Emerald
+(44583, 35, 52428, 0, 2970, 1, 0, 0, 45745), -- Design: Forceful Dream Emerald
+(44583, 34, 52402, 0, 2970, 1, 0, 0, 45745), -- Design: Timeless Demonseye
+(44583, 33, 52399, 0, 2970, 1, 0, 0, 45745), -- Design: Sovereign Demonseye
+(44583, 32, 52400, 0, 2970, 1, 0, 0, 45745), -- Design: Shifting Demonseye
+(44583, 31, 52404, 0, 2970, 1, 0, 0, 45745), -- Design: Purified Demonseye
+(44583, 30, 52407, 0, 2970, 1, 0, 0, 45745), -- Design: Retaliating Demonseye
+(44583, 29, 52403, 0, 2970, 1, 0, 0, 45745), -- Design: Guardian's Demonseye
+(44583, 28, 52406, 0, 2970, 1, 0, 0, 45745), -- Design: Glinting Demonseye
+(44583, 27, 52408, 0, 2970, 1, 0, 0, 45745), -- Design: Veiled Demonseye
+(44583, 26, 52405, 0, 2970, 1, 0, 0, 45745), -- Design: Etched Demonseye
+(44583, 25, 52401, 0, 2970, 1, 0, 0, 45745), -- Design: Defender's Demonseye
+(44583, 24, 52409, 0, 2970, 1, 0, 0, 45745), -- Design: Accurate Demonseye
+(44583, 23, 52394, 0, 2970, 1, 0, 0, 45745), -- Design: Subtle Amberjewel
+(44583, 22, 52395, 0, 2970, 1, 0, 0, 45745), -- Design: Smooth Amberjewel
+(44583, 21, 52397, 0, 2970, 1, 0, 0, 45745), -- Design: Quick Amberjewel
+(44583, 20, 52396, 0, 2970, 1, 0, 0, 45745), -- Design: Mystic Amberjewel
+(44583, 19, 52398, 0, 2970, 1, 0, 0, 45745), -- Design: Fractured Amberjewel
+(44583, 18, 52455, 0, 2972, 1, 0, 0, 45745), -- Design: Subtle Chimera's Eye
+(44583, 17, 52453, 0, 2972, 1, 0, 0, 45745), -- Design: Stormy Chimera's Eye
+(44583, 16, 52452, 0, 2972, 1, 0, 0, 45745), -- Design: Sparkling Chimera's Eye
+(44583, 15, 52451, 0, 2972, 1, 0, 0, 45745), -- Design: Solid Chimera's Eye
+(44583, 14, 52456, 0, 2972, 1, 0, 0, 45745), -- Design: Smooth Chimera's Eye
+(44583, 13, 52454, 0, 2972, 1, 0, 0, 45745), -- Design: Rigid Chimera's Eye
+(44583, 12, 52458, 0, 2972, 1, 0, 0, 45745), -- Design: Quick Chimera's Eye
+(44583, 11, 52450, 0, 2972, 1, 0, 0, 45745), -- Design: Precise Chimera's Eye
+(44583, 10, 52457, 0, 2972, 1, 0, 0, 45745), -- Design: Mystic Chimera's Eye
+(44583, 9, 52459, 0, 2972, 1, 0, 0, 45745), -- Design: Fractured Chimera's Eye
+(44583, 8, 52448, 0, 2972, 1, 0, 0, 45745), -- Design: Flashing Chimera's Eye
+(44583, 7, 52447, 0, 2972, 1, 0, 0, 45745), -- Design: Delicate Chimera's Eye
+(44583, 6, 52449, 0, 2972, 1, 0, 0, 45745), -- Design: Brilliant Chimera's Eye
+(44583, 5, 52381, 0, 2972, 1, 0, 0, 45745), -- Design: Bold Chimera's Eye
+(44583, 4, 52196, 0, 3232, 1, 0, 0, 45745), -- Chimera's Eye
+(44583, 3, 183954, 0, 0, 1, 0, 0, 45745), -- Malleable Wire
+(44583, 2, 52188, 0, 0, 1, 0, 0, 45745), -- Jeweler's Setting
+(44583, 1, 20815, 0, 0, 1, 0, 0, 45745), -- Jeweler's Kit
+(49877, 5, 64901, 0, 0, 1, 12252, 0, 45745), -- Mantle of Stormwind
+(49877, 4, 64902, 0, 0, 1, 12252, 0, 45745), -- Cape of Stormwind
+(49877, 3, 64903, 0, 0, 1, 12252, 0, 45745), -- Shroud of Stormwind
+(49877, 2, 67531, 0, 0, 1, 12251, 0, 45745), -- Stormwind Satchel
+(49877, 1, 45574, 0, 0, 1, 0, 0, 45745), -- Stormwind Tabard
+(1257, 6, 858, 2, 0, 1, 0, 0, 45745), -- Lesser Healing Potion
+(1257, 4, 183950, 0, 0, 1, 0, 0, 45745), -- Distilled Death Extract
+(1257, 3, 3371, 0, 0, 1, 0, 0, 45745), -- Crystal Vial
+(1257, 2, 188152, 0, 0, 1, 0, 0, 45745), -- Gateway Control Shard
+(1257, 1, 64670, 0, 0, 1, 0, 0, 45745), -- Vanishing Powder
+(1286, 42, 20856, 1, 0, 1, 0, 0, 45745), -- Design: Heavy Golden Necklace of Battle
+(1286, 32, 39505, 0, 0, 1, 0, 0, 45745), -- Virtuoso Inking Set
+(1286, 31, 20815, 0, 0, 1, 0, 0, 45745), -- Jeweler's Kit
+(1286, 30, 6532, 0, 0, 1, 0, 0, 45745), -- Bright Baubles
+(1286, 29, 6530, 0, 0, 1, 0, 0, 45745), -- Nightcrawlers
+(1286, 28, 4400, 0, 0, 1, 0, 0, 45745), -- Heavy Stock
+(1286, 27, 4399, 0, 0, 1, 0, 0, 45745), -- Wooden Stock
+(1286, 26, 4289, 0, 0, 1, 0, 0, 45745), -- Salt
+(1286, 25, 3371, 0, 0, 1, 0, 0, 45745), -- Crystal Vial
+(1286, 24, 4340, 0, 0, 1, 0, 0, 45745), -- Gray Dye
+(1286, 23, 4342, 0, 0, 1, 0, 0, 45745), -- Purple Dye
+(1286, 22, 4341, 0, 0, 1, 0, 0, 45745), -- Yellow Dye
+(1286, 21, 2325, 0, 0, 1, 0, 0, 45745), -- Black Dye
+(1286, 20, 2604, 0, 0, 1, 0, 0, 45745), -- Red Dye
+(1286, 19, 3857, 0, 0, 1, 0, 0, 45745), -- Coal
+(1286, 18, 3466, 0, 0, 1, 0, 0, 45745), -- Strong Flux
+(1286, 17, 2880, 0, 0, 1, 0, 0, 45745), -- Weak Flux
+(1286, 16, 2678, 0, 0, 1, 0, 0, 45745), -- Mild Spices
+(1286, 15, 14341, 0, 0, 1, 0, 0, 45745), -- Rune Thread
+(1286, 14, 8343, 0, 0, 1, 0, 0, 45745), -- Heavy Silken Thread
+(1286, 13, 4291, 0, 0, 1, 0, 0, 45745), -- Silken Thread
+(1286, 12, 2321, 0, 0, 1, 0, 0, 45745), -- Fine Thread
+(1286, 11, 2320, 0, 0, 1, 0, 0, 45745), -- Coarse Thread
+(1286, 10, 180733, 0, 0, 1, 0, 0, 45745), -- Luminous Flux
+(1286, 9, 183955, 0, 0, 1, 0, 0, 45745), -- Curing Salt
+(1286, 8, 177062, 0, 0, 1, 0, 0, 45745), -- Penumbra Thread
+(1286, 7, 5956, 0, 0, 1, 0, 0, 45745), -- Blacksmith Hammer
+(1286, 6, 6217, 0, 0, 1, 0, 0, 45745), -- Copper Rod
+(1286, 5, 6256, 0, 0, 1, 0, 0, 45745), -- Fishing Pole
+(1286, 4, 85663, 0, 0, 1, 0, 0, 45745), -- Herbalist's Spade
+(1286, 3, 7005, 0, 0, 1, 0, 0, 45745), -- Skinning Knife
+(1286, 2, 2901, 0, 0, 1, 0, 0, 45745), -- Mining Pick
+(179896, 5, 186091, 0, 0, 1, 0, 0, 45745), -- Onyx Glare-Reducers
+(179896, 4, 186092, 0, 0, 1, 0, 0, 45745), -- Historical Perspective Shifters
+(179896, 3, 187010, 0, 0, 1, 0, 0, 45745), -- Tasteful Eyeglasses
+(179896, 2, 187009, 0, 0, 1, 0, 0, 45745), -- Dazzling Spectacles
+(179896, 1, 186090, 0, 0, 1, 0, 0, 45745), -- Simple Glasses
+(1298, 2, 3027, 0, 0, 1, 0, 1, 45745), -- Heavy Recurve Bow
+(1298, 1, 3026, 0, 0, 1, 0, 1, 45745), -- Reinforced Bow
+(1275, 2, 188152, 0, 0, 1, 0, 0, 45745), -- Gateway Control Shard
+(1275, 1, 64670, 0, 0, 1, 0, 0, 45745); -- Vanishing Powder