<?php
$mysqli=new mysqli(
ini_get('127.0.0.1'),
#'blablalba',
ini_get('mysqli.default_user'),
#'blablabla',
ini_get('mysqli.default_pw'),
(!defined("DB")?'mydb':DB)
);
if($mysqli->connect_error) { printf("DB connect failed: %s\n", mysqli_connect_error()); exit(); }
$mysqli->set_charset('utf8');
$query="SELECT texts.id,
texts.teaser,
texts.xhtml,
texts.
date_posted,
texts.views,
texts.description,
texts.keywords,
texts.title,
files_texts.file_id,
texts_categories.cat_id,
categories.title as catname,
texts_sources.source_title,
texts_sources.source_link
FROM `texts`
LEFT JOIN files_texts ON texts.id=files_texts.text_id
LEFT JOIN texts_categories ON texts.id=texts_categories.text_id
LEFT JOIN categories ON texts_categories.cat_id=categories.id
LEFT JOIN texts_sources ON texts.id=texts_sources.text_id
WHERE texts.news2=1
";
$RubrikId=7;
$i=0;
$id_last=99999;
if ($result = $mysqli->query($query))
{
while ($row = $result->fetch_assoc())
{
$url='/'.str_replace('-','/',substr($row['date_posted'],0,10)).'/'.$row['id'].'.html';
$date=str_replace('-','.', $row['date_posted']);
$date=str_replace(' ',',', $date);
$DokStart=strtotime($row['date_posted']);
$img='http://i.vladnews.ru/f/'.$row['file_id'].'/';
$title=str_replace("'","`",$row['title']);
$keywords=str_replace("'","`",$row['keywords']);
$description=str_replace("'","`",$row['description']);
$views=str_replace("'","`",$row['views']);
$source_link=str_replace("'","`",$row['source_link']);
$source_title=str_replace("'","`",$row['source_title']);
$xhtml=str_replace("'","`",$row['xhtml']);
$catname=str_replace("'","`",$row['catname']);
$teaser=str_replace("'","`",$row['teaser']);
$title=str_replace("'","`",$row['title']);
$id=str_replace("'","`",$row['id']);
$mysqli_1=new mysqli(
ini_get('127.0.0.1'),
#'blablabla',
ini_get('mysqli.default_user'),
#'blabla',
ini_get('mysqli.default_pw'),
(!defined("DB")?'avecms':DB)
);
if($mysqli_1->connect_error) { printf("DB connect failed: %s\n", mysqli_connect_error()); exit(); }
//$mysqli->set_charset('utf8');
$sql="INSERT INTO ave3_documents ( Id,RubrikId,Url,Titel,DokTyp,DokStart,DokEnde,DokEdi,Redakteur,Suche,MetaKeywords,MetaDescription,IndexFollow,DokStatus,Geloescht,Drucke,Geklickt,ElterNavi)
VALUES ($id,7,'$url','".$title."','',$DokStart,1886072400,
$DokStart,1,1,'".substr(0,100,$keywords)."','".substr(0,100,$description)."','index,follow',1,0,0,".$views.",0);";
$sql=$sql."
INSERT INTO ave3_document_fields ( Id,RubrikFeld,DokumentId,Inhalt,Suche)
VALUES
(NULL,35,$id,'".$date."',1 ),
(NULL,34,$id,'Author',1),
(NULL,54,$id,'".str_replace('/','[cp:replacement]',$source_link )."',1),
(NULL,33,$id,'".str_replace('/','[cp:replacement]',$source_title) ."',1),
(NULL,32,$id,'".str_replace('/','[cp:replacement]',$img) ."',1),
(NULL,31,$id,'".str_replace('/','[cp:replacement]',$xhtml) ."',1 ),
(NULL,36,$id,'Лента',1 ),
(NULL,28,$id,'".str_replace('/','[cp:replacement]',$catname) ."',1),
(NULL,30,$id,'".str_replace('/','[cp:replacement]',$teaser) ."',1 ),
(NULL,29,$id,'".str_replace('/','[cp:replacement]',$title) ."',1 );";
if($id_last != $id)
{
$fp = fopen('dump.txt', 'a+');
$test=fwrite($fp, $sql);
if ($test) echo 'Данные в файл успешно занесены.<br>';
else {echo 'Ошибка при записи в файл.<br><br>';exit();}
fclose($fp);
$id_last=$id;
echo $i++;
echo "<br>";
}
}
}
?>
|
