Official site of Steveya

Everything about my gaming interests

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.


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:


World of Warcraft… dur

WORKING reaper mangos server

the .sql file of your custom item

navicat lite


1. Open up navicat and click trial if the option comes up

2. Click on Connection (below File) and enter in


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.


Go to if you want to createm custom items, vendors, armour, bags and jelwery!


71 Responses to “How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think)”

  1. sprite said

    MaNGOS database Editor

    Quest Editor, Creature Editor, GameObject Editor, Item Editor, And some small features

    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 :))

  2. steveya said


    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 …


  3. 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 😛

  4. steveya said


    yeh, sometimes reaper-x doesnt reply to the emails you send him, other times he does 😛 … numbers and numbers… so confusing… lol 😛


  5. Alpha136000 said

    Hey i was the one who teached u this =) lol xD BTW to be more specific get navicat lite

  6. steveya said


    Ok, I’ll put full credit to you now and get them to download navicat lite 😛 lol


  7. 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

  8. Alpha136000 said


    Dont even think abt editing spells lol. If it goes loading spells on mangosd.exe or somthing it will come up with error.

  9. dom said

    im having difficulty just geting the server up onto navicat…im useless can some one explain that bit in more detail .

  10. sprite said

    use sqllite

  11. 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?

  12. steveya said


    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.

  13. Jonboy said

    I am running Mangos 5225 and it would seem to work with eather.

  14. Jonboy said

    I am running Mangos 5225 and it wouldn’t seem to work with eather.Steveya do you mean its good to have paragraphs or not?

  15. steveya said


    its not good to have paragraphs

  16. Jonboy said


  17. steveya said


  18. 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

  19. steveya said


    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…

  20. JimiF said

    #sprite adds to item_template, which iirc, already exists. Personally I use quince, but I can see why some people would prefer the website.

  21. 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.

  22. Remar said

    duh….lol…I found your link……sorry ’bout that. Oh and its called Quice…

  23. steveya said


    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

  24. 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 and tell me

  25. 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 ?

  26. steveya said

    #Robin and James

    I replied to you both in your emails (James much earlier).


  27. Xspence said

    Great way:

    its free, just have to make a quick account…

  28. MinD said

    well i have the same problem as “robin”

  29. Flambé said


    I sent the answer to your email.

  30. MinD said

    ty v much

  31. Flambé said


    No problem.

  32. wow-killa said

    i got a error : SQL Error: Duplicate entry ‘32830’ for key 1

  33. Flambé said


    Is the .sql file you are trying to impliment in a “working order”?

  34. 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..?

  35. 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.

  36. zekoy said

    which command are it to get your custom vendor ingame? 😀 happy for answer

  37. 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.

  38. Thalor said

    I heard you can create a unlinkable, unlookable, unaddable item unless you know the EntryID, would anyone mail me how to do.

  39. 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.

  40. 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?

  41. Ares said

    Ok, so I keep getting a Statscount Error. Any idea how to fix it? And its not statcounter its statscount.

  42. wow mage pvp…

    […]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…

  43. submit url add site…

    […]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…

  44. PvP said


    […]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…

  45. world of warcraft fishing bot…

    […]How to add WoW custom vendors and items ect. (Reaper Mangos, any patch i think) « Official site of Steveya[…]…

  46. Nike Free Running Sko

  47. 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 […]

  48. , 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.

  49. 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

  50. 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.

  51. 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.

  52. 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

  53. 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.

  54. 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.

  55. It’s very effortless to find out any topic on net as compared to textbooks, as I found this paragraph at this web page.

  56. 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

  57. 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!

  58. 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.

  59. 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

  60. 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!

  61. Hi mates, its enormous piece of writing on the topic of teachingand entirely defined, keep it up all the time.

  62. Hello Dear, are you really visiting this website daily,
    if so afterward you will definitely obtain pleasant know-how.

  63. 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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: