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);