.-.-.-.-.-

<?php
defined ( '_JEXEC' ) or die ( 'Restricted access' );

class modGetDataHelper {
	public function getData(){
		$config = & JFactory::getConfig();
		$db = &JFactory::getDBO();
		$query= "TRUNCATE TABLE #__articles";
		$db->setQuery($query);
		$db->query();
		$query= "TRUNCATE TABLE #__articles_cats";
		$db->setQuery($query);
		$db->query();
		$query = "SELECT introtext,title,catid,metakey,metadesc,hits FROM #__content WHERE catid>=12 AND catid<=33";
		$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('/<td>Дата выхода:<\/td><td>([0-9\.]{9,13})<\/td>/',$row->introtext, $matches);
			preg_match('/<td>([0-9\.]{9,13})<\/td>/',$row->introtext, $matches);
			$prop[$j]['date']=$matches[1];
			preg_match('/<td>([0-9]{1,4}) <\/td>/',$row->introtext, $matches);
			$prop[$j]['page_numbers']=$matches[1];
			preg_match('/Цена: ([0-9 ]{5,7} руб.)/',$row->introtext, $matches);
			$prop[$j]['price']=$matches[1];
			//preg_match('/>ОПИСАНИЕ<([0-9а-яА-Я *)>ОГЛАВЛЕНИЕ</',$row->introtext, $matches);
			$s = strpos($row->introtext, 'ОПИСАНИЕ');
			$e = strpos($row->introtext, 'ОГЛАВЛЕНИЕ');
			if($s!=0) $prop[$j]['about']=''.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('/<td>Дата выхода:<\/td><td>([0-9\.]{9,13})<\/td>/',$row->introtext, $matches);
			preg_match('/<td>([0-9\.]{9,13})<\/td>/',$row->introtext, $matches);
			$prop[$j]['date']=$matches[1];
			preg_match('/<td>([0-9]{1,4})<\/td>/',$row->introtext, $matches);
			$prop[$j]['page_numbers']=$matches[1];
			preg_match('/Цена: ([0-9 ]{5,7} руб.)/',$row->introtext, $matches);
			$prop[$j]['price']=$matches[1];
			//preg_match('/>ОПИСАНИЕ<([0-9а-яА-Я *)>ОГЛАВЛЕНИЕ</',$row->introtext, $matches);
			$s = strpos($row->introtext, 'ОПИСАНИЕ');
			$e = strpos($row->introtext, 'ОГЛАВЛЕНИЕ');
			if($s!=0) $prop[$j]['about']=''.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();
		}
	}

}
?>

/var/www/iplanru/data/./mod-tmp/../old/./www/i-plan.ru/modules/./mod_getdata/./helper.php