for ($i = 1; $i <= $pages; $i++) { print_r("page " . $i . "\n"); $cases = XML2Array::createArray($ebay->getCases(200, $i)); $cases = isset($cases["soapenv:Envelope"]["soapenv:Body"]["getUserCasesResponse"]["cases"]["caseSummary"]) ? $cases["soapenv:Envelope"]["soapenv:Body"]["getUserCasesResponse"]["cases"]["caseSummary"] : array(); if (!empty($cases)) { print_r("cases: " . count($cases) . "\n"); foreach ($cases as $j => $caseShort) { if (isset($caseShort['user']) && $caseShort['user']['userId'] == "chandlermotorsportsinc" && $caseShort['user']['role'] == "SELLER") { $sql = "SELECT * FROM cases where caseId = '" . $caseShort['caseId']['id'] . "'"; $rs = $db->Execute($sql); $row = $rs->FetchRow(); if (isset($row['caseId'])) { print_r("case: " . $row['caseId'] . " exists" . "\n"); continue; } $case = XML2Array::createArray($ebay->getCaseDetails($caseShort['caseId']['id'], $caseShort['caseId']['type'])); $case = isset($case["soapenv:Envelope"]["soapenv:Body"]["getEBPCaseDetailResponse"]) ? $case["soapenv:Envelope"]["soapenv:Body"]["getEBPCaseDetailResponse"] : array(); if (!isset($case['caseSummary']['caseId']['id'])) { $caseSummary = $caseShort; $caseDetail = array(); } else { $caseSummary = $case['caseSummary']; $caseDetail = isset($case['caseDetail']) ? $case['caseDetail'] : array(); } $status = isset($caseSummary['status']) ? array_values($caseSummary['status']) : array(); $tmp = array("caseId" => $caseSummary['caseId']['id'], "type" => isset($caseSummary['caseId']['type']) ? $caseSummary['caseId']['type'] : '', "userId" => isset($caseSummary['otherParty']['userId']) ? $caseSummary['otherParty']['userId'] : '', "status" => isset($status[0]) ? $status[0] : '', "itemId" => isset($caseSummary['item']['itemId']) ? $caseSummary['item']['itemId'] : '', "transactionId" => isset($caseSummary['item']['transactionId']) ? $caseSummary['item']['transactionId'] : '', "respondByDate" => isset($caseSummary["respondByDate"]) ? $caseSummary["respondByDate"] : '', "creationDate" => isset($caseSummary["creationDate"]) ? $caseSummary["creationDate"] : '', "lastModifiedDate" => isset($caseSummary["lastModifiedDate"]) ? $caseSummary["lastModifiedDate"] : '', "openReason" => isset($caseDetail["openReason"]) ? $caseDetail["openReason"] : '', "decision" => isset($caseDetail["decision"]) ? $caseDetail["decision"] : '', "agreedRefundAmount" => isset($caseDetail["agreedRefundAmount"]) ? $caseDetail["agreedRefundAmount"] : '', "detailStatus" => isset($caseDetail["detailStatus"]) ? $caseDetail["detailStatus"] : '', "initialBuyerExpectation" => isset($caseDetail["initialBuyerExpectation"]) ? $caseDetail["initialBuyerExpectation"] : ''); $updateSQL = $db->GetInsertSQL($rs, $tmp); $db->Execute($updateSQL); } } } else {