[Archive] Reduce Respawn time creature/npc
[Archive] Reduce Respawn time creature/npc
Original source
Quote: UPDATE `creature_respawn` SET `respawntime` = 'Respawn time here' WHERE `entry` = entry id here LIMIT 1;or with this one
Click to expand...
Quote: SET
@ENTRY = 160000, /*NPC ENTRY*/
@SPAWNTIME = 10; /*SPAWNTIME*/
UPDATE creature SET spawntimesecs = @SPAWNTIME WHERE id IN (SELECT DISTINCT id FROM creature_template WHERE entry = @ENTRY);
Click to expand...
![[Image: sc6vpv.jpg]](http://i59.tinypic.com/sc6vpv.jpg)
rektbyfaith
11-04-2025, 05:04 PM #1Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
Quote: UPDATE `creature_respawn` SET `respawntime` = 'Respawn time here' WHERE `entry` = entry id here LIMIT 1;or with this one
Click to expand...
Quote: SET
@ENTRY = 160000, /*NPC ENTRY*/
@SPAWNTIME = 10; /*SPAWNTIME*/
UPDATE creature SET spawntimesecs = @SPAWNTIME WHERE id IN (SELECT DISTINCT id FROM creature_template WHERE entry = @ENTRY);
Click to expand...
Original source
Been looking for this
rektbyfaith
11-04-2025, 05:04 PM #2Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
Been looking for this
Original source
Hi hi, playing, or trying to play/configure latest version, 10, and when we kill a red creature it IMMEDIATELY respawns when I loot it. I have tried searching and looking through the config. I cannot find a creature_respawn table in the SQL in this version, not does "Rate.Corpse.Decay.Looted = 100" change anything. I know it should be something obvious, but, please help!? How do I stop mobs respawning as soon as they are looted and their corpses instantly decay? Thanks.
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Update:
- If I use the default "Corpse.Decay.NORMAL = 60" and default "Rate.Corpse.Decay.Looted = 1" and loot a corpse, the mob respawns in 60 seconds (good)
- If I use "Corpse.Decay.NORMAL = 600" and default "Rate.Corpse.Decay.Looted = 1" and loot a corpse, the mob respawns in 60 seconds (bad)
- If I use "Corpse.Decay.NORMAL = 600" and default "Rate.Corpse.Decay.Looted = 1" and DO NOT loot a corpse, the mob respawns in 600 seconds (good)
- If I use the default "Corpse.Decay.NORMAL = 60" and ANY non default like 100 "Rate.Corpse.Decay.Looted = 100" and loot a corpse, the mob respawns instantly (bad)
Is this a know bug or am I completely missing / misunderstanding something?
![[Image: 1f635.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f635.png)
... I'd like to have NOTHING respawn for a long time, and their corpses clutter the battlefiueld for ages and be able to 'empty' an area of mobs... but with the above, I don't think it is working correctly nor I will be able to.
Any assistance, again, thanks.
rektbyfaith
11-04-2025, 05:04 PM #3Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
Hi hi, playing, or trying to play/configure latest version, 10, and when we kill a red creature it IMMEDIATELY respawns when I loot it. I have tried searching and looking through the config. I cannot find a creature_respawn table in the SQL in this version, not does "Rate.Corpse.Decay.Looted = 100" change anything. I know it should be something obvious, but, please help!? How do I stop mobs respawning as soon as they are looted and their corpses instantly decay? Thanks.
Update:
- If I use the default "Corpse.Decay.NORMAL = 60" and default "Rate.Corpse.Decay.Looted = 1" and loot a corpse, the mob respawns in 60 seconds (good)
- If I use "Corpse.Decay.NORMAL = 600" and default "Rate.Corpse.Decay.Looted = 1" and loot a corpse, the mob respawns in 60 seconds (bad)
- If I use "Corpse.Decay.NORMAL = 600" and default "Rate.Corpse.Decay.Looted = 1" and DO NOT loot a corpse, the mob respawns in 600 seconds (good)
- If I use the default "Corpse.Decay.NORMAL = 60" and ANY non default like 100 "Rate.Corpse.Decay.Looted = 100" and loot a corpse, the mob respawns instantly (bad)
Is this a know bug or am I completely missing / misunderstanding something?
... I'd like to have NOTHING respawn for a long time, and their corpses clutter the battlefiueld for ages and be able to 'empty' an area of mobs... but with the above, I don't think it is working correctly nor I will be able to.
Any assistance, again, thanks.
Original source
Thank you this is a good team
rektbyfaith
11-04-2025, 05:04 PM #4Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
Thank you this is a good team
Original source
thanks
that's what i was looking for
rektbyfaith
11-04-2025, 05:04 PM #5Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
thanks
that's what i was looking for
Original source
I've had some success with modifying respawn times globally using 'worldserver.conf' settings and without modifying the database.
Here's my post about it:
Modifying creature respawn time
rektbyfaith
11-04-2025, 05:04 PM #6Archived author: cliffsmits • Posted: 2025-11-04T18:04:28.374124
Original source
I've had some success with modifying respawn times globally using 'worldserver.conf' settings and without modifying the database.
Here's my post about it:
Modifying creature respawn time
1 Guest(s)
1 Guest(s)