function import_sql($source, $result_code = 'import_ok')
{
global $modx, $e;
$tbl_active_users = $modx->getFullTableName('active_users');
$rs = $modx->db->select('count(*)', $tbl_active_users, "action='27'");
if (0 < $modx->db->getValue($rs)) {
$modx->webAlertAndQuit("Resource is edit now by any user.");
}
$settings = getSettings();
if (strpos($source, "\r") !== false) {
$source = str_replace(array("\r\n", "\n", "\r"), "\n", $source);
}
$sql_array = preg_split('@;[ \\t]*\\n@', $source);
foreach ($sql_array as $sql_entry) {
$sql_entry = trim($sql_entry, "\r\n; ");
if (empty($sql_entry)) {
continue;
}
$rs = $modx->db->query($sql_entry);
}
restoreSettings($settings);
$modx->clearCache();
$_SESSION['last_result'] = $modx->db->makeArray($rs);
$_SESSION['result_msg'] = $result_code;
}
function import_sql($source, $result_code = 'import_ok')
{
global $modx, $e;
$rs = $modx->db->select('*', '[+prefix+]active_users', "action='27'");
if (0 < $modx->db->getRecordCount($rs)) {
include_once "header.inc.php";
// start normal header
$e->setError(5, 'Resource is edit now by any user');
$e->dumpError();
exit;
}
$settings = getSettings();
$source = str_replace(array("\r\n", "\n", "\r"), "\n", $source);
$sql_array = preg_split('@;[ \\t]*\\n@', $source);
foreach ($sql_array as $sql_entry) {
$sql_entry = trim($sql_entry, "\r\n; ");
if (empty($sql_entry)) {
continue;
}
$rs = $modx->db->query($sql_entry);
}
restoreSettings($settings);
$modx->clearCache();
if (0 < $modx->db->getRecordCount($rs)) {
while ($row = $modx->db->getRow($rs)) {
$_SESSION['last_result'][] = $row;
}
}
$_SESSION['result_msg'] = $result_code;
}
