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