public static function findByUAP($userId, $affectedUserId, $permission)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_user_permission.user_id as user_id, ' . 'guacamole_user_permission.affected_user_id as affected_user_id, ' . 'guacamole_user_permission.permission as permission ' . ' FROM guacamole_user_permission' . ' WHERE guacamole_user_permission.user_id = ? AND guacamole_user_permission.affected_user_id = ? AND LOWER(guacamole_user_permission.permission) = LOWER(?)', array('iis', &$userId, &$affectedUserId, &$permission));
$guacamoleUserPermission = new Guacamole_User_Permission();
if (sizeof($data) > 0) {
$guacamoleUserPermission->hydrate($data[0]);
} else {
$guacamoleUserPermission = null;
}
return $guacamoleUserPermission;
}
