src/snac/server/database/SQL.php
/**
     * Select user role record IDs
     *
     * Select all the IDs of roles for a single user. Higher level code will use each id to call
     * populateRole().
     *
     * @param int $appUserID The numeric ID for the user for whom to list roles.
     *
     * @return integer[] Return list of ID values. We expect the higher level calling code to pass each ID to
     * populateRole().
     */
Select user role record IDs
Select all the IDs of roles for a single user. Higher level code will use each id to call
populateRole().

@param int $appUserID The numeric ID for the user for whom to list roles.

@return integer[] Return list of ID values. We expect the higher level calling code to pass each ID to
populateRole().
Select user role record IDs Select all the IDs of roles for a single user . Higher level code will use each id to call populateRole () . @param int $appUserID The numeric ID for the user for whom to list roles . @return integer [] Return list of ID values . We expect the higher level calling code to pass each ID to populateRole () .
public function selectUserRoleIDs($appUserID)
    {
        $result = $this->sdb->query("select role.id from role,appuser_role_link
                                    where appuser_role_link.uid=$1 and role.id=rid order by label asc",
                                    array($appUserID));
        $all = array();
        while($row = $this->sdb->fetchrow($result))
        {
            array_push($all, $row['id']);
        }
        return $all;
    }
public function selectUserRoleIDs ( $ appUserID ) { $ result = $ this -> sdb -> query ( " select role.id from role,appuser_role_link
                                    where appuser_role_link.uid=$1 and role.id=rid order by label asc " , array ( $ appUserID ) ) ; $ all = array ( ) ; while ( $ row = $ this -> sdb -> fetchrow ( $ result ) ) { array_push ( $ all , $ row [ 'id' ] ) ; } return $ all ; }
Select user role record IDs
 Select all the IDs of roles for a single user.
Select user role record IDs Select all the IDs of roles for a single user .