IP Visit Counter

\n Tracking visits from different IP addresses\n

\n\n

Visit Statistics

\n \n Refresh Data\n \n

\n\n

Total Visits

Your IP Address

Unknown

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

IP Address	Visits	First Visit	Last Visit
\n Loading visit data...\n

\n\n \n

\n\n \n \n","label",[177,66],"frontend","pulls","branches","forks","envVars",{"_185":26,"_187":26},"connections",{"_185":26,"_186":26},"count","unfilledCount","emptyCount",{"_35":231,"_13":230,"_64":222,"_45":-5,"_37":38,"_169":232,"_170":108,"_39":233,"_41":26,"_67":216,"_173":-5,"_68":24,"_175":-5,"_201":234,"_17":235},{"_35":219,"_13":220,"_64":221,"_45":222,"_37":38,"_169":223,"_170":108,"_39":224,"_41":225,"_67":226,"_173":227,"_68":24,"_175":-5,"_201":228,"_17":229},{"_35":214,"_13":177,"_64":168,"_45":-5,"_37":38,"_169":42,"_170":108,"_39":215,"_41":26,"_67":216,"_173":-5,"_68":24,"_175":-5,"_201":217,"_17":218},{"_35":167,"_13":66,"_64":65,"_45":168,"_37":38,"_169":90,"_170":108,"_39":211,"_41":172,"_67":21,"_173":174,"_68":24,"_175":-5,"_201":212,"_17":213},{"_35":204,"_13":205,"_64":206,"_45":-5,"_37":38,"_169":113,"_170":108,"_39":207,"_41":26,"_67":21,"_173":208,"_68":24,"_175":-5,"_201":209,"_17":210},{"_35":194,"_13":195,"_64":106,"_45":-5,"_37":38,"_169":111,"_170":108,"_39":196,"_41":197,"_67":198,"_173":199,"_68":24,"_175":200,"_201":202,"_17":203},"c8e4894e-2f9a-11f0-8b6f-569c3dd06744","index.ts",["D",1747100229023],8,"http","import { serveStatic } from \"https://esm.sh/@hono/node-server@1.2.0/serve-static\";\nimport { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { getAllVisits, getTotalVisits, initDatabase, recordVisit } from \"./backend/database.ts\";\n\n// Initialize the Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize the database on startup\nawait initDatabase();\n\n// API endpoint to get visit data\napp.get(\"/api/visits\", async (c) => {\n const visits = await getAllVisits();\n const totalVisits = await getTotalVisits();\n\n // Extract the current IP using the same logic as the main route\n const forwardedFor = c.req.header(\"x-forwarded-for\") || \"unknown\";\n const currentIp = forwardedFor.split(\",\")[0].trim();\n\n return c.json({\n visits,\n totalVisits,\n currentIp,\n });\n});\n\n// Serve the main page with visit tracking\napp.get(\"/\", async (c) => {\n // Get the visitor's IP address\n // Extract just the first IP from x-forwarded-for which can be comma-separated\n const forwardedFor = c.req.header(\"x-forwarded-for\") || \"unknown\";\n const ip = forwardedFor.split(\",\")[0].trim();\n\n // Record this visit\n await recordVisit(ip);\n\n // Get the HTML template\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Get the current visit data to inject\n const visits = await getAllVisits();\n const totalVisits = await getTotalVisits();\n\n // Inject the data into the HTML\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n\n return c.html(html);\n});\n\n// Serve static files from the frontend directory\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// This is the entry point for HTTP vals\nexport default app.fetch;","ipv4","children",[],[195],"287cc04c-2f73-11f0-aada-569c3dd06744","README.md","287cc0f6-2f73-11f0-aada-569c3dd06744",["D",1747083209541],"# IP Visit Counter\n\nA simple website that tracks and displays the number of visits from different IP addresses.\n\n## Features\n\n- Records visits from unique IP addresses\n- Displays a count of visits per IP address\n- Shows total visit count\n\n## Project Structure\n\n- `backend/` - Server-side code\n - `index.ts` - Main HTTP handler using Hono\n - `database.ts` - SQLite database setup and queries\n- `frontend/` - Client-side code\n - `index.html` - Main webpage\n\n## How It Works\n\nWhen a user visits the site, their IP address is recorded in the SQLite database. If the IP already exists, its visit counter is incremented. The page displays a table of all IP addresses and their visit counts.",[],[205],["D",1749047344252],[],[177,66],"43e4a714-2f73-11f0-8220-569c3dd06744",["D",1747083255520],"directory",[191],[177],"240d3bdc-2ff4-11f0-94c5-569c3dd06744","database.ts","2ea3d6b8-2f73-11f0-8fad-569c3dd06744","02458130-e2f3-43f6-b859-cf5280073d2d",19,["D",1747138607174],6,"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table name - change this if you need to modify the schema\nconst TABLE_NAME = \"ip_visits_v1\";\n\n// Define the structure of our visit records\nexport interface VisitRecord {\n id: number;\n ip: string;\n visits: number;\n first_visit: string;\n last_visit: string;\n}\n\n/**\n * Initialize the database with our table\n */\nexport async function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ip TEXT NOT NULL UNIQUE,\n visits INTEGER NOT NULL DEFAULT 1,\n first_visit TEXT NOT NULL,\n last_visit TEXT NOT NULL\n )\n `);\n}\n\n/**\n * Record a visit from an IP address\n * If the IP exists, increment its counter\n * If not, create a new record\n */\nexport async function recordVisit(ip: string): Promise {\n const now = new Date().toISOString();\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (ip, visits, first_visit, last_visit) \n VALUES (?, 1, ?, ?)\n ON CONFLICT(ip) DO UPDATE SET \n visits = visits + 1, \n last_visit = ?`,\n [ip, now, now, now],\n );\n}\n\n/**\n * Get all visit records\n */\nexport async function getAllVisits(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY visits DESC`,\n );\n\n return result.rows as VisitRecord[];\n}\n\n/**\n * Get total visit count across all IPs\n */\nexport async function getTotalVisits(): Promise {\n const result = await sqlite.execute(\n `SELECT SUM(visits) as total FROM ${TABLE_NAME}`,\n );\n\n return result.rows[0]?.total || 0;\n}",[],[230,220],"backend","2ea3f54e-2f73-11f0-8fad-569c3dd06744",2,["D",1747083219863],[189],[230],["D",1747083168181],{"_11":12,"_145":71},{"_11":12,"_141":-5,"_70":71,"_30":69,"_142":143,"_144":24},{"_41":90,"_13":16,"_35":38,"_133":96,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_54":-5,"_164":273,"_274":275,"_276":277,"_278":24,"_279":24,"_280":24,"_281":108,"_282":-5,"_283":-7,"_284":-7,"_285":26,"_286":24,"_287":24,"_288":-5,"_289":24,"_290":24,"_291":24,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":16,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

History · index.html