Add support for vendors selling the same items with different extendedCost - original code by Vladimir (thanks mate)

Closes issue #1756

--HG--
branch : trunk

2 files changed, 5 insertions, 0 deletions

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);