Hello RaGeZone,
When the world server crashes... You are getting roll back if you didn't re-log...
I was thinking of making something about it so SQL would save every 10 seconds and rollbacks wont happen.
Anny suggestions of how could i do that.
I would be really thankful and likeful if someone helps me out.
Originally Posted by ll Chris ll
Good idea :D
On: I can't help but i'm gonna try this one too if someone will answer on this idea.
http://forum.ragezone.com/f457/auto-...abases-745564/
you should use the search button next time. :D
This is clearly not what he was looking for. Thank you.
Having it save your character data so often would cause a lot of lag and therefore would be inefficient.
Don't let your server crash so you don't have this issue. The server isn't meant to crash.
~~~~~~~~~~~~~~~~~ Solved by Xakzi<- Thank you :3 ~~~~~~~~~~~~~~~~~~~
MSSQL? You can do this with native windows functions, what windows and MSSQL versions are you running?
You'll also find out that backing every 10 seconds will slow down your server.
What causes these rollbacks?
You misunderstood the question. By default, the game server only saves your character information (level, stats, inventory, etc.) every 15 minutes. If the server (whether program or the server itself) crashes in some way, everything since your last character save will be lost (aka rollback). That's what he's talking about.
Save database every 10seconds looool.... Abd if the problem is caused by world crashes, fix the crash.
Posted via Mobile Device
Using the tool Charles posted won't make any impact on the server and give any lag.
So the tool he shared is pretty useful, instead of using the jobs in SQL server.
![Save the database every 10 secounds. [Anti-Rollback]](http://ragezone.com/hyper728.png)
