aa:I[903690,["/chat-static/_next/static/immutable/chunks/25sy-cznq5gtk.js","/chat-static/_next/static/immutable/chunks/17kl369b79nmd.js","/chat-static/_next/static/immutable/chunks/3ipxm38dyyb9q.js","/chat-static/_next/static/immutable/chunks/25oa2-cd4babd.js","/chat-static/_next/static/immutable/chunks/1di_td8luy3gw.js","/chat-static/_next/static/immutable/chunks/0_zevym5bobxk.js","/chat-static/_next/static/immutable/chunks/0pa2o-879tgyz.js","/chat-static/_next/static/immutable/chunks/2iyogqj39terz.js","/chat-static/_next/static/immutable/chunks/0vmwjdmzo33vb.js","/chat-static/_next/static/immutable/chunks/3xsyi84us226z.js","/chat-static/_next/static/immutable/chunks/3sd5co-q3j6ji.js","/chat-static/_next/static/immutable/chunks/3b6rwng7jzw37.js","/chat-static/_next/static/immutable/chunks/454vo2w1h6da9.js","/chat-static/_next/static/immutable/chunks/0kpqqt3b70onu.js","/chat-static/_next/static/immutable/chunks/0i48amtc28pqy.js","/chat-static/_next/static/immutable/chunks/0t6ytllohkn0t.js","/chat-static/_next/static/immutable/chunks/17xddrdopbp9_.js","/chat-static/_next/static/immutable/chunks/2dh86ziq4bpa7.js","/chat-static/_next/static/immutable/chunks/33addp8wpisll.js","/chat-static/_next/static/immutable/chunks/0avdeadirr7ac.js","/chat-static/_next/static/immutable/chunks/421be_5xz_yit.js","/chat-static/_next/static/immutable/chunks/2gn4nsrh2z77a.js","/chat-static/_next/static/immutable/chunks/0nc47r7g497qp.js","/chat-static/_next/static/immutable/chunks/1o9d1-74u-xr7.js","/chat-static/_next/static/immutable/chunks/0_zojv1j0yvgz.js","/chat-static/_next/static/immutable/chunks/0dt5xmjm5355d.js","/chat-static/_next/static/immutable/chunks/1c3kqwyzatdha.js","/chat-static/_next/static/immutable/chunks/1afvjiubxi20p.js","/chat-static/_next/static/immutable/chunks/1efvyp5ys0qa_.js","/chat-static/_next/static/immutable/chunks/16p-wd29zwtcb.js","/chat-static/_next/static/immutable/chunks/19etlne9fpz8c.js","/chat-static/_next/static/immutable/chunks/25vs-yagbngt2.js","/chat-static/_next/static/immutable/chunks/3uz_m6bi6f-lg.js","/chat-static/_next/static/immutable/chunks/1ukuldvl_7ewm.js","/chat-static/_next/static/immutable/chunks/1j2pv-n41aow7.js","/chat-static/_next/static/immutable/chunks/3all0vilnb92m.js","/chat-static/_next/static/immutable/chunks/0v_w5d6uj-d1p.js","/chat-static/_next/static/immutable/chunks/216nuiz0k8ips.js","/chat-static/_next/static/immutable/chunks/2ktsmvnrpabs_.js","/chat-static/_next/static/immutable/chunks/29mrkgtzx_4wp.js","/chat-static/_next/static/immutable/chunks/04gkop25t1q10.js","/chat-static/_next/static/immutable/chunks/0i0qxxzro3chc.js","/chat-static/_next/static/immutable/chunks/3ozgp_g2qonep.js","/chat-static/_next/static/immutable/chunks/34plql7k-5zln.js","/chat-static/_next/static/immutable/chunks/1_2vxq9xb046f.js","/chat-static/_next/static/immutable/chunks/2x0m84hlfqnp9.js","/chat-static/_next/static/immutable/chunks/0wa14r29vk-50.js","/chat-static/_next/static/immutable/chunks/33yhsbwlge-yd.js","/chat-static/_next/static/immutable/chunks/34-_dn6funmns.js","/chat-static/_next/static/immutable/chunks/3y9uy30_vf_ol.js","/chat-static/_next/static/immutable/chunks/0h3zc71pdnjom.js","/chat-static/_next/static/immutable/chunks/0b9ex5d30islg.js","/chat-static/_next/static/immutable/chunks/1erht42aiso18.js","/chat-static/_next/static/immutable/chunks/30mwco_q1oioj.js","/chat-static/_next/static/immutable/chunks/1cmyat5y1o107.js"],"ExplicitChatIdProvider"] ab:I[838238,["/chat-static/_next/static/immutable/chunks/25sy-cznq5gtk.js","/chat-static/_next/static/immutable/chunks/17kl369b79nmd.js","/chat-static/_next/static/immutable/chunks/3ipxm38dyyb9q.js","/chat-static/_next/static/immutable/chunks/25oa2-cd4babd.js","/chat-static/_next/static/immutable/chunks/1di_td8luy3gw.js","/chat-static/_next/static/immutable/chunks/0_zevym5bobxk.js","/chat-static/_next/static/immutable/chunks/0pa2o-879tgyz.js","/chat-static/_next/static/immutable/chunks/2iyogqj39terz.js","/chat-static/_next/static/immutable/chunks/0vmwjdmzo33vb.js","/chat-static/_next/static/immutable/chunks/3xsyi84us226z.js","/chat-static/_next/static/immutable/chunks/3sd5co-q3j6ji.js","/chat-static/_next/static/immutable/chunks/3b6rwng7jzw37.js","/chat-static/_next/static/immutable/chunks/454vo2w1h6da9.js","/chat-static/_next/static/immutable/chunks/0kpqqt3b70onu.js","/chat-static/_next/static/immutable/chunks/0i48amtc28pqy.js","/chat-static/_next/static/immutable/chunks/0t6ytllohkn0t.js","/chat-static/_next/static/immutable/chunks/17xddrdopbp9_.js","/chat-static/_next/static/immutable/chunks/2dh86ziq4bpa7.js","/chat-static/_next/static/immutable/chunks/33addp8wpisll.js","/chat-static/_next/static/immutable/chunks/0avdeadirr7ac.js","/chat-static/_next/static/immutable/chunks/421be_5xz_yit.js","/chat-static/_next/static/immutable/chunks/2gn4nsrh2z77a.js","/chat-static/_next/static/immutable/chunks/0nc47r7g497qp.js","/chat-static/_next/static/immutable/chunks/1o9d1-74u-xr7.js","/chat-static/_next/static/immutable/chunks/0_zojv1j0yvgz.js","/chat-static/_next/static/immutable/chunks/0dt5xmjm5355d.js","/chat-static/_next/static/immutable/chunks/1c3kqwyzatdha.js","/chat-static/_next/static/immutable/chunks/1afvjiubxi20p.js","/chat-static/_next/static/immutable/chunks/1efvyp5ys0qa_.js","/chat-static/_next/static/immutable/chunks/16p-wd29zwtcb.js","/chat-static/_next/static/immutable/chunks/19etlne9fpz8c.js","/chat-static/_next/static/immutable/chunks/25vs-yagbngt2.js","/chat-static/_next/static/immutable/chunks/3uz_m6bi6f-lg.js","/chat-static/_next/static/immutable/chunks/1ukuldvl_7ewm.js","/chat-static/_next/static/immutable/chunks/1j2pv-n41aow7.js","/chat-static/_next/static/immutable/chunks/3all0vilnb92m.js","/chat-static/_next/static/immutable/chunks/0v_w5d6uj-d1p.js","/chat-static/_next/static/immutable/chunks/216nuiz0k8ips.js","/chat-static/_next/static/immutable/chunks/2ktsmvnrpabs_.js","/chat-static/_next/static/immutable/chunks/29mrkgtzx_4wp.js","/chat-static/_next/static/immutable/chunks/04gkop25t1q10.js","/chat-static/_next/static/immutable/chunks/0i0qxxzro3chc.js","/chat-static/_next/static/immutable/chunks/3ozgp_g2qonep.js","/chat-static/_next/static/immutable/chunks/34plql7k-5zln.js","/chat-static/_next/static/immutable/chunks/1_2vxq9xb046f.js","/chat-static/_next/static/immutable/chunks/2x0m84hlfqnp9.js","/chat-static/_next/static/immutable/chunks/0wa14r29vk-50.js","/chat-static/_next/static/immutable/chunks/33yhsbwlge-yd.js","/chat-static/_next/static/immutable/chunks/34-_dn6funmns.js","/chat-static/_next/static/immutable/chunks/3y9uy30_vf_ol.js","/chat-static/_next/static/immutable/chunks/0h3zc71pdnjom.js","/chat-static/_next/static/immutable/chunks/0b9ex5d30islg.js","/chat-static/_next/static/immutable/chunks/1erht42aiso18.js","/chat-static/_next/static/immutable/chunks/30mwco_q1oioj.js","/chat-static/_next/static/immutable/chunks/1cmyat5y1o107.js"],"SWRDataProvider"] ad:[] ae:[["b_UkGFdJN1Pom",null],["b_zrbXzoo3CaG",null],["b_DSADp5wgxuZ",null]] af:[["b_UkGFdJN1Pom",{"templateVersionId":null,"templateCanonId":null}],["b_zrbXzoo3CaG",{"templateVersionId":null,"templateCanonId":null}],["b_DSADp5wgxuZ",{"templateVersionId":null,"templateCanonId":null}]] b0:[["b_LToeDBeHCRj","$D2025-11-14T07:40:22.624Z"],["b_BLXz810XPSC","$D2025-11-14T08:19:58.323Z"],["b_d1ZURvvdKCU","$D2025-11-14T08:30:02.110Z"],["b_4lWYoBqtCQl","$D2025-11-14T08:46:02.231Z"],["b_UkGFdJN1Pom","$D2025-11-14T09:16:59.103Z"],["b_zrbXzoo3CaG","$D2025-11-14T09:36:19.402Z"],["b_DSADp5wgxuZ","$D2025-11-14T09:40:43.175Z"]] b1:[["b_UkGFdJN1Pom",false],["b_zrbXzoo3CaG",false],["b_DSADp5wgxuZ",false]] b2:[["b_UkGFdJN1Pom","$undefined"],["b_zrbXzoo3CaG","$undefined"],["b_DSADp5wgxuZ",{"git":{"ref":"main","sha":"f63741bd63f4021d55afe70a04f13c69dea5a9c8","type":"github","repoId":0,"repoName":"v0-1-OFrPg1gOowN9S3E79JEgiU8j-cZsc5u06vUf","ownerName":"v0-git-s3-storage","commitMessage":"Initial commit from v0"}}]] b3:[["b_UkGFdJN1Pom",null],["b_zrbXzoo3CaG",null],["b_DSADp5wgxuZ",null]] b4:[["b_UkGFdJN1Pom",true],["b_zrbXzoo3CaG",true],["b_DSADp5wgxuZ",true]] b5:[["b_UkGFdJN1Pom",true],["b_zrbXzoo3CaG",true],["b_DSADp5wgxuZ",true]] b6:[] b7:T805,The user is showing me two images: 1. Stack Auth admin page showing a user "Sujay" with Display name set to "Sujay" - this was manually changed in the admin panel 2. The current sign-up page code The issue is that when users sign up through the form, the username/displayName is not being saved even though the code looks correct. Looking at the current code, I can see: 1. Username is being collected in the form 2. `displayName: username` is being passed to `signUpWithCredential` 3. After signup, `currentUser.update()` is being called with the displayName However, the problem might be: 1. The `signUpWithCredential` response might not be successful or might not be persisting the displayName immediately 2. The `app.getUser()` call after signup might be getting a user object that's not fully synced yet 3. The Stack Auth API might not support setting displayName during signup - it needs to be done as an update AFTER the user exists Let me check the Stack Auth documentation more carefully. The issue is likely that `signUpWithCredential` doesn't accept a `displayName` parameter in the first place, or it's not being processed. The correct approach would be to: 1. Call `signUpWithCredential` with just email and password 2. Then immediately call `update()` on the current user to set the displayName Let me also check if there's an issue with awaiting the update properly or if we need to ensure the user is fully created before updating. Actually, looking more carefully at the code flow - after `signUpWithCredential`, we're calling `app.getUser()` and then updating. But the timeout is only 500ms which might not be enough time for the backend to persist the update before the redirect. The real issue is likely that: 1. `signUpWithCredential` might not support displayName as a parameter 2. The user object returned might not be the full user 3. The update needs to complete and persist before we redirect away from the page I should look into Stack Auth's actual API to understand how displayName gets set during the signup flow.b8:T4d3,The warning is about `NEXT_PUBLIC_STACK_PUBLISHABLE_CLIENT_KEY` being exposed to the client. However, this is actually the **correct and intended behavior** for this environment variable. Let me think about this: 1. **`NEXT_PUBLIC_STACK_PUBLISHABLE_CLIENT_KEY`** - This is intentionally prefixed with `NEXT_PUBLIC_` which means it's designed to be public. This is a publishable key for Stack Auth (similar to Stripe's publishable key or OAuth client IDs). It's meant to be exposed to the client. 2. **`STACK_SECRET_SERVER_KEY`** - This is the actual secret key that should remain server-only. The diagnostic warning is technically a false positive because: - The `NEXT_PUBLIC_` prefix is the Next.js convention for public environment variables - Stack Auth's client SDK **requires** the publishable key on the client side to function - This is the standard and secure pattern for Stack Auth However, I should acknowledge this warning to the user and explain that this is not actually a security risk. The user doesn't need to do anything—this is the correct configuration. The diagnostic system is being overly cautious. This is similar to the previous diagnostics warnings we've seen, so I can give a brief, confident response.b9:T7ced5,[V0_FILE]jpg:file="public/action-manga-cover-with-dramatic-character-pose.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/action-manga-cover-with-dramatic-character-pose-0anBoa2ZOyBbvLSISGofje3OU7fnYS.jpg" isMerged="true" [V0_FILE]jpg:file="public/action-manga-cover-with-red-and-black-theme.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/action-manga-cover-with-red-and-black-theme-u72qmPYW1CG4wKTD0vPeOJ91s9ZdwB.jpg" isMerged="true" [V0_FILE]png:file="public/apple-icon.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/apple-icon-3z2px0lxFOnWpsOcYVlzPJSFInEs9c.png" isMerged="true" [V0_FILE]jpg:file="public/dark-fantasy-demon-sovereign-manga-cover-art.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/dark-fantasy-demon-sovereign-manga-cover-art-PS33VYvRBiNLOw7dUaisbjRjEb3Xuy.jpg" isMerged="true" [V0_FILE]jpg:file="public/dark-fantasy-manga-cover-with-purple-magic.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/dark-fantasy-manga-cover-with-purple-magic-iiOvTfIHlYEWl2MaPe9b5klduWJ716.jpg" isMerged="true" [V0_FILE]jpg:file="public/dark-revenge-manga-cover-art-with-red-accents.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/dark-revenge-manga-cover-art-with-red-accents-VOtpCA0sb9OxrZ3A9aRhzvbYiDcgFN.jpg" isMerged="true" [V0_FILE]jpg:file="public/hero-demon-sovereign.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/hero-demon-sovereign-q4Ha163P8q299nOC0KVBJUgwaW3j9H.jpg" isMerged="true" [V0_FILE]png:file="public/icon-dark-32x32.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/icon-dark-32x32-Em0RJHGhn700XNwNtCOpFIMIjKMLdp.png" isMerged="true" [V0_FILE]png:file="public/icon-light-32x32.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/icon-light-32x32-uE9gS6HXtTwjXGrKVXsywaRNfRVZZU.png" isMerged="true" [V0_FILE]png:file="public/logo-ad.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/logo-ad-CWHmg9W1GZpZASVAhi2U3KjlirmqhI.png" isMerged="true" [V0_FILE]png:file="public/logo.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/logo-RvZONaMyE6jGeabwixGxSJa24of5s2.png" isMerged="true" [V0_FILE]jpg:file="public/manhwa-cover-.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/manhwa-cover--v7voGUOMkJlRuUqu4qBB9AI90S9DWp.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manga-cover-with-blue-and-pink-energy.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manga-cover-with-blue-and-pink-energy-BAZCQrIkFCklJgPg2SlkDaxCbNfEAF.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manga-cover-with-silver-haired-charac.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manga-cover-with-silver-haired-charac-mzRDIxp1roahOKw7OlTcEQA7Fc7s0l.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-chapter-44-page-1.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-chapter-44-page-1-PJGw1n6Fryq1ro5EdnvKZXLPWK1rn1.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-chapter-44-page-2.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-chapter-44-page-2-CDbR6wDxwqMNLipONxscNUAJGUFaqB.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-chapter-44-page-3.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-chapter-44-page-3-S4DQyttyJgWs4sqcAKdUeA2IqYQbQe.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-chapter-44-page-4.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-chapter-44-page-4-FT5UO2ld2UJMz6mma9B5enzHVPOodh.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-chapter-44-page-5.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-chapter-44-page-5-TTA33DKDxSYKsd6RRqtatoQ93XKvGs.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-1-demon-sovereign-awakeni.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-1-demon-sovereign-awakeni-wLOJBDweZLbRmEdu3E1uosZJeyXhIb.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-10-chapter-ending.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-10-chapter-ending-tZxCeOu18DGIkqQAeLA0mQzKKGq1xE.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-2-intense-battle-scene.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-2-intense-battle-scene-dA7sR3Qm3Ij4Kx0Ykd1V2XXiItHub8.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-3-demon-palace-background.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-3-demon-palace-background-Po7mN3dLtaa0E0bmKitYgTdh2xA9l5.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-4-energy-blast-attack.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-4-energy-blast-attack-alVI7Sym85EBIPA2ppq993GGjWEfEp.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-5-character-close-up.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-5-character-close-up-DdwOqjxTXawY0Sa1gQfm19Na7Sp73E.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-6-dramatic-fight-scene.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-6-dramatic-fight-scene-HbxNk9lpjvmwOlGj01tDh8SwZmjpyX.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-7-mystical-powers.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-7-mystical-powers-SH661F4eKaWA3JN5CsBPlI5LuNmC9L.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-8-demon-transformation.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-8-demon-transformation-nG93ykTR5U4IC0jkJ6bdMhyPcAHj74.jpg" isMerged="true" [V0_FILE]jpg:file="public/martial-arts-manhwa-page-9-epic-showdown.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/martial-arts-manhwa-page-9-epic-showdown-PngmTCQHDfQ4SVgpPWu8yfPUBdzhWu.jpg" isMerged="true" [V0_FILE]jpg:file="public/samurai-manga-cover-with-confident-character.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/samurai-manga-cover-with-confident-character-TYorJYAUUMpJ7WPCeQgIu4lHB1n1mX.jpg" isMerged="true" [V0_FILE]jpg:file="public/swordmaster-manga-cover-art-with-katana.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/files-blob/gg-14.11.25-main/public/swordmaster-manga-cover-art-with-katana-bs8tOz5aNuFAhXQhUugI8d0R9uw2xr.jpg" isMerged="true" [V0_FILE]typescript:file="app/actions/auth.ts" isMerged="true" "use server" import { signOut } from "@/lib/auth" import { redirect } from "next/navigation" export async function signOutAction() { await signOut() redirect("/handler/sign-in") } [V0_FILE]typescript:file="app/actions/comic-library.ts" isMerged="true" "use server" import { neon } from "@neondatabase/serverless" import { stackServerApp } from "@/lib/stack-server" const sql = neon(process.env.DATABASE_URL!) type LibraryStatus = "Reading" | "Completed" | "On-Hold" | "Dropped" | "Plan to Read" export async function addComicToLibrary( comicId: string, status: LibraryStatus = "Plan to Read" ) { try { const user = await stackServerApp.getUser() if (!user) { return { success: false, error: "Not authenticated" } } await sql` INSERT INTO user_library (user_id, comic_id, status, added_at) VALUES (${user.id}, ${comicId}, ${status}, NOW()) ON CONFLICT (user_id, comic_id) DO UPDATE SET status = ${status} ` return { success: true, data: { status } } } catch (error) { console.error("[v0] Error adding comic to library:", error) return { success: false, error: "Failed to add comic to library" } } } export async function updateComicStatus( comicId: string, status: LibraryStatus ) { try { const user = await stackServerApp.getUser() if (!user) { return { success: false, error: "Not authenticated" } } await sql` UPDATE user_library SET status = ${status} WHERE user_id = ${user.id} AND comic_id = ${comicId} ` return { success: true, data: { status } } } catch (error) { console.error("[v0] Error updating comic status:", error) return { success: false, error: "Failed to update comic status" } } } export async function removeComicFromLibrary(comicId: string) { try { const user = await stackServerApp.getUser() if (!user) { return { success: false, error: "Not authenticated" } } await sql` DELETE FROM user_library WHERE user_id = ${user.id} AND comic_id = ${comicId} ` return { success: true } } catch (error) { console.error("[v0] Error removing comic from library:", error) return { success: false, error: "Failed to remove comic from library" } } } export async function getComicLibraryStatus(comicId: string) { try { const user = await stackServerApp.getUser() if (!user) { return { success: true, data: null } } const result = await sql` SELECT status FROM user_library WHERE user_id = ${user.id} AND comic_id = ${comicId} LIMIT 1 ` return { success: true, data: result.length > 0 ? result[0] : null } } catch (error) { console.error("[v0] Error fetching comic library status:", error) return { success: true, data: null } } } [V0_FILE]typescript:file="app/actions/featured-comics.ts" isMerged="true" "use server" import { sql } from "@/lib/db" export interface Comic { id: string title: string slug: string cover_image: string | null hero_image: string | null description: string | null is_featured: boolean featured_order: number | null } export async function getFeaturedComics() { try { const comics = await sql` SELECT id, title, slug, cover_image, is_featured, featured_order FROM comics ORDER BY title ASC ` return { success: true, data: comics as Comic[] } } catch (error) { console.error("Error fetching comics:", error) return { success: false, error: "Failed to fetch comics" } } } export async function saveFeaturedComics(featuredComicIds: string[], availableComicIds: string[]) { try { // Update featured comics with their order for (let i = 0; i < featuredComicIds.length; i++) { await sql` UPDATE comics SET is_featured = TRUE, featured_order = ${i} WHERE id = ${featuredComicIds[i]} ` } // Update available comics to not be featured for (const comicId of availableComicIds) { await sql` UPDATE comics SET is_featured = FALSE, featured_order = NULL WHERE id = ${comicId} ` } return { success: true } } catch (error) { console.error("Error saving featured comics:", error) return { success: false, error: "Failed to save changes" } } } export async function getHomeFeaturedComics() { try { const comics = await sql` SELECT id, title, slug, cover_image, hero_image, description, is_featured, featured_order FROM comics WHERE is_featured = TRUE ORDER BY featured_order ASC ` return { success: true, data: comics } } catch (error) { console.error("Error fetching featured comics:", error) return { success: false, error: "Failed to fetch featured comics", data: [] } } } [V0_FILE]typescript:file="app/actions/notices.ts" isMerged="true" "use server" import { sql } from "@/lib/db" import { revalidatePath } from "next/cache" export type NoticePriority = "Low" | "Medium" | "High" export type NoticeIcon = "Info" | "AlertTriangle" | "Megaphone" | "CircleHelp" | "ShieldAlert" | "PartyPopper" export type Notice = { id: string title: string content: string priority: NoticePriority icon: NoticeIcon active: boolean dismissible: boolean title_color?: string content_color?: string background_opacity?: number created_at?: string updated_at?: string } export async function getNotices(): Promise { try { console.log("[v0] Fetching notices from database...") const notices = await sql` SELECT * FROM notices ORDER BY created_at DESC ` console.log("[v0] Fetched notices count:", notices.length) console.log("[v0] Fetched notices:", notices) return notices as Notice[] } catch (error) { console.error("[v0] Error fetching notices:", error) return [] } } export async function createNotice(data: Omit) { try { const id = crypto.randomUUID() await sql` INSERT INTO notices ( id, title, content, priority, icon, active, dismissible, title_color, content_color, background_opacity, created_at, updated_at ) VALUES ( ${id}, ${data.title}, ${data.content}, ${data.priority}, ${data.icon}, ${data.active}, ${data.dismissible}, ${data.title_color || "#FFFFFF"}, ${data.content_color || "#E2E8F0"}, ${data.background_opacity || 1}, NOW() AT TIME ZONE 'Asia/Kolkata', NOW() AT TIME ZONE 'Asia/Kolkata' ) ` revalidatePath("/admin/notices") return { success: true, id } } catch (error) { console.error("[v0] Error creating notice:", error) return { success: false, error: "Failed to create notice" } } } export async function updateNotice(id: string, data: Partial) { try { await sql` UPDATE notices SET title = COALESCE(${data.title}, title), content = COALESCE(${data.content}, content), priority = COALESCE(${data.priority}, priority), icon = COALESCE(${data.icon}, icon), active = COALESCE(${data.active}, active), dismissible = COALESCE(${data.dismissible}, dismissible), title_color = COALESCE(${data.title_color}, title_color), content_color = COALESCE(${data.content_color}, content_color), background_opacity = COALESCE(${data.background_opacity}, background_opacity), updated_at = NOW() AT TIME ZONE 'Asia/Kolkata' WHERE id = ${id} ` revalidatePath("/admin/notices") return { success: true } } catch (error) { console.error("[v0] Error updating notice:", error) return { success: false, error: "Failed to update notice" } } } export async function deleteNotice(id: string) { try { await sql`DELETE FROM notices WHERE id = ${id}` revalidatePath("/admin/notices") return { success: true } } catch (error) { console.error("[v0] Error deleting notice:", error) return { success: false, error: "Failed to delete notice" } } } export async function getActiveNotices(): Promise { try { const notices = await sql` SELECT * FROM notices WHERE active = true ORDER BY CASE priority WHEN 'High' THEN 1 WHEN 'Medium' THEN 2 WHEN 'Low' THEN 3 END, created_at DESC LIMIT 3 ` return notices as Notice[] } catch (error) { console.error("Error fetching active notices:", error) return [] } } [V0_FILE]typescript:file="app/actions/translator-groups.ts" isMerged="true" "use server" import { sql } from "@/lib/db" import { revalidatePath } from "next/cache" export interface TranslatorGroup { id: number name: string description?: string website?: string logo_url?: string active_year?: number active_month?: number | null active_until_year?: number | null active_until_month?: number | null status: string created_at: Date updated_at: Date comics?: number chapters?: number } export async function getTranslatorGroups() { try { const groups = await sql` SELECT tg.id, tg.name, tg.description, tg.website, tg.logo_url, tg.active_year, tg.active_month, tg.active_until_year, tg.active_until_month, tg.status, tg.created_at, tg.updated_at, COUNT(DISTINCT c.id) as comics, COUNT(DISTINCT ch.id) as chapters FROM translator_groups tg LEFT JOIN chapters ch ON ch.translator_group_id = tg.id LEFT JOIN comics c ON c.id = ch.comic_id GROUP BY tg.id, tg.name, tg.description, tg.website, tg.logo_url, tg.active_year, tg.active_month, tg.active_until_year, tg.active_until_month, tg.status, tg.created_at, tg.updated_at ORDER BY tg.created_at DESC ` return groups.map((group) => ({ ...group, comics: Number.parseInt(group.comics as string) || 0, chapters: Number.parseInt(group.chapters as string) || 0, })) as TranslatorGroup[] } catch (error) { console.error("[v0] Error fetching translator groups:", error) return [] } } export async function createTranslatorGroup(data: { name: string description?: string website?: string logo_url?: string active_year?: number active_month?: number | null active_until_year?: number | null active_until_month?: number | null status?: string }) { try { const result = await sql` INSERT INTO translator_groups (name, description, website, logo_url, active_year, active_month, active_until_year, active_until_month, status, created_at, updated_at) VALUES ( ${data.name}, ${data.description || null}, ${data.website || null}, ${data.logo_url || null}, ${data.active_year || null}, ${data.active_month || null}, ${data.active_until_year || null}, ${data.active_until_month || null}, ${data.status || "active"}, NOW() AT TIME ZONE 'Asia/Kolkata', NOW() AT TIME ZONE 'Asia/Kolkata' ) RETURNING * ` revalidatePath("/admin/translator-groups") return { success: true, data: result[0] } } catch (error) { console.error("[v0] Error creating translator group:", error) return { success: false, error: "Failed to create translator group" } } } export async function updateTranslatorGroup( id: number, data: { name?: string description?: string website?: string logo_url?: string active_year?: number active_month?: number | null active_until_year?: number | null active_until_month?: number | null status?: string }, ) { try { const result = await sql` UPDATE translator_groups SET name = COALESCE(${data.name}, name), description = COALESCE(${data.description}, description), website = COALESCE(${data.website}, website), logo_url = COALESCE(${data.logo_url}, logo_url), active_year = COALESCE(${data.active_year}, active_year), active_month = ${data.active_month !== undefined ? data.active_month : sql`active_month`}, active_until_year = ${data.active_until_year !== undefined ? data.active_until_year : sql`active_until_year`}, active_until_month = ${data.active_until_month !== undefined ? data.active_until_month : sql`active_until_month`}, status = COALESCE(${data.status}, status), updated_at = NOW() AT TIME ZONE 'Asia/Kolkata' WHERE id = ${id} RETURNING * ` revalidatePath("/admin/translator-groups") return { success: true, data: result[0] } } catch (error) { console.error("[v0] Error updating translator group:", error) return { success: false, error: "Failed to update translator group" } } } export async function deleteTranslatorGroup(id: number) { try { await sql` DELETE FROM translator_groups WHERE id = ${id} ` revalidatePath("/admin/translator-groups") return { success: true } } catch (error) { console.error("[v0] Error deleting translator group:", error) return { success: false, error: "Failed to delete translator group" } } } [V0_FILE]typescript:file="app/actions/user-profile.ts" isMerged="true" "use server" import { neon } from "@neondatabase/serverless" import { stackServerApp } from "@/lib/stack-server" const sql = neon(process.env.DATABASE_URL!) export async function getUserProfile(userId: string) { try { console.log("[v0] Fetching user profile for:", userId) const user = await stackServerApp.getUser({ userId }) if (!user) { console.log("[v0] User not found in Stack Auth") return { success: false, error: "User not found" } } console.log("[v0] User found:", user.id, user.primaryEmail) return { success: true, data: { id: user.id, email: user.primaryEmail || "", name: user.displayName || user.primaryEmail || "User", created_at: user.createdAt ? user.createdAt.toISOString() : new Date().toISOString(), }, } } catch (error) { console.error("[v0] Error fetching user profile:", error) return { success: false, error: "Failed to fetch user profile" } } } export async function getUserLibrary(userId: string) { try { const library = await sql` SELECT c.id, c.title, c.slug, c.cover_image, c.description, c.rating, c.status as series_status, ul.status as reader_status, ul.added_at, COALESCE( (SELECT MAX(chapter_number) FROM chapters WHERE comic_id = c.id), 0 ) as latest_chapter FROM user_library ul JOIN comics c ON ul.comic_id = c.id WHERE ul.user_id = ${userId} ORDER BY ul.added_at DESC ` return { success: true, data: library } } catch (error) { console.error("[v0] Error fetching user library:", error) return { success: false, error: "Failed to fetch library" } } } export async function getUserReadingHistory(userId: string) { try { const history = await sql` SELECT rh.id, rh.comic_id, rh.last_read_chapter, rh.last_read_at, c.title, c.slug, c.cover_image, COALESCE( (SELECT MAX(chapter_number) FROM chapters WHERE comic_id = c.id), 0 ) as latest_chapter FROM reading_history rh JOIN comics c ON rh.comic_id = c.id WHERE rh.user_id = ${userId} ORDER BY rh.last_read_at DESC LIMIT 50 ` return { success: true, data: history } } catch (error) { console.error("[v0] Error fetching reading history:", error) return { success: false, error: "Failed to fetch reading history" } } } [V0_FILE]typescript:file="app/admin/actions.ts" isMerged="true" "use server" import { sql } from "@/lib/db" // Import SQL scripts as strings const scripts = { "001_create_tables": `-- Comics table - Main comics information CREATE TABLE IF NOT EXISTS comics ( id TEXT PRIMARY KEY, title TEXT NOT NULL, slug TEXT UNIQUE NOT NULL, description TEXT, cover_image TEXT, hero_image TEXT, type TEXT CHECK(type IN ('Manga', 'Manhwa', 'Manhua')), status TEXT CHECK(status IN ('Ongoing', 'Completed', 'Hiatus')), year INTEGER, rating DECIMAL(3, 2), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS alt_titles ( id SERIAL PRIMARY KEY, comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, title TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS authors ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS artists ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS genres ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS themes ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS translator_groups ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS comic_authors ( comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, author_id INTEGER REFERENCES authors(id) ON DELETE CASCADE, PRIMARY KEY (comic_id, author_id) ); CREATE TABLE IF NOT EXISTS comic_artists ( comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, artist_id INTEGER REFERENCES artists(id) ON DELETE CASCADE, PRIMARY KEY (comic_id, artist_id) ); CREATE TABLE IF NOT EXISTS comic_genres ( comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, genre_id INTEGER REFERENCES genres(id) ON DELETE CASCADE, PRIMARY KEY (comic_id, genre_id) ); CREATE TABLE IF NOT EXISTS comic_themes ( comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, theme_id INTEGER REFERENCES themes(id) ON DELETE CASCADE, PRIMARY KEY (comic_id, theme_id) ); CREATE TABLE IF NOT EXISTS chapters ( id TEXT PRIMARY KEY, comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, chapter_number INTEGER NOT NULL, title TEXT, translator_group_id INTEGER REFERENCES translator_groups(id), pages INTEGER, uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UNIQUE(comic_id, chapter_number, translator_group_id) ); CREATE TABLE IF NOT EXISTS user_library ( id SERIAL PRIMARY KEY, user_id TEXT NOT NULL, comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, added_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UNIQUE(user_id, comic_id) ); CREATE TABLE IF NOT EXISTS reading_history ( id SERIAL PRIMARY KEY, user_id TEXT NOT NULL, comic_id TEXT REFERENCES comics(id) ON DELETE CASCADE, chapter_id TEXT REFERENCES chapters(id) ON DELETE CASCADE, last_read_chapter INTEGER, last_read_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UNIQUE(user_id, comic_id) ); CREATE INDEX IF NOT EXISTS idx_comics_slug ON comics(slug); CREATE INDEX IF NOT EXISTS idx_comics_status ON comics(status); CREATE INDEX IF NOT EXISTS idx_comics_updated_at ON comics(updated_at DESC); CREATE INDEX IF NOT EXISTS idx_chapters_comic_id ON chapters(comic_id); CREATE INDEX IF NOT EXISTS idx_chapters_uploaded_at ON chapters(uploaded_at DESC);`, "002_seed_data": `INSERT INTO translator_groups (name) VALUES ('Asura'), ('Vortex Scans'), ('Qi Scans'), ('Red Hook') ON CONFLICT (name) DO NOTHING; INSERT INTO genres (name) VALUES ('Action'), ('Martial Arts'), ('Fantasy'), ('Drama'), ('Adventure'), ('Historical'), ('Wuxia'), ('Comedy'), ('Revenge'), ('Reincarnation'), ('Sci-Fi'), ('School Life'), ('Business'), ('Horror'), ('Regression') ON CONFLICT (name) DO NOTHING; INSERT INTO themes (name) VALUES ('Demonic Path'), ('Power'), ('Revenge'), ('Martial Arts') ON CONFLICT (name) DO NOTHING; INSERT INTO authors (name) VALUES ('Unknown'), ('Kim Kkulppal (작가 김꿀빨)'), ('Biga (비가)'), ('Guem-Gang-Bul-Gae'), ('YC'), ('SAN.G'), ('BK_Moon') ON CONFLICT (name) DO NOTHING; INSERT INTO artists (name) VALUES ('Unknown Artist'), ('Red Hook (레드훅)') ON CONFLICT (name) DO NOTHING; INSERT INTO comics (id, title, slug, description, cover_image, type, status, year, rating, updated_at) VALUES ('1', 'The Great Heavenly Demon Sovereign', 'great-heavenly-demon-sovereign', 'The holy land of the Demonic Path, the ten Demonic Sects. When they combined their strength, the world came to call them Demon Palace. And now, in the holy land of all the world''s demons, a Heavenly Demon awakes... He was a nobleman, a paragon, and a peerless hero who fought against countless enemies to protect the world.', '/martial-arts-manga-cover-with-blue-and-pink-energy.jpg', 'Manhwa', 'Ongoing', 2025, 8.45, NOW() - INTERVAL '2 days') ON CONFLICT (slug) DO NOTHING; INSERT INTO alt_titles (comic_id, title) VALUES ('1', '대천마주'), ('1', 'The Great Demon Lord'); INSERT INTO comics (id, title, slug, description, cover_image, type, status, year, rating, updated_at) VALUES ('3', 'Chronicles of the Lazy Sovereign', 'chronicles-lazy-swordmaster', 'Wi Yeonho, the Radiant Martial Sovereign, is the great martial artist who ended the world''s calamity. He was a nobleman, a paragon, and a peerless hero...', '/samurai-manga-cover-with-confident-character.jpg', 'Manhwa', 'Ongoing', 2025, 8.18, NOW() - INTERVAL '11 days') ON CONFLICT (slug) DO NOTHING; INSERT INTO alt_titles (comic_id, title) VALUES ('3', '태조비록'), ('3', 'The Secret Records of the Supreme'); INSERT INTO comic_authors (comic_id, author_id) VALUES ('1', (SELECT id FROM authors WHERE name = 'Unknown')), ('3', (SELECT id FROM authors WHERE name = 'Kim Kkulppal (작가 김꿀빨)')), ('3', (SELECT id FROM authors WHERE name = 'Biga (비가)')); INSERT INTO comic_artists (comic_id, artist_id) VALUES ('1', (SELECT id FROM artists WHERE name = 'Unknown Artist')), ('3', (SELECT id FROM artists WHERE name = 'Red Hook (레드훅)')); INSERT INTO comic_genres (comic_id, genre_id) VALUES ('1', (SELECT id FROM genres WHERE name = 'Action')), ('1', (SELECT id FROM genres WHERE name = 'Martial Arts')), ('1', (SELECT id FROM genres WHERE name = 'Fantasy')), ('1', (SELECT id FROM genres WHERE name = 'Adventure')), ('3', (SELECT id FROM genres WHERE name = 'Historical')), ('3', (SELECT id FROM genres WHERE name = 'Action')), ('3', (SELECT id FROM genres WHERE name = 'Wuxia')), ('3', (SELECT id FROM genres WHERE name = 'Drama')), ('3', (SELECT id FROM genres WHERE name = 'Fantasy')); INSERT INTO comic_themes (comic_id, theme_id) VALUES ('1', (SELECT id FROM themes WHERE name = 'Demonic Path')), ('1', (SELECT id FROM themes WHERE name = 'Revenge')), ('1', (SELECT id FROM themes WHERE name = 'Power')), ('3', (SELECT id FROM themes WHERE name = 'Martial Arts')); INSERT INTO chapters (id, comic_id, chapter_number, translator_group_id, uploaded_at) VALUES ('ch-1-45', '1', 45, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '2 days'), ('ch-1-44', '1', 44, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '9 days'), ('ch-1-43', '1', 43, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '16 days'), ('ch-1-42', '1', 42, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '23 days'), ('ch-1-41', '1', 41, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '30 days'); INSERT INTO chapters (id, comic_id, chapter_number, translator_group_id, uploaded_at) VALUES ('ch-3-20', '3', 20, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '11 days'), ('ch-3-19', '3', 19, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '18 days'), ('ch-3-18', '3', 18, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '25 days'), ('ch-3-17', '3', 17, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '32 days'), ('ch-3-16', '3', 16, (SELECT id FROM translator_groups WHERE name = 'Asura'), NOW() - INTERVAL '39 days');`, add_featured_fields: `ALTER TABLE comics ADD COLUMN IF NOT EXISTS is_featured BOOLEAN DEFAULT FALSE; ALTER TABLE comics ADD COLUMN IF NOT EXISTS featured_order INTEGER; CREATE INDEX IF NOT EXISTS idx_comics_featured ON comics(is_featured, featured_order);`, create_notices_table: `CREATE TABLE IF NOT EXISTS notices ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title TEXT NOT NULL, content TEXT NOT NULL, priority TEXT NOT NULL CHECK (priority IN ('Low', 'Medium', 'High')), icon TEXT NOT NULL CHECK (icon IN ('Info', 'AlertTriangle', 'Megaphone', 'CircleHelp', 'ShieldAlert', 'PartyPopper')), active BOOLEAN DEFAULT false, dismissible BOOLEAN DEFAULT true, title_color TEXT DEFAULT '#FFFFFF', content_color TEXT DEFAULT '#E2E8F0', background_opacity DECIMAL(3,2) DEFAULT 1.0, created_at TIMESTAMPTZ DEFAULT (NOW() AT TIME ZONE 'Asia/Kolkata'), updated_at TIMESTAMPTZ DEFAULT (NOW() AT TIME ZONE 'Asia/Kolkata') );`, } export type ScriptKey = keyof typeof scripts export interface ScriptInfo { key: ScriptKey name: string description: string } export const availableScripts: ScriptInfo[] = [ { key: "001_create_tables", name: "Create Database Tables", description: "Creates all core tables: comics, chapters, authors, artists, genres, themes, and user data", }, { key: "002_seed_data", name: "Seed Initial Data", description: "Populates database with sample comics, translator groups, genres, and themes", }, { key: "add_featured_fields", name: "Add Featured Fields", description: "Adds is_featured and featured_order columns to comics table", }, { key: "create_notices_table", name: "Create Notices Table", description: "Creates the notices table for site announcements and alerts", }, ] export async function runDatabaseScript(scriptKey: ScriptKey) { try { const script = scripts[scriptKey] if (!script) { return { success: false, error: "Script not found", } } // Execute the SQL script await sql(script) return { success: true, message: `Successfully executed ${scriptKey}`, } } catch (error) { console.error(`Error executing script ${scriptKey}:`, error) return { success: false, error: error instanceof Error ? error.message : "Unknown error occurred", } } } [V0_FILE]typescriptreact:file="app/admin/comics/loading.tsx" isMerged="true" export default function Loading() { return (

) } [V0_FILE]typescriptreact:file="app/admin/comics/page.tsx" isMerged="true" "use client" import { useState, useEffect } from "react" import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table" import { StatusBadge } from "@/components/ui/status-badge" import { Button } from "@/components/ui/button" import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle, DialogTrigger, } from "@/components/ui/dialog" import { AlertDialog, AlertDialogAction, AlertDialogCancel, AlertDialogContent, AlertDialogDescription, AlertDialogFooter, AlertDialogHeader, AlertDialogTitle, } from "@/components/ui/alert-dialog" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Textarea } from "@/components/ui/textarea" import { PlusCircle, X, Search, Loader2, Download, Timer, Eye, Pencil, Trash2, List } from "lucide-react" import type { Comic, ComicStatus, ComicType, ComicOrigin, ComicRelation, TranslatorSource, TranslatorGroup, } from "@/lib/types" import Image from "next/image" import { Select, SelectContent, SelectItem, SelectTrigger, SelectValue } from "@/components/ui/select" import { Popover, PopoverContent, PopoverTrigger } from "@/components/ui/popover" import { ImageUpload } from "@/components/admin/image-upload" import { useToast } from "@/hooks/use-toast" import { fetchMangaDexData } from "@/lib/mangadex" import { useForm, Controller } from "react-hook-form" import { Switch } from "@/components/ui/switch" import { Combobox } from "@/components/ui/combobox" import { slugify } from "@/lib/utils" import { useRouter } from "next/navigation" // import { getComicImageUploadUrl } from "@/lib/r2-upload" const relationTypes: ComicRelation[] = [ "Sequel", "Prequel", "Spin-off", "Shared Universe", "Main Story", "Side Story", "Alternate Version", ] type FormValues = Partial & { coverImage?: string | { imageUrl: string; imageHint: string } heroImage?: string | { imageUrl: string; imageHint: string } } export default function ComicsPage() { const [comics, setComics] = useState([]) const [open, setOpen] = useState(false) const [editingComic, setEditingComic] = useState(null) const [comicToDelete, setComicToDelete] = useState(null) const [coverImageFile, setCoverImageFile] = useState(null) const [heroImageFile, setHeroImageFile] = useState(null) const { toast } = useToast() const [isSaving, setIsSaving] = useState(false) const [isLoading, setIsLoading] = useState(true) // --- State for Search and Related Comics --- const [searchQuery, setSearchQuery] = useState("") const [searchResults, setSearchResults] = useState([]) const [isSearching, setIsSearching] = useState(false) const [relatedComics, setRelatedComics] = useState< { comicId: string; comicTitle: string; relationType: ComicRelation }[] >([]) const [selectedRelationType, setSelectedRelationType] = useState("Sequel") // --- End State for Search and Related Comics --- const translatorGroupsData: TranslatorGroup[] = [ { id: "asura", name: "Asura Scans" }, { id: "vortex", name: "Vortex Scans" }, { id: "qi", name: "Qi Scans" }, ] const [translatorSources, setTranslatorSources] = useState([]) const [newSourceGroup, setNewSourceGroup] = useState<{ id: string; name: string } | null>(null) const [newSourceUrl, setNewSourceUrl] = useState("") const [coverPreviewUrl, setCoverPreviewUrl] = useState("") const [heroPreviewUrl, setHeroPreviewUrl] = useState("") // --- State for MangaDex Import --- const [mangaDexId, setMangaDexId] = useState("") const [isFetchingMangaDex, setIsFetchingMangaDex] = useState(false) // --- End State for MangaDex Import --- const router = useRouter() const [chapterDialogOpen, setChapterDialogOpen] = useState(false) const [selectedComicForChapters, setSelectedComicForChapters] = useState(null) const form = useForm({ defaultValues: { title: "", altTitles: [], description: "", status: "Ongoing", year: undefined, rating: undefined, authors: [], artists: [], genres: [], themes: [], type: "Manhwa", origin: "KR", coverImage: "", heroImage: "", isFeatured: false, commentsDisabled: false, slowModeSeconds: 0, translatorSources: [], }, }) useEffect(() => { console.log("[v0] ComicsPage mounted, fetching comics...") fetchComics() }, []) const fetchComics = async () => { console.log("[v0] fetchComics started") setIsLoading(true) try { const response = await fetch("/api/comics") console.log("[v0] API response:", response.status) if (response.ok) { const data = await response.json() console.log("[v0] Comics fetched:", data.length) setComics(data) } else { console.error("[v0] Failed to fetch comics:", response.statusText) } } catch (error) { console.error("[v0] Error fetching comics:", error) toast({ title: "Error", description: "Failed to load comics", variant: "destructive" }) } finally { setIsLoading(false) console.log("[v0] fetchComics completed") } } useEffect(() => { const handleSearch = async () => { if (searchQuery.trim().length < 2) { setSearchResults([]) return } setIsSearching(true) const filtered = comics.filter( (c) => c.title.toLowerCase().includes(searchQuery.toLowerCase()) && c.id !== editingComic?.id, ) setSearchResults(filtered.slice(0, 5)) setIsSearching(false) } const debounce = setTimeout(handleSearch, 300) return () => clearTimeout(debounce) }, [searchQuery, comics, editingComic]) const handleTypeChange = (value: ComicType) => { form.setValue("type", value) const newOrigin = { Manhwa: "KR", Manga: "JP", Manhua: "CN", }[value] as ComicOrigin form.setValue("origin", newOrigin) } const generateSlug = (title: string) => { if (!title) return "" return title .toLowerCase() .replace(/\s+/g, "-") .replace(/[^\w-]+/g, "") } const handleFormSubmit = async (data: FormValues) => { setIsSaving(true) const title = data.title if (!title) { toast({ title: "Error", description: "Title is required.", variant: "destructive" }) setIsSaving(false) return } const slug = editingComic?.id || generateSlug(title) if (!editingComic) { const comicExists = comics.some((comic) => comic.id === slug) if (comicExists) { toast({ title: "Error", description: "A comic with this slug already exists.", variant: "destructive" }) setIsSaving(false) return } } let coverImageUrl = "" let heroImageUrl = "" try { // Upload cover image if a file was selected if (coverImageFile) { console.log("[v0] Uploading cover image to R2...") // const uploadData = await getComicImageUploadUrl(slug, "cover", coverImageFile.name, coverImageFile.type) // if ("error" in uploadData) { // throw new Error(uploadData.error) // } // // Upload to presigned URL // const uploadResponse = await fetch(uploadData.presignedUrl, { // method: "PUT", // body: coverImageFile, // headers: { // "Content-Type": coverImageFile.type, // }, // }) // if (!uploadResponse.ok) { // throw new Error("Failed to upload cover image to R2") // } coverImageUrl = "/placeholder.svg?height=80&width=64" // Temporary placeholder URL console.log("[v0] Cover uploaded successfully:", coverImageUrl) } else if (typeof data.coverImage === "string") { coverImageUrl = data.coverImage } else if (data.coverImage?.imageUrl) { coverImageUrl = data.coverImage.imageUrl } // Upload hero image if a file was selected if (heroImageFile) { console.log("[v0] Uploading hero image to R2...") // const uploadData = await getComicImageUploadUrl(slug, "hero", heroImageFile.name, heroImageFile.type) // if ("error" in uploadData) { // throw new Error(uploadData.error) // } // // Upload to presigned URL // const uploadResponse = await fetch(uploadData.presignedUrl, { // method: "PUT", // body: heroImageFile, // headers: { // "Content-Type": heroImageFile.type, // }, // }) // if (!uploadResponse.ok) { // throw new Error("Failed to upload hero image to R2") // } heroImageUrl = "/placeholder.svg?height=80&width=64" // Temporary placeholder URL console.log("[v0] Hero uploaded successfully:", heroImageUrl) } else if (typeof data.heroImage === "string") { heroImageUrl = data.heroImage } else if (data.heroImage?.imageUrl) { heroImageUrl = data.heroImage.imageUrl } console.log("[v0] Image upload complete. Cover:", coverImageUrl, "Hero:", heroImageUrl) } catch (error) { console.error("[v0] Error uploading images:", error) toast({ title: "Error", description: error instanceof Error ? error.message : "Failed to upload images", variant: "destructive", }) setIsSaving(false) return } const coverImage = { imageUrl: coverImageUrl, imageHint: "comic cover" } const heroImage = { imageUrl: heroImageUrl, imageHint: "comic hero" } const comicData: any = { ...data, id: slug, slug, coverImage, heroImage, relatedComics: relatedComics.map((rc) => ({ comicId: rc.comicId, relationType: rc.relationType })), translatorSources: translatorSources, } try { if (editingComic) { const response = await fetch(`/api/comics/${slug}`, { method: "PUT", headers: { "Content-Type": "application/json" }, body: JSON.stringify(comicData), }) if (!response.ok) throw new Error("Failed to update comic") toast({ title: "Comic Updated", description: `"${title}" has been successfully updated.` }) } else { const response = await fetch("/api/comics", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify(comicData), }) if (!response.ok) throw new Error("Failed to create comic") toast({ title: "Comic Added", description: `"${title}" has been successfully added.` }) } // Refresh comics list await fetchComics() handleCloseDialog() } catch (error) { console.error("Error saving comic:", error) toast({ title: "Error", description: "Failed to save comic", variant: "destructive" }) } finally { setIsSaving(false) } } const handleOpenDialog = (comic: Comic | null = null) => { if (comic) { setEditingComic(comic) const coverUrl = typeof comic.coverImage === "string" ? comic.coverImage : comic.coverImage?.imageUrl || "" const heroUrl = typeof comic.heroImage === "string" ? comic.heroImage : comic.heroImage?.imageUrl || "" setCoverPreviewUrl(coverUrl) setHeroPreviewUrl(heroUrl) form.reset({ ...comic, coverImage: coverUrl, heroImage: heroUrl, year: comic.year || undefined, rating: comic.rating || undefined, }) if (comic.relatedComics && comics.length > 0) { const populatedRelations = comic.relatedComics .map((rc) => { const relatedComic = comics.find((c) => c.id === rc.comicId) return relatedComic ? { ...rc, comicTitle: relatedComic.title } : null }) .filter(Boolean) as { comicId: string; comicTitle: string; relationType: ComicRelation }[] setRelatedComics(populatedRelations) } else { setRelatedComics([]) } setTranslatorSources(comic.translatorSources || []) } else { setEditingComic(null) setCoverPreviewUrl("") setHeroPreviewUrl("") form.reset({ title: "", altTitles: [], description: "", status: "Ongoing", year: undefined, rating: undefined, authors: [], artists: [], genres: [], themes: [], type: "Manhwa", origin: "KR", coverImage: "", heroImage: "", isFeatured: false, commentsDisabled: false, slowModeSeconds: 0, translatorSources: [], }) setRelatedComics([]) setTranslatorSources([]) } setOpen(true) } const handleCloseDialog = () => { setOpen(false) setEditingComic(null) setCoverImageFile(null) setHeroImageFile(null) setCoverPreviewUrl("") setHeroPreviewUrl("") setRelatedComics([]) setSearchQuery("") setSearchResults([]) setMangaDexId("") setTranslatorSources([]) setNewSourceGroup(null) setNewSourceUrl("") form.reset() } const handleAddRelation = (comic: Comic) => { if (!relatedComics.some((rc) => rc.comicId === comic.id)) { setRelatedComics([ ...relatedComics, { comicId: comic.id, comicTitle: comic.title, relationType: selectedRelationType }, ]) setSearchQuery("") setSearchResults([]) } } const handleRemoveRelation = (comicId: string) => { setRelatedComics(relatedComics.filter((rc) => rc.comicId !== comicId)) } const tlGroupOptions = translatorGroupsData?.map((g) => ({ value: g.id, label: g.name })) || [] const handleAddTranslatorSource = () => { if (newSourceGroup && newSourceUrl.trim() && newSourceUrl.startsWith("http")) { if (!translatorSources.some((ts) => ts.groupName.toLowerCase() === newSourceGroup.name.trim().toLowerCase())) { setTranslatorSources([ ...translatorSources, { groupName: newSourceGroup.name.trim(), url: newSourceUrl.trim() }, ]) setNewSourceGroup(null) setNewSourceUrl("") } else { toast({ title: "Duplicate", description: "This translator group name already exists for this comic.", variant: "destructive", }) } } else { toast({ title: "Invalid Input", description: "Please select a group and provide a valid URL.", variant: "destructive", }) } } const handleRemoveTranslatorSource = (groupName: string) => { setTranslatorSources(translatorSources.filter((ts) => ts.groupName !== groupName)) } const handleDeleteComic = async () => { if (!comicToDelete) return try { const response = await fetch(`/api/comics/${comicToDelete.id}`, { method: "DELETE", }) if (!response.ok) throw new Error("Failed to delete comic") toast({ title: "Comic Deleted", description: `"${comicToDelete.title}" has been removed.` }) await fetchComics() } catch (error) { console.error("Error deleting comic:", error) toast({ title: "Error", description: "Failed to delete comic", variant: "destructive" }) } finally { setComicToDelete(null) } } const handleFetchFromMangaDex = async () => { let idToFetch = mangaDexId if (!idToFetch) { toast({ title: "MangaDex ID required", description: "Please enter a valid MangaDex ID or URL.", variant: "destructive", }) return } const uuidRegex = /([a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-?[a-fA-F0-9]{4}-?[a-fA-F0-9]{12})/ const match = idToFetch.match(uuidRegex) if (match) { idToFetch = match[1] } setIsFetchingMangaDex(true) try { const data = await fetchMangaDexData(idToFetch) if (data) { const coverUrl = typeof data.coverImage === "string" ? data.coverImage : data.coverImage?.imageUrl || "" const heroUrl = typeof data.heroImage === "string" ? data.heroImage : data.heroImage?.imageUrl || "" setCoverPreviewUrl(coverUrl) setHeroPreviewUrl(heroUrl) form.reset({ ...form.getValues(), ...data, coverImage: coverUrl, heroImage: heroUrl, }) toast({ title: "Success", description: "Data fetched from MangaDex." }) } else { toast({ title: "Not Found", description: "Could not find a comic with that ID.", variant: "destructive" }) } } catch (error) { console.error("MangaDex fetch error:", error) toast({ title: "Error", description: "Failed to fetch data from MangaDex.", variant: "destructive" }) } finally { setIsFetchingMangaDex(false) } } const handleViewComic = (comic: Comic) => { router.push(`/comic/${comic.slug}`) } const handleManageChapters = (comic: Comic) => { setSelectedComicForChapters(comic) setChapterDialogOpen(true) } const watchedType = form.watch("type") const watchedOrigin = form.watch("origin") console.log("[v0] Rendering ComicsPage, isLoading:", isLoading, "comics count:", comics.length) if (isLoading) { return (

Loading comics...

) } return (

setSearchQuery(e.target.value)} />