function load_view($id)
{
global $cp;
$objQueue = new Queue();
$objQueue->setUid($id);
if ($objQueue->load()) {
$cp->set_data(nl2br($objQueue->getBbs('description')));
} else {
$cp->set_data('item not found!');
}
return;
}
function saveQueue($testbed, $suite)
{
$simple = new Queue();
$_GET['build'] = $_REQUEST['versionBuild'];
$_GET['suite'] = $suite;
$_GET['command'] = 1;
$_GET['testbed'] = $testbed;
$_GET['dbResults'] = "on";
$_GET['description'] = "Automatically queue'd from Nightly Build Server";
$_GET['userName'] = "******";
$_GET['tftpIP'] = 1;
$simple->setAuto($_GET);
$simple->setUid('');
$simple->load();
$simple->add();
sleep(6);
}
function saveQueue($testbed, $suite)
{
$linkID = mysql_connect('10.65.102.22', 'root', '123456');
if (!$linkID) {
die('Could not connect: ' . mysql_error());
}
$db = mysql_select_db('autoSmoke', $linkID);
$queryPrefix = "";
if ($_GET['prefix'] != "") {
$queryPrefix = "prefix = '" . $_GET['prefix'] . "' and ";
}
$threeMinAgo = date('Y-m-d H:i:s', mktime(date("H"), date("i") - 2, date("s"), date("n"), date("j"), date("Y")));
$sql = "select * " . "from " . "queue " . "where " . "userName='******' and " . "command regexp '1' and " . "description='Automatically queue\\'d from Nightly Build Server' and " . $queryPrefix . "testbed regexp '" . $testbed . "' and " . "build regexp '" . $_GET['versionBuild'] . "' and " . "suite = 'DD:" . $suite . "' and " . "status = 2 and '" . $threeMinAgo . "' <= creationDate";
$rs = mysql_query($sql);
if (!mysql_num_rows($rs)) {
$simple = new Queue();
if ($_GET['prefix'] == "C_" || $_GET['prefix'] == "T_") {
$_GET['prefix'] = $_GET[prefix];
}
$_GET['build'] = $_GET['versionBuild'];
$_GET['suite'] = $suite;
$_GET['command'] = 1;
$_GET['testbed'] = $testbed;
$_GET['dbResults'] = "on";
$_GET['description'] = "Automatically queue'd from Nightly Build Server";
$_GET['userName'] = "******";
$_GET['tftpIP'] = 1;
// if (!preg_match ("/^5.0/", $_GET['versionBuild']) && !preg_match ("/^6.0/", $_GET['versionBuild']))
// $_GET['loadAlcatel'] = 'on';
$simple->setAuto($_GET);
$simple->setUid('');
$simple->load();
$simple->add();
sleep(1);
}
mysql_close($linkID);
}
} else {
$hasErrors = 2;
}
}
}
if ($_POST['editQualys']) {
$simple = new Queue();
$_GET['build'] = $_POST['build'] ? $_POST['build'] : $_POST['build2'];
$_GET['suite'] = "D";
$_GET['command'] = 1;
$_GET['testbed'] = "autoqualys";
$_GET['dbResults'] = "on";
$_GET['userName'] = "******";
$_GET['tftpIP'] = 1;
$simple->setAuto($_GET);
$simple->setUid('');
$simple->load();
$simple->add();
}
}
// --- LOAD Queue -----------------------------------------------
$objItemList = new Queue();
$objItemList->addWhere('((status != 5 and DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= creationDate) or ' . '(status = 5 and DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= creationDate))');
if ($_REQUEST['sTestbed']) {
$pUserName = get_magic_quotes_gpc() ? stripslashes($_REQUEST['sTestbed']) : $_REQUEST['sTestbed'];
$objItemList->addWhere('testbed = \'' . addslashes($pUserName) . '\'');
}
if ($_REQUEST['sSuite']) {
$pSuite = $_REQUEST['sSuite'];
$objItemList->addWhere('suite = \'' . $pSuite . '\'');
}
