Welcome Guest, Not a member yet? Register   Sign In
Extending ci_sessions table
#1

[eluser]thomasR[/eluser]
I'm currently trying to create a list of 'active users' meaning users that are logged in and have been active in the last few minutes.

Since the session stores the 'last_activity' field in the ci_sessions table I hope to use that.
My problem is, that I can't connect the sessions with the users in an SQL statement since all userdata is stored in a single text field.

Is it possible to extend the ci_sessions table to add a user_id field? Or would there be another way of doing it?


Messages In This Thread
Extending ci_sessions table - by El Forum - 12-17-2010, 08:31 AM
Extending ci_sessions table - by El Forum - 12-17-2010, 09:13 AM
Extending ci_sessions table - by El Forum - 12-19-2010, 06:31 PM
Extending ci_sessions table - by El Forum - 12-20-2010, 01:40 AM
Extending ci_sessions table - by El Forum - 12-22-2010, 06:15 PM
Extending ci_sessions table - by El Forum - 12-22-2010, 07:12 PM
Extending ci_sessions table - by El Forum - 12-23-2010, 04:10 AM



Theme © iAndrew 2016 - Forum software by © MyBB