WotLK and TBC GMI Vendors

[paris15]

Update for ArcEmu latest revision ;)

WotLK Vendors
ID NPC
900000 -Armor: Tier VII (1)
900001 -Armor: Tier VII (2)
900002 -Armor: Season V
900003 -Weapon: Level 200+
900004 -Armor: Trinkets
900005 -Armor: Necklace
900006 -Armor: Rings
900009 -Armor: Relic
900010 -Armor: Cloak
900011 -Misc : Container
900012 -Misc : Glyph I
900013 -Misc : Glyph II
900014 -Misc : Wrist
900015 -Recipe: Book A-Z
900016 -Recipe: Leather A-Z
900017 -Recipe: Jewelcrafting A-Z
900018 -Recipe: Engineering/Enchanting A-Z
900019 -Recipe: Alchemy/Blacksmithing/Tailoring

TBC Vendors
ID NPC
50078 - Reagent: Miscellaneous
50077 - Reagent: Jeweler
50076 - Reagent: Enchant
50075 - Reagent: Alchemy
50074 - Reagent: Cooking
50073 - Reagent: Blacksmith II
50072 - Reagent: Blacksmith I
50071 - Reagent: Engineer II
50070 - Reagent: Engineer I
50069 - Reagent: Tailor II
50068 - Reagent: Tailor I
50067 - Reagent: Leather II
50066 - Reagent: Leather I
50065 - Recipe: Jeweler L-Z
50064 - Recipe: Jeweler A-K
50063 - Recipe: Enchant H-Z
50062 - Recipe: Enchant A-G
50061 - Recipe: Alchemy A-Z
50060 - Recipe: Cooking A-Z
50059 - Recipe: Blacksmith S-Z
50058 - Recipe: Blacksmith G-R
50057 - Recipe: Blacksmith A-F
50056 - Recipe: Engineer A-Z
50055 - Recipe: Tailor H-Z
50054 - Recipe: Tailor A-G
50053 - Recipe: Leather S-Z
50052 - Recipe: Leather G-R
50051 - Recipe: Leather A-F
50050 - Recipe: Book A-Z
50049 - Misc: Currency
50048 - Misc: Key
50047 - Misc: Enchantment
50045 - Misc: Container
50044 - Misc: Projectile
50043 - Misc: Mount II
50042 - Misc: Mount I
50035 - Arena: Season II
50034 - Arena: Season II
50033 - Arena: Season II
50032 - Arena: Season I
50031 - Arena: Season I
50030 - Arena: Season I
50029 - Armor: Libram/Idol/Totem
50028 - Armor: Off-Hands
50026 - Armor: Miscellaneous
50025 - Armor: Tabard
50024 - Armor: Shirt
50023 - Armor: Cloak
50022 - Armor: Trinket
50021 - Armor: Rings
50020 - Armor: Necklace
50019 - Weapon: Level 100+
50018 - Weapon: Level 75+
50017 - Weapon: Level 65+
50016 - Weapon: Level 60+
50015 - Weapon: Level 50+
50083 - Armor: Shield
50082 - Armor: Feet
50081 - Armor: Waist
50009 - Armor: Wrist
50008 - Armor: Raid Tier VI
50007 - Armor: Raid Tier V
50006 - Armor: Raid Tier IV
50005 - Armor: Raid Tier III
50004 - Armor: Raid Tier II
50003 - Armor: Raid Tier I
50002 - Armor: Dungeon III
50000 - Armor: Dungeon I
50001 - Armor: Dungeon II
50084 - Misc: Custom
60014 - Arena: Season III
60015 - Arena: Season III
60016 - Arena: Season III
60017 - Arena: Season IV
60018 - Arena: Season IV
60063 - Misc: Red Gemstone
60064 - Misc: Blue Gemstone
60065 - Misc: Yellow Gemstone
60066 - Misc: Purple Gemstone
60067 - Misc: Green Gemstone
60068 - Misc: Orange Gemstone
60069 - Misc: Meta/Prismatic Gemstone
60070 - Misc: Simple Gemstone

Help on add npc:
.npc spawn 'id'
example: .npc spawn 900000

Download link: WotLK Vendors
Filebeam - Free Fast File Hosting (http://filebeam.com/acb78891da453df3895c3fe2908acb65)

Download link :TBC Vendors
Filebeam - Free Fast File Hosting (http://filebeam.com/62b23532a7aa85927bdd72c5889c3cd4)


Credits:
Paris15(Me)
http://www.ac-web.org/forum/releases/41185-release-paikproductions-real-tier-7-vendors.html

[fredrik555]

amazing!
gonna try it out now :D

Well i tried execute it but what do i have to do when it says:

insert into creature_proto values('50080','70','70','1741','200000000','20000 0000','50000000','1','130','2000',0,'450','1000',' 68','0','426','0','0','20000','0','0','0','0','0', '0','1.5','0.347','0','0',5000,'0','0','4','8','14 ','0','0','0','0','0','0','0')

/* SQL Error: Column count doesn't match value count at row 1 */

:S help :S

[paris15]

Check you are arcemu revision it work with the latest.
Make sure you are using arcemu of course

[XxbryanxX]

Dude +rep!!!! so much bro ive been lokking for these xD

[fredrik555]

Check you are arcemu revision it work with the latest.
Make sure you are using arcemu of course

Im using Arcemu as always :P
And how do i see if im using the latest one?
And if i dont have it, how do i update it?

Sry im kinda new on the DB :(

[paris15]

Just add me on msn godofwow@live.com i will help you

[fredrik555]

everything works fine now... THIS IS THE BEST REPACK EVER

[PaikProductions]

Np for wotlk vendors :D

[zeal_aiz]

U maybe not noob but u stealing others ppl work without even credit them.:(

I already take a look at ur sql query for TBC. Exactly 100% same with mine which release 3 month ago. U juz deleting creature_spawn query and some vendor query. So there is no Misc: Custom vendor as u said since u already delete it.

Meanwhile WotLK vendor was made by PaikProduction.

So what do u really actually do to deserve credit? At least if u want to take credit, at least must do something new not juz delete some query and then said it was your.

Mine release was release 3 month ago for 2.4.3 WoW TBC client.
http://www.ac-web.org/forum/releases/33298-release-gm-island-full-spawn-vendor-trainer-etc.html
But right now I'm not going to release a new one since WotLK emu database structure frequently change.

Sad how this forum becoming:( Ppl stealing other work stealing other repack. U should think all hardwork that person made. I take 1 month to do this mall. But stealing juz take 1 min.

[$hadow]

1 Q real Tier 7 or fake ?

[PaikProductions]

Its the real T7 :D

[borzakro]

well... i tried to execute them and it says : SQL Error : Column count doesn't match value count at raw 1. what can i do ?

[dondon]

Can someone link a arcemu revision that works with this vendors?

I have tested arround 10 repacks and allways the same problem:

/* SQL Error: Column count doesn't match value count at row 1 */

I have done everything do get it works, but nothing works.
Gah, please, help me!

[iOwn]

workd for me. ty

[Scopiaboy12]

Thanks Dude! this is awesome they work perfect

dondon go to this Url YouTube - How To Make a 3.1.3 WoW WoTLK Arcemu Private Server! With Tier8! (EASY&FAST) (http://www.youtube.com/watch?v=sXJvLVduKjs&feature=channel_page) this is what i use its for 3.1.3 and it works for me

[labancsanyi]

Ahh it doesen't work for me :( i don't know why .... but +rep anyway :D

Column count doesn't match value count at raw 1. for me 2 :S