$arQuery = $DB->ParseSQLBatch(str_replace("\r", "", $query));
foreach ($arQuery as $i => $sql) {
$dbr = $DB->Query($sql, true);
if (!$dbr) {
$arErrors[$i] = $DB->GetErrorMessage();
}
}
if (count($arErrors) <= 0) {
$exec_time = round(getmicrotime() - $first, 5);
$rsData = new CAdminResult($dbr, $sTableID);
$message = new CAdminMessage(array("MESSAGE" => GetMessage("SQL_SUCCESS_EXECUTE"), "DETAILS" => GetMessage("SQL_EXEC_TIME") . "<b>" . $exec_time . "</b> " . GetMessage("SQL_SEC"), "TYPE" => "OK", "HTML" => true));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->bPostNavigation = true;
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("SQL_PAGES")));
$intNumFields = $rsData->FieldsCount();
$i = 0;
$header = array();
$arFieldName = array();
while ($i < $intNumFields) {
$header[] = array("id" => $rsData->FieldName($i), "content" => $rsData->FieldName($i), "sort" => $rsData->FieldName($i), "default" => true, "align" => "left", "valign" => "top");
$arFieldName[] = $rsData->FieldName($i);
$i++;
}
$lAdmin->AddHeaders($header);
$j = 0;
while ($db_res = $rsData->Fetch()) {
$row =& $lAdmin->AddRow("ID", $db_res);
foreach ($arFieldName as $field_name) {
$row->AddViewField($field_name, TxtToHtml($db_res[$field_name]));
}
