Changeset 226 for trunk/wifidog-auth/wifidog/portal/index.php

Timestamp:

09/22/04 12:53:28 (9 years ago)

Author:

benoitg

Message:

2004-09-22 Benoit Gr�goire <bock@…>

• portal/index.php: Fix users appearing online at every hotspot.
• wifidog/classes/Style.php, wifidog/login/index.php: Fix some potential cache problems and help with validation.

Files:

• trunk/wifidog-auth/wifidog/portal/index.php (modified) (3 diffs)

trunk/wifidog-auth/wifidog/portal/index.php

@@ -26 +26 @@
 define('BASEPATH','../');
 require_once BASEPATH.'include/common.php';
+require_once BASEPATH.'classes/Style.php';//Required to write http headers
 require_once BASEPATH.'classes/SmartyWifidog.php';
 require_once (BASEPATH.'include/user_management_menu.php');
@@ -38 +39 @@
 
 $portal_template = $_REQUEST['gw_id'] . ".html";
-
-$db->ExecSqlUniqueRes("SELECT * FROM nodes WHERE node_id='". $db->EscapeString($_REQUEST['gw_id'])."'", $node_info);
+$node_id = $db->EscapeString($_REQUEST['gw_id']);
+$db->ExecSqlUniqueRes("SELECT * FROM nodes WHERE node_id='$node_id'", $node_info);
 if($node_info==null)
   {
@@ -54 +55 @@
 $db->ExecSql("SELECT users.user_id FROM users,connections " .
              "WHERE connections.token_status='" . TOKEN_INUSE . "' " .
-             "AND users.user_id=connections.user_id "
+             "AND users.user_id=connections.user_id AND connections.node_id='$node_id' "
              ,$users, false);
 if($users!=null)