Need Heirloom Vendor!!!

[thefallen1one]

Need a vendor for mangos with all the heirloom items, not just a few. Please help me out, I've been looking around and can't find any.

[The-Eradicator]

Is there a reason you can't make it yourself?

[thefallen1one]

I Work so much I just thought someone would like to help, I am fully capable of making it myself but i would have to do it over time. I'm in and out of my house constantly. Why is everyone on this site so mean? It's like you join it, and get flamed for asking for help...constantly.

[The-Eradicator]

I Work so much I just thought someone would like to help, I am fully capable of making it myself but i would have to do it over time. I'm in and out of my house constantly. Why is everyone on this site so mean? It's like you join it, and get flamed for asking for help...constantly.

I can't speak for everyone in the emulation section, but personally, i'm here to help people. I'm not here to do simple repetitive jobs for people, unless they're paying me.

This can be done purely with SQL queries in about 40 seconds if you know how, and even if you don't, you can manually add them to the vendor in-game in literally 5 minutes. It doesn't take hours.

Aside from that, running a server is tough stuff. When you run a server, you're committing huge amounts of time to the players of that server. Which ever way you spin it, you're getting into a lot of work.

I've spent hundreds of hours working on various servers. I've spent a lot of time answering questions in this section. I don't appreciate it when people come to this section willing to commit two hours to taking 30 other people's work and making a server out of it.

Understand that i'm not trying to offend you, and that these statements are generalized. You asked why people are mean (to these sorts of questions), and the answer is because a lot of us have had work used (stolen) on many servers without any credit given to the original authors.


I'll answer your next question pre-emptively. ("Why, Eradicator, how do I do this with an SQL query?")

I don't know the structure in MaNGOS, but this should work on TrinityCore (tested on the database, not tested in game).

INSERT INTO npc_vendor (entry, item)
SELECT creature_template.entry, item_template.entry
FROM creature_template, item_template
WHERE item_template.quality = 7 AND creature_template.entry = 12345;

Replace "12345" with your creature's entry ID.

If you change the names of the tables, this will probably work with MaNGOS as well.

If you're interested in how this query works, search for "SQL inner join"