/copy_news/copy_akcii.php

<?php

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

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

//-------------------------------------------------------------  акнй юйжхх

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

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

//--------------------------------------------------- ондявер гюохяеи б хяундмни рюакхже

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

mysql_select_db('citrus_store', $db);		

$i_bl=32;

$sql="SELECT ID from b_iblock_element WHERE (IBLOCK_ID=".$i_bl." AND WF_PARENT_ELEMENT_ID IS NULL)";

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

$num_rows1 = mysql_num_rows($result);

mysql_close($db);

//--------------------------------------------------- #ондявер гюохяеи б хяундмни рюакхже

//---

//--------------------------------------------------- ондявер гюохяеи б жекебни рюакхже

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

mysql_select_db('citrus_mobile', $db);		

$sql="SELECT ID FROM akcii";

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

$num_rows2 = mysql_num_rows($result);

mysql_close($db);

//--------------------------------------------------- #ондявер гюохяеи б жекебни рюакхже

echo "хЯУНДМЮЪ РЮАКХЖЮ [".$num_rows1."] --- жЕКЕБЮЪ РЮАКХЖЮ [".$num_rows2."]<br />";



//---



if ($num_rows1>$num_rows2)

{

	//---------------------------------------------------------------мюонкмъел астепмши люяяхб

	$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;

	$sql="SELECT * from b_iblock_element WHERE (IBLOCK_ID=".$i_bl." AND WF_PARENT_ELEMENT_ID IS NULL) ORDER BY ID ASC";

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

	while ($r = mysql_fetch_array($result))

	{

		$p_pic=$r['PREVIEW_PICTURE'];

		$d_pic=$r['DETAIL_PICTURE'];

		$arr_to[$ii]["ID"]=$r['ID'];

		$arr_to[$ii]["DATE_CREATE"]=$r['DATE_CREATE'];

		$arr_to[$ii]["ACTIVE"]=$r['ACTIVE'];

		$arr_to[$ii]["NAME"]=$r['NAME'];

		$arr_to[$ii]["PREVIEW_TEXT"]=trim($r['PREVIEW_TEXT']);

		if ($r['PREVIEW_PICTURE']!="")

		{

			$sql2="SELECT * from b_file WHERE (ID=".$p_pic.")";

			$result2 = mysql_query($sql2, $db);

			while ($r2 = mysql_fetch_array($result2))

			{

				$arr_to[$ii]["PREVIEW_PICTURE"]='<img src="http://www.citrus.ua/upload/';

				$arr_to[$ii]["PREVIEW_PICTURE"].=$r2['SUBDIR'];

				$arr_to[$ii]["PREVIEW_PICTURE"].='/';

				$arr_to[$ii]["PREVIEW_PICTURE"].=$r2['FILE_NAME'];

				$arr_to[$ii]["PREVIEW_PICTURE"].='" />';

			}

		}

		$what="/images/";

		$to="http://www.citrus.ua/images/";

		$arr_to[$ii]["DETAIL_TEXT"]=str_replace($what, $to, trim($r['DETAIL_TEXT']));

		$ii++;

	}

	mysql_close($db);

	//---------------------------------------------------------------  #мюонкмъел астепмши люяяхб

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

	

	

	

//	echo $arr_to[0]['NAME'];

	

	

	//-------------------------------------------------------------- вхярхл жекебсч рюакхжс х мюонкмъел ее





	$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'");

	mysql_query("Delete from `akcii`");



	for ($jj=0; $jj<$ii; $jj++)

	{

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

		('".$arr_to[$jj]['DATE_CREATE']."', '".$arr_to[$jj]['ACTIVE']."', '".$arr_to[$jj]['NAME']."', '".$arr_to[$jj]['PREVIEW_PICTURE']."', '".$arr_to[$jj]['PREVIEW_TEXT']."', '".$arr_to[$jj]['DETAIL_TEXT']."')";

		mysql_query($sql, $db);

	}

	



	$sql="SELECT * FROM akcii ORDER BY DATE_CREATE DESC LIMIT 4";

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

	while ($r = mysql_fetch_array($result))

	{

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

		echo $r['DATE_CREATE']."<br />";

		echo $r['ACTIVE']."<br />";

		echo $r['NAME']."<br />";

		echo $r['PREVIEW_PICTURE']."<br />";

		echo $r['PREVIEW_TEXT']."<br />";

		//echo $r['DETAIL_TEXT']."<br />";

		echo "<br /><br />";

	}

	mysql_close($db);

	//--------------------------------------------------------------    #вхярхл жекебсч рюакхжс х мюонкмъел ее

}

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

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

//-------------------------------------------------------------  #акнй юйжхх

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

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





?>