if ($date) {
$cond_date = " AND a.`" . $date_field . "` LIKE '" . $db->escape($date) . "%'";
}
// ignore section
if (!$ignore_sub && !$user_table_mode) {
$cond_where .= " AND a.`Subdivision_ID` = '" . (int) $sub . "'";
}
if (!$ignore_cc && !$user_table_mode) {
$cond_where .= " AND a.`Sub_Class_ID` = '" . (int) $cc . "'";
}
// query_where
if ($query_where) {
$cond_where .= " AND " . $query_where;
}
if (!$ignore_all) {
$message_select = "SELECT " . $component->get_fields_query() . ($query_select ? ", " . nc_add_column_aliases($query_select) : "") . "\n FROM (`" . ($user_table_mode ? "User" : "Message" . $classID) . "` AS a\n " . ($query_from ? ", " . $query_from : "") . ")\n " . $component->get_joins() . " " . ($query_join ? " " . $query_join : "") . " WHERE 1=1 " . $cond_where . $cond_user . $cond_mod . $cond_date . "\n AND a.`" . ($user_table_mode ? "User" : "Message") . "_ID` = '" . (int) $message . "'";
} else {
$message_select = "SELECT " . $query_select . " FROM " . $query_from . ($query_join ? " " . $query_join : "") . ($query_where ? " WHERE " . $query_where : "") . ($query_group ? " GROUP BY " . $query_group : "");
}
$db->num_rows = 0;
$resMsg = $db->get_row($message_select, ARRAY_A);
if (!$db->num_rows) {
$nc_is_error = $db->is_error;
if ($nc_is_error) {
echo NETCAT_FUNCTION_FULL_SQL_ERROR_USER;
}
break;
}
/*
* в списке объектов при fs переменные экстрактятся, и соответственно не работает $result_vars
* нужно здесь тоже сделать экстракт переменных при fs
$goBackLink = $admin_url_prefix . "?catalogue=" . $catalogue . "&sub=" . $sub . "&cc=" . $cc . "&curPos=" . $curPos;
} else {
$goBackLink = ($user_table_mode ? nc_folder_url($current_sub['Subdivision_ID']) : nc_infoblock_url($current_cc['Sub_Class_ID'])) . ($curPos ? "?curPos=" . $curPos : "");
}
} else {
$goBackLink = $alter_goBackLink;
}
$goBack = "<a href=" . $goBackLink . ">" . NETCAT_MODERATION_BACKTOSECTION . "</a>";
// визуальные настройки
$cc_settings = nc_get_visual_settings($cc);
// удаление или включение/выключение одного объекта
// нужно загрузить все данные полей
if (($delete || $checked) && $message && !is_array($message) && $posting) {
$component = new nc_Component($classID, $user_table_mode ? 3 : 0);
$component->make_query();
$field_names = $component->get_fields_query();
$field_vars = $component->get_fields_vars();
$multilist_fileds = $component->get_fields(10);
//$date_field = $component->get_date_field(); #not used
$message_select = "\n SELECT " . $field_names . "\n FROM (" . ($user_table_mode ? "`User`" : "`Message" . $classID . "`") . " AS a )" . $component->get_joins() . "\n WHERE " . ($user_table_mode ? "a.`User_ID`" : "a.`Message_ID`") . " = '" . (int) $message . "'";
eval("list(" . $field_vars . ") = \$db->get_row(\$message_select, ARRAY_N);");
// Multiselect
$multilist_fileds = $component->get_fields(10);
if (!empty($multilist_fileds)) {
// просмотр каждого поля типа multiselect
foreach ($multilist_fileds as $multilist_filed) {
// таблицу с элементами можно взять их кэша, если ее там нет - то добавить
if (!$_cache['classificator'][$multilist_filed['table']]) {
$db_res = $db->get_results("SELECT `" . $multilist_filed['table'] . "_ID` AS ID, `" . $multilist_filed['table'] . "_Name` AS Name, `Value`\n FROM `Classificator_" . $multilist_filed['table'] . "`", ARRAY_A);
if (!empty($db_res)) {
foreach ($db_res as $v) {
