0) $QRub=" AND (Rubrica0=6 OR Rubrica0=7 OR Rubrica0=8 OR Rubrica0=17 OR Rubrica0=9 OR Rubrica0=10) "; else $QRub=" AND Rubrica0=0 AND Rubrica1=0 AND Rubrica2=0 "; } if (($ivr<1)||($ivr>3)) die; $QTown=""; if ($twn) { if ($twn>0) $QTown=" AND (Town=$twn OR Town=$twn OR Town=$twn) "; else $QTown=" AND Town=0 AND Town=0 AND Town=0 "; } $QRegion=""; if ($areg) { if ($areg>0) $QRegion=" AND (Region=$areg OR Region=$areg OR Region=$areg) "; else $QRegion=" AND Region=0 AND Region=0 AND Region=0 "; } // include ("data.php"); $portion=10; $pattern= array("","one_resume.htm","one_vacancy.htm"); // $title= array("","Предприятия","Оборудование"); $SSI=2; // отрубаем шаблоны # вывод результата запроса Предприятия порциями по $portion штук MyRead($pattern[$ivr]); //шаблон одного Предприятия $tpl=$Template; //запоминаем шаблон $resume=""; # формируем SQL if (!isset($i0)) $i0=0; settype($i0,"integer"); // $i1=$i0+$portion; $i1=$portion; $t=time()-$ZTime*60; $sql="SELECT * from $zarplata where Type=$ivr $QRegion $QTown $QRub AND Moderate=1 AND Date<$t AND Date>$year order by Date DESC LIMIT $i0, $i1 "; $q=$db->query($sql); # форматируем вывод результатов $t_i=0; // partner.yandex.ru while ($db->next_record()) { $Template=$tpl; $ID=$db->Record["Id"]; $Icon=$db->Record["Icon"]; SetParamOut("ID",$ID); $Date=date("d.m.Y",$db->Record["Date"]); SetParamOut("DATE",$Date); $Name=ClearMask($db->Record["Name"]); SetParamOut("Name",$db->Record['Name']); SetParamOut("Town",$db->Record["Town"],$_Town); SetParamOut("Region",$db->Record["Region"],$_Region); SetParamOut("Rubrica0",$db->Record["Rubrica0"],$_Rubrica); SetParamOut("Rubrica1",$db->Record["Rubrica1"],$_Rubrica); SetParamOut("Rubrica2",$db->Record["Rubrica2"],$_Rubrica); $subject = $db->Record['Subject']; $note = $db->Record['Note']; $note = str_replace("• ", "• ", $note); $note = str_replace("• ", "• ", $note); $note = str_replace("• ", "• ", $note); $note = str_replace(" href=", " href=http://www.oborud.info/s/click.php?", $note); $note = str_replace(" href=http://www.oborud.info/s/click.php?/", " href=/", $note); $note = str_replace(" href=http://www.oborud.info/s/click.php?http://www.oborud.info/", " href=/", $note); $note = str_replace(" href=http://www.oborud.info/s/click.php?mailto:", " href=mailto:", $note); if (strlen($subject)<1) { $subject = strtolower($note); // убираем заглавные буквы $subject = substr($subject, 0, 46); // урезаем строку $subject = preg_replace("/[^\w\x7F-\xFF\s]/", " ", $subject); // каленым железом выжжем все "ненормальные" символы. $subject = str_replace("\n"," ", $subject); $subject = str_replace("\r"," ",$subject); $subject = str_replace("
"," ", $subject); // вычищяем лишние остатки тегов $subject = str_replace("quot", "", $subject); $subject = str_replace("href", "", $subject); $subject = str_replace("http", "", $subject); $subject = str_replace("target", "", $subject); $subject = str_replace("_blank", "", $subject); $subject = str_replace("•", "", $subject); $subject = str_replace(" в ", " ", $subject); $subject = str_replace(" на ", " ", $subject); $subject = str_replace(" к ", " ", $subject); $subject = str_replace(" из ", " ", $subject); $subject = str_replace(" для ", " ", $subject); $subject = str_replace(" над ", " ", $subject); $subject = str_replace(" под ", " ", $subject); $subject = str_replace(" и ", " ", $subject); $subject = str_replace(" как ", " ", $subject); $subject = str_replace(" при ", " ", $subject); $subject = str_replace(" от ", " ", $subject); $subject = ucfirst($subject); } $note = str_replace("
", "", $note); $note = str_replace("\n", "", $note); $note = str_replace("\r"," ",$note); $note = substr($note, 0, 150); $note = wordwrap($note, 140); // в одну строку помещается 48 символов if ($title_len>50) { $note = substr($note, 0, 100); $note = wordwrap($note, 90); } $handle = explode ("\n", $note); $note = $handle[0]; SetParamOut("Note",$note); // SetParamOut("Note",$db->Record['Note']); $price = $db->Record['Price']; if ($price<1) { $price="не указана"; } else { $price=$price." руб."; } SetParamOut("Price",$price); SetParamOut("Firm",$db->Record['Firm']); SetParamOut("Phone",$db->Record['Phone']); SetParamOut("Contacts",$db->Record['Contacts']); SetParamOut("EMail",$db->Record['EMail']); SetParamOut("Age1",$db->Record['Age1']); SetParamOut("URL",$db->Record['URL']); $Zarplata=intval($db->Record['Zarplata']); if ($Zarplata) $Zarplata=' '; SetParamOut("Zarplata",$Zarplata); SetParamOut("SUBJECT",$subject); // версия для печати $printtopic = "resume3.php?ivr=2&id=$ID$hrefsid"; SetParamOut("PRINTTOPIC",$printtopic); if (strlen($Icon)>5) { $image= $server_name."/board/icon/".$Icon; $image_info = getimagesize($image); // $width = $image_info[0]; // $height = $image_info[1]; $image_type = $image_info[2]; if( $image_type == 2 ) { $image= "/product/resize.php?f=".$server_name."/board/icon/".$Icon."&type=0"; } } else { $image = "/product/cat/noimage_pr.png"; } SetParamOut("IMAGE",$image); // partner.yandex.ru_BEGIN if($t_i++==2) { $resume=$resume."

"; } // partner.yandex.ru_END $resume=$resume.$Template; } # формируем список страниц $sql="SELECT count(Id) as n from $zarplata where Type=$ivr $QRegion $QTown $QRub and Moderate=1 AND Date<$t AND Date>$year order by Date"; # $sql="SELECT count(*) as n from $zarplata where Type = 2 AND ( Rubrica0 = 16 OR Rubrica1 = 16 OR Rubrica2 = 16 ) AND Moderate = 1 AND Date < 1046436477"; $q=$db->query($sql); if ($db->next_record()) $n=$db->Record["n"]; else exit; $nav0="";$j=1+$i0/10; $h=""; $pp=100; if ($i0+$portion+$pp>$n) { $pp=$n-$i0-$portion; } for ($i=$i0; $i<$i0+$portion+$pp; $i=$i+$portion) // for ($i=0;$i<$n;$i=$i+$portion) { if ($i!=$i0) $nav0=$nav0.$h."$j"; else $nav0=$nav0.$h."$j"; $h=" | " ; $j++; } if ($i0>0) { $in0 = $i0-$portion; $nav .=" << | "; } $nav .= $nav0; if ($i0+$portion<$n) { $in = $i0+$portion; $nav .=" | >> "; } MyRead("bulletb.htm"); //шаблон одного Предприятия $Template=str_replace("{PAGE}",$nav,$Template); $Template=str_replace("{NAME}",$title[$ivr],$Template); $Template=str_replace("{BODY}",$resume,$Template); $Template=str_replace("{ERR}",$Err,$Template); $Template=str_replace("{RUB2}",$rub2,$Template); MyOutput(); ?>