[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","aurorinmagazine","name","one-hr-with-god","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/aurorinmagazine/one-hr-with-god/code/main.ts","extension","id","ded62ba8-e4bc-44d6-bbe3-53ae7c48c035","fileId","c05bab1a-a021-11f1-a445-1607ee4eb77e","parentId","branchId","fc770e11-97c3-42d1-b343-91b7a313d9e7","branchVersion",80,"latest",true,"createdAt",["D",1787722670886],"version",43,"fileType","http","content","import { page as appPage } from \"./app-ui-v2.ts\";\nimport { db, migrate } from \"./db.ts\";\n\nawait migrate();\n\nconst esc = (value: unknown) => String(value ?? \"\").replace(/[&<>\\\"']/g, c => ({\"&\":\"&\",\"<\":\"<\",\">\":\">\",'\\\"':\""\",\"'\":\"'\"}[c]!));\n\nconst page = `\n\n\n\n1Hr With God — A Digital Sanctuary\n\n

\n\n

A daily hour with God

Come as you are.
Leave closer.

A digital sanctuary for prayer, Scripture, worship, reflection, community and compassionate action. Start quietly. Stay as long as you need.

Your sacred rhythm60:00Prayer · Scripture · Worship · Reflection · Love

The journey

One hour. Five movements.

01 · Arrive

02 · Listen

03 · Speak

04 · Reflect

05 · Go in love

60:00

Be still. You do not have to perform here.

Inside 1Hr With God

◌

Audio Adventure Bible

Scripture journeys designed for listening, imagination and reflection.

◉

Live Altar

A moderated gathering place for prayer and worship.

♡

Prayer & Memory

Keep your story private, revisit it gently, and share only when you choose.

✦

SMILE

Carry formation outward through practical compassion and service.

The Mirror Principle

“The platform is a mirror, not a courtroom. It helps you see where you are without shame and take one faithful step toward God.”

Your spiritual story belongs to you. Consent comes before memory, sharing, AI assistance or pastoral access.

Scripture

Today’s invitation

“Be still, and know that I am God.”

Psalm 46:10

Community

Live Altar

Gather with others in a presence-first prayer space. Recording is never assumed.

Compassion

SMILE

Formation becomes love when it reaches another person.

Global Prayer Wall

You are not praying alone.

Loading prayers…

Cinematic Scripture

John 3:16

A Scripture reading will appear here.

Your story

Remembered, not tracked

Your returning experience is built around continuity you can control: saved memories, chosen needs, and formation rhythms.

Grace

Grace Coins · 0

Earned through formation-aligned participation. Never gambling. Never a paywall for God.

Formation

0 day rhythm

A private measure of consistency, not a public ranking.

\n\n\n\n\n`;\n\nasync function audit(action: string, entityType: string, entityId: string | null = null, metadata: unknown = {}) {\n await db.execute(\"INSERT INTO audit_events(id,actor_id,action,entity_type,entity_id,metadata) VALUES(?,?,?,?,?,?)\", [crypto.randomUUID(), null, action, entityType, entityId, JSON.stringify(metadata)]);\n}\n\n\nfunction cookieValue(req: Request, name: string) {\n const raw = req.headers.get(\"cookie\") || \"\";\n const part = raw.split(\";\").map(x => x.trim()).find(x => x.startsWith(name + \"=\"));\n return part ? decodeURIComponent(part.slice(name.length + 1)) : null;\n}\n\nasync function ensureUser(req: Request, seed: Record = {}) {\n let id = cookieValue(req, \"owg_uid\");\n if (id) {\n await db.execute(\"UPDATE users SET last_seen_at=CURRENT_TIMESTAMP WHERE id=?\", [id]);\n return { id, isNew: false };\n }\n id = crypto.randomUUID();\n await db.execute(\"INSERT INTO users(id,anonymous,current_need,preferred_minutes) VALUES(?,?,?,?)\", [\n id, 1, typeof seed.currentNeed === \"string\" ? seed.currentNeed : null,\n Number.isFinite(Number(seed.preferredMinutes)) ? Number(seed.preferredMinutes) : 60,\n ]);\n return { id, isNew: true };\n}\n\nfunction sessionCookie(userId: string) {\n return `owg_uid=${encodeURIComponent(userId)}; Path=/; Max-Age=31536000; SameSite=Lax; Secure`;\n}\n\nasync function auditFor(actorId: string | null, action: string, entityType: string, entityId: string | null = null, metadata: unknown = {}) {\n await db.execute(\"INSERT INTO audit_events(id,actor_id,action,entity_type,entity_id,metadata) VALUES(?,?,?,?,?,?)\", [crypto.randomUUID(), actorId, action, entityType, entityId, JSON.stringify(metadata)]);\n}\n\nexport default async function(req: Request) {\n const u = new URL(req.url);\n if (req.method === \"GET\" && u.pathname === \"/\") return new Response(appPage, { headers: { \"content-type\": \"text/html; charset=utf-8\", \"cache-control\": \"no-store\", \"x-app-version\":\"one-hr-with-god-global\" } });\n if (req.method === \"POST\" && u.pathname === \"/api/ai/guard\") {\n const user=await ensureUser(req); const b=await req.json().catch(()=>({})); const prompt=String(b.prompt||\"\").trim().slice(0,4000);\n if(!prompt)return Response.json({ok:false,error:\"Prompt required\"},{status:400});\n const blocked=/(you are god|god told me|pretend to be (jesus|god)|prophet|diagnose me|replace my doctor|replace my pastor|self[- ]harm|suicide|kill myself)/i.test(prompt);\n const action=blocked?\"escalate\":\"reflect\";\n await auditFor(user.id,\"ai.guard.checked\",\"ai\",null,{action,blocked});\n return Response.json({ok:true,action,allowed:!blocked,boundary:blocked?\"Human support is required for this request. AI does not claim divine, pastoral, medical, or emergency authority.\":\"AI may help with reflection, journaling, Scripture study, and practical next steps without presenting itself as spiritual authority.\"});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/health\") return Response.json({ ok:true, name:\"1Hr With God\", version:\"foundation-v2\", modules:[\"identity\",\"sessions\",\"memory\",\"prayer\",\"circles\",\"live-altar\",\"consent\",\"formation\",\"smile\",\"wallet\",\"audit\"] });\n\n if (req.method === \"GET\" && u.pathname === \"/api/me\") {\n const user = await ensureUser(req);\n const r = await db.execute(\"SELECT id,display_name,current_need,preferred_minutes,created_at,last_seen_at FROM users WHERE id=?\", [user.id]);\n const c = await db.execute(\"SELECT memory,transcript,sharing,ai,notifications FROM consent_preferences WHERE user_id=?\", [user.id]);\n return new Response(JSON.stringify({ ok:true, user:r.rows[0] || null, consent:c.rows[0] || {memory:0,transcript:0,sharing:0,ai:0,notifications:0} }), { headers:{\"content-type\":\"application/json\",\"set-cookie\":sessionCookie(user.id)} });\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/onboarding\") {\n const b = await req.json().catch(()=>({}));\n const user = await ensureUser(req, b);\n await db.execute(\"UPDATE users SET display_name=?,current_need=?,preferred_minutes=?,last_seen_at=CURRENT_TIMESTAMP WHERE id=?\", [b.displayName || null, b.currentNeed || null, Number(b.preferredMinutes) || 60, user.id]);\n await db.execute(\"INSERT INTO consent_preferences(user_id,memory,transcript,sharing,ai,notifications) VALUES(?,?,?,?,?,?) ON CONFLICT(user_id) DO UPDATE SET memory=excluded.memory, transcript=excluded.transcript, sharing=excluded.sharing, ai=excluded.ai, notifications=excluded.notifications, updated_at=CURRENT_TIMESTAMP\", [user.id,b.memory?1:0,b.transcript?1:0,b.sharing?1:0,b.ai?1:0,b.notifications?1:0]);\n await db.execute(\"INSERT INTO analytics_events(id,user_id,event_name,path,source,metadata) VALUES(?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"onboarding_completed\",\"/\",\"onboarding\",JSON.stringify({currentNeed:b.currentNeed||null,preferredMinutes:Number(b.preferredMinutes)||60})]);\n await auditFor(user.id,\"onboarding.completed\",\"user\",user.id,{currentNeed:b.currentNeed || null});\n return new Response(JSON.stringify({ok:true,userId:user.id}), {headers:{\"content-type\":\"application/json\",\"set-cookie\":sessionCookie(user.id)}});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/session\") {\n const b = await req.json().catch(()=>({}));\n const user = await ensureUser(req);\n const id=crypto.randomUUID();\n await db.execute(\"INSERT INTO sessions(id,user_id,mode) VALUES(?,?,?)\",[id,user.id,b.mode||\"60-minute\"]);\n await auditFor(user.id,\"session.started\",\"session\",id,{mode:b.mode||\"60-minute\"});\n return new Response(JSON.stringify({ok:true,sessionId:id,message:\"Your hour has begun.\"}), {headers:{\"content-type\":\"application/json\",\"set-cookie\":sessionCookie(user.id)}});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/session/complete\") {\n const b = await req.json().catch(()=>({})); const user = await ensureUser(req);\n const minutes=Math.max(0,Math.min(180,Number(b.minutes)||60));\n if(!b.sessionId) return Response.json({ok:false,error:\"sessionId required\"},{status:400});\n const owned=await db.execute(\"SELECT id FROM sessions WHERE id=? AND user_id=?\",[b.sessionId,user.id]);\n if(!owned.rows.length) return Response.json({ok:false,error:\"Session not found\"},{status:404});\n await db.execute(\"UPDATE sessions SET completed_at=CURRENT_TIMESTAMP,minutes=?,completed=1,current_step=4 WHERE id=? AND user_id=?\",[minutes,b.sessionId,user.id]);\n const day=new Date().toISOString().slice(0,10);\n await db.execute(\"INSERT INTO formation_daily(user_id,day,minutes,session_count,completed_hour) VALUES(?,?,?,?,?) ON CONFLICT(user_id,day) DO UPDATE SET minutes=minutes+excluded.minutes,session_count=session_count+1,completed_hour=completed_hour+excluded.completed_hour\",[user.id,day,minutes,1,minutes>=60?1:0]);\n const ledgerId=crypto.randomUUID();\n if(minutes>=60) await db.execute(\"INSERT INTO wallet_ledger(id,user_id,kind,amount,currency,reference_type,reference_id,metadata) VALUES(?,?,?,?,?,?,?,?)\",[ledgerId,user.id,\"hour-completion\",1,\"GRACE\",\"session\",b.sessionId,JSON.stringify({formation:true})]);\n await auditFor(user.id,\"session.completed\",\"session\",b.sessionId,{minutes});\n return Response.json({ok:true,minutes,completedHour:minutes>=60,graceCoinAwarded:minutes>=60});\n }\n\n if (req.method === \"PATCH\" && u.pathname.match(/^\\/api\\/session\\/[^/]+\\/step$/)) {\n const sessionId=u.pathname.split(\"/\")[3]; const b=await req.json().catch(()=>({})); const user=await ensureUser(req);\n const currentStep=Math.max(0,Math.min(4,Number(b.step)||0));\n const r=await db.execute(\"UPDATE sessions SET current_step=? WHERE id=? AND user_id=? AND completed=0\",[currentStep,sessionId,user.id]);\n if(!r.rowsAffected) return Response.json({ok:false,error:\"Session not found\"},{status:404});\n await auditFor(user.id,\"session.step.updated\",\"session\",sessionId,{currentStep});\n return Response.json({ok:true,sessionId,currentStep});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/sessions\") {\n const user=await ensureUser(req);\n const rows=await db.execute(\"SELECT id,mode,started_at,completed_at,minutes,completed,current_step FROM sessions WHERE user_id=? ORDER BY started_at DESC LIMIT 50\",[user.id]);\n return Response.json({ok:true,sessions:rows.rows});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/journey\") {\n const user=await ensureUser(req);\n const sessions=await db.execute(\"SELECT id,mode,started_at,completed_at,minutes,completed,current_step FROM sessions WHERE user_id=? ORDER BY started_at DESC LIMIT 30\",[user.id]);\n const memories=await db.execute(\"SELECT id,session_id,kind,body,visibility,created_at FROM memories WHERE user_id=? ORDER BY created_at DESC LIMIT 20\",[user.id]);\n const formation=await db.execute(\"SELECT day,minutes,session_count,completed_hour FROM formation_daily WHERE user_id=? ORDER BY day DESC LIMIT 30\",[user.id]);\n const wallet=await db.execute(\"SELECT COALESCE(SUM(amount),0) AS balance FROM wallet_ledger WHERE user_id=?\",[user.id]);\n return Response.json({ok:true,userId:user.id,sessions:sessions.rows,memories:memories.rows,formation:formation.rows,balance:Number((wallet.rows[0] as any)?.balance||0)});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/formation\") {\n const user = await ensureUser(req);\n const rows = await db.execute(\"SELECT day,minutes,session_count,completed_hour FROM formation_daily WHERE user_id=? ORDER BY day DESC LIMIT 365\",[user.id]);\n let streak=0, cursor=new Date();\n for(const row of rows.rows as any[]){ const day=String(row.day); const expected=cursor.toISOString().slice(0,10); if(day!==expected && streak===0) { cursor.setUTCDate(cursor.getUTCDate()-1); if(day!==cursor.toISOString().slice(0,10)) break; } if(Number(row.session_count)>0){streak++;cursor.setUTCDate(cursor.getUTCDate()-1);} else break; }\n return Response.json({ok:true,streak,days:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/memories\") {\n const b=await req.json().catch(()=>({})); if(!b.body)return Response.json({ok:false,error:\"Reflection required\"},{status:400});\n const user=await ensureUser(req); const id=crypto.randomUUID();\n const consent=await db.execute(\"SELECT memory FROM consent_preferences WHERE user_id=?\",[user.id]);\n if(!Number((consent.rows[0] as any)?.memory)) return Response.json({ok:false,error:\"Memory consent required\"},{status:403});\n await db.execute(\"INSERT INTO memories(id,user_id,session_id,kind,body,visibility) VALUES(?,?,?,?,?,?)\",[id,user.id,b.sessionId||null,b.kind||\"reflection\",b.body,\"private\"]);\n await auditFor(user.id,\"memory.created\",\"memory\",id,{visibility:\"private\"});\n return Response.json({ok:true,memoryId:id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/memories\") {\n const user=await ensureUser(req); const rows=await db.execute(\"SELECT id,session_id,kind,title,body,tags,pinned,archived,visibility,created_at FROM memories WHERE user_id=? AND archived=0 ORDER BY pinned DESC, created_at DESC LIMIT 100\",[user.id]);\n return Response.json({ok:true,memories:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/consent\") {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req);\n await db.execute(\"INSERT INTO consent_preferences(user_id,memory,transcript,sharing,ai,notifications) VALUES(?,?,?,?,?,?) ON CONFLICT(user_id) DO UPDATE SET memory=excluded.memory,transcript=excluded.transcript,sharing=excluded.sharing,ai=excluded.ai,notifications=excluded.notifications,updated_at=CURRENT_TIMESTAMP\",[user.id,b.memory?1:0,b.transcript?1:0,b.sharing?1:0,b.ai?1:0,b.notifications?1:0]);\n await auditFor(user.id,\"consent.updated\",\"consent\",user.id,{memory:!!b.memory,ai:!!b.ai,sharing:!!b.sharing});\n return new Response(JSON.stringify({ok:true,userId:user.id}), {headers:{\"content-type\":\"application/json\",\"set-cookie\":sessionCookie(user.id)}});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/prayers\") {\n const b=await req.json().catch(()=>({})); if(!b.body)return Response.json({ok:false,error:\"Prayer required\"},{status:400});\n const user=await ensureUser(req); const visibility=b.visibility===\"public\"?\"public\":\"private\"; const id=crypto.randomUUID();\n if(visibility===\"public\") { const c=await db.execute(\"SELECT sharing FROM consent_preferences WHERE user_id=?\",[user.id]); if(!Number((c.rows[0] as any)?.sharing)) return Response.json({ok:false,error:\"Sharing consent required\"},{status:403}); }\n await db.execute(\"INSERT INTO prayer_requests(id,user_id,body,visibility) VALUES(?,?,?,?)\",[id,user.id,b.body,visibility]); await auditFor(user.id,\"prayer.created\",\"prayer\",id,{visibility}); return Response.json({ok:true,prayerId:id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/prayers\") {\n const rows=await db.execute(\"SELECT id,body,answered,spark_count,created_at FROM prayer_requests WHERE visibility='public' ORDER BY created_at DESC LIMIT 100\");\n return Response.json({ok:true,prayers:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.startsWith(\"/api/prayers/\") && u.pathname.endsWith(\"/spark\")) {\n const prayerId=u.pathname.split(\"/\")[3]; const user=await ensureUser(req); const id=crypto.randomUUID();\n try { await db.execute(\"INSERT INTO prayer_sparks(id,prayer_id,user_id) VALUES(?,?,?)\",[id,prayerId,user.id]); await db.execute(\"UPDATE prayer_requests SET spark_count=spark_count+1 WHERE id=?\",[prayerId]); } catch (_) { return Response.json({ok:false,error:\"Already sparked\"},{status:409}); }\n await db.execute(\"INSERT INTO wallet_ledger(id,user_id,kind,amount,currency,reference_type,reference_id) VALUES(?,?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"prayer-spark\",5,\"GRACE\",\"prayer\",prayerId]); await auditFor(user.id,\"prayer.sparked\",\"prayer\",prayerId); return Response.json({ok:true,award:5});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/testimonies\") {\n const b=await req.json().catch(()=>({})); if(!b.body)return Response.json({ok:false,error:\"Testimony required\"},{status:400}); const user=await ensureUser(req); const id=crypto.randomUUID();\n await db.execute(\"INSERT INTO testimonies(id,user_id,type,body,visibility,moderation_status) VALUES(?,?,?,?,?,?)\",[id,user.id,b.type||\"testimony\",b.body,b.visibility===\"public\"?\"public\":\"private\",b.visibility===\"public\"?\"pending\":\"private\"]); await auditFor(user.id,\"testimony.created\",\"testimony\",id,{visibility:b.visibility||\"private\"}); return Response.json({ok:true,testimonyId:id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/testimonies\") {\n const rows=await db.execute(\"SELECT id,type,body,created_at FROM testimonies WHERE visibility='public' AND moderation_status='approved' ORDER BY created_at DESC LIMIT 100\"); return Response.json({ok:true,testimonies:rows.rows});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/bible\") {\n const reference = u.searchParams.get(\"reference\") || \"John 3:16\";\n const response = await fetch(\"https://bible-api.com/\" + encodeURIComponent(reference));\n if (!response.ok) return Response.json({ok:false,error:\"Scripture service unavailable\"},{status:502});\n const data = await response.json();\n return Response.json({ok:true,reference:data.reference,text:data.text,translation:data.translation_name || data.translation_id || null});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/events\") {\n const rows=await db.execute(\"SELECT id,title,description,starts_at,status,recording_consent_required FROM live_events WHERE status IN ('scheduled','live') ORDER BY starts_at ASC LIMIT 50\"); return Response.json({ok:true,events:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/circles\") {\n const b=await req.json().catch(()=>({})); if(!b.name)return Response.json({ok:false,error:\"Circle name required\"},{status:400});\n const user=await ensureUser(req); const id=crypto.randomUUID();\n await db.execute(\"INSERT INTO prayer_circles(id,name,description,visibility,created_by) VALUES(?,?,?,?,?)\",[id,b.name,b.description||null,\"invite-only\",user.id]);\n await db.execute(\"INSERT INTO circle_members(circle_id,user_id,role) VALUES(?,?,?)\",[id,user.id,\"facilitator\"]);\n await auditFor(user.id,\"circle.created\",\"prayer_circle\",id); return Response.json({ok:true,circleId:id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/circles\") {\n const user=await ensureUser(req);\n const rows=await db.execute(\"SELECT c.id,c.name,c.description,c.visibility,COUNT(m.user_id) AS member_count FROM prayer_circles c LEFT JOIN circle_members m ON m.circle_id=c.id WHERE c.visibility='invite-only' GROUP BY c.id ORDER BY c.created_at DESC LIMIT 100\");\n return Response.json({ok:true,circles:rows.rows,userId:user.id});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/circles\\/[^/]+\\/join$/)) {\n const circleId=u.pathname.split(\"/\")[3]; const user=await ensureUser(req);\n await db.execute(\"INSERT INTO circle_members(circle_id,user_id,role) VALUES(?,?,?) ON CONFLICT(circle_id,user_id) DO NOTHING\",[circleId,user.id,\"member\"]);\n await auditFor(user.id,\"circle.joined\",\"prayer_circle\",circleId); return Response.json({ok:true,circleId});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/circles/mine\") {\n const user=await ensureUser(req); const rows=await db.execute(\"SELECT c.id,c.name,c.description,m.role,m.created_at FROM circle_members m JOIN prayer_circles c ON c.id=m.circle_id WHERE m.user_id=? ORDER BY m.created_at DESC\",[user.id]); return Response.json({ok:true,circles:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/events\\/[^/]+\\/join$/)) {\n const eventId=u.pathname.split(\"/\")[3]; const user=await ensureUser(req); const event=await db.execute(\"SELECT id,status,recording_consent_required FROM live_events WHERE id=? AND status IN ('scheduled','live')\",[eventId]);\n if(!event.rows.length)return Response.json({ok:false,error:\"Live gathering not available\"},{status:404});\n await db.execute(\"INSERT INTO live_event_attendance(event_id,user_id) VALUES(?,?) ON CONFLICT(event_id,user_id) DO UPDATE SET joined_at=CURRENT_TIMESTAMP\",[eventId,user.id]); await auditFor(user.id,\"live_event.joined\",\"live_event\",eventId,{recordingConsentRequired:!!(event.rows[0] as any).recording_consent_required}); return Response.json({ok:true,eventId,recordingConsentRequired:!!(event.rows[0] as any).recording_consent_required});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/reports$/)) {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req); const entityType=String(b.entityType||\"\").slice(0,40); const entityId=String(b.entityId||\"\").slice(0,100); const reason=String(b.reason||\"\").trim().slice(0,500);\n if(!entityType||!entityId||!reason)return Response.json({ok:false,error:\"entityType, entityId and reason required\"},{status:400});\n const id=crypto.randomUUID(); await db.execute(\"INSERT INTO moderation_reports(id,reporter_id,entity_type,entity_id,reason) VALUES(?,?,?,?,?)\",[id,user.id,entityType,entityId,reason]); await auditFor(user.id,\"moderation.report.created\",entityType,entityId,{reportId:id}); return Response.json({ok:true,reportId:id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/moderation/reports\") {\n if(!Deno.env.get(\"ONE_HR_ADMIN_KEY\") || req.headers.get(\"x-admin-key\")!==Deno.env.get(\"ONE_HR_ADMIN_KEY\"))return Response.json({ok:false,error:\"Admin authorization required\"},{status:401});\n const rows=await db.execute(\"SELECT id,reporter_id,entity_type,entity_id,reason,status,created_at,resolved_at FROM moderation_reports WHERE status='open' ORDER BY created_at ASC LIMIT 200\"); return Response.json({ok:true,reports:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/moderation\\/[^/]+$/)) {\n if(!Deno.env.get(\"ONE_HR_ADMIN_KEY\") || req.headers.get(\"x-admin-key\")!==Deno.env.get(\"ONE_HR_ADMIN_KEY\"))return Response.json({ok:false,error:\"Admin authorization required\"},{status:401});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/prayer-rooms\") {\n const user=await ensureUser(req);\n const rows=await db.execute(\"SELECT r.id,r.name,r.description,r.room_type,r.visibility,COUNT(m.user_id) AS member_count,EXISTS(SELECT 1 FROM prayer_room_members me WHERE me.room_id=r.id AND me.user_id=?) AS joined FROM prayer_rooms r LEFT JOIN prayer_room_members m ON m.room_id=r.id WHERE r.visibility='public' GROUP BY r.id ORDER BY r.created_at DESC\",[user.id]);\n return Response.json({ok:true,rooms:rows.rows});\n }\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/prayer-rooms\\/[^/]+\\/join$/)) {\n const roomId=u.pathname.split(\"/\")[3]; const user=await ensureUser(req);\n await db.execute(\"INSERT INTO prayer_room_members(room_id,user_id,role) VALUES(?,?,?) ON CONFLICT(room_id,user_id) DO NOTHING\",[roomId,user.id,\"member\"]);\n await auditFor(user.id,\"prayer_room.joined\",\"prayer_room\",roomId); return Response.json({ok:true,roomId});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/devotionals\") {\n const rows=await db.execute(\"SELECT id,title,body,scripture_reference,theme,created_at FROM devotionals WHERE published=1 ORDER BY created_at DESC LIMIT 30\"); return Response.json({ok:true,devotionals:rows.rows});\n }\n if (req.method === \"POST\" && u.pathname === \"/api/bible-session\") {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req); const reference=String(b.reference||\"John 3:16\").slice(0,120); const minutes=Math.max(0,Math.min(180,Number(b.minutes)||0));\n const id=crypto.randomUUID(); await db.execute(\"INSERT INTO bible_reading_sessions(id,user_id,reference,minutes,completed) VALUES(?,?,?,?,?)\",[id,user.id,reference,minutes,minutes>=10?1:0]);\n if(minutes>=10) await db.execute(\"INSERT INTO wallet_ledger(id,user_id,kind,amount,currency,reference_type,reference_id,metadata) VALUES(?,?,?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"bible-reading\",5,\"GRACE\",\"bible_reading_session\",id,JSON.stringify({formation:true})]);\n await auditFor(user.id,\"bible_session.completed\",\"bible_reading_session\",id,{reference,minutes}); return Response.json({ok:true,id,reference,minutes,completed:minutes>=10,graceCoinAwarded:minutes>=10?5:0});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/bible-games\") {\n const rows=await db.execute(\"SELECT id,title,description,question,option_a,option_b,option_c,reward FROM bible_games WHERE active=1 ORDER BY created_at DESC LIMIT 20\"); return Response.json({ok:true,games:rows.rows});\n }\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/bible-games\\/[^/]+\\/answer$/)) {\n const gameId=u.pathname.split(\"/\")[3]; const b=await req.json().catch(()=>({})); const answer=String(b.answer||\"\").slice(0,1); const user=await ensureUser(req);\n const g=await db.execute(\"SELECT correct_option,reward FROM bible_games WHERE id=? AND active=1\",[gameId]); if(!g.rows.length)return Response.json({ok:false,error:\"Game unavailable\"},{status:404});\n const correct=answer===String((g.rows[0] as any).correct_option); const reward=correct?Number((g.rows[0] as any).reward||0):0;\n await db.execute(\"INSERT INTO game_scores(id,user_id,game_id,correct,reward) VALUES(?,?,?,?,?) ON CONFLICT(user_id,game_id) DO UPDATE SET correct=excluded.correct,reward=excluded.reward,created_at=CURRENT_TIMESTAMP\",[crypto.randomUUID(),user.id,gameId,correct?1:0,reward]);\n if(reward) await db.execute(\"INSERT INTO wallet_ledger(id,user_id,kind,amount,currency,reference_type,reference_id) VALUES(?,?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"bible-game\",reward,\"GRACE\",\"bible_game\",gameId]);\n await auditFor(user.id,\"bible_game.answered\",\"bible_game\",gameId,{correct,reward}); return Response.json({ok:true,correct,reward});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/leaderboard\") {\n const rows=await db.execute(\"SELECT u.id,COALESCE(NULLIF(u.display_name,''),'Believer') AS display_name,COALESCE(SUM(w.amount),0) AS grace,COALESCE(SUM(f.session_count),0) AS sessions FROM users u LEFT JOIN wallet_ledger w ON w.user_id=u.id LEFT JOIN formation_daily f ON f.user_id=u.id GROUP BY u.id ORDER BY sessions DESC,grace DESC LIMIT 20\"); return Response.json({ok:true,leaderboard:rows.rows});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/treasury\") {\n const rows=await db.execute(\"SELECT id,entry_type,category,amount,currency,description,verified,created_at FROM treasury_entries ORDER BY created_at DESC LIMIT 100\");\n const totals=await db.execute(\"SELECT currency,SUM(CASE WHEN entry_type IN ('income','reserve') THEN amount ELSE -amount END) AS net FROM treasury_entries GROUP BY currency\");\n return Response.json({ok:true,entries:rows.rows,totals:totals.rows,principle:\"Verified entries only. The platform does not invent or imply funds.\"});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/ambient\") {\n const rows=await db.execute(\"SELECT id,name,kind,url,duration_seconds FROM ambient_tracks WHERE active=1 ORDER BY name ASC\"); return Response.json({ok:true,tracks:rows.rows});\n }\n if (req.method === \"POST\" && u.pathname === \"/api/social-share\") {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req); const target=String(b.target||\"\").slice(0,40); const entity=String(b.entity||\"\").slice(0,120);\n await auditFor(user.id,\"social.share.initiated\",\"share\",entity,{target}); return Response.json({ok:true,target,entity});\n }\n\n\n if (req.method === \"GET\" && u.pathname === \"/api/smile/projects\") {\n const rows=await db.execute(\"SELECT id,name,description,goal_amount,raised_amount,status,created_at FROM smile_projects WHERE status='active' ORDER BY created_at DESC\"); return Response.json({ok:true,projects:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/smile\\/projects\\/[^/]+\\/pledge$/)) {\n const projectId=u.pathname.split(\"/\")[4]; const b=await req.json().catch(()=>({})); const user=await ensureUser(req); const amount=Math.max(1,Math.min(1000000,Number(b.amount)||0));\n if(!amount)return Response.json({ok:false,error:\"Valid amount required\"},{status:400});\n const project=await db.execute(\"SELECT id,status FROM smile_projects WHERE id=? AND status='active'\",[projectId]); if(!project.rows.length)return Response.json({ok:false,error:\"SMILE project unavailable\"},{status:404});\n const id=crypto.randomUUID(); await db.execute(\"INSERT INTO smile_pledges(id,project_id,user_id,amount,currency,status,created_at) VALUES(?,?,?,?,?,?,CURRENT_TIMESTAMP)\",[id,projectId,user.id,amount,\"GRACE\",\"pledged\"]); await auditFor(user.id,\"smile.pledge.created\",\"smile_project\",projectId,{pledgeId:id,amount}); return Response.json({ok:true,pledgeId:id,amount,status:\"pledged\"});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/smile/mine\") {\n const user=await ensureUser(req); const rows=await db.execute(\"SELECT p.id,p.project_id,p.amount,p.currency,p.status,p.created_at,s.name AS project_name FROM smile_pledges p JOIN smile_projects s ON s.id=p.project_id WHERE p.user_id=? ORDER BY p.created_at DESC LIMIT 100\",[user.id]); return Response.json({ok:true,pledges:rows.rows});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/wallet\") {\n const user=await ensureUser(req); const rows=await db.execute(\"SELECT kind,amount,currency,reference_type,reference_id,created_at FROM wallet_ledger WHERE user_id=? ORDER BY created_at DESC LIMIT 200\",[user.id]); const balance=rows.rows.reduce((s:any,r:any)=>s+Number(r.amount||0),0); return Response.json({ok:true,balance,entries:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/ai/guide\") {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req);\n const consent=await db.execute(\"SELECT ai FROM consent_preferences WHERE user_id=?\",[user.id]);\n if(!Number((consent.rows[0] as any)?.ai)) return Response.json({ok:false,error:\"AI consent required\"},{status:403});\n const question=String(b.question||\"\").trim().slice(0,4000); if(!question)return Response.json({ok:false,error:\"Question required\"},{status:400});\n const sensitive=/(suicide|kill myself|self[- ]harm|replace my doctor|medical emergency|you are god|god told me|pretend to be jesus|prophet|replace my pastor)/i.test(question);\n const answer=sensitive?\"This needs human care rather than AI authority. Please reach out to a trusted person, qualified professional, pastor or appropriate emergency service. I can still help you prepare what you want to say to them.\":\"I’m here to help you reflect, explore Scripture, journal, and prepare a practical next step. I am an AI assistant, not God, a pastor, prophet, doctor, therapist, or spiritual authority.\";\n await auditFor(user.id,\"ai.guide.requested\",\"ai_conversation\",null,{questionLength:question.length,sensitive});\n return Response.json({ok:true,labeled:true,answer,requiresHumanForPastoralDecision:true,escalate:sensitive});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/moderation/queue\") {\n if(!Deno.env.get(\"ONE_HR_ADMIN_KEY\") || req.headers.get(\"x-admin-key\")!==Deno.env.get(\"ONE_HR_ADMIN_KEY\"))return Response.json({ok:false,error:\"Admin authorization required\"},{status:401});\n const rows=await db.execute(\"SELECT id,type,body,visibility,moderation_status,created_at FROM testimonies WHERE moderation_status='pending' ORDER BY created_at ASC LIMIT 100\"); return Response.json({ok:true,items:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/moderation\\/[^/]+$/)) {\n if(!Deno.env.get(\"ONE_HR_ADMIN_KEY\") || req.headers.get(\"x-admin-key\")!==Deno.env.get(\"ONE_HR_ADMIN_KEY\"))return Response.json({ok:false,error:\"Admin authorization required\"},{status:401});\n const id=u.pathname.split(\"/\")[3]; const b=await req.json().catch(()=>({})); const action=String(b.action||\"\");\n if(![\"approve\",\"reject\"].includes(action)) return Response.json({ok:false,error:\"Invalid moderation action\"},{status:400});\n await db.execute(\"UPDATE testimonies SET moderation_status=? WHERE id=?\",[action===\"approve\"?\"approved\":\"rejected\",id]); await audit(\"moderation.action\",\"testimony\",id,{action}); return Response.json({ok:true,id,action});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/journey\") {\n const user=await ensureUser(req);\n const [sessions,memories,formation,wallet,consent]=await Promise.all([\n db.execute(\"SELECT id,mode,started_at,completed_at,minutes,completed,current_step FROM sessions WHERE user_id=? ORDER BY started_at DESC LIMIT 30\",[user.id]),\n db.execute(\"SELECT id,session_id,kind,title,body,tags,pinned,archived,created_at FROM memories WHERE user_id=? ORDER BY pinned DESC,created_at DESC LIMIT 50\",[user.id]),\n db.execute(\"SELECT day,minutes,session_count,completed_hour FROM formation_daily WHERE user_id=? ORDER BY day DESC LIMIT 30\",[user.id]),\n db.execute(\"SELECT COALESCE(SUM(amount),0) AS balance FROM wallet_ledger WHERE user_id=?\",[user.id]),\n db.execute(\"SELECT memory,transcript,sharing,ai,notifications FROM consent_preferences WHERE user_id=?\",[user.id])\n ]);\n return Response.json({ok:true,userId:user.id,sessions:sessions.rows,memories:memories.rows,formation:formation.rows,balance:Number((wallet.rows[0] as any)?.balance||0),consent:consent.rows[0]||{memory:0,transcript:0,sharing:0,ai:0,notifications:0}});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/memories/export\") {\n const user=await ensureUser(req); const consent=await db.execute(\"SELECT memory FROM consent_preferences WHERE user_id=?\",[user.id]);\n if(!Number((consent.rows[0] as any)?.memory)) return Response.json({ok:false,error:\"Memory consent required\"},{status:403});\n const rows=await db.execute(\"SELECT id,session_id,kind,title,body,tags,pinned,archived,visibility,created_at FROM memories WHERE user_id=? ORDER BY created_at ASC\",[user.id]);\n await auditFor(user.id,\"memory.exported\",\"memory\",null,{count:rows.rows.length});\n return new Response(JSON.stringify({exportedAt:new Date().toISOString(),userId:user.id,memories:rows.rows},null,2),{headers:{\"content-type\":\"application/json\",\"content-disposition\":\"attachment; filename=one-hr-with-god-memory.json\"}});\n }\n\n if (req.method === \"PATCH\" && u.pathname.match(/^\\/api\\/memories\\/[^/]+$/)) {\n const id=u.pathname.split(\"/\")[3]; const b=await req.json().catch(()=>({})); const user=await ensureUser(req);\n const exists=await db.execute(\"SELECT id FROM memories WHERE id=? AND user_id=?\",[id,user.id]);\n if(!exists.rows.length) return Response.json({ok:false,error:\"Memory not found\"},{status:404});\n await db.execute(\"UPDATE memories SET title=COALESCE(?,title),tags=COALESCE(?,tags),pinned=COALESCE(?,pinned),archived=COALESCE(?,archived) WHERE id=? AND user_id=?\",[b.title===undefined?null:String(b.title||\"\").slice(0,160),b.tags===undefined?null:String(b.tags||\"\").slice(0,500),b.pinned===undefined?null:(b.pinned?1:0),b.archived===undefined?null:(b.archived?1:0),id,user.id]);\n await auditFor(user.id,\"memory.updated\",\"memory\",id,{pinned:!!b.pinned,archived:!!b.archived}); return Response.json({ok:true,id});\n }\n\n if (req.method === \"DELETE\" && u.pathname.match(/^\\/api\\/memories\\/[^/]+$/)) {\n const id=u.pathname.split(\"/\")[3]; const user=await ensureUser(req); const r=await db.execute(\"DELETE FROM memories WHERE id=? AND user_id=?\",[id,user.id]);\n if(!r.rowsAffected) return Response.json({ok:false,error:\"Memory not found\"},{status:404});\n await db.execute(\"DELETE FROM memory_tags WHERE memory_id=? AND user_id=?\",[id,user.id]);\n await auditFor(user.id,\"memory.deleted\",\"memory\",id); return Response.json({ok:true,id});\n }\n\n if (req.method === \"GET\" && u.pathname === \"/api/memories/search\") {\n const user=await ensureUser(req); const q=String(u.searchParams.get(\"q\")||\"\").trim().slice(0,120); const tag=String(u.searchParams.get(\"tag\")||\"\").trim().slice(0,60); const limit=Math.min(100,Math.max(1,Number(u.searchParams.get(\"limit\"))||50));\n let rows;\n if(tag) rows=await db.execute(\"SELECT m.id,m.session_id,m.kind,m.title,m.body,m.tags,m.pinned,m.archived,m.visibility,m.created_at FROM memories m JOIN memory_tags t ON t.memory_id=m.id AND t.user_id=? WHERE m.user_id=? AND m.archived=0 AND t.tag=? ORDER BY m.pinned DESC,m.created_at DESC LIMIT ?\",[user.id,user.id,tag,limit]);\n else if(q) rows=await db.execute(\"SELECT id,session_id,kind,title,body,tags,pinned,archived,visibility,created_at FROM memories WHERE user_id=? AND archived=0 AND (title LIKE ? OR body LIKE ? OR tags LIKE ?) ORDER BY pinned DESC,created_at DESC LIMIT ?\",[user.id,'%'+q+'%','%'+q+'%','%'+q+'%',limit]);\n else rows=await db.execute(\"SELECT id,session_id,kind,title,body,tags,pinned,archived,visibility,created_at FROM memories WHERE user_id=? AND archived=0 ORDER BY pinned DESC,created_at DESC LIMIT ?\",[user.id,limit]);\n return Response.json({ok:true,query:q,tag,memories:rows.rows});\n }\n\n if (req.method === \"POST\" && u.pathname.match(/^\\/api\\/memories\\/[^/]+\\/tags$/)) {\n const id=u.pathname.split(\"/\")[3]; const user=await ensureUser(req); const b=await req.json().catch(()=>({})); const tags=Array.isArray(b.tags)?b.tags:[];\n const exists=await db.execute(\"SELECT id FROM memories WHERE id=? AND user_id=?\",[id,user.id]); if(!exists.rows.length)return Response.json({ok:false,error:\"Memory not found\"},{status:404});\n await db.execute(\"DELETE FROM memory_tags WHERE memory_id=? AND user_id=?\",[id,user.id]);\n for(const raw of tags.slice(0,12)){const tag=String(raw||\"\").trim().toLowerCase().replace(/[^a-z0-9_-]/g,\"-\").slice(0,40);if(tag)await db.execute(\"INSERT OR IGNORE INTO memory_tags(id,user_id,memory_id,tag) VALUES(?,?,?,?)\",[crypto.randomUUID(),user.id,id,tag]);}\n await auditFor(user.id,\"memory.tags.updated\",\"memory\",id,{count:Math.min(tags.length,12)}); return Response.json({ok:true,id});\n }\n\n if (req.method === \"DELETE\" && u.pathname === \"/api/memories\") {\n const user=await ensureUser(req); const c=await db.execute(\"SELECT memory FROM consent_preferences WHERE user_id=?\",[user.id]);\n if(!Number((c.rows[0] as any)?.memory)) return Response.json({ok:false,error:\"Memory consent required\"},{status:403});\n const r=await db.execute(\"DELETE FROM memories WHERE user_id=?\",[user.id]); await db.execute(\"DELETE FROM memory_tags WHERE user_id=?\",[user.id]);\n await auditFor(user.id,\"memory.vault.cleared\",\"memory\",null,{deleted:r.rowsAffected}); return Response.json({ok:true,deleted:r.rowsAffected});\n }\n\n if (req.method === \"POST\" && u.pathname === \"/api/analytics\") {\n const b=await req.json().catch(()=>({})); const user=await ensureUser(req); const eventName=String(b.eventName||\"\").slice(0,80); if(!eventName)return Response.json({ok:false,error:\"eventName required\"},{status:400});\n await db.execute(\"INSERT INTO analytics_events(id,user_id,session_id,event_name,path,source,referrer,metadata) VALUES(?,?,?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,b.sessionId||null,eventName,String(b.path||u.pathname).slice(0,300),String(b.source||\"\").slice(0,100),String(req.headers.get(\"referer\")||b.referrer||\"\").slice(0,500),JSON.stringify(b.metadata||{})]);\n return Response.json({ok:true});\n }\n if (req.method === \"GET\" && u.pathname === \"/api/analytics/summary\") {\n const since=String(u.searchParams.get(\"since\")||\"1970-01-01\"); const totals=await db.execute(\"SELECT event_name,COUNT(*) AS count FROM analytics_events WHERE created_at>=? GROUP BY event_name ORDER BY count DESC\",[since]); return Response.json({ok:true,totals:totals.rows});\n }\n if (req.method === \"POST\" && u.pathname === \"/api/referrals\") {\n const user=await ensureUser(req); const code=crypto.randomUUID().replace(/-/g,\"\").slice(0,10).toUpperCase(); await db.execute(\"INSERT INTO referrals(id,code,owner_user_id) VALUES(?,?,?)\",[crypto.randomUUID(),code,user.id]); await db.execute(\"INSERT INTO analytics_events(id,user_id,event_name,path,source,metadata) VALUES(?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"referral_created\",\"/\",\"referral\",JSON.stringify({code})]); return new Response(JSON.stringify({ok:true,code,link:new URL(\"/?ref=\"+code,req.url).toString()}),{headers:{\"content-type\":\"application/json\",\"set-cookie\":sessionCookie(user.id)}});\n }\n if (req.method === \"POST\" && u.pathname === \"/api/referrals/convert\") {\n const b=await req.json().catch(()=>({})); const code=String(b.code||\"\").trim().toUpperCase(); const user=await ensureUser(req); if(!code)return Response.json({ok:false,error:\"Referral code required\"},{status:400}); const r=await db.execute(\"UPDATE referrals SET referred_user_id=?,converted_at=CURRENT_TIMESTAMP WHERE code=? AND referred_user_id IS NULL AND owner_user_id<>?\",[user.id,code,user.id]); if(r.rowsAffected) await db.execute(\"INSERT INTO analytics_events(id,user_id,event_name,path,source,metadata) VALUES(?,?,?,?,?,?)\",[crypto.randomUUID(),user.id,\"referral_converted\",\"/\",\"referral\",JSON.stringify({code})]); return Response.json({ok:true,converted:!!r.rowsAffected});\n }\n if (req.method === \"GET\" && u.pathname === \"/robots.txt\") { const origin=new URL(req.url).origin; return new Response(\"User-agent: *\\\\nAllow: /\\\\nSitemap: \"+origin+\"/sitemap.xml\\\\n\",{headers:{\"content-type\":\"text/plain; charset=utf-8\"}}); }\n if (req.method === \"GET\" && u.pathname === \"/sitemap.xml\") {\n const origin=new URL(req.url).origin; const [prayers,seoRequests,devotionals,testimonies]=await Promise.all([db.execute(\"SELECT slug FROM seo_prayer_pages WHERE published=1 ORDER BY updated_at DESC\"),db.execute(\"SELECT id FROM prayer_requests WHERE visibility='public' ORDER BY created_at DESC LIMIT 500\"),db.execute(\"SELECT id FROM devotionals WHERE published=1 ORDER BY created_at DESC\"),db.execute(\"SELECT id FROM testimonies WHERE visibility='public' AND moderation_status='approved' ORDER BY created_at DESC\")]); const urls=[origin+\"/\"]; for(const r of prayers.rows as any[]) urls.push(origin+\"/prayers/\"+encodeURIComponent(r.slug)); for(const r of seoRequests.rows as any[]) urls.push(origin+\"/prayers/request/\"+encodeURIComponent(r.id)); for(const r of devotionals.rows as any[]) urls.push(origin+\"/devotionals/\"+encodeURIComponent(r.id)); for(const r of testimonies.rows as any[]) urls.push(origin+\"/testimonies/\"+encodeURIComponent(r.id)); const xml=\"\"+urls.map(x=>\"\"+esc(x)+\"\").join(\"\")+\"\"; return new Response(xml,{headers:{\"content-type\":\"application/xml; charset=utf-8\",\"cache-control\":\"public, max-age=300\"}});\n }\n if (req.method === \"GET\" && u.pathname.startsWith(\"/prayers/request/\")) {\n const id=decodeURIComponent(u.pathname.slice(\"/prayers/request/\".length)); const r=await db.execute(\"SELECT id,body,answered,created_at FROM prayer_requests WHERE id=? AND visibility='public'\",[id]); if(!r.rows.length)return new Response(\"Not Found\",{status:404}); const p=r.rows[0] as any; const origin=new URL(req.url).origin; const title=\"Prayer Request · 1Hr With God\"; const html=`${title}

Public Prayer Request

Pray with this person.

${esc(p.body)}

${Number(p.answered)?\"Marked as answered prayer.\":\"Please join in prayer.\"}

I Need Prayer · Enter 1Hr With God

`; await db.execute(\"INSERT INTO analytics_events(id,event_name,path,source,metadata) VALUES(?,?,?,?,?)\",[crypto.randomUUID(),\"public_prayer_view\",\"/prayers/request/\"+id,\"organic\",JSON.stringify({prayerId:id})]); return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"public, max-age=300\",\"x-content-purpose\":\"public-prayer\"}});\n }\n\n if (req.method === \"GET\" && u.pathname.startsWith(\"/prayers/\")) {\n const slug=decodeURIComponent(u.pathname.slice(\"/prayers/\".length)); const r=await db.execute(\"SELECT title,summary,body,scripture_reference,category FROM seo_prayer_pages WHERE slug=? AND published=1\",[slug]); if(!r.rows.length)return new Response(\"Not Found\",{status:404}); const p=r.rows[0] as any; const origin=new URL(req.url).origin; const desc=esc(p.summary); const body=esc(p.body);\n const html=`${esc(p.title)} | 1Hr With God

Prayer · ${esc(p.category)}

${esc(p.title)}

${desc}

${body}

${esc(p.scripture_reference||\"Scripture\")}

Enter 1Hr With God · I Need Prayer

`; await db.execute(\"INSERT INTO analytics_events(id,event_name,path,source,metadata) VALUES(?,?,?,?,?)\",[crypto.randomUUID(),\"seo_page_view\",u.pathname,\"organic\",JSON.stringify({type:\"prayer\",slug})]); return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"public, max-age=300\",\"x-content-purpose\":\"seo-public-prayer\"}});\n }\n if (req.method === \"GET\" && u.pathname.startsWith(\"/devotionals/\")) {\n const id=decodeURIComponent(u.pathname.slice(\"/devotionals/\".length)); const r=await db.execute(\"SELECT title,body,scripture_reference,theme FROM devotionals WHERE id=? AND published=1\",[id]); if(!r.rows.length)return new Response(\"Not Found\",{status:404}); const d=r.rows[0] as any; const origin=new URL(req.url).origin; const html=`${esc(d.title)} | 1Hr With God

${esc(d.theme||\"Devotional\")}

${esc(d.title)}

${esc(d.body)}

${esc(d.scripture_reference||\"Scripture\")}

Enter 1Hr With God

`; return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"public, max-age=300\"}});\n }\n if (req.method === \"GET\" && u.pathname.startsWith(\"/testimonies/\")) {\n const id=decodeURIComponent(u.pathname.slice(\"/testimonies/\".length)); const r=await db.execute(\"SELECT type,body,created_at FROM testimonies WHERE id=? AND visibility='public' AND moderation_status='approved'\",[id]); if(!r.rows.length)return new Response(\"Not Found\",{status:404}); const t=r.rows[0] as any; const origin=new URL(req.url).origin; const html=`Testimony | 1Hr With God

Testimony

What God has done

${esc(t.body)}

Enter 1Hr With God

`; return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"public, max-age=300\"}});\n }\n\n return new Response(\"Not Found\",{status:404});\n}\n","deleted",false,"label",[14],"08ff040a-7da8-4f7c-9f6d-6e1ca1d848fd",["D",1787620224495],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Digital sanctuary for prayer, Scripture, worship and impact.","imageUrl","userId","1066b61b-f70a-46a7-8125-91c596378659","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","08ff040a7da84f7c9f6d6e1ca1d848fd","tursoHostname","08ff040a7da84f7c9f6d6e1ca1d848fd-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789533091345],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",84,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Aurorin Magazine","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ8i2UIZrlsQap-nn3UPmSBKMkeYfBAHCiy5Y-K4y1DhFt-Bh4=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":62,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Come as you are.Leave closer.

One hour. Five movements.

Audio Adventure Bible

Live Altar

Prayer & Memory

SMILE

Today’s invitation

Live Altar

SMILE

You are not praying alone.

John 3:16

Remembered, not tracked

Grace Coins · 0

0 day rhythm

Privacy & consent

What would you like to say to God?

Bring it into the room.

Your reflections, yours to control.

Pray with this person.

${esc(p.title)}

${esc(d.title)}

What God has done

Come as you are.
Leave closer.