Add new columns: IP, FirstLogin, LastLogin, and OnlineTime to Hawk_Players table

[redpoptarts]

Add support for features already present in LogBlock and Guardian:

Track this information about players and store in the hawk_players table in the database...
(TEXT) IP Address
(DATETIME) First Login
(DATETIME) Most Recent Login
(TIME) Total Online Time

I rely on this information for various features in a plugin I'm working on:
http://dev.bukkit.org/server-mods/x-ray-detective/

It has the ability to process data from an LogBlock, and I will be adding support for HawkEye and Guardian soon. If HawkEye does not add this information to the MySQL tables, certain features will not be available to HawkEye users.

[oliverwoodings]

All this information already exists. Adding those columns. would simply be duplicating data.

[redpoptarts]

You say this information already exists, but I can't find it anywhere in the database.

Would you mind pointing its location out to me? I have a mysql dump of a hawkeye users' database here in front of me, and am unable to find any of those 4 pieces of information. Perhaps I'm overlooking something?

[oliverwoodings]

The information isn't in the users table.

• IP addresses are stored in the login entries in the main table
• you can get the first time logged in by finding the first login entry for that person
• you can find the last time logged in by getting the last login entry for that person
• you can calculate the total time online by getting all the login and logout times and then working out the total.