// Get/Set Task ID - as sent from cronjob when this script is called and is stored in DB.nodes table also
$tid = $_GET['id'];
// get task details from DB
$taskResult = $db->q("SELECT * FROM tasks WHERE id = {$tid} AND status = '1'");
$taskRow = mysql_fetch_assoc($taskResult);
$command = $taskRow['catCommand'];
$taskname = $taskRow['taskname'];
// create connection report file
$reportFilename = 'compareReport' . $date . '.html';
$reportDirectory = 'compareReports';
$serverIp = getHostByName(getHostName());
// get server IP address for CLI scripts
$report = new report($config_reports_basedir, $reportFilename, $reportDirectory, $serverIp);
$report->createFile();
$title = "rConfig Report - " . $taskname;
$report->header($title, $title, basename($_SERVER['PHP_SELF']), $tid, $startTime);
$reportFail = '<font color="red">Fail</font>';
$reportPass = '******';
// Get active nodes for a given task ID
// Query to retireve row for given ID (tidxxxxxx is stored in nodes and is generated when task is created)
$getNodesSql = "SELECT id, deviceName, deviceIpAddr, deviceUsername, devicePassword, deviceEnableMode, deviceEnablePassword, nodeCatId, deviceAccessMethodId, connPort FROM nodes WHERE taskId" . $tid . " = 1 AND status = 1";
if ($result = $db->q($getNodesSql)) {
// push rows to $devices array
$devices = array();
while ($row = mysql_fetch_assoc($result)) {
array_push($devices, $row);
}
foreach ($devices as $device) {
$deviceId = $device['id'];
$command = str_replace(" ", "", $command);
$getPathSqlToday = $db->q("SELECT * FROM configs \n\t\t\t\t\t\t\t\t\t\t\t\tWHERE deviceId = {$deviceId}\n\t\t\t\t\t\t\t\t\t\t\t\tAND configFilename LIKE '%{$command}%'\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY configDate \n\t\t\t\t\t\t\t\t\t\t\t\tDESC LIMIT 1");
