[eluser]mycroes[/eluser]
Also this broke the select_sum function:
$this->db->select_sum('group_permissions.permission', 'permissions');
$this->db->from('group_permissions');
$this->db->join('group_members', 'group_permissions.group_id = group_members.group_id');
$this->db->where('group_members.user_id', $user);
$this->db->where('group_permissions.granted', true);
$this->db->group_by('group_permissions.group_id');
results in:
SELECT `SUM(`group_permissions`.`permission`)` AS permissions FROM (`group_permissions`) JOIN `group_members` ON `group_permissions`.`group_id` = `group_members`.`group_id` WHERE `group_members`.`user_id` = '57' AND `group_permissions`.`granted` = 1 GROUP BY `group_permissions`.`group_id`;
I guess this is fixed with the similar issue reported by someone else... Also when it's fixed I expect my $this->db->select('COUNT(something) AS amount'); to work
