[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_237":238,"_239":240},"routes/_app.x.$handle.$name",{"_103":102,"_38":51,"_112":93,"_33":59,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":31,"_126":127,"_128":129,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":-5,"_63":31,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":31},"version",24,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","727a8254-875b-4466-bf6f-7080c475d9ed","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","auto-rank.ts","latestPath","fileId","24338808-7aff-11f1-9065-1607ee4eb77e","name","fileType","interval","content","/**\n * Auto-ranking engine.\n *\n * Runs on a schedule (interval) or can be triggered via the HTTP API.\n * For each group member, checks enabled ranking rules:\n * - If the member's current role matches a rule's source_role_id\n * - AND they've been in the group for >= min_days_in_group days\n * → Promote them to the rule's target_role_id\n */\nimport {\n getGroupRoles,\n getGroupMembers,\n assignRole,\n getUser,\n type GroupRole,\n type GroupMember,\n} from \"./roblox.ts\";\nimport { getRules, logAction, initDB } from \"./db.ts\";\n\n/** Days between a date string and now. */\nfunction daysSince(dateStr: string): number {\n if (!dateStr) return Infinity; // If unknown, treat as old enough\n const then = new Date(dateStr).getTime();\n const now = Date.now();\n return Math.floor((now - then) / (1000 * 60 * 60 * 24));\n}\n\nexport interface AutoRankResult {\n checked: number;\n promoted: number;\n errors: number;\n actions: Array<{\n userId: string;\n username: string;\n from: string;\n to: string;\n reason: string;\n }>;\n errors_list: string[];\n}\n\n/** Core auto-ranking logic — called by the interval and the HTTP endpoint. */\nexport async function runAutoRank(): Promise {\n await initDB(); // Ensure tables exist (important for interval runs)\n const rules = await getRules(true); // enabled only\n if (rules.length === 0) {\n return {\n checked: 0,\n promoted: 0,\n errors: 0,\n actions: [],\n errors_list: [\"No enabled ranking rules found\"],\n };\n }\n\n // Fetch roles and members\n const roles: GroupRole[] = await getGroupRoles();\n const members: GroupMember[] = await getGroupMembers();\n const roleMap = new Map(roles.map((r) => [r.id, r.displayName]));\n\n const result: AutoRankResult = {\n checked: 0,\n promoted: 0,\n errors: 0,\n actions: [],\n errors_list: [],\n };\n\n // Sort rules by min_days descending so the highest qualifying rule wins\n const sortedRules = [...rules].sort((a, b) =>\n b.min_days_in_group - a.min_days_in_group\n );\n\n for (const member of members) {\n result.checked++;\n\n // Find the best matching rule for this member\n const matchingRule = sortedRules.find((rule) => {\n if (rule.source_role_id !== member.roleId) return false;\n const days = daysSince(member.createTime);\n return days >= rule.min_days_in_group;\n });\n\n if (!matchingRule) continue;\n\n // Get username for logging\n let username = \"unknown\";\n try {\n const user = await getUser(member.userId);\n username = user.name;\n } catch { /* non-critical */ }\n\n const fromRole = roleMap.get(member.roleId) || \"Unknown\";\n const toRole = roleMap.get(matchingRule.target_role_id) || \"Unknown\";\n\n try {\n await assignRole(member.membershipId, matchingRule.target_role_id);\n logAction(\n member.userId,\n username,\n fromRole,\n toRole,\n `Auto-promoted: ${matchingRule.min_days_in_group}+ days in group`,\n );\n result.promoted++;\n result.actions.push({\n userId: member.userId,\n username,\n from: fromRole,\n to: toRole,\n reason: `${matchingRule.min_days_in_group}+ days in group`,\n });\n } catch (e) {\n result.errors++;\n result.errors_list.push(\n `Failed to rank ${username} (${member.userId}): ${e.message}`,\n );\n }\n\n // Small delay to respect rate limits (300/min)\n await new Promise((r) => setTimeout(r, 250));\n }\n\n return result;\n}\n\n/** Interval entrypoint — runs automatically on schedule. */\nexport default async function () {\n console.log(\"🤖 Auto-rank interval triggered at\", new Date().toISOString());\n try {\n const result = await runAutoRank();\n console.log(\n `✅ Auto-rank complete: ${result.checked} checked, ${result.promoted} promoted, ${result.errors} errors`,\n );\n if (result.actions.length > 0) {\n console.log(\"Promotions:\", JSON.stringify(result.actions, null, 2));\n }\n if (result.errors_list.length > 0) {\n console.error(\"Errors:\", result.errors_list);\n }\n } catch (e) {\n console.error(\"Auto-rank failed:\", e.message);\n }\n}\n","/**\n * Auto-ranking engine.\n *\n * Runs on a schedule (interval) or can be triggered via the HTTP API.\n * For each group member, checks enabled ranking rules:\n * - If the member's current role matches a rule's source_role_id\n * - AND they've been in the group for >= min_days_in_group days\n * → Promote them to the rule's target_role_id\n */\nimport {\n getGroupRoles,\n getGroupMembers,\n assignRole,\n getUser,\n type GroupRole,\n type GroupMember,\n} from \"./roblox.ts\";\nimport { getRules, logAction, initDB } from \"./db.ts\";\n\n/** Days between a date string and now. */\nfunction daysSince(dateStr: string): number {\n if (!dateStr) return Infinity; // If unknown, treat as old enough\n const then = new Date(dateStr).getTime();\n const now = Date.now();\n return Math.floor((now - then) / (1000 * 60 * 60 * 24));\n}\n\nexport interface AutoRankResult {\n checked: number;\n promoted: number;\n errors: number;\n actions: Array<{\n userId: string;\n username: string;\n from: string;\n to: string;\n reason: string;\n }>;\n errors_list: string[];\n}\n\n/** Core auto-ranking logic — called by the interval and the HTTP endpoint. */\nexport async function runAutoRank(): Promise {\n await initDB(); // Ensure tables exist (important for interval runs)\n const rules = await getRules(true); // enabled only\n if (rules.length === 0) {\n return {\n checked: 0,\n promoted: 0,\n errors: 0,\n actions: [],\n errors_list: [\"No enabled ranking rules found\"],\n };\n }\n\n // Fetch roles and members\n const roles: GroupRole[] = await getGroupRoles();\n const members: GroupMember[] = await getGroupMembers();\n const roleMap = new Map(roles.map((r) => [r.id, r.displayName]));\n\n const result: AutoRankResult = {\n checked: 0,\n promoted: 0,\n errors: 0,\n actions: [],\n errors_list: [],\n };\n\n // Sort rules by min_days descending so the highest qualifying rule wins\n const sortedRules = [...rules].sort((a, b) =>\n b.min_days_in_group - a.min_days_in_group\n );\n\n for (const member of members) {\n result.checked++;\n\n // Find the best matching rule for this member\n const matchingRule = sortedRules.find((rule) => {\n if (rule.source_role_id !== member.roleId) return false;\n const days = daysSince(member.createTime);\n return days >= rule.min_days_in_group;\n });\n\n if (!matchingRule) continue;\n\n // Get username for logging\n let username = \"unknown\";\n try {\n const user = await getUser(member.userId);\n username = user.name;\n } catch { /* non-critical */ }\n\n const fromRole = roleMap.get(member.roleId) || \"Unknown\";\n const toRole = roleMap.get(matchingRule.target_role_id) || \"Unknown\";\n\n try {\n await assignRole(member.membershipId, matchingRule.target_role_id);\n await logAction(\n member.userId,\n username,\n fromRole,\n toRole,\n `Auto-promoted: ${matchingRule.min_days_in_group}+ days in group`,\n );\n result.promoted++;\n result.actions.push({\n userId: member.userId,\n username,\n from: fromRole,\n to: toRole,\n reason: `${matchingRule.min_days_in_group}+ days in group`,\n });\n } catch (e) {\n result.errors++;\n result.errors_list.push(\n `Failed to rank ${username} (${member.userId}): ${e.message}`,\n );\n }\n\n // Small delay to respect rate limits (300/min)\n await new Promise((r) => setTimeout(r, 250));\n }\n\n return result;\n}\n\n/** Interval entrypoint — runs automatically on schedule. */\nexport default async function () {\n console.log(\"🤖 Auto-rank interval triggered at\", new Date().toISOString());\n try {\n const result = await runAutoRank();\n console.log(\n `✅ Auto-rank complete: ${result.checked} checked, ${result.promoted} promoted, ${result.errors} errors`,\n );\n if (result.actions.length > 0) {\n console.log(\"Promotions:\", JSON.stringify(result.actions, null, 2));\n }\n if (result.errors_list.length > 0) {\n console.error(\"Errors:\", result.errors_list);\n }\n } catch (e) {\n console.error(\"Auto-rank failed:\", e.message);\n }\n}\n","createdAt",["D",1783537338139],"branchVersion","branchId","5c50c4df-e0f6-49fa-84f9-c93ff13e6029","id","a1134ee6-20ed-46b5-9387-13f9b22f6073","API",["D",1783536847583],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","b42bc553-95d9-47f1-a393-d1ed4951b4f3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f4314-02d8-77ea-9313-d14d6836317c","tursoName","a1134ee620ed46b5938713f9b22f6073","tursoHostname","a1134ee620ed46b5938713f9b22f6073-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_19":61,"_108":109,"_110":31},"branch",{"_13":14,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jamesdopp","handle","displayName","James Dopp","avatar","https://lh3.googleusercontent.com/a/ACg8ocK_aLMno0IvMp1g7wxRiXRCbJ02YXD0rhV6Dk3LInziBqlJHUs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":232,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":-5,"_63":31,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":233,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":234,"_88":235,"_90":236,"_92":31},"tree",[203,204,205,206,207,208,209],"files",[203,204,205,206,207,208,209],"counts",{"_193":67,"_194":166,"_195":67,"_196":197,"_198":199},"contents",[134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_49":186,"_38":187,"_36":188,"_144":-5,"_47":48,"_46":189,"_146":129,"_44":190,"_13":67,"_39":191,"_41":-5,"_30":31,"_150":-5,"_33":192},{"_49":179,"_38":180,"_36":181,"_144":-5,"_47":48,"_46":182,"_146":129,"_44":183,"_13":67,"_39":26,"_41":184,"_30":31,"_150":-5,"_33":185},{"_49":173,"_38":174,"_36":175,"_144":-5,"_47":48,"_46":176,"_146":129,"_44":177,"_13":157,"_39":148,"_41":59,"_30":31,"_150":-5,"_33":178},{"_49":169,"_38":34,"_36":37,"_144":-5,"_47":48,"_46":14,"_146":129,"_44":170,"_13":171,"_39":40,"_41":43,"_30":31,"_150":-5,"_33":172},{"_49":161,"_38":162,"_36":163,"_144":-5,"_47":48,"_46":164,"_146":129,"_44":165,"_13":166,"_39":148,"_41":167,"_30":31,"_150":-5,"_33":168},{"_49":152,"_38":153,"_36":154,"_144":-5,"_47":48,"_46":155,"_146":129,"_44":156,"_13":157,"_39":158,"_41":159,"_30":31,"_150":-5,"_33":160},{"_49":141,"_38":142,"_36":143,"_144":-5,"_47":48,"_46":145,"_146":129,"_44":147,"_13":67,"_39":148,"_41":149,"_30":31,"_150":-5,"_33":151},"de61dc92-7354-458e-8276-02ae345d4dec","roblox.ts","115c90ee-7aff-11f1-8bf2-1607ee4eb77e","parentId",8,"latest",["D",1783537135164],"script","/**\n * Roblox Open Cloud API helper.\n * Docs: https://create.roblox.com/docs/cloud/reference/features/groups\n *\n * Requires env vars:\n * ROBLOX_API_KEY – Open Cloud API key (create at https://create.roblox.com/dashboard/credentials)\n * ROBLOX_GROUP_ID – Your Roblox group ID\n */\n\nconst BASE_URL = \"https://apis.roblox.com\";\n\nfunction getApiKey(): string {\n const key = Deno.env.get(\"ROBLOX_API_KEY\");\n if (!key) throw new Error(\"ROBLOX_API_KEY env var not set\");\n return key;\n}\n\nfunction getGroupId(): string {\n const id = Deno.env.get(\"ROBLOX_GROUP_ID\");\n if (!id) throw new Error(\"ROBLOX_GROUP_ID env var not set\");\n return id;\n}\n\nasync function robloxFetch(\n path: string,\n options: RequestInit = {},\n): Promise {\n const key = getApiKey();\n const res = await fetch(`${BASE_URL}${path}`, {\n ...options,\n headers: {\n \"x-api-key\": key,\n \"Content-Type\": \"application/json\",\n ...options.headers,\n },\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Roblox API error ${res.status}: ${text}`);\n }\n const text = await res.text();\n return text ? JSON.parse(text) : null;\n}\n\n/** Extract the trailing ID from a Roblox resource path like \"groups/123/roles/456\" → \"456\" */\nfunction extractId(path: string): string {\n const parts = path.split(\"/\");\n return parts[parts.length - 1];\n}\n\nexport interface GroupRole {\n id: string;\n displayName: string;\n description: string;\n}\n\nexport interface GroupMember {\n membershipId: string;\n userId: string;\n rolePath: string;\n roleId: string;\n createTime: string;\n}\n\nexport interface UserInfo {\n id: string;\n name: string;\n displayName: string;\n}\n\n/** Get all roles in the group (paginated). */\nexport async function getGroupRoles(): Promise {\n const groupId = getGroupId();\n const roles: GroupRole[] = [];\n let pageToken: string | undefined;\n do {\n const params = new URLSearchParams({ maxPageSize: \"20\" });\n if (pageToken) params.set(\"pageToken\", pageToken);\n const data = await robloxFetch(\n `/cloud/v2/groups/${groupId}/roles?${params}`,\n );\n for (const r of data.groupRoles || []) {\n roles.push({\n id: r.id,\n displayName: r.displayName,\n description: r.description || \"\",\n });\n }\n pageToken = data.nextPageToken;\n } while (pageToken);\n return roles;\n}\n\n/** Get all memberships in the group (paginated). */\nexport async function getGroupMembers(): Promise {\n const groupId = getGroupId();\n const members: GroupMember[] = [];\n let pageToken: string | undefined;\n do {\n const params = new URLSearchParams({ maxPageSize: \"100\" });\n if (pageToken) params.set(\"pageToken\", pageToken);\n const data = await robloxFetch(\n `/cloud/v2/groups/${groupId}/memberships?${params}`,\n );\n for (const m of data.groupMemberships || []) {\n members.push({\n membershipId: extractId(m.path),\n userId: extractId(m.user),\n rolePath: m.role || \"\",\n roleId: m.role ? extractId(m.role) : \"\",\n createTime: m.createTime || \"\",\n });\n }\n pageToken = data.nextPageToken;\n } while (pageToken);\n return members;\n}\n\n/** Assign a role to a group member by membership ID and role ID. */\nexport async function assignRole(\n membershipId: string,\n roleId: string,\n): Promise {\n const groupId = getGroupId();\n await robloxFetch(\n `/cloud/v2/groups/${groupId}/memberships/${membershipId}:assignRole`,\n {\n method: \"POST\",\n body: JSON.stringify({\n role: `groups/${groupId}/roles/${roleId}`,\n }),\n },\n );\n}\n\n/** Get a user's basic info by user ID. */\nexport async function getUser(userId: string): Promise {\n const data = await robloxFetch(`/cloud/v2/users/${userId}`);\n return {\n id: data.id,\n name: data.name,\n displayName: data.displayName,\n };\n}\n\n/** Get group info. */\nexport async function getGroup(): Promise<{\n id: string;\n displayName: string;\n description: string;\n}> {\n const groupId = getGroupId();\n const data = await robloxFetch(`/cloud/v2/groups/${groupId}`);\n return {\n id: data.id,\n displayName: data.displayName,\n description: data.description || \"\",\n };\n}\n","label",[142],"879a3904-5932-42ea-8265-c69641d70f39","main.ts","65f5f01a-7afe-11f1-89ad-1607ee4eb77e",18,["D",1783537292204],5,"http","/**\n * Roblox Auto-Rank API Bot\n *\n * HTTP endpoint for managing group ranking:\n * GET / – API info & group details\n * GET /roles – List all group roles\n * GET /members – List all group members\n * POST /rank – Manually rank a user { userId, roleId }\n * GET /rules – List ranking rules\n * POST /rules – Add a ranking rule { sourceRoleId, targetRoleId, minDaysInGroup }\n * DELETE /rules/:id – Delete a ranking rule\n * POST /auto-rank – Trigger auto-ranking run manually\n * GET /logs – View recent ranking action logs\n *\n * Env vars:\n * ROBLOX_API_KEY – Open Cloud API key\n * ROBLOX_GROUP_ID – Your group ID\n * API_SECRET – (optional) secret token for write endpoints\n */\nimport { Hono } from \"npm:hono\";\nimport {\n getGroupRoles,\n getGroupMembers,\n assignRole,\n getUser,\n getGroup,\n} from \"./roblox.ts\";\nimport {\n initDB,\n getRules,\n addRule,\n deleteRule,\n logAction,\n getLogs,\n} from \"./db.ts\";\nimport { runAutoRank } from \"./auto-rank.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Initialize database on first request\nlet dbReady = false;\nasync function ensureDB() {\n if (!dbReady) {\n await initDB();\n dbReady = true;\n }\n}\n\n/** Optional auth check for write endpoints */\nfunction checkAuth(c: any): boolean {\n const secret = Deno.env.get(\"API_SECRET\");\n if (!secret) return true; // No secret set = open access\n const auth = c.req.header(\"Authorization\") || \"\";\n const token = auth.replace(\"Bearer \", \"\");\n return token === secret;\n}\n\n// ─── GET / — API info & group details ───\napp.get(\"/\", async (c) => {\n try {\n const group = await getGroup();\n return c.json({\n name: \"Roblox Auto-Rank Bot\",\n group,\n endpoints: [\n \"GET /roles — List group roles\",\n \"GET /members — List group members\",\n \"POST /rank — Rank a user { userId, roleId }\",\n \"GET /rules — List ranking rules\",\n \"POST /rules — Add rule { sourceRoleId, targetRoleId, minDaysInGroup }\",\n \"DELETE /rules/:id — Delete a rule\",\n \"POST /auto-rank — Run auto-ranking\",\n \"GET /logs — View ranking logs\",\n ],\n });\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── GET /roles — List all group roles ───\napp.get(\"/roles\", async (c) => {\n try {\n const roles = await getGroupRoles();\n return c.json({ roles });\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── GET /members — List all group members ───\napp.get(\"/members\", async (c) => {\n try {\n const members = await getGroupMembers();\n return c.json({ count: members.length, members });\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── POST /rank — Manually rank a user ───\napp.post(\"/rank\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n try {\n const body = await c.req.json();\n const { userId, roleId } = body;\n\n if (!userId || !roleId) {\n return c.json({ error: \"Missing userId or roleId\" }, 400);\n }\n\n // Get user info for logging\n let username = \"unknown\";\n try {\n const user = await getUser(String(userId));\n username = user.name;\n } catch { /* non-critical */ }\n\n // Find the member's membership ID\n const members = await getGroupMembers();\n const member = members.find((m) => m.userId === String(userId));\n if (!member) {\n return c.json({ error: \"User is not a member of this group\" }, 404);\n }\n\n // Get role names for logging\n const roles = await getGroupRoles();\n const fromRole = roles.find((r) => r.id === member.roleId)?.displayName || \"Unknown\";\n const toRole = roles.find((r) => r.id === String(roleId))?.displayName || \"Unknown\";\n\n // Assign the new role\n await assignRole(member.membershipId, String(roleId));\n\n // Log the action\n await ensureDB();\n await logAction(String(userId), username, fromRole, toRole, \"Manual rank via API\");\n\n return c.json({\n success: true,\n user: { id: userId, name: username },\n from: fromRole,\n to: toRole,\n });\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── GET /rules — List ranking rules ───\napp.get(\"/rules\", async (c) => {\n await ensureDB();\n const rules = await getRules();\n return c.json({ rules });\n});\n\n// ─── POST /rules — Add a ranking rule ───\napp.post(\"/rules\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n await ensureDB();\n try {\n const { sourceRoleId, targetRoleId, minDaysInGroup } = await c.req.json();\n\n if (!sourceRoleId || !targetRoleId) {\n return c.json({ error: \"Missing sourceRoleId or targetRoleId\" }, 400);\n }\n\n const rule = await addRule(\n String(sourceRoleId),\n String(targetRoleId),\n Number(minDaysInGroup) || 0,\n );\n return c.json({ success: true, rule });\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── DELETE /rules/:id — Delete a ranking rule ───\napp.delete(\"/rules/:id\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n await ensureDB();\n const id = Number(c.req.param(\"id\"));\n const deleted = await deleteRule(id);\n if (!deleted) return c.json({ error: \"Rule not found\" }, 404);\n return c.json({ success: true });\n});\n\n// ─── POST /auto-rank — Trigger auto-ranking manually ───\napp.post(\"/auto-rank\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n await ensureDB();\n try {\n const result = await runAutoRank();\n return c.json(result);\n } catch (e) {\n return c.json({ error: e.message }, 500);\n }\n});\n\n// ─── GET /logs — View ranking logs ───\napp.get(\"/logs\", async (c) => {\n await ensureDB();\n const limit = Number(c.req.query(\"limit\")) || 50;\n const logs = await getLogs(Math.min(limit, 200));\n return c.json({ logs });\n});\n\nexport default app.fetch;\n",[153],"26629907-9731-44b8-bd61-7ee6e1287f7d","db.ts","1162e25a-7aff-11f1-9db7-1607ee4eb77e",15,["D",1783537259759],1,"/**\n * SQLite database setup for ranking rules and action logs.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface RankRule {\n id: number;\n source_role_id: string;\n target_role_id: string;\n min_days_in_group: number;\n enabled: number;\n created_at: string;\n}\n\nexport interface RankLogEntry {\n id: number;\n user_id: string;\n username: string;\n from_role: string;\n to_role: string;\n reason: string;\n created_at: string;\n}\n\n/** Create tables if they don't exist. Safe to call on every startup. */\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rank_rules (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n source_role_id TEXT NOT NULL,\n target_role_id TEXT NOT NULL,\n min_days_in_group INTEGER DEFAULT 0,\n enabled INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rank_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id TEXT NOT NULL,\n username TEXT,\n from_role TEXT,\n to_role TEXT,\n reason TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n}\n\n/** Get all enabled ranking rules. */\nexport async function getRules(enabledOnly = false): Promise {\n const sql = enabledOnly\n ? \"SELECT * FROM rank_rules WHERE enabled = 1 ORDER BY min_days_in_group DESC\"\n : \"SELECT * FROM rank_rules ORDER BY id\";\n const result = await sqlite.execute(sql);\n return result.rows as unknown as RankRule[];\n}\n\n/** Add a new ranking rule. */\nexport async function addRule(\n sourceRoleId: string,\n targetRoleId: string,\n minDaysInGroup: number,\n): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO rank_rules (source_role_id, target_role_id, min_days_in_group) VALUES (?, ?, ?)\",\n args: [sourceRoleId, targetRoleId, minDaysInGroup],\n });\n const result = await sqlite.execute(\"SELECT * FROM rank_rules ORDER BY id DESC LIMIT 1\");\n return (result.rows as unknown as RankRule[])[0];\n}\n\n/** Delete a ranking rule by ID. */\nexport async function deleteRule(id: number): Promise {\n const before = await sqlite.execute({\n sql: \"SELECT COUNT(*) as count FROM rank_rules WHERE id = ?\",\n args: [id],\n });\n if ((before.rows[0] as any).count === 0) return false;\n await sqlite.execute({ sql: \"DELETE FROM rank_rules WHERE id = ?\", args: [id] });\n return true;\n}\n\n/** Log a ranking action. */\nexport async function logAction(\n userId: string,\n username: string,\n fromRole: string,\n toRole: string,\n reason: string,\n): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO rank_log (user_id, username, from_role, to_role, reason) VALUES (?, ?, ?, ?, ?)\",\n args: [userId, username, fromRole, toRole, reason],\n });\n}\n\n/** Get recent ranking logs. */\nexport async function getLogs(limit = 50): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM rank_log ORDER BY id DESC LIMIT ?\",\n args: [limit],\n });\n return result.rows as unknown as RankLogEntry[];\n}\n",[162],"a7a1e772-3751-4ef6-8e45-c1a43097259a",["D",1783537338139],6,[34],"7fe63f56-03f0-4bdd-a1d3-e4d849162b3e","RobloxAPI.js","aaeb0f66-7afe-11f1-bb1e-1607ee4eb77e",7,["D",1783537133284],[174],"711c2908-a63e-4040-8cad-818a9725eee3","README.md","305d22ce-7aff-11f1-a2a1-1607ee4eb77e",14,["D",1783537187096],"# 🤖 Roblox Auto-Rank Bot\n\nAn API bot that automatically ranks members in your Roblox group based on configurable rules.\n\n## Features\n\n- **Manual Ranking** — Rank any member via API\n- **Auto-Ranking** — Scheduled interval that promotes members based on time-in-group rules\n- **Rule Management** — Add/remove ranking rules via API\n- **Action Logging** — Every rank change is logged with timestamps\n\n## Setup\n\n### 1. Get a Roblox Open Cloud API Key\n\n1. Go to \n2. Create a new API key\n3. Add the **Groups** resource with **Read** and **Write** permissions\n4. Select your group\n5. Copy the API key\n\n### 2. Set Environment Variables\n\n👉 Add ROBLOX_API_KEY here: https://www.val.town/x/jamesdopp/API/environment-variables?key=ROBLOX_API_KEY\n\n👉 Add ROBLOX_GROUP_ID here: https://www.val.town/x/jamesdopp/API/environment-variables?key=ROBLOX_GROUP_ID\n\n👉 Add API_SECRET here (optional, protects write endpoints): https://www.val.town/x/jamesdopp/API/environment-variables?key=API_SECRET\n\n### 3. Set Up Auto-Rank Schedule\n\nThe `auto-rank.ts` interval runs on a schedule. Configure it in the Val Town UI or via the interval settings.\n\n## API Reference\n\n### `GET /` — API Info\nReturns group details and available endpoints.\n\n### `GET /roles` — List Group Roles\nReturns all roles in your group with their IDs and names.\n\n### `GET /members` — List Group Members\nReturns all members with their user IDs, current roles, and join dates.\n\n### `POST /rank` — Manually Rank a User\n```json\n{\n \"userId\": \"123456789\",\n \"roleId\": \"role_id_from_/roles\"\n}\n```\n\n### `GET /rules` — List Ranking Rules\nReturns all configured auto-ranking rules.\n\n### `POST /rules` — Add a Ranking Rule\n```json\n{\n \"sourceRoleId\": \"current_role_id\",\n \"targetRoleId\": \"target_role_id\",\n \"minDaysInGroup\": 7\n}\n```\nThis means: *If a member has the source role and has been in the group for 7+ days, promote them to the target role.*\n\n### `DELETE /rules/:id` — Delete a Ranking Rule\n\n### `POST /auto-rank` — Trigger Auto-Ranking Manually\nRuns the auto-ranking engine immediately and returns results.\n\n### `GET /logs?limit=50` — View Ranking Logs\nReturns recent ranking actions.\n\n## How Auto-Ranking Works\n\n1. The interval fetches all group roles and members\n2. For each member, it checks enabled rules sorted by `minDaysInGroup` (highest first)\n3. If a member's current role matches a rule's source role AND they've been in the group long enough → they get promoted\n4. Every promotion is logged in SQLite\n\n## Example: Promote members after 7 days\n\n1. Call `GET /roles` to find your role IDs\n2. Call `POST /rules` with the \"Member\" role as source, \"Veteran\" role as target, and `minDaysInGroup: 7`\n3. The auto-rank interval will automatically promote eligible members\n\n## Architecture\n\n```\nmain.ts → HTTP API (Hono) — manual ranking, rules, logs\nauto-rank.ts → Interval — scheduled auto-promotion engine\nroblox.ts → Roblox Open Cloud API helper\ndb.ts → SQLite for rules & logs\n```\n",[180],"1ded1b5b-e3d8-40ff-bfe6-72a8ef4e5e06","untitled-folder-2059","75ce1d54-7aff-11f1-8c69-1607ee4eb77e",19,["D",1783537303679],"directory",[187],"pulls","branches","forks","envVars",{"_200":67,"_202":67},"connections",{"_200":67,"_201":67},"count","unfilledCount","emptyCount",{"_49":186,"_38":187,"_36":188,"_144":-5,"_47":48,"_46":189,"_146":129,"_44":229,"_13":67,"_39":191,"_41":-5,"_30":31,"_150":-5,"_211":230,"_33":231},{"_49":179,"_38":180,"_36":181,"_144":-5,"_47":48,"_46":182,"_146":129,"_44":226,"_13":67,"_39":26,"_41":184,"_30":31,"_150":-5,"_211":227,"_33":228},{"_49":173,"_38":174,"_36":175,"_144":-5,"_47":48,"_46":176,"_146":129,"_44":223,"_13":157,"_39":148,"_41":59,"_30":31,"_150":-5,"_211":224,"_33":225},{"_49":169,"_38":34,"_36":37,"_144":-5,"_47":48,"_46":14,"_146":129,"_44":220,"_13":171,"_39":40,"_41":43,"_30":31,"_150":-5,"_211":221,"_33":222},{"_49":161,"_38":162,"_36":163,"_144":-5,"_47":48,"_46":164,"_146":129,"_44":217,"_13":166,"_39":148,"_41":167,"_30":31,"_150":-5,"_211":218,"_33":219},{"_49":152,"_38":153,"_36":154,"_144":-5,"_47":48,"_46":155,"_146":129,"_44":214,"_13":157,"_39":158,"_41":159,"_30":31,"_150":-5,"_211":215,"_33":216},{"_49":141,"_38":142,"_36":143,"_144":-5,"_47":48,"_46":145,"_146":129,"_44":210,"_13":67,"_39":148,"_41":149,"_30":31,"_150":-5,"_211":212,"_33":213},["D",1783537135164],"children",[],[142],["D",1783537292204],[],[153],["D",1783537259759],[],[162],["D",1783537338139],[],[34],["D",1783537133284],[],[174],["D",1783537187096],[],[180],["D",1783537303679],[],[187],["D",1783536847583],["D",1789525245864],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_19":61,"_108":109,"_110":31},{"_13":14,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"ctx",{"_86":-5,"_131":270,"_271":272,"_273":274,"_275":31,"_276":31,"_277":31,"_278":129,"_279":-5,"_280":-7,"_281":-7,"_282":67,"_283":31,"_284":31,"_285":-5,"_286":31,"_287":31,"_288":31,"_289":-5},"ENV",{"_241":242,"_243":244,"_245":93,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269},"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"]

Diff · v24