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...");