MPOS / php-mpos

   * @param userID int UserID

   * @return data string Coin Address

   **/

  public function getCoinAddress($userID, $currency=NULL) {

    if ($currency === NULL) $currency = $this->config['currency'];

    $this->debug->append("STA " . __METHOD__, 4);

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

      SELECT coin_address

      FROM " . $this->getTableName() . "

      WHERE account_id = ? AND currency = ?

      ");

    if ( $this->checkStmt($stmt) && $stmt->bind_param('is', $userID, $currency) && $stmt->execute() && $result = $stmt->get_result()) {

      if ($result->num_rows == 1) {

        return $result->fetch_object()->coin_address;

      }

    }

    $this->debug->append("Unable to fetch users coin address for " . $currency);

    return $this->sqlError();

  }

  /**

   * Fetch users Auto Payout Threshold for a currency

   * @param UserID int UserID

   * @return mixed Float value for threshold, false on error

   **/

  public function getAPThreshold($userID, $currency=NULL) {

   * @param UserID int UserID

   * @return mixed Float value for threshold, false on error

   **/

  public function getAPThreshold($userID, $currency=NULL) {

    if ($currency === NULL) $currency = $this->config['currency'];

    $this->debug->append("STA " . __METHOD__, 4);

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

      SELECT ap_threshold

      FROM " . $this->getTableName() . "

      WHERE account_id = ? AND currency = ?

      ");

    if ( $this->checkStmt($stmt) && $stmt->bind_param('is', $userID, $currency) && $stmt->execute() && $result = $stmt->get_result()) {

      if ($result->num_rows == 1) {

        return $result->fetch_object()->ap_threshold;

      }

    }

    $this->debug->append("Unable to fetch users auto payout threshold for " . $currency);

    return $this->sqlError();

  }

  /**

   * Check if a coin address is already set

   * @param address string Coin Address to check for

   * @return bool true or false

   **/