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;
}
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
$connectionContainer->setProtocol('ssh');
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Type d'IHM inconnu...");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
exit;
}
}
$idConnectContainer = Guacamole_ConnectionDAL::insertOnDuplicate($connectionContainer);
if (!is_null($idConnectContainer)) {
//Si création de connection guaca ok
//======créer les parameter de la connection guaca=====/
$paramConnectContainer = new Guacamole_Connection_Parameter();
$paramConnectContainer->setConnection($idConnectContainer);
if ($ihm == 'no') {
//set le paramètre color-scheme
$paramConnectContainer->setParameterName("color-scheme");
$paramConnectContainer->setParameterValue("green-black");
$validInsertParamUsername = Guacamole_Connection_ParameterDAL::insertOnDuplicate($paramConnectContainer);
if (!is_null(Guacamole_Connection_ParameterDAL::findByCP($paramConnectContainer->getConnection()->getConnectionId(), $paramConnectContainer->getParameterName()))) {
$newLog->setLevel("INFO");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Paramètre 'color-scheme' = 'green-black' de la connection (connection n°" . $idConnectContainer . ") correctmeent ajoutée.");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$connectionContainer->setProtocol('ssh');
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Type d'IHM inconnu... Si vous voyez ce message, posez-vous des questions...");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
//Arret
exit;
}
}
$idConnectContainer = Guacamole_ConnectionDAL::insertOnDuplicate($connectionContainer);
if (!is_null($idConnectContainer)) {
//Si création de connection guaca ok
//======créer les parameter de la connection guaca=====/
$paramConnectContainer = new Guacamole_Connection_Parameter();
$paramConnectContainer->setConnection($idConnectContainer);
//set le paramètre username
$paramConnectContainer->setParameterName("username");
$paramConnectContainer->setParameterValue("root");
$validInsertParamUsername = Guacamole_Connection_ParameterDAL::insertOnDuplicate($paramConnectContainer);
if (!is_null(Guacamole_Connection_ParameterDAL::findByCP($paramConnectContainer->getConnection()->getConnectionId(), $paramConnectContainer->getParameterName()))) {
$newLog->setLevel("INFO");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Paramètre username = root de la connection (connection n°" . $idConnectContainer . ") correctmeent ajoutée.");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Paramètre username = root de la connection (connection n°" . $idConnectContainer . ") non ajoutée, erreur...");
