diff options
| -rw-r--r-- | admin/WebConsole/rest/remotepc.php | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/admin/WebConsole/rest/remotepc.php b/admin/WebConsole/rest/remotepc.php index c6dcda51..f8f3af75 100644 --- a/admin/WebConsole/rest/remotepc.php +++ b/admin/WebConsole/rest/remotepc.php @@ -187,20 +187,19 @@ EOD; CREATE EVENT e_timeout_$clntid ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL $timeout DO BEGIN - SET @clntid = NULL; + SET @action_id = NULL; UPDATE acciones SET estado = $ACCION_FINALIZADA, resultado = $ACCION_FALLIDA, descrinotificacion = 'Timeout' WHERE descriaccion = 'RemotePC Session' AND estado = $ACCION_INICIADA - AND idordenador = (SELECT @clntid := '$clntid'); - IF @clntid IS NOT NULL THEN + AND idordenador = '$clntid' + AND (SELECT @action_id := idaccion); + IF @action_id IS NOT NULL THEN UPDATE remotepc SET reserved=NOW() - INTERVAL 1 SECOND, urllogin=NULL, urllogout=NULL - WHERE id = @clntid; + WHERE id = '$clntid'; DELETE FROM acciones - WHERE idordenador = @clntid - AND descriaccion = 'RemotePC Session' - AND descrinotificacion = 'Timeout'; + WHERE idaccion = @action_id; END IF; END EOD; |