public function getCategories($categorySiteID = 0) { global $argv; if (!empty($argv[2])) { $this->setAccount(1); $this->configEbay($argv[2]); $categorySiteID = $argv[2]; } else { $this->setAccount(1); $this->configEbay($categorySiteID); //$categorySiteID = 0; } try { $client = new eBaySOAP($this->session); $CategorySiteID = $categorySiteID; $Version = $this->version; $DetailLevel = "ReturnAll"; $params = array('Version' => $Version, 'DetailLevel' => $DetailLevel, 'WarningLevel' => 'High', 'CategorySiteID' => $CategorySiteID, 'ViewAllNodes' => true); $results = $client->GetCategories($params); //---------- debug -------------------------------- //print "Request: \n".$client->__getLastRequest() ."\n"; //print "Response: \n".$client->__getLastResponse()."\n"; //var_dump($results); if (!empty($results->CategoryArray)) { $sql_00 = "update site set newCategoryVersion = " . $results->CategoryVersion . " where id = " . $CategorySiteID; echo $sql_00 . "\n"; $result_00 = mysql_query($sql_00, eBayListing::$database_connect); $sql_0 = "delete from categories where CategorySiteID = " . $CategorySiteID; echo $sql_0 . "\n"; $result_0 = mysql_query($sql_0, eBayListing::$database_connect); sleep(3); $this->saveFetchData("getCategories-" . $CategorySiteID . "-" . date("Y-m-d H:i:s") . ".xml", $client->__getLastResponse()); foreach ($results->CategoryArray->Category as $category) { $sql = "insert into categories (CategoryID,CategoryLevel,CategoryName,CategoryParentID,LeafCategory,BestOfferEnabled,AutoPayEnabled,SellerGuaranteeEligible,CategorySiteID) values \n\t\t ('" . $category->CategoryID . "','" . $category->CategoryLevel . "','" . mysql_real_escape_string($category->CategoryName) . "','" . $category->CategoryParentID . "',\n\t\t '" . $category->LeafCategory . "','" . $category->BestOfferEnabled . "','" . $category->AutoPayEnabled . "','" . $category->SellerGuaranteeEligible . "','" . $CategorySiteID . "')"; //echo $sql."\n"; $result = mysql_query($sql, eBayListing::$database_connect); //echo $CategorySiteID.":".$category->CategoryName."[".$category->CategoryID."]\n"; } } else { echo "failure.\n"; } } catch (SOAPFault $f) { print $f; // error handling } }