Ion Auth - Lightweight Auth System based on Redux Auth 2

Code:

Ein Datenbankfehler ist aufgetreten



Error Number: 1064



Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'id` = '8'' in Zeile 1



UPDATE `users` SET `last_login` = 1270340970 WHERE ` IS NULL AND `id` = '8'

Code:

ErrorException [ Notice ]: Undefined property: Practice::$ion_auth



SYSDIR/core/Model.php [ 50 ]



45      * @access private

46      */

47     function __get($key)

48     {

49         $CI =& get_instance();

50         return $CI->$key;

51     }

52 }

53 // END Model Class

54 

55 /* End of file Model.php */

Code:

class Practice extends CI_Controller {

    

    var $user;

    var $game;

    

    function __construct() {

        parent::__construct();

        

        // ION Auth

        $this->load->library('Ion_auth');

        $this->load->library('form_validation');

        $this->load->library('session');

        

        // Defaults

        $this->load->helper('url');

        $this->load->library('firephp');

        

        // Models

        //$this->load->model('Ion_auth_model');

        //$this->load->model('Player');

        $this->load->model('Practice_Game');

Code:

APPPATH/models/ion_auth_model.php [ 966 ] » CI_Model->__get(arguments) 



key ion_auth

 



961         {

962             return FALSE;

963         }

964 

965         //get the user

966         if (isset($this->ion_auth->_extra_where))

967         {

968         $this->db->where($this->ion_auth->_extra_where);

969         }

970 

971         $query = $this->db->select($this->identity_column.', id, group_id')

Code:

CREATE TABLE `tcs_users` (

  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

  `group_id` mediumint(8) unsigned NOT NULL,

  `ip_address` char(16) NOT NULL,

  `username` varchar(15) NOT NULL,

  `password` varchar(40) NOT NULL,

  `salt` varchar(40) DEFAULT NULL,

  `email` varchar(100) NOT NULL,

  `activation_code` varchar(40) DEFAULT NULL,

  `forgotten_password_code` varchar(40) DEFAULT NULL,

  `remember_code` varchar(40) DEFAULT NULL,

  `created_on` int(11) unsigned NOT NULL,

  `last_login` int(11) unsigned DEFAULT NULL,

  `last_login_ip` varchar(20) DEFAULT NULL,

  `active` tinyint(1) unsigned DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Code:

/**

     * login

     *

     * @return bool

     * @author Mathew

     **/

    public function login($identity, $password, $remember=FALSE)

    {

        if (empty($identity) || empty($password) || !$this->identity_check($identity))

        {

        return FALSE;

        }



        $query = $this->db->select($this->identity_column.', id, password, group_id, last_login, ip_address')

                  ->where($this->identity_column, $identity)

                  ->where('active', 1)

                  ->where($this->ion_auth->_extra_where)

                  ->limit(1)

                  ->get($this->tables['users']);



        $result = $query->row();



        if ($query->num_rows() == 1)

        {

        $password = $this->hash_password_db($identity, $password);



        if ($result->password === $password)

        {



            $group_row = $this->db->select('name')->where('id', $result->group_id)->get($this->tables['groups'])->row();



            $session_data = array(

                    $this->identity_column => $result->{$this->identity_column},

                    'id'                   => $result->id, //kept for backwards compatibility

                    'user_id'              => $result->id, //everyone likes to overwrite id so we'll use user_id

                    'group_id'             => $result->group_id,

                    'group'                => $group_row->name,

                    'userlastlogin'        => $result->last_login,

                    'userlastloginip'      => $this->session->userdata('ip_address')

                     );



            $this->session->set_userdata($session_data);

                

            $this->update_last_login($result->id, $this->session->userdata('ip_address'));

        

            if ($remember && $this->config->item('remember_users', 'ion_auth'))

            {

            $this->remember_user($result->id);

            }



            return TRUE;

        }

        }



        return FALSE;

    }

Code:

/**

     * update_last_login

     *

     * @return bool

     * @author Ben Edmunds

     **/

    public function update_last_login($id,$lastloginip)

    {

        $this->load->helper('date');



        if (isset($this->ion_auth->_extra_where) && !empty($this->ion_auth->_extra_where))

        {

            $this->db->where($this->ion_auth->_extra_where);

        }



        $this->db->update($this->tables['users'], array('last_login' => now(), 'last_login_ip' => $lastloginip), array('id' => $id));



        return $this->db->affected_rows() == 1;

    }