Been away, have some questions

[Bdiddy]

I haven't messed around w/my mini login eq emu in some time, nor am I an expert. I have navicat installed, but what I want to do is figure out what the re-spawn times are on certain mobs and alter them if needed. Can someone point me in the direction to figure this out? Also can you tell me what the time is in, such as seconds, minutes, etc. Thanks

[Bdiddy]

anyone able to help here?

[Congdar]

the respawntime column is in the spawn2 table
the timers are added to the respawn_times table in duration column
i believe it is in seconds

[Derision]

select distinct n.id, n.name, s.respawntime from npc_types n
inner join spawnentry se on n.id = se.npcID
inner join spawn2 s on se.spawngroupID = s.spawngroupID
where s.zone = 'fearplane' and n.name like '%cazic%';

+-------+-------------+-------------+
| id | name | respawntime |
+-------+-------------+-------------+
| 72003 | Cazic_Thule | 281232 |
+-------+-------------+-------------+
1 row in set (0.00 sec)

mysql>


Just replace 'fearplane' with the short name of the zone you are interested in, and %cazic% with the mob name. The % signs are wildcards.

There is also a 'variance' column in the spawn2 table to allow the mob to spawn within a window around it's 'respawntime'.

[Bdiddy]

Thx for the replies, now what if there is a window, say for example cazic thure has a window +/- X amount of hours he can spawn in