Thread: Mangos 3.1.3 Epic Vendors

CREDITS: Althaeus

I wrote a few scripts a few days back to autogenerate the SQL to create a bunch of epic vendors... It dynamically uses [Only registered and activated users can see links. ] database to generate them. It works with the latest Mangos core (as of this morning) and UDB.

You can download the file here:
[Only registered and activated users can see links. ]

Here is the list of vendors that it creates:

900007 - T8 Cloth armor
900008 - T8 Leather armor
900009 - T8 Mail armor
900010 - T8 Plate armor
900011 - T8.5 Cloth armor
900012 - T8.5 Leather armor
900013 - T8.5 Mail armor
900014 - T8.5 Plate armor
900015 - 226+ Axe Weapons
900016 - 226+ Bow Weapons
900017 - 226+ Crossbow Weapons
900018 - 226+ Dagger Weapons
900019 - 226+ Fist+Weapon Weapons
900020 - 226+ Gun Weapons
900021 - 226+ Mace Weapons
900022 - 226+ Polearm Weapons
900023 - 226+ Staff Weapons
900024 - 226+ Sword Weapons
900025 - 226+ Thrown Weapons
900026 - 226+ Wand Weapons
900028 - 226+ Back armor
900029 - 226+ Chest armor
900030 - 226+ Feet armor
900031 - 226+ Finger armor
900032 - 226+ Hands armor
900033 - 226+ Head armor
900034 - 226+ Held+In+Off-hand armor
900035 - 226+ Legs armor
900036 - 226+ Neck armor
900037 - 226+ Off+Hand armor
900038 - 226+ Shirt armor
900039 - 226+ Shoulder armor
900040 - 226+ Tabard armor
900041 - 226+ Trinket armor
900042 - 226+ Waist armor
900043 - 226+ Wrist armor
900045 - Blue gems
900046 - Meta gems
900047 - Red gems
900048 - Yellow gems
900049 - 226+ shields
900050 - Mage glyphs
900051 - Hunter glyphs
900052 - Paladin glyphs
900053 - Death glyphs
900054 - Shaman glyphs
900055 - Priest glyphs
900056 - Druid glyphs
900057 - Warlock glyphs
900058 - totems
900059 - sigils
900060 - librams
900061 - idols

In the download zip is also a second sql file to autospawn these vendors on gmisland.

Let me know how it works for you

Althaeus

I`m using mangos Revision 8169. and UDB 8158 (latest at the moment)
I did add mangos.sql on mangos db.. But I didn`t see any vendor in the world..
what I miss??
Thanks for helps..

Originally Posted by tip_1

I`m using mangos Revision 8169. and UDB 8158 (latest at the moment)
I did add mangos.sql on mangos db.. But I didn`t see any vendor in the world..
what I miss??
Thanks for helps..

Log into your server as GM and type:

.addspw id-number

Example:

.addspw 900007

That's all !

Then I imported mangos.sql and mangos-spawn.sql on mangos DB, All off vendors spawned on GmIsland.. Very Good Job.. Thanks again..

From the README: "These vendors are created dynamically from the thottbot.com website. So if some of them don't exist on your server yet, its just because you don't have the latest retail items yet.

Load combined.sql to your mangos database.

The list.sorted combines the ids of the epic vendors for you to spawn with
.npc add or load the gm-spawn.sql to your mangos database to spawn them all on GM Island.

server restart to make the changes effective.

Note:
Each time you load combined.sql it will despawn any of the vendor npcs you had previously spawned from this pack."



Where do i get the combined.sql and the gm-spawn.sql ? They are not in the download.

Originally Posted by imkrazy182

From the README: "These vendors are created dynamically from the thottbot.com website. So if some of them don't exist on your server yet, its just because you don't have the latest retail items yet.

Load combined.sql to your mangos database.

The list.sorted combines the ids of the epic vendors for you to spawn with
.npc add or load the gm-spawn.sql to your mangos database to spawn them all on GM Island.

server restart to make the changes effective.

Note:
Each time you load combined.sql it will despawn any of the vendor npcs you had previously spawned from this pack."



Where do i get the combined.sql and the gm-spawn.sql ? They are not in the download.

If you have mangos emu import into your mysql: mangos-spawn.sql

You can compile mangos and get latest udb.
In ulduar there is no vehicles working and i dont think that boss fight with flame leviathan will be working soon so you will need to wait.

thanks alot

link does not work help pls.