Show
Ignore:
Timestamp:
03/03/10 19:27:35 (2 years ago)
Author:
gbastien
Message:

* Modifs on the token architecture: some corrections to connection and token deletions and garbage collection because token are now reusable

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • branches/newtoken/wifidog/include/common.php

    r1446 r1455  
    182182    $sql = null; 
    183183    $sql .= "BEGIN;\n";  
    184     $sql .= "UPDATE connections SET logout_reason=" . LOGOUT_REASON_GARBAGE_COLLECTED . ", timestamp_out=(CURRENT_TIMESTAMP - interval '$expiration') FROM tokens WHERE connections.token_id=tokens.token_id AND last_updated < (CURRENT_TIMESTAMP - interval '$expiration') AND token_status = '" . TOKEN_INUSE . "';"; 
    185     $sql .= "UPDATE tokens SET token_status='" . TOKEN_USED . "' FROM connections WHERE connections.token_id=tokens.token_id AND last_updated < (CURRENT_TIMESTAMP - interval '$expiration') AND token_status = '" . TOKEN_INUSE . "';"; 
     184    $sql .= "UPDATE connections SET logout_reason=" . LOGOUT_REASON_GARBAGE_COLLECTED . ", timestamp_out=(CURRENT_TIMESTAMP - interval '$expiration') FROM tokens WHERE connections.token_id=tokens.token_id AND timestamp_out is null AND last_updated < (CURRENT_TIMESTAMP - interval '$expiration') AND token_status = '" . TOKEN_INUSE . "';"; 
     185    $sql .= "UPDATE tokens SET token_status='" . TOKEN_USED . "' FROM (select token_id, max(last_updated) as last_updated from connections group by token_id) conn WHERE conn.token_id=tokens.token_id AND last_updated < (CURRENT_TIMESTAMP - interval '$expiration') AND token_status = '" . TOKEN_INUSE . "';"; 
    186186    $sql .= "COMMIT;\n"; 
    187187    $db->execSqlUpdate($sql, false);