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'"); } }