[eluser]Andy78[/eluser]
Has anybody added another table to the users object? For example you have users, groups and meta I want to add a forth table user_profiles and have the fields from this returned in the standard user object. I know it shouldn't be that difficult to this but I'm a bit rusty and tired right now and cant follow the full logic of the library. Is it as simple as adding another join into this function:
Code:
public function get_users($group = false)
{
$this->db->select(array(
$this->tables['users'].'.*',
$this->tables['groups'].'.name AS `group`',
$this->tables['groups'].'.description AS group_description'
));
if (!empty($this->columns))
{
foreach ($this->columns as $field)
{
$this->db->select($this->tables['meta'].'.'. $field);
}
}