Example #1
0
    function getMinimumShareId($iCount, $current_upstream)
    {
        // We don't use baseline here to be more accurate
        $iCount = $iCount * pow(2, $this->config['difficulty'] - 16);
        $stmt = $this->mysqli->prepare("\n      SELECT MIN(b.id) AS id FROM\n      (\n        SELECT id, @total := @total + IF(difficulty=0, POW(2, (" . $this->config['difficulty'] . " - 16)), difficulty) AS total\n        FROM {$this->table}, (SELECT @total := 0) AS a\n        WHERE our_result = 'Y'\n        AND id <= ? AND @total < ?\n        ORDER BY id DESC\n      ) AS b\n      WHERE total <= ?");
        if ($this->checkStmt($stmt) && $stmt->bind_param('iii', $current_upstream, $iCount, $iCount) && $stmt->execute() && ($result = $stmt->get_result())) {
            return $result->fetch_object()->id;
        }
        return $this->sqlError();
    }
    /**
     * Fetch the lowest needed share ID from archive
     **/
    function getMinArchiveShareId($iCount)
    {
        // We don't use baseline here to be more accurate
        $iCount = $iCount * pow(2, $this->config['difficulty'] - 16);
        $stmt = $this->mysqli->prepare("\n      SELECT MIN(b.share_id) AS share_id FROM\n      (\n        SELECT share_id, @total := @total + IF(difficulty=0, POW(2, (" . $this->config['difficulty'] . " - 16)), difficulty) AS total\n        FROM {$this->tableArchive}, (SELECT @total := 0) AS a\n        WHERE our_result = 'Y'\n        AND @total < ?\n        ORDER BY share_id DESC\n      ) AS b\n      WHERE total <= ?\n      ");
        if ($this->checkStmt($stmt) && $stmt->bind_param('ii', $iCount, $iCount) && $stmt->execute() && ($result = $stmt->get_result())) {
            return $result->fetch_object()->share_id;
        }
        return $this->sqlError();
    }
}
$share = new Share();
$share->setDebug($debug);
$share->setMysql($mysqli);
$share->setConfig($config);
$share->setUser($user);
$share->setBlock($block);
$share->setErrorCodes($aErrorCodes);