foreach ($tztype_list as $k => $v) {
$sql1 = mysql_query("SELECT count(*) FROM " . TABLE_TZ . " WHERE type={$k}") or Error(1, __FILE__, __LINE__);
$info = @mysql_fetch_array($sql1);
$type_list[$k] = array('name' => $v, 'count' => (int) @$info[0]);
}
$replace['tztype_list'] = $type_list;
if ($tz_id) {
$sql1 = mysql_query("SELECT * FROM " . TABLE_TZ . " WHERE tz_id={$tz_id}") or Error(1, __FILE__, __LINE__);
if (!($info = @mysql_fetch_array($sql1))) {
$content = 'Не найдено задание!';
return;
}
$info['name'] = htmlspecialchars($info['name'], ENT_COMPAT, 'cp1251');
$info['description'] = htmlspecialchars($info['description'], ENT_COMPAT, 'cp1251');
$info['type_select'] = array_select('type', $tztype_list, $info['type'], 0, "");
$info['ord_select'] = ord_select("SELECT name FROM " . TABLE_TZ . " WHERE tz_id!={$tz_id} AND type={$info['type']} ORDER BY ord", 'ord', $info['ord']);
$where = "g.news_id={$tz_id} AND g.type={$commenttype}";
$sql = mysql_query("SELECT COUNT(*) FROM " . TABLE_OPINION . " g WHERE {$where}") or Error(1, __FILE__, __LINE__);
$arr1 = mysql_fetch_array($sql);
$info['all'] = $all = $arr1[0];
list($limit, $pages) = pages($all, $url . "&");
$opinion_list = array();
$sql = mysql_query("\n\t\tSELECT \n\t\t\tg.* , u.name as uname\n\t\tFROM \n\t\t\t" . TABLE_OPINION . " g \n\t\t\tLEFT JOIN " . TABLE_USER . " u ON (u.user_id=g.user_id)\n\t\tWHERE\n\t\t\t{$where}\n\t\tORDER BY \n\t\t\tg.datetime, g.opinion_id \n\t\tLIMIT {$limit}") or Error(1, __FILE__, __LINE__);
while ($arr1 = @mysql_fetch_array($sql)) {
$arr1['uname'] = HtmlSpecialChars($arr1['uname'], ENT_COMPAT, 'cp1251');
$arr1['text'] = comment_text($arr1['text']);
list($date, $time) = explode(" ", $arr1['datetime']);
$arr1['datetime'] = sql_to_text_date($date) . " " . substr($time, 0, 5);
$arr1['del_link'] = $url . "&delopinion={$arr1['opinion_id']}";
$opinion_list[] = $arr1;
}
$replace['forms'] = $forms;
$replace['field_id'] = $field_id;
$replace['form_id'] = $form_id;
$left_menu = get_template('templ/field_list.htm', $replace);
if ($field_id) {
$sql = mysql_query("SELECT * FROM " . TABLE_QUESTFIELD . " WHERE field_id='{$field_id}'") or Error(1, __FILE__, __LINE__);
if ($field = @mysql_fetch_array($sql)) {
$field['name'] = htmlspecialchars($field['name'], ENT_COMPAT, 'cp1251');
$field['data'] = htmlspecialchars($field['data'], ENT_COMPAT, 'cp1251');
$field['public_select'] = array_select('public', array(0 => 'Нет', 1 => 'Да'), $field['public'], 0);
$field['line_select'] = array_select('line', array(0 => 'Нет', 1 => 'Да'), $field['line'], 0);
$type_arr = array(0 => 'Строка', 1 => 'Многострочный текст', 2 => 'Выбор из списка', 3 => 'Дата', 4 => 'Checkbox (галочки)', 5 => 'Адресат');
$field['type_select'] = array_select('type', $type_arr, $field['type'], 0);
$checkfield_arr = array(0 => 'Без проверки', 1 => 'Не пустое поле', 2 => 'Целое число', 3 => 'E-Mail', 4 => 'Дата');
$field['checkfield_select'] = array_select('checkfield', $checkfield_arr, $field['checkfield'], 0);
$field['ord_select'] = ord_select("SELECT name FROM " . TABLE_QUESTFIELD . " WHERE field_id!={$field_id} AND form_id={$field['form_id']} ORDER BY ord", 'ord', $field['ord']);
$content = get_template('templ/field.htm', $field);
}
return;
}
if ($form_id) {
$sql = mysql_query("SELECT * FROM " . TABLE_QUESTIONNAIRE . " WHERE form_id='{$form_id}'") or Error(1, __FILE__, __LINE__);
if ($form = @mysql_fetch_array($sql)) {
$form['name'] = htmlspecialchars($form['name'], ENT_COMPAT, 'cp1251');
$form['butt'] = htmlspecialchars($form['butt'], ENT_COMPAT, 'cp1251');
if (!$form['butt']) {
$form['butt'] = 'Отправить запрос';
}
$form['email'] = htmlspecialchars($form['email'], ENT_COMPAT, 'cp1251');
$content = get_template('templ/form.htm', $form);
}
}
$info['bron'] = $bron;
$reserv[] = $info;
}
}
return array($reserv, $days);
}
if ($hotel_id) {
$sql = mysql_query("SELECT * FROM " . TABLE_HOTEL . " WHERE hotel_id='{$hotel_id}'") or Error(1, __FILE__, __LINE__);
if ($hotel = @mysql_fetch_array($sql)) {
$hotel['name'] = htmlspecialchars($hotel['name'], ENT_COMPAT, 'cp1251');
$hotel['url'] = htmlspecialchars($hotel['url'], ENT_COMPAT, 'cp1251');
$hotel['text'] = htmlspecialchars($hotel['text'], ENT_COMPAT, 'cp1251');
$hotel['public_select'] = array_select('public', array(0 => 'Нет', 1 => 'Да'), $hotel['public'], 0);
$hotel['tour_select'] = array_select('tour', array(0 => 'обычный график', 1 => 'туры', 2 => 'через gz.tour-shop.ru'), $hotel['tour'], 0);
$hotel['ord_select'] = ord_select("SELECT name FROM " . TABLE_HOTEL . " WHERE hotel_id!={$hotel_id} ORDER BY ord", 'ord', $hotel['ord']);
$suites = array();
$reserv = array();
$zaezd_array = array();
$order_array = array();
if (isset($tours)) {
$tmp_file = 'hotel_tour.htm';
$hotel['hotel_link'] = ADMIN_URL . "?p={$part}&hotel_id={$hotel_id}";
$hotel['date_link'] = ADMIN_URL . "?p={$part}&hotel_id={$hotel_id}&month=" . date("Y-m");
$sql = mysql_query("SELECT tour_id, name, date_from, date_to, public FROM " . TABLE_TOUR . " WHERE hotel_id={$hotel_id} ORDER BY ord") or Error(1, __FILE__, __LINE__);
$tour_list = array();
while ($info = @mysql_fetch_array($sql)) {
$info['name'] = HtmlSpecialChars($info['name'], ENT_COMPAT, 'cp1251');
$info['name'] .= " " . sql_to_text_date($info['date_from']) . " - " . sql_to_text_date($info['date_to']);
$info['edit_link'] = "?p={$part}&tours&tour_id={$info['tour_id']}&hotel_id={$hotel_id}";
$info['del_link'] = "?p={$part}&tours&tour_id={$info['tour_id']}&hotel_id={$hotel_id}&deltour=1";
