MPOS / php-mpos

   * @param height int Block Height

   * @return data array Block information from DB

   **/

  public function getPPLNSRoundStatsForAccounts($iHeight=0) {

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

      SELECT

        a.username,

        a.is_anonymous,

        s.pplns_valid,

        s.pplns_invalid

        FROM " . $this->statistics->getTableName() . " AS s

        LEFT JOIN " . $this->block->getTableName() . " AS b ON s.block_id = b.id

        LEFT JOIN " . $this->user->getTableName() . " AS a ON a.id = s.account_id

        WHERE b.height = ? AND s.pplns_valid > 0

        GROUP BY username ASC

        ORDER BY pplns_valid DESC

        ");

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

      return $result->fetch_all(MYSQLI_ASSOC);

    return $this->sqlError();

  }

  /**

   * Get total valid pplns shares for block height

   **/

  public function getPPLNSRoundShares($iHeight=0) {

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

  /**

   * Get total valid pplns shares for block height

   **/

  public function getPPLNSRoundShares($iHeight=0) {

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

      SELECT

        SUM(s.pplns_valid) AS pplns_valid

        FROM " . $this->statistics->getTableName() . " AS s

        LEFT JOIN " . $this->block->getTableName() . " AS b ON s.block_id = b.id

        WHERE b.height = ?

        ");

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

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

    return $this->sqlError();

  }

  /**

   * Get all transactions for round block height for admin

   * @param height int Block Height

   * @return data array Block round transactions

   **/

  /**

   * Get USER last blocks from height for admin panel

   **/

  public function getUserReportBlocksFoundHeight($iHeight=0, $limit=10, $iUser) {

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

      SELECT

        b.height, b.shares

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

        LEFT JOIN " . $this->statistics->getTableName() . " AS s ON s.block_id = b.id

        LEFT JOIN " . $this->user->getTableName() . " AS a ON a.id = s.account_id 

      WHERE b.height <= ? AND a.id = ?

      ORDER BY height DESC LIMIT ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('iii', $iHeight, $iUser, $limit) && $stmt->execute() && $result = $stmt->get_result())

      return $result->fetch_all(MYSQLI_ASSOC);

    return $this->sqlError();

  }

  /**

   * Get shares for block height for user admin panel

   **/

  public function getRoundStatsForUser($iHeight=0, $iUser) {

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

  /**

   * Get shares for block height for user admin panel

   **/

  public function getRoundStatsForUser($iHeight=0, $iUser) {

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

      SELECT

        s.valid,

        s.invalid,

        s.pplns_valid,

        s.pplns_invalid

        FROM " . $this->statistics->getTableName() . " AS s

        LEFT JOIN " . $this->block->getTableName() . " AS b ON s.block_id = b.id

        LEFT JOIN " . $this->user->getTableName() . " AS a ON a.id = s.account_id

        WHERE b.height = ? AND a.id = ?");

    if ($this->checkStmt($stmt) && $stmt->bind_param('ii', $iHeight, $iUser) && $stmt->execute() && $result = $stmt->get_result())

      return $result->fetch_assoc();

    return $this->sqlError();

  }

  /**

   * Get credit transactions for round block height for admin panel

   **/

  public function getUserRoundTransHeight($iHeight=0, $iUser) {

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