Topic: members online mysql query
Hey,
I'm currently monitoring a bunch of stats for our site using zabbix. I got total members monitored and graphed no problem. (simple count against members table).
My question is, does anyone have a members online db query they built? This isn't information I want displayed on the page, it's a query I'd like to do. I assume I'll need to do some calculations based off the timestamp in the last visit column.
Does anyone have a query or shell script they have used by chance? Would be much appreciated.