How to Change Respawn Rate for Creatures

[Nanos]

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".

 

[Ayiko]

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 )

 

[Nanos]

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.

 

[ExO]

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.

 

[Nanos]

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?

 

[Nanos]

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?

 

[Ayiko]

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?

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)

 

[Nanos]

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)

Ha, isn't that the rub eh?

It started working after I saved it.

Thank you for your help.