[Archive] How to Change Respawn Rate for Creatures
[Archive] How to Change Respawn Rate for Creatures
Original source
Hello,
Is there a way to increase the time between a creatures death and their respawn? I am tired of being attacked from behind by a creature I had killed just a few minutes previously.
I have looked in the WorldServer.conf file and didn't find anything, but I was looking for the word "respawn".
rektbyfaith
11-04-2025, 05:17 PM #1Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Hello,
Is there a way to increase the time between a creatures death and their respawn? I am tired of being attacked from behind by a creature I had killed just a few minutes previously.
I have looked in the WorldServer.conf file and didn't find anything, but I was looking for the word "respawn".
Original source
Well, if you wish to edit every already in-game npc via one simple SQL query, use
" UPDATE CREATURE SET spawntimesecs = 1200 "
(Goes in seconds, 1200 = 20 minutes, up to you though how long you want it to be )
rektbyfaith
11-04-2025, 05:17 PM #2Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Well, if you wish to edit every already in-game npc via one simple SQL query, use
" UPDATE CREATURE SET spawntimesecs = 1200 "
(Goes in seconds, 1200 = 20 minutes, up to you though how long you want it to be )
Original source
Thank you.
I am new to using databases so I have a very newb question for you (or anyone who wishes to help).
What file initiates the SQL Query? I am just not sure where to put the line " UPDATE CREATURE SET spawntimesecs = 1200 ".
--edit--
After looking this up for a couple of hours, I have come to the conclusion it is far beyond my current abilities.
rektbyfaith
11-04-2025, 05:17 PM #3Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Thank you.
I am new to using databases so I have a very newb question for you (or anyone who wishes to help).
What file initiates the SQL Query? I am just not sure where to put the line " UPDATE CREATURE SET spawntimesecs = 1200 ".
--edit--
After looking this up for a couple of hours, I have come to the conclusion it is far beyond my current abilities.
Original source
Actually,
It may not be as advanced as you think it is, let me explain;
You should open the database with a program as "HeidiSQL" and then you should browse into the "emucoachw" database and then paste that query in there and press at the execute button or press at F5, if that doesn't work press F9 (can't remember which one that executes it right now ;p) but you get the point.
If you need me to be more detailed, feel free to let me know and I will try to describe it further.
rektbyfaith
11-04-2025, 05:17 PM #4Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Actually,
It may not be as advanced as you think it is, let me explain;
You should open the database with a program as "HeidiSQL" and then you should browse into the "emucoachw" database and then paste that query in there and press at the execute button or press at F5, if that doesn't work press F9 (can't remember which one that executes it right now ;p) but you get the point.
If you need me to be more detailed, feel free to let me know and I will try to describe it further.
Original source
ExO,
Thank you for your help. I really don't expect you to hand hold me through all of this, but I appreciate any help you can give. I consider myself a quick learner; there are just a few basic things that the tutorials I have found seem a little muddy to me.
The number one thing I am not clear on is the process of opening the database itself. I downloaded the HeidiSQL tool, put it in the "Release" folder, and attempted to open the libmysql.dll file. It says the "settings were successfully saved" but it won't open. I have a feeling if I knew what I was doing with this it would help tremendously.
The HeidiSQL I have downloaded is the 64-bit version (since I have a 64-bit processor). Does that matter at all for working with the database?
rektbyfaith
11-04-2025, 05:17 PM #5Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
ExO,
Thank you for your help. I really don't expect you to hand hold me through all of this, but I appreciate any help you can give. I consider myself a quick learner; there are just a few basic things that the tutorials I have found seem a little muddy to me.
The number one thing I am not clear on is the process of opening the database itself. I downloaded the HeidiSQL tool, put it in the "Release" folder, and attempted to open the libmysql.dll file. It says the "settings were successfully saved" but it won't open. I have a feeling if I knew what I was doing with this it would help tremendously.
The HeidiSQL I have downloaded is the 64-bit version (since I have a 64-bit processor). Does that matter at all for working with the database?
Original source
So I finally figured it out. I was able to open the database and place the line Ayiko gave me, but when executed (F9) it gave me a message notifying me of the absence of a "WHERE" clause. When I tested it out, the spawn rate was not changed.
I thought perhaps the change would not happen until or unless I saved it, but I did not want to chance messing something up.
Is there a code for "everywhere" for the WHERE clause?
rektbyfaith
11-04-2025, 05:17 PM #6Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
So I finally figured it out. I was able to open the database and place the line Ayiko gave me, but when executed (F9) it gave me a message notifying me of the absence of a "WHERE" clause. When I tested it out, the spawn rate was not changed.
I thought perhaps the change would not happen until or unless I saved it, but I did not want to chance messing something up.
Is there a code for "everywhere" for the WHERE clause?
Original source
Quote:Nanos said:It should give you a warning that you need a where clause, butyou cna just skip it by clicking that you know what you are doing, Yes/No (Click yes)
So I finally figured it out. I was able to open the database and place the line Ayiko gave me, but when executed (F9) it gave me a message notifying me of the absence of a "WHERE" clause. When I tested it out, the spawn rate was not changed.
I thought perhaps the change would not happen until or unless I saved it, but I did not want to chance messing something up.
Is there a code for "everywhere" for the WHERE clause?
Click to expand...
rektbyfaith
11-04-2025, 05:17 PM #7Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Quote:Nanos said:It should give you a warning that you need a where clause, butyou cna just skip it by clicking that you know what you are doing, Yes/No (Click yes)
So I finally figured it out. I was able to open the database and place the line Ayiko gave me, but when executed (F9) it gave me a message notifying me of the absence of a "WHERE" clause. When I tested it out, the spawn rate was not changed.
I thought perhaps the change would not happen until or unless I saved it, but I did not want to chance messing something up.
Is there a code for "everywhere" for the WHERE clause?
Click to expand...
Original source
Quote:Ayiko said:Ha, isn't that the rub eh?
It should give you a warning that you need a where clause, butyou cna just skip it by clicking that you know what you are doing, Yes/No (Click yes)
Click to expand...
It started working after I saved it.
Thank you for your help.
rektbyfaith
11-04-2025, 05:17 PM #8Archived author: Nanos • Posted: 2025-11-04T18:17:40.568121
Original source
Quote:Ayiko said:Ha, isn't that the rub eh?
It should give you a warning that you need a where clause, butyou cna just skip it by clicking that you know what you are doing, Yes/No (Click yes)
Click to expand...
It started working after I saved it.
Thank you for your help.
1 Guest(s)
1 Guest(s)