Changeset 1455 for branches/newtoken/wifidog/classes/Node.php

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:

• branches/newtoken/wifidog/classes/Node.php (modified) (1 diff)

branches/newtoken/wifidog/classes/Node.php

@@ -1666 +1666 @@
 
     private function getOnlineUsersSql() {
-        return "SELECT users.user_id FROM users,connections JOIN tokens USING (token_id) WHERE tokens.token_status='".TOKEN_INUSE."' AND users.user_id=connections.user_id AND connections.node_id='{$this->id}'";
+        return "SELECT DISTINCT users.user_id FROM users,connections JOIN tokens USING (token_id) WHERE tokens.token_status='".TOKEN_INUSE."' AND users.user_id=connections.user_id AND connections.node_id='{$this->id}'";
+        
     }
     /**