<?php

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


//------------------------------------------выборка SAMSUNG, NOKIA, LG, SONY
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND (bise.IBLOCK_SECTION_ID=149 OR bise.IBLOCK_SECTION_ID=150 OR bise.IBLOCK_SECTION_ID=151 OR bise.IBLOCK_SECTION_ID=566))";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------


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

//------------------------------------------выборка HTC
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=239)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1.05;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1.05=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------


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

//------------------------------------------выборка HUAWEI
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=626)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1.09;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1.09=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------




echo "DONE!";
?>