Feature request: Timestamp for first_join items
SlimeDog opened this issue · 5 comments
Please add a timestamp for each first_join item, so we can tell when they were granted.
How would you like to retrieve this timestamp?
Would it be via the debug messages for when a player joins?
Also, this is a storable dataset correct? Something I should add to the database.db first-join tableset by creating an additional column to store the timestamp?
Also, How would you want the timestamp to be formatted?
I don't need ItemJoin to retrieve it. I can read the database. :)
A SQL timestamp is fine. I suppose you could document the SQL command (in American format):
SELECT strftime('%Y-%m-%d %H:%M', data_value/1000, 'unixepoch') FROM ...
Okay, so I think I implemented it how you asked.
I simply used the default Java SQL Timestamp format.
This applies to first-join, first-world, and ip-limit items as well as first-commanded players.
Should see this take effect in the latest snapshot; http://ci.craftationgaming.com/job/ItemJoin/207/
Note: that obviously I cannot go back in time and put the missing timestamps so the ones that were given before this snapshot will be marked as NULL while others will be given the text timestamp as they are given.