This is what I would like to do. In the player_data table the only categorizes are PlayerUID, Playername, playermortality, and playersex. I do not run events to cleanup players who have not logged in in x amount of days. I don't want a event to do that because, as I would rather do it manually in case I don't want to delete someone.
What I would like is a fifth category lastlogin or datestamp something like that. That way I can see playerid playername and when they last logged in. If it was someone who has not logged in within my 30 day rule I would no to delete them along with char data, etc. I added a category within player_data called Datestamp
datatype TIMESTAMP
everything else I left blank except the default category
I have it set as CURRENT TIMESTAMP with on UPDATE CURRENT TIMESTAMP checked.
I restarted the server and logged in, pulled up the database and that category was 0000-00-00 00:00:00. I thought maybe since that player has not logged in it did not update, so I looked at my char which was currently logged in. It showed 0000-00-00 00:00:00 as well
My question is, is it possible to do what I am trying to do, if so how?
Question
sampson42002
This is what I would like to do. In the player_data table the only categorizes are PlayerUID, Playername, playermortality, and playersex. I do not run events to cleanup players who have not logged in in x amount of days. I don't want a event to do that because, as I would rather do it manually in case I don't want to delete someone.
What I would like is a fifth category lastlogin or datestamp something like that. That way I can see playerid playername and when they last logged in. If it was someone who has not logged in within my 30 day rule I would no to delete them along with char data, etc. I added a category within player_data called Datestamp
datatype TIMESTAMP
everything else I left blank except the default category
I have it set as CURRENT TIMESTAMP with on UPDATE CURRENT TIMESTAMP checked.
I restarted the server and logged in, pulled up the database and that category was 0000-00-00 00:00:00. I thought maybe since that player has not logged in it did not update, so I looked at my char which was currently logged in. It showed 0000-00-00 00:00:00 as well
My question is, is it possible to do what I am trying to do, if so how?
Thanks Mike
Link to comment
Share on other sites
3 answers 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