$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])); }