Changeset 1187

Show
Ignore:
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.
Location:
trunk/wifidog-auth
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/wifidog-auth/CHANGELOG

    r1185 r1187  
     12007-02-24 Damien Raude-Morvan <drazzib@drazzib.com> 
     2        * Fix main SQL request in Node::getSelectNodeUI() to use 
     3          table alias in ORDER BY and SELECT. This disambiguation 
     4          is necessary when using a join on a table containing 
     5          another 'node_id' field. 
     6 
    17 2007-02-24 Max Horvath <max.horvath@freenet.de> 
    28        * Updated dependencies list (completion of all required components) 

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

    r1173 r1187  
    295295            ); 
    296296 
    297             $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)"; 
     297            $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)"; 
    298298            $node_rows = null; 
    299299            $db->execSql($sql, $node_rows, false);