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",[],[69,97],["D",1747083219863],[108],[76],{"_36":109,"_13":110,"_39":111,"_41":77,"_42":43,"_44":112,"_46":47,"_48":113,"_17":114,"_51":115,"_53":116,"_55":56,"_57":-5,"_86":117,"_18":118},"240d3bdc-2ff4-11f0-94c5-569c3dd06744","database.ts","2ea3d6b8-2f73-11f0-8fad-569c3dd06744",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}",[],[76,110],"0fd4bb58-2f73-11f0-b386-569c3dd06744",["D",1747083168181],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","418c1e39-eb48-4f2f-8c97-122ece94631c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","c1e7642a-74cc-4d69-8652-20abbdeaa94e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_171":167},"org",{"_11":12,"_165":-5,"_166":167,"_128":129,"_168":169,"_170":56},"branch",{"_17":99,"_13":16,"_36":43,"_157":119,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":-5,"_163":14,"_164":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJnTEtkSHlOMWxWZm1GRHdKYUVTNklYM3FpdiJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":119,"_13":14,"_48":225,"_121":-5,"_122":56,"_123":124,"_125":124,"_126":-5,"_127":-5,"_128":129,"_130":40,"_131":47,"_132":-5,"_133":45,"_134":63,"_135":136,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":142,"_143":142,"_144":145,"_146":145,"_147":145,"_148":142,"_149":142,"_150":226,"_152":227,"_154":228,"_156":56},[207,209,211,212],"files",[207,208,209,210,211,212],"counts",{"_198":65,"_199":63,"_200":63,"_31":201,"_202":203},[190,191,192,193],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_36":75,"_13":76,"_39":77,"_41":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":65,"_51":73,"_53":-5,"_55":56,"_57":-5,"_18":197},{"_36":68,"_13":69,"_39":70,"_41":-5,"_42":43,"_44":71,"_46":47,"_48":72,"_17":65,"_51":73,"_53":-5,"_55":56,"_57":-5,"_18":196},{"_36":60,"_13":61,"_39":62,"_41":-5,"_42":43,"_44":63,"_46":47,"_48":64,"_17":65,"_51":24,"_53":66,"_55":56,"_57":-5,"_18":195},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_18":194},[38],[61],[69],[76],"pulls","branches","forks",{"_204":65,"_206":65},"connections",{"_204":65,"_205":65},"count","unfilledCount","emptyCount",{"_36":75,"_13":76,"_39":77,"_41":-5,"_42":43,"_44":78,"_46":47,"_48":105,"_17":65,"_51":73,"_53":-5,"_55":56,"_57":-5,"_86":223,"_18":224},{"_36":109,"_13":110,"_39":111,"_41":77,"_42":43,"_44":112,"_46":47,"_48":113,"_17":114,"_51":115,"_53":116,"_55":56,"_57":-5,"_86":221,"_18":222},{"_36":68,"_13":69,"_39":70,"_41":-5,"_42":43,"_44":71,"_46":47,"_48":92,"_17":65,"_51":73,"_53":-5,"_55":56,"_57":-5,"_86":219,"_18":220},{"_36":96,"_13":97,"_39":98,"_41":70,"_42":43,"_44":99,"_46":47,"_48":100,"_17":101,"_51":24,"_53":102,"_55":56,"_57":-5,"_86":217,"_18":218},{"_36":60,"_13":61,"_39":62,"_41":-5,"_42":43,"_44":63,"_46":47,"_48":89,"_17":65,"_51":24,"_53":66,"_55":56,"_57":-5,"_86":215,"_18":216},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":85,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_86":213,"_18":214},[],[38],[],[61],[],[69,97],[210],[69],[],[76,110],[208],[76],["D",1747083168181],{"_11":12,"_171":167},{"_11":12,"_165":-5,"_166":167,"_128":129,"_168":169,"_170":56},{"_17":99,"_13":16,"_36":43,"_157":119,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":-5,"_163":14,"_164":12},"ctx",{"_150":-5,"_187":262,"_263":264,"_265":266,"_267":56,"_268":56,"_269":56,"_270":47,"_271":-5,"_272":-7,"_273":-7,"_274":65,"_275":56,"_276":56,"_277":-5,"_278":56,"_279":56,"_280":56,"_281":-5},"ENV",{"_233":234,"_235":236,"_237":16,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261},"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"]

Code