[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_132":-5,"_19":133,"_134":135,"_136":137,"_138":139,"_140":141,"_21":142,"_143":-5,"_144":-5,"_145":24,"_146":147,"_148":149,"_150":-5,"_151":-5,"_152":153},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","jamesdopp","name","API","branchName","main","path","db.ts","project",{"_33":80,"_13":14,"_37":81,"_82":-5,"_83":24,"_84":85,"_86":85,"_87":88,"_89":-5,"_30":68,"_90":-5,"_91":24,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":100,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_53":111,"_112":113,"_114":115,"_116":24},"file",{"_63":64,"_13":18,"_65":66,"_67":24,"_79":-5},"isDirectory",false,"page",0,"history",[31,32],"hasNext","userId",{"_33":71,"_35":36,"_37":72,"_39":73,"_41":42,"_43":74,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":75,"_21":76,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":77},{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":61},"id","e3652a0d-3d19-425b-8e60-414a36c71b21","branchId","5c50c4df-e0f6-49fa-84f9-c93ff13e6029","createdAt",["D",1783537135165],"version",9,"orgId","019f4314-02d8-77ea-9313-d14d6836317c","parentId","76046938-c9b4-46f8-9f9d-b64084b44119","incomingCommitId","aiChatMessageId","727a8254-875b-4466-bf6f-7080c475d9ed","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_33":68,"_41":42,"_11":12,"_69":70},{"_63":64,"_13":18,"_65":66,"_67":24},"pull","merge","revert","multiple","commits",[62],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5},"fileId","1162e25a-7aff-11f1-9db7-1607ee4eb77e","fileType","script","deleted","b42bc553-95d9-47f1-a393-d1ed4951b4f3","avatar","https://lh3.googleusercontent.com/a/ACg8ocK_aLMno0IvMp1g7wxRiXRCbJ02YXD0rhV6Dk3LInziBqlJHUs=s96-c","9bed6927-7401-4cf6-9112-f2b316db65ab",["D",1783537259759],15,"965e82ba-e8c8-4157-a651-ddf7c70860c2",{"_33":68,"_41":42,"_11":12,"_69":70},{"_63":64,"_13":18,"_65":66,"_67":24},[78],{"_33":71,"_35":36,"_37":72,"_39":73,"_41":42,"_43":74,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":75,"_21":76,"_56":-5,"_57":-5,"_58":-5},"deletedAtVersion","a1134ee6-20ed-46b5-9387-13f9b22f6073",["D",1783536847583],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_131":70},"org",{"_11":12,"_126":127,"_69":70,"_30":68,"_128":129,"_130":24},"branch",{"_39":117,"_13":16,"_33":36,"_118":80,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"isOwned",24,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","James Dopp","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":80,"_13":14,"_37":234,"_82":-5,"_83":24,"_84":85,"_86":85,"_87":88,"_89":-5,"_30":68,"_90":-5,"_91":24,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":235,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_53":236,"_112":237,"_114":238,"_116":24},"tree",[173,174,175,176,177,178,179],"files",[173,174,175,176,177,178,179],"counts",{"_163":26,"_164":158,"_165":26,"_166":167,"_168":169},"contents",[],{"_33":154,"_13":18,"_63":64,"_43":-5,"_35":36,"_155":73,"_156":149,"_37":157,"_39":158,"_65":66,"_159":160,"_67":24,"_161":-5,"_17":162},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},"26629907-9731-44b8-bd61-7ee6e1287f7d","branchVersion","latest",["D",1783537259759],1,"content","/**\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","label",[18],"pulls","branches","forks","envVars",{"_170":26,"_172":26},"connections",{"_170":26,"_171":26},"count","unfilledCount","emptyCount",{"_33":226,"_13":227,"_63":228,"_43":-5,"_35":36,"_155":229,"_156":149,"_37":230,"_39":26,"_65":231,"_159":-5,"_67":24,"_161":-5,"_186":232,"_17":233},{"_33":218,"_13":219,"_63":220,"_43":-5,"_35":36,"_155":221,"_156":149,"_37":222,"_39":26,"_65":21,"_159":223,"_67":24,"_161":-5,"_186":224,"_17":225},{"_33":211,"_13":212,"_63":213,"_43":-5,"_35":36,"_155":214,"_156":149,"_37":215,"_39":194,"_65":66,"_159":88,"_67":24,"_161":-5,"_186":216,"_17":217},{"_33":202,"_13":203,"_63":204,"_43":-5,"_35":36,"_155":117,"_156":149,"_37":205,"_39":206,"_65":207,"_159":208,"_67":24,"_161":-5,"_186":209,"_17":210},{"_33":154,"_13":18,"_63":64,"_43":-5,"_35":36,"_155":73,"_156":149,"_37":199,"_39":158,"_65":66,"_159":160,"_67":24,"_161":-5,"_186":200,"_17":201},{"_33":189,"_13":190,"_63":191,"_43":-5,"_35":36,"_155":192,"_156":149,"_37":193,"_39":194,"_65":195,"_159":196,"_67":24,"_161":-5,"_186":197,"_17":198},{"_33":180,"_13":181,"_63":182,"_43":-5,"_35":36,"_155":183,"_156":149,"_37":184,"_39":26,"_65":66,"_159":185,"_67":24,"_161":-5,"_186":187,"_17":188},"de61dc92-7354-458e-8276-02ae345d4dec","roblox.ts","115c90ee-7aff-11f1-8bf2-1607ee4eb77e",8,["D",1783537135164],"/**\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","children",[],[181],"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",[],[190],["D",1783537259759],[],[18],"a7a1e772-3751-4ef6-8e45-c1a43097259a","auto-rank.ts","24338808-7aff-11f1-9065-1607ee4eb77e",["D",1783537338139],6,"interval","/**\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",[],[203],"7fe63f56-03f0-4bdd-a1d3-e4d849162b3e","RobloxAPI.js","aaeb0f66-7afe-11f1-bb1e-1607ee4eb77e",7,["D",1783537133284],[],[212],"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",[],[219],"1ded1b5b-e3d8-40ff-bfe6-72a8ef4e5e06","untitled-folder-2059","75ce1d54-7aff-11f1-8c69-1607ee4eb77e",19,["D",1783537303679],"directory",[],[227],["D",1783536847583],["D",1789525245864],{"_11":12,"_131":70},{"_11":12,"_126":127,"_69":70,"_30":68,"_128":129,"_130":24},{"_39":117,"_13":16,"_33":36,"_118":80,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_53":-5,"_151":272,"_273":274,"_275":276,"_277":24,"_278":24,"_279":24,"_280":149,"_281":-5,"_282":-7,"_283":-7,"_284":26,"_285":24,"_286":24,"_287":-5,"_288":24,"_289":24,"_290":24,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":16,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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"]

History · db.ts