Codes for creating own vendor place, and taking away the arena points costs[Guide]

[chanceless]

Hello!
I've been creating my own vendor place and it is very irriating to go around and find all npcs IDs. I made a list wich I will now share
Mount vendors:
Troll trainer: 7953 Mount vendor: 7952
Orc trainer: 4752 Mount vendor: 3362
UD trainer: 4773 Mount vendor: 4731
Tauren trainer: 3690 Mount vendor: 3685

Class Trainers:
(these are from the cities/races that i prefered, if you want another race you'll have to find them yourself :P)
Paladin: 16681
Hunter: 3352
Mage: 4566 Portal Trainer: 2492
Lock: 4563 Demon trainer: 5753
Rogue: 4584
Warrior: 4593
Priest: 4606
(for some reason, u can't respecc at some trainers...)

Weapon masters:
Orc: 11868
Troll: 2704
UD: 11870
Blood Elf: 16621
Tauren: 11869

Vendors:
(only for Chrispee's DB, if you don't have Chirspee's DB it probably won't work)
Weapons 100+: 50020
Necklace: 50021
Rings: 50021
Trinkets: 50023
Bag/Container: 50040(if it doesn't work try 50090)
Gemstone 1: 50041
Currency: 50050 (and t4 t5 t6 tokens)
Wrist: 50009
Waist: 50010
Feet: 50011
Glad Merciless: 50033 (I will write later in this guide how to buy without arena points)
Glad Merciless Weapons: 50035
BG epics: 50034
Shield: 50024
Libram/Totem/Relic: 50029
Tier 4: 50006
Tier 5: 50007
Tier 6: 50008

How to make so that you don't need arena points to buy arena gear:
1. Go to your MySql
2. Open up your database and open the table "Items"
3. Go to the second last page
4. Scroll to the left end
5. Under "ItemExtendedCost" everything should be "0" all arena stuff is at a higher number, change them to "0"
6. Do the same thing at the last page
7. Try it out, if it can't buy a certain item; go to your Items table, find the item and change it's "ItemExtendedCost" to 0
8. Everything should work

Just some funny extras:
Thrall: 4949 Orc "Royal" Guard: 14304
Sylvanas: 10181 UD "Royal" Guard: 13839
Varimathas: 2425

Portals (not 100% sure):
(try if they work, if not I will take it away)
SW: 3561
IF: 3562
UC: 3563
Darnassus: 3565
TB: 3566
ORG: 3567

I really hope this will help you make an own vendor place.
All credits goes to me/mmowned.
Tell me if something doesn't work please!
Didn't find anything similar to this on the page :P!
See You!

[anything]

very nice stuff put together here...thx dude
PS: am I the first one to post ? =)

[lehtea]

thx mate +rep

[The_Demon]

what's the commands for adding the vendors and portals ?^^

[The_Demon]

Nvm ... do you have vendors id for Ascent ?

[ddinek]

whyts the command for add vendors ?

[chanceless]

its the same for ascent i think. .npc spawn (ID) 1 <-- Remember the "1"
Or .gobject spawn (ID) 1 <-- remember the "1"

[Mythers]

Yea really nice