require ("./conf.php");
//error_reporting(E_ALL);
//require ("$path_data/lib-msa/lib_mstime.php"); // function dayto2
require ("$path_data/common/class_search.php"); // function MS_Search_Query ParseDocText
//require ("$path_data/common/class_meta.php");
$page_rl="book";
$page_rl2="search";
$rz="03"; // Stroylocman
$Meta_Title="Книги строительство ремонт дизайн дом коттедж дача";
$Meta_Description="Литература (книги) по строительству домов, дач, коттеджей, дизайну квартир";
$Meta_Keywords="книги строительство ремонт дизайн дача дом коттедж";
$img_shop_dot="
";
$bgcolor=" BGCOLOR=#EBEBF0";
if ( !isset($adv) ) { $adv=""; }
if ( $adv=="yes" ) {
// advanced search
unset($year_ar);
$year_ar[""]="все года";
$first_year=1995;
$this_year=2004;
$i=$this_year;
while ( $i>$first_year ) {
$year_ar[$i]=$i;
$i--;
}
if ( !isset($year) ) {
$year="";
}
$a="no";
reset($year_ar);
while( list($key,$val)=each($year_ar) ) {
if ( $year==$key ) {
$a="";
break;
}
}
if ( $a ) {
$year="";
}
}
else {
$adv="";
$year="";
}
if ( !isset($q) ) { $q=""; }
$what=urldecode($q);
$mes_error="";
unset($db_id);
$Kolvo=0;
$KolvoPage=0;
$Vivod1=0;
$Vivod2=0;
$table0="rl_opis01";
require ($database_connection_file);
if ( $dbh ) {
$step=20;
if ( !isset($fs) ) { $fs=0; }
else { $fs=intval($fs); }
unset($ar_where);
// text search
$MinTextValue=3;
$MaxTextValue=32;
$MaxWords=5;
$what=chop(trim($what));
unset($ar);
if ( strlen($what)>=$MinTextValue ) {
$what=substr($what,0,$MaxTextValue);
$q=urlencode($what);
unset($ar_what);
$what1=$what;
$what1=str_replace("ё","е",$what1);
$what1=str_replace("Ё","Е",$what1);
$what1=ereg_replace("[^A-Za-zА-Яа-я0-9]"," ",$what1);
$ar_what=explode(" ",$what1);
$LastMaxWord="";
reset($ar_what);
$i=0;
while( list($key,$val)=each($ar_what) ) {
$val0=chop(trim($val));
if ( strlen($val0)<$MinTextValue or $i>=$MaxWords ) {
unset($ar_what[$key]);
}
else {
$ar[]="(CONCAT(ptex1,' ',ptex2,' ',ptex3,' ',name1,' ',description) LIKE '%".$val0."%')";
$i++;
if ( $i>=$MaxWords ) {
$LastMaxWord=$val0;
}
}
}
if ( isset($ar) ) {
$a=implode($ar," AND ");
$ar_where[]=$a;
}
}
if ( !isset($ar) ) {
$mes_error="Для поиска необходимо ввести не менее $MinTextValue символов";
}
// text search
$ar_where[]="rz='$rz'";
if ( $adv=="yes" ) {
if ( $year ) {
$ar_where[]="pint1='$year'";
}
}
$where=implode(" AND ",$ar_where);
$where="WHERE ".$where;
$SQL="SELECT count(*) AS Kolvo FROM $table0 $where";
// print $SQL;
$result=mysql_query($SQL);
if ($result) {
$Kolvo=mysql_result($result,0,"Kolvo");
mysql_free_result($result);
$tord="ORDER BY datad DESC";
$SQL="SELECT * FROM $table0 $where $tord LIMIT $fs,$step";
$result=mysql_query($SQL);
if ( $result ) {
unset($row);
while( $row=mysql_fetch_array($result) ) {
$a=$row["id"];
$db_id[$a]=$a;
$db_name[$a]=$row["ptex1"];
$db_author[$a]=$row["ptex2"];
$db_ser[$a]=$row["ptex3"];
$db_isbn[$a]=$row["name1"];
$db_year[$a]=$row["pint1"];
$db_desc[$a]=$row["description"];
$db_imgs[$a]=$row["pchr1"];
}
mysql_free_result($result);
if ( isset($db_id) ) {
$KolvoPage=count($db_id);
if ( $KolvoPage ) {
$Vivod1=$fs+1;
if ( $KolvoPage>1 ) {
$Vivod2=$fs+$KolvoPage;
}
if ( $what ) {
if ( !$mes_error ) {
$Meta_Title=$what." ".$Meta_Title;
$Meta_Description=$what." ".$Meta_Description;
$Meta_Keywords=$what." ".$Meta_Keywords;
}
}
}
}
}
}
}
require ("$path_docs_t/include/top.php");
?>

 |
|
Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 171
>
print $img_shop_dot;
print " ";
$t="Книги по строительству, ремонту, дизайну";
if ( $fs or $what ) {
print "$t";
}
else {
print "$t";
}
?>

if ( $what or $year ) {
?>
if ( $what ) {
print "Поиск по: "$what" ";
if ( $mes_error ) {
print "$mes_error ";
}
}
if ( $adv=="yes" ) {
if ( $year ) {
print "Год выпуска: $year ";
}
}
?>
|
}
?>

|
Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 252
>
print "Найдено: $Kolvo";
if ( $Vivod1 ) {
print " Вывод: $Vivod1";
if ( $Vivod2>$Vivod1 ) {
print " - $Vivod2";
}
print " ";
}
?>

if ( !isset($Ya_Premium) ) {
$Ya_Premium="";
}
if ( $Ya_Premium ) {
include ("$path_docs/ban/ya/premium-body.html");
}
if ( !$dbh ) {
print "Сервер базы данных не доступен. Попробуйте еще раз или попозже. ";
}
else {
if ( isset($db_id) ) {
reset($db_id);
print "";
while( list($key,$val)=each($db_id) ) {
print "";
if ( $db_imgs[$key] ) {
$a=str_replace('"',"",$db_name[$val]);
print " ";
}
print "".$db_name[$val]." ";
unset($ar);
if ( $db_author[$val] ) {
$ar[]=$db_author[$val];
}
if ( $db_year[$val] ) {
$ar[]="(".$db_year[$val].")";
}
if ( isset($ar) ) {
$a=implode(" ",$ar);
print "$a ";
}
if ( $db_desc[$val] ) {
$a=substr($db_desc[$val],0,160);
print $a." ... ";
}
print " | ";
print " Подробнее >>
";
print " | ";
}
print " ";
if ( $Kolvo>$step ) {
?>
|
Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 312
>
$idown=intval($fs/(10*$step));
if ($idown>0) {
$i=(10*$idown-1)*$step+1;
$j=-1;
}
else {
$i=1;
$j=0;
}
$Kolvo1=$Kolvo+1;
while ( $i<$Kolvo1 ) {
$i0=$i-1;
if ($i0==$fs) {
print "$i";
}
else {
$query="q=$q&fs=$i0&adv=$adv&year=$year";
$queryDef="&0&&";
$query=MS_Search_Query($query,$queryDef);
print "";
if ($j==10) { print "След.>>"; }
else {
if ($j==-1) { print "<<Пред."; }
else { print $i; }
}
print "";
}
print " ";
$i=$i+$step;
if ( $j==10 ) { break; }
$j++;
}
?>
}
}
}
?>
|
 |
require ("$path_docs_t/include/right.php");
?>
|
 |
require ("$path_docs_t/include/bot.php");
?>