Quote:
|
I noticed that the latest CVS has a new field "timeleft" in the spawn2 table
|
I added this a few weeks ago so that static zones are not needed for mobs with long respawn times. Its pretty simple, when a spawn is killed it records the timeleft in ms into that field and every 5 minutes the world updates the field by decreasing the value by 300000 (5 minutes in ms). If a zone crashes before the npc has reached his respawn time, the timeleft will be loaded from the db on zonebootup and the spawn wont be spawned until the timeleft has reached 0. The reason for this is so that if a zone crashes and you had a high respawn time on a mob that was just killed, it would not be respawned immediately like it used to be. Hope I made that clear, if not post and Ill answer any questions about it further.
OK now about the fields, I am planning on adding 1 field, 'lastname' to npc_types, it will be after name. Its size will be 20. Just add it as a varchar tho.