Custom Data Update

[dhamaso]

Hello again, When i try to update the user's data like this:

// Config Settings
$config['database']['user_acc']['custom_columns'] = array(
'first_name', 'last_name'
);

// Update Code
$user_id = 3;
$user_data = array(
'uacc_password' => 'newpass',
'first_name' => 'Damaso',
'last_name' => 'Pérez'
);

if(!$this->flexi_auth->update_user($user_id, $user_data)){
exit($this->flexi_auth->get_messages());
}

The library show me an sql error:
UPDATE user_accounts SET = 'Perez' WHEREuser_accounts.uacc_id` = '5'

This is because the custom_columns array's keys are numeric instead associative keys (the column names in the user account table):
print_r($user_account_cols);
Array
(
[id] => uacc_id
[group_id] => uacc_group_fk
[email] => uacc_email
[username] => uacc_username
[password] => uacc_password
...
[0] => first_name <-- check the key
[1] => last_name <-- check the key
)

So in the below code
foreach ($this->auth->database_config['user_acc']['custom_columns'] as $column) {
$user_account_cols[] = $column;
}

Change this
foreach ($this->auth->database_config['user_acc']['custom_columns'] as $column) {
$user_account_cols[$column] = $column;
}

Now the array keys are
print_r($user_account_cols);
Array
(
[id] => uacc_id
[group_id] => uacc_group_fk
[email] => uacc_email
[username] => uacc_username
[password] => uacc_password
...
[first_name] => first_name
[last_name] => last_name
)

And now change the line
$sql_update[$this->auth->tbl_col_user_account[$key]] = $user_data[$column];

by adding
if(array_key_exists($key, $this->auth->tbl_col_user_account)){
$sql_update[$this->auth->tbl_col_user_account[$key]] = $user_data[$column];
}else{
$sql_update[$key] = $user_data[$column];
}

This works for me!