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

usertime stamp on MySQL | Forum

Topic location: Forum home » Support » General Questions
The Chauffeur
The Chauffeur Nov 22 '14
My IRC server authenticates users against Oswall's MySQL database. I'm trying to get users to appear online on website when they're connected to IRC and shown on profile when they were last seen on as well. Can someone tell which tables need to be updated and how often?
The Chauffeur
The Chauffeur Nov 24 '14

I've managed to get IRCd server to update ow_base_user`

.`activityStamp every minute and when the disconnect with the latest timestamp. I can see on users profile showing was seen less than a minute ago but doesn't show online on front page. Do I need to update ow_base_user_online through IRCd as well or is that something done through Oxwall and if do get it updated by IRCd will it cause any problems with Oxwall?
ross Team
ross Nov 25 '14
Yes, correc, you need to update ow_base_user_online table as well. 

You can look at this file: ow_system_plugins/base/bol/user_service.php and find the methods for updating activity timestamp of user logging in and out.