[T6.1] Run finalize script + approve distribution (settlement)

[realproject7]

Epic: #1229 · Spec: §5, §8 Phase 6 · Type: OPERATOR · Estimate: 1 day

Pre-settlement checks

• 7-day TWAP window of pl_daily_prices captured cleanly (no missing days)
• If TWAP looks manipulated (per R12), delay settlement up to 7d via operator judgment
• Bonding-curve depth check (per R17) — if insufficient liquidity for unlock, delay claim opening
• T2.7 sweep-enabled MerkleClaim contract code merged + tested on testnet

Scope

This is finalize + review only. NO on-chain execution. The actual contract deploy / unlock / fund / burn / announce all happens in #1263 (T6.2 settlement day).

1. Run scripts/airdrop-finalize.ts (T2.6) in DRY-RUN mode first
2. Review output:
   • Total eligible wallets (matches eligible_activation_count from /status)
   • Total weighted spend
   • Per-tier released_pool value based on 7-day TWAP FDV (per §4.3: Bronze 20K / Silver 60K / Gold 100K / Diamond 200K)
   • Per-wallet share table (CSV)
   • Merkle root
3. Distribution dispute audit: publish CSV of per-wallet weighted spends to a public location BEFORE running for-real
4. Approve: confirm dry-run output looks correct, no anomalies, no is_blacklisted review issues
5. Run finalize for-real → writes pl_airdrop_proofs table + outputs final Merkle root
6. Record Merkle root in this issue (for [T6.2] Settlement day (deploy contract + fund + announce) #1263 settlement-day deploy)
7. Confirm CLAIM_WINDOW_DAYS value (from T2.1 config, default 30) and reference it in this issue for [T6.2] Settlement day (deploy contract + fund + announce) #1263 — actual claimDeadline is computed at [T6.2] Settlement day (deploy contract + fund + announce) #1263 Step 1 deploy time based on intended claim-open timestamp, NOT from CAMPAIGN_END.

Branching by tier outcome — hand off to #1263

Normal flow (FDV ≥ Bronze threshold)

• Record decision: NORMAL in this issue
• → proceed to [T6.2] Settlement day (deploy contract + fund + announce) #1263 settlement-day NORMAL branch (deploy MerkleClaim + unlock + fund + burn rest + env + announce)
• → then [T6.5] At claimDeadline: sweep unclaimed to dead address #1266 T6.5 sweep after claimDeadline

Sub-Bronze flow (FDV < $100K)

• Record decision: SUB-BRONZE in this issue
• → proceed to [T6.2] Settlement day (deploy contract + fund + announce) #1263 settlement-day SUB-BRONZE branch (skip Merkle deploy, unlock + burn full 200K, announce sub-Bronze)
• → [T6.5] At claimDeadline: sweep unclaimed to dead address #1266 T6.5 marked skipped (no contract to sweep)

Zero-recipient flow (FDV ≥ Bronze but proof_count = 0) — RE1 r29

Even if the milestone tier is hit, if no wallet has positive weighted_spend (e.g., everyone activated but nobody bought storyline tokens), there are NO recipients to distribute to.

• Record decision: ZERO-RECIPIENT in this issue (note: tier was X, but zero eligible recipients)
• → proceed to [T6.2] Settlement day (deploy contract + fund + announce) #1263 settlement-day ZERO-RECIPIENT branch (skip Merkle deploy, unlock + burn full 200K, announce "milestone hit but no eligible recipients — full burn")
• → [T6.5] At claimDeadline: sweep unclaimed to dead address #1266 T6.5 marked skipped (no contract to sweep)

Detection during T6.1 dry-run: if finalize SQL returns 0 rows (because WHERE weighted_spend > 0 filters everything out), surface this clearly in dry-run output before for-real run. Don't write empty pl_airdrop_proofs.

Critical clarification: this ticket (T6.1) does NO on-chain execution under any branch. The 200K burn for sub-Bronze AND zero-recipient is executed in #1263, not here.

What T6.1 does NOT do

• ❌ Does NOT compute claimDeadline (deferred to [T6.2] Settlement day (deploy contract + fund + announce) #1263 deploy time)
• ❌ Does NOT execute any on-chain transactions (deferred to [T6.2] Settlement day (deploy contract + fund + announce) #1263)
• T6.1 only confirms CLAIM_WINDOW_DAYS value for [T6.2] Settlement day (deploy contract + fund + announce) #1263 to use
• T6.1 only records the tier decision (NORMAL / SUB-BRONZE) so [T6.2] Settlement day (deploy contract + fund + announce) #1263 knows which branch to run

Acceptance

• Dry-run completed and reviewed
• CSV published for public audit
• No is_blacklisted anomalies (per §10 q10 manual review if curation active)
• Decision recorded in this issue: NORMAL / SUB-BRONZE / ZERO-RECIPIENT branch (RE1 r29: third branch added for FDV ≥ Bronze but no eligible recipients)
• If NORMAL: for-real run executed; Merkle root recorded; CLAIM_WINDOW_DAYS value confirmed in this issue
• Proof row count check (RE1 r28): pl_airdrop_proofs populated with **proof_count rows = COUNT(wallets where activated AND not blacklisted AND weighted_spend > 0)** — NOT eligible_activation_count`, because activated wallets with zero buy_volume produce zero share and get no proof row. Cross-check:
  • proof_count ≤ eligible_activation_count (sanity upper bound)
  • proof_count = COUNT(*) from v_weighted_spend helper where weighted_spend > 0
  • Record both numbers + the delta (= activated-but-didn't-spend cohort) in this issue
• If SUB-BRONZE: dry-run output documents zero shares; [T6.2] Settlement day (deploy contract + fund + announce) #1263 Sub-Bronze branch flagged; [T6.5] At claimDeadline: sweep unclaimed to dead address #1266 marked skip
• If ZERO-RECIPIENT: dry-run output documents proof_count = 0 (with reason — all wallets had weighted_spend ≤ 0); [T6.2] Settlement day (deploy contract + fund + announce) #1263 Zero-Recipient branch flagged; [T6.5] At claimDeadline: sweep unclaimed to dead address #1266 marked skip
• [T6.2] Settlement day (deploy contract + fund + announce) #1263 explicitly tagged with branch decision in this issue's closing comment

Dependencies

End of 3-month campaign window; #1260 T5.2 launch-day (live with real campaign data — was previously #1261 T5.3 before round-9 merge); T2.6 (#1248 — finalize script merged); T2.7 (#1267 — sweep-enabled contract code merged + tested)

[realproject7]

Superseded by the v6 Base Ecosystem Sprint redesign (spec: docs/PLOTLINK-diamond-hand-airdrop-6.md). v6 settlement uses a simplified single-branch finalize (max × stage% × basic_gate × bonus). The v5 3-branch finalize script is obsolete.