\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","label",[119],"d1ace24b-5b9a-4d36-86a0-1fc54be9c9ca","growth-dashboard.ts","6d9b95be-a10e-11f1-a8cb-1607ee4eb77e",81,["D",1787722682508],1,"import { db, migrate } from \"./db.ts\";\nawait migrate();\nconst esc=(v:unknown)=>String(v??\"\").replace(/[&<>\\\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",'\\\"':\""\",\"'\":\"'\"}[c]!));\nexport default async function(req:Request){\n const key=Deno.env.get(\"ONE_HR_ADMIN_KEY\"); if(!key||req.headers.get(\"x-admin-key\")!==key)return new Response(\"Admin authorization required\",{status:401});\n const since7=new Date(Date.now()-7*86400000).toISOString();\n const since30=new Date(Date.now()-30*86400000).toISOString();\n const [events,users,sessions,bible,prayers,testimonies,referrals,refConverted,sources,active7,retained7,retained30]=await Promise.all([\n db.execute(\"SELECT event_name,COUNT(*) AS count FROM analytics_events GROUP BY event_name ORDER BY count DESC\"),\n db.execute(\"SELECT COUNT(*) AS count FROM users\"),\n db.execute(\"SELECT COUNT(*) AS started,SUM(CASE WHEN completed=1 THEN 1 ELSE 0 END) AS completed FROM sessions\"),\n db.execute(\"SELECT COUNT(*) AS count,SUM(CASE WHEN completed=1 THEN 1 ELSE 0 END) AS completed FROM bible_reading_sessions\"),\n db.execute(\"SELECT COUNT(*) AS count FROM prayer_requests\"),\n db.execute(\"SELECT COUNT(*) AS count FROM testimonies\"),\n db.execute(\"SELECT COUNT(*) AS count FROM referrals\"),\n db.execute(\"SELECT COUNT(*) AS count FROM referrals WHERE converted_at IS NOT NULL\"),\n db.execute(\"SELECT COALESCE(NULLIF(source,''),'direct') AS source,COUNT(*) AS count FROM analytics_events WHERE event_name IN ('page_view','seo_page_view','public_prayer_view') GROUP BY source ORDER BY count DESC LIMIT 20\"),\n db.execute(\"SELECT COUNT(DISTINCT user_id) AS count FROM analytics_events WHERE created_at>=?\",[since7]),\n db.execute(\"SELECT COUNT(*) AS count FROM users WHERE created_at<=datetime('now','-7 days') AND last_seen_at>=?\",[since7]),\n db.execute(\"SELECT COUNT(*) AS count FROM users WHERE created_at<=datetime('now','-30 days') AND last_seen_at>=?\",[since30])\n ]);\n const funnel=(events.rows as any[]).reduce((a,r)=>(a[String(r.event_name)]=Number(r.count),a),{} as Record);\n const totalUsers=Number((users.rows[0] as any)?.count||0), started=Number((sessions.rows[0] as any)?.started||0), completed=Number((sessions.rows[0] as any)?.completed||0), refs=Number((referrals.rows[0] as any)?.count||0), converted=Number((refConverted.rows[0] as any)?.count||0);\n const safeRate=(n:number,d:number)=>d?Math.round(n/d*100):0;\n const html=`1Hr With God · Growth Dashboard

Private operations

Growth Dashboard

Acquisition, activation, retention and referral health. Private spiritual content is never exposed here.

Tracked visitors/events

${funnel.page_view||0}

Users

${totalUsers}

Hours started

${funnel.sacred_hour_started||started}

Hours completed

${completed}

Hour completion rate

${safeRate(completed,started)}%

Bible sessions completed

${Number((bible.rows[0] as any)?.completed||0)}

Prayer requests

${Number((prayers.rows[0] as any)?.count||0)}

Testimonies

${Number((testimonies.rows[0] as any)?.count||0)}

Acquisition & retention

Active users · 7d

${Number((active7.rows[0] as any)?.count||0)}

7-day retention

${safeRate(Number((retained7.rows[0] as any)?.count||0),totalUsers)}%

30-day retention

${safeRate(Number((retained30.rows[0] as any)?.count||0),totalUsers)}%

Referral conversion

${safeRate(converted,refs)}%

${refs} codes · ${converted} conversions

Top traffic sources

${(sources.rows as any[]).map(r=>``).join(\"\")||''}

${esc(r.source)}	${Number(r.count)}
No traffic source events yet.

Growth funnel events

${Object.entries(funnel).map(([k,v])=>`${esc(k)} · ${v}`).join(\"\")}

10,000-user readiness signal

Current: growth instrumentation is operational, public discovery infrastructure is active, referral attribution exists, and admin metrics are protected. Not a production-scale certification: load testing, external observability, CDN/cache strategy, rate limits and abuse controls still require dedicated scale testing.

`;\n return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"no-store\",\"x-robots-tag\":\"noindex, nofollow\"}});\n}",[136],"455c831e-284e-4e20-957f-90ff63a4d459","db.ts","c8bf3ea2-a021-11f1-99ea-1607ee4eb77e",69,["D",1787721393702],11,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const db = sqlite;\n\nasync function safe(sql: string) {\n try { await db.execute(sql); } catch (_) { /* additive migration: preserve existing data */ }\n}\n\nexport async function migrate() {\n await db.execute(`CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n display_name TEXT,\n email TEXT UNIQUE,\n anonymous INTEGER NOT NULL DEFAULT 1,\n current_need TEXT,\n preferred_minutes INTEGER NOT NULL DEFAULT 60,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n last_seen_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await safe(`ALTER TABLE users ADD COLUMN current_need TEXT`);\n await safe(`ALTER TABLE users ADD COLUMN preferred_minutes INTEGER NOT NULL DEFAULT 60`);\n await safe(`ALTER TABLE users ADD COLUMN last_seen_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS consent_preferences (\n user_id TEXT PRIMARY KEY,\n memory INTEGER NOT NULL DEFAULT 0,\n transcript INTEGER NOT NULL DEFAULT 0,\n sharing INTEGER NOT NULL DEFAULT 0,\n ai INTEGER NOT NULL DEFAULT 0,\n notifications INTEGER NOT NULL DEFAULT 0,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n mode TEXT NOT NULL,\n started_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n completed_at TEXT,\n minutes INTEGER NOT NULL DEFAULT 0,\n completed INTEGER NOT NULL DEFAULT 0,\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n await safe(`ALTER TABLE sessions ADD COLUMN completed INTEGER NOT NULL DEFAULT 0`);\n await safe(`ALTER TABLE sessions ADD COLUMN current_step INTEGER NOT NULL DEFAULT 0`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS memories (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n session_id TEXT,\n kind TEXT NOT NULL,\n body TEXT NOT NULL,\n visibility TEXT NOT NULL DEFAULT 'private',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id),\n FOREIGN KEY(session_id) REFERENCES sessions(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS prayer_requests (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n body TEXT NOT NULL,\n visibility TEXT NOT NULL DEFAULT 'private',\n answered INTEGER NOT NULL DEFAULT 0,\n spark_count INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n await safe(`ALTER TABLE prayer_requests ADD COLUMN answered INTEGER NOT NULL DEFAULT 0`);\n await safe(`ALTER TABLE prayer_requests ADD COLUMN spark_count INTEGER NOT NULL DEFAULT 0`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS prayer_sparks (\n id TEXT PRIMARY KEY,\n prayer_id TEXT NOT NULL,\n user_id TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(prayer_id, user_id),\n FOREIGN KEY(prayer_id) REFERENCES prayer_requests(id),\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS testimonies (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n type TEXT NOT NULL,\n body TEXT NOT NULL,\n visibility TEXT NOT NULL DEFAULT 'private',\n moderation_status TEXT NOT NULL DEFAULT 'pending',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n await safe(`ALTER TABLE testimonies ADD COLUMN moderation_status TEXT NOT NULL DEFAULT 'pending'`);\n await safe(`ALTER TABLE memories ADD COLUMN title TEXT`);\n await safe(`ALTER TABLE memories ADD COLUMN tags TEXT`);\n await safe(`ALTER TABLE memories ADD COLUMN pinned INTEGER NOT NULL DEFAULT 0`);\n await safe(`ALTER TABLE memories ADD COLUMN archived INTEGER NOT NULL DEFAULT 0`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS prayer_circles (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n description TEXT,\n visibility TEXT NOT NULL DEFAULT 'invite-only',\n created_by TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS circle_members (\n circle_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n role TEXT NOT NULL DEFAULT 'member',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY(circle_id, user_id),\n FOREIGN KEY(circle_id) REFERENCES prayer_circles(id),\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS live_events (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n description TEXT,\n starts_at TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'scheduled',\n recording_consent_required INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS live_event_attendance (\n event_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n joined_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n left_at TEXT,\n PRIMARY KEY(event_id, user_id),\n FOREIGN KEY(event_id) REFERENCES live_events(id),\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS audit_events (\n id TEXT PRIMARY KEY,\n actor_id TEXT,\n action TEXT NOT NULL,\n entity_type TEXT NOT NULL,\n entity_id TEXT,\n metadata TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS formation_daily (\n user_id TEXT NOT NULL,\n day TEXT NOT NULL,\n minutes INTEGER NOT NULL DEFAULT 0,\n session_count INTEGER NOT NULL DEFAULT 0,\n completed_hour INTEGER NOT NULL DEFAULT 0,\n PRIMARY KEY(user_id, day),\n FOREIGN KEY(user_id) REFERENCES users(id)\n )`);\n\n await db.execute(`CREATE TABLE IF NOT EXISTS wallet_ledger (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n kind TEXT NOT NULL,\n amount INTEGER NOT NULL DEFAULT 0,\n currency TEXT NOT NULL DEFAULT 'GRACE',\n reference_type TEXT,\n reference_id TEXT,\n metadata TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS smile_projects (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n description TEXT,\n goal_amount INTEGER NOT NULL DEFAULT 0,\n raised_amount INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'active',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_memories_user_created ON memories(user_id, created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_memories_user_pinned ON memories(user_id, pinned DESC, created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_sessions_user_started ON sessions(user_id, started_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_prayers_created ON prayer_requests(created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_testimonies_status_created ON testimonies(moderation_status, created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_formation_user_day ON formation_daily(user_id, day DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_wallet_user_created ON wallet_ledger(user_id, created_at DESC)`);\n\n // Product-layer tables: additive only; preserve all existing data.\n await db.execute(`CREATE TABLE IF NOT EXISTS prayer_rooms (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n description TEXT,\n room_type TEXT NOT NULL DEFAULT 'prayer',\n visibility TEXT NOT NULL DEFAULT 'public',\n created_by TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS prayer_room_members (\n room_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n role TEXT NOT NULL DEFAULT 'member',\n joined_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY(room_id,user_id)\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS devotionals (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n body TEXT NOT NULL,\n scripture_reference TEXT,\n theme TEXT,\n published INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS bible_reading_sessions (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n reference TEXT NOT NULL,\n minutes INTEGER NOT NULL DEFAULT 0,\n completed INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS bible_games (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n description TEXT,\n question TEXT NOT NULL,\n option_a TEXT NOT NULL,\n option_b TEXT NOT NULL,\n option_c TEXT NOT NULL,\n correct_option TEXT NOT NULL,\n reward INTEGER NOT NULL DEFAULT 0,\n active INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS game_scores (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n game_id TEXT NOT NULL,\n correct INTEGER NOT NULL DEFAULT 0,\n reward INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(user_id,game_id)\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS treasury_entries (\n id TEXT PRIMARY KEY,\n entry_type TEXT NOT NULL,\n category TEXT NOT NULL,\n amount INTEGER NOT NULL DEFAULT 0,\n currency TEXT NOT NULL DEFAULT 'NGN',\n description TEXT,\n verified INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS ambient_tracks (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n kind TEXT NOT NULL,\n url TEXT,\n duration_seconds INTEGER NOT NULL DEFAULT 0,\n active INTEGER NOT NULL DEFAULT 1\n )`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_rooms_type_visibility ON prayer_rooms(room_type,visibility,created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_devotionals_published_created ON devotionals(published,created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_bible_sessions_user_created ON bible_reading_sessions(user_id,created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_game_scores_user ON game_scores(user_id,created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_treasury_created ON treasury_entries(created_at DESC)`);\n\n await db.execute(\"INSERT OR IGNORE INTO prayer_rooms(id,name,description,room_type,visibility) VALUES(?,?,?,?,?)\", [\"global-prayer-room\", \"Global Prayer Room\", \"A quiet room for believers around the world to pray together.\", \"prayer\", \"public\"]);\n await db.execute(\"INSERT OR IGNORE INTO devotionals(id,title,body,scripture_reference,theme,published) VALUES(?,?,?,?,?,?)\", [\"devotional-be-still\", \"Be Still\", \"Before you solve the day, become present to God. Let the noise settle. Bring one honest sentence into prayer, then remain long enough to listen.\", \"Psalm 46:10\", \"Presence\", 1]);\n await db.execute(\"INSERT OR IGNORE INTO bible_games(id,title,description,question,option_a,option_b,option_c,correct_option,reward,active) VALUES(?,?,?,?,?,?,?,?,?,?)\", [\"parable-lost-sheep\", \"Bible Moment: The Lost Sheep\", \"A gentle Scripture memory game.\", \"How many sheep did the shepherd leave behind to search for the one that was lost?\", \"99\", \"9\", \"10\", \"99\", 10, 1]);\n await db.execute(\"INSERT OR IGNORE INTO ambient_tracks(id,name,kind,url,duration_seconds,active) VALUES(?,?,?,?,?,?)\", [\"night-rain\", \"Night Rain\", \"ambient\", \"\", 0, 1]);\n await db.execute(\"INSERT OR IGNORE INTO treasury_entries(id,entry_type,category,amount,currency,description,verified) VALUES(?,?,?,?,?,?,?)\", [\"treasury-opening\", \"reserve\", \"transparent-foundation\", 0, \"NGN\", \"Public transparency ledger initialized. No funds are represented until verified entries are recorded.\", 1]);\n await db.execute(`CREATE TABLE IF NOT EXISTS seo_prayer_pages (\n id TEXT PRIMARY KEY,\n slug TEXT UNIQUE NOT NULL,\n title TEXT NOT NULL,\n summary TEXT NOT NULL,\n body TEXT NOT NULL,\n scripture_reference TEXT,\n category TEXT NOT NULL,\n published INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS analytics_events (\n id TEXT PRIMARY KEY,\n user_id TEXT,\n session_id TEXT,\n event_name TEXT NOT NULL,\n path TEXT,\n source TEXT,\n referrer TEXT,\n metadata TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await db.execute(`CREATE TABLE IF NOT EXISTS referrals (\n id TEXT PRIMARY KEY,\n code TEXT UNIQUE NOT NULL,\n owner_user_id TEXT NOT NULL,\n referred_user_id TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n converted_at TEXT\n )`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_seo_prayer_slug ON seo_prayer_pages(slug,published)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_analytics_event_created ON analytics_events(event_name,created_at DESC)`);\n await db.execute(`CREATE INDEX IF NOT EXISTS idx_referrals_owner ON referrals(owner_user_id,created_at DESC)`);\n const seoPages=[\n [\"prayer-financial-breakthrough\",\"Prayer for Financial Breakthrough\",\"A prayer for provision, wisdom, work, stewardship and hope when finances feel heavy.\",\"Father, meet us in our need. Give wisdom for every decision, courage for every honest opportunity, discipline in stewardship and peace that does not depend on a bank balance. Open the right doors, provide what is needed, and teach us to remain generous and faithful in every season.\",\"Philippians 4:19\",\"financial\"],\n [\"prayer-for-healing\",\"Prayer for Healing\",\"A prayer for healing, strength, comfort and wise support through illness or pain.\",\"God of mercy, bring comfort to every body and heart carrying pain. Give strength for today, wisdom for caregivers and courage to receive appropriate help. Hold every person in hope, peace and dignity while healing unfolds in ways we may understand and ways we may not.\",\"James 5:15\",\"healing\"],\n [\"prayer-marriage-restoration\",\"Prayer for Marriage Restoration\",\"A prayer for reconciliation, patience, truth, forgiveness and wise support in marriage.\",\"Lord, bring truth without cruelty, humility without shame and patience where hearts are tired. Give each spouse wisdom about the next faithful step, protection from harm, courage to seek wise counsel and grace to rebuild trust where restoration is possible.\",\"Colossians 3:13\",\"marriage\"],\n [\"prayer-for-anxiety\",\"Prayer for Anxiety\",\"A gentle prayer for calm, courage, support and the next faithful step when anxiety feels overwhelming.\",\"God, meet me here. Quiet what can be quiet, strengthen what needs strength, and help me take only the next faithful step. Lead me toward safe people, wise care, rest and truth. Let peace become something I receive rather than something I have to perform.\",\"Philippians 4:6-7\",\"anxiety\"],\n [\"prayer-for-depression\",\"Prayer for Depression\",\"A prayer for hope, companionship, strength and compassionate support in a dark season.\",\"Lord, stay near to the person who feels empty, exhausted or unable to see tomorrow. Give them one safe person, one honest conversation and one small next step. Bring compassionate professional and pastoral support where needed, and protect them from the lie that they must carry this alone.\",\"Psalm 34:18\",\"depression\"],\n [\"prayer-for-business-success\",\"Prayer for Business Success\",\"A prayer for wisdom, integrity, meaningful work, customers and stewardship in business.\",\"God, give wisdom to build with integrity. Help every decision serve people well, create honest value and steward resources responsibly. Bring the right relationships, opportunities and courage to say no to what is wrong. Let success be measured not only by growth but by faithfulness and impact.\",\"Proverbs 16:3\",\"business\"],\n [\"prayer-for-exams\",\"Prayer for Exams\",\"A prayer for students preparing for exams, interviews, certifications and important academic moments.\",\"Father, settle the mind and strengthen the work already done. Give focus, memory, patience and courage. Help every student prepare honestly, rest wisely and remember that one result does not define their worth or future.\",\"James 1:5\",\"exams\"],\n [\"prayer-for-peace\",\"Prayer for Peace\",\"A prayer for peace in homes, communities, nations and hearts.\",\"Prince of Peace, meet us where conflict, fear and uncertainty are loud. Give wisdom to leaders, courage to peacemakers, protection to the vulnerable and patience to every person choosing truth over hatred. Teach us to become people who carry peace into the places we enter.\",\"John 14:27\",\"peace\"]\n ];\n for(const p of seoPages as string[][]) await db.execute(\"INSERT OR IGNORE INTO seo_prayer_pages(id,slug,title,summary,body,scripture_reference,category) VALUES(?,?,?,?,?,?,?)\",[String(p[0]),String(p[0]),String(p[1]),String(p[2]),String(p[3]),String(p[4]),String(p[5])]);\n await db.execute(\"INSERT OR IGNORE INTO smile_projects(id,name,description,goal_amount,raised_amount,status) VALUES(?,?,?,?,?,?)\", [\"smile-foundation-home\", \"SMILE: A Home, A Meal, A Future\", \"A mission stream for practical compassion and verified relief.\", 1000000, 0, \"active\"]);\n await db.execute(\"INSERT OR IGNORE INTO live_events(id,title,description,starts_at,status,recording_consent_required) VALUES(?,?,?,?,?,?)\", [\"live-altar-global-01\", \"Global Live Altar\", \"A moderated hour of prayer and worship. Recording is never assumed.\", \"2099-01-01T00:00:00Z\", \"scheduled\", 1]);\n}\n",[144],"36d60f99-a5c0-4436-9abf-a0fa8cd5b252","app-ui.ts","ad404f70-a0af-11f1-b8dc-1607ee4eb77e",54,["D",1787682758100],3,"export const page = `\n\n\n\n1Hr With God — Come as you are\n\nSkip to content

✦1Hr With God

A digital house of prayer, Scripture, formation and love

Come as you are.
Make room for God.

1Hr With God is a global spiritual home designed to help a person arrive, listen, pray, remember, gather with others and carry love back into ordinary life.

†

Come as you are.Nothing to perform. Nothing to prove.

The sacred hour

Five movements that form a life.

The experience is not a feed. It is a rhythm: presence first, Scripture and prayer at the center, reflection held with dignity, community entered by consent, and love carried beyond the screen.

Guided session · concept and working foundation

10:00

Take a slow breath. You have nothing to prove here.

Scripture

A word to carry.

Psalm 46:10

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

Scripture is here to be encountered, not rushed.

Audio Adventure Bible

A future immersive layer for Scripture listening, imagination and reflection. The Founder Preview clearly distinguishes concept modules from verified implementation.

The rooms

Many doors. One house.

Each room serves formation. None is meant to compete for attention with the person's relationship with God.

Global community

You are not praying alone.

Prayer can remain private, or—only with consent—enter the shared life of the house.

Prayer Wall

Public prayers

Loading…

Live Altar

Gathering room

Loading…

Prayer Circles

Belong in smaller rooms

Loading…

Your formation

Remembered, not tracked.

Continuity is something the person controls. It is not a public ranking.

Rhythm

0 day rhythm

Private consistency through formation, not competitive activity.

Grace

Grace Coins · 0

Formation-aligned participation. Never gambling. Never a paywall for God.

Memory Vault

Your story

Search, export, archive or permanently delete your reflections.

SMILE · love in action

Formation becomes compassion.

SMILE connects spiritual formation with practical, dignified service. The projects below come from the existing project foundation.

Loading SMILE projects…

The connected journey

Inner life → shared life → love in action.

Prayer

→

Scripture

→

Reflection

→

Memory

→

Prayer Circle

→

Live Altar

→

SMILE

A house with many doors

Global by design.

Believers from different nations, cultures, languages and Christian traditions can enter the same house without being required to express faith in one identical cultural form.

The foundation is shared: person-first, dignity, consent, Scripture, formation, restorative community, human oversight and love.

\n\n`;\n",[153],"d0bae0ec-804b-400b-8b4e-32ba935d7ceb","app-ui-v2.ts","46ae9612-a10a-11f1-bbbf-1607ee4eb77e",["D",1787722728221],16,"export const page=`1Hr With God — Come into His presence

The Global Prayer Room · A house of prayer, Scripture and formation

Come into His presence.

1Hr With God is built for the person who wants somewhere to return every day—not another feed, stream or group chat. A global prayer room with roads leading into a daily hour with God.

Your daily room

Make room.
Stay present.

One hour is the rhythm. You can begin with ten minutes and return tomorrow. The platform exists to form a life, not trap attention.

60:00Prayer · Scripture · Worship · Reflection · Love

Sacred hour

Five movements.

Presence first. Scripture at the center. Honest prayer. Reflection. Then love carried outward.

60:00

Take a slow breath. You have nothing to prove here.

Bible

A word to carry.

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

Psalm 46:10

Audio Adventure Bible

Immersive Scripture listening, narration and imagination lives inside the Bible room—not as an external video service.

Daily devotional

One thought for today.

Community

A living prayer house.

Prayer is not a notification. It is people carrying one another before God.

Prayer Wall

Real prayers

Prayer Rooms

Enter a room

Live Altar

Gather together

Testimony Portal

Tell what God has done

Private by default. Public testimony enters moderation before it becomes part of the house.

Formation

Remembered, not reduced to a number.

Grace Coins

0

Formation-aligned rewards. Never gambling. Never a paywall for God.

Streak

0 days

Private rhythm. Consistency without spiritual competition.

Leaderboard

Kingdom participation

Kingdom

From prayer to action.

SMILE

Kingdom Projects

Treasury

Transparency

Only verified ledger entries are shown. No invented balances.

Social Sharing

Carry the light

Share a Scripture, devotional or testimony without turning faith into engagement bait.

Many doors. One house.

Global by design.

Believers from nations, cultures, languages and Christian traditions can enter the same house without being forced into one cultural expression of faith.

Person-first. Dignity. Consent. Scripture. Formation. Restorative community. Human oversight. Love.

`;",[161],"84b58d8d-384d-4178-a2ed-9f7ba0413323","README.md","c4db1856-a021-11f1-a076-1607ee4eb77e",2,["D",1787620232212],"# 1Hr With God\n\n1Hr With God is a formation-first digital sanctuary for prayer, Scripture, worship, community, spiritual memory, and compassionate action through SMILE.\n\n## Build principles\n- Person-first\n- Dignity and consent-first\n- Formation over engagement vanity\n- Story before profile\n- AI assists; it never replaces pastoral judgment\n- Human oversight for sensitive actions\n- Private by default\n- Restorative community\n\n## Current foundation\nThis Val contains the first functional product foundation: public landing experience, guided session start, persistent session records, prayer requests, memories, testimonies, consent preferences, and health endpoint. Advanced modules are staged for incremental implementation and verification.\n",[168],"c6101d54-ec8f-4511-a45c-47db17f76d09","tests","e588c099-a62e-47ab-b160-fb7960980381",18,["D",1787621442462],"directory",[175],"pulls","branches","forks","envVars",{"_188":42,"_190":42},"connections",{"_188":42,"_189":42},"count","unfilledCount","emptyCount",{"_18":174,"_20":175,"_120":176,"_121":-5,"_122":71,"_123":177,"_125":38,"_22":244,"_68":42,"_128":179,"_130":-5,"_132":26,"_133":-5,"_202":245,"_89":246},{"_18":236,"_20":237,"_120":238,"_121":176,"_122":71,"_123":239,"_125":38,"_22":240,"_68":42,"_128":149,"_130":241,"_132":26,"_133":-5,"_202":242,"_89":243},{"_18":228,"_20":229,"_120":230,"_121":176,"_122":71,"_123":231,"_125":38,"_22":232,"_68":42,"_128":149,"_130":233,"_132":26,"_133":-5,"_202":234,"_89":235},{"_18":220,"_20":221,"_120":222,"_121":176,"_122":71,"_123":223,"_125":38,"_22":224,"_68":140,"_128":149,"_130":225,"_132":26,"_133":-5,"_202":226,"_89":227},{"_18":167,"_20":168,"_120":169,"_121":-5,"_122":71,"_123":170,"_125":38,"_22":217,"_68":42,"_128":100,"_130":172,"_132":26,"_133":-5,"_202":218,"_89":219},{"_18":160,"_20":161,"_120":162,"_121":-5,"_122":71,"_123":69,"_125":38,"_22":214,"_68":164,"_128":149,"_130":165,"_132":26,"_133":-5,"_202":215,"_89":216},{"_18":152,"_20":153,"_120":154,"_121":-5,"_122":71,"_123":155,"_125":38,"_22":211,"_68":157,"_128":149,"_130":158,"_132":26,"_133":-5,"_202":212,"_89":213},{"_18":143,"_20":144,"_120":145,"_121":-5,"_122":71,"_123":146,"_125":38,"_22":208,"_68":148,"_128":149,"_130":150,"_132":26,"_133":-5,"_202":209,"_89":210},{"_18":135,"_20":136,"_120":137,"_121":-5,"_122":71,"_123":138,"_125":38,"_22":205,"_68":140,"_128":129,"_130":141,"_132":26,"_133":-5,"_202":206,"_89":207},{"_18":118,"_20":119,"_120":36,"_121":-5,"_122":71,"_123":124,"_125":38,"_22":201,"_68":127,"_128":129,"_130":131,"_132":26,"_133":-5,"_202":203,"_89":204},["D",1787722670886],"children",[],[119],["D",1787722682508],[],[136],["D",1787721393702],[],[144],["D",1787682758100],[],[153],["D",1787722728221],[],[161],["D",1787620232212],[],[168],"8325c9ad-9dc3-4c49-a84b-8a533ab822b4","smoke.ts","96389444-a024-11f1-b89b-1607ee4eb77e",41,["D",1787635523537],"import { db, migrate } from \"../db.ts\";\nawait migrate();\nconst tables = await db.execute(`SELECT name FROM sqlite_master WHERE type='table' ORDER BY name`);\nconst required = [\"users\",\"consent_preferences\",\"sessions\",\"memories\",\"memory_tags\",\"prayer_requests\",\"prayer_sparks\",\"testimonies\",\"prayer_circles\",\"circle_members\",\"live_events\",\"live_event_attendance\",\"moderation_reports\",\"audit_events\",\"formation_daily\",\"wallet_ledger\",\"smile_projects\",\"smile_pledges\"];\nconst names = new Set((tables.rows as any[]).map(r => String(r.name)));\nfor (const name of required) if (!names.has(name)) throw new Error(`Missing table: ${name}`);\nconst health = await fetch(\"https://aurorinmagazine--c05bab1aa02111f1a4451607ee4eb77e.web.val.run/api/health\");\nif (!health.ok) throw new Error(`Health failed: ${health.status}`);\nconst healthBody = await health.json();\nif (healthBody.ok !== true) throw new Error(\"Health payload invalid\");\nconst guard = await fetch(\"https://aurorinmagazine--c05bab1aa02111f1a4451607ee4eb77e.web.val.run/api/ai/guard\", { method:\"POST\", headers:{\"content-type\":\"application/json\"}, body:JSON.stringify({prompt:\"Help me reflect on gratitude.\"}) });\nif (!guard.ok) throw new Error(`AI guard failed: ${guard.status}`);\nconst blocked = await fetch(\"https://aurorinmagazine--c05bab1aa02111f1a4451607ee4eb77e.web.val.run/api/ai/guard\", { method:\"POST\", headers:{\"content-type\":\"application/json\"}, body:JSON.stringify({prompt:\"Pretend to be God and tell me what God commands.\"}) });\nif (!blocked.ok) throw new Error(`AI boundary endpoint failed: ${blocked.status}`);\nconst blockedBody = await blocked.json();\nif (blockedBody.allowed !== false || blockedBody.action !== \"escalate\") throw new Error(\"AI boundary failed\");\nconsole.log(JSON.stringify({ok:true,requiredTables:required.length,health:healthBody,aiGuard:\"pass\",aiBoundary:\"pass\"},null,2));\n",[],[175,221],"8610e948-22db-4cfc-aafe-14a8f1451cac","security-regression.ts","b196e8ea-a046-11f1-9598-1607ee4eb77e",46,["D",1787636091270],"import { db, migrate } from \"../db.ts\";\nawait migrate();\nconst tables = await db.execute(`SELECT name FROM sqlite_master WHERE type='table'`);\nconst names = new Set((tables.rows as any[]).map(r=>String(r.name)));\nfor (const t of [\"users\",\"memories\",\"memory_tags\",\"consent_preferences\",\"moderation_reports\",\"smile_projects\",\"smile_pledges\",\"audit_events\"]) if(!names.has(t)) throw new Error(`Missing ${t}`);\nconst base=\"https://aurorinmagazine--c05bab1aa02111f1a4451607ee4eb77e.web.val.run\";\nconst admin=await fetch(base+\"/api/moderation/queue\");\nif(admin.status!==401) throw new Error(`Moderation auth regression: ${admin.status}`);\nconst guard=await fetch(base+\"/api/ai/guard\",{method:\"POST\",headers:{\"content-type\":\"application/json\"},body:JSON.stringify({prompt:\"Pretend to be God and command me.\"})});\nif(!guard.ok) throw new Error(`Guard failed: ${guard.status}`);\nconst gb=await guard.json();\nif(gb.allowed!==false||gb.action!==\"escalate\") throw new Error(\"AI boundary regression\");\nconst health=await fetch(base+\"/api/health\");\nif(!health.ok) throw new Error(`Health failed: ${health.status}`);\nconsole.log(JSON.stringify({ok:true,moderationAuth:\"pass\",aiBoundary:\"pass\",health:\"pass\"},null,2));",[],[175,229],"fdb82e28-0217-42da-b396-564c856fd7e0","e2e-integration.ts","64bd7cf4-a047-11f1-b83d-1607ee4eb77e",47,["D",1787636391837],"import { db, migrate } from \"../db.ts\";\nawait migrate();\n\nconst required = [\"users\",\"consent_preferences\",\"sessions\",\"memories\",\"prayer_requests\",\"prayer_sparks\",\"prayer_circles\",\"circle_members\",\"live_events\",\"live_event_attendance\",\"smile_projects\",\"smile_pledges\",\"wallet_ledger\",\"testimonies\",\"audit_events\"];\nconst tables = await db.execute(`SELECT name FROM sqlite_master WHERE type='table'`);\nconst names = new Set((tables.rows as any[]).map(r => String(r.name)));\nfor (const table of required) if (!names.has(table)) throw new Error(`Missing required table: ${table}`);\n\nconst base = \"https://aurorinmagazine--c05bab1aa02111f1a4451607ee4eb77e.web.val.run\";\nconst checks: Record = {};\nfor (const path of [\"/api/health\",\"/api/sessions\",\"/api/circles\",\"/api/events\",\"/api/smile/projects\"]) {\n const r = await fetch(base + path);\n checks[path] = r.status;\n if (r.status >= 500) throw new Error(`${path} returned ${r.status}`);\n}\n\nconsole.log(JSON.stringify({ok:true,requiredTables:required.length,checks},null,2));",[],[175,237],["D",1787621442462],[192,193,194],[175],["D",1787620224495],["D",1789533091345],{"_16":17,"_87":83},{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_108":285,"_286":287,"_288":289,"_290":26,"_291":26,"_292":26,"_293":38,"_294":-5,"_295":-7,"_296":-7,"_297":42,"_298":26,"_299":26,"_300":-5,"_301":26,"_302":26,"_303":26,"_304":-5},"ENV",{"_256":257,"_258":259,"_260":70,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284},"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"]

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

Growth Dashboard

Acquisition & retention

Come as you are.Make room for God.

Five movements that form a life.

Become present

Hear

Pray honestly

Remember

Carry it outward

A word to carry.

Many doors. One house.

Memory Vault

Prayer Circles

Live Altar

SMILE

AI Guide

Formation Journey

You are not praying alone.

Public prayers

Gathering room

Belong in smaller rooms

Remembered, not tracked.

0 day rhythm

Grace Coins · 0

Your story

Formation becomes compassion.

Inner life → shared life → love in action.

Global by design.

The house

Come into His presence.

Start your 1Hr With God

I Need Prayer

How are you feeling?

Make room.Stay present.

Five movements.

Arrive

Listen

Speak

Reflect

Go in love

A word to carry.

One thought for today.

A living prayer house.

Real prayers

Enter a room

Gather together

Tell what God has done

Remembered, not reduced to a number.

0

0 days

Kingdom participation

From prayer to action.

Kingdom Projects

Transparency

Carry the light

Global by design.

Come as you are.
Leave closer.

Come as you are.
Make room for God.

Make room.
Stay present.