imagecms/ImageCMS

<?php

class User_Autologin extends CI_Model
{

    public function __construct() {
        parent::__construct();

        // Other stuff
        $this->_prefix = $this->config->item('DX_table_prefix');
        $this->_table = $this->_prefix . $this->config->item('DX_user_autologin');
        $this->_users_table = $this->_prefix . $this->config->item('DX_users_table');
    }

    public function store_key($key, $user_id) {
        $user = [
                 'key_id'     => md5($key),
                 'user_id'    => $user_id,
                 'user_agent' => substr($this->input->user_agent(), 0, 149),
                 'last_ip'    => $this->input->ip_address(),
                ];

        return $this->db->insert($this->_table, $user);
    }

    public function get_key($key, $user_id) {
        $auto_table = $this->_table;
        $users_table = $this->_users_table;

        $this->db->select("$users_table.id");
        $this->db->select("$users_table.username");
        $this->db->select("$users_table.role_id");
        $this->db->from($users_table);
        $this->db->join($auto_table, "$auto_table.user_id = $users_table.id");
        $this->db->where("$users_table.id", $user_id);
        $this->db->where("$auto_table.key_id", md5($key));

        return $this->db->get();
    }

    public function delete_key($key, $user_id) {
        $data = [
                 'key_id'  => md5($key),
                 'user_id' => $user_id,
                ];

        $this->db->where($data);
        return $this->db->delete($this->_table);
    }

    public function clear_keys($user_id) {
        $this->db->where('user_id', $user_id);
        return $this->db->delete($this->_table);
    }

    public function prune_keys($user_id) {
        $data = [
                 'user_id'    => $user_id,
                 'user_agent' => substr($this->input->user_agent(), 0, 149),
                 'last_ip'    => $this->input->ip_address(),
                ];

        $this->db->where($data);
        return $this->db->delete($this->_table);
    }

}