Warning: preg_replace(): Unknown modifier 'g' in /home/rossia3/public_html/index.php on line 25
Новости марша >> ";
$pg_months = array("Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь", "Октябрь", "Ноябрь", "Декабрь");
$pg_countrys = array("rus" => "Россия", "ukr" => "Украина", "tur" => "Турция", "mol" => "Молдавия");
$db_query = "";
$db_date_cond = "";
$db_path_cond = "";
$CURRENT_TIMESTAMP=date("YmdHis",mktime());
$pg_redtram_banner_1 = $pg_redtram_banner_1_stencil;
$pg_redtram_banner_2 = $pg_redtram_banner_2_stencil;
//if (preg_match("{^/news/([:/0-9]+)(\?[-._&=a-z0-9]+)?$}i", $pg_path, $matches) && $matches[1] != "") {
if (preg_match("|^/news4/(\d{4}(/\d{2}(/\d{2}(/\d{2}(:\d{2}(:\d{2})?)?)?)?)?)?/?$|i", $pg_path, $matches) && $matches[1] != "") {
//echo $matches[1]; // только для тестирования
$db_date = preg_replace("{[:/]}", "", $matches[1]);
$db_date = substr($db_date, 0, 14);
$db_date_cond = " AND `r3_text`.`date_pub` LIKE '".$db_date."%'";
} elseif (preg_match("{^/news4/([a-f0-9]+)$}i", $pg_path, $matches)) {
$db_path_cond = " AND `r3_text`.`text_name` = '".$matches[1]."'";
} elseif (preg_match("{^/news4(/[-._a-z0-9]+)+$}i", $pg_path)) {
$db_path_cond = " AND CONCAT(`r3_topic`.`path_lat`, `r3_topic`.`topic_name`, '/', `r3_text`.`text_name`) LIKE '".$pg_path."%'";
}
$cut_future_date = " AND `r3_text`.`date_pub` < CURRENT_TIMESTAMP";
if (isset($_GET["start"])) $db_start = intval($_GET["start"]);
elseif (preg_match("{^/news4/?$}i", $pg_path)) $db_start = 0;
else
if(strpos($pg_path,"/start=")>0) $db_start = intval(substr($pg_path,13,strlen($pg_path)));
else $db_start = 0;
if (isset($_GET["offset"])) $db_offset = intval($_GET["offset"]);
else $db_offset = 10;
$db_query = "SELECT `r3_text`.`text_id`, `r3_text`.`date_pub`, `r3_text`.`title`, `r3_text`.`text`, `r3_text`.`pict2_ext`, `r3_text`.`pict_alt`,"
." `r3_topic`.`topic_name`, `r3_topic`.`title`, `r3_topic`.`kword`, `r3_topic`.`descr` FROM `r3_text`"
." LEFT JOIN `r3_topic` ON `r3_text`.`topic_id` = `r3_topic`.`topic_id`"
." WHERE `r3_text`.`type` = '7'"
." AND `r3_text`.`usr_active` = '1'"
.$cut_future_date
.$db_date_cond
.$db_path_cond
." ORDER BY `r3_text`.`date_pub` DESC"
." LIMIT ".$db_start.", ".$db_offset;
$db_query_cnt = "SELECT `r3_text`.`text_id` FROM `r3_text`"
." WHERE `r3_text`.`type` = '7'"
." AND `r3_text`.`usr_active` = '1'"
.$cut_future_date
.$db_date_cond
.$db_path_cond;
$db_results_cnt = mysql_query_ext($db_query_cnt);
$db_cnt=mysql_num_rows($db_results_cnt);
$db_result = mysql_query_ext($db_query);
if (!$db_result) {echo "Ошибка доступа к базе: " . mysql_error()."
\n"; echo "