/copy_news/parser_akcii.php

<?php

$db = mysql_connect('localhost', 'citrus_mobile', 'KLcZat4aKMrrBEF7');

mysql_select_db('citrus_mobile', $db);		

mysql_query ("set character_set_client='cp1251'");

mysql_query ("set character_set_results='cp1251'");

mysql_query ("set collation_connection='cp1251_general_ci'");





$arr_akcii=array();

$arr_upp=array();

$arr_add=array();





$ii=1;

$sql="SELECT * from akcii";

$result = mysql_query($sql, $db);

while ($r = mysql_fetch_array($result))

{

	$arr_akcii[$ii]=array('ID'=>$r['ID'], 'TIMESTAMP_X'=>$r['TIMESTAMP_X']);

	$ii++;

}

mysql_close($db);

//-------------------------------------



$db = mysql_connect('localhost', 'citrus_store', 'vSpYAxRujDfNtneX11a');

mysql_select_db('citrus_store', $db);		

mysql_query ("set character_set_client='cp1251'");

mysql_query ("set character_set_results='cp1251'");

mysql_query ("set collation_connection='cp1251_general_ci'");

$ii=0;

$i_bl=32;

$upp=0;

$add=0;

$sql="SELECT * from b_iblock_element WHERE (IBLOCK_ID=".$i_bl." 

AND WF_PARENT_ELEMENT_ID IS NULL)";

$result = mysql_query($sql, $db);

while ($r = mysql_fetch_array($result))

{

	$found=0;

	foreach ($arr_akcii as $key => $value) {

	if ($value['ID']==$r['ID']) {

		$found = $key;

		break;

		}

	}

	//echo "ID=".$r['ID']." found=".$found."<br />";

	//-------------------------------------------- #ÇÀÏÈÑÜ ÍÀ ÀÏÄÅÉÒ

	if ($found>0 AND $r['TIMESTAMP_X']!=$arr_akcii[$found]['TIMESTAMP_X'])

	{

		//echo "2".$arr_akcii[$found]['TIMESTAMP_X'];

		$upp++;

		$arr_upp[$upp]=array('ID'=>$r['ID'], 'DATE_CREATE'=>$r['DATE_CREATE'], 'TIMESTAMP_X'=>$r['TIMESTAMP_X'], 

		'ACTIVE'=>$r['ACTIVE'],

		'NAME'=>$r['NAME'],

		'PREVIEW_PICTURE'=>$r['PREVIEW_PICTURE'],

		'PREVIEW_TEXT'=>$r['PREVIEW_TEXT'],

		'DETAIL_TEXT'=>$r['DETAIL_TEXT']);

	}

	//-------------------------------------------- #ÇÀÏÈÑÜ ÍÀ ÀÏÄÅÉÒ

	

	//-------------------------------------------- ÇÀÏÈÑÜ ÍÀ ÄÎÁÀÂËÅÍÈÅ

	if ($found==0)

	{

		$add++;

		$arr_add[$add]=array('ID'=>$r['ID'], 'DATE_CREATE'=>$r['DATE_CREATE'], 'TIMESTAMP_X'=>$r['TIMESTAMP_X'], 

		'ACTIVE'=>$r['ACTIVE'],

		'NAME'=>$r['NAME'],

		'PREVIEW_PICTURE'=>$r['PREVIEW_PICTURE'],

		'PREVIEW_TEXT'=>$r['PREVIEW_TEXT'],

		'DETAIL_TEXT'=>$r['DETAIL_TEXT']);

	}

	//-------------------------------------------- #ÇÀÏÈÑÜ ÍÀ ÄÎÁÀÂËÅÍÈÅ

	

}

mysql_close($db);



if ($add>0)

{

	$db = mysql_connect('localhost', 'citrus_mobile', 'KLcZat4aKMrrBEF7');

	mysql_select_db('citrus_mobile', $db);		

	mysql_query ("set character_set_client='cp1251'");

	mysql_query ("set character_set_results='cp1251'");

	mysql_query ("set collation_connection='cp1251_general_ci'");

	

	$c_add=0;

	for ($jj=1; $jj<=$add; $jj++)

	{

		$c_add++;

		$sql="INSERT INTO akcii (ID, DATE_CREATE, TIMESTAMP_X, ACTIVE, NAME, PREVIEW_PICTURE, PREVIEW_TEXT, DETAIL_TEXT) VALUES 

		(".$arr_add[$jj]['ID'].",'".$arr_add[$jj]['DATE_CREATE']."', '".$arr_add[$jj]['TIMESTAMP_X']."', '".$arr_add[$jj]['ACTIVE']."', '".$arr_add[$jj]['NAME']."', '".$arr_add[$jj]['PREVIEW_PICTURE']."', '".trim($arr_add[$jj]['PREVIEW_TEXT'])."', '".trim($arr_add[$jj]['DETAIL_TEXT'])."')";

		mysql_query($sql, $db);

	}

	mysql_close($db);

}





if ($upp>0)

{

	$c_upp=0;

	$db = mysql_connect('localhost', 'citrus_mobile', 'KLcZat4aKMrrBEF7');

	mysql_select_db('citrus_mobile', $db);		

	mysql_query ("set character_set_client='cp1251'");

	mysql_query ("set character_set_results='cp1251'");

	mysql_query ("set collation_connection='cp1251_general_ci'");

	

	for ($jj=1; $jj<=$upp; $jj++)

	{

		$c_upp++;

		$sql="UPDATE akcii set `TIMESTAMP_X`='".$arr_upp[$jj]['TIMESTAMP_X']."', 

		`NAME`='".$arr_upp[$jj]['NAME']."',

		`PREVIEW_PICTURE`='".$arr_upp[$jj]['PREVIEW_PICTURE']."',

		`PREVIEW_TEXT`='".trim($arr_upp[$jj]['PREVIEW_TEXT'])."',

		`DETAIL_TEXT`='".trim($arr_upp[$jj]['DETAIL_TEXT'])."'

		WHERE (ID=".$arr_upp[$jj]['ID'].")";

		mysql_query($sql, $db);

	}

	

	

	mysql_close($db);

}







echo "Äîáàâëåíî ".$c_add."<br />";

echo "Îáíîâëåíî ".$c_upp."<br />";







?>