Czech Hunter Bonus Myvidster | Work

-- Users (existing)
TABLE users (
    id               BIGINT PRIMARY KEY,
    email            VARCHAR,
    country_code     CHAR(2),   -- e.g., 'CZ'
    language_pref    VARCHAR,
    wallet_balance   INT,       -- coins
    ...
);
-- New table: hunter_scores
TABLE hunter_scores (
    user_id          BIGINT PRIMARY KEY REFERENCES users(id),
    total_points     BIGINT NOT NULL DEFAULT 0,
    level            VARCHAR(20) NOT NULL DEFAULT 'Scout',
    last_updated     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
-- Event log
TABLE hunter_events (
    id               BIGINT PRIMARY KEY AUTO_INCREMENT,
    user_id          BIGINT NOT NULL REFERENCES users(id),
    video_id         BIGINT NOT NULL REFERENCES videos(id),
    action_type      ENUM('TAG','SUBTITLE','HIDDEN_GEM','TRANSLATE','VOTE','COLLECTION'),
    base_points      SMALLINT NOT NULL,
    multiplier       DECIMAL(3,2) NOT NULL,
    earned_points    SMALLINT NOT NULL,
    created_at       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_user_video_action (user_id, video_id, action_type, DATE(created_at))
);
-- Badges (existing) – new rows inserted when awarded
TABLE user_badges (
    user_id          BIGINT REFERENCES users(id),
    badge_code       VARCHAR(30),   -- e.g., 'CZ_TAGGER'
    awarded_at       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (user_id, badge_code)
);
-- Monthly leaderboard snapshot
TABLE hunter_leaderboard (
    month            DATE NOT NULL,          -- first day of month
    rank             SMALLINT NOT NULL,
    user_id          BIGINT NOT NULL,
    points           BIGINT NOT NULL,
    PRIMARY KEY (month, rank)
);

| Level | Required Cumulative Points | Bonus Multiplier | |-------|----------------------------|------------------| | Scout | 0‑199 | ×1.0 | | Tracker | 200‑599 | ×1.1 | | Stalker | 600‑1499 | ×1.2 | | Ranger | 1500‑3499 | ×1.3 | | Master Hunter | 3500+ | ×1.5 |

In the past month, the detection algorithm has missed about 5 % of new uploads, mostly when creators use non‑standard tags. The points system occasionally fails to credit a view if the page is refreshed quickly. czech hunter bonus myvidster work

Czech Hunter Bonus is a browser extension for MyVidster that adds a “hunter” mode, automatically detecting and highlighting new video uploads from channels you follow. It also offers a small points‑based reward system for watching and sharing content. -- Users (existing) TABLE users ( id BIGINT

Czech Hunter content is copyrighted. While streaming is a grey area, downloading or re-uploading "bonus" episodes could expose you to DMCA notices or, in extreme cases, legal action from the production company. | Level | Required Cumulative Points | Bonus