Val Town Code SearchReturn to Val Town

15};
16
17function isInNorthAmerica(lat: number, lng: number): boolean {
18  return (
19    lat >= NA_BOUNDS.latMin &&

16 * Initialize the database with our table
17 */
18export async function initDatabase() {
19  await sqlite.execute(`
20    CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
33 * If not, create a new record
34 */
35export async function recordVisit(ip: string): Promise<void> {
36  const now = new Date().toISOString();
37  await sqlite.execute(
48 * Get all visit records
49 */
50export async function getAllVisits(): Promise<VisitRecord[]> {
51  const result = await sqlite.execute(
52    `SELECT * FROM ${TABLE_NAME} ORDER BY visits DESC`,
59 * Get total visit count across all IPs
60 */
61export async function getTotalVisits(): Promise<number> {
62  const result = await sqlite.execute(
63    `SELECT SUM(visits) as total FROM ${TABLE_NAME}`,

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}