How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think)
Posted by Flambé on 24 January, 2008
I can see this is my most viewed post on my site so I Will be updating it as soon as I’ve got my compiled MaNGOS stable and released it. I may comlpetely remake the guide for my compiled MaNGOS and rerelease it when it’s ready.
This will be remade in the new year.
—PICTURES COMING SOON—
FULL CREDIT to Alpha136000 who made this guide
Have you got some custom items or vendors or something else that you want to put onto your private server? Well, here’s how:
Requirements:
World of Warcraft… dur
WORKING reaper mangos server
the .sql file of your custom item
Instructions:
1. Open up navicat and click trial if the option comes up
2. Click on Connection (below File) and enter in
root
for the username and the password is what you chose when configuring MySQL (also make sure that its the same port as when configuring MySQL) and click OK
3. On the left hand side of navicat your connection should come up. (If you can’t see mangos their, right click the one you see and click Open Connection.) Then right click mangos and click Open Database.
4. Right click mangos again and click Execute Batch File and then the … to the right of the blank box.
5. Find where you saved the .sql file and open it
6. Click start and it should finish almost instantly.
7. IMPORTANT: If it says unsuccessful your custom whatever it is WON’T be in-game. If you got sent the file via email or IM or something similar, it most likely WON’T work. If it doesn’t contact the person that sent you it and ask them to copy EVERYTHING in the .sql file on their computer and paste it into an email or IM and then you should copy it all over to the .sql file on your computer and replace EVERYTHING and save it. Redo steps 3-6 and it should work.
WoW-V
Go to wow-v.com if you want to createm custom items, vendors, armour, bags and jelwery!
Official site of Steveya 
sprite said
MaNGOS database Editor
Features
Quest Editor, Creature Editor, GameObject Editor, Item Editor, And some small features
http://quice.indomit.ru/
easy and fast …. even a newby will learn how to make those things 😛 …
the things y wanted to ask u is if how do u edit spells? .. and don`t tell me with navicat or sql tool cause heck it`s damn booring :))
steveya said
#sprite
Thanks for the link, I’ll add it onto the post. I don’t know how to edit spells :(, if you ask Reaper-x via email or comment on his site he’ll probaly say navicat or something. So sorry …
Steve
sprite said
man thank`s … y emailed reapear a long time ago .. didn`t answear my emails so y droped it 😛 …. and yes y know how to edit some of the spells there .. y mean teleport spells … but onestly it gives me a very big headake when y see on the spells only numners and numners and more numbers and nothing to give me at least a clue 😛
steveya said
#sprite
yeh, sometimes reaper-x doesnt reply to the emails you send him, other times he does 😛 … numbers and numbers… so confusing… lol 😛
Steve
Alpha136000 said
Hey i was the one who teached u this =) lol xD BTW to be more specific get navicat lite
steveya said
#Alpha136000
Ok, I’ll put full credit to you now and get them to download navicat lite 😛 lol
Steve
Alpha136000 said
note: dont make your item to big like 999999 dmg or your server cant handle it and your item templates will get errors
Alpha136000 said
sprite#
Dont even think abt editing spells lol. If it goes loading spells on mangosd.exe or somthing it will come up with error.
dom said
im having difficulty just geting the server up onto navicat…im useless can some one explain that bit in more detail .
sprite said
use sqllite
Avo said
Hey, i got all this good and clean but, when im executing batch file it always is unsucsessful, what do i use for encoding?
steveya said
#Avo
open up the .sql file with notepad or something and make sure theirs no paragraphs, e.g its not all connected together. Make sure it is and then retry execucting the batch file.
Jonboy said
I am running Mangos 5225 and it would seem to work with http://www.wow-v.com eather.
Jonboy said
Correction
I am running Mangos 5225 and it wouldn’t seem to work with http://www.wow-v.com eather.Steveya do you mean its good to have paragraphs or not?
steveya said
#Jonboy
its not good to have paragraphs
Jonboy said
TY
steveya said
np
sprite said
stop using the websites to make custom weapons .. u get a extra table in the sql and eventualy it will crash … use quince for making custom stuff
steveya said
#sprite
you learn something new every day,
BTW everyone reading this, i may be compiling my own MaNGOS soon when i reinstall WoW, if i need to reinstall it so stay here for more info…
JimiF said
#sprite
wow-v.com adds to item_template, which iirc, already exists. Personally I use quince, but I can see why some people would prefer the website.
Remar said
where do I find this Quince and is it compatible with 2.4.2 ? I found editors that do work with the latest patch, but the all the sites want you to be a paying member.
Remar said
duh….lol…I found your link……sorry ’bout that. Oh and its called Quice…..lol
steveya said
#Remar
no problem, just incase you haven’t noticed on their site, it doesn’t need you to even be a member or pay for it. It should be compatible i think becuase it runs with mysql not the mangos
james said
when you add a vendor a item like .vendoradditem id x
how do you make it so when someone buys the item it give’s
them like 5 insted of 1
pleace email me at panic3333@hotmail.com and tell me
robin said
How do i do that for ArcEmu ?
I have hamachi, ArcEmu, HeidiSql, and Navicat.. But i dont know how to do it.. I have my custom item as a Sql-script… where to put it ?
robinmoller6@hotmail.com
steveya said
#Robin and James
I replied to you both in your emails (James much earlier).
Steve.
Xspence said
Great way: Wow-v.com
its free, just have to make a quick account…
steveya said
I have mentioned that at the bottom of the post. Maybe not well enough though. I’ll change that now.
MinD said
well i have the same problem as “robin”
mindgw@yahoo.com
Flambé said
#MinD
I sent the answer to your email.
MinD said
ty v much
Flambé said
#MinD
No problem.
wow-killa said
i got a error : SQL Error: Duplicate entry ‘32830’ for key 1
Flambé said
#Wow-killa
Is the .sql file you are trying to impliment in a “working order”?
niceo said
look i add i file in my vendor with .npc vendoradditem 1 . and when i shutdown my serv and open it again the item is gone..?
Flambé said
There is a command to save the world as it is I believe. This should save the item in the vendor as well.
I’ll see if I can find the command.
Flambé said
Look at the post below for the answer.
lorht said
Found it? and i also wanna know how to make stuf unclickble like doors that its just for the show and not for the use? anyone know how to do that XD?
Flambé said
The only ones I can find are save and saveall. Try them.
And I think the door thing would mean editing the world itself which I don’t know how to do yet. The best I can suggest is spawning objects in front if it to stop people getting to it.
zekoy said
which command are it to get your custom vendor ingame? 😀 happy for answer
Flambé said
If I remember correctly, they should automatically appear if you follow the tutoiral correctly, though it may need updating 😛
JD said
Could someone plz! Tell me how to do this (add custom items) with out useing navicat or anyother program like it… Plz!!! I don’t have the internet besides a cell phone and my trial has ran out 4 navi so I think I’m screwd… Someone plz tell me otherwize… Ty.
Flambé said
So would you use navi if your trail hadn’t run out?
And I’ll see if I can find any other ways.
Thalor said
I heard you can create a unlinkable, unlookable, unaddable item unless you know the EntryID, would anyone mail me how to do.
Krchmarus said
Dudes, Quince is no longer to be found on net, so I guess it’s was a failure. WoW-V is the best.
Lazaro said
awesome issues here. I am very glad to peer your post. Thank you a lot and i’m looking forward to contact you. Will you please drop me a mail?
Ares said
Ok, so I keep getting a Statscount Error. Any idea how to fix it? And its not statcounter its statscount.
Flambé said
I haven’t tried this in a few years now and I don’t recognise that error. What were you doing at the time?
Ares said
Adding a weapon into the DB
wow mage pvp said
wow mage pvp…
[…]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…
submit url add site said
submit url add site…
[…]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…
PvP said
PvP…
[…]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…
world of warcraft fishing bot said
world of warcraft fishing bot…
[…]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…
Nike Free Sko Salg544 said
Nike Free Running Sko
Anonymous said
[…] india best electric shaver value best electric razor 2012 best electric razor for men review men's electric shaver reviews electric shaver reviews for women electric shaver reviews best electric shaver best […]
antivirus gratuito em portugues said
, as they provide protection from spam mails
by giving warning message as soon as you try to open an email
from the spam or junk mail box. It will also install Microsoft Visual
C++ 2008 redistributable software which means you’ll see new programs in the Add or Remove programs, if no other software has already installed the Visual C++ software. Experts always recommend the purchase of virus protection tool that provides free updates that are valid for a year.
watermelon salsa said
I’ve learned newer and more effective things out of your blog post. Also a thing to I have observed is that usually, FSBO sellers will certainly reject people. Remember, they can prefer to not use your products and services. But if a person maintain a comfortable, professional connection, offering help and keeping contact for about four to five weeks, you will usually have the ability to win a meeting. From there, a house listing follows. Thank you
short cheap party dresses said
Shop around for what you are interested in and while doing it
2 months in advance may seem early, it will give you
time to change your mind if the formal prom dresses are
no longer catching your eye. Price Stores Macy’s department store Bethany’s Bridal and Prom The greene The Dayton Daily News.
When color specialists look at the two colours over a set of ladies they found some fascinating results.
Candice said
I’ve learn a few good stuff here. Definitely value bookmarking for revisiting. I surprise how much attempt you place to make this type of fantastic informative website.
helpful resources said
helpful resources Looking For Furniture? Read Through This Initial
Determine when it’s the very best to buy specific home furniture. Just like the finest time for you to buy a new automobile is rumored to be Sept ., furniture is very likely to he said be located at the low price at specific times of the season. Discover what these are to acquire excellent deals. Examine the weld to make certain that no fragile versions can be found. When you have a variety of sections or receive furnishings that you simply dislike, take into consideration what can be done so it will be appearance much better. There are numerous methods to make household furniture into points that you prefer. You can include a deal with, use covers, stain it or find other methods to improve up a bit thus it gets to be your brand-new beloved. Check the condition of utilized furniture offered to you free of charge.You might dislike to acquire a sizeable piece of furniture because your friend no longer wishes it. You may wish to avoid spending money on new things, but a pre-owned a single might get far more effort than its really worth. Look at the preferences of your own loved ones believes when buying household furniture. They will need to live with this furniture for quite a while, too. Is someone you know about the not too distant future? Ask should they be getting all any furnishings. You might be able to get home furniture and reduce costs too. Discover when it’s the very
best to get distinct furniture. Just like the recommendation for getting a new car in September, various market activities can determine the ideal periods to purchase home furniture too.
Discover when these dates are to find the
best feasible discounts. Take a look at reselling retailers
in your town to get offers on furniture that is certainly
substantial-top quality. You will probably find a good variety of low-cost household furniture at
reduced price ranges. Try out your employed furniture prior to buying it.
You need to know that this furnishings holds up and doesn’t possess injury which you can’t
see by just checking out it. Flipping it more than will likely permit you to try to find labeling or producer represents that assist determine benefit.
Don’t be scared about receiving a low cost when home furniture purchasing. You could possibly get yourself a cheaper value. If they aren’t capable of giving you the price you want,
inquire if they may feature a complementing piece in the package.
They typically will often offer you additional features to help make a transaction.
When attempting to get a couch, find one built to very last.
Springs will support pillows greatest. Hand-tied up 8-way springs are
usually greatest, but serpentine models might be
good way too. Check springs by attempting to feel them by means of
any upholstery. Excellent springs are always firm and close up jointly.
Generally think about what your family’s view on purchasing furnishings. They are managing the furnishings as well, so their thoughts make a difference. Don’t get rid of top quality
eating seating even though their soft cushions are donned downward.
You can select the very same textile or try one thing
fully new. If your seats are top quality, place them. When you are searching for higher-end
wood home furniture, ensure that these are made from wood.
Numerous pieces are produced from wood products. You can observe this through the
grain about the bottoms of chairs and tables. While searching for excellent-good quality wooden household furniture, only purchase products composed of solid wood.
Many items are produced utilizing particle board and it doesn’t possess the reliability of solid wood. You can see this with the grain if you seem underneath the bottoms of tables and chairs. Leather furnishings might be a wonderful selection in lengthy-enduring home furniture. Leather ages nicely and also appears excellent. There are numerous kinds of leather material that boost their look as we age. This will make acquiring leather a wise fiscal decision. While you may see some duds, you might find some good sections. You just have to look at them for any tears or tears. Ensure you lift pillows and look for cabinet and entrance function. Sit down on couches and if you appreciate it. Always inspect the compartments on sections you are planning on buying. You will notice very clear warning signs of the development good quality of building. The storage should be an easy task to open and really should be even when you available or shut it. They are going to stay longer when they fit greater. Affordable furniture is not suit securely jointly and may bust significantly quicker. You know your financial budget, desired design and available choices, thus shop! When looking for home furniture you can find a a number of things to bear in mind. Utilize the strategies to help you when you are buying furniture. Give your furnishings sections a try ahead of buying it. Sit on a sofa that you are currently contemplating and ensured that it is easy to fully stand up once you are accomplished. You should also rest over a bed furniture to make sure it’s cozy ample
to create home. Investigate the choices at secondhand stores.
It may have been quite a while since your final pay a visit to,
or maybe you not have.You may get some superb pieces of furniture there.
You will probably locate smaller things, but occasionally they may have larger sized sections like couches that will
work for your needs. Are you mindful of the reality that furniture proceeds selling in the course
of diverse times of the vacations? Veterans Day and Memorial
Day are a number of wonderful holiday seasons which give their selves nicely
for home furniture store shopping. The brightest time for purchasing
new furnishings are close to Christmas time and July fourth.
Charges are lowered substantially and you may be marked straight down as much as seventy-5
percent with great funding possibilities at those times.
Usually appraise the space you’re about to get household furniture is going to be positioned. Whatever part and dimensions of furnishings you happen to be acquiring, it needs to be calculated in order to ensure it’s heading to match your space.
Guessing on the level of place you have can
easily develop into disaster. Very first
pick a range of prices and magnificence, then go shopping with assurance using these recommendations.
There are many standard points to be aware of when furniture purchasing.
You’ll be able to make the most efficient alternatives if you stick to what you’ve figured out in this article.
their explanation
expert comptable a paris said
In fact, you don’t need to enter all your expenses in detail. Like anything else, the best protection for accounting fraud and theft is prevention. Your business suffers from frequent inventory shortages for your high-demand products and inventory surpluses for your low-demand products.
kids clothing brands said
Howdy, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam comments?
If so how do you reduce it, any plugin or anything you can
recommend? I get so much lately it’s driving me insane so any assistance is very much appreciated.
buy a used car Online said
It’s very effortless to find out any topic on net as compared to textbooks, as I found this paragraph at this web page.
Parthenia E. Cardone said
I think this is one of the most important information for me.
And i am glad reading your article. But wanna remark on some general things, The
website style is wonderful, the articles is really great : D.
Good job, cheers
Hermina E. Platner said
Thanks for finally talking about >How to add WoW custom vendors and items ect.
(Reaper Mangos, any patch i think) « Official site of Steveya <Loved it!
Nubia G. Ellsbury said
Howdy! Do you use Twitter? I’d like to follow you if that would be
ok. I’m definitely enjoying your blog and look forward to
new updates.
Patria I. Ramo said
Excellent beat ! I wish to apprentice whilst you amend
your web site, how can i subscribe for a blog web site?
The account aided me a appropriate deal. I have been tiny bit acquainted
of this your broadcast provided bright clear concept
Jesenia H. Robair said
My brother suggested I might like this web site. He was entirely right.
This post actually made my day. You cann’t imagine simply how much
time I had spent for this info! Thanks!
Daine S. Okeefe said
Hi mates, its enormous piece of writing on the topic of teachingand entirely defined, keep it up all the time.
Wei L. Joeckel said
Hello Dear, are you really visiting this website daily,
if so afterward you will definitely obtain pleasant know-how.
Mamie S. Roussel said
I think the admin of this web page is really working hard for his site, for the reason that here
every stuff is quality based stuff.