How can I undo a dropevent ?? Please Help

[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 

 

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);

[jahangir13]

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.