MPOS / php-mpos

    if (!isset($this->config['archive']['purge'])) $this->config['archive']['purge'] = 5;

    $stmt = $this->mysqli->prepare("SELECT CEIL(COUNT(id) / 100 * ?) AS count FROM $this->tableArchive");

    if ($this->checkStmt($stmt) && $stmt->bind_param('i', $this->config['archive']['purge']) && $stmt->execute() && $result = $stmt->get_result()) {

      $limit = $result->fetch_object()->count;

    } else {

      return $this->sqlError();

    }

    $stmt->close();

    $stmt = $this->mysqli->prepare("

      DELETE FROM $this->tableArchive WHERE time < (

      LEFT JOIN " . $this->block->getTableName() . " AS b

      ON t.block_id = b.id

      WHERE archived = 0");

    if ($this->checkStmt($stmt) && $stmt->bind_param('ii', $this->config['confirmations'], $this->config['confirmations']) && $stmt->execute() && $stmt->bind_result($dBalance) && $stmt->fetch())

      return $dBalance;

    return $this->sqlError();

  }

  /**

      GROUP BY t.account_id

      HAVING confirmed > ca.ap_threshold AND confirmed > " . $this->config['txfee_auto'] . "

      LIMIT ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('si', $this->config['currency'], $limit) && $stmt->execute() && $result = $stmt->get_result())

      return $result->fetch_all(MYSQLI_ASSOC);

    return $this->sqlError();

  }

      GROUP BY t.account_id

      HAVING confirmed > " . $this->config['txfee_manual'] . "

      LIMIT ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('si', $this->config['currency'], $limit) && $stmt->execute() && $result = $stmt->get_result())

      return $result->fetch_all(MYSQLI_ASSOC);

    return $this->sqlError('E0050');

  }

}

      WHERE ca.ap_threshold > 0 AND ca.currency = ?

      AND ca.coin_address IS NOT NULL

      ");

    if ( $this->checkStmt($stmt) && $stmt->bind_param('s', $this->config['currency']) && $stmt->execute() && $result = $stmt->get_result()) {

      return $result->fetch_all(MYSQLI_ASSOC);

    }

    $this->debug->append("Unable to fetch users with AP set");

    return false;

  }