private function updateTempalteCategoryByCategoryMap($siteId, $CategoryVersion)
{
try {
echo $siteId . "[" . $CategoryVersion . "]\n";
$this->configEbay($siteId);
$client = new eBaySOAP($this->session);
$Version = $this->version;
$params = array('Version' => $Version, 'DetailLevel' => 'ReturnAll', 'CategoryVersion' => $CategoryVersion);
$results = $client->GetCategoryMappings($params);
//---------- debug --------------------------------
//print "Request: \n".$client->__getLastRequest() ."\n";
//print "Response: \n".$client->__getLastResponse()."\n";
$this->saveFetchData("GetCategoryMappings-" . $siteId . "[" . $CategoryVersion . "]-" . date("Y-m-d H:i:s") . ".xml", $client->__getLastResponse());
foreach ($results->CategoryMapping as $CategoryMapping) {
$sql_1 = "update template set PrimaryCategoryCategoryID = " . $CategoryMapping->id . " where Site = '" . $siteName . "' and PrimaryCategoryCategoryID = " . $CategoryMapping->oldID;
//echo $sql_1."\n";
$result_1 = mysql_query($sql_1, eBayListing::$database_connect);
$num_rows = mysql_num_rows($result_1);
echo $siteName . ":Template have " . $num_rows . " count " . $CategoryMapping->oldID . " change to " . $CategoryMapping->id . "\n";
$sql_2 = "update share_template set PrimaryCategoryCategoryID = " . $CategoryMapping->id . " where Site = '" . $siteName . "' and PrimaryCategoryCategoryID = " . $CategoryMapping->oldID;
$result_2 = mysql_query($sql_2, eBayListing::$database_connect);
$num_rows = mysql_num_rows($result_2);
echo $siteName . ":Share template have " . $num_rows . " count " . $CategoryMapping->oldID . " change to " . $CategoryMapping->id . "\n";
}
sleep(10);
} catch (SOAPFault $f) {
print $f;
// error handling
}
}
