summaryrefslogtreecommitdiff
path: root/includes/model/UserGroups_model.php
blob: 9d67770c8bdfe130aa265c2a6978e57e06b10cfa (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?php

use Engelsystem\Database\DB;

/**
 * Returns users groups
 *
 * @param array $user
 * @return array[]
 */
function User_groups($user)
{
    return DB::select('
          SELECT `Groups`.*
          FROM `UserGroups`
          JOIN `Groups` ON `Groups`.`UID`=`UserGroups`.`group_id`
          WHERE `UserGroups`.`uid`=?
          ORDER BY `UserGroups`.`group_id`
       ',
        [$user['UID']]
    );
}