public static function findByCP($connectionId, $parameterName)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_connection_parameter.connection_id as connection_id, ' . 'guacamole_connection_parameter.parameter_name as parameter_name, ' . 'guacamole_connection_parameter.parameter_value as parameter_value ' . ' FROM guacamole_connection_parameter' . ' WHERE guacamole_connection_parameter.connection_id = ? AND LOWER(guacamole_connection_parameter.parameter_name) = LOWER(?)', array('is', &$connectionId, &$parameterName));
$guacamoleConnectionParameter = new Guacamole_Connection_Parameter();
if (sizeof($data) > 0) {
$guacamoleConnectionParameter->hydrate($data[0]);
} else {
$guacamoleConnectionParameter = null;
}
return $guacamoleConnectionParameter;
}
public static function findByUsername($username)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_user.user_id as user_id, ' . 'guacamole_user.username as username, ' . 'guacamole_user.password_hash as password_hash, ' . 'guacamole_user.password_salt as password_salt, ' . 'guacamole_user.disabled as disabled, ' . 'guacamole_user.expired as expired, ' . 'guacamole_user.access_window_start as access_window_start, ' . 'guacamole_user.access_window_end as access_window_end, ' . 'guacamole_user.valid_from as valid_from, ' . 'guacamole_user.valid_until as valid_until, ' . 'guacamole_user.timezone as timezone ' . ' FROM guacamole_user' . ' WHERE LOWER(guacamole_user.username) = LOWER(?)', array('s', &$username));
$guacamoleUser = new Guacamole_User();
if (sizeof($data) > 0) {
$guacamoleUser->hydrate($data[0]);
} else {
$guacamoleUser = null;
}
return $guacamoleUser;
}
public static function findByUCP($userId, $connectionId, $permission)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_connection_permission.user_id as user_id, ' . 'guacamole_connection_permission.connection_id as connection_id, ' . 'guacamole_connection_permission.permission as permission ' . ' FROM guacamole_connection_permission' . ' WHERE guacamole_connection_permission.user_id = ? AND guacamole_connection_permission.connection_id = ? AND LOWER(guacamole_connection_permission.permission) = LOWER(?)', array('iis', &$userId, &$connectionId, &$permission));
$guacamoleConnectionPermission = new Guacamole_Connection_Permission();
if (sizeof($data) > 0) {
$guacamoleConnectionPermission->hydrate($data[0]);
} else {
$guacamoleConnectionPermission = null;
}
return $guacamoleConnectionPermission;
}
public static function findByCP($connectionName, $protocol)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_connection.connection_id as connection_id, ' . 'guacamole_connection.connection_name as connection_name, ' . 'guacamole_connection.parent_id as parent_id, ' . 'guacamole_connection.protocol as protocol, ' . 'guacamole_connection.max_connections as max_connections, ' . 'guacamole_connection.max_connections_per_user as max_connections_per_user ' . ' FROM guacamole_connection' . ' WHERE LOWER(guacamole_connection.connection_name) = LOWER(?) AND LOWER(guacamole_connection.protocol) = LOWER(?)', array('ss', &$connectionName, &$protocol));
$guacamoleConnection = new Guacamole_Connection();
if (sizeof($data) > 0) {
$guacamoleConnection->hydrate($data[0]);
} else {
$guacamoleConnection = null;
}
return $guacamoleConnection;
}
