Welcome to my first tutorial
I will teach you hwo you can create your own vendors here.
Open Notepad and isert the text.
Code:
INSERT INTO `creature_names` (`entry`,`name`,`subname`,`info_str`,`type`,`spell dataid`,`male_displayid`,`female_displayid`,`civil ian`,`leader`) VALUES ('<Your vendors id>',"<Your Vendors Name>",'','<your vendors guild name>','10','0','<your vendor's display id>','0','0','0')
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealt h`,`maxhealth`,`scale`,`npcflags`,`respawntime`,`c ombat_reach`,`bounding_radius`,`auras`,`invisibili ty_type`,`death_state`,`walk_speed`,`run_speed`,`f ly_speed`) VALUES ('<again your vendors display id>','80','80','35','5000000','5000000','1','128','1' ,'1','1','','0','0','0','0','0')
Edit everything in red to the numbers you want.
ok just leave the rest how it is
now to add some items:
Code
INSERT INTO vendors(entry, item, amount) VALUES(<your vendors id>,<the item that you want to sell>, 1)
Ok, you can add multiple of these things to let the vendor sell multiple things.
When you are done save the file as an .sql file.
Then go to your database and import your file to your database.
Login to your account and spawn the vendor
Good job, if you followed everything you made your own vendor
Questions?
Feel free to ask =)
I will teach you hwo you can create your own vendors here.
Open Notepad and isert the text.
Code:
INSERT INTO `creature_names` (`entry`,`name`,`subname`,`info_str`,`type`,`spell dataid`,`male_displayid`,`female_displayid`,`civil ian`,`leader`) VALUES ('<Your vendors id>',"<Your Vendors Name>",'','<your vendors guild name>','10','0','<your vendor's display id>','0','0','0')
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealt h`,`maxhealth`,`scale`,`npcflags`,`respawntime`,`c ombat_reach`,`bounding_radius`,`auras`,`invisibili ty_type`,`death_state`,`walk_speed`,`run_speed`,`f ly_speed`) VALUES ('<again your vendors display id>','80','80','35','5000000','5000000','1','128','1' ,'1','1','','0','0','0','0','0')
Edit everything in red to the numbers you want.
ok just leave the rest how it is
now to add some items:
Code
INSERT INTO vendors(entry, item, amount) VALUES(<your vendors id>,<the item that you want to sell>, 1)
Ok, you can add multiple of these things to let the vendor sell multiple things.
When you are done save the file as an .sql file.
Then go to your database and import your file to your database.
Login to your account and spawn the vendor
Good job, if you followed everything you made your own vendor
Questions?
Feel free to ask =)