<?php
ini_set("memory_limit", "30M");
require_once 'config.php';
require_once 'common.php';
require_once 'functions.php';
dashboardInit();
$runIDform = isset($_GET['runID']) ? $_GET['runID'] : null;
list($data['host']['ip'], $data['host']['client'], $data['host']['hostnameID'], $data['host']['hostname']) = getMachineInfo($runIDform);
$sql = "select " . "runs.runID, " . "runs.runLogPath, " . "runs.runExecuteMethod, " . "runs.runComment, " . "runPurposes.runPurpose, " . "date_format(runs.startedRun, '%b %D, %Y %r'), " . "date_format(runs.finishedRun, '%b %D, %Y %r'), " . "TIMEDIFF(runs.finishedRun,runs.startedRun), " . "pataBranches.branchName, " . "pataBranches.branchDir, " . "runStatus.runStatus, " . "concat(users.first,' ',users.last) as userName, " . "versions.buildNum, " . "versions.versionDottedQuad, " . "hostnames.hostname " . "from " . "runPurposes, " . "hostnames, " . "runs, " . "runStatus, " . "users, " . "versions, " . "pataBranches " . "where " . "runs.runID = {$runIDform} and " . "runs.runPurposeID = runPurposes.runPurposeID and " . "runs.runMachineID = hostnames.hostnameID AND " . "runs.runner = users.userID and " . "runs.versionID = versions.versionID and " . "runs.pataBranchID = pataBranches.pataBranchID and " . "runs.runStatusID = runStatus.runStatusID";
list($runData['runID'], $runData['logPath'], $runData['executeMethod'], $runData['runComment'], $runData['runPurpose'], $runData['startedRun'], $runData['finishedRun'], $runData['timeToRun'], $runData['branchName'], $runData['branchDir'], $runData['runStatus'], $runData['userName'], $runData['buildNum'], $runData['version'], $runData['hostname']) = sqlSingleRow($sql);
$runData['executeMethod'] = preg_replace("/(scpFtpPassword) (.*) (-path)/", '$1 **** $3', $runData['executeMethod']);
$sql = "select " . "scriptResults.scriptResultID, " . "scriptResults.scriptCommandLine, " . "scriptResults.scriptLogLocation, " . "scriptResults.scriptLogFile, " . "scripts.script, " . "scripts.scriptSynopsis " . "from " . "runs, " . "scripts, " . "scriptResults " . "where " . "scriptResults.scriptID = scripts.scriptID and " . "scriptResults.runID = {$runIDform} and " . "runs.runID = {$runIDform} " . "ORDER BY " . "scriptResults.scriptResultID DESC";
// establish connection to DB
$linkID = connectDB();
$result = mysql_query($sql);
if ($result) {
while ($myrow = mysql_fetch_assoc($result)) {
$data[scriptIDs][$myrow['scriptResultID']][scriptResultID] = $myrow['scriptResultID'];
$data[scriptIDs][$myrow['scriptResultID']][scriptName] = $myrow['script'];
$data[scriptIDs][$myrow['scriptResultID']][scriptSynopsis] = $myrow['scriptSynopsis'];
$data[scriptIDs][$myrow['scriptResultID']][logFile] = $runData['logPath'] . "/";
if ($myrow['scriptLogLocation'] != "") {
$data[scriptIDs][$myrow['scriptResultID']][logFile] .= "/" . $myrow['scriptLogLocation'] . "/";
}
$data[scriptIDs][$myrow['scriptResultID']][logFile] .= $myrow['scriptLogFile'];
$cmdLine = preg_replace("/-testbed\\s+\\w+/", "", $myrow['scriptCommandLine']);
$cmdLine = preg_replace("/(scpFtpPassword) (.*) (-path)/", '$1 **** $3', $cmdLine);
#$cmdLine = preg_replace("/-FILE\.\w+\s+\S+/", "", $cmdLine);
#$cmdLine = preg_replace("/-PATA_IMAGE\s+\S+/", "", $cmdLine);
$data[scriptIDs][$myrow['scriptResultID']][commandLine] = $cmdLine;
function getMachineInfo($runID)
{
# getting the server this was run on...
$hostname = "select " . "IPInterfaces.IPAddr, " . "hostnames.hostnameID, " . "hostnames.hostname " . "from " . "runs, " . "hostnames, " . "hostnamesToIPs, " . "IPInterfaces " . "where " . "runs.runMachineID = hostnames.hostnameID AND " . "hostnamesToIPs.hostnameID = hostnames.hostnameID AND " . "hostnamesToIPs.IPID = IPInterfaces.IPID AND " . "IPInterfaces.primaryInterface = true AND " . "runs.runID = " . $runID;
return sqlSingleRow($hostname);
}
