root/wifidog/wifidog-auth/wifidog/ping/index.php

 <?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

// +-------------------------------------------------------------------+
// | WiFiDog Authentication Server                                     |
// | =============================                                     |
// |                                                                   |
// | The WiFiDog Authentication Server is part of the WiFiDog captive  |
// | portal suite.                                                     |
// +-------------------------------------------------------------------+
// | PHP version 5 required.                                           |
// +-------------------------------------------------------------------+
// | Homepage:     http://www.wifidog.org/                             |
// | Source Forge: http://sourceforge.net/projects/wifidog/            |
// +-------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or     |
// | modify it under the terms of the GNU General Public License as    |
// | published by the Free Software Foundation; either version 2 of    |
// | the License, or (at your option) any later version.               |
// |                                                                   |
// | This program is distributed in the hope that it will be useful,   |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of    |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the     |
// | GNU General Public License for more details.                      |
// |                                                                   |
// | You should have received a copy of the GNU General Public License |
// | along with this program; if not, contact:                         |
// |                                                                   |
// | Free Software Foundation           Voice:  +1-617-542-5942        |
// | 59 Temple Place - Suite 330        Fax:    +1-617-542-2652        |
// | Boston, MA  02111-1307,  USA       gnu@gnu.org                    |
// |                                                                   |
// +-------------------------------------------------------------------+

/**
 * This will respond to the gateway to tell them that the gateway is still up,
 * and also log the gateway checking in for network monitoring
 *
 * @package    WiFiDogAuthServer
 * @author     Alexandre Carmel-Veilleux <acv@acv.ca>
 * @copyright  2004-2006 Alexandre Carmel-Veilleux
 * @version    Subversion $Id: index.php 916 2006-01-23 05:28:15Z max-horvath $
 * @link       http://www.wifidog.org/
 */

/**
 * Raphael Jacquot 2009-01-15
 * amélioration des vérifications des entrées.
 */

/**
 * Load required files
 * connect to the database directly, get rid of the dumbass abstraction layer from hell
 */
require_once('../config.php');
$conn_string = "host=".CONF_DATABASE_HOST." dbname=".CONF_DATABASE_NAME." user=".CONF_DATABASE_USER." password=".CONF_DATABASE_PASSWORD;
$db = @ pg_pconnect($conn_string);

if ($db == FALSE) {
    // si on a un probleme, on sort sans rien faire
    error_log ("Unable to connect to database");
    exit(1);
}

echo "Pong";

// On recupere l'id de la gateway
if (array_key_exists('gw_id',$_REQUEST)) $node_id = $_REQUEST['gw_id'];
else $node_id="";

// On recupere la version de Wifidog utilisee
if (array_key_exists('HTTP_USER_AGENT',$_SERVER)) $user_agent =  $_SERVER['HTTP_USER_AGENT'];
else $user_agent="";

// On recupere le network_id
if (array_key_exists('network_id',$_REQUEST)) $network_id = $_REQUEST['network_id'];
else $network_id="";

// On recupere les coordonnees gps 
// c'est transformé en float automatiquement par php (comme ca on est tranquille)
if (array_key_exists('lat', $_REQUEST)) $lat = 0.0+$_REQUEST['lat'];
else $lat = 0.0;
if (array_key_exists('lon', $_REQUEST)) $lon=0.0+$_REQUEST['lon'];
else $lon = 0.0;

// On recupere le node name
if (array_key_exists('node_name',$_REQUEST)) $node_name = trim($_REQUEST['node_name']);
else $node_name = "";

if($node_name == "(null)") $node_name = "";

// On verifie que le noeud existe en base
$q = pg_query_params($db, "select node_id, name from nodes where node_id=$1;", array($node_id));
$numrow = pg_num_rows($q);

// Si le noeud n'existe pas 
if (($numrow == 0) && array_key_exists('prop',$_REQUEST)){
        
    /* modifications de valeurs */
    if($network_id=="") $network_id="default-network";
        if($node_name=="") $node_name="Node".$owner;

    echo "\nLe node $node_id n existe pas\n";
    // On verifie que le proprietaire est enregistre en base

    $owner = $_REQUEST['prop'];
    echo "Proprio: $owner\n";

    $q = pg_query_params($db, "select user_id from users where username=$1;", array($owner));
    $numrow = pg_num_rows($q);
   
    echo "Nbr de résultats : $numrow\n";

    // Si le proprietaire est enregistre comme utilisateur
    // normalement on ne doit en avoir qu'un seul
    if ($numrow == 1){
        echo "Proprio $owner existe\n";

        $row = pg_fetch_assoc($q);
        $user_id=$row["user_id"]; 
       
        // On ajoute le noeud a la base
        echo "Rajout du node $node_id\n";

        pg_query_params ($db, "insert into nodes(network_id, last_heartbeat_ip, last_heartbeat_timestamp, last_heartbeat_user_agent,".
            "node_id, latitude, longitude, node_deployment_status, name) values ($1, $2, CURRENT_TIMESTAMP, $3, $4, $5, $6, $7, $8);",
            array ($network_id, $_SERVER['REMOTE_ADDR'], $user_agent, $node_id, $lat, $lon, "DEPLOYED", $node_name));

        // On ajoute les droits d'administration du noeud au proprietaire
        echo "Rajout $user_id pour $node_id\n";
        pg_query_params ($db, "insert into node_stakeholders (node_id, user_id, is_owner, is_tech_officer) values ($1, $2, 'TRUE', 'FALSE');", array($node_id, $user_id));
        
    } else {
        if ($numrow==0) {
            $errmsg = sprintf("Attempting to add node %s (%s) to network %s with owner %s failed, owner does not exist",
                $node_id, $node_name, $network_id, $owner);
            error_log ($errmsg);
        } else {
            $errmsg = sprintf("CAN'T HAPPEN: found multiple (%d) users for user_id %s", $numrow, $user_id);
            error_log ($errmsg);
        }
    }

} else {
    // Le noeud existe deja en base, on met a jour ses informations

    echo "\nMise a jour des infos.\n";

    $sql = "last_heartbeat_ip='". $_SERVER['REMOTE_ADDR']. "', last_heartbeat_user_agent='$user_agent'";

        if(isset($_REQUEST['network_id'])) $sql .= ",network_id = '". $_REQUEST['network_id']. "'";

    if($lat!=0 && $lon!=0) $sql .= ", latitude=$lat, longitude=$lon";

    // change le nom du node si ca a changé
        $row = pg_fetch_assoc($q);
    $errmsg = "node_id = '".$node_id."', name = '".$row['name']."', node_name = '".$node_name."'";
    if (strcmp($row["name"], $node_name)!=0) {
        $errmsg.=" ==> name change";
        error_log ($errmsg);
    }

    $req = "update nodes set last_heartbeat_timestamp=CURRENT_TIMESTAMP, node_deployment_status='DEPLOYED', $sql where node_id='$node_id';";
        pg_query($db, $req);

}

pg_close($db);

////////////////////////////////////////////////////////////////////////
// HACK : Permet de forwarder le ping vers le serveur de la federation

//function postit($host, $url, $postdata) {
//function doResquest($host, $url){
//    $fp = pfsockopen ( $host, 80, &$errno, &$errstr, 60 );
//    if( ! $fp ) return "$errstr ($errno)<br>\n";
//    fputs ($ft,"GET /ping/index.php?$url HTTP/1.1\n");
//     fputs ($fp,"POST $url HTTP/1.1\n");
//    fputs ($fp,"Host: $host\n");
//    fputs ($fp,"User-Agent: France-Wireless Auth\n");
//    fputs ($fp,"Accept: */*\n");
//    fputs ($fp,"Content-type: application/x-www-form-urlencoded\n");
//    fputs ($fp,"Content-length: ".strlen($postdata)."\n\n");
//   fputs ($fp,"$postdata\n\n");
//    fputs ($fp,"\n");
//    $output = "";
//    while( !feof( $fp ) ) {
//        $output .= fgets( $fp, 1024);
//    }
//    fclose ( $fp);
//    return ($output);
//}

//$host = "auth.marseille-wireless.org";
//$url = "/ping/index.php";
//$url = $_SERVER['QUERY_STRING'];
//$postdata = "gw_id=".$_REQUEST['gw_id']."&prop=".$_REQUEST['prop'];
//doResquets($host, $url);

/*$gotten = postit($host, $url, $postdata);*/
//////////////////////////////////////////////////////////////////////


/*
 * Local variables:
 * tab-width: 4
 * c-basic-offset: 4
 * c-hanging-comment-ender-p: nil
 * End:
 */

?>