Esempio n. 1
0
 if (!empty($factionStandingsArray)) {
     $update_standings_faction = mysqli_query($con, "INSERT IGNORE INTO `trader`.`standings_faction` \n                        (`idstandings_faction`, \n                        `characters_eve_idcharacters`, \n                        `faction_eve_idfaction`, \n                        `value`) \n                        VALUES" . implode(', ', $factionStandingsArray)) or die(mysqli_error($con));
 } else {
     $newStandingsFaction = 0;
     $update_standings_faction = False;
 }
 $refID = 0;
 ///////////////////////////////////
 //Update ALL transactions for each character
 ////////////////////////////////////
 $newTransactions = fetchTransactions($apikey, $vcode, $refID, $idcharacter, $con);
 ///////////////////////////
 ///Update contracts
 /////////////////////////
 $pheal_contracts = new Pheal($apikey, $vcode, "char");
 $response = $pheal_contracts->Contracts(array("characterID" => $idcharacter));
 $getLatestContract = utils::mysqli_result(mysqli_query($con, "SELECT MAX(eve_idcontracts) FROM contracts WHERE characters_eve_idcharacters = '{$idcharacter}'"), 0, 0);
 $arrayfinal_contracts = array();
 //array with new contracts data
 $i = -1;
 //Store all new contracts, calculate how many contracts exceed the latest inserted ID, then delete all->insert all contracts from API again.
 $p = -1;
 $contracts_list_new = array();
 //stores a reference to all new contracts
 foreach ($response->contractList as $row) {
     $contractID = $row->contractID;
     $issuerID = $row->issuerID;
     $acceptorID = $row->acceptorID;
     if ($acceptorID == "") {
         $acceptorID = "NULL";
     }
<?php

require '../includes/config.php';
use Pheal\Pheal;
use Pheal\Core\Config;
Config::getInstance()->cache = new \Pheal\Cache\MemcacheStorage();
Config::getInstance()->access = new \Pheal\Access\StaticCheck();
$stmt = $db->prepare('DELETE FROM alliance_contracts WHERE 1=1');
$stmt->execute(array());
$stmt = $db->prepare('DELETE FROM alliance_contract_items WHERE 1=1');
$stmt->execute(array());
$corpKeyID = 4813754;
$corpVCode = 'TQb0AdlLKCwZcUoGkHbb6TTmZTAleIuxZtNdlHOqograHNNyLNerJewlonedsnqv';
$pheal = new Pheal($corpKeyID, $corpVCode, 'corp');
$contracts = $pheal->Contracts(array('corporationID' => '98098579'));
$stmt = $db->prepare('INSERT INTO alliance_contracts (contractID,issuerID,issuerName,corporationID,volume,title,price,status,doctrine,ship,end_date) VALUEs (?,?,?,?,?,?,?,?,?,?,?)' . 'ON DUPLICATE KEY UPDATE status=VALUES(status),doctrine=VALUES(doctrine),ship=VALUES(ship),end_date=VALUES(end_date)');
$stmt_items = $db->prepare('INSERT INTO alliance_contract_items (contractID,itemID,quantity) VALUES (?,?,?) ON DUPLICATE KEY UPDATE quantity = quantity + ?');
foreach ($contracts->contractList as $contract) {
    if ($contract['assigneeID'] == '150097440' and $contract['status'] == 'Outstanding' and $contract['startStationID'] == '61000829' and $contract['type'] == 'ItemExchange') {
        $parsed_string = get_string_between($contract['title'], '[', ']');
        if ($parsed_string != '' and $parsed_string != NULL) {
            $parsed_array = explode("-", $parsed_string);
            $doctrine = trim($parsed_array[0]);
            $ship = trim($parsed_array[1]);
        } else {
            $doctrine = 'Unknown';
            $ship = 'Unknown';
        }
        $stmt->execute(array($contract['contractID'], $contract['issuerID'], Character::lookupCharacterName($contract['issuerID'], $user), $contract['issuerCorpID'], $contract['volume'], $contract['title'], $contract['price'], $contract['status'], $doctrine, $ship, strtotime($contract['dateExpired'])));
        $contractItems = $pheal->ContractItems(array('contractID' => $contract['contractID']));
        foreach ($contractItems->itemList as $item) {
 public function updateMarketInformation()
 {
     if (2097152 & $this->accessMask and 67108864 & $this->accessMask) {
         $pheal = new Pheal($this->keyID, $this->vCode, 'char');
         try {
             // Wallet Journal pull
             $response = $pheal->WalletJournal(array("characterID" => $this->characterID, "rowCount" => 2560));
             $stmtJournal = $this->db->prepare('INSERT INTO user_walletjournal (character_id,journal_id,journal_date,journal_type,journal_fromname,journal_fromid,journal_toname,journal_toid,journal_specialid,journal_specialname,journal_amount,journal_balance,journal_reason) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE journal_amount=VALUES(journal_amount)');
             foreach ($response->transactions as $transaction) {
                 $stmtJournal->execute(array($this->characterID, $transaction->refID, $transaction->date, $transaction->refTypeID, $transaction->ownerName1, $transaction->ownerID1, $transaction->ownerName2, $transaction->ownerID2, $transaction->argID1, $transaction->argName1, $transaction->amount, $transaction->balance, $transaction->reason));
             }
             // Contracts pull
             $response = $pheal->Contracts(array('characterID' => $this->characterID));
             $stmtContract = $this->db->prepare('INSERT INTO user_contracts (character_id,contract_id,contract_issuerid,contract_issuercorpid,contract_assigneeid,contract_acceptorid,contract_startstationid,' . 'contract_endstationid,contract_type,contract_status,contract_title,contract_forcorp,contract_availability,contract_dateissued,contract_dateexpired,contract_dateaccepted,' . 'contract_numdays,contract_datecompleted,contract_price,contract_reward,contract_collateral,contract_buyout,contract_volume) VALUES ' . '(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE contract_acceptorid=VALUES(contract_acceptorid),contract_status=VALUES(contract_status),' . 'contract_dateaccepted=VALUES(contract_dateaccepted),contract_dateexpired=VALUES(contract_dateexpired),contract_datecompleted=VALUES(contract_datecompleted)');
             foreach ($response->contractList as $contract) {
                 $stmtContract->execute(array($this->characterID, $contract->contractID, $contract->issuerID, $contract->issuerCorpID, $contract->assigneeID, $contract->acceptorID, $contract->startStationID, $contract->endStationID, $contract->type, $contract->status, $contract->title, $contract->forCorp, $contract->availability, $contract->dateIssued, $contract->dateExpired, $contract->dateAccepted, $contract->numDays, $contract->dateCompleted, $contract->price, $contract->reward, $contract->collateral, $contract->buyout, $contract->volume));
             }
             // Contact List pull
             $response = $pheal->ContactList(array("characterID" => $this->characterID));
             $stmtJournal = $this->db->prepare('INSERT INTO user_contactlist (character_id,contact_type,contact_id,contact_name,contact_inwatchlist,contact_standing) VALUES (?,?,?,?,?,?) ON DUPLICATE KEY UPDATE contact_inwatchlist=VALUES(contact_inwatchlist),contact_standing=VALUES(contact_standing)');
             foreach ($response->contactList as $contact) {
                 $stmtJournal->execute(array($this->characterID, 'personal', $contact->contactID, $contact->contactName, $contact->inWatchlist, $contact->standing));
             }
             return TRUE;
         } catch (\Pheal\Exceptions\PhealException $phealException) {
             // Putting the pheal exception through our test function to determine if it's a key failure, or an API server failure.
             $this->testAPIKeyStatus($phealException);
             return FALSE;
         }
     } else {
         return TRUE;
     }
 }