View Single Post
  #710  
Old 09-03-2008, 04:05 PM
Congdar
Developer
 
Join Date: Jul 2007
Location: my own little world
Posts: 751
Default

I wonder who is adding those npc's. They are not following the npc id format for zone id and npc id. Really, those npc's are being incorrectly added to the database as I understand it.

From the wiki:

npc_types table
So, first things first. Since we are working on the tutoriala zone, we are going to add Arias. So with Navicat already running, open up the npc_types table. Now, we are going to assign him an id. To do that, we need to make sure that we give him an id that is not in use. Here is a good way to come up with an id for a npc. I would create a 6 digit id for my npc and break it down as follows:


The first 3 digits, I would use the zone id. That way, if we are working on a zone, we can easily search for what npcs are in a zone by using the begin with filter in Navicat.
The last 3 digits would be there sequential number for the npc.

So, for this example, we know that we are going to add a npc to the tutoriala zone. We know that the id for the zone is 188 so the first three digits of his id would be 188. And since we know that this is the first npc we are going to add, we will number him 001. Therefore the complete id for Arias would be 188001. Now, we need to make sure that this id is not in use, so go ahead and perform a search and see if there is an id of 188001 in the npc_types table. If all is well, you should not get anything to pop up.