Changeset 1088 for trunk/wifidog-auth/wifidog/classes/NodeLists/NodeListJiWireCSV.php

Timestamp:

09/02/06 23:35:06 (6 years ago)

Author:

max-horvath

Message:

"2006-09-02 Max Horvath <max.horvath@…>

• Installation script checks for PHP session extension (fixes #139)
• Removed \"Call-time pass-by-reference has been deprecated\" warnings (fixes #239)
• Revert changes of FCKeditor implementation (fixes #240)
• Fix of FCKeditor implementation, now also supports FCKeditor 2.3+ (fixes #145)
• Hotspots/Nodes? are sorted case-insensitive now (fixes #109)
• Fix #141
• templates/sites/index.tpl: fix wrong user count (fixes #236)
• Added more trash mail services to the black list (fixes #149)"

Files:

• trunk/wifidog-auth/wifidog/classes/NodeLists/NodeListJiWireCSV.php (modified) (1 diff)

trunk/wifidog-auth/wifidog/classes/NodeLists/NodeListJiWireCSV.php

@@ -100 +100 @@
 
         // Query the database, sorting by node name
-        $db->execSql("SELECT *, (NOW()-last_heartbeat_timestamp) AS since_last_heartbeat, EXTRACT(epoch FROM creation_date) as creation_date_epoch, CASE WHEN ((NOW()-last_heartbeat_timestamp) < interval '5 minutes') THEN true ELSE false END AS is_up FROM nodes WHERE network_id = '" . $db->escapeString($this->_network->getId()) . "' AND (node_deployment_status = 'DEPLOYED' OR node_deployment_status = 'NON_WIFIDOG_NODE') ORDER BY name", $this->_nodes, false);
+        $db->execSql("SELECT *, (NOW()-last_heartbeat_timestamp) AS since_last_heartbeat, EXTRACT(epoch FROM creation_date) as creation_date_epoch, CASE WHEN ((NOW()-last_heartbeat_timestamp) < interval '5 minutes') THEN true ELSE false END AS is_up FROM nodes WHERE network_id = '" . $db->escapeString($this->_network->getId()) . "' AND (node_deployment_status = 'DEPLOYED' OR node_deployment_status = 'NON_WIFIDOG_NODE') ORDER BY lower(name)", $this->_nodes, false);
     }