summaryrefslogtreecommitdiffstats
path: root/admin/WebConsole/rest/remotepc.php
diff options
context:
space:
mode:
authorRamón M. Gómez <ramongomez@us.es>2018-05-23 14:48:04 +0200
committerRamón M. Gómez <ramongomez@us.es>2018-05-23 14:48:04 +0200
commit9199fc761629d6ab0f117415f1052ba160ec0297 (patch)
tree9b36c4249a66ea32d2ae620acd7b0905c6dcfabe /admin/WebConsole/rest/remotepc.php
parentc870c844e42cbd68b4f277b3f6e686f4c69b8fc4 (diff)
#708: Corregir error en verificación de administrdor de UO.
Diffstat (limited to 'admin/WebConsole/rest/remotepc.php')
-rw-r--r--admin/WebConsole/rest/remotepc.php24
1 files changed, 12 insertions, 12 deletions
diff --git a/admin/WebConsole/rest/remotepc.php b/admin/WebConsole/rest/remotepc.php
index 39224636..4bf7b6b5 100644
--- a/admin/WebConsole/rest/remotepc.php
+++ b/admin/WebConsole/rest/remotepc.php
@@ -81,7 +81,7 @@ $app->post('/ous/:ouid/images/:imageid/reserve(/)', 'validateApiKey',
writeRemotepcLog($app->request()->getResourceUri(). ": Parameters: labid=$labid, maxtime=$maxtime");
// Choose older not-reserved client with image installed and get ogAdmServer data.
$cmd->texto = <<<EOD
-SELECT adm.idadministradorcentro, entornos.ipserveradm, entornos.portserveradm,
+SELECT adm.idusuario, entornos.ipserveradm, entornos.portserveradm,
ordenadores.idordenador, ordenadores.nombreordenador, ordenadores.ip,
ordenadores.mac, ordenadores.agentkey, ordenadores_particiones.numdisk,
ordenadores_particiones.numpar, aulas.idaula, aulas.idcentro
@@ -92,7 +92,7 @@ SELECT adm.idadministradorcentro, entornos.ipserveradm, entornos.portserveradm,
RIGHT JOIN ordenadores_particiones USING(idordenador)
RIGHT JOIN imagenes USING(idimagen)
LEFT JOIN remotepc ON remotepc.id=ordenadores.idordenador
- WHERE adm.idadministradorcentro = '$userid'
+ WHERE adm.idusuario = '$userid'
AND aulas.idcentro = '$ouid' AND aulas.idaula LIKE '$labid' AND aulas.inremotepc = 1
AND imagenes.idimagen = '$imageid' AND imagenes.inremotepc = 1
AND (remotepc.reserved < NOW() OR ISNULL(reserved))
@@ -103,7 +103,7 @@ EOD;
if (!$rs->Abrir()) return(false); // Error opening recordset.
// Check if user is admin and client exists.
$rs->Primero();
- if (checkAdmin($rs->campos["idadministradorcentro"]) and checkParameter($rs->campos["idordenador"])) {
+ if (checkAdmin($rs->campos["idusuario"]) and checkParameter($rs->campos["idordenador"])) {
// Read query data.
$serverip = $rs->campos["ipserveradm"];
$serverport = $rs->campos["portserveradm"];
@@ -290,13 +290,13 @@ $app->post('/ous/:ouid/labs/:labid/clients/:clntid/events', 'validateApiKey',
writeRemotepcLog($app->request()->getResourceUri(). ": Parameters: urlLogin=$urlLogin, urlLogout=$urlLogout");
// Select client data for UDS compatibility.
$cmd->texto = <<<EOD
-SELECT adm.idadministradorcentro, ordenadores.idordenador, remotepc.*
+SELECT adm.idusuario, ordenadores.idordenador, remotepc.*
FROM remotepc
RIGHT JOIN ordenadores ON remotepc.id=ordenadores.idordenador
JOIN aulas USING(idaula)
RIGHT JOIN administradores_centros AS adm USING(idcentro)
RIGHT JOIN usuarios USING(idusuario)
- WHERE adm.idadministradorcentro = '$userid'
+ WHERE adm.idusuario = '$userid'
AND idcentro = '$ouid' AND aulas.idaula ='$labid'
AND ordenadores.idordenador = '$clntid';
EOD;
@@ -305,7 +305,7 @@ EOD;
if (!$rs->Abrir()) return(false); // Error opening recordset.
// Check if user is admin and client exists.
$rs->Primero();
- if (checkAdmin($rs->campos["idadministradorcentro"]) and checkParameter($rs->campos["idordenador"])) {
+ if (checkAdmin($rs->campos["idusuario"]) and checkParameter($rs->campos["idordenador"])) {
// Check if client is reserved.
if (! is_null($rs->campos["reserved"])) {
// Updating DB if client is reserved.
@@ -381,12 +381,12 @@ $app->post('/ous/:ouid/labs/:labid/clients/:clntid/session', 'validateApiKey',
writeRemotepcLog($app->request()->getResourceUri(). ": Parameters: deadLine=$deadLine");
// Get client's data.
$cmd->texto = <<<EOD
-SELECT adm.idadministradorcentro, ordenadores.idordenador, remotepc.*
+SELECT adm.idusuario, ordenadores.idordenador, remotepc.*
FROM remotepc
RIGHT JOIN ordenadores ON remotepc.id=ordenadores.idordenador
JOIN aulas USING(idaula)
RIGHT JOIN administradores_centros AS adm USING(idcentro)
- WHERE adm.idadministradorcentro = '$userid'
+ WHERE adm.idusuario = '$userid'
AND aulas.idcentro = '$ouid' AND aulas.idaula = '$labid'
AND ordenadores.idordenador = '$clntid';
EOD;
@@ -395,7 +395,7 @@ EOD;
if (!$rs->Abrir()) return(false); // Error opening recordset.
// Check if user is admin and client exists.
$rs->Primero();
- if (checkAdmin($rs->campos["idadministradorcentro"]) and checkParameter($rs->campos["idordenador"])) {
+ if (checkAdmin($rs->campos["idusuario"]) and checkParameter($rs->campos["idordenador"])) {
// Check if client is reserved.
if (! is_null($rs->campos["urllogin"])) {
// Read query data.
@@ -479,13 +479,13 @@ $app->delete('/ous/:ouid/labs/:labid/clients/:clntid/unreserve', 'validateApiKey
// Select client data for UDS compatibility.
$cmd->texto = <<<EOD
-SELECT adm.idadministradorcentro, ordenadores.idordenador, ordenadores.ip, ordenadores.agentkey, remotepc.reserved
+SELECT adm.idusuario, ordenadores.idordenador, ordenadores.ip, ordenadores.agentkey, remotepc.reserved
FROM remotepc
RIGHT JOIN ordenadores ON remotepc.id=ordenadores.idordenador
JOIN aulas USING(idaula)
RIGHT JOIN administradores_centros AS adm USING(idcentro)
RIGHT JOIN usuarios USING(idusuario)
- WHERE adm.idadministradorcentro = '$userid'
+ WHERE adm.idusuario = '$userid'
AND idcentro = '$ouid' AND aulas.idaula ='$labid'
AND ordenadores.idordenador = '$clntid';
EOD;
@@ -494,7 +494,7 @@ EOD;
if (!$rs->Abrir()) return(false); // Error opening recordset.
// Check if user is admin and client exists.
$rs->Primero();
- if (checkAdmin($rs->campos["idadministradorcentro"]) and checkParameter($rs->campos["idordenador"])) {
+ if (checkAdmin($rs->campos["idusuario"]) and checkParameter($rs->campos["idordenador"])) {
// Check if client is reserved.
if (! is_null($rs->campos["reserved"])) {
// Read query data.