5165 Bugs

Page 3 of 5 12 3 45
03/30/2010 04:32 Santa#31
Quote:
Originally Posted by kamote View Post
one question, what is the purpose of being here in the thread if you won't share?
Whats the point of just handing out the code to everyone on the forum, he gave you enough information, im sure, to fix the problem.
03/30/2010 06:22 Arcо#32
Starbucks please refrain from double posting.
Thanks:)
03/30/2010 16:58 Korvacs#33
Quote:
Originally Posted by .Arco View Post
Starbucks please refrain from double posting.
Thanks:)
The user before him deleted his post, so at time of posting it wasnt a double post, but thanks for the report. :)
03/30/2010 17:10 ChingChong23#34
Quote:
Originally Posted by StarBucks View Post
Your server really shouldn't have major rollbacks if it it done correctly. Anytime a character receives money/cps/skills/exp, anything that is saved to the database, should be saved right when it happens. Don't wait and save everything when the played logs off, or periodic server wide saves. Save it when anything changes is what im trying to say.
or.... they could post the errors they get from the server crashing and fix it by the root of the problem.
03/30/2010 21:34 PeTe Ninja#35
You shouldn't save it every single ten seconds, that would just be laggy. You shouldn't have rollbacks period.
03/30/2010 22:12 -impulse-#36
I only save when player logs out...no rollbacks(mysql ftw ^^)
03/30/2010 22:36 ~Yuki~#37
I save every 15 minutes and at logout , for security i also do a account and char backup all 20 min.. but thats just me
03/30/2010 22:38 -NewDawn-#38
Idk... I've never had a rollback and I'm on Flat Database. Maybe you added something to it that makes it unstable... or maybe it's your connection. Pete, post your internet speed using speedtest.net.
03/31/2010 05:44 Santa#39
Quote:
Originally Posted by PeTe Ninja View Post
You shouldn't save it every single ten seconds, that would just be laggy. You shouldn't have rollbacks period.
Well honestly if you don't save it any time something gets updated and the client looses connection (there internet goes down, vps/dedi fails) then that stuff that the character did between the last save and then would be gone.

Quote:
Originally Posted by -impulse- View Post
I only save when player logs out...no rollbacks(mysql ftw ^^)
What if the player doesn't log out, what if he looses connection with his net?

Quote:
Originally Posted by ~Yuki~ View Post
I save every 15 minutes and at logout , for security i also do a account and char backup all 20 min.. but thats just me
Saving all the characters logged in every 15 minutes would cause lag on the server every 15 minutes.


Maybe seperating the "database" server from the game server would make it so the constant saving wouldn't cause the server to lag? I don't know if that would work seeing as the game server would need to send the data still. Idk. Just an idea.

I still don't understand how you all complain that saving constantly would cause server lag, honestly saving EVERYTHING at periodic times would cause tremendous lag for a few seconds. Wouldn't you rather have a few millaseconds lag constantly, if it was constant people would get used to it (its not like your vps won't cause lag also).
03/31/2010 05:52 -NewDawn-#40
As I said. I don't get rollbacks. The only thing I can think of that would cause a rollback is the server crashing. If the server crashes, then it won't save the characters. Characters save on a disconnect as far as I know of. The server must be crashing then? Something not coded right like flowers? The flower save system doesn't work... unless you merge it with the character save system... then it works perfectly.

For the people that have the rollbacks... what happens before the rollback?
03/31/2010 07:27 ~Yuki~#41
Quote:
Originally Posted by StarBucks View Post
Well honestly if you don't save it any time something gets updated and the client looses connection (there internet goes down, vps/dedi fails) then that stuff that the character did between the last save and then would be gone.



What if the player doesn't log out, what if he looses connection with his net?
Will still save.


Saving all the characters logged in every 15 minutes would cause lag on the server every 15 minutes.
No?


Maybe seperating the "database" server from the game server would make it so the constant saving wouldn't cause the server to lag? I don't know if that would work seeing as the game server would need to send the data still. Idk. Just an idea.
Good Idea ima do that later

I still don't understand how you all complain that saving constantly would cause server lag, honestly saving EVERYTHING at periodic times would cause tremendous lag for a few seconds. Wouldn't you rather have a few millaseconds lag constantly, if it was constant people would get used to it (its not like your vps won't cause lag also).
^this
03/31/2010 08:30 -impulse-#42
Separating the database from server is equal to create a new thread where database will save the characters.
If you want loading to be on that thread also, you gotta add a callback, take it and then move on another thread, so the database thread can load/save and give callbacks.
03/31/2010 13:26 _Emme_#43
For a SQL database, just save the variable whenever it gets changed (just make sure you check that there isn't any open query, there will be queues ofcourse).
04/01/2010 01:01 Santa#44
Quote:
Originally Posted by EmmeTheCoder View Post
For a SQL database, just save the variable whenever it gets changed (just make sure you check that there isn't any open query, there will be queues ofcourse).
Exactly.
04/01/2010 01:58 PeTe Ninja#45
You shouldn't have to do that.. You should make it when the socket disconnects to save.. that way no matter what.. if the server crashes or whatever.. the socket will disconnect causing it to run that void of save ><
Page 3 of 5 12 3 45