We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
usertime stamp on MySQL | Forum
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
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?
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.
