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";