index.php | searchcode

/copy_news/index.php

https://bitbucket.org/spivovartsev/citrus.ua
PHP | 360 lines | 242 code | 49 blank | 69 comment | 18 complexity | 7819d6a27259e8e07948a0adf70f0188 MD5 | raw file
Possible License(s): BSD-3-Clause

<?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]["TIMESTAMP_X"]=$r['TIMESTAMP_X'];

		$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 (ID, DATE_CREATE, TIMESTAMP_X, ACTIVE, NAME, PREVIEW_PICTURE, PREVIEW_TEXT, DETAIL_TEXT) VALUES 

		(".$arr_to[$jj]['ID'].",'".$arr_to[$jj]['DATE_CREATE']."', '".$arr_to[$jj]['TIMESTAMP_X']."', '".$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);

	}

	

	echo "<h2>юйжхх</h2><br />";

	$sql="SELECT * FROM akcii ORDER BY TIMESTAMP_X DESC LIMIT 5";

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

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

}

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

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

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

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

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











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

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

//-------------------------------------------------------------  акнй мнбнярх

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

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

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

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

mysql_select_db('citrus_store', $db);		

$i_bl=3;

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

$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]["TIMESTAMP_X"]=$r['TIMESTAMP_X'];

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



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

	{

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

		(".$arr_to[$jj]['ID'].", '".$arr_to[$jj]['DATE_CREATE']."', '".$arr_to[$jj]['TIMESTAMP_X']."', '".$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);

	}

	

	echo "<h2>мнбнярх</h2><br />";

	$sql="SELECT * FROM news ORDER BY TIMESTAMP_X DESC LIMIT 5";

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

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

}

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

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

//-------------------------------------------------------------  #акнй мнбнярх

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

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













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

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

//-------------------------------------------------------------  акнй нагнпш

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

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

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

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

mysql_select_db('citrus_store', $db);		

$i_bl=61;

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

$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]["TIMESTAMP_X"]=$r['TIMESTAMP_X'];

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



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

	{

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

		(".$arr_to[$jj]['ID'].", '".$arr_to[$jj]['DATE_CREATE']."', '".$arr_to[$jj]['TIMESTAMP_X']."', '".$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);

	}

	

echo "<h2>нагнпш</h2><br />";

	$sql="SELECT * FROM obzori ORDER BY TIMESTAMP_X DESC LIMIT 5";

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

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

}

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

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

//-------------------------------------------------------------  #акнй нагнпш

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

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

?>