From 5dff68e457f6c0111acfc4c55b0dfba464ca72df Mon Sep 17 00:00:00 2001 From: John Holiver Date: Wed, 9 Jun 2010 19:38:15 -0300 Subject: Allow to sell item for: money, extendedCost or money+extendedCost. The new method (money+extende) can be used by using negative values on npc_vendor.ExtendedCost. This one goes dedicated to ZxBiohazardZx. Tnx also to VladimirMangos. --HG-- branch : trunk --- sql/updates/8568_world_npc_vendor.sql | 1 + sql/updates/8568_world_trinity_string.sql | 4 ++++ 2 files changed, 5 insertions(+) create mode 100644 sql/updates/8568_world_npc_vendor.sql create mode 100644 sql/updates/8568_world_trinity_string.sql (limited to 'sql') diff --git a/sql/updates/8568_world_npc_vendor.sql b/sql/updates/8568_world_npc_vendor.sql new file mode 100644 index 00000000000..63645847ef6 --- /dev/null +++ b/sql/updates/8568_world_npc_vendor.sql @@ -0,0 +1 @@ +ALTER TABLE npc_vendor CHANGE COLUMN `ExtendedCost` `ExtendedCost` mediumint(8) NOT NULL default '0' COMMENT 'negative if cost must exclude normal money cost'; diff --git a/sql/updates/8568_world_trinity_string.sql b/sql/updates/8568_world_trinity_string.sql new file mode 100644 index 00000000000..029966a4968 --- /dev/null +++ b/sql/updates/8568_world_trinity_string.sql @@ -0,0 +1,4 @@ +DELETE FROM trinity_string WHERE entry IN (210); +INSERT INTO trinity_string VALUES +(210,'Item \'%i\' (with extended cost %i) already in vendor list.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); + -- cgit v1.2.3