Changing "last visit" format under "users&quo

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

Hey Guys,

Not sure if this goes here. On my database row "users" it has the "last visit" column. It displays the random number code format or whatever you call it. I am wanting to know if there is a way to change it to where it shows the actual date. I am wanting to clear up my members list by deleting members who haven't logged in in a while.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2853

What it displays is the Unix timestamp. You can use some PHP code to convert them back into string dates. Another option is the MySQL function FROM_UNIXTIME

Gremmie · Posted: Fri Jan 11, 2008 12:29 pm

Also be aware that field came from phpBB. It is only updated when people visit the forums, which may or may not be good enough for you. Unfortunately there is no "last login" field in the database.

And finally you may want to remove members using the admin panel and not something like phpMyAdmin, as that will make sure private messages and such get deleted.

The next Your_Account module should provide more support for this kind of thing, IMHO.