From 697685c3f57ffb9498e1a957333ea4fa6dd87b9a Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Fri, 30 Apr 2010 22:35:37 +0200
Subject: Add support for vendors selling the same items with different
 extendedCost - original code by Vladimir (thanks mate) Closes issue #1756

--HG--
branch : trunk
---
 sql/updates/8049_world_npc_vendor.sql      | 2 ++
 sql/updates/8049_world_trinity_strings.sql | 3 +++
 2 files changed, 5 insertions(+)
 create mode 100644 sql/updates/8049_world_npc_vendor.sql
 create mode 100644 sql/updates/8049_world_trinity_strings.sql

(limited to 'sql')

diff --git a/sql/updates/8049_world_npc_vendor.sql b/sql/updates/8049_world_npc_vendor.sql
new file mode 100644
index 00000000000..c09d579f725
--- /dev/null
+++ b/sql/updates/8049_world_npc_vendor.sql
@@ -0,0 +1,2 @@
+ALTER TABLE npc_vendor DROP PRIMARY KEY,
+ADD PRIMARY KEY (`entry`,`item`,`ExtendedCost`);
diff --git a/sql/updates/8049_world_trinity_strings.sql b/sql/updates/8049_world_trinity_strings.sql
new file mode 100644
index 00000000000..e04e776a3e8
--- /dev/null
+++ b/sql/updates/8049_world_trinity_strings.sql
@@ -0,0 +1,3 @@
+DELETE FROM trinity_string WHERE entry in (210);
+INSERT INTO trinity_string VALUES
+(210,'Item ''%i'' (with extended cost %u) already in vendor list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3