$log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Debug Option missing or invalid.');
} else {
if ($opt_debugLog == 'False') {
$log->opt_debug = false;
} else {
$log->opt_debug = true;
}
}
$opt_logLoc = $sql->getOption('Log_File_Location');
if ($opt_logLoc === false) {
$log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Log_File_Location Option missing or invalid.');
} else {
$log->set_log_location($opt_logLoc);
}
$runLevel = $sql->verifySID($sessionID, "1");
$arr = $sql->gatherSQLCredentials();
$query = array("USE master", "ALTER DATABASE IMS SET SINGLE_USER WITH ROLLBACK IMMEDIATE", "RESTORE DATABASE IMS FROM DISK = N" . $arr["location"], "ALTER DATABASE IMS SET MULTI_USER");
$conn = sqlsrv_connect($arr["servername"], array('UID' => $arr["username"], 'PWD' => $arr["password"], 'Database' => $arr["db"], 'CharacterSet' => 'UTF-8'));
if (!$conn) {
print_r(sqlsrv_errors());
exit;
}
sqlsrv_configure("WarningsReturnAsErrors", 0);
foreach ($query as $current) {
if ($stmt = sqlsrv_query($conn, $current)) {
do {
echo "\n";
if (($errors = sqlsrv_errors()) != null) {
foreach ($errors as $error) {
//echo ("SQLSTATE: ".$error[ 'SQLSTATE']."\n");
$dataArray .= "SQLSTATE: " . $error['SQLSTATE'] . "\n";
