From a6d1b3447209ba2203edd5d934f061228f1d1ae0 Mon Sep 17 00:00:00 2001 From: Roc13x Date: Mon, 9 Oct 2017 20:03:25 +0100 Subject: 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 --- sql/updates/world/master/2017_10_09_00_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/master/2017_10_09_00_world.sql (limited to 'sql') 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'; -- cgit v1.2.3