6 Commits

Author SHA1 Message Date
denshooter 7b5fdbd611 refactor: remove snippets feature and n8n project detection
- Remove snippets page, component, API route, Directus types, and setup script
- Remove snippets section from About.tsx (card, modal, state)
- Remove snippets link from 404 page, simplify layout
- Remove n8n Docker event and callback handler workflows (auto project detection)
- Remove Gitea runner setup and deploy scripts
2026-04-09 18:02:21 +02:00
denshooter 8ff17c552b chore: update workflows, messages, and footer 2026-04-09 17:22:56 +02:00
denshooter a958008add fix: remove review truncation and show full reviews; fix telegram-cms workflow bugs
- ReadBooks.tsx: remove line-clamp-3, readMore button, and review modal
- Show full review text inline instead of truncated snippets
- Remove unused AnimatePresence, X import, selectedReview state
- Fix  typo in 6 handler nodes
- Fix Markdown/HTML mix (*text*</b> → <b>text</b>)
- Fix Switch condition syntax (.action → .action)
- Fix position collision (Review Info Handler)
- Hardcode Telegram bot token, fix response handling in Publish Handler
- Add AI-generated questions for .review flow (was .review HC_ID TEXT)
- New .answer command for submitting review answers
- Create/Refine Review: POST new translations if missing instead of skipping
- Remove all substring truncations from Telegram messages
2026-04-09 17:22:23 +02:00
denshooter a36268302c feat: complete telegram cms system with workflows and deployment guide
- Add ULTIMATE-Telegram-CMS-COMPLETE.json with all commands
- Add Docker Event workflows with Gitea integration
- Add comprehensive deployment guide for fresh installs
- Add quick reference and testing checklist
- Include all n8n workflow exports

Commands:
/start, /list, /search, /stats, /preview, /publish, /delete, .review

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-04-02 12:10:07 +02:00
denshooter 9d3e7ad44a feat: add modal for full book reviews with responsive design
- Add modal popup to view complete book reviews
- Click 'Read full review' opens animated modal
- Responsive design optimized for mobile and desktop
- Liquid design system styling with gradients and blur effects
- Modal includes book cover, rating, and full review text
- Close via X button or backdrop click
- Smooth Framer Motion animations
- Clean up old n8n workflow temporary files

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-04-02 01:12:22 +02:00
Copilot d297776c9f feat: Snippets "The Lab" — category filters, search, language badges, code preview, modal keyboard nav (#72)
* fix: pass locale explicitly to Hero and force-dynamic on locale-sensitive API routes

- Hero.tsx: pass locale prop directly to getTranslations instead of
  relying on setRequestLocale async storage, which can be lost during
  Next.js RSC streaming
- book-reviews route: replace revalidate=300 with force-dynamic to
  prevent cached English responses being served to German locale requests
- content/page route: add runtime=nodejs and force-dynamic (was missing
  both, violating CLAUDE.md API route conventions)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* fix: scroll to top on locale switch and remove dashes from hero text

- HeaderClient: track locale prop changes with useRef and call
  window.scrollTo on switch to reliably reset scroll position
- messages/en.json + de.json: replace em dash with comma and remove
  hyphens from Self-Hoster/Full-Stack in hero description

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* Initial plan

* feat: improve Snippets/The Lab UI with category filters, search, language badges and code preview

Agent-Logs-Url: https://github.com/denshooter/portfolio/sessions/4a562022-cad7-4b4f-8bc4-1be022ecbf1e

Co-authored-by: denshooter <44590296+denshooter@users.noreply.github.com>

---------

Co-authored-by: denshooter <dennis@konkol.net>
Co-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>
Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
Co-authored-by: denshooter <44590296+denshooter@users.noreply.github.com>
2026-04-01 14:45:16 +02:00
26 changed files with 1688 additions and 1550 deletions
-109
View File
@@ -1,109 +0,0 @@
"use client";
import React, { useState } from "react";
import { motion, AnimatePresence } from "framer-motion";
import { Snippet } from "@/lib/directus";
import { X, Copy, Check, Hash } from "lucide-react";
export default function SnippetsClient({ initialSnippets }: { initialSnippets: Snippet[] }) {
const [selectedSnippet, setSelectedSnippet] = useState<Snippet | null>(null);
const [copied, setCopied] = useState(false);
const copyToClipboard = (code: string) => {
navigator.clipboard.writeText(code);
setCopied(true);
setTimeout(() => setCopied(false), 2000);
};
return (
<>
<div className="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6 md:gap-8">
{initialSnippets.map((s, i) => (
<motion.button
key={s.id}
initial={{ opacity: 0, y: 20 }}
animate={{ opacity: 1, y: 0 }}
transition={{ delay: i * 0.05 }}
onClick={() => setSelectedSnippet(s)}
className="text-left bg-white dark:bg-stone-900 rounded-[2.5rem] p-10 border border-stone-200/60 dark:border-stone-800/60 shadow-sm hover:shadow-xl hover:border-liquid-purple/40 transition-all group"
>
<div className="flex items-center gap-2 mb-6">
<div className="w-8 h-8 rounded-xl bg-stone-50 dark:bg-stone-800 flex items-center justify-center text-stone-400 group-hover:text-liquid-purple transition-colors">
<Hash size={16} />
</div>
<span className="text-[10px] font-black uppercase tracking-widest text-stone-400">{s.category}</span>
</div>
<h3 className="text-2xl font-black text-stone-900 dark:text-white uppercase tracking-tighter mb-4 group-hover:text-liquid-purple transition-colors">{s.title}</h3>
<p className="text-stone-500 dark:text-stone-400 text-sm line-clamp-2 leading-relaxed">
{s.description}
</p>
</motion.button>
))}
</div>
{/* Snippet Modal */}
<AnimatePresence>
{selectedSnippet && (
<div className="fixed inset-0 z-[100] flex items-center justify-center p-4 md:p-8">
<motion.div
initial={{ opacity: 0 }}
animate={{ opacity: 1 }}
exit={{ opacity: 0 }}
onClick={() => setSelectedSnippet(null)}
className="absolute inset-0 bg-stone-950/60 backdrop-blur-md"
/>
<motion.div
initial={{ opacity: 0, scale: 0.9, y: 20 }}
animate={{ opacity: 1, scale: 1, y: 0 }}
exit={{ opacity: 0, scale: 0.9, y: 20 }}
className="relative w-full max-w-3xl bg-white dark:bg-stone-900 rounded-[2.5rem] shadow-2xl border border-stone-200 dark:border-stone-800 overflow-hidden flex flex-col max-h-[90vh]"
>
<div className="p-8 md:p-10 overflow-y-auto">
<div className="flex justify-between items-start mb-8">
<div>
<p className="text-[10px] font-black uppercase tracking-[0.2em] text-liquid-purple mb-2">{selectedSnippet.category}</p>
<h3 className="text-3xl font-black text-stone-900 dark:text-white uppercase tracking-tighter">{selectedSnippet.title}</h3>
</div>
<button
onClick={() => setSelectedSnippet(null)}
className="p-3 bg-stone-50 dark:bg-stone-800 rounded-full hover:bg-stone-100 dark:hover:bg-stone-700 transition-colors"
>
<X size={20} />
</button>
</div>
<p className="text-stone-600 dark:text-stone-400 mb-8 leading-relaxed">
{selectedSnippet.description}
</p>
<div className="relative group/code">
<div className="absolute top-4 right-4 flex gap-2">
<button
onClick={() => copyToClipboard(selectedSnippet.code)}
className="p-2.5 bg-white/10 backdrop-blur-md hover:bg-white/20 rounded-lg border border-white/10 transition-all text-white"
title="Copy Code"
>
{copied ? <Check size={16} className="text-emerald-400" /> : <Copy size={16} />}
</button>
</div>
<pre className="bg-stone-950 p-6 rounded-2xl overflow-x-auto text-sm font-mono text-stone-300 border border-stone-800 leading-relaxed">
<code>{selectedSnippet.code}</code>
</pre>
</div>
</div>
<div className="p-6 bg-stone-50 dark:bg-stone-800/50 border-t border-stone-100 dark:border-stone-800 text-center">
<button
onClick={() => setSelectedSnippet(null)}
className="text-[10px] font-black uppercase tracking-[0.2em] text-stone-400 hover:text-stone-900 dark:hover:text-white transition-colors"
>
Close Laboratory
</button>
</div>
</motion.div>
</div>
)}
</AnimatePresence>
</>
);
}
-41
View File
@@ -1,41 +0,0 @@
import React from "react";
import { getSnippets } from "@/lib/directus";
import { Terminal, ArrowLeft } from "lucide-react";
import Link from "next/link";
import SnippetsClient from "./SnippetsClient";
export default async function SnippetsPage({ params }: { params: Promise<{ locale: string }> }) {
const { locale } = await params;
const snippets = await getSnippets(100) || [];
return (
<main className="min-h-screen bg-[#fdfcf8] dark:bg-stone-950 py-24 px-6 transition-colors duration-500">
<div className="max-w-7xl mx-auto">
<Link
href={`/${locale}`}
className="inline-flex items-center gap-2 text-[10px] font-black uppercase tracking-[0.3em] text-stone-400 hover:text-stone-900 dark:hover:text-white transition-all mb-12 group"
>
<ArrowLeft size={14} className="group-hover:-translate-x-1 transition-transform" />
Back to Portfolio
</Link>
<header className="mb-20">
<div className="flex items-center gap-4 mb-6">
<div className="w-12 h-12 rounded-2xl bg-stone-900 dark:bg-stone-50 flex items-center justify-center text-white dark:text-stone-900">
<Terminal size={24} />
</div>
<h1 className="text-5xl md:text-8xl font-black tracking-tighter uppercase text-stone-900 dark:text-stone-50">
The Lab<span className="text-liquid-purple">.</span>
</h1>
</div>
<p className="text-xl md:text-2xl font-light text-stone-500 max-w-2xl leading-relaxed">
A collection of technical snippets, configurations, and mental notes from my daily building process.
</p>
</header>
<SnippetsClient initialSnippets={snippets} />
</div>
</main>
);
}
+1 -1
View File
@@ -3,7 +3,7 @@ import { getBookReviews } from '@/lib/directus';
import { checkRateLimit, getClientIp } from '@/lib/auth';
export const runtime = 'nodejs';
export const revalidate = 300;
export const dynamic = 'force-dynamic';
const CACHE_TTL = 300; // 5 minutes
+3
View File
@@ -3,6 +3,9 @@ import { getContentByKey } from "@/lib/content";
import { getContentPage } from "@/lib/directus";
import { richTextToSafeHtml } from "@/lib/richtext";
export const runtime = 'nodejs';
export const dynamic = 'force-dynamic';
const CACHE_TTL = 300; // 5 minutes
export async function GET(request: NextRequest) {
-21
View File
@@ -1,21 +0,0 @@
import { NextRequest, NextResponse } from 'next/server';
import { getSnippets } from '@/lib/directus';
const CACHE_TTL = 300; // 5 minutes
export async function GET(request: NextRequest) {
try {
const { searchParams } = new URL(request.url);
const limit = parseInt(searchParams.get('limit') || '10');
const featured = searchParams.get('featured') === 'true' ? true : undefined;
const snippets = await getSnippets(limit, featured);
return NextResponse.json(
{ snippets: snippets || [] },
{ headers: { 'Cache-Control': `public, s-maxage=${CACHE_TTL}, stale-while-revalidate=${CACHE_TTL * 2}` } }
);
} catch (_error) {
return NextResponse.json({ error: 'Failed to fetch snippets' }, { status: 500 });
}
}
+57 -168
View File
@@ -7,13 +7,13 @@ import dynamic from "next/dynamic";
const RichTextClient = dynamic(() => import("./RichTextClient"), { ssr: false });
import CurrentlyReading from "./CurrentlyReading";
import ReadBooks from "./ReadBooks";
import { motion, AnimatePresence } from "framer-motion";
import { TechStackCategory, TechStackItem, Hobby, Snippet } from "@/lib/directus";
import { motion } from "framer-motion";
import { TechStackCategory, TechStackItem, Hobby } from "@/lib/directus";
import Link from "next/link";
import ActivityFeed from "./ActivityFeed";
import BentoChat from "./BentoChat";
import { Skeleton } from "./ui/Skeleton";
import { LucideIcon, X, Copy, Check } from "lucide-react";
import { LucideIcon } from "lucide-react";
const iconMap: Record<string, LucideIcon> = {
Globe, Server, Code, Wrench, Shield, Activity, Lightbulb, Gamepad2, BookOpen, Tv, Plane, Camera, Stars, Music, Terminal, Cpu
@@ -25,21 +25,17 @@ const About = () => {
const [cmsHtml, setCmsHtml] = useState<string | null>(null);
const [techStack, setTechStack] = useState<TechStackCategory[]>([]);
const [hobbies, setHobbies] = useState<Hobby[]>([]);
const [snippets, setSnippets] = useState<Snippet[]>([]);
const [selectedSnippet, setSelectedSnippet] = useState<Snippet | null>(null);
const [copied, setCopied] = useState(false);
const [_cmsMessages, setCmsMessages] = useState<Record<string, string>>({});
const [isLoading, setIsLoading] = useState(true);
useEffect(() => {
const fetchData = async () => {
try {
const [cmsRes, techRes, hobbiesRes, msgRes, snippetsRes] = await Promise.all([
const [cmsRes, techRes, hobbiesRes, msgRes] = await Promise.all([
fetch(`/api/content/page?key=home-about&locale=${locale}`),
fetch(`/api/tech-stack?locale=${locale}`),
fetch(`/api/hobbies?locale=${locale}`),
fetch(`/api/messages?locale=${locale}`),
fetch(`/api/snippets?limit=3&featured=true`)
fetch(`/api/messages?locale=${locale}`)
]);
const cmsData = await cmsRes.json();
@@ -53,9 +49,6 @@ const About = () => {
const msgData = await msgRes.json();
if (msgData?.messages) setCmsMessages(msgData.messages);
const snippetsData = await snippetsRes.json();
if (snippetsData?.snippets) setSnippets(snippetsData.snippets);
} catch (error) {
console.error("About data fetch failed:", error);
} finally {
@@ -65,12 +58,6 @@ const About = () => {
fetchData();
}, [locale]);
const copyToClipboard = (code: string) => {
navigator.clipboard.writeText(code);
setCopied(true);
setTimeout(() => setCopied(false), 2000);
};
return (
<section id="about" className="py-16 sm:py-24 md:py-32 px-4 sm:px-6 bg-[#fdfcf8] dark:bg-stone-950 transition-colors duration-500">
<div className="max-w-7xl mx-auto">
@@ -169,96 +156,61 @@ const About = () => {
</div>
</motion.div>
{/* 5. Library, Gear & Snippets */}
<div className="md:col-span-12 grid grid-cols-1 lg:grid-cols-12 gap-4 sm:gap-6 md:gap-8">
{/* Library - Larger Span */}
<motion.div
transition={{ delay: 0.4 }}
className="lg:col-span-7 bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-10 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex flex-col group overflow-hidden relative min-h-[350px] sm:min-h-[400px] md:min-h-[500px]"
>
<div className="relative z-10 flex flex-col h-full">
<div className="flex justify-between items-center mb-6 sm:mb-8 md:mb-10">
<h3 className="text-xl sm:text-2xl font-black text-stone-900 dark:text-stone-50 flex items-center gap-2 sm:gap-3 uppercase tracking-tighter">
<BookOpen className="text-liquid-purple" size={24} /> Library
</h3>
<Link href={`/${locale}/books`} className="group/link flex items-center gap-2 text-stone-900 dark:text-stone-100 font-black border-b-2 border-stone-900 dark:border-stone-100 pb-1 hover:opacity-70 transition-all">
View All <ArrowRight size={14} className="group-hover/link:translate-x-1 transition-transform" />
</Link>
</div>
<CurrentlyReading />
<div className="mt-6 flex-1">
<ReadBooks />
{/* 5. Library */}
<motion.div
transition={{ delay: 0.4 }}
className="md:col-span-7 bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-10 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex flex-col group overflow-hidden relative min-h-[350px] sm:min-h-[400px] md:min-h-[500px]"
>
<div className="relative z-10 flex flex-col h-full">
<div className="flex justify-between items-center mb-6 sm:mb-8 md:mb-10">
<h3 className="text-xl sm:text-2xl font-black text-stone-900 dark:text-stone-50 flex items-center gap-2 sm:gap-3 uppercase tracking-tighter">
<BookOpen className="text-liquid-purple" size={24} /> Library
</h3>
<Link href={`/${locale}/books`} className="group/link flex items-center gap-2 text-stone-900 dark:text-stone-100 font-black border-b-2 border-stone-900 dark:border-stone-100 pb-1 hover:opacity-70 transition-all">
View All <ArrowRight size={14} className="group-hover/link:translate-x-1 transition-transform" />
</Link>
</div>
<CurrentlyReading />
<div className="mt-6 flex-1">
<ReadBooks />
</div>
</div>
</motion.div>
{/* 6. My Gear */}
<motion.div
transition={{ delay: 0.5 }}
className="md:col-span-5 flex flex-col gap-4 sm:gap-6 md:gap-8"
>
<div className="flex-1 bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-10 border border-stone-800 shadow-2xl text-white relative overflow-hidden group">
<div className="relative z-10">
<h3 className="text-xl sm:text-2xl font-black mb-5 sm:mb-8 flex items-center gap-2 sm:gap-3 uppercase tracking-tighter text-white">
<Cpu className="text-liquid-mint" size={24} /> My Gear
</h3>
<div className="grid grid-cols-2 gap-4 sm:gap-6">
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">Main</p>
<p className="text-sm font-bold text-stone-100">MacBook M4 Pro</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">PC</p>
<p className="text-sm font-bold text-stone-100">RTX 3080 / R7</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">Server</p>
<p className="text-sm font-bold text-stone-100">IONOS & RPi 4</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">OS</p>
<p className="text-sm font-bold text-stone-100">macOS / Linux</p>
</div>
</div>
</div>
</motion.div>
<div className="lg:col-span-5 flex flex-col gap-4 sm:gap-6 md:gap-8">
{/* My Gear (Uses) */}
<motion.div
transition={{ delay: 0.5 }}
className="bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-10 border border-stone-800 shadow-2xl text-white relative overflow-hidden group flex-1"
>
<div className="relative z-10">
<h3 className="text-xl sm:text-2xl font-black mb-5 sm:mb-8 flex items-center gap-2 sm:gap-3 uppercase tracking-tighter text-white">
<Cpu className="text-liquid-mint" size={24} /> My Gear
</h3>
<div className="grid grid-cols-2 gap-4 sm:gap-6">
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">Main</p>
<p className="text-sm font-bold text-stone-100">MacBook M4 Pro</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">PC</p>
<p className="text-sm font-bold text-stone-100">RTX 3080 / R7</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">Server</p>
<p className="text-sm font-bold text-stone-100">IONOS & RPi 4</p>
</div>
<div className="space-y-1">
<p className="text-[9px] font-black uppercase tracking-widest text-stone-400">OS</p>
<p className="text-sm font-bold text-stone-100">macOS / Linux</p>
</div>
</div>
</div>
<div className="absolute bottom-0 right-0 w-32 h-32 bg-liquid-mint/10 blur-3xl rounded-full -mr-16 -mb-16" />
</motion.div>
<motion.div
transition={{ delay: 0.6 }}
className="bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-10 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex flex-col justify-between group overflow-hidden relative flex-1"
>
<div className="relative z-10">
<h3 className="text-xl sm:text-2xl font-black text-stone-900 dark:text-stone-50 flex items-center gap-2 sm:gap-3 uppercase tracking-tighter mb-4 sm:mb-6">
<Terminal className="text-liquid-purple" size={24} /> Snippets
</h3>
<div className="space-y-3">
{isLoading ? (
Array.from({ length: 2 }).map((_, i) => <Skeleton key={i} className="h-12 rounded-xl" />)
) : snippets.length > 0 ? (
snippets.map((s) => (
<button
key={s.id}
onClick={() => setSelectedSnippet(s)}
className="w-full text-left p-3 bg-stone-50 dark:bg-stone-800 rounded-xl border border-stone-100 dark:border-stone-700 hover:border-liquid-purple transition-all group/s"
>
<p className="text-[9px] font-black uppercase tracking-widest text-stone-600 dark:text-stone-400 mb-0.5 group-hover/s:text-liquid-purple transition-colors">{s.category}</p>
<p className="text-xs font-bold text-stone-800 dark:text-stone-200">{s.title}</p>
</button>
))
) : (
<p className="text-xs text-stone-500 dark:text-stone-400 italic">No snippets yet.</p>
)}
</div>
</div>
<Link href={`/${locale}/snippets`} className="mt-6 group/btn inline-flex items-center gap-2 text-[10px] font-black uppercase tracking-widest text-stone-600 dark:text-stone-400 hover:text-stone-900 dark:hover:text-white transition-colors">
Enter the Lab <ArrowRight size={12} className="group-hover/btn:translate-x-1 transition-transform" />
</Link>
</motion.div>
<div className="absolute bottom-0 right-0 w-32 h-32 bg-liquid-mint/10 blur-3xl rounded-full -mr-16 -mb-16" />
</div>
</div>
</motion.div>
{/* 6. Hobbies */}
{/* 7. Hobbies */}
<motion.div
transition={{ delay: 0.5 }}
className="md:col-span-12"
@@ -293,71 +245,8 @@ const About = () => {
</div>
</div>
{/* Snippet Modal */}
<AnimatePresence>
{selectedSnippet && (
<div className="fixed inset-0 z-[100] flex items-center justify-center p-4 md:p-8">
<motion.div
initial={{ opacity: 0 }}
animate={{ opacity: 1 }}
exit={{ opacity: 0 }}
onClick={() => setSelectedSnippet(null)}
className="absolute inset-0 bg-stone-950/60 backdrop-blur-md"
/>
<motion.div
initial={{ opacity: 0, scale: 0.9, y: 20 }}
animate={{ opacity: 1, scale: 1, y: 0 }}
exit={{ opacity: 0, scale: 0.9, y: 20 }}
className="relative w-full max-w-3xl bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] shadow-2xl border border-stone-200 dark:border-stone-800 overflow-hidden flex flex-col max-h-[90vh]"
>
<div className="p-5 sm:p-8 md:p-10 overflow-y-auto">
<div className="flex justify-between items-start mb-5 sm:mb-8">
<div>
<p className="text-[10px] font-black uppercase tracking-[0.2em] text-liquid-purple mb-1 sm:mb-2">{selectedSnippet.category}</p>
<h3 className="text-xl sm:text-2xl md:text-3xl font-black text-stone-900 dark:text-white uppercase tracking-tighter">{selectedSnippet.title}</h3>
</div>
<button
onClick={() => setSelectedSnippet(null)}
className="p-3 bg-stone-50 dark:bg-stone-800 rounded-full hover:bg-stone-100 dark:hover:bg-stone-700 transition-colors"
>
<X size={20} />
</button>
</div>
<p className="text-sm sm:text-base text-stone-600 dark:text-stone-400 mb-5 sm:mb-8 leading-relaxed">
{selectedSnippet.description}
</p>
<div className="relative group/code">
<div className="absolute top-3 right-3 sm:top-4 sm:right-4 flex gap-2">
<button
onClick={() => copyToClipboard(selectedSnippet.code)}
className="p-2 sm:p-2.5 bg-white/10 backdrop-blur-md hover:bg-white/20 rounded-lg border border-white/10 transition-all text-white"
title="Copy Code"
>
{copied ? <Check size={16} className="text-emerald-400" /> : <Copy size={16} />}
</button>
</div>
<pre className="bg-stone-950 p-4 sm:p-6 rounded-xl sm:rounded-2xl overflow-x-auto text-xs sm:text-sm font-mono text-stone-300 border border-stone-800 leading-relaxed">
<code>{selectedSnippet.code}</code>
</pre>
</div>
</div>
<div className="p-6 bg-stone-50 dark:bg-stone-800/50 border-t border-stone-100 dark:border-stone-800 text-center">
<button
onClick={() => setSelectedSnippet(null)}
className="text-[10px] font-black uppercase tracking-[0.2em] text-stone-600 dark:text-stone-400 hover:text-stone-900 dark:hover:text-white transition-colors"
>
Close Laboratory
</button>
</div>
</motion.div>
</div>
)}
</AnimatePresence>
</section>
);
};
export default About;
export default About;
+8 -3
View File
@@ -64,9 +64,14 @@ const Footer = () => {
{/* Bottom Bar */}
<div className="mt-10 sm:mt-16 md:mt-20 pt-6 sm:pt-8 border-t border-stone-100 dark:border-stone-900 flex flex-col md:flex-row justify-between items-center gap-4">
<p className="text-[10px] font-bold text-stone-600 dark:text-stone-400 uppercase tracking-widest">
Built with Next.js, Directus & Passion.
</p>
<div className="flex flex-col gap-1">
<p className="text-[10px] font-bold text-stone-600 dark:text-stone-400 uppercase tracking-widest">
Built with Next.js, Directus & Passion.
</p>
<p className="text-[10px] text-stone-400 dark:text-stone-600 tracking-wide">
{t("aiDisclaimer")}
</p>
</div>
<div className="flex items-center gap-2">
<div className="w-2 h-2 rounded-full bg-green-500 animate-pulse" />
<span className="text-[10px] font-bold text-stone-600 dark:text-stone-400 uppercase tracking-widest">Systems Online</span>
+9 -1
View File
@@ -1,6 +1,6 @@
"use client";
import { useState, useEffect } from "react";
import { useState, useEffect, useRef } from "react";
import { SiGithub, SiLinkedin } from "react-icons/si";
import Link from "next/link";
import { usePathname, useSearchParams } from "next/navigation";
@@ -27,6 +27,14 @@ export default function HeaderClient({ locale, translations }: HeaderClientProps
const [scrolled, setScrolled] = useState(false);
const pathname = usePathname();
const searchParams = useSearchParams();
const prevLocale = useRef(locale);
useEffect(() => {
if (prevLocale.current !== locale) {
window.scrollTo({ top: 0, behavior: "instant" });
prevLocale.current = locale;
}
}, [locale]);
const isHome = pathname === `/${locale}` || pathname === `/${locale}/`;
+2 -2
View File
@@ -5,8 +5,8 @@ interface HeroProps {
locale: string;
}
export default async function Hero({ locale: _locale }: HeroProps) {
const t = await getTranslations("home.hero");
export default async function Hero({ locale }: HeroProps) {
const t = await getTranslations({ locale, namespace: "home.hero" });
return (
<section className="relative min-h-screen flex flex-col items-center justify-center bg-stone-50 dark:bg-stone-950 px-6 transition-colors duration-500">
+3 -1
View File
@@ -198,7 +198,7 @@ const ReadBooks = () => {
{/* Review Text (Optional) */}
{review.review && (
<p className="text-sm text-stone-700 dark:text-stone-300 leading-relaxed line-clamp-3 italic">
<p className="text-sm text-stone-700 dark:text-stone-300 leading-relaxed italic">
&ldquo;{stripHtml(review.review)}&rdquo;
</p>
)}
@@ -239,6 +239,8 @@ const ReadBooks = () => {
)}
</motion.button>
)}
</div>
);
};
+22 -45
View File
@@ -1,7 +1,7 @@
"use client";
import { motion } from "framer-motion";
import { ArrowLeft, Search, Terminal } from "lucide-react";
import { ArrowLeft, Search } from "lucide-react";
import Link from "next/link";
import { useRouter } from "next/navigation";
import { useEffect, useState } from "react";
@@ -25,7 +25,7 @@ export default function NotFound() {
<motion.div
initial={{ opacity: 0, y: 30 }}
animate={{ opacity: 1, y: 0 }}
className="md:col-span-12 lg:col-span-8 bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-16 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex flex-col justify-between min-h-[300px] sm:min-h-[400px]"
className="md:col-span-12 bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] md:rounded-[3rem] p-6 sm:p-8 md:p-16 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex flex-col justify-between min-h-[300px] sm:min-h-[400px]"
>
<div>
<div className="flex items-center gap-3 mb-6 sm:mb-8 md:mb-12">
@@ -58,52 +58,29 @@ export default function NotFound() {
</div>
</motion.div>
{/* Sidebar Cards */}
<div className="md:col-span-12 lg:col-span-4 flex flex-col gap-4 sm:gap-6">
{/* Search/Explore Projects */}
<motion.div
initial={{ opacity: 0, x: 20 }}
animate={{ opacity: 1, x: 0 }}
transition={{ delay: 0.1 }}
className="bg-stone-900 rounded-2xl sm:rounded-[2.5rem] p-6 sm:p-8 md:p-10 border border-stone-800 shadow-2xl text-white relative overflow-hidden group flex-1 flex flex-col justify-between"
{/* Explore Work Card */}
<motion.div
initial={{ opacity: 0, x: 20 }}
animate={{ opacity: 1, x: 0 }}
transition={{ delay: 0.1 }}
className="md:col-span-12 bg-stone-900 rounded-2xl sm:rounded-[2.5rem] p-6 sm:p-8 md:p-10 border border-stone-800 shadow-2xl text-white relative overflow-hidden group flex flex-col justify-between min-h-[200px]"
>
<div className="relative z-10">
<Search className="text-liquid-mint mb-4 sm:mb-6" size={28} />
<h3 className="text-xl sm:text-2xl font-black uppercase tracking-tighter mb-1 sm:mb-2">Explore Work</h3>
<p className="text-stone-400 text-sm font-medium">Maybe what you need is in my project archive?</p>
</div>
<Link
href="/projects"
className="mt-5 sm:mt-8 inline-flex items-center gap-2 text-[10px] font-black uppercase tracking-widest text-liquid-mint group-hover:gap-4 transition-all"
>
<div className="relative z-10">
<Search className="text-liquid-mint mb-4 sm:mb-6" size={28} />
<h3 className="text-xl sm:text-2xl font-black uppercase tracking-tighter mb-1 sm:mb-2">Explore Work</h3>
<p className="text-stone-400 text-sm font-medium">Maybe what you need is in my project archive?</p>
</div>
<Link
href="/projects"
className="mt-5 sm:mt-8 inline-flex items-center gap-2 text-[10px] font-black uppercase tracking-widest text-liquid-mint group-hover:gap-4 transition-all"
>
View Projects <ArrowLeft className="rotate-180" size={14} />
</Link>
<div className="absolute top-0 right-0 w-32 h-32 bg-liquid-mint/5 blur-3xl rounded-full -mr-16 -mt-16" />
</motion.div>
{/* Visit the Lab */}
<motion.div
initial={{ opacity: 0, x: 20 }}
animate={{ opacity: 1, x: 0 }}
transition={{ delay: 0.2 }}
className="bg-white dark:bg-stone-900 rounded-2xl sm:rounded-[2.5rem] p-6 sm:p-8 md:p-10 border border-stone-200/60 dark:border-stone-800/60 shadow-sm flex-1 flex flex-col justify-between group"
>
<div className="relative z-10">
<Terminal className="text-liquid-purple mb-4 sm:mb-6" size={28} />
<h3 className="text-xl sm:text-2xl font-black uppercase tracking-tighter mb-1 sm:mb-2 text-stone-900 dark:text-stone-50">Technical</h3>
<p className="text-stone-500 dark:text-stone-400 text-sm font-medium">Check out my collection of code snippets and notes.</p>
</div>
<Link
href="/snippets"
className="mt-8 inline-flex items-center gap-2 text-[10px] font-black uppercase tracking-widest text-stone-400 hover:text-stone-900 dark:hover:text-white transition-colors"
>
Enter the Lab <ArrowLeft className="rotate-180" size={14} />
</Link>
</motion.div>
</div>
View Projects <ArrowLeft className="rotate-180" size={14} />
</Link>
<div className="absolute top-0 right-0 w-32 h-32 bg-liquid-mint/5 blur-3xl rounded-full -mr-16 -mt-16" />
</motion.div>
</div>
</div>
</main>
);
}
}
-57
View File
@@ -937,63 +937,6 @@ export async function getProjectBySlug(
}
}
// Snippets Types
export interface Snippet {
id: string;
title: string;
category: string;
code: string;
description: string;
language: string;
}
/**
* Get Snippets from Directus
*/
export async function getSnippets(limit = 10, featured?: boolean): Promise<Snippet[] | null> {
const filters = ['status: { _eq: "published" }'];
if (featured !== undefined) {
filters.push(`featured: { _eq: ${featured} }`);
}
const filterString = `filter: { _and: [{ ${filters.join(' }, { ')} }] }`;
const query = `
query {
snippets(
${filterString}
limit: ${limit}
) {
id
title
category
code
description
language
}
}
`;
try {
const result = await directusRequest(
'',
{ body: { query } }
);
interface SnippetsResult {
snippets: Snippet[];
}
const snippets = (result as SnippetsResult | null)?.snippets;
if (!snippets || snippets.length === 0) {
return null;
}
return snippets;
} catch (_error) {
console.error('Failed to fetch snippets:', _error);
return null;
}
}
// ─── Hardcover → Directus sync helpers ───────────────────────────────────────
export interface BookReviewCreate {
+3 -2
View File
@@ -34,7 +34,7 @@
"f2": "Docker Swarm & CI/CD",
"f3": "Self-Hosted Infrastruktur"
},
"description": "Ich bin Dennis Student aus Osnabrück und leidenschaftlicher Self-Hoster. Ich entwickle Full-Stack Apps und sorge am liebsten selbst dafür, dass sie auf meiner eigenen Infrastruktur perfekt laufen.",
"description": "Ich bin Dennis, Student aus Osnabrück und leidenschaftlicher Selfhoster. Ich entwickle Fullstack Apps und sorge am liebsten selbst dafür, dass sie auf meiner eigenen Infrastruktur perfekt laufen.",
"ctaWork": "Meine Projekte",
"ctaContact": "Kontakt"
},
@@ -157,6 +157,7 @@
"privacyPolicy": "Datenschutz",
"privacySettings": "Datenschutz-Einstellungen",
"privacySettingsTitle": "Datenschutz-Banner wieder anzeigen",
"builtWith": "Built with"
"builtWith": "Built with",
"aiDisclaimer": "Einige Inhalte dieser Seite können KI-generiert sein."
}
}
+3 -2
View File
@@ -35,7 +35,7 @@
"f2": "Docker Swarm & CI/CD",
"f3": "Self-Hosted Infrastructure"
},
"description": "I'm Dennis a student from Germany and a passionate self-hoster. I build full-stack applications and love the challenge of managing the infrastructure they run on.",
"description": "I'm Dennis, a student from Germany and a passionate selfhoster. I build fullstack applications and love the challenge of managing the infrastructure they run on.",
"ctaWork": "View Projects",
"ctaContact": "Get in touch"
},
@@ -160,7 +160,8 @@
"privacyPolicy": "Privacy policy",
"privacySettings": "Privacy settings",
"privacySettingsTitle": "Show privacy settings banner again",
"builtWith": "Built with"
"builtWith": "Built with",
"aiDisclaimer": "Some content on this site may be AI-assisted."
}
}
+219
View File
@@ -0,0 +1,219 @@
{
"name": "Book Review",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 19
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
0,
-192
],
"id": "f0c86dde-aa19-4440-b17c-c572b582da5e",
"name": "Schedule Trigger"
},
{
"parameters": {
"method": "POST",
"url": "https://api.hardcover.app/v1/graphql",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "httpBearerAuth",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "content-type",
"value": "application/json"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "query",
"value": "query GetFinishedBooks { me { user_books(where: {status_id: {_eq: 3}}, limit: 5) { book { id title contributions { author { name } } images { url } } last_read_date updated_at } } }"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.4,
"position": [
224,
-192
],
"id": "e5c28f64-29ed-40ae-804e-896c10f3bc58",
"name": "HTTP Request",
"credentials": {
"httpBearerAuth": {
"id": "Kmf2fBCFkuRuWWZa",
"name": "Hardcover"
}
}
},
{
"parameters": {
"jsCode": "const responseData = $input.first().json;\nconst meData = responseData?.data?.me;\nconst userBooks =\n (Array.isArray(meData) && meData[0]?.user_books) || meData?.user_books || [];\n\nconst newBooks = [];\n\nfor (const ub of userBooks) {\n const check = await this.helpers.httpRequest({\n method: \"GET\",\n url:\n \"https://cms.dk0.dev/items/book_reviews?filter[hardcover_id][_eq]=\" +\n ub.book.id +\n \"&fields=id,translations.id&limit=1\",\n headers: {\n Authorization: \"Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB\",\n },\n });\n\n const existing = check.data?.[0];\n const hasReview =\n existing && existing.translations && existing.translations.length > 0;\n\n if (!hasReview) {\n newBooks.push({\n json: {\n hardcover_id: String(ub.book.id),\n directus_id: existing ? existing.id : null,\n title: ub.book.title,\n author: ub.book.contributions?.[0]?.author?.name ?? \"Unknown\",\n image: ub.book.images?.[0]?.url ?? null,\n finished_at: ub.last_read_date ?? ub.updated_at ?? null,\n already_in_directus: !!existing,\n },\n });\n }\n}\n\nreturn newBooks.length > 0 ? newBooks[0] : [{ json: { skip: true } }];\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
448,
-192
],
"id": "60380362-e954-40ee-b0d0-7bc1edbaf9d3",
"name": "Filter books"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"id": "b356ade3-5cf0-40dd-bb47-e977f354e803",
"leftValue": "={{ $json.skip }}",
"rightValue": "={{ $json.skip }}",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.3,
"position": [
672,
-192
],
"id": "45f65c65-ae6a-46b0-9d96-46f0a32e59db",
"name": "If"
},
{
"parameters": {
"jsCode": "const book = $input.first().json;\nif (book.skip) return [{ json: { skip: true } }];\n\nconst parts = [];\nparts.push(\"Du hilfst jemandem eine Buchbewertung zu schreiben.\");\nparts.push(\"Das Buch ist \" + book.title + \" von \" + book.author + \".\");\nparts.push(\"Erstelle 4 kurze spezifische Fragen zum Buch.\");\nparts.push(\"Die Fragen sollen helfen eine Review zu schreiben.\");\nparts.push(\"Frage auf Deutsch.\");\nparts.push(\"Antworte NUR als JSON Array mit 4 Strings. Verwende keine Bindestriche, Em-Dashes oder Gedankenstriche (, —, -).\");\nconst prompt = parts.join(\" \");\n\nconst aiResponse = await this.helpers.httpRequest({\n method: \"POST\",\n url: \"https://openrouter.ai/api/v1/chat/completions\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: \"Bearer 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\",\n },\n body: {\n model: \"openrouter/free\",\n messages: [{ role: \"user\", content: prompt }],\n },\n});\n\nconst aiText = aiResponse.choices?.[0]?.message?.content ?? \"[]\";\nconst match = aiText.match(/\\[[\\s\\S]*\\]/);\n\nconst f1 = \"Wie hat dir das Buch gefallen?\";\nconst f2 = \"Was war der beste Teil?\";\nconst f3 = \"Was hast du mitgenommen?\";\nconst f4 = \"Wem empfiehlst du es?\";\nconst fallback = [f1, f2, f3, f4];\n\nconst questions = match ? JSON.parse(match[0]) : fallback;\n\nreturn [{ json: { ...book, questions } }];\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
896,
-192
],
"id": "b56ab681-90d8-4376-9408-dc3302ab55bd",
"name": "ai"
},
{
"parameters": {
"chatId": "145931600",
"text": "={{ '📚 ' + $json.title + ' von ' + $json.author + '\\n\\nBeantworte bitte:\\n\\n1. ' + $json.questions[0] + '\\n2. ' + $json.questions[1] + '\\n3. ' + $json.questions[2] + '\\n4. ' + $json.questions[3] + '\\n\\n⭐ Bewertung (1-5)?\\n\\nAntworte so (kopiere und ergänze):\\n\\n/review' + $json.hardcover_id + ' Hier deine Antworten als Text' }}",
"additionalFields": {}
},
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.2,
"position": [
1136,
-208
],
"id": "13087afe-8a1d-457f-a1f1-e0aa64fc0e26",
"name": "Send a text message",
"webhookId": "eaa44b55-b3b1-4747-9b6a-dfc920910b4b",
"credentials": {
"telegramApi": {
"id": "ADurvy9EKUDzbDdq",
"name": "DK0_Server"
}
}
}
],
"pinData": {},
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Filter books",
"type": "main",
"index": 0
}
]
]
},
"Filter books": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[],
[
{
"node": "ai",
"type": "main",
"index": 0
}
]
]
},
"ai": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate",
"availableInMCP": false
},
"versionId": "4c605d70-0428-4611-9ad8-d9452c2660a7",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "cb28e4db755465d5826da179e87f69603d81f833414cc52c327be9183a217b8d"
},
"id": "FDQ5Qmk9POy4Ajdd",
"tags": []
}
+141
View File
@@ -0,0 +1,141 @@
{
"name": "reading",
"nodes": [
{
"parameters": {
"path": "/hardcover/currently-reading",
"responseMode": "responseNode",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
0,
0
],
"id": "3e611a99-cbf7-48a6-b75b-f136ac76055f",
"name": "Webhook",
"webhookId": "02c226fd-2d1a-450c-9941-ff438dc5c987"
},
{
"parameters": {
"method": "POST",
"url": "https://api.hardcover.app/v1/graphql",
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "content-type",
"value": "application/json"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "query",
"value": "query GetCurrentlyReading { me { user_books(where: {status_id: {_eq: 2}}) { user_book_reads(limit: 1, order_by: {started_at: desc}) { progress } edition { title image { url } book { contributions { author { name } } } } } } }"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
288,
0
],
"id": "b2a74fcb-93a9-4a28-905f-076a51a80a98",
"name": "HTTP Request",
"credentials": {
"httpBearerAuth": {
"id": "Kmf2fBCFkuRuWWZa",
"name": "Hardcover"
}
}
},
{
"parameters": {
"jsCode": "// Hardcover API Response kommt als GraphQL Response\n// Die Response ist ein Array: [{ data: { me: [{ user_books: [...] }] } }]\nconst graphqlResponse = $input.all()[0].json;\n\n// Extrahiere die Daten - Response-Struktur: [{ data: { me: [{ user_books: [...] }] } }]\nconst responseData = Array.isArray(graphqlResponse) ? graphqlResponse[0] : graphqlResponse;\nconst meData = responseData?.data?.me;\nconst userBooks = (Array.isArray(meData) && meData[0]?.user_books) || meData?.user_books || [];\n\nif (!userBooks || userBooks.length === 0) {\n return {\n json: {\n currentlyReading: null\n }\n };\n}\n\n// Sortiere nach Fortschritt, falls mehrere Bücher vorhanden sind\nconst sortedBooks = userBooks.sort((a, b) => {\n const progressA = a.user_book_reads?.[0]?.progress || 0;\n const progressB = b.user_book_reads?.[0]?.progress || 0;\n return progressB - progressA; // Höchster zuerst\n});\n\n// Formatiere alle Bücher\nconst formattedBooks = sortedBooks.map(book => {\n const edition = book.edition || {};\n const bookData = edition.book || {};\n const contributions = bookData.contributions || [];\n const authors = contributions\n .filter(c => c.author && c.author.name)\n .map(c => c.author.name);\n \n const readData = book.user_book_reads?.[0] || {};\n const progress = readData.progress || 0;\n const image = edition.image?.url || null;\n\n return {\n title: edition.title || 'Unknown Title',\n authors: authors.length > 0 ? authors : ['Unknown Author'],\n image: image,\n progress: Math.round(progress) || 0, // Progress ist bereits in Prozent (z.B. 65.75)\n startedAt: readData.started_at || null,\n };\n});\n\n// Gib alle Bücher zurück\nreturn {\n json: {\n currentlyReading: formattedBooks.length > 0 ? formattedBooks : null\n }\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
592,
0
],
"id": "eff96166-8be2-4ece-b338-2b4dec1ee26a",
"name": "Code in JavaScript"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.5,
"position": [
944,
0
],
"id": "80c59480-69db-4ecb-80f4-ddeec2be8376",
"name": "Respond to Webhook"
}
],
"pinData": {},
"connections": {
"Webhook": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Code in JavaScript",
"type": "main",
"index": 0
}
]
]
},
"Code in JavaScript": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "63a2c985-4b40-44ca-a40d-e7048ac5619b",
"meta": {
"instanceId": "cb28e4db755465d5826da179e87f69603d81f833414cc52c327be9183a217b8d"
},
"id": "P2itbbCCQVa0C0HTIVGvy",
"tags": []
}
+219
View File
@@ -0,0 +1,219 @@
{
"name": "finishedBooks",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 6
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
0,
-64
],
"id": "7170586a-8b80-4614-b186-1b661276fd30",
"name": "Schedule Trigger"
},
{
"parameters": {
"operation": "getAll",
"collection": "book_reviews",
"itemFields": [
"hardcover_id"
]
},
"type": "@directus/n8n-nodes-directus.directus",
"typeVersion": 1,
"position": [
224,
-64
],
"id": "145cc646-45d1-4ce7-9f04-77debe503ec6",
"name": "Get_Existing_Books",
"credentials": {
"directusApi": {
"id": "QnVxKFcSXqpaG86u",
"name": "Directus"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://api.hardcover.app/v1/graphql",
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "content-type",
"value": "application/json"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "query",
"value": "query GetReadBooks { me { user_books(where: {status_id: {_eq: 3}}, limit: 10, order_by: {last_read_date: desc}) { last_read_date rating edition { title image { url } book { id contributions { author { name } } } } } } }"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
448,
-64
],
"id": "c2e0f7e4-a30e-4083-b4a9-a1a7e9f8ba3f",
"name": "hardcover",
"credentials": {
"httpBearerAuth": {
"id": "Kmf2fBCFkuRuWWZa",
"name": "Hardcover"
}
}
},
{
"parameters": {
"jsCode": "// 1. Alle gelesenen Bücher von Hardcover holen\nconst hcData = $input.all()[0]?.json;\nconst hcBooks = hcData?.data?.me?.[0]?.user_books || [];\n// 2. Alle bereits in Directus existierenden IDs holen\nlet existingIds = [];\ntry{\n const existingItems = $('Get_Existing_Books').all();\n existingIds = existingItems.map(item => item.json.hardcover_id?.toString());\n } catch (e) {\n // Falls noch gar keine Bücher in Directus sind, ist die Liste einfach leer\n existingIds = [];\n}\n// 3. Filtern: Nur Bücher behalten, deren ID noch NICHT in Directus ist\nconst newBooks = hcBooks.filter(entry => {\n const id = entry.edition.book.id.toString();\n return !existingIds.includes(id);\n});\n// 4. Die neuen Bücher für Directus formatieren\nreturn newBooks.map(entry => {\n const ed = entry.edition || {};\n return {\n json: {\n book_title: ed.title,\n book_author: ed.book?.contributions?.[0]?.author?.name || \"Unbekannter Autor\",\n book_image: ed.image?.url || null,\n hardcover_id: ed.book?.id?.toString(),\n finished_at: entry.last_read_date,\n rating: entry.rating || null,\n status: \"draft\"\n }\n };\n});"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
672,
-64
],
"id": "a0bc4f01-264f-46c3-a667-359983109a72",
"name": "removeDuplicates"
},
{
"parameters": {
"collection": "book_reviews",
"collectionFields": {
"fields": {
"field": [
{
"name": "status",
"value": "={{ $json.status }}"
},
{
"name": "book_title",
"value": "={{ $json.book_title }}"
},
{
"name": "book_author",
"value": "={{ $json.book_author }}"
},
{
"name": "rating",
"value": "={{ $json.rating }}"
},
{
"name": "book_image",
"value": "={{ $json.book_image }}"
},
{
"name": "hardcover_id",
"value": "={{ $json.hardcover_id }}"
},
{
"name": "finished_at",
"value": "={{ $json.finished_at }}"
}
]
}
}
},
"type": "@directus/n8n-nodes-directus.directus",
"typeVersion": 1,
"position": [
896,
-64
],
"id": "0f3db869-1832-4041-8d1d-2a3d834922f0",
"name": "Create an item",
"credentials": {
"directusApi": {
"id": "QnVxKFcSXqpaG86u",
"name": "Directus"
}
}
}
],
"pinData": {},
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get_Existing_Books",
"type": "main",
"index": 0
}
]
]
},
"Get_Existing_Books": {
"main": [
[
{
"node": "hardcover",
"type": "main",
"index": 0
}
]
]
},
"hardcover": {
"main": [
[
{
"node": "removeDuplicates",
"type": "main",
"index": 0
}
]
]
},
"removeDuplicates": {
"main": [
[
{
"node": "Create an item",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "2fa60722-a717-44da-9047-c867a440609c",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "cb28e4db755465d5826da179e87f69603d81f833414cc52c327be9183a217b8d"
},
"id": "sbpapdCb7OBoRdc_3j0VL",
"tags": []
}
File diff suppressed because one or more lines are too long
+740
View File
@@ -0,0 +1,740 @@
{
"name": "🎯 ULTIMATE Telegram CMS COMPLETE",
"nodes": [
{
"parameters": {
"updates": [
"message",
"callback_query"
],
"additionalFields": {}
},
"type": "n8n-nodes-base.telegramTrigger",
"typeVersion": 1.2,
"position": [
0,
240
],
"id": "telegram-trigger-001",
"name": "Telegram Trigger",
"webhookId": "telegram-cms-webhook-001",
"credentials": {
"telegramApi": {
"id": "ADurvy9EKUDzbDdq",
"name": "DK0_Server"
}
}
},
{
"parameters": {
"jsCode": "const input = $input.first().json;\nconst token = '8166414331:AAGNQ6fn2juD5esaTRxPjtTdSMkwq_oASIc';\n\nif (input.callback_query) {\n const cbq = input.callback_query;\n const chatId = cbq.message.chat.id;\n const data = cbq.data;\n const callbackQueryId = cbq.id;\n \n if (token) {\n try {\n await this.helpers.httpRequest({ \n method: 'POST', \n url: 'https://api.telegram.org/bot' + token + '/answerCallbackQuery', \n headers: { 'Content-Type': 'application/json' }, \n body: { callback_query_id: callbackQueryId } \n });\n } catch(e) {}\n }\n \n const parts = data.split(':');\n const action = parts[0];\n \n if (action === 'start') return [{ json: { action: 'start', chatId } }];\n if (action === 'stats') return [{ json: { action: 'stats', chatId } }];\n if (action === 'list') return [{ json: { action: 'list', type: parts[1], page: parseInt(parts[2] || '1'), chatId } }];\n if (action === 'preview') return [{ json: { action: 'preview', collectionType: parts[1], id: parts[2], chatId } }];\n if (action === 'publish') return [{ json: { action: 'publish', collectionType: parts[1], id: parts[2], chatId } }];\n if (action === 'delete') return [{ json: { action: 'delete', collectionType: parts[1], id: parts[2], chatId } }];\n if (action === 'review_info') return [{ json: { action: 'review_info', id: parts[1], chatId } }];\n \n return [{ json: { action: 'unknown', chatId } }];\n}\n\nconst text = input.message?.text ?? '';\nconst chatId = input.message?.chat?.id;\nlet match;\n\nif (text === '/start') return [{ json: { action: 'start', chatId } }];\nif (text === '/stats') return [{ json: { action: 'stats', chatId } }];\n\nmatch = text.match(/^\\/list\\s+(projects|books)(?:\\s+(\\d+))?/);\nif (match) return [{ json: { action: 'list', type: match[1], page: parseInt(match[2] || '1'), chatId } }];\n\nmatch = text.match(/^\\/preview\\s*(project|book)?(\\d+)/);\nif (match) {\n const typePrefix = match[1] === 'project' ? 'projects' : match[1] === 'book' ? 'book_reviews' : 'projects';\n return [{ json: { action: 'preview', collectionType: typePrefix, id: match[2], chatId } }];\n}\n\nmatch = text.match(/^\\/search\\s+(.+)/);\nif (match) return [{ json: { action: 'search', query: match[1].trim(), chatId } }];\n\nmatch = text.match(/^\\/publish\\s*(project|book)?(\\d+)/);\nif (match) {\n const typePrefix = match[1] === 'book' ? 'books' : 'projects';\n return [{ json: { action: 'publish', collectionType: typePrefix, id: match[2], chatId } }];\n}\n\nmatch = text.match(/^\\/delete\\s*(project|book)?(\\d+)/);\nif (match) {\n const typePrefix = match[1] === 'book' ? 'books' : 'projects';\n return [{ json: { action: 'delete', collectionType: typePrefix, id: match[2], chatId } }];\n}\n\n// .review HC_ID [RATING] -> starts review process with AI questions\nmatch = text.match(/^\\.review\\s+(\\d+)(?:\\s+([1-5]))?/);\nif (match) return [{ json: { action: 'review_info', hardcoverId: match[1], rating: match[2] ? parseInt(match[2]) : 0, chatId } }];\n\n// .answer BOOK_ID RATING your answers -> submit review answers\nmatch = text.match(/^\\.answer\\s+(\\d+)\\s+([1-5])\\s+(.+)/);\nif (match) return [{ json: { action: 'answer_review', bookId: match[1], rating: parseInt(match[2]), answers: match[3].trim(), chatId } }];\n\nmatch = text.match(/^\\.refine\\s+(\\d+)\\s+(.+)/);\nif (match) return [{ json: { action: 'refine_review', id: match[1], feedback: match[2].trim(), chatId } }];\n\nreturn [{ json: { action: 'unknown', chatId } }];\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
240,
240
],
"id": "global-parser-001",
"name": "Global Parser"
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "start",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "start"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "list",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "list"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "search",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "search"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "stats",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "stats"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "preview",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "preview"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "publish",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "publish"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "delete",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "delete"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "delete_review",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "delete_review"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "answer_review",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "answer_review"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": ""
},
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "refine_review",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "refine_review"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "unknown",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "unknown"
},
{
"conditions": {
"conditions": [
{
"leftValue": "={{ $json.action }}",
"rightValue": "review_info",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and",
"options": {
"caseSensitive": true,
"leftValue": ""
}
},
"renameOutput": true,
"outputKey": "review_info"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
480,
240
],
"id": "router-001",
"name": "Command Router"
},
{
"parameters": {
"jsCode": "\ntry {\n var chatId = $input.first().json.chatId;\n var projectsResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/projects?aggregate[count]=id&filter[status][_eq]=draft', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var draftProjects = (projectsResp && projectsResp.data && projectsResp.data[0] && projectsResp.data[0].count && projectsResp.data[0].count.id) || 0;\n var booksResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews?aggregate[count]=id&filter[status][_eq]=draft', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var draftBooks = (booksResp && booksResp.data && booksResp.data[0] && booksResp.data[0].count && booksResp.data[0].count.id) || 0;\n var message = '\\u{1F3AF} <b>DK0 Portfolio CMS</b>\\n\\n\\u{1F4CA} <b>Status:</b>\\n\\u2022 Draft Projects: ' + draftProjects + '\\n\\u2022 Draft Reviews: ' + draftBooks + '\\n\\nTap a button to navigate.';\n var keyboard = [\n [{ text: '\\u{1F4CB} Projects', callback_data: 'list:projects:1' }, { text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }],\n [{ text: '\\u{1F4CA} Stats', callback_data: 'stats' }]\n ];\n return [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error loading dashboard: ' + error.message, parseMode: 'HTML' } }];\n}\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
-120
],
"id": "dashboard-001",
"name": "Dashboard Handler"
},
{
"parameters": {
"jsCode": "\ntry {\n var input = $input.first().json;\n var type = input.type;\n var page = input.page || 1;\n var chatId = input.chatId;\n var limit = 5;\n var offset = (page - 1) * limit;\n var collection = type === 'projects' ? 'projects' : 'book_reviews';\n var fields = type === 'projects' ? 'id,slug,category,status,date_created,translations.*' : 'id,book_title,rating,status,finished_at';\n var url = 'https://cms.dk0.dev/items/' + collection + '?limit=' + limit + '&offset=' + offset + '&sort=' + (type === 'projects' ? '-date_created' : '-finished_at') + '&fields=' + fields;\n var response = await this.helpers.httpRequest({ method: 'GET', url: url, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var items = (response && response.data) || [];\n if (items.length === 0) {\n return [{ json: { chatId: chatId, message: 'No ' + type + ' found.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n var message = '<b>' + type.toUpperCase() + ' (Page ' + page + ')</b>\\n\\n';\n var keyboard = [];\n items.forEach(function(item, idx) {\n var num = idx + 1;\n var displayNum = (offset || 0) + num;\n if (type === 'projects') {\n var title = (item.translations && item.translations[0] && item.translations[0].title) || item.slug || 'Untitled';\n message += displayNum + '. <b>' + title + '</b>\\n ' + (item.category || 'N/A') + ' | ' + item.status + '\\n\\n';\n } else {\n var stars = '';\n for (var s = 0; s < (item.rating || 0); s++) { stars += '\\u2B50'; }\n message += displayNum + '. <b>' + (item.book_title || 'Untitled') + '</b>\\n ' + stars + ' | ' + item.status + '\\n\\n';\n }\n var row = [\n { text: '\\u{1F441} #' + displayNum, callback_data: 'preview:' + type + ':' + item.id },\n { text: '\\u2705 Pub #' + displayNum, callback_data: 'publish:' + type + ':' + item.id }\n ];\n if (type === 'books' && item.status === 'draft') {\n row.push({ text: '\\u270D\\uFE0F Review #' + displayNum, callback_data: 'review_info:' + item.id });\n }\n row.push({ text: '\\u{1F5D1} Del #' + displayNum, callback_data: 'delete:' + type + ':' + item.id });\n keyboard.push(row);\n });\n var navRow = [];\n if (page > 1) { navRow.push({ text: '\\u2190 Prev', callback_data: 'list:' + type + ':' + (page - 1) }); }\n if (items.length === limit) { navRow.push({ text: 'Next \\u2192', callback_data: 'list:' + type + ':' + (page + 1) }); }\n navRow.push({ text: '\\u{1F3E0} Home', callback_data: 'start' });\n keyboard.push(navRow);\n return [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error fetching list: ' + error.message, parseMode: 'HTML' } }];\n}\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
0
],
"id": "list-handler-001",
"name": "List Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var query = input.query;\n var chatId = input.chatId;\n var encoded = encodeURIComponent(query);\n var projectsResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/projects?filter[translations][title][_contains]=' + encoded + '&limit=5&fields=id,slug,category,translations.*', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var booksResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews?filter[book_title][_contains]=' + encoded + '&limit=5&fields=id,book_title,book_author,rating', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var projects = (projectsResp && projectsResp.data) || [];\n var books = (booksResp && booksResp.data) || [];\n if (projects.length === 0 && books.length === 0) {\n return [{ json: { chatId: chatId, message: '\\u{1F50D} No results for \"' + query + '\"', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n var message = '\\u{1F50D} <b>Search: \"' + query + '\"</b>\\n\\n';\n var keyboard = [];\n if (projects.length > 0) {\n message += '\\u{1F4C1} <b>Projects (' + projects.length + '):</b>\\n';\n projects.forEach(function(p) {\n var title = (p.translations && p.translations[0] && p.translations[0].title) || p.slug || 'Untitled';\n message += '\\u2022 ' + title + '\\n';\n keyboard.push([{ text: '\\u{1F441} ' + title, callback_data: 'preview:projects:' + p.id }]);\n });\n message += '\\n';\n }\n if (books.length > 0) {\n message += '\\u{1F4DA} <b>Books (' + books.length + '):</b>\\n';\n books.forEach(function(b) {\n message += '\\u2022 ' + b.book_title + ' by ' + b.book_author + '\\n';\n keyboard.push([{ text: '\\u{1F441} ' + b.book_title, callback_data: 'preview:books:' + b.id }]);\n });\n }\n keyboard.push([{ text: '\\u{1F3E0} Home', callback_data: 'start' }]);\n return [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error searching: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
120
],
"id": "search-handler-001",
"name": "Search Handler"
},
{
"parameters": {
"jsCode": "try {\n var chatId = $input.first().json.chatId;\n var projectsResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/projects?fields=id,category,status,date_created', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var booksResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews?fields=id,rating,status,finished_at', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var projects = (projectsResp && projectsResp.data) || [];\n var books = (booksResp && booksResp.data) || [];\n var pPublished = projects.filter(function(p) { return p.status === 'published'; }).length;\n var pDraft = projects.filter(function(p) { return p.status === 'draft'; }).length;\n var pArchived = projects.filter(function(p) { return p.status === 'archived'; }).length;\n var bPublished = books.filter(function(b) { return b.status === 'published'; }).length;\n var bDraft = books.filter(function(b) { return b.status === 'draft'; }).length;\n var bAvg = books.length > 0 ? (books.reduce(function(sum, b) { return sum + (b.rating || 0); }, 0) / books.length).toFixed(1) : 0;\n var categories = {};\n projects.forEach(function(p) { if (p.category) { categories[p.category] = (categories[p.category] || 0) + 1; } });\n var message = '\\u{1F4CA} <b>DK0 Portfolio Statistics</b>\\n\\n\\u{1F4C1} <b>Projects:</b>\\n\\u2022 Total: ' + projects.length + '\\n\\u2022 Published: ' + pPublished + '\\n\\u2022 Draft: ' + pDraft + '\\n\\u2022 Archived: ' + pArchived + '\\n\\n\\u{1F4DA} <b>Book Reviews:</b>\\n\\u2022 Total: ' + books.length + '\\n\\u2022 Published: ' + bPublished + '\\n\\u2022 Draft: ' + bDraft + '\\n\\u2022 Avg Rating: ' + bAvg + '/5\\n';\n var catEntries = Object.entries(categories).sort(function(a, b) { return b[1] - a[1]; });\n if (catEntries.length > 0) {\n message += '\\n\\u{1F3F7}\\uFE0F <b>Categories:</b>\\n';\n catEntries.forEach(function(entry) { message += '\\u2022 ' + entry[0] + ': ' + entry[1] + '\\n'; });\n }\n var keyboard = [\n [{ text: '\\u{1F4CB} Projects', callback_data: 'list:projects:1' }, { text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }],\n [{ text: '\\u{1F3E0} Home', callback_data: 'start' }]\n ];\n return [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error loading stats: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
240
],
"id": "stats-handler-001",
"name": "Stats Handler"
},
{
"parameters": {
"jsCode": "\ntry {\n var input = $input.first().json;\n var id = input.id;\n var chatId = input.chatId;\n var collectionType = input.collectionType;\n \n var response, collection;\n \n if (collectionType === 'projects' || collectionType === 'project') {\n response = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/projects/' + id + '?fields=id,slug,category,status,date_created,translations.*', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'projects';\n } else if (collectionType === 'books' || collectionType === 'book') {\n response = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + id + '?fields=id,book_title,book_author,rating,status,hardcover_id,translations.*', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'book_reviews';\n } else {\n response = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/projects/' + id + '?fields=id,slug,category,status,date_created,translations.*', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'projects';\n var itemTry = response && response.body && response.body.data;\n if (!itemTry) {\n response = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + id + '?fields=id,book_title,book_author,rating,status,hardcover_id,translations.*', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'book_reviews';\n }\n }\n\n var item = response && response.body && response.body.data;\n if (!item) {\n return [{ json: { chatId: chatId, message: '\\u274C Item #' + id + ' not found.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n \n var message = '\\u{1F441}\\uFE0F <b>Preview #' + id + '</b>\\n\\n';\n if (collection === 'projects') {\n message += '\\u{1F4C1} <b>Type:</b> Project\\n\\u{1F516} <b>Slug:</b> ' + item.slug + '\\n\\u{1F3F7}\\uFE0F <b>Category:</b> ' + (item.category || 'N/A') + '\\n\\u{1F4CA} <b>Status:</b> ' + item.status + '\\n\\n';\n var translations = item.translations || [];\n translations.forEach(function(t) {\n var lang = t.languages_code === 'en-US' ? '\\u{1F1EC}\\u{1F1E7} EN' : '\\u{1F1E9}\\u{1F1EA} DE';\n message += lang + ':\\n<b>Title:</b> ' + (t.title || 'N/A') + '\\n<b>Desc:</b> ' + ((t.description || 'N/A')) + '...\\n\\n';\n });\n } else {\n message += '\\u{1F4DA} <b>Type:</b> Book Review\\n\\u{1F4D6} <b>Title:</b> ' + item.book_title + '\\n\\u270D\\uFE0F <b>Author:</b> ' + item.book_author + '\\n\\u2B50 <b>Rating:</b> ' + item.rating + '/5\\n\\u{1F4CA} <b>Status:</b> ' + item.status + '\\n\\u{1F517} <b>HC-ID:</b> ' + item.hardcover_id + '\\n\\n';\n var translations = item.translations || [];\n translations.forEach(function(t) {\n var lang = t.languages_code === 'en-US' ? '\\u{1F1EC}\\u{1F1E7} EN' : '\\u{1F1E9}\\u{1F1EA} DE';\n message += lang + ':\\n' + ((t.review || 'No review')) + '...\\n\\n';\n });\n }\n var listType = collection === 'projects' ? 'projects' : 'books';\n var keyboard = [\n [{ text: '\\u2705 Publish', callback_data: 'publish:' + listType + ':' + id }, { text: '\\u{1F5D1} Delete', callback_data: 'delete:' + listType + ':' + id }],\n [{ text: '\\u2190 Back', callback_data: 'list:' + listType + ':1' }, { text: '\\u{1F3E0} Home', callback_data: 'start' }]\n ];\n return [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error loading preview: ' + error.message, parseMode: 'HTML' } }];\n}\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
360
],
"id": "preview-handler-001",
"name": "Preview Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var id = input.id;\n var chatId = input.chatId;\n var collectionType = input.collectionType;\n \n var url, title, listType;\n \n if (collectionType === 'projects' || collectionType === 'project') {\n url = 'https://cms.dk0.dev/items/projects/' + id;\n title = 'Project';\n listType = 'projects';\n } else {\n url = 'https://cms.dk0.dev/items/book_reviews/' + id;\n title = 'Book Review';\n listType = 'books';\n }\n \n var response;\n try {\n response = await this.helpers.httpRequest({\n method: 'PATCH',\n url: url,\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB'\n },\n body: { status: 'published' }\n });\n } catch(e) {\n return [{ json: { chatId: chatId, message: '\\u274C <b>Publish fehlgeschlagen</b>\\n\\n' + e.message, parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n \n var result = response.data || response;\n if (!result || !result.id) {\n return [{ json: { chatId: chatId, message: '\\u274C <b>Publish fehlgeschlagen</b>\\n\\nKeine Bestaetigung von Directus.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n \n var keyboard = [[{ text: '\\u{1F4CB} ' + (listType === 'projects' ? 'Projects' : 'Books'), callback_data: 'list:' + listType + ':1' }, { text: '\\u{1F3E0} Home', callback_data: 'start' }]];\n return [{ json: { chatId: chatId, message: '\\u2705 <b>' + title + ' #' + id + ' Published!</b>\\n\\nNow live on dk0.dev.', parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error publishing: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
480
],
"id": "publish-handler-001",
"name": "Publish Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var id = input.id;\n var chatId = input.chatId;\n var collectionType = input.collectionType;\n \n var response, collection, title;\n \n if (collectionType === 'projects' || collectionType === 'project') {\n response = await this.helpers.httpRequest({ method: 'DELETE', url: 'https://cms.dk0.dev/items/projects/' + id, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'projects';\n title = 'Project';\n } else if (collectionType === 'books' || collectionType === 'book') {\n response = await this.helpers.httpRequest({ method: 'DELETE', url: 'https://cms.dk0.dev/items/book_reviews/' + id, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'book_reviews';\n title = 'Book Review';\n } else {\n // Fallback\n response = await this.helpers.httpRequest({ method: 'DELETE', url: 'https://cms.dk0.dev/items/projects/' + id, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'projects';\n title = 'Project';\n if (!response || response.statusCode >= 400) {\n response = await this.helpers.httpRequest({ method: 'DELETE', url: 'https://cms.dk0.dev/items/book_reviews/' + id, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, returnFullResponse: true }).catch(function() { return null; });\n collection = 'book_reviews';\n title = 'Book Review';\n }\n }\n\n if (!response || response.statusCode >= 400) {\n return [{ json: { chatId: chatId, message: '\\u274C Item #' + id + ' could not be deleted.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n var listType = collection === 'projects' ? 'projects' : 'books';\n var keyboard = [[{ text: (collection === 'projects' ? '\\u{1F4CB} Projects' : '\\u{1F4DA} Books'), callback_data: 'list:' + listType + ':1' }, { text: '\\u{1F3E0} Home', callback_data: 'start' }]];\n return [{ json: { chatId: chatId, message: '\\u{1F5D1}\\uFE0F *' + title + ' #' + id + ' Deleted*', parseMode: 'HTML', keyboard: keyboard, collection: collection, itemId: id } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error deleting: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
600
],
"id": "delete-handler-001",
"name": "Delete Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var id = input.id;\n var chatId = input.chatId;\n var bookResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + id + '?fields=id,book_title,translations.id', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var book = bookResp && bookResp.data;\n if (!book) {\n return [{ json: { chatId: chatId, message: '\\u274C Book review #' + id + ' not found.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n var translations = book.translations || [];\n var deletedCount = 0;\n for (var i = 0; i < translations.length; i++) {\n await this.helpers.httpRequest({ method: 'DELETE', url: 'https://cms.dk0.dev/items/book_reviews_translations/' + translations[i].id, headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } }).catch(function() {});\n deletedCount++;\n }\n var keyboard = [[{ text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }, { text: '\\u{1F3E0} Home', callback_data: 'start' }]];\n return [{ json: { chatId: chatId, message: '\\u{1F5D1}\\uFE0F Deleted ' + deletedCount + ' review translations for \"' + book.book_title + '\".\\n\\nBook entry still exists.', parseMode: 'HTML', keyboard: keyboard, itemId: id, deletedCount: deletedCount } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error deleting review: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
720
],
"id": "delete-review-handler-001",
"name": "Delete Review Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var bookId = input.bookId;\n var rating = input.rating;\n var answers = input.answers;\n var chatId = input.chatId;\n\n var bookResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + bookId + '?fields=id,book_title,book_author,rating,translations.id,translations.languages_code,translations.review', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var bookData = bookResp && bookResp.data ? bookResp.data : bookResp;\n if (!bookData || !bookData.id) {\n return [{ json: { chatId: chatId, message: '\\u274C Buch #' + bookId + ' nicht gefunden.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n\n var prompt = 'Schreibe eine authentische Buchbewertung. Buch: ' + bookData.book_title + ' von ' + bookData.book_author + '. Rating: ' + rating + '/5. Antworten des Lesers auf Fragen zum Buch: ' + answers + ' Schreibe Ich-Perspektive, 4-6 Saetze pro Sprache. Verwende keine Bindestriche, Em-Dashes oder Gedankenstriche. Antworte NUR als JSON: {\"review_en\": \"English review\", \"review_de\": \"Deutsche Bewertung\"}';\n\n var aiResp = await this.helpers.httpRequest({ method: 'POST', url: 'https://openrouter.ai/api/v1/chat/completions', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer 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' }, body: { model: 'openrouter/free', messages: [{ role: 'user', content: prompt }] } });\n var aiText = (aiResp && aiResp.choices && aiResp.choices[0] && aiResp.choices[0].message && aiResp.choices[0].message.content) || '{}';\n var jsonMatch = aiText.match(/\\{[\\s\\S]*\\}/);\n var ai = jsonMatch ? JSON.parse(jsonMatch[0]) : { review_en: answers, review_de: answers };\n\n // Update rating\n await this.helpers.httpRequest({ method: 'PATCH', url: 'https://cms.dk0.dev/items/book_reviews/' + bookData.id, headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { rating: rating } });\n\n var translations = bookData.translations || [];\n var enTrans = null, deTrans = null;\n for (var i = 0; i < translations.length; i++) {\n if (translations[i].languages_code === 'en-US') enTrans = translations[i];\n if (translations[i].languages_code === 'de-DE') deTrans = translations[i];\n }\n\n var reviewEn = ai.review_en || answers;\n var reviewDe = ai.review_de || answers;\n\n // Update existing translations (PATCH) or create new ones (POST)\n if (enTrans) {\n await this.helpers.httpRequest({ method: 'PATCH', url: 'https://cms.dk0.dev/items/book_reviews_translations/' + enTrans.id, headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { review: reviewEn } });\n } else {\n await this.helpers.httpRequest({ method: 'POST', url: 'https://cms.dk0.dev/items/book_reviews_translations', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { book_reviews_id: bookData.id, languages_code: 'en-US', review: reviewEn } });\n }\n\n if (deTrans) {\n await this.helpers.httpRequest({ method: 'PATCH', url: 'https://cms.dk0.dev/items/book_reviews_translations/' + deTrans.id, headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { review: reviewDe } });\n } else {\n await this.helpers.httpRequest({ method: 'POST', url: 'https://cms.dk0.dev/items/book_reviews_translations', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { book_reviews_id: bookData.id, languages_code: 'de-DE', review: reviewDe } });\n }\n\n var showEn = reviewEn;\n var showDe = reviewDe;\n var msg = '\\u2705 <b>Review erstellt!</b>\\n\\n\\u{1F4DA} ' + bookData.book_title + ' (' + rating + '/5)\\n\\n<b>EN:</b> ' + showEn + '\\n\\n<b>DE:</b> ' + showDe;\n var keyboard = [[{ text: '\\u{1F441} Preview', callback_data: 'preview:books:' + bookData.id }, { text: '\\u2705 Publish', callback_data: 'publish:books:' + bookData.id }], [{ text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }]];\n return [{ json: { chatId: chatId, message: msg, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Fehler beim Erstellen der Review: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
840
],
"id": "create-review-handler-001",
"name": "Create Review Handler"
},
{
"parameters": {
"jsCode": "var chatId = $input.first().json.chatId;\nvar message = '\\u2753 <b>Unknown Command</b>\\n\\nUse the buttons below or type:\\n<code>.review HC_ID [RATING]</code> - Start review with AI questions\\n<code>.answer BOOK_ID RATING your answers</code> - Submit review answers\\n<code>.refine ID FEEDBACK</code> - Refine existing review';\nvar keyboard = [\n [{ text: '\\u{1F4CB} Projects', callback_data: 'list:projects:1' }, { text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }],\n [{ text: '\\u{1F4CA} Stats', callback_data: 'stats' }, { text: '\\u{1F3E0} Dashboard', callback_data: 'start' }]\n];\nreturn [{ json: { chatId: chatId, message: message, parseMode: 'HTML', keyboard: keyboard } }];"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
960
],
"id": "unknown-handler-001",
"name": "Unknown Command Handler"
},
{
"parameters": {
"method": "POST",
"url": "={{ 'https://api.telegram.org/bot8166414331:AAGNQ6fn2juD5esaTRxPjtTdSMkwq_oASIc/sendMessage' }}",
"authentication": "none",
"sendBody": true,
"contentType": "json",
"specifyBody": "json",
"jsonBody": "={{ { chat_id: $json.chatId, text: $json.message, parse_mode: $json.parseMode || 'HTML', reply_markup: ($json.keyboard && $json.keyboard.length > 0) ? { inline_keyboard: $json.keyboard } : undefined } }}"
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
960,
420
],
"id": "send-message-001",
"name": "Send Message",
"options": {}
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var id = input.id;\n var feedback = input.feedback;\n var chatId = input.chatId;\n var bookResp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + id + '?fields=id,book_title,book_author,rating,translations.id,translations.languages_code,translations.review', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n var bookData = bookResp && bookResp.data ? bookResp.data : bookResp;\n if (!bookData || !bookData.id) {\n return [{ json: { chatId: chatId, message: 'Review #' + id + ' nicht gefunden.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F3E0} Home', callback_data: 'start' }]] } }];\n }\n var translations = bookData.translations || [];\n var enTrans = null, deTrans = null;\n for (var i = 0; i < translations.length; i++) {\n if (translations[i].languages_code === 'en-US') enTrans = translations[i];\n if (translations[i].languages_code === 'de-DE') deTrans = translations[i];\n }\n var currentEn = enTrans ? enTrans.review : '';\n var currentDe = deTrans ? deTrans.review : '';\n var prompt = 'Du hast eine Buchbewertung fuer \"' + bookData.book_title + '\" von \"' + bookData.book_author + '\" geschrieben. Rating: ' + bookData.rating + '/5. Aktuelle EN-Bewertung: ' + currentEn + ' Aktuelle DE-Bewertung: ' + currentDe + ' Feedback des Lesers: ' + feedback + ' Wichtig: EN und DE sind immer inhaltlich identisch, nur die Sprache unterscheidet sich. Feedback gilt fuer BEIDE Versionen, auch wenn es nur eine Sprache erwaehnt. Ueberarbeite daher immer beide synchron. Ich-Perspektive, 4-6 Saetze pro Sprache. Verwende keine Bindestriche, Em-Dashes oder Gedankenstriche. Antworte NUR als JSON: {\"review_en\": \"...\", \"review_de\": \"...\"}';\n var aiResp = await this.helpers.httpRequest({ method: 'POST', url: 'https://openrouter.ai/api/v1/chat/completions', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer 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' }, body: { model: 'openrouter/free', messages: [{ role: 'user', content: prompt }] } });\n var aiText = (aiResp && aiResp.choices && aiResp.choices[0] && aiResp.choices[0].message && aiResp.choices[0].message.content) || '{}';\n var jsonMatch = aiText.match(/\\{[\\s\\S]*\\}/);\n var ai = jsonMatch ? JSON.parse(jsonMatch[0]) : { review_en: feedback, review_de: feedback };\n var reviewEn = ai.review_en || feedback;\n var reviewDe = ai.review_de || feedback;\n\n // Update existing translations (PATCH) or create new ones (POST)\n if (enTrans) {\n await this.helpers.httpRequest({ method: 'PATCH', url: 'https://cms.dk0.dev/items/book_reviews_translations/' + enTrans.id, headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { review: reviewEn } });\n } else {\n await this.helpers.httpRequest({ method: 'POST', url: 'https://cms.dk0.dev/items/book_reviews_translations', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { book_reviews_id: bookData.id, languages_code: 'en-US', review: reviewEn } });\n }\n if (deTrans) {\n await this.helpers.httpRequest({ method: 'PATCH', url: 'https://cms.dk0.dev/items/book_reviews_translations/' + deTrans.id, headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { review: reviewDe } });\n } else {\n await this.helpers.httpRequest({ method: 'POST', url: 'https://cms.dk0.dev/items/book_reviews_translations', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' }, body: { book_reviews_id: bookData.id, languages_code: 'de-DE', review: reviewDe } });\n }\n\n var showEn = reviewEn;\n var showDe = reviewDe;\n var msg = '\\u270F\\uFE0F <b>Review aktualisiert!</b>\\n\\n\\u{1F4DA} ' + bookData.book_title + '\\n\\n<b>EN:</b> ' + showEn + '\\n\\n<b>DE:</b> ' + showDe;\n var keyboard = [[{ text: '\\u{1F441} Preview', callback_data: 'preview:books:' + id }, { text: '\\u2705 Publish', callback_data: 'publish:books:' + id }], [{ text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }]];\n return [{ json: { chatId: chatId, message: msg, parseMode: 'HTML', keyboard: keyboard } }];\n} catch (error) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Fehler beim Aktualisieren: ' + error.message, parseMode: 'HTML' } }];\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
1080
],
"id": "refine-review-handler-001",
"name": "Refine Review Handler"
},
{
"parameters": {
"jsCode": "try {\n var input = $input.first().json;\n var chatId = input.chatId;\n var bookId = input.id;\n var hardcoverId = input.hardcoverId;\n var rating = input.rating || 0;\n var book;\n\n if (bookId) {\n var resp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews/' + bookId + '?fields=id,book_title,book_author,hardcover_id,rating', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n book = resp && resp.data;\n } else if (hardcoverId) {\n var resp = await this.helpers.httpRequest({ method: 'GET', url: 'https://cms.dk0.dev/items/book_reviews?filter[hardcover_id][_eq]=' + hardcoverId + '&fields=id,book_title,book_author,hardcover_id,rating&limit=1', headers: { 'Authorization': 'Bearer RF2QytqhcLXuVy6FO3PzWlsoR-ysCTwB' } });\n book = resp && resp.data && resp.data[0];\n }\n\n if (!book) {\n return [{ json: { chatId: chatId, message: '\\u274C Buch nicht gefunden. Pr\\u00fcfe die ID.', parseMode: 'HTML', keyboard: [[{ text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }]] } }];\n }\n\n var prompt = 'Du bist ein Leseberater. Generiere genau 4 persoenliche, tiefgruendige Fragen zum Buch \"' + book.book_title + '\" von ' + book.book_author + ', die einem helfen, eine authentische Bewertung zu schreiben. Die Fragen sollen spezifisch zum Buch sein und zum Nachdenken anregen. Antworte NUR als JSON-Array, keine Erklaerung davor: [\"Frage 1\", \"Frage 2\", \"Frage 3\", \"Frage 4\"]';\n\n var aiResp = await this.helpers.httpRequest({ method: 'POST', url: 'https://openrouter.ai/api/v1/chat/completions', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer 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' }, body: { model: 'openrouter/free', messages: [{ role: 'user', content: prompt }] } });\n\n var aiText = (aiResp && aiResp.choices && aiResp.choices[0] && aiResp.choices[0].message && aiResp.choices[0].message.content) || '[]';\n var questions;\n try {\n var jsonMatch = aiText.match(/\\[[\\s\\S]*\\]/);\n questions = jsonMatch ? JSON.parse(jsonMatch[0]) : ['Was hat dir am besten gefallen?', 'Was hat dich gestoert?', 'Wuerdest du es weiterempfehlen?', 'Welche Szene ist dir im Gedaechtnis geblieben?'];\n } catch(e) {\n questions = ['Was hat dir am besten gefallen?', 'Was hat dich gestoert?', 'Wuerdest du es weiterempfehlen?', 'Welche Szene ist dir im Gedaechtnis geblieben?'];\n }\n\n var ratingInfo = rating > 0 ? '\\n\\u2B50 Dein Rating: ' + rating + '/5' : '\\n\\u2B50 Gib dein Rating (1-5) an';\n var msg = '\\u{1F4D6} <b>Review: ' + book.book_title + '</b>\\n' + book.book_author + ratingInfo + '\\n\\n\\u2753 <b>Beantworte diese Fragen:</b>\\n\\n';\n for (var i = 0; i < questions.length; i++) {\n msg += (i + 1) + '. ' + questions[i] + '\\n';\n }\n msg += '\\n\\u270D\\uFE0F Antworte mit:\\n<code>.answer ' + book.id + ' ' + (rating > 0 ? rating : '5') + ' deine Antworten hier</code>';\n msg += '\\n\\n<i>Beispiel: .answer ' + book.id + ' 4 Die Charakterentwicklung war super...</i>';\n\n var keyboard = [[{ text: '\\u{1F4DA} Books', callback_data: 'list:books:1' }, { text: '\\u{1F3E0} Home', callback_data: 'start' }]];\n return [{ json: { chatId: chatId, message: msg, parseMode: 'HTML', keyboard: keyboard } }];\n} catch(e) {\n return [{ json: { chatId: $input.first().json.chatId, message: '\\u274C Error: ' + e.message, parseMode: 'HTML' } }];\n}\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
960
],
"id": "review-info-handler-001",
"name": "Review Info Handler"
}
],
"connections": {
"Telegram Trigger": {
"main": [
[
{
"node": "Global Parser",
"type": "main",
"index": 0
}
]
]
},
"Global Parser": {
"main": [
[
{
"node": "Command Router",
"type": "main",
"index": 0
}
]
]
},
"Command Router": {
"main": [
[
{
"node": "Dashboard Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "List Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Search Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Stats Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Preview Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Publish Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Delete Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Delete Review Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Create Review Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Refine Review Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Unknown Command Handler",
"type": "main",
"index": 0
}
],
[
{
"node": "Review Info Handler",
"type": "main",
"index": 0
}
]
]
},
"Dashboard Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"List Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Search Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Stats Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Preview Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Publish Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Delete Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Delete Review Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Create Review Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Unknown Command Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Refine Review Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
},
"Review Info Handler": {
"main": [
[
{
"node": "Send Message",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"tags": [],
"triggerCount": 1,
"updatedAt": "2025-01-21T00:00:00.000Z",
"versionId": "1"
}
-11
View File
@@ -26,7 +26,6 @@
"lucide-react": "^0.542.0",
"next": "^15.5.7",
"next-intl": "^4.7.0",
"next-themes": "^0.4.6",
"node-cache": "^5.1.2",
"node-fetch": "^2.7.0",
"nodemailer": "^7.0.11",
@@ -11348,16 +11347,6 @@
}
}
},
"node_modules/next-themes": {
"version": "0.4.6",
"resolved": "https://registry.npmjs.org/next-themes/-/next-themes-0.4.6.tgz",
"integrity": "sha512-pZvgD5L0IEvX5/9GWyHMf3m8BKiVQwsCMHfoFosXtXBMnaS0ZnIJ9ST4b4NqLVKDEm8QBxoNNGNaBv2JNF6XNA==",
"license": "MIT",
"peerDependencies": {
"react": "^16.8 || ^17 || ^18 || ^19 || ^19.0.0-rc",
"react-dom": "^16.8 || ^17 || ^18 || ^19 || ^19.0.0-rc"
}
},
"node_modules/next/node_modules/@swc/helpers": {
"version": "0.5.15",
"resolved": "https://registry.npmjs.org/@swc/helpers/-/helpers-0.5.15.tgz",
-136
View File
@@ -1,136 +0,0 @@
#!/bin/bash
# Gitea Runner Status Check Script
# Prüft den Status des Gitea Runners
set -e
# Colors for output
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
CYAN='\033[0;36m'
NC='\033[0m' # No Color
echo -e "${BLUE}╔════════════════════════════════════════════════════════════╗${NC}"
echo -e "${BLUE}║ Gitea Runner Status Check ║${NC}"
echo -e "${BLUE}╚════════════════════════════════════════════════════════════╝${NC}"
echo ""
# Check 1: systemd service
echo -e "${CYAN}[1/5] Checking systemd service...${NC}"
if systemctl list-units --type=service --all | grep -q "gitea-runner.service"; then
echo -e "${GREEN}✓ systemd service found${NC}"
systemctl status gitea-runner --no-pager -l || true
else
echo -e "${YELLOW}⚠ systemd service not found (runner might be running differently)${NC}"
fi
echo ""
# Check 2: Running processes
echo -e "${CYAN}[2/5] Checking for running runner processes...${NC}"
RUNNER_PROCESSES=$(ps aux | grep -E "(gitea|act_runner|woodpecker)" | grep -v grep || echo "")
if [ ! -z "$RUNNER_PROCESSES" ]; then
echo -e "${GREEN}✓ Found runner processes:${NC}"
echo "$RUNNER_PROCESSES" | while read line; do
echo " $line"
done
else
echo -e "${RED}✗ No runner processes found${NC}"
fi
echo ""
# Check 3: Docker containers (if runner runs in Docker)
echo -e "${CYAN}[3/5] Checking for runner Docker containers...${NC}"
RUNNER_CONTAINERS=$(docker ps -a --filter "name=runner" --format "{{.Names}}\t{{.Status}}" 2>/dev/null || echo "")
if [ ! -z "$RUNNER_CONTAINERS" ]; then
echo -e "${GREEN}✓ Found runner containers:${NC}"
echo "$RUNNER_CONTAINERS" | while read line; do
echo " $line"
done
else
echo -e "${YELLOW}⚠ No runner containers found${NC}"
fi
echo ""
# Check 4: Common runner directories
echo -e "${CYAN}[4/5] Checking common runner directories...${NC}"
RUNNER_DIRS=(
"/tmp/gitea-runner"
"/opt/gitea-runner"
"/home/*/gitea-runner"
"~/.gitea-runner"
"/usr/local/gitea-runner"
)
FOUND_DIRS=0
for dir in "${RUNNER_DIRS[@]}"; do
# Expand ~ and wildcards
EXPANDED_DIR=$(eval echo "$dir" 2>/dev/null || echo "")
if [ -d "$EXPANDED_DIR" ]; then
echo -e "${GREEN}✓ Found runner directory: $EXPANDED_DIR${NC}"
FOUND_DIRS=$((FOUND_DIRS + 1))
# Check for config files
if [ -f "$EXPANDED_DIR/.runner" ] || [ -f "$EXPANDED_DIR/config.yml" ]; then
echo " → Contains configuration files"
fi
fi
done
if [ $FOUND_DIRS -eq 0 ]; then
echo -e "${YELLOW}⚠ No runner directories found in common locations${NC}"
fi
echo ""
# Check 5: Network connections (check if runner is connecting to Gitea)
echo -e "${CYAN}[5/5] Checking network connections to Gitea...${NC}"
GITEA_URL="${GITEA_URL:-https://git.dk0.dev}"
if command -v netstat >/dev/null 2>&1; then
CONNECTIONS=$(netstat -tn 2>/dev/null | grep -E "(git.dk0.dev|3000|3001)" || echo "")
elif command -v ss >/dev/null 2>&1; then
CONNECTIONS=$(ss -tn 2>/dev/null | grep -E "(git.dk0.dev|3000|3001)" || echo "")
fi
if [ ! -z "$CONNECTIONS" ]; then
echo -e "${GREEN}✓ Found connections to Gitea:${NC}"
echo "$CONNECTIONS" | head -5
else
echo -e "${YELLOW}⚠ No active connections to Gitea found${NC}"
fi
echo ""
# Summary
echo -e "${BLUE}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}"
echo -e "${BLUE}Summary:${NC}"
echo ""
if [ ! -z "$RUNNER_PROCESSES" ] || [ ! -z "$RUNNER_CONTAINERS" ]; then
echo -e "${GREEN}✓ Runner appears to be running${NC}"
echo ""
echo "To check runner status in Gitea:"
echo " 1. Go to: https://git.dk0.dev/denshooter/portfolio/settings/actions/runners"
echo " 2. Check if runner-01 shows as 'online' or 'idle'"
echo ""
echo "To view runner logs:"
if [ ! -z "$RUNNER_PROCESSES" ]; then
echo " - Check process logs or journalctl"
fi
if [ ! -z "$RUNNER_CONTAINERS" ]; then
echo " - docker logs <container-name>"
fi
else
echo -e "${RED}✗ Runner does not appear to be running${NC}"
echo ""
echo "To start the runner:"
echo " 1. Find where the runner binary is located"
echo " 2. Check Gitea for registration token"
echo " 3. Run: ./act_runner register --config config.yml"
echo " 4. Run: ./act_runner daemon --config config.yml"
fi
echo ""
echo -e "${CYAN}For more information, check:${NC}"
echo " - Gitea Runner Docs: https://docs.gitea.com/usage/actions/act-runner"
echo " - Runner Status: https://git.dk0.dev/denshooter/portfolio/settings/actions/runners"
echo ""
-225
View File
@@ -1,225 +0,0 @@
#!/bin/bash
# Simplified Gitea deployment script for testing
# This version doesn't require database dependencies
set -e
# Configuration
PROJECT_NAME="portfolio"
CONTAINER_NAME="portfolio-app-simple"
IMAGE_NAME="portfolio-app"
PORT=3000
BACKUP_PORT=3001
LOG_FILE="./logs/gitea-deploy-simple.log"
# Colors for output
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color
# Logging function
log() {
echo -e "${BLUE}[$(date +'%Y-%m-%d %H:%M:%S')]${NC} $1" | tee -a "$LOG_FILE"
}
error() {
echo -e "${RED}[ERROR]${NC} $1" | tee -a "$LOG_FILE"
}
success() {
echo -e "${GREEN}[SUCCESS]${NC} $1" | tee -a "$LOG_FILE"
}
warning() {
echo -e "${YELLOW}[WARNING]${NC} $1" | tee -a "$LOG_FILE"
}
# Check if running as root (skip in CI environments)
if [[ $EUID -eq 0 ]] && [[ -z "$CI" ]]; then
error "This script should not be run as root (use CI=true to override)"
exit 1
fi
# Check if Docker is running
if ! docker info > /dev/null 2>&1; then
error "Docker is not running. Please start Docker and try again."
exit 1
fi
# Check if we're in the right directory
if [ ! -f "package.json" ] || [ ! -f "Dockerfile" ]; then
error "Please run this script from the project root directory"
exit 1
fi
log "🚀 Starting simplified Gitea deployment for $PROJECT_NAME"
# Step 1: Build Application
log "🔨 Step 1: Building application..."
# Build Next.js application
log "📦 Building Next.js application..."
npm run build || {
error "Build failed"
exit 1
}
success "✅ Application built successfully"
# Step 2: Docker Operations
log "🐳 Step 2: Docker operations..."
# Build Docker image
log "🏗️ Building Docker image..."
docker build -t "$IMAGE_NAME:latest" . || {
error "Docker build failed"
exit 1
}
# Tag with timestamp
TIMESTAMP=$(date +%Y%m%d-%H%M%S)
docker tag "$IMAGE_NAME:latest" "$IMAGE_NAME:$TIMESTAMP"
success "✅ Docker image built successfully"
# Step 3: Deployment
log "🚀 Step 3: Deploying application..."
# Export environment variables for docker-compose compatibility
log "📝 Exporting environment variables..."
export NODE_ENV=${NODE_ENV:-production}
export NEXT_PUBLIC_BASE_URL=${NEXT_PUBLIC_BASE_URL:-https://dk0.dev}
export MY_EMAIL=${MY_EMAIL:-contact@dk0.dev}
export MY_INFO_EMAIL=${MY_INFO_EMAIL:-info@dk0.dev}
export MY_PASSWORD="${MY_PASSWORD}"
export MY_INFO_PASSWORD="${MY_INFO_PASSWORD}"
export ADMIN_BASIC_AUTH="${ADMIN_BASIC_AUTH}"
export LOG_LEVEL=${LOG_LEVEL:-info}
export PORT=${PORT:-3000}
# Log which variables are set (without revealing secrets)
log "Environment variables configured:"
log " - NODE_ENV: ${NODE_ENV}"
log " - NEXT_PUBLIC_BASE_URL: ${NEXT_PUBLIC_BASE_URL}"
log " - MY_EMAIL: ${MY_EMAIL}"
log " - MY_INFO_EMAIL: ${MY_INFO_EMAIL}"
log " - MY_PASSWORD: [SET]"
log " - MY_INFO_PASSWORD: [SET]"
log " - ADMIN_BASIC_AUTH: [SET]"
log " - LOG_LEVEL: ${LOG_LEVEL}"
log " - PORT: ${PORT}"
# Check if container is running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" = "true" ]; then
log "📦 Stopping existing container..."
docker stop "$CONTAINER_NAME" || true
docker rm "$CONTAINER_NAME" || true
fi
# Check if port is available
if lsof -Pi :$PORT -sTCP:LISTEN -t >/dev/null ; then
warning "Port $PORT is in use. Trying backup port $BACKUP_PORT"
DEPLOY_PORT=$BACKUP_PORT
else
DEPLOY_PORT=$PORT
fi
# Start new container with minimal environment variables
log "🚀 Starting new container on port $DEPLOY_PORT..."
docker run -d \
--name "$CONTAINER_NAME" \
--restart unless-stopped \
-p "$DEPLOY_PORT:3000" \
-e NODE_ENV=production \
-e NEXT_PUBLIC_BASE_URL=https://dk0.dev \
-e MY_EMAIL=contact@dk0.dev \
-e MY_INFO_EMAIL=info@dk0.dev \
-e MY_PASSWORD=test-password \
-e MY_INFO_PASSWORD=test-password \
-e ADMIN_BASIC_AUTH=admin:test123 \
-e LOG_LEVEL=info \
"$IMAGE_NAME:latest" || {
error "Failed to start container"
exit 1
}
# Wait for container to be ready
log "⏳ Waiting for container to be ready..."
sleep 20
# Check if container is actually running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" != "true" ]; then
error "Container failed to start or crashed"
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=50
exit 1
fi
# Health check
log "🏥 Performing health check..."
HEALTH_CHECK_TIMEOUT=180
HEALTH_CHECK_INTERVAL=5
ELAPSED=0
while [ $ELAPSED -lt $HEALTH_CHECK_TIMEOUT ]; do
# Check if container is still running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" != "true" ]; then
error "Container stopped during health check"
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=50
exit 1
fi
# Try health check endpoint
if curl -f "http://localhost:$DEPLOY_PORT/api/health" > /dev/null 2>&1; then
success "✅ Application is healthy!"
break
fi
sleep $HEALTH_CHECK_INTERVAL
ELAPSED=$((ELAPSED + HEALTH_CHECK_INTERVAL))
echo -n "."
done
if [ $ELAPSED -ge $HEALTH_CHECK_TIMEOUT ]; then
error "Health check timeout. Application may not be running properly."
log "Container status:"
docker inspect "$CONTAINER_NAME" --format='{{.State.Status}} - {{.State.Health.Status}}'
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=100
exit 1
fi
# Step 4: Verification
log "✅ Step 4: Verifying deployment..."
# Test main page
if curl -f "http://localhost:$DEPLOY_PORT/" > /dev/null 2>&1; then
success "✅ Main page is accessible"
else
error "❌ Main page is not accessible"
exit 1
fi
# Show container status
log "📊 Container status:"
docker ps --filter "name=$CONTAINER_NAME" --format "table {{.Names}}\t{{.Status}}\t{{.Ports}}"
# Show resource usage
log "📈 Resource usage:"
docker stats --no-stream --format "table {{.Container}}\t{{.CPUPerc}}\t{{.MemUsage}}" "$CONTAINER_NAME"
# Final success message
success "🎉 Simplified Gitea deployment completed successfully!"
log "🌐 Application is available at: http://localhost:$DEPLOY_PORT"
log "🏥 Health check endpoint: http://localhost:$DEPLOY_PORT/api/health"
log "📊 Container name: $CONTAINER_NAME"
log "📝 Logs: docker logs $CONTAINER_NAME"
# Update deployment log
echo "$(date): Simplified Gitea deployment successful - Port: $DEPLOY_PORT - Image: $IMAGE_NAME:$TIMESTAMP" >> "$LOG_FILE"
exit 0
-257
View File
@@ -1,257 +0,0 @@
#!/bin/bash
# Gitea-specific deployment script
# Optimiert für lokalen Gitea Runner
set -e
# Configuration
PROJECT_NAME="portfolio"
CONTAINER_NAME="portfolio-app"
IMAGE_NAME="portfolio-app"
PORT=3000
BACKUP_PORT=3001
LOG_FILE="./logs/gitea-deploy.log"
# Colors for output
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color
# Logging function
log() {
echo -e "${BLUE}[$(date +'%Y-%m-%d %H:%M:%S')]${NC} $1" | tee -a "$LOG_FILE"
}
error() {
echo -e "${RED}[ERROR]${NC} $1" | tee -a "$LOG_FILE"
}
success() {
echo -e "${GREEN}[SUCCESS]${NC} $1" | tee -a "$LOG_FILE"
}
warning() {
echo -e "${YELLOW}[WARNING]${NC} $1" | tee -a "$LOG_FILE"
}
# Check if running as root (skip in CI environments)
if [[ $EUID -eq 0 ]] && [[ -z "$CI" ]]; then
error "This script should not be run as root (use CI=true to override)"
exit 1
fi
# Check if Docker is running
if ! docker info > /dev/null 2>&1; then
error "Docker is not running. Please start Docker and try again."
exit 1
fi
# Check if we're in the right directory
if [ ! -f "package.json" ] || [ ! -f "Dockerfile" ]; then
error "Please run this script from the project root directory"
exit 1
fi
log "🚀 Starting Gitea deployment for $PROJECT_NAME"
# Step 1: Code Quality Checks
log "📋 Step 1: Running code quality checks..."
# Run linting
log "🔍 Running ESLint..."
npm run lint || {
error "ESLint failed. Please fix the issues before deploying."
exit 1
}
# Run tests
log "🧪 Running tests..."
npm run test:production || {
error "Tests failed. Please fix the issues before deploying."
exit 1
}
success "✅ Code quality checks passed"
# Step 2: Build Application
log "🔨 Step 2: Building application..."
# Build Next.js application
log "📦 Building Next.js application..."
npm run build || {
error "Build failed"
exit 1
}
success "✅ Application built successfully"
# Step 3: Docker Operations
log "🐳 Step 3: Docker operations..."
# Build Docker image
log "🏗️ Building Docker image..."
docker build -t "$IMAGE_NAME:latest" . || {
error "Docker build failed"
exit 1
}
# Tag with timestamp
TIMESTAMP=$(date +%Y%m%d-%H%M%S)
docker tag "$IMAGE_NAME:latest" "$IMAGE_NAME:$TIMESTAMP"
success "✅ Docker image built successfully"
# Step 4: Deployment
log "🚀 Step 4: Deploying application..."
# Export environment variables for docker-compose compatibility
log "📝 Exporting environment variables..."
export NODE_ENV=${NODE_ENV:-production}
export NEXT_PUBLIC_BASE_URL=${NEXT_PUBLIC_BASE_URL:-https://dk0.dev}
export MY_EMAIL=${MY_EMAIL:-contact@dk0.dev}
export MY_INFO_EMAIL=${MY_INFO_EMAIL:-info@dk0.dev}
export MY_PASSWORD="${MY_PASSWORD}"
export MY_INFO_PASSWORD="${MY_INFO_PASSWORD}"
export ADMIN_BASIC_AUTH="${ADMIN_BASIC_AUTH}"
export LOG_LEVEL=${LOG_LEVEL:-info}
export PORT=${PORT:-3000}
# Log which variables are set (without revealing secrets)
log "Environment variables configured:"
log " - NODE_ENV: ${NODE_ENV}"
log " - NEXT_PUBLIC_BASE_URL: ${NEXT_PUBLIC_BASE_URL}"
log " - MY_EMAIL: ${MY_EMAIL}"
log " - MY_INFO_EMAIL: ${MY_INFO_EMAIL}"
log " - MY_PASSWORD: [SET]"
log " - MY_INFO_PASSWORD: [SET]"
log " - ADMIN_BASIC_AUTH: [SET]"
log " - LOG_LEVEL: ${LOG_LEVEL}"
log " - PORT: ${PORT}"
# Check if container is running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" = "true" ]; then
log "📦 Stopping existing container..."
docker stop "$CONTAINER_NAME" || true
docker rm "$CONTAINER_NAME" || true
fi
# Check if port is available
if lsof -Pi :$PORT -sTCP:LISTEN -t >/dev/null ; then
warning "Port $PORT is in use. Trying backup port $BACKUP_PORT"
DEPLOY_PORT=$BACKUP_PORT
else
DEPLOY_PORT=$PORT
fi
# Start new container with environment variables
log "🚀 Starting new container on port $DEPLOY_PORT..."
docker run -d \
--name "$CONTAINER_NAME" \
--restart unless-stopped \
-p "$DEPLOY_PORT:3000" \
-e NODE_ENV=production \
-e NEXT_PUBLIC_BASE_URL=https://dk0.dev \
-e MY_EMAIL=contact@dk0.dev \
-e MY_INFO_EMAIL=info@dk0.dev \
-e MY_PASSWORD="${MY_PASSWORD:-your-email-password}" \
-e MY_INFO_PASSWORD="${MY_INFO_PASSWORD:-your-info-email-password}" \
-e ADMIN_BASIC_AUTH="${ADMIN_BASIC_AUTH:-admin:your_secure_password_here}" \
-e LOG_LEVEL=info \
"$IMAGE_NAME:latest" || {
error "Failed to start container"
exit 1
}
# Wait for container to be ready
log "⏳ Waiting for container to be ready..."
sleep 15
# Check if container is actually running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" != "true" ]; then
error "Container failed to start or crashed"
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=50
exit 1
fi
# Health check
log "🏥 Performing health check..."
HEALTH_CHECK_TIMEOUT=120
HEALTH_CHECK_INTERVAL=3
ELAPSED=0
while [ $ELAPSED -lt $HEALTH_CHECK_TIMEOUT ]; do
# Check if container is still running
if [ "$(docker inspect -f '{{.State.Running}}' "$CONTAINER_NAME" 2>/dev/null)" != "true" ]; then
error "Container stopped during health check"
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=50
exit 1
fi
# Try health check endpoint
if curl -f "http://localhost:$DEPLOY_PORT/api/health" > /dev/null 2>&1; then
success "✅ Application is healthy!"
break
fi
sleep $HEALTH_CHECK_INTERVAL
ELAPSED=$((ELAPSED + HEALTH_CHECK_INTERVAL))
echo -n "."
done
if [ $ELAPSED -ge $HEALTH_CHECK_TIMEOUT ]; then
error "Health check timeout. Application may not be running properly."
log "Container status:"
docker inspect "$CONTAINER_NAME" --format='{{.State.Status}} - {{.State.Health.Status}}'
log "Container logs:"
docker logs "$CONTAINER_NAME" --tail=100
exit 1
fi
# Step 5: Verification
log "✅ Step 5: Verifying deployment..."
# Test main page
if curl -f "http://localhost:$DEPLOY_PORT/" > /dev/null 2>&1; then
success "✅ Main page is accessible"
else
error "❌ Main page is not accessible"
exit 1
fi
# Show container status
log "📊 Container status:"
docker ps --filter "name=$CONTAINER_NAME" --format "table {{.Names}}\t{{.Status}}\t{{.Ports}}"
# Show resource usage
log "📈 Resource usage:"
docker stats --no-stream --format "table {{.Container}}\t{{.CPUPerc}}\t{{.MemUsage}}" "$CONTAINER_NAME"
# Step 6: Cleanup
log "🧹 Step 6: Cleaning up old images..."
# Remove old images (keep last 3 versions)
docker images "$IMAGE_NAME" --format "table {{.Tag}}\t{{.ID}}" | tail -n +2 | head -n -3 | awk '{print $2}' | xargs -r docker rmi || {
warning "No old images to remove"
}
# Clean up unused Docker resources
docker system prune -f --volumes || {
warning "Failed to clean up Docker resources"
}
# Final success message
success "🎉 Gitea deployment completed successfully!"
log "🌐 Application is available at: http://localhost:$DEPLOY_PORT"
log "🏥 Health check endpoint: http://localhost:$DEPLOY_PORT/api/health"
log "📊 Container name: $CONTAINER_NAME"
log "📝 Logs: docker logs $CONTAINER_NAME"
# Update deployment log
echo "$(date): Gitea deployment successful - Port: $DEPLOY_PORT - Image: $IMAGE_NAME:$TIMESTAMP" >> "$LOG_FILE"
exit 0
-197
View File
@@ -1,197 +0,0 @@
// --------------------------------------------------------
// DATEN AUS DEN VORHERIGEN NODES HOLEN
// --------------------------------------------------------
// 1. Spotify Node
let spotifyData = null;
try {
spotifyData = $('Spotify').first().json;
} catch (e) {}
// 2. Lanyard Node (Discord)
let lanyardData = null;
try {
lanyardData = $('Lanyard').first().json.data;
} catch (e) {}
// 3. Wakapi Summary (Tages-Statistik)
let wakapiStats = null;
try {
const wRaw = $('Wakapi').first().json;
// Manchmal ist es direkt im Root, manchmal unter data
wakapiStats = wRaw.grand_total ? wRaw : (wRaw.data ? wRaw.data : null);
} catch (e) {}
// 4. Wakapi Heartbeats (Live Check)
let heartbeatsList = [];
try {
const response = $('WakapiLast').last().json;
if (response.data && Array.isArray(response.data)) {
heartbeatsList = response.data;
}
} catch (e) {}
// 5. Hardcover Reading (Neu!)
let hardcoverData = null;
try {
// Falls du einen Node "Hardcover" hast
hardcoverData = $('Hardcover').first().json;
} catch (e) {}
// --------------------------------------------------------
// LOGIK & FORMATIERUNG
// --------------------------------------------------------
// --- A. SPOTIFY / MUSIC ---
let music = null;
if (spotifyData && spotifyData.item && spotifyData.is_playing) {
music = {
isPlaying: true,
track: spotifyData.item.name,
artist: spotifyData.item.artists.map(a => a.name).join(', '),
album: spotifyData.item.album.name,
albumArt: spotifyData.item.album.images[0]?.url,
url: spotifyData.item.external_urls.spotify
};
} else if (lanyardData?.listening_to_spotify && lanyardData.spotify) {
music = {
isPlaying: true,
track: lanyardData.spotify.song,
artist: lanyardData.spotify.artist.replace(/;/g, ", "),
album: lanyardData.spotify.album,
albumArt: lanyardData.spotify.album_art_url,
url: `https://open.spotify.com/track/${lanyardData.spotify.track_id}`
};
}
// --- B. GAMING & STATUS ---
let gaming = null;
let status = {
text: lanyardData?.discord_status || "offline",
color: 'gray'
};
// Farben mapping
if (status.text === 'online') status.color = 'green';
if (status.text === 'idle') status.color = 'yellow';
if (status.text === 'dnd') status.color = 'red';
if (lanyardData?.activities) {
lanyardData.activities.forEach(act => {
// Type 0 = Game (Spotify ignorieren)
if (act.type === 0 && act.name !== "Spotify") {
let image = null;
if (act.assets?.large_image) {
if (act.assets.large_image.startsWith("mp:external")) {
image = act.assets.large_image.replace(/mp:external\/([^\/]*)\/(https?)\/(^\/]*)\/(.*)/,"$2://$3/$4");
} else {
image = `https://cdn.discordapp.com/app-assets/${act.application_id}/${act.assets.large_image}.png`;
}
}
gaming = {
isPlaying: true,
name: act.name,
details: act.details,
state: act.state,
image: image
};
}
});
}
// --- C. CODING (Wakapi Logic) ---
let coding = null;
// 1. Basis-Stats von heute (Fallback)
if (wakapiStats && wakapiStats.grand_total) {
coding = {
isActive: false,
stats: {
time: wakapiStats.grand_total.text,
topLang: wakapiStats.languages?.[0]?.name || "Code",
topProject: wakapiStats.projects?.[0]?.name || "Project"
}
};
}
// 2. Live Check via Heartbeats
if (heartbeatsList.length > 0) {
const latestBeat = heartbeatsList[heartbeatsList.length - 1];
if (latestBeat && latestBeat.time) {
const beatTime = new Date(latestBeat.time * 1000).getTime();
const now = new Date().getTime();
const diffMinutes = (now - beatTime) / 1000 / 60;
// Wenn jünger als 15 Minuten -> AKTIV
if (diffMinutes < 15) {
if (!coding) coding = { stats: { time: "Just started" } };
coding.isActive = true;
coding.project = latestBeat.project || coding.stats?.topProject;
if (latestBeat.entity) {
const parts = latestBeat.entity.split(/[/\\]/);
coding.file = parts[parts.length - 1];
}
coding.language = latestBeat.language;
}
}
}
// --- D. CUSTOM ACTIVITIES (Komplett dynamisch!) ---
// Hier kannst du beliebige Activities hinzufügen ohne Website Code zu ändern
let customActivities = {};
// Beispiel: Reading Activity (Hardcover Integration)
if (hardcoverData && hardcoverData.user_book) {
const book = hardcoverData.user_book;
customActivities.reading = {
enabled: true,
title: book.book?.title,
author: book.book?.contributions?.[0]?.author?.name,
progress: book.progress_pages && book.book?.pages
? Math.round((book.progress_pages / book.book.pages) * 100)
: undefined,
coverUrl: book.book?.image_url
};
}
// Beispiel: Manuell gesetzt via separatem Webhook
// Du kannst einen Webhook erstellen der customActivities setzt:
// POST /webhook/set-custom-activity
// {
// "type": "working_out",
// "data": {
// "enabled": true,
// "activity": "Running",
// "duration_minutes": 45,
// "distance_km": 7.2,
// "calories": 350
// }
// }
// Dann hier einfach: customActivities.working_out = $('SetCustomActivity').first().json.data;
// WICHTIG: Du kannst auch mehrere Activities gleichzeitig haben!
// customActivities.learning = { enabled: true, course: "Docker", platform: "Udemy", progress: 67 };
// customActivities.streaming = { enabled: true, platform: "Twitch", viewers: 42 };
// etc.
// --------------------------------------------------------
// OUTPUT
// --------------------------------------------------------
return {
json: {
status,
music,
gaming,
coding,
customActivities, // NEU! Komplett dynamisch
timestamp: new Date().toISOString()
}
};
-192
View File
@@ -1,192 +0,0 @@
#!/bin/bash
# Gitea Runner Setup Script
# Installiert und konfiguriert einen lokalen Gitea Runner
set -e
# Configuration
GITEA_URL="${GITEA_URL:-http://localhost:3000}"
RUNNER_NAME="${RUNNER_NAME:-portfolio-runner}"
RUNNER_LABELS="${RUNNER_LABELS:-ubuntu-latest,self-hosted,portfolio}"
RUNNER_WORK_DIR="${RUNNER_WORK_DIR:-/tmp/gitea-runner}"
# Colors for output
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color
# Logging function
log() {
echo -e "${BLUE}[$(date +'%Y-%m-%d %H:%M:%S')]${NC} $1"
}
error() {
echo -e "${RED}[ERROR]${NC} $1"
}
success() {
echo -e "${GREEN}[SUCCESS]${NC} $1"
}
warning() {
echo -e "${YELLOW}[WARNING]${NC} $1"
}
# Check if running as root (skip in CI environments)
if [[ $EUID -eq 0 ]] && [[ -z "$CI" ]]; then
error "This script should not be run as root (use CI=true to override)"
exit 1
fi
log "🚀 Setting up Gitea Runner for Portfolio"
# Check if Gitea URL is accessible
log "🔍 Checking Gitea server accessibility..."
if ! curl -f "$GITEA_URL" > /dev/null 2>&1; then
error "Cannot access Gitea server at $GITEA_URL"
error "Please make sure Gitea is running and accessible"
exit 1
fi
success "✅ Gitea server is accessible"
# Create runner directory
log "📁 Creating runner directory..."
mkdir -p "$RUNNER_WORK_DIR"
cd "$RUNNER_WORK_DIR"
# Download Gitea Runner
log "📥 Downloading Gitea Runner..."
RUNNER_VERSION="latest"
RUNNER_ARCH="linux-amd64"
# Get latest version
if [ "$RUNNER_VERSION" = "latest" ]; then
RUNNER_VERSION=$(curl -s https://api.github.com/repos/woodpecker-ci/woodpecker/releases/latest | grep -o '"tag_name": "[^"]*' | grep -o '[^"]*$')
fi
RUNNER_URL="https://github.com/woodpecker-ci/woodpecker/releases/download/${RUNNER_VERSION}/woodpecker-agent_${RUNNER_VERSION}_${RUNNER_ARCH}.tar.gz"
log "Downloading from: $RUNNER_URL"
curl -L -o woodpecker-agent.tar.gz "$RUNNER_URL"
# Extract runner
log "📦 Extracting Gitea Runner..."
tar -xzf woodpecker-agent.tar.gz
chmod +x woodpecker-agent
success "✅ Gitea Runner downloaded and extracted"
# Create systemd service
log "⚙️ Creating systemd service..."
sudo tee /etc/systemd/system/gitea-runner.service > /dev/null <<EOF
[Unit]
Description=Gitea Runner for Portfolio
After=network.target
[Service]
Type=simple
User=$USER
WorkingDirectory=$RUNNER_WORK_DIR
ExecStart=$RUNNER_WORK_DIR/woodpecker-agent
Restart=always
RestartSec=5
Environment=WOODPECKER_SERVER=$GITEA_URL
Environment=WOODPECKER_AGENT_SECRET=
Environment=WOODPECKER_LOG_LEVEL=info
[Install]
WantedBy=multi-user.target
EOF
# Reload systemd
sudo systemctl daemon-reload
success "✅ Systemd service created"
# Instructions for manual registration
log "📋 Manual registration required:"
echo ""
echo "1. Go to your Gitea instance: $GITEA_URL"
echo "2. Navigate to: Settings → Actions → Runners"
echo "3. Click 'Create new Runner'"
echo "4. Copy the registration token"
echo "5. Run the following command:"
echo ""
echo " cd $RUNNER_WORK_DIR"
echo " ./woodpecker-agent register --server $GITEA_URL --token YOUR_TOKEN"
echo ""
echo "6. After registration, start the service:"
echo " sudo systemctl enable gitea-runner"
echo " sudo systemctl start gitea-runner"
echo ""
echo "7. Check status:"
echo " sudo systemctl status gitea-runner"
echo ""
# Create helper scripts
log "📝 Creating helper scripts..."
# Start script
cat > "$RUNNER_WORK_DIR/start-runner.sh" << 'EOF'
#!/bin/bash
echo "Starting Gitea Runner..."
sudo systemctl start gitea-runner
sudo systemctl status gitea-runner
EOF
# Stop script
cat > "$RUNNER_WORK_DIR/stop-runner.sh" << 'EOF'
#!/bin/bash
echo "Stopping Gitea Runner..."
sudo systemctl stop gitea-runner
EOF
# Status script
cat > "$RUNNER_WORK_DIR/status-runner.sh" << 'EOF'
#!/bin/bash
echo "Gitea Runner Status:"
sudo systemctl status gitea-runner
echo ""
echo "Logs (last 20 lines):"
sudo journalctl -u gitea-runner -n 20 --no-pager
EOF
# Logs script
cat > "$RUNNER_WORK_DIR/logs-runner.sh" << 'EOF'
#!/bin/bash
echo "Gitea Runner Logs:"
sudo journalctl -u gitea-runner -f
EOF
chmod +x "$RUNNER_WORK_DIR"/*.sh
success "✅ Helper scripts created"
# Create environment file
cat > "$RUNNER_WORK_DIR/.env" << EOF
# Gitea Runner Configuration
GITEA_URL=$GITEA_URL
RUNNER_NAME=$RUNNER_NAME
RUNNER_LABELS=$RUNNER_LABELS
RUNNER_WORK_DIR=$RUNNER_WORK_DIR
EOF
log "📋 Setup Summary:"
echo " • Runner Directory: $RUNNER_WORK_DIR"
echo " • Gitea URL: $GITEA_URL"
echo " • Runner Name: $RUNNER_NAME"
echo " • Labels: $RUNNER_LABELS"
echo " • Helper Scripts: $RUNNER_WORK_DIR/*.sh"
echo ""
log "🎯 Next Steps:"
echo "1. Register the runner in Gitea web interface"
echo "2. Enable and start the service"
echo "3. Test with a workflow run"
echo ""
success "🎉 Gitea Runner setup completed!"
log "📁 All files are in: $RUNNER_WORK_DIR"
-79
View File
@@ -1,79 +0,0 @@
/* eslint-disable @typescript-eslint/no-require-imports */
const fetch = require('node-fetch');
require('dotenv').config();
const DIRECTUS_URL = process.env.DIRECTUS_URL || 'https://cms.dk0.dev';
const DIRECTUS_TOKEN = process.env.DIRECTUS_STATIC_TOKEN;
async function setupSnippets() {
console.log('📦 Setting up Snippets collection...');
// 1. Create Collection
try {
await fetch(`${DIRECTUS_URL}/collections`, {
method: 'POST',
headers: { 'Authorization': `Bearer ${DIRECTUS_TOKEN}`, 'Content-Type': 'application/json' },
body: JSON.stringify({
collection: 'snippets',
meta: { icon: 'terminal', display_template: '{{title}}' },
schema: { name: 'snippets' }
})
});
} catch (_e) {}
// 2. Add Fields
const fields = [
{ field: 'status', type: 'string', meta: { interface: 'select-dropdown' }, schema: { default_value: 'published' } },
{ field: 'title', type: 'string', meta: { interface: 'input' } },
{ field: 'category', type: 'string', meta: { interface: 'input' } },
{ field: 'code', type: 'text', meta: { interface: 'input-code' } },
{ field: 'description', type: 'text', meta: { interface: 'textarea' } },
{ field: 'language', type: 'string', meta: { interface: 'input' }, schema: { default_value: 'javascript' } },
{ field: 'featured', type: 'boolean', meta: { interface: 'boolean' }, schema: { default_value: false } }
];
for (const f of fields) {
try {
await fetch(`${DIRECTUS_URL}/fields/snippets`, {
method: 'POST',
headers: { 'Authorization': `Bearer ${DIRECTUS_TOKEN}`, 'Content-Type': 'application/json' },
body: JSON.stringify(f)
});
} catch (_e) {}
}
// 3. Add Example Data
const exampleSnippets = [
{
title: 'Traefik SSL Config',
category: 'Docker',
language: 'yaml',
featured: true,
description: "Meine Standard-Konfiguration für automatisches SSL via Let's Encrypt in Docker Swarm.",
code: "labels:\n - \"traefik.enable=true\"\n - \"traefik.http.routers.myapp.rule=Host(`example.com`)\"\n - \"traefik.http.routers.myapp.entrypoints=websecure\"\n - \"traefik.http.routers.myapp.tls.certresolver=myresolver\""
},
{
title: 'Docker Cleanup Alias',
category: 'ZSH',
language: 'bash',
featured: true,
description: 'Ein einfacher Alias, um ungenutzte Docker-Container, Images und Volumes schnell zu entfernen.',
code: "alias dclean='docker system prune -af --volumes'"
}
];
for (const s of exampleSnippets) {
try {
await fetch(`${DIRECTUS_URL}/items/snippets`, {
method: 'POST',
headers: { 'Authorization': `Bearer ${DIRECTUS_TOKEN}`, 'Content-Type': 'application/json' },
body: JSON.stringify(s)
});
} catch (_e) {}
}
console.log('✅ Snippets setup complete!');
}
setupSnippets();