Core/Creature: Refactor and improve vendor items (#20328)

* Implement item bonuses in vendors.
* Implement the PlayerConditionID and IgnoreFiltering DB columns.
* Fix loading referenced vendor items
* Allow adding bonuses in .npc add item command

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_10_09_00_world.sql b/sql/updates/world/master/2017_10_09_00_world.sql
new file mode 100644
index 00000000000..8646ecb9eeb
--- /dev/null
+++ b/sql/updates/world/master/2017_10_09_00_world.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `npc_vendor`
+  ADD `BonusListIDs` TEXT NULL AFTER `type`;
+
+ALTER TABLE `game_event_npc_vendor`
+  ADD `BonusListIDs` TEXT NULL,
+  ADD PlayerConditionID INT(10) unsigned NOT NULL DEFAULT '0',
+  ADD IgnoreFiltering TINYINT(3) unsigned NOT NULL DEFAULT '0';
+
+UPDATE `command` SET `help`='Syntax: .npc add item #itemId <#maxcount><#incrtime><#extendedcost><#bonusListIDs>\r\nAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list and time to item count restoring and items ExtendedCost.\r\n#bonusListIDs is a semicolon separated list of bonuses to add to item (such as Mythic/Heroic/Warforged/socket)' WHERE `name`='npc add item';