";
$head="
";
$sql="SELECT * from news2 where pubdate > 0 order by pubdate DESC, id DESC LIMIT 0, 6";
$q=$db->query($sql);
# форматируем вывод результатов
$s="";$n=0;
while ($db->next_record())
{
$id=$db->Record['id'];
// $pubdate=date("d.m.y",$db->Record["pubdate"]);
$link=$db->Record['link'];
$title=$db->Record['title'];
$description=$db->Record['description'];
$notes=$db->Record['notes'];
$s=$s." ".$title."
".$description." ... | \n\n";
}
$head2="
";
//$t1=time()+86400;
$t1=time();
$t2=time()+3974400+3974400;
// $sql="SELECT * from exhibitn2news where pubdate > $t1 and pubdate < $t2 order by pubdate ASC, id ASC LIMIT 0, 6 ";
$sql="SELECT * from exhibitn2news where pubdate > $t1 order by pubdate ASC, id ASC LIMIT 0, 6 ";
$q=$db->query($sql);
# форматируем вывод результатов
$s2="";$n=0;
while ($db->next_record())
{
$id=$db->Record['id'];
// $pubdate=date("d.m.y",$db->Record["pubdate"]);
$link=$db->Record['link'];
$title=$db->Record['title'];
$title = str_replace('.', '', $title);
$description=$db->Record['description'];
$description = str_replace("
", "", $description);
$description = str_replace("\n", "", $description);
$description = str_replace("\r"," ",$description);
$description = trim($description);
// ищем совпадение в строке
$findme = 'click.php';
$pos = strpos($link, $findme);
// Заметьте, что используется ===. Использование == не даст верного
// результата, так как 'a' находится в нулевой позиции.
if ($pos === false) {
// echo "Строка '$findme' не найдена в строке '$link'";
$s2=$s2." ".$title."
".$description." ... | \n\n";
} else {
// echo "Строка '$findme' найдена в строке '$link'";
// echo " в позиции $pos";
$s2=$s2." ".$title."
".$description." ... | \n\n";
}
}
$head3="
Новые позиции в каталоге оборудования
|
";
$t=time()-$ZTime*60;
$sql="select * from (SELECT lid, cat1, title, url, type, Date,description from cat_main where type=1 AND Date<$t AND cat1!=1057 AND cat1!=1058 AND cat1!=1059 AND cat1!=1060 AND cat1!=1061 AND cat1!=1062 AND cat1!=1054 AND cat1!=1055 AND cat1!=1056 AND cat1!=1063 AND cat1!=1064 AND cat1!=1065 AND cat1!=1069 AND cat1!=872 AND cat1!=875 AND cat1!=873 AND cat1!=874 AND cat1!=882 AND cat1!=886 AND cat1!=887 AND cat1!=890 AND cat1!=889 AND cat1!=891 AND cat1!=1067 AND cat1!=1068 AND cat1!=1070 AND cat1!=1219 order by lid DESC) c GROUP BY c.url order by c.lid DESC LIMIT 0, 6";
$q=$db->query($sql);
$s3="";$n=0;
while ($db->next_record())
{
$lid = $db->Record['lid']; // ID
$cat1 = $db->Record['cat1']; // Рубрика
$title = $db->Record['title']; // название
$url = $db->Record['url']; // производитель
$description = $db->Record['description']; // описание
// сокращаем описание
$description = str_replace("
", "", $description);
$description = str_replace("\n", "", $description);
$description = str_replace("\r"," ",$description);
$description = substr($description, 0, 140);
$description = wordwrap($description, 130);
$handle = explode ("\n", $description);
$description = $handle[0];
$description = str_replace('.', '', $description);
if(!is_numeric($url)) {$url = preg_replace("/^[0-9]{3}/","",$url, 3);}
else // иначе ссылку на каталог
{
$url = " ".mysql_result(mysql_query("SELECT brands2.title FROM brands2 WHERE brands2.id=$url LIMIT 1"),0,0)." ";
}
$s3=$s3." ".$title." ".$url ."
".$description." ... | \n\n";
}
$head4="
";
$sql2="select * from (SELECT Id, Date, Firm, Rubrica0, Region, Moderate, Note, Subject from board2 where Moderate=1 AND Date<$t AND Rubrica0!=5 AND Rubrica0!=10 AND Rubrica0!=11 AND Rubrica0!=12 AND Rubrica0!=13 AND Rubrica0!=14 AND Rubrica0!=15 order by Date DESC) c GROUP BY Firm order by Date DESC LIMIT 0, 6";
$q2=$db->query($sql2);
$s4="";$n=0;
while ($db->next_record())
{
$Id = $db->Record['Id'];
$Region = $db->Record['Region'];
$Rubrica0 = $db->Record['Rubrica0'];
$rub2 = "$_Rubrica[$Rubrica0]";
$subject = $db->Record['Subject'];
$description = $db->Record['Note']; // описание
// сокращаем описание
$description = str_replace("
", "", $description);
$description = str_replace("\n", "", $description);
$description = str_replace("\r"," ",$description);
$description = substr($description, 0, 140);
$description = wordwrap($description, 130);
$handle = explode ("\n", $description);
$description = $handle[0];
$description = str_replace('.', '', $description);
$description = preg_replace("/[^\w\x7F-\xFF\s]/", " ", $description); // каленым железом выжжем все "ненормальные" символы.
$description = str_replace("\n"," ", $description);
$description = str_replace("\r"," ",$description);
$description = str_replace("
"," ", $description);
// вычищяем лишние остатки тегов
$description = str_replace("quot", "", $description);
$description = str_replace("href", "", $description);
$description = str_replace("http", "", $description);
$description = str_replace("target", "", $description);
$description = str_replace("_blank", "", $description);
$description = str_replace("•", "", $description);
$s4=$s4." ".$subject." ".$reg2 ."
".$description." ... | \n\n";
}
$message .= $html . "\n\n";
$message .= $head . "\n\n";
$message .= $s . "\n\n";
$message .= " \n\n";
$message .= $head2 . "\n\n";
$message .= $s2 . "\n\n";
$message .= " \n\n";
$message .= $head3 . "\n\n";
$message .= $s3 . "\n\n";
$message .= " \n\n";
$message .= $head4 . "\n\n";
$message .= $s4 . "\n\n";
$message .= " \n\n";
$message .= "\n\n
![\"Наш](\"http://www.oborud.info/img/youtube_772x132_oborud_static_03.png\")
|
Информеры новостей от Oborud.info
|
|
C уважением, Oborud.info - Портал оборудования
Вы получили это письмо, так как являетесь подписчиком новостей Oborud.info.
Пожаловаться на рассылку | Отписаться от рассылки
Бесплатная публикация новостей на Oborud.info, подробности здесь »»
OBORUD.INFO © 2001 Интернет-справочник по оборудованию: торговое, холодильное, пищевое и другое оборудование
|
|
|
|
|
![\"Портал](\"http://www.oborud.info/img/youtube.png\")
![\"Виджет\"](\"http://www.oborud.info/img/ya.png\")
![\"RSS\"](\"http://www.oborud.info/img/rss2.png\")
![\"Twitter\"](\"http://www.oborud.info/img/twitter.png\")
![\"ВКонтакте\"](\"http://www.oborud.info/img/vkontakte.png\")
![\"Livejournal\"](\"http://www.oborud.info/img/livejournal.png\")
![\"Одноклассники\"](\"http://www.oborud.info/img/ok.png\")