diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_10_09_00_world.sql | 9 |
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'; |