EQEmulator Forums - Changing spawn time

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Changing spawn time (https://www.eqemulator.org/forums/showthread.php?t=16557)

Changing spawn time

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. :)

In order to set a specific spawn time for ALL mobs currently spawned, put in this MySQL query:

Code:

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.

Code:

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:

Code:

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.