[Release] Vendors, for those who dont have them

[XC4T4LY5TX]

I Dont know About you guys, but everytime i start with a Blank DB id like to Have vendors, but can never find them!.
Ive searched these forums for them, but never find the full release im lookin for. so i found these. Credits go to original Poster on GAMERZplanet.net
Wotlk Vendors Included

- Compatibility with ArcEmu rev 1913 or latest. Now also support AspireCore HS branch rev 670 or latest!!
- Easy to install include Readme
- Add install and remove feature
- Can be execute many time
- Thousand of cleanup
- Thousand of addition
- Thousand of fix and editing
- Clean sql base make it easier for editing and adding item in future
- WotLK items thx to PaikProductions
- Contain 94 mall vendor which sell 8000+ TBC & WOTLK items
- Mall Vendor List:

ID           NPC Vendor
50000      Armor:Dungeon I -TBC-
50001      Armor:Dungeon II  -TBC-
50002      Armor:Dungeon III -TBC-
50003      Armor:Raid Tier I -TBC-
50004 Armor:Raid Tier II -TBC-
50005 Armor:Raid Tier III -TBC-
50006      Armor:Raid Tier IV -TBC-
50007      Armor:Raid Tier V -TBC-
50008      Armor:Raid Tier VI -TBC-
50009      Armor:Raid Tier VII -WOTLK- 
50010      Armor:Raid Tier VII -WOTLK-
50011      Armor:Wrist -TBC- -WOTLK-
50012      Armor:Necklace -TBC- -WOTLK-
50013      Armor:Rings -TBC- -WOTLK-
50014      Armor:Trinket -TBC- -WOTLK-
50015      Armor:Cloak -TBC- -WOTLK-
50016      Armor:Shirt -TBC- -WOTLK-
50017      Armor:Tabard -TBC- -WOTLK-
50018      Armor:Miscellaneous -TBC- -WOTLK-
50019      Armor:Off-Hands/Relic -TBC- -WOTLK-
50020      Armor:Libram/Idol/Totem -TBC-
50021      Armor:Waist -TBC- -WOTLK-
50022      Armor:Feet -TBC- -WOTLK-
50023      Armor:Shield -TBC- -WOTLK-
50024      Weapon:Level 50+ -TBC-
50025      Weapon:Level 60+ -TBC-
50026      Weapon:Level 65+ -TBC-
50027      Weapon:Level 75+ -TBC-
50028      Weapon:Level 100+ -TBC-
50029      Weapon:Level 200+ -WOTLK-
50030      Arena:Season I -TBC-
50031      Arena:Season I -TBC-
50032      Arena:Season I -TBC-
50033      Arena:Season II -TBC-
50034      Arena:Season II -TBC-
50035      Arena:Season II -TBC-
50036      Arena:Season III -TBC-
50037      Arena:Season III -TBC-
50038      Arena:Season III -TBC-
50039      Arena:Season IV -TBC-
50040      Arena:Season IV -TBC-
50041      Arena:Season V -WOTLK-
50042      Gem:Red Gemstone -TBC-
50043      Gem:Blue Gemstone -TBC-
50044      Gem:Yellow Gemstone -TBC-
50045      Gem:Purple Gemstone -TBC-
50046      Gem:Green Gemstone -TBC-
50047      Gem:Orange Gemstone -TBC-
50048      Gem:Meta/Prismatic Gemstone -TBC-
50049      Gem:Simple Gemstone -TBC-
50050      Recipe:Book A-Z -TBC- -WOTLK-
50051      Recipe:Leather A-F -TBC- -WOTLK-
50052      Recipe:Leather G-R -TBC- -WOTLK-
50053      Recipe:Leather S-Z -TBC- -WOTLK-
50054      Recipe:Tailor A-G -TBC- -WOTLK-
50055      Recipe:Tailor H-Z -TBC- -WOTLK-
50056      Recipe:Engineer A-Z -TBC- -WOTLK-
50057      Recipe:Blacksmith A-F -TBC- -WOTLK-
50058      Recipe:Blacksmith G-R -TBC- -WOTLK-
50059      Recipe:Blacksmith S-Z -TBC- -WOTLK-
50060      Recipe:Cooking A-Z -TBC- -WOTLK-
50061      Recipe:Alchemy A-Z -TBC- -WOTLK-
50062      Recipe:Enchant A-G -TBC- -WOTLK-
50063      Recipe:Enchant H-Z -TBC- -WOTLK-
50064      Recipe:Jeweler A-K -TBC- -WOTLK-
50065      Recipe:Jeweler L-Z -TBC- -WOTLK-
50066      Reagent:Leather I -TBC- -WOTLK-
50067      Reagent:Leather II -TBC- -WOTLK-
50068      Reagent:Tailor I -TBC- -WOTLK-
50069      Reagent:Tailor II -TBC- -WOTLK-
50070      Reagent:Engineer I -TBC- -WOTLK-
50071      Reagent:Engineer II -TBC- -WOTLK-
50072      Reagent:Blacksmith I -TBC- -WOTLK-
50073      Reagent:Blacksmith II -TBC- -WOTLK-
50074      Reagent:Cooking -TBC- -WOTLK-
50075      Reagent:Alchemy -TBC- -WOTLK-
50076      Reagent:Enchant -TBC- -WOTLK-
50077      Reagent:Jeweler -TBC- -WOTLK-
50078      Reagent:Inscription/Miscellaneous -TBC- -WOTLK-
50079      Misc:Potion/Flask/Elixir -TBC-
50080      Misc:Scrolls -TBC-
50081      Misc:Books/Tomes/Codex -TBC-
50082      Misc:Projectile/Quiver -TBC- -WOTLK-
50083      Misc:Container -TBC- -WOTLK-
50084      Misc:Enchantment -TBC- -WOTLK-
50085      Misc:Key -TBC-
50086      Misc:Currency -TBC-
50087      Misc:Mount I -TBC-
50088      Misc:Mount II -TBC-
50089      Misc:Mount III -TBC-
50090      Misc:Glyph I -WOTLK-
50091      Misc:Glyph II -WOTLK-
50092      Misc:Heirloom -WOTLK-
50093      Misc:General Goods -WOTLK-
50094      Misc:Custom -TBC- -WOTLK-

Update:

 UPDATE `vendors` SET `entry` = 80013 WHERE (`entry` = 50013);

THX TO MIRCAST

Full GMI Mall Vendor v4.0 ArcEmu
http://filebeam.com/34f4b213dfb888e798a7144599c2235d
Full GMI Mall Vendor v4.0 AspireCore
http://filebeam.com/0f06443ea8fabb49d5f92c6ec21afaea

PASSWORD: zeal


Any Questions, PM me, or leave a comment. Ill Keep you updated on the latest releases ;D


Update 4/23/09: Fixed SQL Syntax error. Thx to scyther.

 http://filebeam.com/607985f949720262b1a382b43dc3e898

[tylert40]

thanks for reuploading! Saved me time so ill + rep u

[y2kss66]

very nice +RepX2 for you! saving me some work!

[Mircast]

I can never find TBC vendors anymore, so thanks for sharing.

+rep

[fendas]

thank you

[deathomen]

I seem to be having a problem with these vendors. Sometimes when I spawn a vendor, it won't let me buy anything from it, but when I delete it and respawn it it generally fixes the problem.

Also, vendor 50010 is bugged. When it is spawned, the vendor has a blue glow and swims away in the air for about 40 yards and then despawns.

Anyone have an idea how I can fix these two problems?

~death~

[enegue]

I got the same problem as well.

[Ickybad]

Here I updated the query so it can work on latest arcemu and not have syntax errors or to many columns .

Filebeam - Free Fast File Hosting

[God-Of-War]

I seem to be having a problem with these vendors. Sometimes when I spawn a vendor, it won't let me buy anything from it, but when I delete it and respawn it it generally fixes the problem.

Also, vendor 50010 is bugged. When it is spawned, the vendor has a blue glow and swims away in the air for about 40 yards and then despawns.

Anyone have an idea how I can fix these two problems?

~death~

i have the same problem.. Any solution?

[deathomen]

i have the same problem.. Any solution?

Not as of yet, but the issue with not being able to speak to a vendor sometimes is happening with a few of my own custom vendors, so I'm going to ask over on Arcemu forums and let you know here what I find out.

As for the bugged vendor 50010, I still have no idea what the problem is.

~death~

[mungham1234]

Ok i just made my server and i have no idea where to put this code(i have NO idea how to edit .lua either so iam a COMPLETE N33B(i have ArcEmu(Johved Repack if it helps)
pls tell me where to put this code

[deathomen]

Import the .sql file into your database via Navicat or some similar DB editing program. Then open the .lua with Notepad or Wordpad and edit it like that, then save it in your \arcemu\scripts folder when you're finished

~death~

[mungham1234]

Thank you
oh and 1 more Question
when i spawn a vendor then i say shutdown the server becuase i added sumthing to the DB...when i log back in the vendor is gone
so how do i save it so its always there?

[Coffzor]

Why 50010 is bugged is cuz 50010 is the id of the shappiron trigger breath, the script makes the shick to do a frostbreath then fly away, its the script from shapphiron pre TBC, try do either edit the sun++/moon++ or some of the luas,

[Contox]

Why 50010 is bugged is cuz 50010 is the id of the shappiron trigger breath, the script makes the shick to do a frostbreath then fly away, its the script from shapphiron pre TBC, try do either edit the sun++/moon++ or some of the luas,

Why not just edit the npc spawn id?. That would be twice as simple :P