Ion Auth - Lightweight Auth System based on Redux Auth 2

Code:

function get_player($username){

        $this->db->select('id');

        $this->db->where('username', $username); 

        $id = $this->db->get('users');

        

        $user = $this->ion_auth_model->get_user($id);  

        

    }

Code:

A PHP Error was encountered



Severity: 4096



Message: Object of class CI_DB_mysql_result could not be converted to string



Filename: database/DB_active_rec.php



Line Number: 453

A Database Error Occurred



Error Number: 1064



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 6



SELECT `users`.*, `groups`.`name` AS `group`, `groups`.`description` AS `group_description`, `meta`.`location`, `meta`.`time_zone`, `meta`.`fav_games`, `meta`.`bio` FROM (`users`) LEFT JOIN `meta` ON `users`.`id` = `meta`.`user_id` LEFT JOIN `groups` ON `users`.`group_id` = `groups`.`id` WHERE `users`.`id` = LIMIT 1

Code:

// Show Player List 

    function player_list(){

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

        $data = $this->player_model->general();

        $data['websubtitle']    = 'Player List';

        $data['users'] = $this->ion_auth->get_users_array();

        $data['content'] = 'player/player_list.php';

        $this->load->view('template', $data);

    }

    

// Show the player's page 

    public function view($username=""){

    

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

        $data = $this->player_model->general();

        $data['now'] = time();

        $data['username'] = $this->uri->segment(3); //I believe this is where it is breaking, but I can't figure a way to pass this info

        if($username = ""){

            $this->player_model->get_player($username);

            $data['websubtitle']    = 'View Profile';

            $data['content'] = 'player/view_profile';

            $this->load->view('template', $data);

            

        }    

        else{

            redirect('player/not_working'); //currently, I keep getting redirected to this page.

        }

    }

    // If the view doesn't work, send me to this page of sadness

    function not_working(){

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

        $data = $this->player_model->general();

        $data['websubtitle']    = 'Error';

        $data['content'] = 'player/error';

        $this->load->view('template', $data);

    }

Code:

// Gets a player's data for profile page

    function get_player($username){

        $this->db->select('id');

        $this->db->where('username', $username); 

        $id = $this->db->get('users');

        

        $user = $this->ion_auth_model->get_user($id);  

        

    }

Code:

<h3>All Players</h3>

    

    <table>

        <tr>

            <th colspan=2>Player Name</th>

            <th>Member Since</th>

            <th>PM Player</th>

        </tr>

        &lt;?php foreach ($users as $user):?&gt;

            <tr>

                <td><img src="&lt;?php echo base_url();?&gt;public/uploads/avatars/&lt;?php echo $user['username']; ?&gt;.png" width="25" height="25"/></td>

                <td>&lt;?php echo anchor('player/view/'.$user['username'], humanize($user['username']));?&gt;</td>

                <td>&lt;?php echo unix_to_human($user['created_on'], FALSE, 'us');?&gt;</td>

                <td>Send PM</td>

            </tr>

        &lt;?php endforeach;?&gt;

    </table>

Code:

/**

* get_user_by_field

*

* @param string field name to search

* @param string value to lookup

*

* @return object

**/

public function get_user_by_field($field, $value)

{

   $this->db->where($this->tables['users'].'.'.$field, $value);

   $this->db->or_where($this->tables['meta'].'.'.$field, $value);

   $this->db->limit(1);



   return $this->get_users();

}