Subversion-Projekte lars-tiefland.content-management

<?

	// forget about any script timeouts

	set_time_limit(0);

	define ("ITEMTYPES_AUCTION", 1);

	define ("CURRENCYENUM_USDOLLAR", 1);

	define ("CURRENCYENUM_EURO", 7);

	define ("SHIPPINGRANGEENUM_SITEONLY", '0');

	require_once "/web/apache/content-management/ebayphpat/Ebay_ItemSellerQuery.php";

	$mySession = new Ebay_Session();

	$mySession->InitFromConfig("/web/apache/content-management/ebay.config");

	global $theItem;

	$theItem = null;

	function AddItem($session,$ItemData)

	{

		global $theItem;

		$theItem = new Ebay_Item($session);

		if

		(

			($ItemData[StartPrice] == 0)

			&&

			($ItemData[BuyItNowPrice] > 0)

		)

		{

			$ItemData[StartPrice] == $zeile[BuyItNowPrice];

			$ItemData[BuyItNowPrice]='';

			$theItem->setPropIsFixedPrice(true);

		}

		foreach(array_keys($ItemData) as $elem)

		{

			if ($ItemData[$elem])

			{

				$theItem->{"set".$elem}($ItemData[$elem]);

			}

		}

		return $theItem->Add();

	}

/* ------------------------------------------------------------------------------------------------ */

	mysql_connect("localhost","content_managem","k-dp-u");

	mysql_query("use mediaran_de");

	// Settings laden

	$query=

	"

		select

			Name,

			Inhalt

		from

			eBay_settings

		where

			Name = 'Location'

			or Name = 'Currency'

			or Name = 'Country'

			or Name = 'Region'

	";

	$result=mysql_query($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");

	$settings=array();

	while ($zeile=mysql_fetch_assoc($result)) {$settings[$zeile[Name]]=$zeile[Inhalt];}

	// WIRD VON DER SANDBOX BENÖTIGT. KANN IN DER PRODUKTIONSUMGEBUNG WEG.

	//$settings[Currency]=1;

	// Auktionsdaten laden

	$query=

	"

		select

			eBay_Auktionen.ID,

			eBay_Auktionen.Title													as Title,

			eBay_Auktionen.Description												as Description,

			eBay_Auktionen.Category													as CategoryId,

			eBay_Auktionen.Quantity													as Quantity,

			eBay_Auktionen.MinimumBid												as StartPrice,

			if (eBay_Auktionen.BuyItNowPrice > 0,eBay_Auktionen.BuyItNowPrice,'')	as BuyItNowPrice,

			eBay_Auktionen.SubtitleText												as SubtitleText,

			eBay_Auktionen.Category2												as Category2Id,

			eBay_Auktionen.Duration													as Duration,

			eBay_Auktionen.Private													as PropPrivate,

			'true' 																	as PaymentTermsSeeDescription,

			if (eBay_Auktionen.Gallery = '','','true')								as PropGallery,

			if (eBay_Auktionen.Featured = '','','true')								as PropFeatured,

			if (eBay_Auktionen.BoldTitle = '','','true')							as PropBoldTitle,

			if (eBay_Auktionen.HighLight = '','','true')							as PropHighLight,

			eBay_Auktionen.Gallery													as GalleryURL,

			concat('http://pictures.weban.de/35/',artikel.bild_6_url)				as PictureURL,

		from

			eBay_Auktionen,artikel

		where

			eBay_Auktionen.artikel_ID = artikel.ID

		and

			artikel.Language='DE'

		and

			eBay_Id = 0

		and

			eBay_error = ''

		and

			ListingStartDay <= NOW()

		and

			ListingStartTime <= NOW()

	";

	$result=mysql_query($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");

	while ($AuktionsData=mysql_fetch_assoc($result))

	{

		$zeile=array_merge($settings,$AuktionsData);

		unset($zeile[ID]);

		$eBayRes=AddItem($mySession,$zeile);

		if ($eBayRes->isGood())

		{

			$names=array();

			$values=array();

			foreach($eBayRes->_xmlValues as $elem)

			{

				if ($elem[type] == "complete")

				{

					$names[]=$elem[tag];

					$values[]=$elem[value];

				}

			}

			mysql_query("insert into eBay_AuktionsDaten (".implode(",",$names).") values ('".implode("','",$values)."')") or mail("lautsch@weban.de","eBay runQueue: Fehler bei insert into insert into eBay_AuktionsDaten",mysql_errno().": ".mysql_error(),"from: runQueue");

		}

		mysql_query ("update eBay_Auktionen set eBay_Id=".$theItem->getId()." where ID = ".$AuktionsData[ID]);

		mysql_query ("update eBay_Auktionen set eBay_error='".serialize($eBayRes->_errors)."' where ID = ".$AuktionsData[ID]);

	}

/* ------------------------------------------------------------------------------------------------ */

?>