Changeset 1187 for trunk/wifidog-auth/wifidog/classes/Node.php

Timestamp:

02/25/07 13:50:18 (5 years ago)

Author:

benoitg

Message:

2007-02-24 Damien Raude-Morvan <drazzib@…>

• Fix main SQL request in Node::getSelectNodeUI() to use table alias in ORDER BY and SELECT. This disambiguation is necessary when using a join on a table containing another 'node_id' field.

Files:

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

trunk/wifidog-auth/wifidog/classes/Node.php

@@ -295 +295 @@
             );
 
-            $sql = "SELECT node_id, name, gw_id, node_deployment_status, is_splash_only_node from nodes $sql_additional_join WHERE 1=1 $sql_additional_where ORDER BY lower(node_id)";
+            $sql = "SELECT nodes.node_id, nodes.name, nodes.gw_id, nodes.node_deployment_status, nodes.is_splash_only_node from nodes $sql_additional_join WHERE 1=1 $sql_additional_where ORDER BY lower(nodes.node_id)";
             $node_rows = null;
             $db->execSql($sql, $node_rows, false);