PDA

View Full Version : Changing spawn time


cyberstormx
10-22-2004, 09:41 PM
I'm sure this has been asked before, but i could not find any relevant information when i searched.

How would i go about changing the spawn time for newly created mobs. The only spawn time field was in Spawn2 under respawntime, but i only saw a limited list w/ qeynos entries.

Would i have to make a new entry for the zone that i'm concerned with? if so, how would i specify the mob(s) affected?

Using 6.0DR1

Thanks in advance. :)

Cans
10-23-2004, 02:25 AM
In order to set a specific spawn time for ALL mobs currently spawned, put in this MySQL query:


UPDATE spawn2 SET respawntime=X;


Replace X with the amount of time (in seconds I believe) you want it to take for all your mobs to repsawn. 0 gives an instant respawn.

ajb20
10-25-2004, 10:33 PM
select npc_types.id, npc_types.name, spawn2.zone, spawn2.spawngroupid
from npc_types, spawn2, spawnentry
where spawnentry.npcID = npc_types.ID
and spawnentry.spawngroupid = spawn2.spawngroupid;



This way you can see what npcid is part of what npcgroupid and than you do something like:

update spawn2
set respawntime = xx
where spawngroupid = xx
or spwngroupid = xx
or ......;

If you want to be more specific in the select command and just see npcs in one zone:

select npc_types.id, npc_types.name, spawn2.zone, spawn2.spawngroupid
from npc_types, spawn2, spawnentry
where spawnentry.npcID = npc_types.ID
and spawnentry.spawngroupid = spawn2.spawngroupid
and zone = 'zoneshortname';

Keep in mind you can NOT edit the query in MySQL-front due to the results being from multiple tables.