require_once 'common.php'; require_once 'functions.php'; //dashboardInit(); $queueIDform = isset($_GET['queueID']) ? $_GET['queueID'] : null; $condition[] = "runs.queueId = {$queueIDform}"; $linkID = connectDB(); $sql = "select " . "runStatus.runStatus, " . "runs.runExecuteMethod, " . "runs.runID, " . "runs.runMachineID, " . "runPurposes.runPurpose, " . "users.NTID, " . "versions.versionDottedQuad, " . "versions.buildNum " . "from " . "runs, " . "runStatus, " . "runPurposes, " . "users, " . "hostnames, " . "versions " . "where " . "runs.versionID = versions.versionID AND " . "runs.runPurposeID = runPurposes.runPurposeID AND " . "runs.runner = users.userID AND " . "runs.runMachineID = hostnames.hostnameID AND " . "runs.runStatusID = runStatus.runStatusID and " . implode(" and ", $condition) . " " . "ORDER BY " . "runs.startedRun DESC "; $result = mysql_query($sql); $data = array(); $limiteRunIDs = array(); if ($result) { while ($myrow = mysql_fetch_assoc($result)) { $data[runID][$myrow['runID']] = $myrow; $limitedRunIDs[] = $myrow['runID']; if (!isset($machine[$myrow['runMachineID']])) { list($ip, $client, $hostnameID, $hostname) = getMachineInfo($myrow['runID']); $machine[$hostnameID][ip] = $ip; $machine[$hostnameID][client] = $client; $machine[$hostnameID][hostnameID] = $hostnameID; $machine[$hostnameID][hostname] = $hostname; } $data[runID][$myrow['runID']][machineIPAddr] = $machine[$myrow['runMachineID']][ip]; $data[runID][$myrow['runID']][p4Client] = $machine[$myrow['runMachineID']][client]; $data[runID][$myrow['runID']][hostname] = $machine[$myrow['runMachineID']][hostname]; $data[runID][$myrow['runID']][scriptCount] = 0; $data[runID][$myrow['runID']][caseCount] = 0; $data[runID][$myrow['runID']][scripts][passed] = 0; } } getTestScriptResults($data, $condition, $limitedRunIDs); $smarty = new TLSmarty();
<?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;