[SQL] MaNGOSZero 1.12 Mall Vendors

[Valmere]

Updated to version R5! Change log at the bottom of the post.

Information:

There's a few 1.12 servers out there with instant level 60 realms that port you into the main city upon creating a new character. Once there, you're standing in front of a couple of vendors with pre-selected gear for you to purchase to gear up your new toon.

What I've done here is create 35 new NPCs, (ID 20001-20036), each named according to what they do. You can of course change them at your own will :P. Each vendor contains Rare quality gear with item levels between 50 and 63, which covers just about all the pre-raiding blues (including dungeon tier gear). In version R4 I've also added a Master Weapon Skills trainer. His ID is 20025, and can teach all weapon skills for free, which eliminates having to run around to all the major cities. If you'd like to set a training price, just edit the npc_trainer section in the file creature_template.sql before importing. In R5 I've added Profession Trainers for each profession that can train you from 1-300, again without having to run around finding all the different trainers.

In the download you'll find 3 .sql files:

creature_template.sql
Contains the main portion of this download. All 25 customized vendors and the Weapon Skill trainer.
items_RemovePrices.sql
Sets the Buy Price of the items on the vendors to 0 and Sell Price to 1 copper - Recommended for servers with instant level 60's.
items_RestoreOldPrices.sql
A full restoration file for the items sold by the vendors. Importing this will restore the items to their original state if you decide to switch back.

Download:

You can download it here: 1.12_Vendors_R5.rar

Installing:

Notice for installing R5: The first 3 lines of creature_template.sql are DELETE queries. They will remove any current entries that are currently in your database that I use for these NPCs. Make sure before importing that none of these will overwrite any other custom things in your DB! If you're upgrading from a previous version, ignore this.



Simply import creature_template.sql into your database and then restart your server. Find a good place to make a mall at, and then type:

.npc add #NPCid

Like I said earlier, the ID's for the NPC's are by default 20001-20036. If you're already using those numbers for your own database, you should probably change these before importing them.

Optionally you can also import the items_RemovePrices.sql to make all of the items available to fresh level 60's right from the start. This is useful for instant level 60 realms that don't want to give their players any starting gold. To restore the original prices, import items_RestoreOldPrices.sql.



NPC ID's:[spoiler]
20001 - Vendor 1 - Helms
20002 - Vendor 2 - Necklaces
20003 - Vendor 3 - Shoulders
20004 - Vendor 4 - Cloaks
20005 - Vendor 5 - Chests 1
20006 - Vendor 6 - Chests 2
20007 - Vendor 7 Bracers
20008 - Vendor 8 - Gloves
20009 - Vendor 9 - Gloves 2
20010 - Vendor 10 - Belts
20011 - Vendor 11 - Leggings
20012 - Vendor 12 - Leggings 2
20013 - Vendor 13 - Boots
20014 - Vendor 14 - Boots 2
20015 - Vendor 15 - Rings
20016 - Vendor 16 - Trinkets
20017 - Vendor 17 - Weapons - Main Hand
20018 - Vendor 18 - Weapons - Offhand
20019 - Vendor 19 - Weapons - One Handed
20020 - Vendor 20 - Weapons - Two Handed
20021 - Vendor 21 - Weapons - Two Handed 2
20022 - Vendor 22 - Shields
20023 - Vendor 23 - Weapons - Ranged
20024 - Vendor 24 - Bags and Misc
20025 - Khan'Zee - Weapons Master Trainer
20026 - Vendor 25 - Mounts
20027 - Trainer 1 - First Aid Master Trainer
20028 - Trainer 2 - Alchemy Master Trainer
20029 - Trainer 3 - Herbalism Master Trainer
20030 - Trainer 4 - Cooking Master Trainer
20031 - Trainer 5 - Tailoring Master Trainer
20032 - Trainer 6 - Engineering Master Trainer
20033 - Trainer 7 - Enchanting Master Trainer
20034 - Trainer 8 - Fishing Master Trainer
20035 - Trainer 9 - Skinning Master Trainer
20036 - Trainer 10 - Blacksmithing Master Trainer
[/spoiler]

Here's an old screeny of the vendors spawned on GM Island: (Note: This does not automatically spawn ANY of the included NPCs anywhere. All this does is add them to the database. You are free to choose where you want to place them.



Version Log:[spoiler]
R1 - Initial release
R2 - Added remove & restore prices
R3 - creature_template bugfix - vendors no longer wander around, I thought I had fixed it already ?? w/e fixed now.
R4 - Condensed npc_vendor and creature_template into 1 file. Added Weapon Master (ID#20025) and Mount Vendor (ID#20026)
R5 - Added Profession Trainers. NPC ID's are 20027 to 20036.
[/spoiler]



Feedback and bug reports are always appreciated

With the release of R5, I don't plan on adding much more or updating since this doesn't seem to be all that popular. R5 still has plenty of quality starter NPCs for anyone that wants to make a 1.12.1 server.

[Fumi]

I've never played 1.12 but it looks good

+rep

and i like how you used "Diffrent npc displays" than other (i see many servers with lich king vendors -.-)

[Valmere]

I've never played 1.12 but it looks good and i like how you used "Diffrent npc displays" than other (i see many servers with lich king vendors -.-)

Classic servers have a great nostalgia factor. I also noticed people always using LK as a vendor for their malls, but thankfully his model isn't in the vanilla client

Also, updated to version R2. Added 2 new sql files, you can remove the vendor prices from the items and then restore them at a later date if you want to.(Good for instant-60 realms)

[Unimatrix_001]

cool! +rep

[Valmere]

Updated to R4. Now includes a mount vendor and Master Weapons Trainer.

[Valmere]

Thread updated, R5 added. As I said in the OP, this doesn't seem to be all that popular and there's really not much else I can add aside from more gear vendors. Ah well, back to 3.3.5a stuff

[Ithir]

Just the epic items vendors left! Would be really nice if you added those aswell, in seperate vendors of course!


great work by the way!

[DragonfireEX402]

I keep getting this error, "#1054 - Unknown column 'unit_class' in 'field list'". Why am I getting this error, please reply.

[Valmere]

This is for a 1.12.1 mangos database.

[pimp1]

I got this working on a mangos zero repack but i cant get it to work on a 1.12.1 repack named arathi


this is the error i get [err] 1054 - unknown column "killcredit1" in "field list"

any one know why this is happening?

and also the arathi repack i use provides a website for registration could it be possible to take the mangos zero stuff in to the arathi that is mangos? just to keep the website thingy etc`?

[Zazi529]

Yes, you can get the website to work with the current repack the Vendors work with.

- What's the core for both servers?

- Also give me the names of them too.


-ZaZi