Евразийское вторжение >> "; $pg_monthss = array("Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь", "Октябрь", "Ноябрь", "Декабрь"); $pg_months = array("Января", "Февраля", "Марта", "Апреля", "Мая", "Июня", "Июля", "Августа", "Сентября", "Октября", "Ноября", "Декабря"); $pg_countrys = array("rus" => "Россия", "ukr" => "Украина", "tur" => "Турция", "mol" => "Молдавия"); $db_query = ""; $db_date_cond = ""; $db_path_cond = ""; $CURRENT_TIMESTAMP=date("YmdHis",mktime()); if (preg_match("{^/gazeta/([:/0-9]+)(\?[-._&=a-z0-9]+)?$}i", $pg_path, $matches) && $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("{^/gazeta(/[-._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"]); 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`.`text_name`, `r3_text`.`title`, `r3_text`.`text`, `r3_text`.`country`," ." `r3_text`.`pict2_ext`, `r3_text`.`pict_alt`, `r3_topic`.`topic_name`, `r3_topic`.`title`, `r3_topic`.`kword`, `r3_topic`.`descr`," ." `r3_topic`.`path_lat`, `r3_topic`.`topic_name` FROM `r3_text`" ." LEFT JOIN `r3_topic` ON `r3_text`.`topic_id` = `r3_topic`.`topic_id`" ." WHERE `r3_text`.`type` = '2'" ." AND `r3_text`.`usr_active` = '1'" .$cut_future_date .$db_date_cond .$db_path_cond ." ORDER BY `r3_text`.`date_ord` DESC" ." LIMIT ".$db_start.", ".$db_offset; $db_result = mysql_query_ext($db_query); if (!$db_result) {echo "

Ошибка доступа к базе: " . mysql_error()."
\n"; echo ""; exit;} $pg_tmpl = file_get_contents("inc/tmpl_newspaper_show.html");// шаблон share1 //echo mysql_num_rows($db_result), "
\n"; if (mysql_num_rows($db_result) != 0 && $pg_tmpl != false) { while (list($pg_text_id, $pg_date_pub, $pg_text_name, $pg_title, $pg_text, $pg_country, $pg_pict2_ext, $pg_pict_alt, $pg_tp_topic_name, $pg_tp_title, $pg_tp_kword, $pg_tp_descr, $pg_tp_path_lat, $pg_tp_topic_name) = mysql_fetch_row($db_result)) { $pg_description = $pg_tp_descr; $pg_keywords = $pg_tp_kword; // ссылка редактировать if (isset($_SESSION["us_type"]) && $_SESSION["us_type"] != 3 && $_SESSION["us_type"] != 4) $pg_editor_link = "

Редактировать статью

"; // оформляем ссылку "Комментировать" if (($pg_us_user_id !== NULL && isset($_SESSION["us_id"]) && $pg_us_user_id == $_SESSION["us_id"]) || (isset($_SESSION["us_type"]) && 5 > $_SESSION["us_type"])) $pg_quote_link = "

Комментировать статью(".GetQuotesCount($pg_text_id).")

"; else $pg_quote_link = " "; // картинка if ($pg_pict2_ext !== NULL) { $pg_pict = "\"".$pg_pict_alt."\""; $pg_pict_off = ""; } // дата и время //if (intval(substr($pg_date_pub, 10, 2)) == 0 && intval(substr($pg_date_pub, 8, 2)) == 0) { $pg_date = intval(substr($pg_date_pub, 6, 2))." ".$pg_months[intval(substr($pg_date_pub, 4, 2))-1]." ".substr($pg_date_pub, 0, 4); $pg_time = " [00:00]"; $pg_time = ""; //} elseif (intval(substr($pg_date_pub, 10, 2)) == 0) { // $pg_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 0, 4); // $pg_time = " [".intval(substr($pg_date_pub, 8, 2)).":00]"; //} else { // $pg_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 0, 4); // $pg_time = " [".intval(substr($pg_date_pub, 8, 2)).":".substr($pg_date_pub, 10, 2)."]"; //} /* AAE Comment:$pg_time*/ // подготовка к выводу $pg_tp_title = cyr_case_ch($pg_tp_title, 1); //if (mysql_num_rows($db_result) == 1 || strlen($db_date) > 11) { // вывод статьи целиком //if ($pg_pict2_ext !== NULL) $pg_pict = "
".$pg_pict; //$pg_comm2_on = ""; //$pg_text_full = "_full"; //} else { // путь новости вида /gazeta/2005/06/21/15:45 //$pg_path = "/gazeta/".substr($pg_date_pub, 0, 4)."/".substr($pg_date_pub, 4, 2)."/".substr($pg_date_pub, 6, 2)."/".substr($pg_date_pub, 8, 2).":".substr($pg_date_pub, 10, 2).":".substr($pg_date_pub, 12, 2); // путь страницы вида /topic_path/topic_name/page_name if ($pg_tp_topic_name === NULL) {$pg_tp_path_lat = ""; $pg_tp_topic_name = "";} $pg_path = $pg_tp_path_lat.$pg_tp_topic_name."/".$pg_text_name; if ($pg_pict2_ext !== NULL) $pg_pict = "
".$pg_pict.""; // сокращённый текст $pg_text = preg_replace("{]+>}i", " ", $pg_text); // Убираем все теги по всему тексту $pg_text = preg_replace("{^( |\s)*}si", " ", $pg_text); // В начале текста могу оказаться пробелы или " " $pg_text2_cut = 300; // Кол-во символов в строке $re_text_cut = "{[.,:;]?(\s\S{1,4})*\s\S*$}s"; // Рег. Выр. для удаления последнего солва, предлога и знаков препинания $pg_text = preg_replace($re_text_cut, " ...", substr($pg_text, 0, $pg_text2_cut)); $pg_text = "".$pg_text.""; //} // шаблонг блока $pg_part = prepare_toeval($pg_tmpl); eval("\$pg_part = \"$pg_part\";"); $pg_cent_col .= $pg_part; //вставим 3 последних коммента $db_query_q = "SELECT `r3_users`.`tirl`, `r3_users`.`user_id`, `r3_users`.`login`, `r3_text`.`text_id`," ." `r3_text`.`text`, `r3_text`.`nik`, `r3_users`.`fio`, `r3_text`.`title`" ." FROM `r3_text`" ." LEFT JOIN `r3_users` ON `r3_text`.`user_id` = `r3_users`.`user_id`" ." WHERE `r3_text`.`topic_id` = '".$pg_text_id."' AND `r3_text`.`type`=10 ORDER BY `date_ord` DESC LIMIT 0,3"; $db_result_q = mysql_query_ext($db_query_q); if(mysql_num_rows($db_result_q) > 0) { $pg_quotes.=""; while( list($pg_q_tirline, $pg_q_user, $pg_q_username, $pg_q_id, $pg_q_text, $pg_q_nik, $pg_q_fio, $pg_q_title) = mysql_fetch_row($db_result_q)) { $pg_quotes.="\r\n
"; $fm_userpic = "/img/none.gif"; $fm_alt = "Картинки нет"; if (file_exists($_SERVER['DOCUMENT_ROOT']."/userpic/".$pg_q_username.".gif")) $fm_userpic = "/userpic/".$pg_q_username.".gif"; elseif (file_exists($_SERVER['DOCUMENT_ROOT']."/userpic/".$pg_q_username.".jpg")) $fm_userpic = "/userpic/".$pg_q_username.".jpg"; elseif (file_exists($_SERVER['DOCUMENT_ROOT']."/userpic/".$pg_q_username.".jpeg")) $fm_userpic = "/userpic/".$pg_q_username.".jpeg"; elseif (file_exists($_SERVER['DOCUMENT_ROOT']."/userpic/".$pg_q_username.".png")) $fm_userpic = "/userpic/".$pg_q_username.".png"; elseif (file_exists($_SERVER['DOCUMENT_ROOT']."/userpic/".$pg_q_username.".bmp")) $fm_userpic = "/userpic/".$pg_q_username.".bmp"; $pg_quotes_add=""; //а вот сюда положим ссылку если смотрит админ или автор if (($pg_us_user_id !== NULL && isset($_SESSION["us_id"]) && $pg_us_user_id == $_SESSION["us_id"]) || (isset($_SESSION["us_type"]) && 3 > $_SESSION["us_type"]) || ($_SESSION["us_id"]==$pg_q_user)) $pg_quotes_add.="редактировать удалить "; //но ссылка "комментировать" будет для всех кому можно if (isset($_SESSION["us_type"]) && (5 > $_SESSION["us_type"])) $pg_quotes_add.="комментировать(".GetQuotesCount($pg_q_id).")"; $l_imgorname="\"$pg_q_fio\""; $pg_q_text = preg_replace($re_text_cut, " ...", substr(strip_tags($pg_q_text),0,130)); $pg_quotes.="
$l_imgorname
$pg_q_text
"; if(strlen($pg_quotes_add)>2) $pg_quotes.="
$pg_q_fio
$pg_quotes_add
"; else $pg_quotes.="
$pg_q_fio
"; $pg_quotes.="
"; $pg_quotes.="
"; } } $pg_cent_col .= $pg_quotes; $pg_quotes=""; } } else { $pg_cent_col = "

Статей нет

"; // $pg_cent_col .= "

".$pg_path."

"; // $pg_cent_col .= "

".$db_path_cond."

"; //$pg_cent_col = "

Страница скоро будет

"; } if (mysql_num_rows($db_result) != 0) { // путь, название рубрики и т.д. echo " "; // навигация по годам, месяцам, дня и цепочка обратной навигации $pg_nav_line = "Евразийское вторжение"; //strlen($db_date) switch (strlen($db_date)) { case 0: $db_period = "'1', '4'";// годы $pg_period_path = "/gazeta/"; break; case 4: $db_period = "'5', '2'";// месяцы $pg_period_path = "/gazeta/".substr($db_date, 0, 4)."/"; $pg_nav_line .= " >> ".substr($db_date, 0, 4).""; break; case 6: case 8: case 10: case 12: case 14: $db_period = "'7', '2'";// дни $pg_period_path = "/gazeta/".substr($db_date, 0, 4)."/".substr($db_date, 4, 2)."/"; $pg_nav_line .= " >> ".substr($db_date, 0, 4)." >> ".$pg_monthss[intval(substr($db_date, 4, 2))-1].""; break; default: $db_period = "'1', '4'";// годы $pg_period_path = "/gazeta/".substr($db_date, 0, 4)."/"; } $db_query = "SELECT SUBSTRING(`date_pub`, ".$db_period.") AS `period`, COUNT(`text_id`) FROM `r3_text`" ." WHERE `type` = '2' AND `usr_active` = '1' AND `date_pub` < CURRENT_TIMESTAMP".$db_date_cond ." GROUP BY `period` ORDER BY `period`"; $db_res=mysql_query_ext($db_query); $pg_tp_list_tmpl = file_get_contents("inc/tmpl_topic_item.html"); if (!$db_res) echo "

Ошибка доступа к базе: " . mysql_error()."
\n"; elseif ($pg_tp_list_tmpl != false && mysql_num_rows($db_res) > 0) { while (list($pg_tp_name, $pg_tp_path) = mysql_fetch_row($db_res)) { $pg_tp_path = $pg_period_path.$pg_tp_name."/"; if (strlen($db_date) == 4) $pg_tp_name = $pg_monthss[intval($pg_tp_name)-1]; $pg_tp_item = prepare_toeval($pg_tp_list_tmpl); eval("\$pg_tp_item = \"$pg_tp_item\";"); $pg_tp_list .= $pg_tp_item; } } else {$pg_comm2_on = "";} } // вывод $pg_title = " : Евразийское вторжение"; $pg_tp_title = "Газета «ЕВРАЗИЙСКОЕ ВТОРЖЕНИЕ»"; $pg_header = file_get_contents("inc/tmpl_topic_show.html"); $pg_header = prepare_toeval($pg_header); eval("\$pg_header = \"$pg_header\";"); $pg_cent_col = $pg_header.$pg_cent_col; ?> Нет такого материала на сайте