Respawn Times...

Moncleared · #1 08-09-2007, 08:07 AM

Can someone give me a quick fix on respawning bosses, I tried to go to Mysql and do:

UPDATE 'respawntime' SET blablhablahblah command but it doesn't work.

I'm not sure if theres a way that I can just reset the server so that it doesn't remember that I cleared Kael/ToV/ ETC ETC. I'd like to just reset all the spawn timers even bosses to like 3 mins, but I definitally don't want to manually do that. Any suggestions?

Moncleared

John Adams · #2 08-09-2007, 08:20 AM

I'm guessing you did not actually try blahblahblah...

Try UPDATE tablename SET fieldname = 'value' WHERE (and then your specific record/ID you wish to update, or you will modify the entire table);

Example:
UPDATE spawn2 SET respawntime = '720' WHERE spawngroupid = 1;

Moncleared · #3 08-09-2007, 08:28 AM

I must have been making a syntax mistake, I'm sorry to bug you for such a petty mistake. This worked, everything in my table now respawns at 60 seconds.

I'm just messing around and having fun, this isn't a serious server so if mobs respawn too fast, to me its not a big deal. The chances of me staying in a zone/instance more than 20 minutes is very slight anyways

Thanks a lot!

Moncleared

Moncleared · #4 08-09-2007, 08:32 AM

John,

Is there anything else you can think of r ight off hand that would cause any boss mobs not to respawn in 60 seconds if i used that command? I looked at my db and the entire 60,000 some entries for spawn2 have been changed to 60 seconds. I noticed a variance column and some other things, is this going to be a problem?

basically what I want to happen is, no matter what zone i go into, what boss i kill, in 60 seconds of its death I want that mofo back up and standing

Thanks in advance.

Moncleared

Moncleared · #5 08-09-2007, 08:59 AM

Also John, Or anyone else,

I've notced not every single spawn is up in a zone. Where can I remove that limitation so that everything is spawned?

Also, Apparently even after changing the respawn times on the database, the mobs I've already killed will not respawn still. As if they are waiting to respawn just like they should. Not sure though.

Moncleared · #6 08-09-2007, 09:14 AM

timeleft ftw. Thanks!

Theeper · #7 08-09-2007, 11:38 AM

Take a look at the spawnentry table and check that the chance field is set to 100% for the spawngroup the mob belongs to.

John Adams · #8 08-09-2007, 11:50 AM

Sometimes 2 (or more) mobs will spawn in the exact same x,y,z, and thus there is a "chance" modifier on their spawnentry (like Theeper said). This is a provision for creating rare spawns. Sometimes Raster, most times, something else (shrieks and kills self at the mention of _his_ name).

Glad to see you worked it out. Yes, "timeleft" is another variable that (far as I know) should be relative to respawntime... but maybe not. I was noticing this with Nagafen today on my server. He's down, so I went to see when he'll be back - something like 60mil milliseconds from now... 18 hours or so, I think I worked it out to be heh. So, I think it's working.

Kinda confusing though, if the wiki is not clear.

Theeper · #9 08-09-2007, 01:57 PM

I thought the chance field worked for mobs in the group that spawn in different places as well, although I have not tested it. Is that not the case John?

John Adams · #10 08-10-2007, 01:44 AM

I think you are right, I didn't mean to say it was _only_ for similar spawn point mobs. I only used that as an example of the functionality. You should be able to randomly spawn anything anywhere using a spawngroup.

However, it is being reported that there are some #npcspawn bugs, so who knows the state of adding anything in-game. I usually add stuff barbarically via SQL insert anyway. I know, I know...