Register for your free account! | Forgot your password?

Go Back   elitepvpers > World of Warcraft > WoW Private Server > WoW PServer Hosting
You last visited: Today at 16:55

  • Please register to post and access all features, it's quick, easy and FREE!


[Navicat Tutorial] Creating Vendors [English]

Old   #1
elite*gold: 0
Join Date: Jul 2010
Posts: 545
Received Thanks: 229
Smile [Navicat Tutorial] Creating Vendors [English]

Welcome to my first tutorial
I will teach you hwo you can create your own vendors here.

Open Notepad and isert the text.

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:

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

Feel free to ask =)

Sρy.εxε is offline  
3 Users
Old   #2
elite*gold: 0
Join Date: Jul 2010
Posts: 3
Received Thanks: 0
Nice tutorial!
If everything is correct!

sven489 is offline  
Old   #3
elite*gold: 0
Join Date: Mar 2010
Posts: 85
Received Thanks: 69
Nice TuT
Bommi123 is offline  
Old   #4
elite*gold: 0
Join Date: Jul 2010
Posts: 545
Received Thanks: 229
Thanks, but not the best =)

Sρy.εxε is offline  
Old   #5
elite*gold: 0
Join Date: Jul 2010
Posts: 3
Received Thanks: 0
Nice Nice Nice DDD

sven489 is offline  

tutorial, vendors, [navicat, ] creating

« Previous Thread | Next Thread »

Similar Threads
[TUTORIAL] Creating a simple DLL Cheat/Hack
HOW TO CREATE YOUR OWN DLL HACK Hello guys, In recent days, I recieved many questions about how to use the pointers posted in one specific thread....
159 Replies - Kal Hacks, Bots, Cheats & Exploits
Pls somebody a complete tutorial for Creating Pserver from start to end.
Every time I start to make a Pserver I've some errors. Sometimes at SQL server install, sometimes at Apache... Someone pls write a complete tutorial:...
19 Replies - Dekaron Private Server
[Tutorial]Creating a notepad app[Lot of Text]
Create a Notepad App In this tutorial I will show you how you can create your own Notepad like Application. Start by creating a new Windows Forms...
15 Replies - CO2 Programming
Need MySQL and navicat ENGLISH
Hey my navicat is .... dunno... i have navicat8_de so german... i checked about 10 times or MORE my c:/mysql/data folder - test, my, acount, mysql...
1 Replies - EO PServer Hosting
Creating a IGN with english letters
I know there are already threads about this (or maby not?) but i odnt feel like digging through 50000000000 pages of the forum can somoe just give me...
4 Replies - SRO PServer - Discussions / Questions

All times are GMT +2. The time now is 16:55.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.