<?php

@ob_flush();
@flush();
@ini_set('max_execution_time', 1800); //300 seconds = 5 minutes
set_time_limit(0);

//error_reporting(E_ALL);
//ini_set('display_errors', '1');

//======Setari
$server_name="localhost";
$db_name = "beauxprod";
$db_user = "root";
$db_pass = "";
mysql_connect($server_name, $db_user, $db_pass);
mysql_select_db($db_name)
or die(mysql_error());
$db2_name="beaux";
$db2_user = "root";
$db2_pass = "mataigay";
//======SF SETARI


$nrpoza=0;
$result = mysql_query("SELECT * FROM products order by id ASC");
if (!$result)
{
die('Could not query:' . mysql_error());
}
else
while ($row = mysql_fetch_array( $result ))
	{
		$visible=$row[visible];
		//if ($visible==1)
			{
			$k++;
			if($k<=3)
			{
			$id=$row[id];
			$title=$row[title];
			$catid=$row[catid];
			$subcatid=$row[subcatid];
			$tricatid=$row[tricatid];

			//echo $title.' '.$id.' ';
			$desc=$row[desc];
			$video=$row[video];
			$price=$row[price];
			//echo '<script>alert("'.$price.'");</script>';
			$stock=$row[stock];
			//if (!is_numeric($stock))
				//$stock=999;
			if($stock>0)
				{
				}
				else
				{
				$stock=0;
				}

			//if($stock>0)
			{

			mysql_connect($server_name, $db2_user, $db2_pass);
			mysql_select_db($db2_name)
			or die(mysql_error());

			if (mysql_num_rows(mysql_query("SELECT * FROM ps_product WHERE id_product='$id'")))

				{
				//updatam stocku`
				mysql_query("UPDATE ps_product SET quantity='$stock' WHERE id_product='$id'") or die(mysql_error());
				}
				else
			{
			$desc=strip_tags($desc);
			$desc=htmlspecialchars_decode($desc);
			$video=htmlspecialchars_decode($video);

			//shortdesc
			$o=0;
			$dot='';
			$shortdesc='';
			while(($dot<>'.') && ($o<250))
			{
			$dot=$desc[$o];
			$shortdesc=$shortdesc.$dot;
			$o++;
			}
			//sf shortdesc


			//$title=utf8_encode($title);
			$tags='';
			$title2=str_replace(',',' ',$title);
			$taguri=explode(' ',$title2);
			$tags=$taguri[0];
			for($o=1;$o<=count($taguri)-1;$o++)
				{
				if(strlen($taguri[$o])>=2)
					$tags=$tags.','.$taguri[$o];
				}
			//echo $title2.'         '.$tags.'<br>';



			//$desc='';
			$price=trim($price);
			$price=str_replace(',','.',$price);


			$sku=strtolower(preg_replace(array('/[^a-zA-Z0-9 -]/', '/[ -]+/', '/^-|-$/'),'',$title));


			$iduri=$catid.','.$subcatid.','.$tricatid;
			//echo $iduri;

			$iduri=explode(',',$iduri);
			$m=count($iduri)-1;
			//echo $m;
			$l=0;
			for($i=0;$i<=$m;$i++)
				{
				$ok=1;
				for($j=0;$j<=$i-1;$j++)
					if ($iduri[$i]==$iduri[$j])
						$ok=0;
				if ($iduri[$i]=='none')
					$ok=0;

				if ($ok==1)
					{
					$l++;
					$v[$l]=$iduri[$i];
					//echo $v[$l];
					}
				}

			$m=$l;
			$v[1]='1';
			$iduri='1';
			for($i=2;$i<=$m;$i++)
				$iduri=$iduri.','.$v[$i];

			//$iduri='1,'.$iduri;
			//echo $iduri;

			/*

			echo $title;
			echo '<br>';
			echo $desc;
			echo '<br>';
			echo $price;
			echo '<br>';
			echo $stock;
			echo '<br>';
			echo $catid;
			echo '<br>';
			echo $subcatid;
			echo '<br>';
			echo $tricatid;
			echo '<br>';
			echo $iduri;
			echo '<br>';
			echo '<br>';
			echo '<br>';

			*/
			//inceput imagine
			mysql_connect($server_name, $db_user, $db_pass);
			mysql_select_db($db_name)
			or die(mysql_error());



			$photos='';
			$i=0;
			$result2 = mysql_query("SELECT * FROM photos WHERE productid='$id' ");
			mysql_connect($server_name, $db2_user, $db2_pass);
			mysql_select_db($db2_name)
			or die(mysql_error());

			if (!$result2)
			{
			die('Could not query:' . mysql_error());
			}
			else
			while ($row2 = mysql_fetch_array( $result2 ))
				{
				$i++;
				//$nrpoza++;
				$link=$row2[link];
				$cover=0;
				if($i==1)
					$cover=1;
				mysql_query("INSERT INTO ps_image (`id_image`,`id_product`,`position`,`cover`) 	 VALUES ('','$id','$i','$cover') ") 	or die(mysql_error());
					$result3=mysql_query("SELECT * FROM ps_image WHERE id_product='$id' and position='$i'");
					$row3=mysql_fetch_array($result3);
					$nrpoza=$row3[id_image];
				$nume=$id.'-'.$nrpoza.'.jpg';
				$file=dirname(__FILE__) ."\\"."tmp"."\\".$nume;
				$poza=$link;
				//echo $file;

				if (!is_file($file))
					{
					$fp = fopen ($file, "w+");//This is the file where we save the information

					$ch = curl_init($poza);
					curl_setopt($ch, CURLOPT_URL, $poza);
					curl_setopt($ch, CURLOPT_FILE, $fp);
					curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
					//curl_setopt($ch, CURLOPT_HEADERFUNCTION, 'read_header');
					curl_exec($ch);
					fclose($fp);


					for($j=1;$j<=3;$j++)
						{
						mysql_query("INSERT INTO ps_image_lang (`id_image`,`id_lang`,`legend`) 	 VALUES ('$nrpoza','$j','$title') ") 	or die(mysql_error());
						}

					}
				}

			/*echo $photos;
			*/

			//$desc='testdesc';
			$desc=str_replace(";","",$desc);
			$shortdesc=str_replace(";","",$shortdesc);
			$title=str_replace(";","",$title);
			$metatitle='';
			for($i=0;$i<=119;$i++)
				$metatitle=$metatitle.$title[$i];
			$metadesc='';
			for($i=0;$i<=119;$i++)
				$metadesc=$metadesc.$desc[$i];
			//$metadesc=utf8_encode($metadesc);
			//echo $desc;
			$price=$price;
			//$desc=$desc.'<br>'.$video;
			$data=$id.';1;'.$title.';'.$iduri.';'.$price.';1;'.$stock.';'.$shortdesc.';'.$desc.';'.$tags.';'.$metatitle.';'.$tags.';'.$metadesc.';'.$photos.'pulenci';



		mysql_query("INSERT INTO ps_product (`id_product`,`id_supplier`,`id_manufacturer`,`id_tax`,`id_category_default`,`id_color_default`,`on_sale`,`ean13`,`ecotax`,`quantity`,`price`,`out_of_stock`,`active`,`indexed`,`date_add`,`date_upd`) 	 VALUES ('$id','0','0','0','1','0','1','','0','$stock','$price','2','1','1',now(),now()) ") 	or die(mysql_error());

//".addslashes($title)."','".addslashes($cat)."','".addslashes($subcat)."','".addslashes($tricat)."','$catid','$subcatid','$tricatid','".addslashes($desc)."','".addslashes($video)."','".$url."','$visible
			for($i=1;$i<=$m;$i++)
				{
				//echo $i.' '.$v[$i].'<br>';
				$idcat=$v[$i];
				mysql_query("INSERT INTO ps_category_product (`id_category`,`id_product`,`position`) 	 VALUES ('$idcat','$id','') ") 	or die(mysql_error());

				}
			for($j=1;$j<=3;$j++)
				{
				mysql_query("INSERT INTO ps_product_lang (`id_product`,`id_lang`,`description`,`description_short`,`link_rewrite`,`meta_description`,`meta_keywords`,`meta_title`,`name`,`available_now`,`available_later`) 	 VALUES ('$id','$j','".mysql_real_escape_string($desc)."','".mysql_real_escape_string($shortdesc)."','','".mysql_real_escape_string($metadesc)."','$tags','".mysql_real_escape_string($title)."','".mysql_real_escape_string($title)."','','') ") 	or die(mysql_error());

				}



			}


			}
			}
		}
	}

?>