View Single Post
  #443  
Old 04-04-2008, 07:45 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

With the next CVS dump, the max NPCID from PEQ will be 999138. I set the auto increment for npc_types to 999999, so on a fresh db without bots, the first bot will take ID 1000000. If you already have bots, I recommend re-ordering your IDs so they start at 1 million. Then, set your auto-increment to the ID of the last bot like this:

Code:
ALTER TABLE npc_types AUTO_INCREMENT = id;
Keep in mind that 1 million will never be used by PEQ, unless Sony uses zones with zoneids in the 1,000s and since the current batch of zones are in the 400s, I don't see that happening. We have more than enough IDs to use inbetween, as we allocate ourselves 1,000 IDs per zone.

Last edited by cavedude; 04-05-2008 at 03:47 AM..