public function getCategory2CS($categorySiteID = 0) { global $argv; if (!empty($argv[2])) { $this->setAccount(1); $this->configEbay($argv[2]); $categorySiteID = $argv[2]; } $sql = "delete from CharacteristicsSets where SiteID = '" . $categorySiteID . "'"; $result = mysql_query($sql, eBayListing::$database_connect); try { echo $this->site_id; echo "\n"; $client = new eBaySOAP($this->session); $Version = $this->version; $DetailLevel = "ReturnAll"; $params = array('Version' => $Version, 'DetailLevel' => $DetailLevel); $results = $client->GetCategory2CS($params); $this->saveFetchData("GetCategory2CS-" . date("Y-m-d H:i:s") . ".xml", $client->__getLastResponse()); foreach ($results->MappedCategoryArray->Category as $category) { $sql = "insert into CharacteristicsSets (SiteID,CategoryID,Name,AttributeSetID,AttributeSetVersion) values \n\t\t('" . $categorySiteID . "','" . $category->CategoryID . "','" . $category->CharacteristicsSets->Name . "',\n\t\t'" . $category->CharacteristicsSets->AttributeSetID . "','" . $category->CharacteristicsSets->AttributeSetVersion . "')"; echo $sql . "\n"; $result = mysql_query($sql, eBayListing::$database_connect); } echo "\n****************************************************************\n"; flush(); //exit(); } catch (SOAPFault $f) { print $f; // error handling } }