<?php
class MCSBilling_User_Model_Admin extends MCSBilling_User_Model {
    
    public $dbTable = 'users_admin u';
    
    protected $attributes = array(
        'id' => null,
        'username' => null,
        'password' => null,
        'email' => null
    );
    
    protected $attributesRequired = array(
        'username'
    );
    
    protected $dbFields = array(
        'id',
        'username',
        'password',
        'email'
    );
    
    protected $idField = 'id';

    public $sqlSelect = self::sqlSelect;
    
    const sqlSelect = "
        SELECT SQL_CALC_FOUND_ROWS
            u.id,
            u.username,
            u.password,
            u.email
        FROM 
    ";
    
    public function authenticate($username, $password) {
        $app = MCSBilling_Application::getInstance();
        $username = addslashes($username);
        //$password = md5($password);
        $sql = "SELECT id FROM {$this->dbTable}
            WHERE username = '{$username}' 
            AND password = '{$password}'
            AND deleted = 0";
        $result = $app->db->fetchRow($sql);
        
        if (!$result['id']) {
            return false;
        }
        $app->session->userId = $result['id'];
        $app->session->active = 1;
        $app->session->sessionStart = date(DB_DATETIME);
        $app->session->lastAction = date(DB_DATETIME);
        $app->session->save();
        return true;
    }
}
?>