Quote:
Originally Posted by PresidentEvil
the rpg randomly reset for me and some other players, so I chnaged the database from sqlLite to mySQL via webhost and it still resets people randomly :S seems to be accociated with server crashes
any help?
|
+1
I've been having a lot of this. The server always seems to crash first, the cause never seems to be logged, although I once found one error about a memory leak in THC RPG, I posted it here I think...
But what I can say happens is that all players get a connection time out (I'm not even 100% sure the server crashes even... I can't establish a connection in any way) and after that the server has a lot of trouble reading the rpg DB, it can appear as though everything has been reset for a while and mostly ppl who were online at that time (but other too I believe) will be reset for some reason (0 in every DB field, lvl 0, 0 credits,..).
It's happening multiple times a week lately and it's a very annoying issue -.-
But what I actually wanted to ask is... is there a way to purge the database? I don't see a way to actually remove IDs from it, but I'd love to shrink it significantly by removing everyone with 0 exp for instance..