[V0_FILE]typescriptreact:file="app/layout.tsx" isFixed="true" isQuickEdit="true" isMerged="true" import type React from "react" import type { Metadata } from "next" import { Geist, Geist_Mono } from "next/font/google" import "./globals.css" import { ClientRootLayout } from "./client-layout" const _geist = Geist({ subsets: ["latin"] }) const _geistMono = Geist_Mono({ subsets: ["latin"] }) export const metadata: Metadata = { title: "Canal 500k", description: "Gaming Platform", generator: "v0.app", } export default function RootLayout({ children, }: Readonly<{ children: React.ReactNode }>) { return ( {children} ) } [V0_FILE]typescriptreact:file="app/dashboard/layout.tsx" isMerged="true" "use client" import type React from "react" export default function DashboardLayout({ children, }: { children: React.ReactNode }) { return <>{children} } [V0_FILE]typescriptreact:file="components/ui/tabs.tsx" isQuickEdit="true" isMerged="true" "use client" import type * as React from "react" import * as TabsPrimitive from "@radix-ui/react-tabs" import { cn } from "@/lib/utils" function Tabs({ className, ...props }: React.ComponentProps) { return } function TabsList({ className, ...props }: React.ComponentProps) { return ( ) } function TabsTrigger({ className, ...props }: React.ComponentProps) { return ( ) } function TabsContent({ className, ...props }: React.ComponentProps) { return } export { Tabs, TabsList, TabsTrigger, TabsContent } [V0_FILE]jpg:file="public/banner-de-boas-vindas.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/banner-de-boas-vindas-yPgbypkHVxZHQUFExZbSWJdLzl01Lz.jpg" isMerged="true" [V0_FILE]jpg:file="public/professional-man-with-tuxedo-casino-dealer.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/professional-man-with-tuxedo-casino-dealer-nrMDsirDh0JK10ZCJmAciQWxBgVujj.jpg" isMerged="true" [V0_FILE]typescriptreact:file="app/client-layout.tsx" isMerged="true" "use client" import type React from "react" import { AuthProvider } from "@/context/auth-context" import { IframeProvider } from "@/context/iframe-context" import { SupportChat } from "@/components/support-chat" export function ClientRootLayout({ children, }: Readonly<{ children: React.ReactNode }>) { return ( {children} ) } export default ClientRootLayout [V0_FILE]typescript:file="middleware.ts" isMerged="true" import { type NextRequest, NextResponse } from "next/server" export function middleware(request: NextRequest) { if (request.nextUrl.pathname.startsWith("/adm")) { // In production, verify JWT or session token here // For now, allow access to /adm route directly from URL // Example: const user = request.cookies.get("user")?.value // if (!user) return NextResponse.redirect(new URL("/login", request.url)) } return NextResponse.next() } export const config = { matcher: ["/adm/:path*", "/dashboard/:path*", "/profile/:path*"], } [V0_FILE]png:file="public/whatsapp.png" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/whatsapp-4zBHvjtDUYUXyyCLBvhbcUqKaHeoMF.png" isMerged="true" [V0_FILE]typescriptreact:file="app/page.tsx" isMerged="true" "use client" import { useEffect } from "react" import { useRouter } from "next/navigation" import { useAuth } from "@/context/auth-context" export default function Home() { const { isAuthenticated, isLoading } = useAuth() const router = useRouter() useEffect(() => { if (!isLoading) { if (isAuthenticated) { router.push("/dashboard") } else { router.push("/login") } } }, [isAuthenticated, isLoading, router]) return (

) } [V0_FILE]typescriptreact:file="components/profile-modal.tsx" isQuickEdit="true" isMerged="true" "use client" import { useAuth } from "@/context/auth-context" import { useState } from "react" import { X, Edit2, Lock, Camera } from "lucide-react" import { Button } from "@/components/ui/button" interface ProfileModalProps { isOpen: boolean onClose: () => void } const tiers = [ { name: "Bronze", level: 5, color: "from-orange-600 to-orange-400" }, { name: "Prata", level: 10, color: "from-gray-500 to-gray-300" }, { name: "Ouro", level: 15, color: "from-yellow-600 to-yellow-400" }, { name: "Esmeralda", level: 20, color: "from-green-600 to-green-400" }, { name: "Rubi", level: 25, color: "from-red-600 to-red-400" }, { name: "Safira", level: 30, color: "from-blue-600 to-blue-400" }, { name: "Supreme", level: 35, color: "from-purple-600 to-purple-400" }, ] export function ProfileModal({ isOpen, onClose }: ProfileModalProps) { const { user } = useAuth() const [nome, setNome] = useState("") const [whatsapp, setWhatsapp] = useState("") const [editingName, setEditingName] = useState(false) const [editingWhatsapp, setEditingWhatsapp] = useState(false) if (!isOpen) return null const xp = user?.xp || 0 const maxXp = 10 return ( <>

{/* Header com botão fechar */}

Meu Perfil

{/* Conteúdo do modal */}

{user?.email}

{/* Campo Nome */}

Nome

setNome(e.target.value)} className="w-full bg-muted/50 border border-border rounded-lg px-4 py-3 text-foreground placeholder:text-muted-foreground focus:outline-none focus:border-primary transition-colors" />

{/* Campo WhatsApp */}

setWhatsapp(e.target.value)} className="w-full bg-muted/50 border border-border rounded-lg px-4 py-3 text-foreground placeholder:text-muted-foreground focus:outline-none focus:border-primary transition-colors" />

{/* XP Bar */}

Progresso XP: {xp}

0 {maxXp}

{/* Níveis e Premiações */}

Níveis e Premiações

{tiers.map((tier) => (

{tier.name}

Alcançado no nível {tier.level}

))}

) } import { User } from "lucide-react" [V0_FILE]typescriptreact:file="context/iframe-context.tsx" isMerged="true" "use client" import { createContext, useContext, useState, type ReactNode } from "react" interface IframeContextType { isIframeOpen: boolean setIsIframeOpen: (isOpen: boolean) => void } const IframeContext = createContext({ isIframeOpen: false, setIsIframeOpen: () => {}, }) export function IframeProvider({ children }: { children: ReactNode }) { const [isIframeOpen, setIsIframeOpen] = useState(false) return {children} } export const useIframe = () => useContext(IframeContext) [V0_FILE]json:file="package.json" isMerged="true" { "name": "my-v0-project", "version": "0.1.0", "private": true, "scripts": { "dev": "next dev", "build": "next build", "start": "next start", "lint": "eslint ." }, "dependencies": { "@hookform/resolvers": "^3.10.0", "@radix-ui/react-accordion": "1.2.2", "@radix-ui/react-alert-dialog": "1.1.4", "@radix-ui/react-aspect-ratio": "1.1.1", "@radix-ui/react-avatar": "1.1.2", "@radix-ui/react-checkbox": "1.1.3", "@radix-ui/react-collapsible": "1.1.2", "@radix-ui/react-context-menu": "2.2.4", "@radix-ui/react-dialog": "1.1.4", "@radix-ui/react-dropdown-menu": "2.1.4", "@radix-ui/react-hover-card": "1.1.4", "@radix-ui/react-label": "2.1.1", "@radix-ui/react-menubar": "1.1.4", "@radix-ui/react-navigation-menu": "1.2.3", "@radix-ui/react-popover": "1.1.4", "@radix-ui/react-progress": "1.1.1", "@radix-ui/react-radio-group": "1.2.2", "@radix-ui/react-scroll-area": "1.2.2", "@radix-ui/react-select": "2.1.4", "@radix-ui/react-separator": "1.1.1", "@radix-ui/react-slider": "1.2.2", "@radix-ui/react-slot": "1.1.1", "@radix-ui/react-switch": "1.1.2", "@radix-ui/react-tabs": "1.1.2", "@radix-ui/react-toast": "1.2.4", "@radix-ui/react-toggle": "1.1.1", "@radix-ui/react-toggle-group": "1.1.1", "@radix-ui/react-tooltip": "1.1.6", "@vercel/analytics": "1.3.1", "@supabase/supabase-js": "^2.49.2", "autoprefixer": "^10.4.20", "class-variance-authority": "^0.7.1", "clsx": "^2.1.1", "cmdk": "1.0.4", "date-fns": "4.1.0", "embla-carousel-react": "8.5.1", "input-otp": "1.4.1", "lucide-react": "^0.454.0", "next": "16.0.10", "next-themes": "^0.4.6", "react": "19.2.0", "react-day-picker": "9.8.0", "react-dom": "19.2.0", "react-hook-form": "^7.60.0", "react-resizable-panels": "^2.1.7", "recharts": "2.15.4", "sonner": "^1.7.4", "tailwind-merge": "^3.3.1", "vaul": "^0.9.9", "zod": "3.25.76", "framer-motion": "12.23.24", "tailwindcss-animate": "1.0.7" }, "devDependencies": { "@tailwindcss/postcss": "^4.1.9", "@types/node": "^22", "@types/react": "^19", "@types/react-dom": "^19", "postcss": "^8.5", "tailwindcss": "^4.1.9", "typescript": "^5" } } [V0_FILE]sql:file="scripts/001-create-users-table.sql" isMerged="true" -- Criar tabela de usuários CREATE TABLE IF NOT EXISTS users ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT UNIQUE NOT NULL, name TEXT, phone TEXT, avatar_url TEXT, level INTEGER DEFAULT 0, balance DECIMAL(10, 2) DEFAULT 0.00, is_vip BOOLEAN DEFAULT FALSE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Criar índice para melhor performance nas consultas CREATE INDEX IF NOT EXISTS idx_users_email ON users(email); CREATE INDEX IF NOT EXISTS idx_users_level ON users(level DESC); -- Habilitar RLS (Row Level Security) ALTER TABLE users ENABLE ROW LEVEL SECURITY; -- Política: usuários podem ver todos os perfis (para ranking) CREATE POLICY "Users can view all profiles" ON users FOR SELECT TO authenticated, anon USING (true); -- Política: usuários podem atualizar apenas seu próprio perfil CREATE POLICY "Users can update own profile" ON users FOR UPDATE TO authenticated USING (auth.uid()::text = id::text); -- Política: permitir inserção de novos usuários CREATE POLICY "Users can insert own profile" ON users FOR INSERT TO authenticated, anon WITH CHECK (true); -- Função para atualizar o updated_at automaticamente CREATE OR REPLACE FUNCTION update_updated_at_column() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; -- Trigger para atualizar updated_at CREATE TRIGGER update_users_updated_at BEFORE UPDATE ON users FOR EACH ROW EXECUTE FUNCTION update_updated_at_column(); [V0_FILE]sql:file="scripts/002-update-users-policies.sql" isMerged="true" -- Script para garantir que as políticas de RLS estão corretas -- e permitir updates sem autenticação (já que não estamos usando auth do Supabase) -- Remover políticas antigas se existirem DROP POLICY IF EXISTS "Users can view all profiles" ON users; DROP POLICY IF EXISTS "Users can update own profile" ON users; DROP POLICY IF EXISTS "Users can insert own profile" ON users; -- Recriar políticas mais permissivas para permitir updates -- NOTA: Em produção, você deve implementar autenticação adequada -- Política: permitir SELECT para todos CREATE POLICY "Enable read access for all users" ON users FOR SELECT USING (true); -- Política: permitir UPDATE para todos (temporário - implementar auth depois) CREATE POLICY "Enable update for all users" ON users FOR UPDATE USING (true); -- Política: permitir INSERT para todos CREATE POLICY "Enable insert for all users" ON users FOR INSERT WITH CHECK (true); -- Verificar se a tabela está correta SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'users' ORDER BY ordinal_position; [V0_FILE]sql:file="scripts/003-create-banners-table.sql" isMerged="true" -- Create banners table CREATE TABLE IF NOT EXISTS banners ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), image_url TEXT NOT NULL, link_url TEXT, display_order INTEGER NOT NULL DEFAULT 0, is_active BOOLEAN DEFAULT true, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Create index for faster queries CREATE INDEX IF NOT EXISTS idx_banners_order ON banners(display_order); CREATE INDEX IF NOT EXISTS idx_banners_active ON banners(is_active); -- Enable Row Level Security ALTER TABLE banners ENABLE ROW LEVEL SECURITY; -- Create policy to allow anyone to view active banners CREATE POLICY "Anyone can view active banners" ON banners FOR SELECT USING (is_active = true); -- Create policy to allow all operations (for now, since we don't have auth) CREATE POLICY "Allow all banner operations" ON banners FOR ALL USING (true) WITH CHECK (true); -- Create trigger to update updated_at CREATE OR REPLACE FUNCTION update_banners_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER banners_updated_at BEFORE UPDATE ON banners FOR EACH ROW EXECUTE FUNCTION update_banners_updated_at(); [V0_FILE]sql:file="scripts/004-create-site-settings-table.sql" isMerged="true" -- Create site_settings table to store app configurations CREATE TABLE IF NOT EXISTS site_settings ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), setting_key TEXT UNIQUE NOT NULL, setting_value TEXT, created_at TIMESTAMPTZ DEFAULT NOW(), updated_at TIMESTAMPTZ DEFAULT NOW() ); -- Create index for faster lookups CREATE INDEX IF NOT EXISTS idx_site_settings_key ON site_settings(setting_key); -- Enable RLS ALTER TABLE site_settings ENABLE ROW LEVEL SECURITY; -- Allow anyone to read settings (for frontend) CREATE POLICY "Allow public read access to settings" ON site_settings FOR SELECT USING (true); -- Allow anyone to insert/update settings (for admin panel) CREATE POLICY "Allow public write access to settings" ON site_settings FOR ALL USING (true); -- Create trigger to update updated_at CREATE OR REPLACE FUNCTION update_site_settings_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER site_settings_updated_at BEFORE UPDATE ON site_settings FOR EACH ROW EXECUTE FUNCTION update_site_settings_updated_at(); -- Insert default login popup image INSERT INTO site_settings (setting_key, setting_value) VALUES ('login_popup_image', 'https://hebbkx1anhila5yf.public.blob.vercel-storage.com/suporte-lK1J52ISj4Vj5vgfoeGIfUzS002jv7.png') ON CONFLICT (setting_key) DO NOTHING; [V0_FILE]sql:file="scripts/005-create-vip-pricing-table.sql" isMerged="true" -- Create VIP pricing table CREATE TABLE IF NOT EXISTS vip_pricing ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, plan_name TEXT NOT NULL UNIQUE, price DECIMAL(10, 2) NOT NULL, period TEXT NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP ); -- Insert default prices INSERT INTO vip_pricing (plan_name, price, period) VALUES ('mensal', 49.90, 'mês'), ('semestral', 179.90, '6 meses'), ('vitalicio', 397.90, 'uma única vez') ON CONFLICT (plan_name) DO NOTHING; -- Enable RLS ALTER TABLE vip_pricing ENABLE ROW LEVEL SECURITY; -- Policy to allow public read CREATE POLICY "Anyone can view VIP prices" ON vip_pricing FOR SELECT USING (true); -- Policy to allow update (for admin panel) CREATE POLICY "Anyone can update VIP prices" ON vip_pricing FOR UPDATE USING (true); -- Trigger to update updated_at CREATE OR REPLACE FUNCTION update_vip_pricing_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = CURRENT_TIMESTAMP; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER vip_pricing_updated_at BEFORE UPDATE ON vip_pricing FOR EACH ROW EXECUTE FUNCTION update_vip_pricing_updated_at(); [V0_FILE]sql:file="scripts/006-add-background-settings.sql" isMerged="true" -- Add background settings to site_settings table -- This allows customization of login and dashboard backgrounds for desktop and mobile -- Insert default background settings INSERT INTO site_settings (setting_key, setting_value) VALUES ('background_desktop_url', ''), ('background_mobile_url', ''), ('use_default_background', 'true') ON CONFLICT (setting_key) DO NOTHING; -- Add comment COMMENT ON TABLE site_settings IS 'Stores site-wide settings including backgrounds, login popup image, etc.'; [V0_FILE]typescript:file="utils/supabase.ts" isMerged="true" // Re-export from the correct location for backwards compatibility export { supabase } from "@/lib/supabase" [V0_FILE]sql:file="scripts/007-create-awards-config-table.sql" isMerged="true" -- Create awards configuration table CREATE TABLE IF NOT EXISTS awards_config ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, award_name TEXT NOT NULL UNIQUE, award_level INTEGER NOT NULL, image_url TEXT, description TEXT, color_gradient TEXT NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Insert default awards INSERT INTO awards_config (award_name, award_level, color_gradient, description) VALUES ('Bronze', 5, 'from-orange-600 to-orange-400', 'Primeiro passo na jornada. Desbloqueie recompensas exclusivas e mostre seu progresso.'), ('Prata', 10, 'from-gray-500 to-gray-300', 'Evolução constante. Acesse benefícios intermediários e destaque-se na comunidade.'), ('Ouro', 15, 'from-yellow-600 to-yellow-400', 'Excelência reconhecida. Ganhe vantagens premium e bônus especiais.'), ('Esmeralda', 20, 'from-green-600 to-green-400', 'Elite do conhecimento. Desbloqueie conteúdos avançados e recompensas raras.'), ('Rubi', 25, 'from-red-600 to-red-400', 'Maestria comprovada. Acesse funcionalidades exclusivas e multiplicadores de XP.'), ('Safira', 30, 'from-blue-600 to-blue-400', 'Lendário no sistema. Receba prioridade e privilégios únicos na plataforma.'), ('Supreme', 35, 'from-purple-600 to-purple-400', 'O topo absoluto. Desfrute de todas as vantagens e reconhecimento máximo.') ON CONFLICT (award_name) DO NOTHING; -- Create trigger to update updated_at CREATE OR REPLACE FUNCTION update_awards_config_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER trigger_update_awards_config_updated_at BEFORE UPDATE ON awards_config FOR EACH ROW EXECUTE FUNCTION update_awards_config_updated_at(); -- Enable RLS ALTER TABLE awards_config ENABLE ROW LEVEL SECURITY; -- Create policies CREATE POLICY "Anyone can view awards config" ON awards_config FOR SELECT USING (true); CREATE POLICY "Anyone can update awards config" ON awards_config FOR UPDATE USING (true); [V0_FILE]typescriptreact:file="components/award-modal.tsx" isQuickEdit="true" isMerged="true" "use client" import { X } from "lucide-react" import { useRouter } from "next/navigation" interface AwardModalProps { isOpen: boolean onClose: () => void award: { name: string level: number color: string description?: string image?: string } isVip: boolean } export function AwardModal({ isOpen, onClose, award, isVip }: AwardModalProps) { const router = useRouter() if (!isOpen) return null const handleBecomVip = () => { router.push("/vip") } return (

{award.image ? (

) : (

)}

{award.name}

NÍVEL {award.level}

{award.description && (

Sobre esta premiação

{award.description}

)} {!isVip && (

🔒 Apenas VIPs podem receber essa premiação

)} {isVip && (

✓ Você é VIP! Premiação desbloqueada

)}

) } [V0_FILE]sql:file="scripts/008-create-notice-popup-table.sql" isMerged="true" -- Criar tabela para configuração do pop-up de avisos CREATE TABLE IF NOT EXISTS notice_popup_config ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), is_enabled BOOLEAN DEFAULT false, aspect_ratio VARCHAR(10) DEFAULT '16:9' CHECK (aspect_ratio IN ('16:9', '9:16')), media_type VARCHAR(10) DEFAULT 'image' CHECK (media_type IN ('image', 'video')), media_url TEXT, description TEXT, button_text VARCHAR(100) DEFAULT 'Ver mais', button_link TEXT, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Inserir configuração padrão INSERT INTO notice_popup_config ( is_enabled, aspect_ratio, media_type, media_url, description, button_text, button_link ) VALUES ( false, '16:9', 'image', '', 'Confira as novidades da plataforma!', 'Ver mais', '#' ) ON CONFLICT DO NOTHING; -- Criar trigger para atualizar updated_at automaticamente CREATE OR REPLACE FUNCTION update_notice_popup_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER notice_popup_config_updated_at BEFORE UPDATE ON notice_popup_config FOR EACH ROW EXECUTE FUNCTION update_notice_popup_updated_at(); -- Habilitar Row Level Security (RLS) ALTER TABLE notice_popup_config ENABLE ROW LEVEL SECURITY; -- Permitir leitura pública CREATE POLICY "Allow public read access to notice popup config" ON notice_popup_config FOR SELECT TO public USING (true); -- Permitir insert/update sem autenticação (para o painel ADM) CREATE POLICY "Allow public insert/update access to notice popup config" ON notice_popup_config FOR ALL TO public USING (true) WITH CHECK (true); [V0_FILE]sql:file="scripts/009-create-xp-system.sql" isMerged="true" -- Sistema completo de XP e Níveis -- Criado para rastrear progressão de usuários através de login diário e tempo de uso -- Adicionar campos de XP e nível na tabela users ALTER TABLE users ADD COLUMN IF NOT EXISTS xp INTEGER DEFAULT 0; ALTER TABLE users ADD COLUMN IF NOT EXISTS last_login_date DATE; ALTER TABLE users ADD COLUMN IF NOT EXISTS last_usage_reset DATE; -- Criar tabela de tracking de tempo de uso diário CREATE TABLE IF NOT EXISTS daily_usage_tracking ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES users(id) ON DELETE CASCADE, date DATE NOT NULL DEFAULT CURRENT_DATE, ia_time_minutes INTEGER DEFAULT 0, vision_time_minutes INTEGER DEFAULT 0, total_time_minutes INTEGER DEFAULT 0, xp_10min_claimed BOOLEAN DEFAULT false, xp_30min_claimed BOOLEAN DEFAULT false, xp_1hour_claimed BOOLEAN DEFAULT false, xp_2hour_claimed BOOLEAN DEFAULT false, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), UNIQUE(user_id, date) ); -- Criar índices para melhor performance CREATE INDEX IF NOT EXISTS idx_daily_usage_user_date ON daily_usage_tracking(user_id, date); CREATE INDEX IF NOT EXISTS idx_users_xp ON users(xp DESC); CREATE INDEX IF NOT EXISTS idx_users_level ON users(level DESC); -- Habilitar Row Level Security ALTER TABLE daily_usage_tracking ENABLE ROW LEVEL SECURITY; -- Políticas de acesso CREATE POLICY "Usuários podem ver seu próprio tracking" ON daily_usage_tracking FOR SELECT USING (true); CREATE POLICY "Usuários podem inserir seu próprio tracking" ON daily_usage_tracking FOR INSERT WITH CHECK (true); CREATE POLICY "Usuários podem atualizar seu próprio tracking" ON daily_usage_tracking FOR UPDATE USING (true); -- Trigger para atualizar updated_at CREATE OR REPLACE FUNCTION update_daily_usage_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER daily_usage_updated_at BEFORE UPDATE ON daily_usage_tracking FOR EACH ROW EXECUTE FUNCTION update_daily_usage_updated_at(); -- Comentários explicativos COMMENT ON TABLE daily_usage_tracking IS 'Rastreia tempo de uso diário e XP ganho por usuário'; COMMENT ON COLUMN users.xp IS 'Total de XP acumulado pelo usuário'; COMMENT ON COLUMN users.last_login_date IS 'Data do último login para controle de XP diário'; COMMENT ON COLUMN users.last_usage_reset IS 'Data do último reset de tempo de uso'; [V0_FILE]typescript:file="lib/xp-system.ts" isMerged="true" // Sistema de XP e Níveis // Gerencia progressão de usuários através de login diário e tempo de uso // Configuração de XP por atividade export const XP_REWARDS = { DAILY_LOGIN: 3, TIME_10MIN: 3, TIME_30MIN: 2, TIME_1HOUR: 2, TIME_2HOUR: 2, } // Configuração de progressão de níveis (XP necessário por nível) export const LEVEL_XP_REQUIREMENTS: { [key: number]: number } = { // Níveis 0-5: 12 XP por nível 1: 12, 2: 12, 3: 12, 4: 12, 5: 12, // Níveis 5-10: 38 XP por nível 6: 38, 7: 38, 8: 38, 9: 38, 10: 38, // Níveis 10-15: 44 XP por nível 11: 44, 12: 44, 13: 44, 14: 44, 15: 44, // Níveis 15-20: 72 XP por nível 16: 72, 17: 72, 18: 72, 19: 72, 20: 72, // Níveis 20-25: 102 XP por nível 21: 102, 22: 102, 23: 102, 24: 102, 25: 102, // Níveis 25-30: 147 XP por nível 26: 147, 27: 147, 28: 147, 29: 147, 30: 147, // Níveis 30-35: 192 XP por nível 31: 192, 32: 192, 33: 192, 34: 192, 35: 192, } // Calcular nível baseado no XP total export function calculateLevel(totalXp: number): number { let level = 0 let xpNeeded = 0 for (let i = 1; i <= 35; i++) { xpNeeded += LEVEL_XP_REQUIREMENTS[i] || 0 if (totalXp >= xpNeeded) { level = i } else { break } } return level } // Calcular XP necessário para o próximo nível export function getXpForNextLevel(currentLevel: number): number { if (currentLevel >= 35) return 0 return LEVEL_XP_REQUIREMENTS[currentLevel + 1] || 0 } // Calcular XP total necessário até um nível específico export function getTotalXpForLevel(level: number): number { let total = 0 for (let i = 1; i <= level; i++) { total += LEVEL_XP_REQUIREMENTS[i] || 0 } return total } // Calcular progresso atual para o próximo nível (0-100%) export function getLevelProgress(totalXp: number, currentLevel: number): number { if (currentLevel >= 35) return 100 const xpForCurrentLevel = getTotalXpForLevel(currentLevel) const xpForNextLevel = getTotalXpForLevel(currentLevel + 1) const xpInCurrentLevel = totalXp - xpForCurrentLevel const xpNeededForLevel = xpForNextLevel - xpForCurrentLevel return Math.min(100, Math.max(0, (xpInCurrentLevel / xpNeededForLevel) * 100)) } // Obter tier de premiação baseado no nível export function getTierByLevel(level: number): string { if (level >= 30) return "Supreme" if (level >= 25) return "Safira" if (level >= 20) return "Rubi" if (level >= 15) return "Esmeralda" if (level >= 10) return "Ouro" if (level >= 5) return "Prata" return "Bronze" } // Obter cor do tier export function getTierColor(tier: string): string { const colors: { [key: string]: string } = { Bronze: "#CD7F32", Prata: "#C0C0C0", Ouro: "#FFD700", Esmeralda: "#50C878", Rubi: "#E0115F", Safira: "#0F52BA", Supreme: "#9400D3", } return colors[tier] || "#CD7F32" } [V0_FILE]typescript:file="hooks/use-xp-tracker.ts" isMerged="true" "use client" import { useEffect, useRef, useState } from "react" import { supabase } from "@/lib/supabase" import { XP_REWARDS } from "@/lib/xp-system" export function useXpTracker(userId: string | undefined, currentTab: string) { const [isTracking, setIsTracking] = useState(false) const startTimeRef = useRef(0) const accumulatedTimeRef = useRef(0) const intervalRef = useRef(null) // Verificar e conceder XP de login diário const checkDailyLogin = async () => { if (!userId) return try { const today = new Date().toISOString().split("T")[0] const { data: user } = await supabase.from("users").select("last_login_date, xp").eq("id", userId).single() if (!user) return // Se o último login foi em um dia diferente, conceder XP if (user.last_login_date !== today) { const newXp = (user.xp || 0) + XP_REWARDS.DAILY_LOGIN await supabase .from("users") .update({ last_login_date: today, xp: newXp, }) .eq("id", userId) console.log("[v0] XP de login diário concedido:", XP_REWARDS.DAILY_LOGIN) } } catch (error) { console.error("[v0] Erro ao verificar login diário:", error) } } // Iniciar tracking de tempo const startTracking = () => { if (currentTab !== "ia" && currentTab !== "vision") return startTimeRef.current = Date.now() setIsTracking(true) // Atualizar a cada minuto intervalRef.current = setInterval(async () => { const elapsedMinutes = Math.floor((Date.now() - startTimeRef.current) / 60000) accumulatedTimeRef.current += elapsedMinutes startTimeRef.current = Date.now() if (accumulatedTimeRef.current > 0) { await updateUsageTime(accumulatedTimeRef.current) accumulatedTimeRef.current = 0 } }, 60000) // A cada 1 minuto } // Parar tracking const stopTracking = () => { if (intervalRef.current) { clearInterval(intervalRef.current) intervalRef.current = null } // Salvar tempo acumulado final if (accumulatedTimeRef.current > 0) { const elapsedMinutes = Math.floor((Date.now() - startTimeRef.current) / 60000) updateUsageTime(accumulatedTimeRef.current + elapsedMinutes) accumulatedTimeRef.current = 0 } setIsTracking(false) } // Atualizar tempo de uso e conceder XP const updateUsageTime = async (minutes: number) => { if (!userId || minutes === 0) return try { const today = new Date().toISOString().split("T")[0] // Buscar ou criar registro de tracking diário let { data: tracking } = await supabase .from("daily_usage_tracking") .select("*") .eq("user_id", userId) .eq("date", today) .single() const isIaTab = currentTab === "ia" const fieldToUpdate = isIaTab ? "ia_time_minutes" : "vision_time_minutes" if (!tracking) { // Criar novo registro const { data: newTracking } = await supabase .from("daily_usage_tracking") .insert({ user_id: userId, date: today, [fieldToUpdate]: minutes, total_time_minutes: minutes, }) .select() .single() tracking = newTracking } else { // Atualizar registro existente const newTime = (tracking[fieldToUpdate] || 0) + minutes const newTotal = (tracking.total_time_minutes || 0) + minutes await supabase .from("daily_usage_tracking") .update({ [fieldToUpdate]: newTime, total_time_minutes: newTotal, }) .eq("id", tracking.id) tracking = { ...tracking, [fieldToUpdate]: newTime, total_time_minutes: newTotal } } // Verificar e conceder XP baseado em marcos de tempo await checkAndGrantTimeXp(tracking) } catch (error) { console.error("[v0] Erro ao atualizar tempo de uso:", error) } } // Verificar e conceder XP por tempo de uso const checkAndGrantTimeXp = async (tracking: any) => { if (!userId || !tracking) return const totalMinutes = tracking.total_time_minutes || 0 let xpToGrant = 0 // Verificar marcos de tempo e conceder XP (máximo 2 horas = 120 minutos) if (totalMinutes >= 120 && !tracking.xp_2hour_claimed) { xpToGrant += XP_REWARDS.TIME_2HOUR await supabase.from("daily_usage_tracking").update({ xp_2hour_claimed: true }).eq("id", tracking.id) } else if (totalMinutes >= 60 && !tracking.xp_1hour_claimed) { xpToGrant += XP_REWARDS.TIME_1HOUR await supabase.from("daily_usage_tracking").update({ xp_1hour_claimed: true }).eq("id", tracking.id) } else if (totalMinutes >= 30 && !tracking.xp_30min_claimed) { xpToGrant += XP_REWARDS.TIME_30MIN await supabase.from("daily_usage_tracking").update({ xp_30min_claimed: true }).eq("id", tracking.id) } else if (totalMinutes >= 10 && !tracking.xp_10min_claimed) { xpToGrant += XP_REWARDS.TIME_10MIN await supabase.from("daily_usage_tracking").update({ xp_10min_claimed: true }).eq("id", tracking.id) } // Conceder XP ao usuário if (xpToGrant > 0) { const { data: user } = await supabase.from("users").select("xp").eq("id", userId).single() if (user) { await supabase .from("users") .update({ xp: (user.xp || 0) + xpToGrant }) .eq("id", userId) console.log("[v0] XP de tempo de uso concedido:", xpToGrant) } } } // Verificar login diário ao montar useEffect(() => { checkDailyLogin() }, [userId]) // Gerenciar tracking baseado na aba atual useEffect(() => { if (userId && (currentTab === "ia" || currentTab === "vision")) { startTracking() } else { stopTracking() } return () => stopTracking() }, [userId, currentTab]) return { isTracking } } [V0_FILE]typescriptreact:file="components/ranking-section.tsx" isMerged="true" "use client" import { Users } from "lucide-react" import { useEffect, useState } from "react" import { supabase } from "@/lib/supabase" interface RankingUser { position: number avatar: string name: string level: number xp: number levelColor: string } export function RankingSection() { const [users, setUsers] = useState([]) const [loading, setLoading] = useState(true) useEffect(() => { fetchRanking() }, []) const fetchRanking = async () => { try { const { data, error } = await supabase .from("users") .select("id, email, name, level, xp, avatar_url") .order("level", { ascending: false }) .order("xp", { ascending: false }) .limit(50) if (error) { console.error("[v0] Error fetching ranking:", error) return } const formattedUsers: RankingUser[] = (data || []).map((user, index) => ({ position: index + 1, avatar: user.avatar_url || user.name?.charAt(0).toUpperCase() || "?", name: user.name || user.email.split("@")[0], level: user.level || 0, xp: user.xp || 0, levelColor: getLevelColor(user.level || 0), })) setUsers(formattedUsers) } catch (error) { console.error("[v0] Error in fetchRanking:", error) } finally { setLoading(false) } } const getLevelColor = (level: number) => { if (level >= 35) return "bg-purple-500/20 text-purple-300" if (level >= 30) return "bg-blue-500/20 text-blue-300" if (level >= 25) return "bg-red-500/20 text-red-300" if (level >= 20) return "bg-green-500/20 text-green-300" if (level >= 15) return "bg-yellow-500/20 text-yellow-300" if (level >= 10) return "bg-gray-400/20 text-gray-300" if (level >= 5) return "bg-orange-500/20 text-orange-300" return "bg-primary/20 text-primary" } return (

Ranking Geral

{loading ? (

Carregando...

) : users.length === 0 ? (

Nenhum usuário no momento

) : ( users.map((user) => (

{user.position}

{user.avatar.startsWith("data:") ? (

) : ( user.avatar )}

{user.name}

Lvl {user.level}

)) )}

) } [V0_FILE]sql:file="scripts/010-create-tournaments-table.sql" isMerged="true" -- Tabela de Torneios -- Armazena informações sobre torneios de XP com período de tempo definido CREATE TABLE IF NOT EXISTS tournaments ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name VARCHAR(255) NOT NULL, start_date TIMESTAMP WITH TIME ZONE NOT NULL, end_date TIMESTAMP WITH TIME ZONE NOT NULL, is_enabled BOOLEAN DEFAULT false, top_limit INTEGER DEFAULT 10, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Índices para performance CREATE INDEX IF NOT EXISTS idx_tournaments_dates ON tournaments(start_date, end_date); CREATE INDEX IF NOT EXISTS idx_tournaments_enabled ON tournaments(is_enabled); -- Habilitar Row Level Security ALTER TABLE tournaments ENABLE ROW LEVEL SECURITY; -- Políticas de acesso (apenas leitura pública, admin gerencia via backend) CREATE POLICY "Qualquer um pode ver torneios habilitados" ON tournaments FOR SELECT USING (is_enabled = true); CREATE POLICY "Admin pode fazer tudo" ON tournaments FOR ALL USING (true) WITH CHECK (true); -- Trigger para atualizar updated_at CREATE OR REPLACE FUNCTION update_tournament_updated_at() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER tournament_updated_at BEFORE UPDATE ON tournaments FOR EACH ROW EXECUTE FUNCTION update_tournament_updated_at(); -- Comentários COMMENT ON TABLE tournaments IS 'Gerencia torneios de XP com períodos específicos'; COMMENT ON COLUMN tournaments.name IS 'Nome do torneio'; COMMENT ON COLUMN tournaments.start_date IS 'Data e hora de início do torneio'; COMMENT ON COLUMN tournaments.end_date IS 'Data e hora de fim do torneio'; COMMENT ON COLUMN tournaments.is_enabled IS 'Se o torneio está ativo'; COMMENT ON COLUMN tournaments.top_limit IS 'Limite de posições a mostrar no ranking'; [V0_FILE]sql:file="scripts/011-create-support-settings.sql" isMerged="true" -- Tabela para armazenar configurações de suporte (link do WhatsApp) CREATE TABLE IF NOT EXISTS support_settings ( id SERIAL PRIMARY KEY, whatsapp_link TEXT NOT NULL DEFAULT 'https://wa.me/5511999999999', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Inserir configuração padrão INSERT INTO support_settings (whatsapp_link) VALUES ('https://wa.me/5511999999999') ON CONFLICT DO NOTHING; -- Criar índice para melhorar performance CREATE INDEX IF NOT EXISTS idx_support_settings_id ON support_settings(id); [V0_FILE]typescript:file="lib/supabase.ts" isMerged="true" import { createClient } from "@supabase/supabase-js" const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL || "https://tejxmbdbbsfoorowljek.supabase.co" const supabaseAnonKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY || "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InRlanhtYmRiYnNmb29yb3dsamVrIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NjIyNjM2NTksImV4cCI6MjA3NzgzOTY1OX0._26Pgq4JF-Qsl-gkGaCIUmgX1gVLZ4Sf6BEs_YbSdrc" export const supabase = createClient(supabaseUrl, supabaseAnonKey) [V0_FILE]plaintext:file=".env.local" isMerged="true" NEXT_PUBLIC_SUPABASE_URL=https://tejxmbdbbsfoorowljek.supabase.co NEXT_PUBLIC_SUPABASE_ANON_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InRlanhtYmRiYnNmb29yb3dsamVrIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NjIyNjM2NTksImV4cCI6MjA3NzgzOTY1OX0._26Pgq4JF-Qsl-gkGaCIUmgX1gVLZ4Sf6BEs_YbSdrc [V0_FILE]sql:file="scripts/create-tournament-xp-table.sql" isMerged="true" -- Create tournament_xp table to track XP earned during tournaments CREATE TABLE IF NOT EXISTS tournament_xp ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), tournament_id UUID NOT NULL REFERENCES tournaments(id) ON DELETE CASCADE, user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, total_xp INTEGER NOT NULL DEFAULT 0, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), UNIQUE(tournament_id, user_id) ); -- Create index for faster queries CREATE INDEX IF NOT EXISTS idx_tournament_xp_tournament ON tournament_xp(tournament_id); CREATE INDEX IF NOT EXISTS idx_tournament_xp_user ON tournament_xp(user_id); CREATE INDEX IF NOT EXISTS idx_tournament_xp_total ON tournament_xp(total_xp DESC); -- Add prize_description column to tournaments table if it doesn't exist ALTER TABLE tournaments ADD COLUMN IF NOT EXISTS prize_description TEXT DEFAULT 'A definir'; [V0_FILE]typescriptreact:file="components/ia-iframe-modal.tsx" isMerged="true" "use client" import { X } from "lucide-react" interface IaIframeModalProps { isOpen: boolean onClose: () => void } export function IaIframeModal({ isOpen, onClose }: IaIframeModalProps) { if (!isOpen) return null return (

{/* Close button */}

{/* Iframe container */}