[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_271":272,"_273":274},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_43":-7,"_166":-5,"_19":167,"_168":169,"_170":171,"_172":173,"_174":175,"_21":176,"_177":-5,"_178":-5,"_179":24,"_180":181,"_182":183,"_184":-5,"_185":-5,"_186":187},"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","main.ts","project",{"_37":114,"_13":14,"_41":115,"_116":-5,"_117":24,"_118":119,"_120":119,"_121":122,"_123":-5,"_30":70,"_124":-5,"_125":24,"_126":-5,"_127":-5,"_128":26,"_45":46,"_129":130,"_131":132,"_133":134,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_55":145,"_146":147,"_148":149,"_150":24},"file",{"_65":66,"_13":18,"_67":90,"_69":24,"_113":-5},"isDirectory",false,"page",0,"history",[31,32,33,34,35,36],"hasNext","userId",{"_37":106,"_39":40,"_41":107,"_43":108,"_45":46,"_47":99,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":109,"_21":110,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":111},{"_37":99,"_39":40,"_41":100,"_43":101,"_45":46,"_47":91,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":102,"_21":103,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":104},{"_37":91,"_39":40,"_41":92,"_43":93,"_45":46,"_47":94,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":95,"_21":96,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":97},{"_37":82,"_39":40,"_41":83,"_43":84,"_45":46,"_47":85,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":86,"_21":87,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":88},{"_37":73,"_39":40,"_41":74,"_43":75,"_45":46,"_47":76,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":78,"_21":79,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":80},{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":63},"id","5984e6aa-b803-4823-936c-6aa7bc7f44f3","branchId","5c50c4df-e0f6-49fa-84f9-c93ff13e6029","createdAt",["D",1783536847598],"version",1,"orgId","019f4314-02d8-77ea-9313-d14d6836317c","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":68,"_69":24},"pull","merge","revert","multiple","commits",[64],{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5},"fileId","65f5f01a-7afe-11f1-89ad-1607ee4eb77e","fileType","script","deleted","b42bc553-95d9-47f1-a393-d1ed4951b4f3","avatar","https://lh3.googleusercontent.com/a/ACg8ocK_aLMno0IvMp1g7wxRiXRCbJ02YXD0rhV6Dk3LInziBqlJHUs=s96-c","4691ef56-b1e2-46ce-920e-606eb8451af2",["D",1783537166716],10,"e3652a0d-3d19-425b-8e60-414a36c71b21","727a8254-875b-4466-bf6f-7080c475d9ed",{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":68,"_69":24},[81],{"_37":73,"_39":40,"_41":74,"_43":75,"_45":46,"_47":76,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":78,"_21":79,"_58":-5,"_59":-5,"_60":-5},"bb8b8d14-2f30-4849-99dd-546f79cc6adb",["D",1783537187090],12,"80ead51e-799a-4c79-9985-1d7174a05a2b",{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":90,"_69":24},[89],{"_37":82,"_39":40,"_41":83,"_43":84,"_45":46,"_47":85,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":86,"_21":87,"_58":-5,"_59":-5,"_60":-5},"http","a35314bd-2d6f-4455-89bf-e0a20debd831",["D",1783537268286],16,"9bed6927-7401-4cf6-9112-f2b316db65ab",{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":90,"_69":24},[98],{"_37":91,"_39":40,"_41":92,"_43":93,"_45":46,"_47":94,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":95,"_21":96,"_58":-5,"_59":-5,"_60":-5},"354d1681-80e0-4f73-bf33-f01a5c8dbfcf",["D",1783537274330],17,{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":90,"_69":24},[105],{"_37":99,"_39":40,"_41":100,"_43":101,"_45":46,"_47":91,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":102,"_21":103,"_58":-5,"_59":-5,"_60":-5},"960b1d95-d294-4f99-82f9-62b285d169ee",["D",1783537292204],18,{"_37":70,"_45":46,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":90,"_69":24},[112],{"_37":106,"_39":40,"_41":107,"_43":108,"_45":46,"_47":99,"_48":-5,"_49":77,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":109,"_21":110,"_58":-5,"_59":-5,"_60":-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,"_165":72},"org",{"_11":12,"_160":161,"_71":72,"_30":70,"_162":163,"_164":24},"branch",{"_43":151,"_13":16,"_37":40,"_152":114,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"isOwned",24,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","James Dopp","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":114,"_13":14,"_41":266,"_116":-5,"_117":24,"_118":119,"_120":119,"_121":122,"_123":-5,"_30":70,"_124":-5,"_125":24,"_126":-5,"_127":-5,"_128":26,"_45":46,"_129":130,"_131":132,"_133":267,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_55":268,"_146":269,"_148":270,"_150":24},"tree",[207,208,209,210,211,212,213],"files",[207,208,209,210,211,212,213],"counts",{"_197":26,"_198":44,"_199":26,"_200":201,"_202":203},"contents",[],{"_37":188,"_13":18,"_65":66,"_47":-5,"_39":40,"_189":108,"_190":183,"_41":191,"_43":192,"_67":90,"_193":194,"_69":24,"_195":-5,"_17":196},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},"879a3904-5932-42ea-8265-c69641d70f39","branchVersion","latest",["D",1783537292204],5,"content","/**\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","label",[18],"pulls","branches","forks","envVars",{"_204":26,"_206":26},"connections",{"_204":26,"_205":26},"count","unfilledCount","emptyCount",{"_37":258,"_13":259,"_65":260,"_47":-5,"_39":40,"_189":261,"_190":183,"_41":262,"_43":26,"_67":263,"_193":-5,"_69":24,"_195":-5,"_220":264,"_17":265},{"_37":250,"_13":251,"_65":252,"_47":-5,"_39":40,"_189":253,"_190":183,"_41":254,"_43":26,"_67":21,"_193":255,"_69":24,"_195":-5,"_220":256,"_17":257},{"_37":243,"_13":244,"_65":245,"_47":-5,"_39":40,"_189":246,"_190":183,"_41":247,"_43":192,"_67":68,"_193":122,"_69":24,"_195":-5,"_220":248,"_17":249},{"_37":234,"_13":235,"_65":236,"_47":-5,"_39":40,"_189":151,"_190":183,"_41":237,"_43":238,"_67":239,"_193":240,"_69":24,"_195":-5,"_220":241,"_17":242},{"_37":226,"_13":227,"_65":228,"_47":-5,"_39":40,"_189":229,"_190":183,"_41":230,"_43":44,"_67":68,"_193":231,"_69":24,"_195":-5,"_220":232,"_17":233},{"_37":188,"_13":18,"_65":66,"_47":-5,"_39":40,"_189":108,"_190":183,"_41":223,"_43":192,"_67":90,"_193":194,"_69":24,"_195":-5,"_220":224,"_17":225},{"_37":214,"_13":215,"_65":216,"_47":-5,"_39":40,"_189":217,"_190":183,"_41":218,"_43":26,"_67":68,"_193":219,"_69":24,"_195":-5,"_220":221,"_17":222},"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",[],[215],["D",1783537292204],[],[18],"26629907-9731-44b8-bd61-7ee6e1287f7d","db.ts","1162e25a-7aff-11f1-9db7-1607ee4eb77e",15,["D",1783537259759],"/**\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",[],[227],"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",[],[235],"7fe63f56-03f0-4bdd-a1d3-e4d849162b3e","RobloxAPI.js","aaeb0f66-7afe-11f1-bb1e-1607ee4eb77e",7,["D",1783537133284],[],[244],"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",[],[251],"1ded1b5b-e3d8-40ff-bfe6-72a8ef4e5e06","untitled-folder-2059","75ce1d54-7aff-11f1-8c69-1607ee4eb77e",19,["D",1783537303679],"directory",[],[259],["D",1783536847583],["D",1789525245864],{"_11":12,"_165":72},{"_11":12,"_160":161,"_71":72,"_30":70,"_162":163,"_164":24},{"_43":151,"_13":16,"_37":40,"_152":114,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"ctx",{"_55":-5,"_185":304,"_305":306,"_307":308,"_309":24,"_310":24,"_311":24,"_312":183,"_313":-5,"_314":-7,"_315":-7,"_316":26,"_317":24,"_318":24,"_319":-5,"_320":24,"_321":24,"_322":24,"_323":-5},"ENV",{"_275":276,"_277":278,"_279":16,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303},"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 · main.ts