root/wifidog/tags/wifidog-auth_1.0/node_export3.php

<?php
/**
 * Permet d'afficher les statuts du r?seau.
 *
 * @author    Thus0 <thus0@free.fr>
 * @author    prospere@nantes-wireless.org
 * @author    pascal.rullier@wireless-fr.org
 * @copyright    2007 Thus0
 * @link    http://auth.wireless-fr.org/
 */

/**
 * Load required files
 */
require_once(dirname(__FILE__) . '/include/common.php');

require_once('include/common_interface.php');
require_once('classes/Network.php');
require_once('classes/Node.php');
require_once('classes/NodeList.php');

global $db;
$body_html = "<div id=\"node_export\">";
$network = "";

if (!empty ($_REQUEST['format'])) {
  $format = $db->escapeString($_REQUEST['format']);
} else {
  $format = "JavaScript";
}

if (!empty ($_REQUEST['gw_id'])) {
  try {
    $node = Node::getObject($db->escapeString($_REQUEST['gw_id']));
    $network = $node->getNetwork();
  } catch (Exception $e) {
    exit;
  }
} else {
  $node = "";
}

if (!empty ($_REQUEST['network_id'])) {
  try {
    $network = Network::getObject($db->escapeString($_REQUEST['network_id']));
  } catch (Exception $e) {
    exit;
  }
} else {
  // $network = Network::getDefaultNetwork(true);
}


if ($node) {
  $body_html .= "<div id=\"node_status\">";
  $body_html .= "  <div id=\"node_status_title\">" . $node->getName() . "</div>";
  $body_html .= "</div>";

  $body_html .= "<div id=\"node_users_status\">";
  $body_html .= "  <div id=\"node_users_status_title\"><a href=\"http://auth.wireless-fr.org/node_status.php\">Utilisateurs connect&eacute;s en WiFi : ";

  $online_users = $node->getOnlineUsers();
  $num_online_users = count($online_users);
  
  $body_html .= $num_online_users . "</a>";
  $body_html .= "  </div>";
  
  $body_html .= "  <div id=\"network_users_list\">";
  $body_html .= "    <ul> ";
  
  $numUser = 0;
  if ($online_users != null){
    foreach ($online_users as $online_user) {
      $numUser++;
      //$body_html .= "    <li>$online_user[username]</li>";
      if ($numUser == $num_online_users) {
        $body_html .= $online_user->getUserName();
      } else {
        $body_html .= $online_user->getUserName() . " - ";
      } 
    }
  } else {
    // $body_html .= "<li>Aucune personne</li>";
  }

  $body_html .= "    </ul>";
  $body_html .= "  </div>";
  $body_html .= "</div>";
}

if ($network) {
  $body_html .= "<div id=\"network_status\">";
  $body_html .= "  <div id=\"network_status_title\">" . $network->getName() . "</div>";
  $body_html .= "  <div id=\"network_nodes_deployed\">D&eacute;ploy&eacute;s&nbsp;:&nbsp;" . $network->getNumDeployedNodes() . "</div>";
  $body_html .= "  <div id=\"network_nodes_online\">En&nbsp;fonctionnement&nbsp;:&nbsp;" . $network->getNumOnlineNodes() . "</div>";

  $body_html .= "<div id=\"network_users_status\">";
  $body_html .= "  <div id=\"network_users_status_title\"><a href=\"http://auth.wireless-fr.org/node_status.php\">Utilisateurs connect&eacute;s en WiFi : ";

  $online_users = null;
  $db->execSql("SELECT username,nodes.node_id FROM connections,users,nodes WHERE token_status='".TOKEN_INUSE."' AND users.user_id=connections.user_id AND nodes.node_id=connections.node_id AND nodes.network_id='".$network->getId()."' ORDER BY account_origin, timestamp_in DESC", $online_users);
  
  $Network_OnlineUsers = count($online_users);

  $body_html .= $Network_OnlineUsers . "</a>";
  $body_html .= "  </div>";

  $body_html .= "  <div id=\"users_list\">";
  $body_html .= "    <ul> ";

  $numUser = 0;
  if ($online_users != null){
    foreach ($online_users as $online_user) {
      $numUser++;
      //$body_html .= "    <li>$online_user[username]</li>";
      if ($numUser == $Network_OnlineUsers) {
        $body_html .= "$online_user[username]";
      } else {
        $body_html .= "$online_user[username] - ";
      } 
    }
  } else {
    // $body_html .= "<li>Aucune personne</li>";
  }

  $body_html .= "    </ul>";
  $body_html .= "  </div>";
  $body_html .= "</div>";
  $body_html .= "</div>";

}

$network_array = Network::getAllNetworks();
$network_list = array();

$All_DeployedNodes=0;
$All_OnlineNodes=0;
$All_OnlineUsers=0;

foreach ($network_array as $network)
{
        $All_DeployedNodes +=$network->getNumDeployedNodes();
    $All_OnlineNodes +=$network->getNumOnlineNodes();
}

$body_html .= "<div id=\"nodes_status\">";
$body_html .= "  <div id=\"nodes_status_title\">France Wireless</div>";
$body_html .= "  <div id=\"nodes_deployed\">D&eacute;ploy&eacute;s&nbsp;:&nbsp;" . $All_DeployedNodes . "</div>";
$body_html .= "  <div id=\"nodes_online\">En&nbsp;fonctionnement&nbsp;:&nbsp;" . $All_OnlineNodes . "</div>";


$body_html .= "<div id=\"users_status\">";
$body_html .= "  <div id=\"users_status_title\"><a href=\"http://auth.wireless-fr.org/node_status.php\">Utilisateurs connect&eacute;s en WiFi : ";


$online_users = null;
$db->execSql("SELECT username,nodes.node_id,nodes.name FROM connections,users,nodes WHERE token_status='".TOKEN_INUSE."' AND users.user_id=connections.user_id AND nodes.node_id=connections.node_id ORDER BY account_origin, timestamp_in DESC", $online_users);

$All_OnlineUsers = count($online_users);

$body_html .= $All_OnlineUsers . "</a>";
$body_html .= "  </div>";

$body_html .= "  <div id=\"users_list\">";
$body_html .= "    <ul> ";

$numUser = 0;

if ($online_users != null){
  foreach ($online_users as $online_user) {
    $numUser++;
    //$body_html .= "    <li>$online_user[username]</li>";
    if ($numUser == $All_OnlineUsers) {
      $body_html .= "$online_user[username]";
    } else {
      $body_html .= "$online_user[username] - ";
    } 
  }
} else {
  //   $body_html .= "<li>Aucune personne</li>";
}

$body_html .= "    </ul>";
$body_html .= "  </div>";
$body_html .= "</div>";
$body_html .= "</div>";

$body_html .= "</div>";
$body_html .= "</div>";

if ($format == "JavaScript") {
  echo "document.write('".$body_html."');";
} else {
  echo $body_html;
}

?>