How do you use two database columns for the identity in ion auth (codeigniter library)?

Question

Ion Auth allows you to choose an identity which is basically a database column to be used for login. I want to be able to choose two database columns for my identity in Ion Auth since I want users to login using either their username or email similar to how Twitter works. How do I do this? Below is a sample code of what I'm trying to accomplish:

<?php
$config['identity'] = 'email && username'; // A database column which is used to login with ion auth
?>

As you can see, I want both usernames and emails but I don't know how to add both in the config.

So how does one modify the core library in order to do this? — Mico Abrina, Oct 31 '12 at 07:47

score 2 · Accepted Answer · edited Dec 18 '14 at 04:48

In ion_auth_model.php, in the login method, right after this code:

$query = $this->db->select($this->identity_column . ', username, email, id, password, active, last_login')
      ->where($this->identity_column, $identity)
      ->limit(1)
      ->order_by('id', 'desc')
      ->get($this->tables['users']);

Add the following code:

if($query->num_rows() == 0){
    $query = $this->db->select($this->identity_column . ', username, email, id, password, active, last_login')
          ->where('username', $this->db->escape_str($identity))
          ->limit(1)
          ->get($this->tables['users']);
}

score 1 · Answer 2 · answered Oct 31 '12 at 14:32

1

You have to modify the core of the library in order to achive that. If you don't know how to do it, ask Ben Edmunds for help, i am sure he will know it.

answered Oct 31 '12 at 14:32

How do I get in touch with him? – Mico Abrina Nov 01 '12 at 00:25

How do you use two database columns for the identity in ion auth (codeigniter library)?

2 Answers2