import { useState, useEffect } from "react"; import { useSQLQuery, useDiveState } from "@motherduck/react-sql-query"; export const REQUIRED_DATABASES = [ { type: 'share', path: 'md:_share/pokemon_game/e22e727f-9a81-417c-9bbe-e14fc10af714', alias: 'pokemon_game' } ]; const N = (v) => (v != null ? Number(v) : 0); const TYPE_COLORS = { normal: "#A8A77A", fire: "#EE8130", water: "#6390F0", electric: "#F7D02C", grass: "#7AC74C", ice: "#96D9D6", fighting: "#C22E28", poison: "#A33EA1", ground: "#E2BF65", flying: "#A98FF3", psychic: "#F95587", bug: "#A6B91A", rock: "#B6A136", ghost: "#735797", dragon: "#6F35FC", dark: "#705746", steel: "#B7B7CE", fairy: "#D685AD" }; const ALL_TYPES = Object.keys(TYPE_COLORS); const PX = { fontFamily: "'Courier New', Courier, monospace", fontWeight: 700, letterSpacing: "1px", textTransform: "uppercase" }; function mulberry32(a) { return function () { a |= 0; a = (a + 0x6D2B79F5) | 0; let t = Math.imul(a ^ (a >>> 15), 1 | a); t = (t + Math.imul(t ^ (t >>> 7), 61 | t)) ^ t; return ((t ^ (t >>> 14)) >>> 0) / 4294967296; }; } function TypeChip({ t, big }) { if (!t) return null; return ( {t} ); } function Sprite({ b64, size }) { if (!b64) return

; return

; } export default function KantoGauntlet() { const [seed, setSeed] = useDiveState("seed", 0); const [picks, setPicks] = useDiveState("picks", []); const [legend, setLegend] = useDiveState("legend", false); const [gens, setGens] = useDiveState("gens", [1, 2, 3, 4, 5, 6]); const [swapSlot, setSwapSlot] = useDiveState("swap", -1); const [redealSlot, setRedealSlot] = useDiveState("redeal", -1); const [spinning, setSpinning] = useState(false); const [spinFace, setSpinFace] = useState("water"); const [showHelp, setShowHelp] = useState(true); useEffect(() => { if (!seed) setSeed(1 + Math.floor(Math.random() * 999999)); }, [seed]); const pokeQ = useSQLQuery(`SELECT pokedex_id, name, type_1, type_2, hp, defense, sp_attack, speed, bst, generation, is_legendary, is_mythical, is_final FROM "pokemon_game"."main"."pokemon" ORDER BY pokedex_id`); const battleQ = useSQLQuery(`SELECT battle_id, trainer_name, trainer_class, primary_type, secondary_type, difficulty_weight, avg_bst_opponent FROM "pokemon_game"."main"."trainer_battles" ORDER BY battle_id`); const chartQ = useSQLQuery(`SELECT attacking_type, defending_type, multiplier FROM "pokemon_game"."main"."type_chart"`); const catQ = useSQLQuery(`SELECT slot_number, type_option_a, type_option_b FROM "pokemon_game"."main"."type_categories" ORDER BY slot_number`); const all = Array.isArray(pokeQ.data) ? pokeQ.data : []; const battles = Array.isArray(battleQ.data) ? battleQ.data : []; const chart = Array.isArray(chartQ.data) ? chartQ.data : []; const cats = Array.isArray(catQ.data) ? catQ.data : []; const byId = {}; all.forEach((p) => { byId[N(p.pokedex_id)] = p; }); const isLegendary = (p) => !!(p && (p.is_legendary || p.is_mythical)); const round = picks.length; // 0..5 while drafting, 6 = done const done = round >= 6; const loaded = all.length > 0 && cats.length === 6 && battles.length > 0 && chart.length > 0 && seed > 0; // ---------- eligible pool for a type ---------- const poolFor = (ty) => all.filter((p) => p.is_final && (legend || !isLegendary(p)) && gens.indexOf(N(p.generation)) !== -1 && (p.type_1 === ty || p.type_2 === ty) && picks.indexOf(N(p.pokedex_id)) === -1 ); // ---------- spun type + dealt hand per slot ---------- const slotInfo = (i) => { if (!loaded) return { type: null, hand: [] }; const pair = [cats[i].type_option_a, cats[i].type_option_b]; let side = mulberry32((seed ^ (i + 1) * 2654435761) | 0)() < 0.5 ? 0 : 1; if (swapSlot === i) side = 1 - side; let ty = pair[side]; let flippedFrom = null; if (poolFor(ty).length === 0) { // spun type has ZERO options: flip to partner, loudly flippedFrom = ty; side = 1 - side; ty = pair[side]; } const rng = mulberry32((seed ^ ((i + 1) * 97) ^ (redealSlot === i ? 0xABCDEF : 0)) | 0); const shuffle = (arr) => { const c = arr.slice(); for (let k = c.length - 1; k > 0; k--) { const j = Math.floor(rng() * (k + 1)); const tmp = c[k]; c[k] = c[j]; c[j] = tmp; } return c; }; // deal up to 9 — spun type ONLY. A thin hand is honest: the player's // gen/legend filters mean few final forms of this type exist. const pool = poolFor(ty); const hand = shuffle(pool).slice(0, 9).sort((a, b) => N(a.pokedex_id) - N(b.pokedex_id)); return { type: ty, hand: hand, poolSize: pool.length, flippedFrom: flippedFrom }; }; const current = !done && loaded ? slotInfo(round) : { type: null, hand: [], poolSize: 0, flippedFrom: null }; // slot machine spin animation on each new round useEffect(() => { if (!loaded || done) return; setSpinning(true); let n = 0; const iv = setInterval(() => { n += 1; setSpinFace(ALL_TYPES[n % ALL_TYPES.length]); }, 70); const to = setTimeout(() => { clearInterval(iv); setSpinning(false); }, 900); return () => { clearInterval(iv); clearTimeout(to); }; }, [round, seed, swapSlot, redealSlot, loaded]); // ---------- sprites for visible mons ---------- const neededIds = Array.from(new Set(picks.concat(current.hand.map((p) => N(p.pokedex_id))))); const idList = neededIds.length ? neededIds.join(",") : "0"; const spriteQ = useSQLQuery( `SELECT pokedex_id, sprite_b64 FROM "pokemon_game"."main"."sprites" WHERE pokedex_id IN (${idList})`, { enabled: neededIds.length > 0 } ); const spr = {}; (Array.isArray(spriteQ.data) ? spriteQ.data : []).forEach((r) => { spr[N(r.pokedex_id)] = r.sprite_b64; }); // ---------- simulation (mirrors the calibrated engine) ---------- const teamRows = picks.map((id) => byId[id]).filter(Boolean); let results = [], record = "", power = 0, endText = ""; if (done && teamRows.length === 6 && loaded) { const mult = {}; chart.forEach((r) => { mult[r.attacking_type + ">" + r.defending_type] = N(r.multiplier); }); const bstAvg = teamRows.reduce((s, p) => s + N(p.bst), 0) / 6; const atk = Array.from(new Set(teamRows.flatMap((p) => [p.type_1, p.type_2]).filter(Boolean))); let rb = 1.0; if (!teamRows.some((p) => N(p.defense) > 80 || N(p.hp) > 90)) rb -= 0.1; if (!teamRows.some((p) => N(p.speed) > 90)) rb -= 0.1; if (!teamRows.some((p) => N(p.sp_attack) > 85)) rb -= 0.1; let lost = false, wins = 0, loser = null; results = battles.map((b) => { const def = [b.primary_type, b.secondary_type].filter(Boolean); const pairs = []; atk.forEach((a) => def.forEach((d) => { pairs.push(mult[a + ">" + d] != null ? mult[a + ">" + d] : 1); })); const covRaw = pairs.length ? pairs.reduce((s, x) => s + x, 0) / pairs.length : 1; const cov = Math.max(0.75, covRaw); const score = Math.pow(bstAvg / N(b.avg_bst_opponent), 1.3) * cov * rb / N(b.difficulty_weight); let wp = 1 / (1 + Math.exp(-2.5 * (score - 0.82))); wp = Math.max(0.05, Math.min(0.97, wp)); const th = b.trainer_class === "Gym Leader" ? 0.6 : b.trainer_class === "Elite Four" ? 0.5 : 0.48; const win = wp >= th; const row = { wp: wp, win: win, locked: lost }; if (!lost) { if (win) { wins += 1; } else { lost = true; loser = b.trainer_name; } } return row; }); record = lost ? wins + "-1" : "13-0"; endText = lost ? "YOUR RUN ENDS AT " + String(loser).toUpperCase() : "UNDEFEATED! LEGENDARY RUN!"; power = Math.min(100, Math.round((bstAvg / 600) * rb * 100)); } const newRun = () => { setPicks([]); setSwapSlot(-1); setRedealSlot(-1); setSeed(1 + Math.floor(Math.random() * 999999)); }; const toggleGen = (g) => { if (gens.indexOf(g) !== -1) { if (gens.length > 1) setGens(gens.filter((x) => x !== g)); } else setGens(gens.concat([g]).sort()); }; const btn = (active) => ({ ...PX, fontSize: 9, padding: "4px 8px", cursor: "pointer", background: active ? "#ffcb05" : "#0a0a12", color: active ? "#0a0a12" : "#8a93b8", border: "2px solid " + (active ? "#ffcb05" : "#3a4470") }); return (

{/* header + settings */}

THE KANTO GAUNTLET

THE SLOTS DEAL · YOU DRAFT 6 · SURVIVE 13 BATTLES

{[1, 2, 3, 4, 5, 6].map((g) => ( ))}

{/* how to play */} {showHelp && (

HOW TO PLAY

1. Your goal: build a team of 6 Pokémon strong enough to win 13 battles in a row.
2. The slot machine gives each team slot a random TYPE (like WATER or FIRE). You don't choose the type — that's the luck part.
3. You'll be shown a hand of Pokémon cards of that type. Click ONE to add it to your team. Tip: a higher BST number = a stronger Pokémon.
4. Dealt a bad type or a weak hand? Once per game you can press SWITCH TYPE (flip to the slot's other type) and once you can press NEW HAND (get different cards).
5. After 6 picks, the battle ladder on the right fills in: green W = win, red L = loss. Your run ends at your first loss — 13-0 is a perfect game.
6. Press NEW RUN to try again. The buttons up top change the rules: LEGENDS allows legendary Pokémon, G1-G6 picks which game generations appear.

)} {/* record banner */}

{done && record ? (

{record} {endText} POWER {power}

) : (

{!loaded ? "LOADING KANTO..." : "ROUND " + (round + 1) + " OF 6 — THE SLOTS HAVE SPOKEN"}

)}

{/* team bar */}

{[0, 1, 2, 3, 4, 5].map((i) => { const id = picks[i]; const p = id != null ? byId[id] : null; const isCurrent = i === round && !done; const slotTy = loaded ? (i < round ? null : isCurrent ? current.type : null) : null; return (

{p ? :

{isCurrent ? "!" : "?"}

}

{p ? p.name : isCurrent && slotTy ? slotTy : "SLOT " + (i + 1)}

); })}

{/* draft panel */}

{!loaded ? (

) : done ? (

{record === "13-0" ? "PERFECT RUN!" : "THE GAUNTLET CLAIMS ANOTHER"}

SHARE THIS LINK TO SHOW OFF YOUR SQUAD — OR TRY AGAIN

) : (

SLOT {round + 1} TYPE: {(spinning ? spinFace : current.type || "???")}

{!spinning && current.flippedFrom && (

NO {String(current.flippedFrom).toUpperCase()} FINAL FORMS IN YOUR GENS — SLOT FLIPPED TO {String(current.type).toUpperCase()}

)} {!spinning && current.hand.length > 0 && current.hand.length < 6 && (

THIN HAND — ONLY {current.poolSize} {String(current.type).toUpperCase()} FINAL FORM{current.poolSize === 1 ? "" : "S"} IN YOUR SELECTED GENS

)} {spinning ? (

SPINNING...

) : current.hand.length === 0 ? (

NO ELIGIBLE POKEMON — ENABLE MORE GENS OR LEGENDS

) : (

{current.hand.map((p) => { const id = N(p.pokedex_id); return (

setPicks(picks.concat([id]))} style={{ border: "2px solid #3a4470", background: "#0a0a12", textAlign: "center", cursor: "pointer", padding: 4, overflow: "hidden" }}>

{p.name}

BST {N(p.bst)} · G{N(p.generation)}

); })}

)}

{/* gauntlet ladder */}

THE GAUNTLET

{battleQ.isLoading ? (

) : ( battles.map((b, i) => { const r = done ? results[i] : null; const wp = r ? r.wp : null; const locked = r ? r.locked : false; const cls = b.trainer_class; return (

{b.trainer_name}

{cls === "Gym Leader" ? "GYM" : cls === "Elite Four" ? "ELITE 4" : "CHAMP"}

{wp != null &&

}

{wp != null ? Math.round(wp * 100) + "%" : "--"}

{!r ? "·" : locked ? "×" : r.win ? "W" : "L"}

); }) )}

FAN PROJECT — NOT AFFILIATED WITH NINTENDO, GAME FREAK, OR THE POKEMON COMPANY · DATA: POKEAPI · LIVE ON MOTHERDUCK

); }

The Kanto Gauntlet

Comments