Hey there! 👋

Your sixth sense is not activated yet 🔮

👥 SQUADS

⭐ FAVOURITES

Star players in your squads to save them as favourites — quick access when building new squads

🎯 PLAY NOW

Remember, you only tip once — your picks automatically count towards all squads you're part of.

Select a competition above to start picking winners

📊 LEADERBOARD

Round 5 standings

M = Margin score — lower is better. Used as a tiebreaker when points are equal.

🔔 NOTIFICATIONS

Notifications are kept for 30 days, then automatically cleared

No notifications yet

⚙️ SETTINGS

Manage your preferences

👤 Profile

Your account details and how others see you in squads + leaderboards.

Display name

—

First name

—

Last name

—

Username

—

🔒 Change password

To change your password, sign out and use "Forgot password?" on the Sign In page. Ensure you have access to the above email.

🎨 App Theme

Choose your own theme or use the default which automatically switches between light and dark based on the time of day.

Use Default (Auto)

Cream & Forest during the day · Night Lime after dark

Choose Theme

🗄 Archive

Archived squads are hidden by default. Toggle on to show them as read-only in your Squads section (greyed out). Leaderboard and other views always exclude archived squads.

Show archived squads

Read-only · greyed out · Squads section only

👥 Squad names

Personalise how each squad appears to you. Owner renames affect everyone in the squad; member renames are personal to you.

❓ HELP

How Tiparuz works

ℹ️ About Tiparuz

Tiparuz is a social prediction game built for friendly competition. You don't need to be a sport expert — just back your instinct and see what happens.

The game is designed around bragging rights. Points, margins, leaderboards — it all comes down to one question: whose instinct is sharpest?

Tiparuz currently supports AFL and Soccer competitions. More competitions may be added in future seasons.

Each competition runs its own rounds and matches independently — you can tip across multiple competitions at the same time.

Version 0.1.0 · 2026-05-02

🎯 Play — How to Tip

You don't need to be in a squad to tip. Select a competition from the Dashboard or the Play Now tab, pick a round, and start tipping.

On the Dashboard your tips save automatically as you pick — no button needed. In the Play Now page, use 🔒 Lock In Tips to confirm all your picks for the round.

You only tip once per competition — your picks automatically count towards every squad you belong to for that competition.

Once match results are entered, each match card shows the Final Score along with whether your tip was correct, your points earned, and your margin score.

Tipping closes when a round starts. Results will appear in your dashboard and recent activity as they come in.

Use the round tabs on the Play Now page to browse past rounds and review your full prediction history.

👥 Squads

🎉 More Fun With Friends — Playing solo is great, but taking down your mates is even better. Create a squad or join one using the buttons at the top to compete head-to-head.

Every squad is tied to a specific competition when it's created — this cannot be changed. To compete in a different competition with the same group, use the ⋮ menu → 🔁 Duplicate on any squad you own — copies the same members into a new squad in another competition.

Once a squad is created, add members from the ⋮ menu → ➕ Invite members on your squad card.

A unique 6-letter code is generated for every squad. Share it so others can request to join — all code-based join requests must be approved by the squad owner.

Pending invites and join requests show as ⏳ +X pending on the squad card footer. Head to 🔔 Notifications to action them.

The squad owner can remove any player. Any player can remove themselves (leave) at any time.

An owner can delete a squad only when they are the sole confirmed member. If pending invites exist you'll be warned before deleting.

Remember — you only tip once per competition. Your picks automatically count towards all squads you're in for that competition.

Personalise how each squad appears to you in ⚙️ Settings → 👥 Squad names. Owners can rename the canonical name (everyone sees it). Members can set a personal display name (only you see it). If two of your squads end up sharing the same displayed name, a 👀 hint appears on those cards — hover or tap for the message.

Owners can cancel a sent invite — tap ✗ Cancel next to a pending invitee in the squad's pending block. The invite silently drops from the invitee's view; no notification fired.

Owners can 🔁 Duplicate a squad — copies the same members into a new squad in another competition. Members are auto-approved (no re-invite needed) and get a notification: "You have been added to NEW_SQUAD by [owner]". If you don't want to stay, leave anytime via the ⋮ menu → 🚪 Leave squad.

🗄 Archiving a squad — owners can archive a squad once it has scored history. Archive = read-only — the squad becomes hidden by default and can no longer accept new members, renames, or be deleted. Owners can still 🔁 Duplicate archived squads to start fresh in another competition with the same members.

Want to see your archived squads? Toggle Show archived squads ON in ⚙️ Settings → 🗄 Archive. Archived squads then appear greyed out in your Squads section. They never show on the Leaderboard or Dashboard regardless of the toggle.

⭐ Favourites

Favourites are your go-to players — squad owners can star any member by tapping ☆ on their row in the squad card. Tap again to unstar. No request or permission needed.

Favourites appear first in the invite picker when adding members to a new or existing squad — making it quick to rebuild squads each season.

The Favourites tab is only visible to squad owners. Players who don't own any squad won't see it.

Remove a favourite by clicking ✕ on their card in the Favourites page, or by tapping ★ again on their row inside any squad card.

🏅 Scoring

Each competition uses one of two scoring modes depending on the sport. Your competition's mode is shown on the match cards.

a. 🏉 AFL — Winner + Margin

Pick the team you think will win and enter how many points you think they'll win by.

Correct winner = 4 points. Wrong winner = 0 points.

Predict a draw = 5 points if the match ends in a draw. Enter 0 as your margin to predict a draw. AFL draws are extremely rare — extra reward for calling it!

If you don't submit a tip before the round starts, the home team is used as your default with a margin of 0.

Margin score — lower is better. If your team wins: |predicted margin − actual margin|. If your team loses: predicted margin + actual margin. Equal points are broken by lowest margin score.

b. ⚽ Soccer — Exact Score

Enter your predicted score for each team — the winner and any draw are worked out automatically from the scores you enter.

Correct winner or draw = 2 points. Wrong result = 0 points.

+1 bonus point if your exact scoreline matches the final result (e.g. you predicted 2–1 and it ended 2–1). Shown as a +1 bonus badge on your result card.

If you don't submit a tip before the round starts, a 0–0 score is used as your default. No bonus point is awarded even if the match ends 0–0.

Margin score — lower is better. Calculated as |predicted goal difference − actual goal difference|. Equal points are broken by lowest margin score.

🏠 Dashboard

The Dashboard is your home base every time you log in. It shows your current round stats, recent activity, and quick-tip match cards.

First time? Use the Choose Competition tiles — follow the bouncing 👇. Once you select one, tap Play Now to go straight to the current round. After your first tip the dashboard switches to showing live match cards.

You can tip directly from the dashboard match cards — picks save automatically as you go. No lock-in button needed on the dashboard.

If you're tipping across multiple competitions, use the tabs above the match cards to switch between them.

Your Stats (shown under your name) updates with your points and correct picks for the current round once results are in.

The Status panel on the right shows at a glance whether tipping is open, you've already locked in, or results are available for each competition.

Recent Activity shows your last 5 picks mixed with any squad notifications — a quick snapshot of what's happened.

📊 Leaderboard

The All tab shows you alongside all your squad mates, with a column for each active competition. Click any competition column header to sort by that competition's points.

Each squad tab shows only that squad's members, ranked by their tips for that squad's competition. The Form column shows your last 3 results — C correct, W wrong.

Margin shown under each score is the tiebreaker — lower is better. When two players have equal points, the one with the lower margin ranks higher.

You need to be in at least one squad to see other players on the leaderboard. Solo tippers only see themselves until they join or create a squad.

🔔 Notifications

The bell 🔔 in the top bar shows a red dot when you have unread notifications. Tap it to see a quick dropdown of pending items.

Notifications cover squad invitations (someone inviting you to join their squad), join requests (someone requesting to join your squad), and squad activity confirmations.

You can action squad invites and join requests directly from the notification dropdown — no need to navigate away.

Head to the Notifications page (🔔 in the sidebar) for the full list. Notifications are automatically cleared after 30 days.

⚙️ Settings

Open Settings from the sidebar to personalise your Tiparuz experience.

Choose your app theme from the colour swatches — pick any theme and it's saved to your profile so it follows you across devices.

Enable Auto theme to let Tiparuz switch automatically — Cream & Forest during the day, Night Lime after dark.

Your theme preference is stored on your account and restored every time you log in.

🛡️ ADMIN

Manage sports, competitions, matches and results

View

➕ Add Sport

Sport Name

Icon (emoji)

Scoring Mode

All Sports

Loading sports...

Filter by sport

All Teams

Loading teams...

🔄 Manage Rounds

Competition

Round #

Label

Batch #

Batch opens

🎯 Enter Results

Competition

Round

All Squads

💬 User Messages

📋 Admin Logs

From

🗺️ Overview

The Admin panel is only visible to users with is_admin = true in the profiles table. Set this in Supabase directly.

The data hierarchy is: Sports → Competitions → Rounds → Matches. Everything flows down this chain. Players tip on matches, matches belong to rounds, rounds belong to competitions, competitions belong to a sport.

Recommended workflow each round: ① Sports tab — one-time setup (add sport + scoring mode) ② Teams tab — one-time setup (add all teams for each sport + venues) ③ Matches tab → Rounds — create a round, set status to future ④ Matches tab → Matches — enter matches manually or via Bulk Import ⑤ Matches tab → Rounds — set round to current (opens tipping for players) ⑥ Results tab — after matches are played, enter scores and Apply All

Admin tabs: Sports (setup), Matches (rounds + fixtures), Results (scores + points), Squads (read-only overview), Messages (user messages), Enquiry (data queries + network), Logs (audit trail), Help (this page).

🏆 Sports Tab

Add Sport — create a sport with a name, emoji icon, and scoring mode. Two scoring modes available: Winner + Margin (AFL) — player picks the winning team and a margin in points Exact Score (Soccer) — player predicts the exact home and away score This is a one-time setup — you rarely need to add new sports.

Edit Sport — click any sport name to open the edit modal. Name, icon, and scoring mode can be changed. Scoring mode locks once the sport has active competitions with rounds — prevents mid-season scoring changes.

Add Competition — click + Competition on any sport row. Give it a name (e.g. AFL 2026), season year, timezone, and optionally a website URL. Competitions appear as inline chips on the sport row — click a chip to edit.

Deleting — delete a competition via its chip (✕), or delete a sport via the edit modal. Both cascade: deleting removes all child rounds, matches, and results permanently. There is no undo.

👕 Teams & Venues Tab

Teams are linked to a sport, not a competition. e.g. Manchester United is a Soccer team and appears in all Soccer competitions (EPL, FA Cup, etc). Add all teams for a sport once at the start of the season.

Team fields: Name (required), Short name (optional, e.g. COL), Sport (required), Competition (optional — only needed for name conflicts across comps of the same sport), Home venue (optional — auto-fills venue in Matches tab).

Warnings: A gold warning appears on blur if a similar team name already exists (fuzzy match). Short name warns if already used by another team. Neither blocks saving — they are advisory.

Duplicate names blocked — you cannot add two teams with the same name under the same sport (enforced by DB constraint).

Renaming a team — you'll be asked: Fix Everywhere (typo fix — updates all matches, predictions, results) or Future Only (real name change — only updates the teams table; existing matches keep the old name).

Deleting a team is blocked if any matches reference it. Edit the name instead, or remove the matches first.

Venues sub-tab — a global venue list (not linked to any sport). Each venue has a name and city. Unique constraint on name + city — "ANZ Stadium, Sydney" and "ANZ Stadium, Auckland" are both allowed.

Deleting a venue is blocked if matches reference it. To retire a venue, stop using it and create a new one for future matches.

📅 Matches Tab

The Matches tab has two sub-tabs: Rounds (create/manage round status) and Matches (enter fixtures). Rounds sub-tab is the default landing.

Rounds sub-tab — select a competition to see all rounds. Each round shows its number, label, status dropdown, match count, and action buttons. + Add Round — enter a round number, the label auto-fills (e.g. R1). You can edit the label to anything (Finals, GF, etc). Set Current — promotes a round to current and auto-cascades: previous rounds → locked, next round → next, remaining → future. Re-cascade — re-clicking Set Current on an already-current round re-runs the cascade to fix manual overrides. Status dropdown — manually override any round's status. Warns when setting to current without cascade.

Round Status — what each status means:

Status	Player sees?	Player tips?	Admin tips?	Add matches?	Bulk import?	Edit venue/time?
Future	No	No	No	Yes	Yes	Yes
Next	No	No	Yes	Yes	Yes	Yes
Current (no tips)	Yes	Yes	Yes	Yes	Yes	Yes
Current (has tips)	Yes	Yes	Yes	No	No	Venue/time only
Locked	Yes (read-only)	No	No	No	No	Venue/time only
Results applied	Yes (with scores)	No	No	No	No	Venue/time only

Auto-lock: When match times are set, the round locks automatically the moment the first kickoff time passes. Players instantly lose the ability to tip. If no match times are set, the round never auto-locks and must be locked manually. Auto-lock also triggers cascade — promoting the next round.

Matches sub-tab — manual entry: Select a competition and round. Click ✏️ Edit to open the form. Use + Add Match to add rows. Home team and away team are required. Match time is optional. Team dropdowns — populated from the Teams tab for that sport. Already-used teams fade across rows to prevent duplicates. Venue auto-fill — when a home team is selected, the venue auto-fills from the team's home venue (if set). You can always override it. Timezone — match times are entered in the competition's timezone (shown next to the form title) and stored as UTC internally.

✅ Apply All — saves the round and all matches to the database. Matches are deduplicated by home team + away team + round. If editing an existing round, removed rows are deleted from DB.

📥 Bulk Import — paste fixtures from any website or load a .csv file. Available on rounds with no tips and no results. Date format — dropdown defaults to AU (DD/MM/YYYY). Switch to US (MM/DD/YYYY) for American sources. Expected columns: round, home_team, away_team, venue, kickoff_time Separators: Tab (paste from Excel) and comma (.csv) are auto-detected. Header row is auto-skipped. Preview: ✅ exact match, 🟡 fuzzy match (click dropdown to confirm), 🔴 not found (add via Teams/Venues tab first), ⚠️ parse error. Duplicates: If a match already exists in the round, a Skip/Replace toggle appears. Skip = leave as-is, Replace = update venue and kickoff time only. Apply: If any 🟡, ⚠️ round warnings, or duplicates exist, a confirmation dialog lists all non-green items before writing. Nothing saves without your click.

Testing tip: Leave match time blank during testing. Auto-lock won't fire — you can tip freely, then manually lock via the Results tab before entering scores.

To reopen a locked round: Update the round status back to current via the Rounds sub-tab dropdown, or in Supabase: UPDATE rounds SET status = 'current' WHERE id = '<round_id>';

🎯 Results Tab

Select a competition and round. The score entry grid appears automatically. If the round is not yet locked, a ⚠️ warning appears with a 🔒 Lock Round Now button — click it to close tipping before entering results.

Recommended workflow: ① Matches with times → round auto-locks at first kickoff → enter scores → Apply All. ② Matches without times → players tip → click Lock Round Now → enter scores → Apply All.

Enter the final score for each match. Leave a row blank to skip — only rows with scores are saved.

🧪 Test — applies results and calculates points for the test user only. Verify before applying to everyone. Test user must have tipped first.

✅ Apply All + Calculate Points — saves results and calculates points for every user who tipped. Points are stored on predictions (points_earned, margin_score, bonus_earned).

Re-apply: Running Apply All again on the same round overwrites results and recalculates all points. Use this to correct mistakes.

After results: Players see final scores, ✓ Correct / ✗ Wrong badges, and points on their match cards. Dashboard stats and leaderboard update on next load.

Auto-advance: When all matches in a round have results, the system auto-advances round statuses — next round becomes current, the one after becomes next. This only fires when ALL matches have results, and does not re-fire on re-apply.

🏅 Scoring Reference

Winner + Margin scoring (AFL):

Outcome	Points	Margin score
Correct winner	4 pts	\|predicted margin - actual margin\|
Correct winner, null margin	4 pts	actual margin (penalty for not entering)
Correct draw prediction	4 pts	0
Wrong winner	0 pts	predicted margin + actual margin
Wrong winner, null margin	0 pts	2 × actual margin
No tip submitted	0 pts	No score calculated

Lower margin score = better. Used for tiebreaking on the leaderboard.

Exact Score scoring (Soccer):

Outcome	Points	Bonus	Margin score
Correct result (right side wins/draws)	2 pts	—	\|predicted diff - actual diff\|
Exact scoreline match	2 pts	+1 bonus	0
Wrong result	0 pts	—	\|predicted diff - actual diff\|
No tip submitted	0 pts	—	No score calculated

👥 Squads Tab

Shows a read-only overview of all squads across all users. Admin cannot create, edit, or delete squads — that is handled by squad owners.

Stats bar: total squads, total members, users in at least one squad, squad owners count.

Each squad row shows: squad name, competition badge (icon + comp name), owner, member count, 6-letter squad code, and creation date.

What players can do: Create squads (become owner), join via code (needs owner approval), invite friends, leave a squad, delete own squad. All managed from the player Squads section — no admin action needed.

💬 Messages Tab

Shows messages sent by users via Contact Admin in their username dropdown. Messages are up to 50 characters with an optional email address for reply.

Unread messages are highlighted with a NEW badge. A count badge appears on the Messages tab label.

✓ Mark read on individual messages, or ✓ Mark all read to clear everything at once.

To reply, click the email link — opens your default mail client with the address pre-filled.

🔍 Enquiry Tab

Four sub-tabs for querying data: Presets, Query Builder (coming soon), Table Browser, and Network.

Presets — quick data lookups:

Preset	What it shows	Filter
👤 Player Lookup	All squads, tips, results, and points for a user	Username (autocomplete)
📋 Round Overview	All rounds with match counts, tip counts, status	Competition
🎯 Tips for a Round	Every tip submitted for a specific round	Competition + Round
🏟️ Match Results	Final scores for all matches in a round	Competition + Round
👥 Squad Members	All members of a squad with status	Squad

Table Browser — browse any database table directly. Select a table from the dropdown, set a row limit (50/100/200), and view all rows. Click column headers to sort. Cells truncate with hover tooltips for full values.

Network — visualise player connections through squads. Three views: Player — select a player to see all their squads and squadmates with frequency counts. Squad Overlap — table of squad pairs sharing members, sorted by shared count. Most Connected — ranks all players by unique squadmate count. Orphan section at bottom (players in zero squads). Stats bar shows: total players, squads, connections, orphans. Use Refresh to re-fetch from DB.

📋 Logs Tab

Full audit trail of all admin and system actions. Every sport, competition, round, match, team, venue, and result change is logged automatically.

Filters: Actor — filter by admin (manual actions) or system (auto-lock, auto-cascade). Action type — filter by category: sport, competition, round, match, team, venue, or all. Time range — quick filters (last 10/60 min, 6h, today, yesterday) or All time.

Each log entry shows: actor (admin/system), action description, target type, and timestamp. Use Load More for pagination (50 rows per page). Refresh to re-fetch.

🗄️ Database Reference

Table	Key columns	Notes
sports	`id, name, slug, icon, input_mode, allow_draw`	Top-level. input_mode: winner-margin or exact-score
competitions	`id, sport_id, name, season, timezone, is_active`	FK to sports. Timezone used for match time display
rounds	`id, competition_id, round_number, label, status`	Status: future, next, current, locked
matches	`id, round_id, competition_id, home_team, away_team, match_time, venue, sort_order`	match_time stored as UTC. Text team/venue names
teams	`id, name, short_name, sport_id, competition_id, home_venue`	Linked to sport. Optional competition_id for name conflicts
venues	`id, name, city`	Global — no sport link. Unique on name + city
predictions	`id, user_id, match_uuid, competition_id, round_uuid, winner, margin, home_score, away_score, points_earned, margin_score, bonus_earned`	One row per user per match
results	`id, match_uuid, home_score, away_score, home_team, away_team, sport, season, round, is_test`	One row per match. Unique on match_uuid. is_test flags seeded test data
squads	`id, name, code, owner_id, competition_id`	6-letter code for joining. FK to competitions
squad_members	`squad_id, user_id`	Junction table. Composite PK on (squad_id, user_id)
profiles	`id, username, theme, is_admin`	Set is_admin = true in Supabase for admin access
messages	`id, user_id, username, message, email, read`	User-to-admin. Max 50 chars
notifications	`id, user_id, type, message, read`	Bell notifications (squad requests, etc)
favourites	`id, user_id, target_id`	Player favourites list
admin_logs	`id, actor, action, target_type, target_id, detail, metadata`	Audit trail. Auto-populated by admin_log()

⚠️ Common Issues

Problem	Cause	Fix
Round select empty in Results	No rounds created for that comp	Go to Matches → Rounds and add rounds first
Match error on Apply — no unique constraint	DB constraint missing	`ALTER TABLE matches ADD CONSTRAINT matches_round_home_away_unique UNIQUE (round_id, home_team, away_team);`
Results not saving	Missing constraint or RLS	`ALTER TABLE results ADD CONSTRAINT results_match_uuid_unique UNIQUE (match_uuid);` + add admin RLS policies
Points not calculating	User tipped after results applied	Re-run Apply All after all users have tipped
Contact Admin failing	RLS missing on messages table	Add insert policy for authenticated, select/update for admins
Squad shows wrong comp	competition_id is null	`UPDATE squads SET competition_id = '...' WHERE sport_legacy = '...';`
Bulk Import button disabled	Round has tips or results	Bulk import only works on rounds with no tips and no results
Bulk Import 🔴 on a team that exists	Team name doesn't match exactly	Use the dropdown to pick the correct team, or check spelling in Teams tab
Auto-lock not firing	Match times not set, or timezone mismatch	Check times are entered in the comp's timezone. Auto-lock fires on any page load after kickoff
Testing — keep tipping open	Auto-lock fires when kickoff passes	Leave match times blank during testing. Lock manually via Results tab when ready

Last run: —

Runs pure-function tests against live app code. No DB writes. Failures logged to console with full details. Tests can also be run from console: window.devTests.runAll()