calamity Posted April 17, 2014 Report Share Posted April 17, 2014 I added some drop events to my server and now alot of my players can get in game at all, unless I set there alive to 0 (kill em in database) I think it has to do with a drop event I added since it just started happening. it seems that it is setting there worldspace and medical to [] or at least that is the only thing I find different about the players that can join. if its not a drop event it could be one of these I run occasionally delete FROM `Character_DATA` USING Character_DATA, Character_DATA AS tmpcharacter_data WHERE NOT Character_DATA.CharacterID=tmpcharacter_data.CharacterID AND Character_DATA.CharacterID<tmpcharacter_data.CharacterID AND (Character_DATA.PlayerUID=tmpcharacter_data.PlayerUID) or........................................... DELETE FROM `Player_LOGIN` WHERE `Datestamp` <= date_sub(CURRENT_TIMESTAMP, INTERVAL 14 DAY); Link to comment Share on other sites More sharing options...
0 jahangir13 Posted April 18, 2014 Report Share Posted April 18, 2014 If you have mysql query logging or binary logging on you could maybe get some information what queries have been executed since a certain point in time. But that does not help in your example as for updates or deletes you will have no way of knowing what the previous data was. At least you will need a full backup. As far as I know with a backup you could go to a previous state of the db (let's say 4 hours ago) and with a log file (binary one...if you have something like that) you could execute the statements from the time the backup was made to the time you specify (e.g. 2 hours ago when your error happened). A redo of the queries so to say. Without a full backup the data is lost. Link to comment Share on other sites More sharing options...
Question
calamity
I added some drop events to my server and now alot of my players can get in game at all, unless I set there alive to 0 (kill em in database)
I think it has to do with a drop event I added since it just started happening.
it seems that it is setting there worldspace and medical to []
or at least that is the only thing I find different about the players that can join.
if its not a drop event it could be one of these I run occasionally
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now