[DiscordArchive] This is how we have been doing it, I take it the automatic reset is bugged/broken?
[DiscordArchive] This is how we have been doing it, I take it the automatic reset is bugged/broken?
Archived author: Tumultus • Posted: 2025-05-17T01:40:35.041000+00:00
Original source
That is correct. At one time we used a mod by Nefertum to get around the limitation, but that mod ended up conflicting with guildhouses and so now we're stuck in a wierd spot.
![[Image: image.png?ex=690bfced&is=690aab6d&hm=a68...cd3d664f9&]](https://cdn.discordapp.com/attachments/1255602330431127753/1373113315508748289/image.png?ex=690bfced&is=690aab6d&hm=a68d4482eac6e8c2c9727b153a7f886e33b7d41de9a0552532a9c35cd3d664f9&)
Archived author: Revision • Posted: 2025-05-17T01:42:05.674000+00:00
Original source
That's in `instance`. It doesn't even have a reset time, which would explain why it can't check; though I don't understand how it keeps track of when to reset them without that.
![[Image: image.png?ex=690bfced&is=690aab6d&hm=a68...cd3d664f9&]](https://cdn.discordapp.com/attachments/1255602330431127753/1373113315508748289/image.png?ex=690bfced&is=690aab6d&hm=a68d4482eac6e8c2c9727b153a7f886e33b7d41de9a0552532a9c35cd3d664f9&)
Archived author: Revision • Posted: 2025-05-17T01:42:53.650000+00:00
Original source
Oh I see now, that's my bad. It keeps track by using `instance_reset`.
Archived author: Tumultus • Posted: 2025-05-17T01:44:30.869000+00:00
Original source
It is rather confusing. There are many places both in sql and config files that make references to the reset time that seem to do absolutely nothing.
Archived author: Tumultus • Posted: 2025-05-17T01:45:31.886000+00:00
Original source
I'm not entirely sure, but we've changed three separate variables in hopes of moving the reset time to no avail or change, it's very strange.
Archived author: Revision • Posted: 2025-05-17T01:49:34.429000+00:00
Original source
I can't make sense of it. It almost looks like it loads reset times, which will be changed after the time is up (found in instance_reset) and then it checks lockouts and resets if needed, but if it loads the new times before that it will never reset them since the server was down when it happened. I am probably wrong, I don't really understand how it works.
Archived author: Tumultus • Posted: 2025-05-17T01:51:09.124000+00:00
Original source
You and I both. Thank you for your SQL code and time, friend!