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.

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

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?

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.