Adding lastlogin to the player_data table

[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

[sampson42002]

The main reason I did not want to do it that way is because some users have quite a few rows in that table, so it could get confusing(plus I kinda forgot about it)  I will do it that way unless someone know's how to add the last login to the player data.

Thanks you

 

[seelenapparat]

I think you would need a custom hiveext.dll for that. as this is the file that makes all the database calls etc.

[sampson42002]

Messing with the hive file sounds like a PITA.  I'll just do what oldmatechoc said and use char data instead.

 

Thanks for all of the help