aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorJohn Holiver <none@none>2010-06-09 19:38:15 -0300
committerJohn Holiver <none@none>2010-06-09 19:38:15 -0300
commit5dff68e457f6c0111acfc4c55b0dfba464ca72df (patch)
tree1a2caa57f1600a4e631bbecb0e2e4e525c3ec95f /sql
parent410eb3d1b6483d5e2ff984d431bafeec419aa6ee (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/8568_world_npc_vendor.sql1
-rw-r--r--sql/updates/8568_world_trinity_string.sql4
2 files changed, 5 insertions, 0 deletions
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);
+