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 18:15

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


[Navicat Tutorial] Creating Vendors [English]

Reply
 
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.

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 =)



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


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


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


sven489 is offline  
Reply

Tags
tutorial, vendors, [navicat, ] creating



« Novo : Server crashed :( | Probleme beim Compilen. »

Similar Threads
[TUTORIAL] Creating a simple DLL Cheat/Hack
11/06/2018 - Kal Hacks, Bots, Cheats & Exploits - 160 Replies
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. So here is guide for creating the basic Proxy-DLL skeleton + hack. I will try to explain it to details. Requirements 1] Some C++ and UCE (memory and such stuff) knowladge 2] Some Time
Pls somebody a complete tutorial for Creating Pserver from start to end.
04/19/2009 - Dekaron Private Server - 19 Replies
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: How can someone make a working Pserver with SQL install, database backup, querys, IP settings, server rate settings, account creation in SQL, account creation with php (inc. apache install, settings) and starting the server (dbmon, cast... and client edit in winhex). Thx, sry 4 my poor eng.
[Tutorial]Creating a notepad app[Lot of Text]
11/23/2008 - CO2 Programming - 15 Replies
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 Application. Now we can add some controls. The first control will be a MenuStrip. After that right click on the newly created menustrip, Select Insert Standard Items. Delete the Tools menu and the Help menu. Delete the Redo menu item from the Edit menu. Now drag and drop a TextBox onto the form.
Need MySQL and navicat ENGLISH
06/08/2008 - EO PServer Hosting - 1 Replies
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 in navicat i got databases: information_schema, my, account, mysql I CANT USE TRIAL because i had already one. pls someone can send me these things? i need that pls
Creating a IGN with english letters
04/07/2008 - SRO PServer - Discussions / Questions - 4 Replies
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 the link or post a guide?? Im lazy:D:D:D:D



All times are GMT +1. The time now is 18:15.


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.