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'");
}
}
if ($importFile != "error" || $sid == 999) {
echo "<br>Importing {$importFile} to database<br>";
$in = fopen($importFile, "r") or die("can't open file r: {$importFile}");
while (!feof($in)) {
$row = fgets($in);
//echo("$row<br/>");
sscanf($row, "%d:%d:%d %f %f", $hour, $min, $sec, $data, $delay);
//echo("$sid $yy-$mm-$dd $hour:$min:$sec,$data,$delay<br>");
$timestamp = date('Y-m-d G:i:s', mktime($hour, $min, $sec, $mm, $dd, $yy));
//echo("$sid $data $timestamp<br>");
if ($g_dbM2) {
$tableName = SXN_COLLECTOR_TABLE_DATA_PREFIX . $sid;
//$doesTableExist = $this->mysqli_->query("SELECT 1 FROM $tableName");
//$doesTableExist = $g_dbM2->selectAllFromTable($tableName, $conditions);
$g_dbM1->selectAllFromTable(SXN_ADMIN_TABLE_STREAMS, SXN_ADMIN_STREAMS_COLUMN_SID . " = {$sid}");
$doesSidExist = $g_dbM1->retrieveNumberOfResults();
//$g_dbM2->checkIfValueExists(SXN_ADMIN_TABLE_USERS,SXN_ADMIN_USERS_COLUMN_NAME,$name) == false
if ($doesSidExist) {
//echo "Sid is ok! data=$data time=$timestamp \n";
$valueArray = array($data, $timestamp);
$columnArray = array(SXN_COLLECTOR_DATA_COLUMN_VALUE, SXN_GENERAL_COLUMN_TIMESTAMP);
$g_dbM2->insertRow($tableName, $columnArray, $valueArray);
//return true;
} else {
echo "Sid does not exists! ({$doesSidExist})\n";
}
} else {
echo "-Database is not open. Data not added!\n";
}
}
fclose($in);