index.php

<?php
//require_once('sxn_definition.php');
require_once('sxn_sql_lib.php');
require_once('sxn_lib.php');
require_once('sxn_sidFunctions.php');
//define ("DEBUG_MODE", "on", true);

//==============================================================================
//Class DataManager
//==============================================================================
class DataCollector
{

	private $username_;
	private $password_;
	private $server_;  
	private $dbName_;  
	private $mysqli_; 
	private $isDbOpen_;

	public function __construct($user, $pass, $server, $dbName)
	{
		if(DEBUG_MODE == 'on')echo "-SXN_DATABASE_COLLECTOR created \n";
		$this->username_   = $user;
		$this->password_   = $pass;
		$this->server_     = $server;
		$this->dbName_     = $dbName;
		$this->isDbOpen_   = false;
	}

	public function __destruct()
	{
		$this->closeDataBase();
		if(DEBUG_MODE == 'on')echo "-DataManager destroyed \n";
	}

	public function openDataBase()
	{
		if(DEBUG_MODE == 'on')echo "-Opening database\n";

		$this->mysqli_ = new mysqli($this->server_,
									$this->username_,
									$this->password_,
									$this->dbName_);
		if ($this->mysqli_->connect_error) 
		{
			if(DEBUG_MODE == 'on')echo "-Problem opening database\n";
		}
		else
		{
			$this->isDbOpen_ = true;
		}
	}

	public function closeDataBase()
	{
		if(DEBUG_MODE == 'on')echo "-Closing database\n ";
		$this->mysqli_->close();
	}

	public function insertData($sid, $data)
	{	
		if ($this->isDbOpen_)
		{
			$tableName = SXN_COLLECTOR_TABLE_DATA_PREFIX . $sid;
			$doesTableExist = $this->mysqli_->query("SELECT 1 FROM $tableName");

			if ($doesTableExist)
			{
				if(DEBUG_MODE == 'on')echo "Sid=$sid is ok! data=$data\n";
			    $param = SXN_COLLECTOR_DATA_COLUMN_VALUE;
				$this->mysqli_->query("INSERT INTO $tableName ($param) VALUES ($data)");

				return true;
			}
			else
			{
				if(DEBUG_MODE == 'on')echo "Sid=$sid does not exists! \n";
				
			}
		}
		else
		{
			if(DEBUG_MODE == 'on')echo "-Database is not open. Data not added!\n";

		}
		return false;
	}


}

//=======================================
function getControlMessage($sid) 
//=======================================
{
 
	$dbM = new DataManager   (SXN_USER, SXN_PASSWORD, "localhost", SXN_DATABASE_CONTROL);
	$dbM->selectAllFromTable(SXN_CONTROL_TABLE_COMMANDS,
							 SXN_CONTROL_COMMANDS_COLUMN_SID."="."$sid AND ".
							 SXN_CONTROL_COMMANDS_COLUMN_STATUS."="."'new'"); //TODO add enum table for new, etc..

	$numRes = $dbM->retrieveNumberOfResults();

	if($numRes>0)
	{
		while($data = $dbM->retrieveResult())
		{
		    echo " :".$data[SXN_CONTROL_COMMANDS_COLUMN_COMMAND]."\n";
		}

		//Update status to "executed"
		$columns = array(SXN_CONTROL_COMMANDS_COLUMN_STATUS);
		$values  = array("executed");
		$dbM->updateRow(SXN_CONTROL_TABLE_COMMANDS, $columns, $values, 
						SXN_CONTROL_COMMANDS_COLUMN_SID."="."$sid AND "
						.SXN_CONTROL_COMMANDS_COLUMN_STATUS."="."'new'");
	}
}
//=======================================
function setClientStatus($sid,$name,$ip,$appid)
//======================================= 
{
	if(!$name) $name   = "noName";
	if(!$ip) $ip       = "noIp";
	if(!$appid) $appid = "noAppid";
	
   	if($sid > 0)
   		$filename = 'ip/'.$name.$sid.'.ip';
   	else
   		$filename = 'ip/'.$name.'.ip';
   		
   	$now  = date("Y-m-d H:i:s");
   	$cont = $sid.' '.$appid.' '.$ip.' '.$now;
   	if (file_exists($filename))
   	{
      		$fh = fopen($filename, "w");
      		fwrite($fh, $cont);
      		fclose($fh);
   	}
    	else
     	{
      		$fh = fopen($filename, "w");
      		fwrite($fh, $cont);
      		fclose($fh);
      		chmod($filename,0777);
     	}              
}
//==============================================================================
// Main program
//==============================================================================

if(isset($_GET['mid']))
{
	//Data from request
    	$mid   = $_GET["mid"];
    	$name  = $_GET["name"];
    	$ip    = $_GET["ip"];
    	$appid = $_GET["appid"];
    	
    	if($mid == SXN_BEACON)
    	{
    		setClientStatus(0,$name,$ip,$appid);
    		die();
    	}
    	if($mid == SXN_CLIENT_STATUS)
        { 
        	setClientStatus(0,$name,$ip,$appid);
            	echo("CLIENT ");
        	system("ls *.ip > ipList.work"); 
		lib_listIpFiles(2,"ipList.work"); 
                echo(" STATUS");
                die();
        }
        
    	$nsid = $_GET["nsid"];

   	if($nsid > 9 || $nsid < 1) die;

   	if($nsid > 0) {$msid[1]  = $_GET["sid1"];}
   	if($nsid > 1) {$msid[2]  = $_GET["sid2"];}
   	if($nsid > 2) {$msid[3]  = $_GET["sid3"];}
   	if($nsid > 3) {$msid[4]  = $_GET["sid4"];}
   	if($nsid > 4) {$msid[5]  = $_GET["sid5"];}
   	if($nsid > 5) {$msid[6]  = $_GET["sid6"];}
   	if($nsid > 6) {$msid[7]  = $_GET["sid7"];}
   	if($nsid > 7) {$msid[8]  = $_GET["sid8"];}
   	if($nsid > 8) {$msid[9]  = $_GET["sid9"];}
    
        $dat[1]  = $_GET["dat1"];
        $dat[2]  = $_GET["dat2"];
        $dat[3]  = $_GET["dat3"];
        $dat[4]  = $_GET["dat4"];
        $dat[5]  = $_GET["dat5"];
        $dat[6]  = $_GET["dat6"];
        $dat[7]  = $_GET["dat7"];
        $dat[8]  = $_GET["dat8"];
        $dat[9]  = $_GET["dat9"];

    	for($ii=1;$ii<=$nsid;$ii++)
    	{
	   	$sid = $msid[$ii];
           	$dd  = $dat[$ii];
           	if($mid == SXN_DATA || $mid == SXN_MAILBOX)setClientStatus($sid,$name,$ip,$appid);
	   	$dbM = new DataManager   (SXN_USER, SXN_PASSWORD, "localhost", SXN_DATABASE_ADMIN);
	   	$dbM->selectAllFromTable(SXN_ADMIN_TABLE_STREAMS,SXN_ADMIN_STREAMS_COLUMN_SID."=".$sid); 
  
	   	$numRes = $dbM->retrieveNumberOfResults();
 
	   	if($numRes == 1)
	   	{
          		while($data = $dbM->retrieveResult())
          		{   
				if($mid == SXN_DATA)
				{
                   			$tag = $data[SXN_ADMIN_STREAMS_COLUMN_TAG];
                   			//if($tag) $name = $tag;
                  			//echo SXN_USER, SXN_PASSWORD, \"localhost\", SXN_DATABASE_COLLECTOR)";
		   			$dbC = new DataCollector (SXN_USER, SXN_PASSWORD, "localhost", SXN_DATABASE_COLLECTOR);
					$dbC->openDataBase();
					$success = $dbC->insertData($sid, $dd);
	           			echo "$sid $dd DATA";
                   			lib_executeSidFunction($sid);
                   			getControlMessage($sid);
				}
              
             			if($mid == SXN_LATEST)
             			{
                			$value = lib_getLatestValue($sid);
                 			echo("$sid:$value:LATEST");
             			}
             			if($mid == SXN_DERLATEST)
             			{
                			$value = lib_getLatestDerivative($sid);
                			echo("$sid:$value:DERLATEST");
             			}
             			if($mid == SXN_MAILBOX)
             			{ 
                			lib_executeSidFunction($sid);
                			getControlMessage($sid);
                			echo("$sid $value MAILBOX");
             			}
			}
		}
    	}
}
else
{
	if(DEBUG_MODE == 'on')echo "- Not a valid request, die \n";
	echo date("Y-m-d H:i:s");
	die();
}

?>