Россия-3 >> "; $pg_months = array("Января", "Февраля", "Марта", "Апреля", "Мая", "Июня", "Июля", "Августа", "Сентября", "Октября", "Ноября", "Декабря"); $pg_countrys = array("rus" => "Россия", "ukr" => "Украина", "tur" => "Турция", "mol" => "Молдавия"); $CURRENT_TIMESTAMP=date("YmdHis",mktime()); //функции function antispam($str) { /* $ostr=""; for($i=0;$i1)//проверим пользуна на существование { $db_query = "SELECT `r3_users`.`fio`, `r3_users`.`user_id` FROM `r3_users`" ." WHERE `r3_users`.`login` = '$pg_user'"; $db_result = mysql_query_ext($db_query); if(mysql_num_rows($db_result)==1)//оки, пользун числится в базе { list($pg_u_fio, $pg_u_id)=mysql_fetch_row($db_result); $pg_title = " :: $pg_u_fio"; } else//нет пользуна - и не надо, не оченьто и хотелось... показываем всех { $pg_user=""; } } if(strlen($pg_user)<2) //если нету - список { $pg_title = " :: Участники"; $db_query1 = "SELECT `r3_users`.`fio`, `r3_users`.`login`, `r3_users`.`user_id` FROM `r3_users` WHERE `type`='1' OR `type`='2' OR `type`='3' OR `type`='4'"; $db_result1 = mysql_query_ext($db_query1); $pg_cent_col.= "
Участники
"; } else //так, теперь если пользун есть - покажем 10 его статей, 10 новостей сети и 10 комментов; если нет - выплюнем список { $db_query = "SELECT `r3_users`.`user_id`, `r3_users`.`fio`, `r3_users`.`login`, `r3_users`.`bio`, `r3_users`.`site_addr`, `r3_users`.`mail_addr` FROM `r3_users` WHERE `r3_users`.`login` = '$pg_user'"; $db_result = mysql_query_ext($db_query); list($us_id, $us_fio, $pg_q_username, $us_bio, $us_http, $us_mail)=mysql_fetch_row($db_result); //общее $pg_editor_link = ""; $pg_user_link = ""; $fm_userpic = "/img/none.gif"; 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_cent_col.= "
Участник
" .""; if(strlen($us_bio)>13) //

 

$pg_cent_col.= ""; if(strlen($us_http)>2) $pg_cent_col.= ""; if(strlen($us_mail)>2) $pg_cent_col.= ""; $pg_cent_col.= "
\"$fm_alt\" $us_fio
Биография
$us_bio
Сайт$us_http
E-mail',unescape('".antispam($us_mail)."') )\">получить адрес
"; //статьи // тут фича: ищем в подписи имя и фамилию list($us_n1,$us_n2)=split(" ",$us_fio); $db_query = "SELECT `r3_text`.`text_id`, `r3_text`.`country`, `r3_text`.`date_pub`, `r3_text`.`text_name`, `r3_text`.`title`, `r3_text`.`text`," ." `r3_text`.`pict1_ext`, `r3_text`.`pict2_ext`, `r3_text`.`pict_alt`, `r3_topic`.`topic_name`, `r3_topic`.`path_lat`," ." `r3_users`.`user_id`, `r3_users`.`login`, `r3_users`.`type`, `r3_users`.`fio` FROM `r3_text`" ." LEFT JOIN `r3_topic` ON `r3_text`.`topic_id` = `r3_topic`.`topic_id`" ." LEFT JOIN `r3_users` ON `r3_text`.`user_id` = `r3_users`.`user_id`" ." WHERE "// AND" ." ((`r3_text`.`type`= '0' OR `r3_text`.`type`= '1' OR `r3_text`.`type`= '2' OR `r3_text`.`type`= '5')" ." AND (`r3_text`.`nik` LIKE '%".$us_n1."%' AND `r3_text`.`nik` LIKE '%".$us_n2."%'))" ." ORDER BY `r3_text`.`date_pub` DESC" ." LIMIT $pg_start_a,10"; $db_result = mysql_query_ext($db_query); if (!$db_result) {echo "

Ошибка доступа к базе: " . mysql_error()."
\n"; echo ""; exit;} $pg_cent_col_add=""; while (list($pg_text_id, $pg_country, $pg_date_pub, $pg_text_name, $pg_text_title, $pg_text, $pg_pict1_ext, $pg_pict2_ext, $pg_pict_alt, $pg_tp_topic_name, $pg_tp_path_lat, $pg_us_user_id, $pg_us_login, $pg_us_type, $pg_us_fio) = mysql_fetch_row($db_result)) { $pg_editor_link = ""; $pg_user_link = ""; // дата if (intval(substr($pg_date_pub, 10, 2)) == 0 && intval(substr($pg_date_pub, 8, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2); } elseif (intval(substr($pg_date_pub, 10, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":00]"; } else $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":".substr($pg_date_pub, 10, 2)."]"; // оформляем путь $pg_nw_path = "/quotes/$pg_text_id"; // оформляем ссылку "Комментировать" 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 (strlen($pg_text_title) > 64) $pg_nw_title = substr($pg_text_title, 0, 50)."... "; else $pg_nw_title = $pg_text_title; $pg_nw_title = preg_replace("{]+>}i", " ", $pg_nw_title); // альт текст $pg_nw_alt = $pg_pict_alt; // картинка if ($pg_pict2_ext !== NULL) $pg_nw_pic = "/pic/".$pg_text_id."_2.".$pg_pict2_ext; elseif ($pg_pict2_ext === NULL && $pg_pict1_ext !== NULL) $pg_nw_pic = "/pic/".$pg_text_id."_1.".$pg_pict1_ext; else $pg_nw_pic = $pg_default_pic3; // подстановка шаблона $pg_cent_col_add.= "
\"$pg_nw_alt\"$pg_nw_date
$pg_nw_title
"; } $db_query_cnt = "SELECT `r3_text`.`text_id` FROM `r3_text`" ." WHERE "// AND" ." ((`r3_text`.`type`= '0' OR `r3_text`.`type`= '1' OR `r3_text`.`type`= '2' OR `r3_text`.`type`= '5')" ." AND (`r3_text`.`nik` LIKE '%".$us_n1."%' AND `r3_text`.`nik` LIKE '%".$us_n2."%'))"; $db_results_cnt = mysql_query_ext($db_query_cnt); $db_cnt=mysql_num_rows($db_results_cnt); //теперь проставим странички if($db_cnt>10) { $pg_navlink=""; if($pg_start_a>40)$pg_navlink.=" ... "; for($i=(($pg_start_a>40)?($pg_start_a-40):0);$i<((($pg_start_a+60)>$db_cnt)?$db_cnt:($pg_start_a+60));$i+=10) { if($i==$pg_start_a) $pg_navlink.=(intval($i/10)+1)." "; else $pg_navlink.="".(intval($i/10)+1)." "; } if(($pg_start_a+60)<$db_cnt)$pg_navlink.=" ... "; } if(strlen($pg_cent_col_add)>0) $pg_cent_col.= "
Статьи  $pg_navlink
$pg_cent_col_add"; //новости сети $db_query = "SELECT `r3_text`.`text_id`, `r3_text`.`country`, `r3_text`.`date_pub`, `r3_text`.`text_name`, `r3_text`.`title`, `r3_text`.`text`," ." `r3_text`.`pict1_ext`, `r3_text`.`pict2_ext`, `r3_text`.`pict_alt`, `r3_topic`.`topic_name`, `r3_topic`.`path_lat`," ." `r3_users`.`user_id`, `r3_users`.`login`, `r3_users`.`type`, `r3_users`.`fio` FROM `r3_text`" ." LEFT JOIN `r3_topic` ON `r3_text`.`topic_id` = `r3_topic`.`topic_id`" ." LEFT JOIN `r3_users` ON `r3_text`.`user_id` = `r3_users`.`user_id`" ." WHERE "// AND" ." (`r3_text`.`type`= '11' AND `r3_text`.`user_id` = '$us_id')" ." ORDER BY `r3_text`.`date_pub` DESC" ." LIMIT $pg_start_n,10"; $db_result = mysql_query_ext($db_query); if (!$db_result) {echo "

Ошибка доступа к базе: " . mysql_error()."
\n"; echo ""; exit;} $pg_cent_col_add=""; while (list($pg_text_id, $pg_country, $pg_date_pub, $pg_text_name, $pg_text_title, $pg_text, $pg_pict1_ext, $pg_pict2_ext, $pg_pict_alt, $pg_tp_topic_name, $pg_tp_path_lat, $pg_us_user_id, $pg_us_login, $pg_us_type, $pg_us_fio) = mysql_fetch_row($db_result)) { $pg_editor_link = ""; $pg_user_link = ""; // дата //added - translate "yyyy-mm-dd hh:ii:ss" to "YmdHis" $pg_date_pub = preg_replace("{[:-]}", "", $pg_date_pub); $pg_date_pub = str_replace(" ","",$pg_date_pub); $pg_date_pub = substr($pg_date_pub, 0, 14); if (intval(substr($pg_date_pub, 10, 2)) == 0 && intval(substr($pg_date_pub, 8, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2); } elseif (intval(substr($pg_date_pub, 10, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":00]"; } else $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":".substr($pg_date_pub, 10, 2)."]"; // оформляем путь $pg_nw_path = "/quotes/$pg_text_id"; // оформляем ссылку "Комментировать" 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 (strlen($pg_text_title) > 64) $pg_nw_title = substr($pg_text_title, 0, 50)."... "; else $pg_nw_title = $pg_text_title; $pg_nw_title = preg_replace("{]+>}i", " ", $pg_nw_title); // альт текст $pg_nw_alt = $pg_pict_alt; // картинка if ($pg_pict2_ext !== NULL) $pg_nw_pic = "/pic/".$pg_text_id."_2.".$pg_pict2_ext; elseif ($pg_pict2_ext === NULL && $pg_pict1_ext !== NULL) $pg_nw_pic = "/pic/".$pg_text_id."_1.".$pg_pict1_ext; else $pg_nw_pic = $pg_default_pic3; // подстановка шаблона $pg_cent_col_add.= "
\"$pg_nw_alt\"$pg_nw_date
$pg_nw_title
"; } $db_query_cnt = "SELECT `r3_text`.`text_id` FROM `r3_text`" ." WHERE " ." (`r3_text`.`type`= '11' AND `r3_text`.`user_id` = '$us_id')"; $db_results_cnt = mysql_query_ext($db_query_cnt); $db_cnt=mysql_num_rows($db_results_cnt); //теперь проставим странички if($db_cnt>10) { $pg_navlink=""; if($pg_start_n>40)$pg_navlink.=" ... "; for($i=(($pg_start_n>40)?($pg_start_n-40):0);$i<((($pg_start_n+60)>$db_cnt)?$db_cnt:($pg_start_n+60));$i+=10) { if($i==$pg_start_n) $pg_navlink.=(intval($i/10)+1)." "; else $pg_navlink.="".(intval($i/10)+1)." "; } if(($pg_start_n+60)<$db_cnt)$pg_navlink.=" ... "; } if(strlen($pg_cent_col_add)>0) $pg_cent_col.= "
Новости сети  $pg_navlink
$pg_cent_col_add"; //комменты $db_query = "SELECT `r3_text`.`title`, `r3_text`.`date_ord`, `r3_text`.`text_id`, `r3_text`.`text`, `r3_users`.`tirl`, `r3_users`.`user_id`, `r3_users`.`login`, `r3_users`.`fio` FROM `r3_text`" ." LEFT JOIN `r3_users` ON `r3_text`.`user_id` = `r3_users`.`user_id`" ." WHERE `r3_text`.`user_id` = '$us_id' AND `r3_text`.`type`= '10'" ." ORDER BY `r3_text`.`date_ord` DESC" ." LIMIT $pg_start_q,10"; $db_result = mysql_query_ext($db_query); if (!$db_result) {echo "

Ошибка доступа к базе: " . mysql_error()."
\n"; echo ""; exit;} $pg_cent_col_add=""; while (list($pg_nw_head, $pg_date_pub, $pg_text_id, $pg_nw_title, $pg_text_tirline, $pg_us_id, $pg_q_username, $fm_alt) = mysql_fetch_row($db_result)) { //added - translate "yyyy-mm-dd hh:ii:ss" to "YmdHis" $pg_date_pub = preg_replace("{[:-]}", "", $pg_date_pub); $pg_date_pub = str_replace(" ","",$pg_date_pub); $pg_date_pub = substr($pg_date_pub, 0, 14); if(strlen($pg_nw_title)==0)$pg_nw_title="без заголовка"; // дата if (intval(substr($pg_date_pub, 10, 2)) == 0 && intval(substr($pg_date_pub, 8, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2); } elseif (intval(substr($pg_date_pub, 10, 2)) == 0) { $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":00]"; } else $pg_nw_date = substr($pg_date_pub, 6, 2).".".substr($pg_date_pub, 4, 2).".".substr($pg_date_pub, 2, 2)." [".intval(substr($pg_date_pub, 8, 2)).":".substr($pg_date_pub, 10, 2)."]"; //заголовок - под датой if(strlen($pg_nw_head)>1)$pg_nw_date.="
$pg_nw_head"; // подстановка шаблона $pg_nw_path="/quotes/all/$pg_text_id"; // $pg_nw_title=str_replace("

","\r\n",str_replace("
","\r\n",str_replace("\r\n","",$pg_nw_title))); $pg_nw_title=strip_tags($pg_nw_title); $pg_nw_title=substr($pg_nw_title,0,100); $pg_cent_col_add.= "
$pg_nw_date
$pg_nw_title
"; } $db_query_cnt = "SELECT `r3_text`.`date_ord` FROM `r3_text`" ." WHERE `r3_text`.`user_id` = '$us_id' AND `r3_text`.`type`= '10'"; $db_results_cnt = mysql_query_ext($db_query_cnt); $db_cnt=mysql_num_rows($db_results_cnt); //теперь проставим странички $pg_navlink=""; if($db_cnt>10) { if($pg_start_q>40)$pg_navlink.=" ... "; for($i=(($pg_start_q>40)?($pg_start_q-40):0);$i<((($pg_start_q+60)>$db_cnt)?$db_cnt:($pg_start_q+60));$i+=10) { if($i==$pg_start_q) $pg_navlink.=(intval($i/10)+1)." "; else $pg_navlink.="".(intval($i/10)+1)." "; } if(($pg_start_q+60)<$db_cnt)$pg_navlink.=" ... "; } if(strlen($pg_cent_col_add)>0) $pg_cent_col.= "
Комментарии  $pg_navlink
$pg_cent_col_add"; } if (($pg_u_id !== NULL && isset($_SESSION["us_id"]) && $pg_u_id == $_SESSION["us_id"])) { if (file_exists("inc/admin_menu".$_SESSION["us_type"].".html")) $pg_left_col = file_get_contents("inc/admin_menu".$_SESSION["us_type"].".html"); if ($pg_left_col != false) {$pg_left_col = prepare_toeval($pg_left_col); eval("\$pg_left_col = \"$pg_left_col\";");} } $pg_righ_col_exist = false; ?> Нет такого материала на сайте