MPOS / php-mpos

        ) AS shares

      FROM $this->table AS w

      WHERE account_id = ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('iiiii', $interval, $interval, $interval, $interval, $account_id) && $stmt->execute() && $result = $stmt->get_result()) {

      $aData = array();

      while ($row = $result->fetch_assoc()) {

        $row['hashrate'] = round($this->coin->calcHashrate($row['shares'], $interval), 2);

        if ($row['count_all'] > 0) {

          $row['difficulty'] = round($row['shares'] / $row['count_all'], $this->coin->getShareDifficultyPrecision());

        } else {

          $row['difficulty'] = 0.00;

        }

        $aData[] = $row;

      }

      return $aData;

    }

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

  }

        ) AS shares

      FROM $this->table AS w

      ORDER BY shares DESC LIMIT ?,?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('iiiiii', $interval, $interval, $interval, $interval, $start, $iLimit) && $stmt->execute() && $result = $stmt->get_result()) {

      $aData = array();

      while ($row = $result->fetch_assoc()) {

        $row['hashrate'] = round($this->coin->calcHashrate($row['shares'], $interval), 2);

        if ($row['count_all'] > 0) {

          $row['avg_difficulty'] = round($row['shares'] / $row['count_all'], 2);

        } else {

          $row['avg_difficulty'] = 0.00;

        }

        $aData[] = $row;

      }

      return $aData;

    }

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

  }