We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

last_activityStamp | Forum

Topic location: Forum home » Support » General Questions
Alex Philipp
Alex Philipp Jan 16 '13
How we can get info about users last activity in their profile from DB ow_base_user  "activityStamp"?
The Forum post is edited by Alex Philipp Jan 16 '13
Shane
Shane Jun 8 '14
I too would like to know what how to reformat the activity stamp stored in in the ow_base_user table back to a date, not using the application (at this stage) as have been asked to provide a report of recent activity for users.


+---------------+------------------+------+-----+---------+----------------+

| Field               | Type          | Null   | Key  | Default   | Extra     |

+---------------+------------------+------+-----+---------+----------------+

| activityStamp  | int(11)         | NO    |       | 0           |     |

+---------------+------------------+------+-----+---------+----------------+


regards


The Forum post is edited by Shane Jun 8 '14
Shane
Shane Jun 8 '14

Quote from Shane I too would like to know what how to reformat the activity stamp stored in in the ow_base_user table back to a date, not using the application (at this stage) as have been asked to provide a report of recent activity for users.


+---------------+------------------+------+-----+---------+----------------+

| Field               | Type          | Null   | Key  | Default   | Extra     |

+---------------+------------------+------+-----+---------+----------------+

| activityStamp  | int(11)         | NO    |       | 0           |     |

+---------------+------------------+------+-----+---------+----------------+


regards


Gotta love Google - found the answer to my question. I used the function FROM_UNIXTIME(activityStamp)