Пример #1
0
 }
 if (!empty($values_contracts)) {
     $delete_old_contracts = mysqli_query($con, "DELETE FROM contracts WHERE characters_eve_idcharacters = '{$idcharacter}'");
     $update_contracts = mysqli_query($con, "INSERT IGNORE INTO `trader`.`contracts` " . "(`eve_idcontracts`, " . "`issuer_id`, " . "`acceptor_id`, " . "`status`, " . "`availability`," . "`type`, " . "`creation_date`, " . "`expiration_date`, " . "`accepted_date`, " . "`completed_date`, " . "`price`, " . "`reward`, " . "`colateral`," . "`volume`, " . "`fromStation_eve_idstation`, " . "`toStation_eve_idstation`, " . "`characters_eve_idcharacters`) " . "VALUES " . implode(', ', $values_contracts)) or die(mysqli_error($con));
     $newContracts = $new_c;
 } else {
     $newContracts = 0;
     $update_contracts = False;
 }
 ////////////////////////////
 //Update Market Orders
 /////////////////////////////
 $i = -1;
 $pheal_orders = new Pheal($apikey, $vcode, "char");
 //set scope
 $response_orders = $pheal->MarketOrders(array("characterID" => $idcharacter));
 //add parameters
 $existingOrders = array();
 $arrayfinal_orders = array();
 $getExistingOrders = mysqli_query($con, "SELECT transkey FROM orders WHERE order_state = 'open' AND characters_eve_idcharacters = '{$idcharacter}'") or die(mysqli_error($con));
 while ($orders = mysqli_fetch_array($getExistingOrders)) {
     array_push($existingOrders, $orders['transkey']);
 }
 foreach ($response_orders->orders as $row) {
     $i++;
     $orderID = $row->orderID;
     $charID = $row->charID;
     $stationID = $row->stationID;
     $volEntered = $row->volEntered;
     $volRemaining = $row->volRemaining;
     $minVolume = $row->minVolume;