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 } }