Features:

*/}\n

✷ Hono + React + Tailwind

✷ React Router + React Query

✷ Built-in database (blob storage)

✷ Farcaster mini app manifest + webhook + embed metadata

✷ Farcaster notifications (storing tokens, sending recurring notifications, ...)

✷ Neynar API integration for Farcaster data

✷ Hosted on Val Town (instant deployments on save)

\n ✷ Source Code:{\" \"}\n \n val.town/x/moe/MiniAppStarter\n \n

\n );\n}\n\nfunction Database() {\n const queryFn = () => fetch(\"/api/counter/get\").then((r) => r.json());\n const { data, refetch } = useQuery({ queryKey: [\"counter\"], queryFn });\n return (\n

\n {/*

Database Example

*/}\n

Counter value: {data}

\n \n

\n );\n}\n\nfunction Neynar() {\n useEffect(() => {\n fetchNeynarGet(\"user/by_username?username=moe\").then(console.log).catch(console.error);\n }, []);\n\n return

Neynar page

;\n}",[],[166,248],"d090432e-4d1b-11f0-9411-76b3cceeab13","supabase.ts","d09043d8-4d1b-11f0-9411-76b3cceeab13","b6216968-0c12-11f0-9af5-569c3dd06744",653,["D",1750344230699],"import { createClient } from 'https://esm.sh/@supabase/supabase-js'\n\nexport const supabase = createClient(\n 'https://xxxxxx.supabase.co', // Replace with your Supabase URL\n 'eyJhxxxxx.eyxxxxx0.mcxxxxxg' // Replace with your Supabase Anon Key\n)\n\nexport async function sendAnalyticsEvent(payload: {\n event: string\n param?: string\n fid?: number\n platform?: string\n}) {\n try {\n // console.log('📈', payload)\n const { data, error } = await supabase.from('analytics_events').insert([payload])\n if (error) throw error\n return data\n } catch (error) {\n console.error('sendAnalyticsEvent error:', error)\n }\n}\n",[],[166,265,257],"util","e9afc324-5041-11f0-8183-f69ea79377d9","neynar.ts","d4046b9c-0cad-11f0-95d5-569c3dd06744",661,["D",1750690447126],13,"const baseUrl = \"/neynar-proxy?path=\";\n// const baseUrl = \"https://api.neynar.com/v2/farcaster/\";\n\nexport async function fetchNeynarGet(path: string) {\n const res = await fetch(baseUrl + encodeURIComponent(path), {\n method: \"GET\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-neynar-experimental\": \"true\",\n \"x-api-key\": \"NEYNAR_API_DOCS\",\n },\n });\n const json = await res.json();\n return json;\n}\n\nexport async function fetchNeynarGetPages(path: string, pages: number, dataKey: string) {\n let data: any = [];\n let cursor = \"\";\n let pagesLeft = pages;\n while (true) {\n const res = await fetchNeynarGet(`${path}&cursor=${cursor}`);\n data = [...data, ...res[dataKey]];\n cursor = res?.next?.cursor;\n pagesLeft--;\n if (!cursor || pagesLeft <= 0) {\n break;\n }\n }\n return {\n [dataKey]: data,\n };\n}\n\n//////////\n\nexport function fetchUser(username: string) {\n return fetchNeynarGet(`user/by_username?username=${username}`).then(r => r.user);\n}\nexport function fetchUsersById(fids: string) {\n return fetchNeynarGet(`user/bulk?fids=${fids}`).then(r => r.users);\n}\n\nexport function fetchUserFeed(fid: number) {\n return fetchNeynarGet(\n `feed?feed_type=filter&filter_type=fids&fids=${fid}&with_recasts=false&with_replies=false&limit=100&cursor=`,\n ).then(r => r.casts);\n}\n\nexport function fetchChannel(channelId: string) {\n return fetchNeynarGet(`channel?id=${channelId}`).then(r => r.channel);\n}\n\nexport function fetchChannelFeed(channelId: string) {\n return fetchNeynarGet(\n `feed/channels?channel_ids=${channelId}&with_recasts=false&limit=100`,\n ).then(r => r.casts);\n}\n\nexport function fetchChannelsFeed(channelIds: string[]) {\n return fetchNeynarGet(\n `feed/channels?channel_ids=${channelIds.join(\",\")}&with_recasts=false&limit=100`,\n ).then(r => r.casts);\n}",[],[166,265,267],"4c3d2fbc-0caf-11f0-92fc-569c3dd06744",411,["D",1743260748625],[217,218],[166,265],"77018f28-416f-11f0-8826-76b3cceeab13","Home.tsx","1f71edea-1558-11f0-8a7f-569c3dd06744","198e9a40-1558-11f0-9ba6-569c3dd06744",629,["D",1749060744128],5,"/** @jsxImportSource https://esm.sh/react@19 */\nimport fcsdk from \"https://esm.sh/@farcaster/frame-sdk\";\nimport { useQuery } from \"https://esm.sh/@tanstack/react-query@5\";\nimport { LoaderCircle, Mic, MicOff } from \"https://esm.sh/lucide-react@0.510.0\";\nimport { NavLink, Route, Routes, useNavigate, useParams } from \"https://esm.sh/react-router@7\";\nimport { useEffect, useRef, useState } from \"https://esm.sh/react@19\";\n\nimport { Button, Input, Section } from \"../components/ui.tsx\";\nimport { fetchUsersById } from \"../util/neynar.ts\";\n\nexport function Home() {\n return (\n

\n );\n}",[],[166,290,281],"screens","663baeb8-7206-11f0-80b7-0224a6c84d84","CustomHaptics.tsx","76f4d6a2-416f-11f0-84b2-76b3cceeab13",675,["D",1754403225895],10,"/** @jsxImportSource https://esm.sh/react@19 */\nimport fcsdk from 'https://esm.sh/@farcaster/frame-sdk'\nimport { useQuery } from 'https://esm.sh/@tanstack/react-query@5'\nimport { LoaderCircle, Mic, MicOff } from 'https://esm.sh/lucide-react@0.510.0'\nimport { NavLink, Route, Routes, useNavigate, useParams } from 'https://esm.sh/react-router@7'\nimport { useEffect, useRef, useState } from 'https://esm.sh/react@19'\n\nimport { Button, Input, Section, MonoButtonWithStatus } from '../components/ui.tsx'\n\nexport function CustomHaptics() {\n const [context, setContext] = useState()\n\n useEffect(() => {\n fcsdk.actions.ready()\n fcsdk.context.then(setContext)\n }, [])\n\n const [pattern, setPattern] = useState('')\n\n console.log(fcsdk, context)\n\n return (\n

\n {context && (\n <>\n

Standard Haptics

\n fcsdk.haptics?.notificationOccurred?.('success')}>\n haptics (success notification)\n \n fcsdk.haptics?.impactOccurred?.('heavy')}>\n haptics (heavy impact)\n \n fcsdk.haptics?.selectionChanged?.()}>\n haptics (selection)\n \n

Custom Haptics

\n hapticsPattern('... * * ...')}>\n haptics (pattern: ... * * ...)\n \n hapticsPattern('......')}>\n haptics (pattern: ......)\n \n\n setPattern(e.target.value)}\n placeholder=\"Custom Pattern (e.g. ... * * ...)\"\n type=\"text\"\n autocomplete=\"off\"\n value={pattern}\n />\n {pattern && (\n hapticsPattern(pattern)}>\n haptics (custom)\n \n )}\n

\n \n )}\n\n {!context && (\n

Open this web app in Farcaster to see the Mini App.

\n )}\n

\n )\n}\n\nasync function hapticsPattern(pattern: string) {\n function delay(ms?: number) {\n return new Promise((resolve) => setTimeout(resolve, ms || 150))\n }\n function hapticsChar(char: string) {\n if (char === 's') return fcsdk.haptics?.notificationOccurred?.('success').then(() => delay())\n if (char === '*') return fcsdk.haptics?.impactOccurred?.('heavy').then(() => delay())\n if (char === '.') return fcsdk.haptics?.selectionChanged?.().then(() => delay())\n if (char === ' ') return delay()\n }\n const chars = pattern.replace(/…/g, '...').split('') || []\n for (const char of chars) {\n await hapticsChar(char)\n }\n}\n// hapticsPattern('... * * ...')\n",[],[166,290,292],"198e9978-1558-11f0-9ba6-569c3dd06744",441,["D",1744212857845],[214,215],[166,290],"efcb0ff6-40c5-11f0-9cad-76b3cceeab13","ui.tsx","8fa8266a-078e-11f0-b2c6-569c3dd06744","b7324e06-5db3-467c-8006-e53bbc155394",621,["D",1748987932416],9,"/** @jsxImportSource https://esm.sh/react@19 */\nimport { ArrowLeft, Share } from \"https://esm.sh/lucide-react@0.510.0\";\nimport { useEffect, useState } from \"https://esm.sh/react@19\";\n\nexport function Section({ children, ...props }: any) {\n const sectionClass = `p-5 rounded-3xl bg-neutral-400/15 ${props.className || \"\"}`;\n return

{children}

;\n}\n\nexport const Input = ({ ...props }) => {\n let sizeStyles = \"text-md px-3 py-1\";\n if (props.sm || props.size == \"sm\") sizeStyles = \"text-sm px-2 py-1\";\n if (props.lg || props.size == \"lg\") sizeStyles = \"text-lg px-3 py-2\";\n const className = `\n\tborder-0 bg-inherit text-inherit rounded-xl shadow-sm \n\tring-1 ring-inset ring-neutral-400 dark:ring-neutral-600 \n\tfocus:ring-2 focus:ring-inset focus:ring-neutral-600 dark:focus:ring-neutral-300\n\tplaceholder:text-neutral-500 placeholder:opacity-50 disabled:opacity-50 disabled:bg-neutral-200/70 dark:disabled:bg-neutral-800/70\n\t${sizeStyles}\n\t${props.className || \"\"}\n\t`;\n\n return ;\n};\n\nexport const TextArea = ({ ...props }) => {\n const className = `\n\tborder-0 bg-inherit text-inherit rounded-xl shadow-sm px-3 py-2\n\tring-1 ring-inset ring-neutral-400 dark:ring-neutral-600 \n\tfocus:ring-2 focus:ring-inset focus:ring-neutral-600 dark:focus:ring-neutral-300\n\tplaceholder:text-neutral-500 placeholder:opacity-50 \n\t${props.className || \"\"}\n\t`;\n\n return

;\n};\n\nexport const Select = ({ ...props }) => {\n  const className = `\n\tborder-0 bg-inherit text-inherit rounded-xl shadow-sm px-3 py-2\n\tring-1 ring-inset ring-neutral-400 dark:ring-neutral-600 \n\tfocus:ring-2 focus:ring-inset focus:ring-neutral-600 dark:focus:ring-neutral-300\n\t${props.className || \"\"}\n\t`;\n\n  return <select {...props} className={className} />;\n};\n\nexport const Checkbox = ({ label, ...props }) => {\n  const className = `\n\th-4 w-4 rounded-xl bg-inherit text-neutral-700\n\tborder border-neutral-400 dark:border-neutral-600  focus:ring-neutral-700 dark:focus:ring-neutral-300 \n\txfocus:ring-0 xfocus:outline-red-500 focus:ring-offset-transparent focus:ring-offset-0\n\t${props.className || \"\"}\n\t`;\n\n  return (\n    <div className=\"relative flex gap-x-2\">\n      <div className=\"flex  items-center\">\n        <input type=\"checkbox\" {...props} className={className} />\n      </div>\n      <div className=\"text-sm flex  items-center\">\n        <label htmlFor={props.id} className={props?.checked ? \"font-medium\" : \"opacity-50\"}>\n          {label}\n        </label>\n      </div>\n    </div>\n  );\n};\n\nexport const Button = ({ ...props }) => {\n  let sizeStyles = \"text-md px-3 py-1\";\n  if (props.sm || props.size == \"sm\") sizeStyles = \"text-sm px-2 py-1\";\n  if (props.lg || props.size == \"lg\") sizeStyles = \"text-lg px-4 py-2\";\n  let variantStyles =\n    \"bg-neutral-900 border border-transparent dark:bg-neutral-100 text-neutral-100 dark:text-neutral-900 \";\n  if (props.variant === \"outline\") {\n    variantStyles =\n      \"bg-transparent border border-neutral-400 dark:border-neutral-600 text-neutral-900 dark:text-neutral-100\";\n  }\n\n  const className = `\n\tflex flex-row justify-center items-center   rounded-xl font-semibold \n\t${variantStyles}\n\tshadow-sm focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-neutral-600  \n\topacity-95 hover:opacity-100 disabled:opacity-50\n\t${sizeStyles}\n\t${props.className || \"\"}\n\t`;\n\n  if (props.href && !props.disabled) return <a {...props} className={className} />;\n  return <button {...props} className={className} />;\n};\n\n// export function Input(props: any) {\n//   const inputClass = \"dark:bg-white dark:text-black bg-black text-white rounded-md px-3 py-1 \";\n//   return <input class={inputClass} {...props} />;\n// }\n\n// export function Button(props: any) {\n//   const buttonClass = \"dark:bg-white dark:text-black bg-black text-white rounded-md px-3 py-1 \";\n//   return <button class={buttonClass} {...props} />;\n// }\n\nexport function MonoButton(props: any) {\n  return (\n    <Button {...props}>\n      <div class=\"font-mono text-sm font-normal\">{props.children}</div>\n    </Button>\n  );\n}\n\nexport function MonoButtonWithStatus(props: any) {\n  const [status, setStatus] = useState<any>();\n  const handleClick = async () => {\n    try {\n      setStatus(\"...\");\n      const result = await props.onClick?.();\n      setStatus(formatJSON(result));\n    } catch (err) {\n      console.error(err);\n      setStatus(\"Error: \" + err);\n    }\n  };\n\n  return (\n    <div>\n      <MonoButton {...props} onClick={handleClick} />\n      {status && <div class={\"mt-2 font-mono text-xs opacity-50 whitespace-pre-wrap break-all\"}>{status}</div>}\n    </div>\n  );\n}\n\nexport function formatJSON(json: any) {\n  return JSON.stringify(json, null, 2);\n}\n\nexport const shorten = (string, start, end) => {\n  return string.substring(0, start) + \"…\" + string.substring(string.length - end);\n};\n\nexport const formatAddress = (address) => {\n  if (!address) return \"\";\n  if (address.length < 20) return address;\n  return shorten(address, 6, 4);\n};\n\nexport function BackButton({}) {\n  return <ArrowLeft className=\"w-5 h-5 m-2 cursor-pointer opacity-50\" onClick={() => window.location.href = \"/\"} />;\n}\n\nexport function ShareButton({ onClick }) {\n  return <Share className=\"w-5 h-5 m-2 cursor-pointer opacity-50\" onClick={onClick} />;\n}",[],[166,315,306],"components","217055a0-daa6-11f0-a1e7-42dde27851f2","FarcasterMiniApp.tsx","c7f50f0e-059c-11f0-b718-569c3dd06744",["D",1765906750880],281,"/** @jsxImportSource https://esm.sh/react@19 */\nimport fcsdk from 'https://esm.sh/@farcaster/frame-sdk'\nimport { useEffect, useState } from 'https://esm.sh/react@19'\nimport { formatAddress, formatJSON, MonoButtonWithStatus, Section } from './ui.tsx'\n\nexport function FarcasterMiniApp() {\n  const [context, setContext] = useState<any>()\n  const [walletAddresses, setWalletAddresses] = useState<any>()\n\n  useEffect(() => {\n    fcsdk.actions.ready()\n    fcsdk.context.then(setContext)\n    fcsdk.wallet?.ethProvider?.request({ method: 'eth_requestAccounts' }).then(setWalletAddresses).catch(console.log)\n  }, [])\n\n  console.log(fcsdk, context, walletAddresses)\n\n  return (\n    <div className=\"flex flex-col gap-3 m-5 mb-20\">\n      {context && (\n        <>\n          {context?.user?.fid && (\n            <Section>\n              <div className=\"text-sm  opacity-50 mb-3 uppercase\">User</div>\n              <div className=\"flex flex-row gap-3 items-center\">\n                <img className=\"rounded-full w-10 h-10\" src={context?.user?.pfpUrl} />\n                <div className=\"font-semibold text-xl\">{context?.user?.username}</div>\n                <div className=\"text-sm opacity-50 pt-1\">{context?.user?.fid}</div>\n              </div>\n            </Section>\n          )}\n\n          {walletAddresses?.length > 0 && (\n            <Section>\n              <div className=\"text-sm  opacity-50 mb-3 uppercase\">Wallet</div>\n              <div className=\"font-mono font-medium text-xl mb-4\">{formatAddress(walletAddresses[0])}</div>\n\n              <div className=\"flex flex-col flex-wrap gap-3 items-start\">\n                <MonoButtonWithStatus\n                  onClick={() =>\n                    fcsdk.wallet?.ethProvider?.request({\n                      method: 'eth_chainId',\n                    })\n                  }\n                >\n                  chainId\n                </MonoButtonWithStatus>\n                <MonoButtonWithStatus\n                  onClick={() =>\n                    fcsdk.wallet?.ethProvider?.request({\n                      method: 'wallet_switchEthereumChain',\n                      params: [{ chainId: '0x2105' }],\n                    })\n                  }\n                >\n                  switchEthereumChain (base)\n                </MonoButtonWithStatus>\n                <MonoButtonWithStatus\n                  onClick={() =>\n                    fcsdk.wallet?.ethProvider?.request({\n                      method: 'eth_sendTransaction',\n                      params: [\n                        {\n                          from: walletAddresses[0],\n                          to: '0x5F77DBc7686327D3BF6eC1887E5a3AdA0aE60841',\n                          value: '0x' + (100000000000000).toString(16),\n                        },\n                      ],\n                    })\n                  }\n                >\n                  sendTransaction\n                </MonoButtonWithStatus>\n                <MonoButtonWithStatus\n                  onClick={() =>\n                    fcsdk.wallet?.ethProvider?.request({\n                      method: 'eth_signTypedData_v4',\n                      params: [\n                        walletAddresses[0],\n                        JSON.stringify({\n                          domain: {\n                            name: 'Frames v2 Demo',\n                            version: '1',\n                            chainId: 8453,\n                          },\n                          types: {\n                            EIP712Domain: [\n                              { name: 'name', type: 'string' },\n                              { name: 'version', type: 'string' },\n                              { name: 'chainId', type: 'uint256' },\n                            ],\n                            Message: [{ name: 'content', type: 'string' }],\n                          },\n                          message: {\n                            content: 'Hello from Frames v2!',\n                          },\n                          primaryType: 'Message',\n                        }),\n                      ],\n                    })\n                  }\n                >\n                  signTypedData_v4\n                </MonoButtonWithStatus>\n              </div>\n            </Section>\n          )}\n\n          <Section>\n            <div className=\"font-mono text-sm  opacity-50 mb-3\">sdk.actions</div>\n            <div className=\"flex flex-col flex-wrap gap-3 items-start\">\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.viewProfile?.({ fid: context.user.fid })}>\n                viewProfile\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus\n                onClick={() => fcsdk.actions.viewCast?.({ hash: '0xd81f802e98c1432bb698cb7d4cb6c2ff5057867d' })}\n              >\n                viewCast\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.composeCast?.({ text: 'Hello' })}>\n                composeCast\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus\n                onClick={() => fcsdk.actions.openUrl('https://www.youtube.com/watch?v=dQw4w9WgXcQ')}\n              >\n                openUrl\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus\n                onClick={() => fcsdk.actions.openMiniApp({ url: 'https://miniapp-starter.val.run/' })}\n              >\n                openMiniApp\n              </MonoButtonWithStatus>\n              {/* <MonoButtonWithStatus onClick={() => fcsdk.actions.openUrl('https://warpcast.com/~/compose')}>\n                openUrl (warpcast)\n              </MonoButtonWithStatus> */}\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.setPrimaryButton({ text: 'Primary Button' })}>\n                setPrimaryButton\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.addMiniApp()}>addMiniApp</MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.signIn({})}>signIn</MonoButtonWithStatus>\n\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.requestCameraAndMicrophoneAccess()}>\n                requestCameraAndMicrophoneAccess\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.actions.close()}>close</MonoButtonWithStatus>\n\n              <MonoButtonWithStatus\n                onClick={() =>\n                  fcsdk.actions.swapToken({\n                    sellToken: 'eip155:8453/erc20:0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913',\n                    buyToken: 'eip155:8453/native',\n                    sellAmount: '3000000',\n                  })\n                }\n              >\n                swapToken\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus\n                onClick={() =>\n                  fcsdk.actions.sendToken({\n                    token: 'eip155:8453/erc20:0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913',\n                    amount: '500000',\n                    recipientFid: 2073,\n                  })\n                }\n              >\n                sendToken\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus\n                onClick={() =>\n                  fcsdk.actions.viewToken({\n                    token: 'eip155:8453/erc20:0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913',\n                  })\n                }\n              >\n                viewToken\n              </MonoButtonWithStatus>\n            </div>\n          </Section>\n\n          <Section>\n            <div className=\"font-mono text-sm  opacity-50 mb-3\">other</div>\n            <div className=\"flex flex-col flex-wrap gap-3 items-start\">\n              <MonoButtonWithStatus onClick={() => fcsdk.quickAuth.getToken()}>quickAuth.getToken</MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.getCapabilities()}>getCapabilities</MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.getChains()}>getChains</MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.isInMiniApp()}>isInMiniApp</MonoButtonWithStatus>\n            </div>\n          </Section>\n\n          <Section>\n            <div className=\"font-mono text-sm  opacity-50 mb-3\">sdk.haptics</div>\n            <div className=\"flex flex-col flex-wrap gap-3 items-start\">\n              <MonoButtonWithStatus onClick={() => fcsdk.haptics?.notificationOccurred?.('success')}>\n                haptics (success notification)\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.haptics?.impactOccurred?.('heavy')}>\n                haptics (heavy impact)\n              </MonoButtonWithStatus>\n              <MonoButtonWithStatus onClick={() => fcsdk.haptics?.selectionChanged?.()}>\n                haptics (selection)\n              </MonoButtonWithStatus>\n            </div>\n          </Section>\n\n          <ExpandableSection title=\"sdk.context\" defaultExpanded>\n            {formatJSON(context)}\n          </ExpandableSection>\n        </>\n      )}\n\n      {!context && (\n        <Section>\n          <div className=\"text-md  opacity-50 \">\n            Farcaster is an open, programmable social network designed for developers to build mini apps with integrated\n            user authentication and financial features. Mini apps on Farcaster can be shared directly within the social\n            feed and installed in users' primary Farcaster clients, enabling seamless access and real-time notifications\n            from the mini apps themselves.\n            <br />\n            <br />\n            Open this web app in{' '}\n            <a href=\"https://farcaster.xyz\" target=\"_blank\" className=\"underline\">\n              Farcaster\n            </a>{' '}\n            to see the Mini App.\n          </div>\n        </Section>\n      )}\n    </div>\n  )\n}\n\nfunction ExpandableSection({\n  title,\n  children,\n  defaultExpanded = false,\n}: {\n  title: string\n  children: React.ReactNode\n  defaultExpanded?: boolean\n}) {\n  const [expanded, setExpanded] = useState(defaultExpanded)\n\n  return (\n    <Section>\n      <div className=\"flex flex-row gap-3 items-center justify-between\">\n        <div className=\"font-mono text-sm  opacity-50\">{title}</div>\n        <div className=\"text-sm cursor-pointer opacity-50 p-1\" onClick={() => setExpanded(!expanded)}>\n          {expanded ? '▲' : '▼'}\n        </div>\n      </div>\n\n      {expanded && <div className=\"font-mono text-xs opacity-50 whitespace-pre-wrap break-all mt-1\">{children}</div>}\n    </Section>\n  )\n}\n",[],[166,315,317],"8b017204-4219-11f0-833f-76b3cceeab13","Example.tsx","324edbf6-059c-11f0-8fd2-569c3dd06744",638,["D",1749133792214],31,"/** @jsxImportSource https://esm.sh/react@19 */\nimport fcsdk from \"https://esm.sh/@farcaster/frame-sdk\";\nimport { useEffect, useState } from \"https://esm.sh/react@19\";\n\nimport { ShareButton } from \"./ui.tsx\";\n\nexport function Example() {\n  const [context, setContext] = useState<any>();\n  useEffect(() => {\n    fcsdk.actions.ready();\n    fcsdk.context.then(setContext);\n    fcsdk.back?.enableWebNavigation?.();\n  }, []);\n\n  const onShare = () => {\n    if (!context) return;\n    const text = `Check out the mini app demo project by @moe!\\n`;\n    fcsdk?.actions?.composeCast?.({ text, embeds: [window.location.href] });\n  };\n\n  return (\n    <div class=\"m-5 mb-8\">\n      <div className=\"flex justify-between items-center\">\n        <h1 class=\"text-3xl font-semibold mb-1\">Mini App Demo</h1>\n        {context && <ShareButton onClick={onShare} />}\n      </div>\n      <div class=\"text-sm opacity-50\">Farcaster Mini App Demo Project on Val Town</div>\n    </div>\n  );\n}",[],[166,315,325],"6640cc2c-7206-11f0-9240-0224a6c84d84","Analytics.tsx","d0c145f0-4d1b-11f0-8589-76b3cceeab13",676,["D",1754403225896],"/** @jsxImportSource https://esm.sh/react@19 */\nimport fcsdk from 'https://esm.sh/@farcaster/frame-sdk'\nimport { useLocation } from 'https://esm.sh/react-router@7'\nimport { useEffect, useState } from 'https://esm.sh/react@19'\n\nimport { sendAnalyticsEvent } from '../util/supabase.ts'\n\nexport const Analytics = ({}) => {\n  const [context, setContext] = useState<any>()\n  useEffect(() => {\n    fcsdk.context.then(setContext)\n  }, [])\n\n  const user = context?.user\n\n  const analyticsEvent = (event: string, param?: string) => {\n    return sendAnalyticsEvent({ event, param, fid: user?.fid, platform: context ? 'miniapp' : 'web' })\n  }\n\n  useEffect(() => {\n    if (!user?.fid) return\n    // analyticsEvent('app_open', undefined)\n    if (context) analyticsEvent('miniapp_open', JSON.stringify(fcMiniAppContextData(context)))\n  }, [user?.fid])\n\n  const location = useLocation()\n  const path = location.pathname\n  let cleanedPath = path\n  if (cleanedPath && cleanedPath?.length > 1 && cleanedPath?.endsWith('/')) cleanedPath = cleanedPath.slice(0, -1)\n\n  useEffect(() => {\n    if (!user?.fid) return\n    analyticsEvent('screen_view', cleanedPath)\n  }, [cleanedPath, user?.fid])\n\n  return null\n}\n\nconst fcMiniAppContextData = (context: any) => {\n  const location: any = {\n    // ...context?.location,\n    clientFid: context?.client?.clientFid,\n    locationType: context?.location?.type,\n  }\n  if (context?.location?.type == 'cast_embed') location.locationId = context?.location.cast?.hash\n  if (context?.location?.type == 'notification') location.locationId = context?.location?.notification?.title\n  return location\n}\n",[],[166,315,334],"324ee222-059c-11f0-8fd2-569c3dd06744",["D",1742482886547],[209,210,211,212],[166,315],["D",1742482886338],[208,213,216,219,220],[166],"d0f34852-4d1b-11f0-9255-76b3cceeab13","d0f34924-4d1b-11f0-9255-76b3cceeab13",658,["D",1750344230702],"import { Client } from 'https://deno.land/x/postgres@v0.17.0/mod.ts'\n\nconst client = new Client(Deno.env.get('SUPABASE_POSTGRES'))\n\nexport async function dbQuery(query: string, args: any[] = []) {\n  await client.connect()\n  const result = await client.queryObject(query, args)\n  await client.end()\n  return result\n}\n",[],[173,257],"dc055d78-6f3c-11f0-aeb9-0224a6c84d84","e9a1d82c-5041-11f0-a3e8-f69ea79377d9",671,["D",1754096762841],"const NEYNAR_API_KEY = Deno.env.get('NEYNAR_API_KEY') || 'NEYNAR_API_DOCS'\nconst headers = {\n  'Content-Type': 'application/json',\n  'x-neynar-experimental': 'true',\n  'x-api-key': NEYNAR_API_KEY,\n}\n\nexport const fetchNeynarGet = async (path: string) => {\n  return await fetch('https://api.neynar.com/v2/farcaster/' + path, {\n    method: 'GET',\n    headers: headers,\n  }).then((r) => r.json())\n}\n\nexport const fetchNeynarPost = async (path: string, body: any) => {\n  return await fetch('https://api.neynar.com/v2/farcaster/' + path, {\n    method: 'POST',\n    headers: headers,\n    body: JSON.stringify(body),\n  }).then((r) => r.json())\n}\n\n//////////\n\nexport function fetchUsersById(fids: string) {\n  return fetchNeynarGet(`user/bulk?fids=${fids}`).then((r) => r.users)\n}\n",[],[173,267],"e9a91b78-5041-11f0-9641-f69ea79377d9",660,["D",1750690447127],91,"http","/** @jsxImportSource npm:hono/jsx */\nimport { serveFile } from \"https://esm.town/v/std/utils@64-main/index.ts\";\nimport { Hono } from \"npm:hono\";\n\nimport * as db from \"./db.ts\";\nimport { embedMetadata, handleFarcasterEndpoints, name } from \"./farcaster.ts\";\nimport { handleImageEndpoints } from \"./image.tsx\";\n// import { handleAnalyticsEndpoints } from './analytics.tsx';\nimport { fetchNeynarGet } from './neynar.ts'\n\nconst app = new Hono();\n\nhandleImageEndpoints(app);\nhandleFarcasterEndpoints(app);\n// handleAnalyticsEndpoints(app);\n\napp.get(\"/testing\", c =>\n  c.json({\n    hello: \"world\",\n    baseUrl: c.req.url.replace(c.req.path, \"\"),\n    \"import.meta.url\": import.meta.url,\n  }));\n\napp.get(\"/api/counter/get\", async c => c.json(await db.get(\"counter\")));\napp.get(\"/api/counter/increment\", async c => c.json(await db.set(\"counter\", (await db.get(\"counter\") || 0) + 1)));\n\napp.get('/neynar-proxy', async (c) => {\n  const url = new URL(c.req.url)\n  const path = url.searchParams.get('path')\n  const response = await fetchNeynarGet(path)\n  return c.json(response)\n})\n\napp.get(\"/frontend/**/*\", c => serveFile(c.req.path, import.meta.url));\n\napp.get(\"/\", async c => {\n  const url = new URL(c.req.url);\n  const path = c.req.url?.replace(url.origin, \"\");\n  return c.html(generateHtml(url.origin, path));\n});\napp.get(\"*\", async c => {\n  const url = new URL(c.req.url);\n  const path = c.req.url?.replace(url.origin, \"\");\n  return c.html(generateHtml(url.origin, path));\n});\n\nfunction generateHtml(baseUrl: string, path: string = \"/\"): any {\n  return (\n    <html>\n      <head>\n        <title>{name}</title>\n        <script src=\"https://cdn.tailwindcss.com\"></script>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n        <meta name=\"fc:frame\" content={JSON.stringify(embedMetadata(baseUrl, path))} />\n        <link rel=\"icon\" href={baseUrl + \"/icon\"} />\n        <meta property=\"og:image\" content={baseUrl + \"/image\"} />\n      </head>\n      <body class=\"bg-white text-black dark:bg-black dark:text-white\">\n        <main>\n          <div id=\"root\"></div>\n        </main>\n        {/* <script src=\"https://esm.town/v/std/catch\"></script> */}\n        <script src=\"/frontend/index.tsx\" type=\"module\"></script>\n      </body>\n    </html>\n  );\n}\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n  throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","miniapp-starter",[],[173,239],"8b0ed3ea-4219-11f0-89fb-76b3cceeab13","image.tsx","915c1b8a-1556-11f0-8871-569c3dd06744",640,["D",1749133792221],29,"/** @jsxImportSource https://esm.sh/react */\nimport { render } from 'https://deno.land/x/resvg_wasm/mod.ts'\nimport { Hono } from 'npm:hono'\nimport { SquareDashed } from 'npm:lucide-static'\nimport satori from 'npm:satori'\n\nexport function handleImageEndpoints(app: Hono) {\n  const headers = {\n    'Content-Type': 'image/png',\n    'cache-control': 'public, max-age=86400',\n  }\n  app.get('/image', async (c) => {\n    return c.body(await homeImage(), 200, headers)\n  })\n  app.get('/icon', async (c) => {\n    const rounded = !!c.req.query('rounded')\n    return c.body(await iconImage(rounded), 200, headers)\n  })\n}\n\nexport async function homeImage() {\n  return await ogImage(\n    <div tw=\"w-full h-full flex justify-start items-end text-[100px] bg-black text-white p-[50px]\">\n      <div tw=\"flex flex-col items-start\">\n        <img tw=\"w-[100px] h-[100px]\" src={base64Icon(SquareDashed)} />\n        <div tw=\"h-[270px]\"></div>\n        <div tw=\"flex text-[100px] tracking-[-5px]\">Mini App Demo</div>\n        <div tw=\"flex text-[30px] opacity-50 tracking-[-1px]\">Hono + React + Tailwind Demo Project on Val Town</div>\n      </div>\n    </div>\n  )\n}\n\nexport async function iconImage(rounded = false) {\n  const roundedClass = rounded ? 'rounded-[96px]' : ''\n  return await ogImage(\n    <div\n      tw={`w-full h-full flex justify-center items-center text-[100px] bg-[#7c65c1] text-white p-[50px] ${roundedClass}`}\n    >\n      <img tw=\"w-[350px] h-[350px]\" src={base64Icon(SquareDashed)} />\n    </div>,\n    {\n      width: 512,\n      height: 512,\n    }\n  )\n}\n\n//////////\n\nexport async function ogImage(body, options = {}) {\n  const svg = await satori(body, {\n    width: 945,\n    height: 630,\n    ...options,\n    fonts: await loadFonts(),\n    loadAdditionalAsset: async (code, segment) => {\n      console.log('loadAdditionalAsset', code, segment)\n      if (code === 'emoji') {\n        const unicode = segment.codePointAt(0).toString(16).toUpperCase()\n        return `data:image/svg+xml;base64,` + btoa(await loadEmoji(unicode))\n      }\n      return ''\n    },\n  })\n  return await render(svg)\n}\n\nconst loadFonts = async () => {\n  const fontsConfig = [\n    { name: 'Inter', weight: 400, fontFile: 'Inter-Regular.otf' },\n    // { name: \"Inter\", weight: 500, fontFile: \"Inter-Medium.otf\" },\n    { name: 'Inter', weight: 600, fontFile: 'Inter-SemiBold.otf' },\n    // { name: \"Inter\", weight: 700, fontFile: \"Inter-Bold.otf\" },\n  ]\n  const fontPromises = fontsConfig.map(async (font) => {\n    const fontUrl = 'https://cdn.jsdelivr.net/npm/@tamagui/font-inter@1.108.3/otf/' + font.fontFile\n    const fontArrayBuf = await fetch(fontUrl).then((res) => res.arrayBuffer())\n    return { name: font.name, data: fontArrayBuf, weight: font.weight }\n  })\n  const fonts: any = await Promise.all(fontPromises)\n\n  return fonts\n}\n\nconst loadEmoji = (code) => {\n  // const api = `https://cdnjs.cloudflare.com/ajax/libs/twemoji/14.0.2/svg/${code.toLowerCase()}.svg`\n  const api = `https://cdn.jsdelivr.net/gh/shuding/fluentui-emoji-unicode/assets/${code.toLowerCase()}_color.svg`\n  return fetch(api).then((r) => r.text())\n}\n\nconst base64Icon = (svg: any) => {\n  if (!svg) return undefined\n  svg = svg.replace('stroke=\"currentColor\"', 'stroke=\"white\"')\n  const base64 = Buffer.from(svg).toString('base64')\n  // console.log('getIconDataUrl', name, svg, base64)\n  return `data:image/svg+xml;base64,${base64}`\n}\n",[],[173,372],"90169eca-aaa8-11f0-b9e2-0224a6c84d84","farcaster.ts","a8e79c30-0727-11f0-994d-569c3dd06744",686,["D",1760630139699],60,"import { Hono } from 'npm:hono'\n\nimport { saveUserNotificationsDetails, sendNotificationToUser } from './farcaster-notifications.ts'\n\nexport const name = 'Mini App Demo'\n// export const iconUrl = \"https://imgur.com/TrJLlwp.png\";\n// export const ogImageUrl = \"https://imgur.com/xKVOVUE.png\";\n\nexport function embedMetadata(baseUrl: string, path: string = '/') {\n  return {\n    version: 'next',\n    imageUrl: baseUrl + '/image',\n    button: {\n      title: name,\n      action: {\n        type: 'launch_frame',\n        name: name,\n        url: baseUrl + path,\n        splashImageUrl: baseUrl + '/icon',\n        splashBackgroundColor: '#111111',\n      },\n    },\n  }\n}\n\nexport function handleFarcasterEndpoints(app: Hono) {\n  app.get('/.well-known/farcaster.json', (c) => {\n    const baseUrl = c.req.url.replace(c.req.path, '')\n\n    let accountAssociation = {}\n    if (baseUrl == 'https://moe--3238fa84059c11f0ac33569c3dd06744.web.val.run') {\n      accountAssociation = {\n        header:\n          'eyJmaWQiOjIwNzMsInR5cGUiOiJjdXN0b2R5Iiwia2V5IjoiMHg0OERCN2U3MWQxMTUyNjU5MTY5NjE2NzNCOTY4NjcwQTU0N2IwZkJFIn0',\n        payload: 'eyJkb21haW4iOiJtb2UtLTMyMzhmYTg0MDU5YzExZjBhYzMzNTY5YzNkZDA2NzQ0LndlYi52YWwucnVuIn0',\n        signature:\n          'MHhjNjc2NTRlMzIzOTA3ZTk4ZDk2OGNiOTNhYmRjMDI0Y2Y3M2MxM2UxNjZmNGY3NjRjZjk4ODJlZTBhZTg4ZjAwNDNkNjRmNjg1YTRmN2MxMjI0YmUyMTZlNjViNTFmYmQ4NDJiYmQ1YzYwMjJkMDZhOGI5MGY3NTQ3NTNmZTExMjFi',\n      }\n    }\n    if (baseUrl == 'https://miniapp-starter.val.run') {\n      accountAssociation = {\n        header:\n          'eyJmaWQiOjIwNzMsInR5cGUiOiJjdXN0b2R5Iiwia2V5IjoiMHg0OERCN2U3MWQxMTUyNjU5MTY5NjE2NzNCOTY4NjcwQTU0N2IwZkJFIn0',\n        payload: 'eyJkb21haW4iOiJtaW5pYXBwLXN0YXJ0ZXIudmFsLnJ1biJ9',\n        signature:\n          'MHg0MjIwZGZhMmEzMmZmMDkzZTBjNWIyMjljNWZjZDc0OGMwN2UyNGNiNjMxNjcwNjIxZTUzMDYxMmVlMWIxYWM1MjNmNzllNGU4OTQzZGYxYTBiNWQzMDQ5NDFlZTliZGFhMzhjNDhmOTdhNWM3MjU5NWFjYzljMTkxM2Y1YmY3YjFj',\n      }\n    }\n\n    const manifest = {\n      accountAssociation,\n      frame: {\n        name: name,\n        version: '1',\n        iconUrl: baseUrl + '/icon',\n        homeUrl: baseUrl,\n        splashImageUrl: baseUrl + '/icon?rounded=1',\n        splashBackgroundColor: '#111111',\n        primaryCategory: 'developer-tools',\n        webhookUrl: baseUrl + '/webhook',\n        castShareUrl: baseUrl,\n      },\n    }\n\n    return c.json(manifest)\n  })\n\n  app.post('/webhook', async (c) => {\n    const baseUrl = c.req.url.replace(c.req.path, '')\n    const body = await c.req.json()\n    const header = decodeBase64Json(body.header)\n    const payload = decodeBase64Json(body.payload)\n\n    // TODO: verify webhook signature\n\n    const fid = header?.fid\n    const event = payload?.event\n\n    console.log('[miniapp-webhook]', header, payload)\n\n    if ((event === 'frame_added' || event === 'notifications_enabled') && payload?.notificationDetails) {\n      // await saveUserNotificationsDetails(fid, payload?.notificationDetails);\n      // const res = await sendWelcomeNotification(fid, baseUrl);\n      // console.log(\"[miniapp-webhook]\", res);\n      saveUserNotificationsDetails(fid, payload?.notificationDetails)\n        .then(() => sendWelcomeNotification(fid, baseUrl))\n        .then((res) => {\n          console.log('[miniapp-webhook]', res)\n        })\n        .catch((err) => {\n          console.error('[miniapp-webhook]', err)\n        })\n    }\n\n    return c.json({})\n  })\n\n  app.get('/test-notif', async (c) => {\n    const baseUrl = c.req.url.replace(c.req.path, '')\n    const fid = Number(c.req.query('fid'))\n    const title = c.req.query('title') || name + ' test notification'\n    const body = c.req.query('body') || 'Hello, World!'\n\n    if (!fid) {\n      return c.json({ error: 'fid is required' })\n    }\n\n    console.log('[miniapp-test-notif]', { fid, title, body })\n\n    try {\n      const res = await sendNotificationToUser(fid, {\n        title,\n        body,\n        targetUrl: baseUrl,\n      })\n      console.log('[miniapp-test-notif]', res)\n      return c.json({ res })\n    } catch (err) {\n      console.error('[miniapp-test-notif]', err)\n      return c.json({ error: err.message })\n    }\n  })\n}\n\nconst decodeBase64Json = (str: string) => JSON.parse(Buffer.from(str, 'base64').toString('utf-8'))\n\nasync function sendWelcomeNotification(fid: number, baseUrl: string) {\n  return await sendNotificationToUser(fid, {\n    title: name + ' installed!',\n    body: '🚀🚀🚀🚀🚀',\n    targetUrl: baseUrl,\n  })\n}\n",[],[173,381],"f5628c46-196f-11f0-af1b-569c3dd06744","farcaster-notifications.ts","a796b84a-195e-11f0-9cbf-569c3dd06744",520,["D",1744662909733],"import * as db from \"./db.ts\";\n\nconst dbKey = \"fc-notification-details-by-fid\";\n\nexport async function saveUserNotificationsDetails(fid: number, notificationDetails: any) {\n  let notificationDetailsByFid: any = await db.get(dbKey) || {};\n  notificationDetailsByFid[fid] = notificationDetails;\n  await db.set(dbKey, notificationDetailsByFid);\n  console.log(\"🔔 saveUserNotificationsDetails\", fid);\n}\n\nexport async function getUserNotificationsDetails(fid: number) {\n  let notificationDetailsByFid: any = await db.get(dbKey) || {};\n  return notificationDetailsByFid[fid];\n}\n\nexport async function sendNotificationToUser(fid: number, payload: any) {\n  const notificationDetails = await getUserNotificationsDetails(fid);\n  if (!notificationDetails) {\n    console.log(\"🔔 sendNotificationToUser: user not found\", fid);\n    return;\n  }\n\n  console.log(\"🔔 sendNotificationToUser\", fid);\n  return await sendNotification(notificationDetails, payload);\n}\n\nexport async function sendNotificationToAllUsers(payload: any) {\n  let notificationDetailsByFid: any = await db.get(dbKey) || {};\n\n  for (const fid in notificationDetailsByFid) {\n    const notificationDetails = notificationDetailsByFid[fid];\n    console.log(\"🔔 sendNotificationToAllUsers\", fid);\n    try {\n      await sendNotification(notificationDetails, payload);\n    } catch (error) {\n      console.error(\"🔔 sendNotificationToAllUsers: error sending to\", fid, error);\n    }\n  }\n}\n\nasync function sendNotification(notificationDetails: any, payload: any) {\n  return await fetch(notificationDetails.url, {\n    method: \"POST\",\n    headers: { \"Content-Type\": \"application/json\" },\n    body: JSON.stringify({\n      notificationId: Math.random().toString(36), // TODO: generate a unique id\n      tokens: [notificationDetails.token],\n      ...payload,\n    }),\n  }).then(res => res.json());\n}",[],[173,390],"c555472e-1874-11f0-bb85-569c3dd06744","db.ts","c0362542-1874-11f0-975f-569c3dd06744",460,["D",1744555025433],"import { blob } from \"https://esm.town/v/std/blob\";\n\nconst projectPrefix = \"miniapp-starter\";\n\nexport async function get(key: string) {\n  return await blob.getJSON(`${projectPrefix}::${key}`);\n}\nexport async function set(key: string, value: any) {\n  return await blob.setJSON(`${projectPrefix}::${key}`, value);\n}",[],[173,398],"44150a86-2e73-11f0-aaaa-569c3dd06744","daily-notification.ts","4ef6939e-196e-11f0-873d-569c3dd06744",590,["D",1746973304668],"interval","import { sendNotificationToAllUsers } from \"./farcaster-notifications.ts\";\n\nconst baseUrl = \"https://miniapp-starter.val.run\";\n\nexport default async function(interval: Interval) {\n  // await sendNotificationToAllUsers({\n  //   title: \"Example daily notification\",\n  //   body: \"Hello, World!\",\n  //   targetUrl: baseUrl,\n  // });\n}",[],[173,406],"7dda01b8-77b6-11f0-b8f6-0224a6c84d84","analytics.tsx","d0a86cce-4d1b-11f0-8bb0-76b3cceeab13",678,["D",1755028612754],"/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from 'npm:hono'\n\nimport { name } from './farcaster.ts'\nimport { dbQuery } from './supabase.ts'\n\nexport function handleAnalyticsEndpoints(app: Hono) {\n  app.get('/analytics', (c) => {\n    const period = c.req.query('p') || 'week'\n    return c.html(<Dashboard period={period} />, 200)\n  })\n}\n\nasync function Dashboard({ period = 'week' }) {\n  // todo: load all data in parallel (postgress connection issue)\n  const w = 90\n  const title = `${name} · Analytics`\n  return (\n    <html>\n      <head>\n        <title>{name} · Analytics</title>\n        <script src=\"https://cdn.tailwindcss.com\"></script>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n        <link rel=\"icon\" href=\"/icon?rounded=1\" />\n      </head>\n      <body className=\"bg-white text-black dark:bg-black dark:text-white\">\n        <pre className=\"text-sm leading-4 p-4\">\n          <div>\n            <B> ═══ </B>\n            <span className=\"font-bold\">{title}</span>\n            <B> {''.padEnd(w - title.length - 8, '═')}═ </B>\n          </div>\n          <B>{'  '.padEnd(w - 2, ' ') + '  '}</B>\n\n          <div className=\"flex flex-row\">\n            <Table data={await countUsersByInterval({})} title=\"DAU\" props={['interval', 'count']} w={w / 3} />\n            <Table\n              data={await countUsersByInterval({ intervalFormat: 'IYYY-\"W\"IW' })}\n              title=\"WAU\"\n              props={['interval', 'count']}\n              w={w / 3}\n            />\n            <Table\n              data={await countUsersByInterval({ intervalFormat: 'YYYY-MM' })}\n              title=\"MAU\"\n              props={['interval', 'count']}\n              w={w / 3}\n            />\n          </div>\n          <div className=\"flex flex-row\">\n            <Table\n              data={await topScreens({ period })}\n              title={`Top Screens (${period})`}\n              props={['param', 'count']}\n              w={(w * 2) / 3}\n            />\n            <Table\n              data={await topUsers({ period })}\n              title={`Top Users (${period})`}\n              props={['fid', 'count']}\n              w={w / 3}\n            />\n          </div>\n          <div className=\"flex flex-row\">\n            <Table\n              data={await topOpenLocations({ period })}\n              title={`Top Open Locations (${period})`}\n              props={['locationText', 'count']}\n              w={(w * 2) / 3}\n            />\n            <Table\n              data={await topClients({ period })}\n              title={`Top Clients (${period})`}\n              props={['client', 'count']}\n              w={w / 3}\n            />\n          </div>\n        </pre>\n      </body>\n    </html>\n  )\n}\n\nfunction Table({ data, title, props, w }) {\n  const renderProp = (item, prop) => {\n    const gap = '   '\n    let text = String(item[prop] || '')\n    if (prop == 'count') return gap + text.padStart(5)\n    if (text.length > w - 18) text = text.slice(0, w - 21) + '...'\n    if (item.link)\n      return (\n        <>\n          <a\n            href={item.link}\n            target=\"_blank\"\n            // className=\"underline underline-offset-2 decoration-neutral-300 dark:decoration-neutral-600\"\n          >\n            {text}\n          </a>\n          {''.padEnd(w - text.length - 18)}\n        </>\n      )\n    return text.padEnd(w - 18)\n  }\n  const renderRow = (item) => {\n    return <>{props.map((prop) => renderProp(item, prop))}</>\n  }\n\n  return (\n    <div>\n      <div>\n        <B> ┌── </B>\n        <span className=\"font-bold\">{title}</span>\n        <B> {''.padEnd(w - title.length - 10, '─')}──┐ </B>\n      </div>\n      <Spacer w={w} />\n      {data.map((item, i) => (\n        <div key={i}>\n          <B>{' │   '}</B>\n          <span className=\"opacity-90\">{renderRow(item)}</span>\n          <B>{'   │ '}</B>\n        </div>\n      ))}\n      <Spacer w={w} />\n      {Array.from({ length: 10 - data.length }, () => (\n        <Spacer w={w} />\n      ))}\n      <div>\n        <B> └──{''.padEnd(w - 6, '─')}┘ </B>\n      </div>\n      <div> </div>\n    </div>\n  )\n}\n\nfunction B({ children }) {\n  return <span className=\"text-neutral-300 dark:text-neutral-600\">{children}</span>\n}\n\nfunction Spacer({ w }) {\n  return (\n    <div>\n      <B>{' │'.padEnd(w - 2, ' ') + '│ '}</B>\n    </div>\n  )\n}\n\nfunction countUsersByInterval({ intervalFormat = 'YYYY-MM-DD' }) {\n  return analyticsQuery(`\n  select TO_CHAR(created_at, '${intervalFormat}') as interval, COUNT(distinct fid)\n  from analytics_events\n  where created_at >= NOW() - INTERVAL '1 year'\n  group by interval\n  order by interval desc\n  limit 10`)\n}\nfunction topOpenLocations({ period = 'week' }) {\n  return analyticsQuery(`\n  select param, COUNT(*)\n  from analytics_events\n  where created_at >= NOW() - INTERVAL '1 ${period}' and event = 'miniapp_open'\n  group by param\n  order by count desc\n  limit 10`).then(miniappLocationDataTransformer)\n}\nfunction topClients({ period = 'week' }) {\n  return analyticsQuery(`\n  select param, COUNT(*)\n  from analytics_events\n  where created_at >= NOW() - INTERVAL '1 ${period}' and event = 'miniapp_open'\n  group by param\n  order by count desc\n  limit 500`).then(miniappClientDataTransformer)\n}\nfunction topScreens({ period = 'week' }) {\n  return analyticsQuery(`\n  select param, COUNT(*)\n  from analytics_events\n  where created_at >= NOW() - INTERVAL '1 ${period}' and event = 'screen_view'\n  group by param\n  order by count desc\n  limit 10`).then(screenDataTransformer)\n}\nfunction topUsers({ period = 'week' }) {\n  return analyticsQuery(`\n  select fid, COUNT(*)\n  from analytics_events\n  where created_at >= NOW() - INTERVAL '1 ${period}'\n  group by fid\n  order by count desc\n  limit 10`).then(userDataTransformer)\n}\n\nfunction screenDataTransformer(data: any) {\n  return data.map((item: any) => {\n    return {\n      ...item,\n      link: item.param,\n    }\n  })\n}\nfunction userDataTransformer(data: any) {\n  return data.map((item: any) => {\n    return {\n      ...item,\n      link: `https://sonar.val.run/u/fid:${item.fid}`,\n    }\n  })\n}\nfunction miniappLocationDataTransformer(data: any) {\n  return data.map((item: any) => {\n    return {\n      ...item,\n      locationText: getLocationText(item.param),\n      link: getLocationLink(item.param),\n    }\n  })\n}\nfunction miniappClientDataTransformer(data: any) {\n  // map to client then group by client, then convert to array\n  const clients = data\n    .map((item: any) => {\n      return {\n        ...item,\n        // client: getClientFidText(JSON.parse(item.param).clientFid),\n        clientFid: JSON.parse(item.param).clientFid,\n      }\n    })\n    .reduce((acc: any, item: any) => {\n      const clientFid = item.clientFid\n      if (!acc[clientFid]) {\n        acc[clientFid] = 0\n      }\n      acc[clientFid] += Number(item.count)\n      return acc\n    }, {})\n  return Object.entries(clients)\n    .map(([clientFid, count]) => ({\n      clientFid,\n      client: getClientFidText(clientFid),\n      count: count as number,\n      link: `https://sonar.val.run/u/fid:${clientFid}`,\n    }))\n    .sort((a, b) => b.count - a.count)\n    .slice(0, 10)\n}\n\nfunction getLocationText(param: string) {\n  let locationText = ''\n  if (param) {\n    const location = JSON.parse(param)\n    locationText += '[' + getClientFidText(location.clientFid).slice(0, 4) + '] '\n\n    locationText +=\n      location.locationType\n        ?.replace('cast_embed', 'cast embed') // 📝\n        .replace('cast_share', 'cast share') // 📝\n        .replace('miniapp_open', 'miniapp open') // 🧩\n        .replace('notification', 'notification') // 🔔\n        .replace('channel', 'channel') // 📡\n        .replace('launcher', 'launcher') || '' // 📱\n\n    if (location.locationId) locationText += `: ${location.locationId}`\n  }\n  return locationText\n}\nfunction getClientFidText(clientFid: any) {\n  if (!clientFid) return `Farcaster`\n  if (clientFid == 9152) return `Farcaster`\n  if (clientFid == 399519) return `Base`\n  if (clientFid == 309857) return `Base`\n  if (clientFid == 827605) return `Zapper`\n  if (clientFid == 356900) return `Recaster`\n  return `${clientFid}`\n}\nfunction getLocationLink(param: string) {\n  if (param) {\n    const location = JSON.parse(param)\n    if (location.locationType == 'cast_embed') return `https://sonar.val.run/p/${location.locationId}`\n    if (location.locationType == 'cast_share') return `https://sonar.val.run/p/${location.locationId}`\n  }\n  return ''\n}\n\nasync function analyticsQuery(query: string, args: any[] = []) {\n  const result = await dbQuery(query, args)\n  return safeRows(result.rows)\n}\n\nfunction safeRows(rows: any[]) {\n  return rows.map((row) => {\n    const newRow: Record<string, any> = {}\n    for (const key in row) {\n      if (typeof row[key] === 'bigint') {\n        newRow[key] = String(row[key])\n      } else {\n        newRow[key] = row[key]\n      }\n    }\n    return newRow\n  })\n}\n",[],[173,415],["D",1742482886402],[198,199,200,201,202,203,204,205,206],[173],"fa3a7b18-3664-11f0-b0e6-9e149126039e","tasks.json","eb668842-2684-11f0-87e1-569c3dd06744",591,["D",1747846777116],"{\n  \"version\": \"2.0.0\",\n  \"tasks\": [\n    {\n      \"label\": \"vt push\",\n      \"type\": \"shell\",\n      \"command\": \"vt push\",\n      \"group\": {\n        \"kind\": \"build\",\n        \"isDefault\": true\n      },\n    },\n    {\n      \"label\": \"vt watch\",\n      \"type\": \"shell\",\n      \"command\": \"vt watch\",\n    },\n    {\n      \"label\": \"vt pull\",\n      \"type\": \"shell\",\n      \"command\": \"vt pull\",\n    },\n    {\n      \"label\": \"vt status\",\n      \"type\": \"shell\",\n      \"command\": \"vt status\",\n    },\n    {\n      \"label\": \"vt browse\",\n      \"type\": \"shell\",\n      \"command\": \"vt browse\",\n    },\n  ]\n}\n",[],[179,426],["D",1746101277393],[196],[179],["D",1742482886202],{"_11":12,"_89":85},{"_11":12,"_83":-5,"_84":85,"_45":46,"_86":87,"_88":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_111":473,"_474":475,"_476":477,"_478":38,"_479":38,"_480":38,"_481":50,"_482":-5,"_483":-7,"_484":-7,"_485":135,"_486":38,"_487":38,"_488":-5,"_489":38,"_490":38,"_491":38,"_492":-5},"ENV",{"_444":445,"_446":447,"_448":26,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]
</article></body></html>

Branches1

Branches
1