Sorry, temporarily not working'; exit; require_once $_SERVER['DOCUMENT_ROOT'].'/include/common.php'; $txt_path = $_SERVER['DOCUMENT_ROOT'].'/inc_txt/'; $material_array = array('Cu', 'Ag', 'Au', 'Pt', 'Ni', 'Fe', 'Zn', 'Br'); $quality_array = array('VF', 'XF', 'Au', 'MS', 'VG', 'F'); $month_array = array('01' => 'Январь', '02' => 'Февраль', '03' => 'Март', '04' => 'Апрель', '05' => 'Май', '06' => 'Июнь', '07' => 'Июль', '08' => 'Август', '09' => 'Сентябрь', '10' => 'Октябрь', '11' => 'Ноябрь', '12' => 'Декабрь' ); set_variable("auction_id"); set_variable("material"); set_variable("quality"); set_variable("year_start"); set_variable("year_stop"); set_variable("month_start"); set_variable("month_stop"); set_variable("day_start"); set_variable("day_stop"); set_variable("nominal"); set_variable("year"); set_variable("letters"); set_variable("p"); set_variable("ord"); $p = clear_digital($p); $ord = clear_digital($ord); if(!in_array($material, $material_array)){$material = '';} if(!in_array($quality, $quality_array)){$quality = '';} $query = "select * from auctions order by auction_name"; $result = mysql_query($query) or die("ERROR :".mysql_error()); while($sql_data = mysql_fetch_array($result)){ $auction_array[$sql_data['id']] = $sql_data['auction_name']; if($sql_data['id'] == $auction_id){ $auction_id = $sql_data['id']; $auction_select_str .= ''."\n"; } else{ $auction_select_str .= ''."\n"; } } mysql_free_result($result); $href_str = "?nominal=$nominal&material=$material&quality=$quality&auction_id=$auction_id&year=$year&letters=$letters&day_start=$day_start&day_stop=$day_stop&month_start=$month_start&month_stop=$month_stop&year_start=$year_start&year_stop=$year_stop&ord=$ord"; $nominal = addslashes($nominal); $letters = addslashes($letters); $year = addslashes($year); foreach($material_array as $mat){ if($material == $mat){ $material_select_str .= ''."\n"; } else{ $material_select_str .= ''."\n"; } } foreach($quality_array as $qua){ if($quality == $qua){ $quality_select_str .= ''."\n"; } else{ $quality_select_str .= ''."\n"; } } $query = "select max(auction_date) as stop, min(auction_date) as start from lots"; $result = mysql_query($query) or die("ERROR :".mysql_error()); $sql_data = mysql_fetch_array($result); mysql_free_result($result); list($base_year_start, $base_month_start, $base_day_start) = split("-", $sql_data['start']); list($base_year_stop, $base_month_stop, $base_day_stop) = split("-", $sql_data['stop']); for($i = $base_year_start; $i <= $base_year_stop; $i++){ if($i == $year_start){ $select_year_start_str .= ''."\n"; } else{ $select_year_start_str .= ''."\n"; } if($i == $year_stop){ $select_year_stop_str .= ''."\n"; } elseif($i == $base_year_stop && $year_stop == ''){ $select_year_stop_str .= ''."\n"; } else{ $select_year_stop_str .= ''."\n"; } } for($i = 1; $i <= 12; $i++){ $this_month = $i; if($i <= 9){$this_month = '0'.$i;} if($this_month == $month_start){ $select_month_start_str .= ''."\n"; } else{ $select_month_start_str .= ''."\n"; } if($this_month == $month_stop){ $select_month_stop_str .= ''."\n"; } elseif($this_month == $base_month_stop && $month_stop == ''){ $select_month_stop_str .= ''."\n"; } else{ $select_month_stop_str .= ''."\n"; } } for($i = 1; $i <= 31; $i++){ $this_day = $i; if($i <= 9){$this_day = '0'.$i;} if($this_day == $day_start){ $select_day_start_str .= ''."\n"; } else{ $select_day_start_str .= ''."\n"; } if($this_day == $day_stop){ $select_day_stop_str .= ''."\n"; } else{ $select_day_stop_str .= ''."\n"; } } //соберем запрос $order_str = ''; switch ($ord) { case 1: $order_str = ' order by year asc'; break; case 2: $order_str = ' order by year desc'; break; case 3: $order_str = ' order by letter asc'; break; case 4: $order_str = ' order by letter desc'; break; case 5: $order_str = ' order by quality asc'; break; case 6: $order_str = ' order by quality desc'; break; case 7: $order_str = ' order by price asc'; break; case 8: $order_str = ' order by price desc'; break; case 9: $order_str = ' order by unix_date asc'; break; case 10: $order_str = ' order by unix_date desc'; break; case 11: $order_str = ' order by material asc'; break; case 12: $order_str = ' order by material desc'; break; case 13: $order_str = ' order by auction_id asc'; break; case 14: $order_str = ' order by auction_id desc'; break; case 15: $order_str = ' order by auction_number asc'; break; case 16: $order_str = ' order by auction_number desc'; break; } $where_str = 'where 1 = 1 '; if($nominal){ $where_str .= "and nominal like '%$nominal%' "; } if($year){ $where_str .= "and year like '%$year%' "; } if($letters){ $where_str .= "and letter like '%$letters%' "; } if($auction_id){ $where_str .= "and auction_id like '%$auction_id%' "; } if($material){ $where_str .= "and material like '%$material%' "; } if($auction_id){ $where_str .= "and quality like '%$quality%' "; } if($year_start && $year_stop && $month_start && $month_stop && $day_start && $day_stop){ $unix_start = mktime(0,0,0,$month_start,$day_start,$year_start); $unix_stop = mktime(0,0,0,$month_stop,$day_stop,$year_stop); if($unix_start <= $unix_stop){ $where_str .= "and unix_date BETWEEN '$unix_start' and '$unix_stop' "; } if($unix_start > $unix_stop){ $where_str .= "and unix_date BETWEEN '$unix_stop' and '$unix_start' "; } } //==========листалка============ $per_page = 23; $visible_page = 10; $p = $p * 1; $query = 'select count(*) as cnt from lots '.$where_str; $result = mysql_query($query) or die("ERROR 1:".mysql_error()); $sql_data = mysql_fetch_array($result); mysql_free_result($result); $all = $sql_data['cnt']; $all_page = floor($all / $per_page); if($all_page != 0){ if($p){$this_page = $p;} else{$this_page = 0;} if($this_page < 0){$this_page = 0;} if($this_page > $all_page){$this_page = $all_page;} $list_str = ''; if($this_page == 0){ $list_str .= ''; } else{ $list_str .= ''; } if($this_page - $visible_page < 1){ $start_fo_for = 1; } else{ $start_fo_for = $this_page - $visible_page; } if($start_fo_for + 2*$visible_page >= $all_page){ $end_fo_for = $all_page; } else{ $end_fo_for = $start_fo_for + 2*$visible_page; } $list_str .= ''; for($i = $start_fo_for; $i <= $end_fo_for - 1; $i++){ $page_number = $i + 1; if($i == $this_page){ $list_str .= ''; } else{ $list_str .= ''; } } $list_str .= ''; if($this_page == $all_page){ $end_page = $all_page + 1; $list_str .= ''; } else{ $end_page = $all_page + 1; $list_str .= ''; } $list_str .= '
[1]1...['.$page_number.']'.$page_number.'...['.$end_page.']'.$end_page.' 
'."\n"; } //========= $start = $p * $per_page; $query = 'select * from lots '.$where_str.' '.$order_str.' limit '.$start.','.$per_page; // print $query; $result = mysql_query($query) or die("ERROR 1:".mysql_error()); while($sql_data = mysql_fetch_array($result)){ $data_str .= ' '.$sql_data['nominal'].''.$sql_data['description'].''.$sql_data['year'].''.$sql_data['letter'].''.$sql_data['quality'].''.$sql_data['material'].''.$sql_data['price'].''.$sql_data['auction_date'].''.$auction_array[$sql_data['auction_id']].''.$sql_data['auction_number'].' '."\n"; } mysql_free_result($result); $data = file_get_contents($txt_path.'stat_index.txt'); $data = str_replace('', $auction_select_str, $data); $data = str_replace('', $material_select_str, $data); $data = str_replace('', $quality_select_str, $data); $data = str_replace('', $select_year_start_str, $data); $data = str_replace('', $select_year_stop_str, $data); $data = str_replace('', $select_month_start_str, $data); $data = str_replace('', $select_month_stop_str, $data); $data = str_replace('', $select_day_start_str, $data); $data = str_replace('', $select_day_stop_str, $data); $data = str_replace('', $list_str, $data); $data = str_replace('', $data_str, $data); $data = str_replace('', $nominal, $data); $data = str_replace('', $year, $data); $data = str_replace('', $letters, $data); $data = str_replace('', $href_str, $data); print $data; exit; ?>