'.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'ОГЛАВЛЕНИЕ'); $e = strpos($row->introtext, 'ПРИЛОЖЕНИЯ'); if($e==0) $e = strpos($row->introtext, 'Ключевые слова'); if($s!=0) $prop[$j]['oglav']=''.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'ПРИЛОЖЕНИЯ'); $e = strpos($row->introtext, 'Ключевые слова'); if($s!=0) $prop[$j]['prilog']=''.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'Ключевые слова'); $e = strpos($row->introtext, 'Ссылка на страницу'); if($s!=0) $prop[$j]['keywords']=''.substr($row->introtext, $s, $e-$s).'
'; $j++; } foreach ($prop as $cur_prop){ $id = $cur_prop['id']; $type = $cur_prop['type']; $category = $cur_prop['category']; $title = $cur_prop['title']; $date = $cur_prop['date']; $date = $date[6].$date[7].$date[8].$date[9].'-'.$date[3].$date[4].'-'.$date[0].$date[1]; $page_numbers = $cur_prop['page_numbers']; $price = $cur_prop['price']; $about = $cur_prop['about']; $oglav = $cur_prop['oglav']; $prilog = $cur_prop['prilog']; $keywords = $cur_prop['keywords']; $metakey = $cur_prop['metakey']; $metadesc = $cur_prop['metadesc']; $hits = $cur_prop['hits']; $query="INSERT INTO #__articles VALUES ('','$id','$type','$category','$title','$date','$page_numbers','$price','$about','$oglav','$prilog','$keywords','$metakey','$metadesc','$hits')"; $db->setQuery($query); $db->query(); $query="INSERT INTO #__articles_cats VALUES('$id','$category')"; $db->setQuery($query); $db->query(); } $query = "SELECT introtext,title,catid,metakey,metadesc,hits FROM #__content WHERE catid>=112 AND catid<=133"; $db->setQuery($query); $result = $db->loadObjectList(); $j=1; foreach ( $result as $row ) { preg_match('/(bp|mi)_([0-9]{1,3})\.(png|gif)/', $row->introtext, $matches); $prop[$j]['type']=$matches[1]; $prop[$j]['id']=$matches[2]; $prop[$j]['title']=$row->title; $prop[$j]['category']=$row->catid; $prop[$j]['metakey']=$row->metakey; $prop[$j]['metadesc']=$row->metadesc; $prop[$j]['hits']=$row->hits; //preg_match('/'.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'ОГЛАВЛЕНИЕ'); $e = strpos($row->introtext, 'ПРИЛОЖЕНИЯ'); if($e==0) $e = strpos($row->introtext, 'Ключевые слова'); if($s!=0) $prop[$j]['oglav']=''.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'ПРИЛОЖЕНИЯ'); $e = strpos($row->introtext, 'Ключевые слова'); if($e==0) $e = strpos($row->introtext, 'Вернуться к списку маркетинговых исследований'); if($s!=0) $prop[$j]['prilog']=''.substr($row->introtext, $s, $e-$s).'
'; $s = strpos($row->introtext, 'Ключевые слова'); $e = strpos($row->introtext, 'Ссылка на страницу'); if($s!=0) $prop[$j]['keywords']=''.substr($row->introtext, $s, $e-$s).'
'; $j++; } foreach ($prop as $cur_prop){ $id = $cur_prop['id']; $type = $cur_prop['type']; $category = $cur_prop['category']; $title = $cur_prop['title']; $date = $cur_prop['date']; $date = $date[6].$date[7].$date[8].$date[9].'-'.$date[3].$date[4].'-'.$date[0].$date[1]; $page_numbers = $cur_prop['page_numbers']; $price = $cur_prop['price']; $about = $cur_prop['about']; $oglav = $cur_prop['oglav']; $prilog = $cur_prop['prilog']; $keywords = $cur_prop['keywords']; $metakey = $cur_prop['metakey']; $metadesc = $cur_prop['metadesc']; $hits = $cur_prop['hits']; $query="INSERT INTO #__articles VALUES ('','$id','$type','$category','$title','$date','$page_numbers','$price','$about','$oglav','$prilog','$keywords','$metakey','$metadesc','$hits')"; $db->setQuery($query); $db->query(); $query="INSERT INTO #__articles_cats VALUES('$id','$category')"; $db->setQuery($query); $db->query(); } } } ?>