MPOS / php-mpos

   * @param limit int Last limit blocks

   * @return array

   **/

  public function getBlocksFound($limit=10) {

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

    if ($data = $this->memcache->get(__FUNCTION__ . $limit)) return $data;

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

      SELECT

        b.*,

        a.username AS finder,

        a.is_anonymous AS is_anonymous,

        ROUND(difficulty * POW(2, 32 - " . $this->coin->getTargetBits() . "), " . $this->coin->getShareDifficultyPrecision() . ") AS estshares

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

      LEFT JOIN " . $this->user->getTableName() . " AS a

      ON b.account_id = a.id

      ORDER BY height DESC LIMIT ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param("i", $limit) && $stmt->execute() && $result = $stmt->get_result())

      return $this->memcache->setCache(__FUNCTION__ . $limit, $result->fetch_all(MYSQLI_ASSOC), 5);

    return $this->sqlError();

  }

  /**

   * Get our last $limit blocks found by height

   * @param none

   * @return data object Our share rate in shares per second

   **/

  public function getCurrentShareRate($interval=180) {

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

    if ($data = $this->memcache->getStatic(__FUNCTION__)) return $data;

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

      SELECT

      (

        (

          SELECT ROUND(SUM(difficulty) / ?, " . $this->coin->getShareDifficultyPrecision() . ") AS sharerate

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

          WHERE time > DATE_SUB(now(), INTERVAL ? SECOND)

          AND our_result = 'Y'

        ) + (

          SELECT ROUND(SUM(difficulty) / ?, " . $this->coin->getShareDifficultyPrecision() . ") AS sharerate

          FROM " . $this->share->getArchiveTableName() . "

          WHERE time > DATE_SUB(now(), INTERVAL ? SECOND)

          AND our_result = 'Y'

        )

      ) AS sharerate

      FROM DUAL");

    if ($this->checkStmt($stmt) && $stmt->bind_param('iiii', $interval, $interval, $interval, $interval) && $stmt->execute() && $result = $stmt->get_result() ) return $this->memcache->setStaticCache(__FUNCTION__, $result->fetch_object()->sharerate);

    return $this->sqlError();

  }

  /**

   * Get total shares for this round, since last block found