Dimman
28-05-10, 02:47 PM
Dimman's "How to create a vendor for TC2 tutorial".
1: Open up a new text document with Notepad/wordpad/word. etc
2: Paste the following template in
INSERT INTO creature_template VALUES ('NPCENTRY', '0', '0', '0', '0', '0', 'DISPLAYID', '0', '0', '0', 'NAME', 'SUBNAME', '', '0', '60', '60', '0', '35', '35', '128', '1', '1.4286', '1', '0', '100', '100', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '', '0');
NPCENTRY= Npc id, the number you are going to use when your going to spawn the npc.
DISPLAYID= The model of the npc. (You can find display ids \here/ (http://wow-v.com/displayid-finder-mobs.php) credits: wow-v)
Ex: Stormwind guard display id = 3167
NAME= The npc/vendors name.
SUBNAME= The subname of the npc/vendor (will be below the name (guildname on characters)
3: use the "save as" feautere in your text editor and save it as:
FILENAME.sql
Save as type: All files
4: Execute the sql into the "world" database.
5: Make a copy of the SQL file you just made and delete all the text inside and replace it with:
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);ITEMID = Item you want the vendor to sell (ID) check wowhead.
NPCENTRY = The ID of the NPC you created before.
1: Open up a new text document with Notepad/wordpad/word. etc
2: Paste the following template in
INSERT INTO creature_template VALUES ('NPCENTRY', '0', '0', '0', '0', '0', 'DISPLAYID', '0', '0', '0', 'NAME', 'SUBNAME', '', '0', '60', '60', '0', '35', '35', '128', '1', '1.4286', '1', '0', '100', '100', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '', '0');
NPCENTRY= Npc id, the number you are going to use when your going to spawn the npc.
DISPLAYID= The model of the npc. (You can find display ids \here/ (http://wow-v.com/displayid-finder-mobs.php) credits: wow-v)
Ex: Stormwind guard display id = 3167
NAME= The npc/vendors name.
SUBNAME= The subname of the npc/vendor (will be below the name (guildname on characters)
3: use the "save as" feautere in your text editor and save it as:
FILENAME.sql
Save as type: All files
4: Execute the sql into the "world" database.
5: Make a copy of the SQL file you just made and delete all the text inside and replace it with:
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);
INSERT INTO npc_vendor VALUES ('NPCENTRY','0','ITEMID',0,'0',0);ITEMID = Item you want the vendor to sell (ID) check wowhead.
NPCENTRY = The ID of the NPC you created before.