Uses for check users online, user's last activity, last ip and other user's information
PHP
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
DbHttpSession.php
DbHttpSession2.php
README.md

README.md

DbHttpSession

Stores session data in database and transfer data when session is destroy. Uses for check users online, user's last activity and last ip.

Add this to component section in config/main.php

'session' => array (
  'class' => 'application.components.DbHttpSession',
  'connectionID' => 'db',
  'sessionTableName' => 'session',
  'userTableName' => 'user'
),

Session table will be created automatically

Add columns to your user table:
ALTER TABLE user ADD user_id INT(11) NOT NULL, ADD last_ip VARCHAR(100) NOT NULL, ADD last_activity DATETIME NOT NULL

For Example:

Add this method to User model

    public static function getOnlineUsers()
    {
        $sql = "SELECT session.user_id, user.name FROM session LEFT JOIN user ON user.id=session.user_id";
        $command = Yii::app()->db->createCommand($sql);
        
        return $command->queryAll();
    }

Wiki http://www.yiiframework.com/wiki/751/check-users-online-user-last-activity-user-last-ip/