// ============================================
// SISTEMA DE LIKES Y REACCIONES
// ============================================

/**
 * Obtener conteo de likes para un contenido
 */
function get_likes_count($content_type, $content_id) {
    global $db;
    $stmt = $db->prepare("SELECT COUNT(*) as count FROM likes WHERE content_type = ? AND content_id = ?");
    $stmt->execute([$content_type, $content_id]);
    $result = $stmt->fetch();
    return $result['count'] ?? 0;
}

/**
 * Verificar si el usuario actual ha dado like
 */
function user_has_liked($content_type, $content_id, $user_id) {
    global $db;
    $stmt = $db->prepare("SELECT id FROM likes WHERE content_type = ? AND content_id = ? AND user_id = ?");
    $stmt->execute([$content_type, $content_id, $user_id]);
    return $stmt->fetch() !== false;
}

/**
 * Toggle like (agregar o quitar)
 */
function toggle_like($content_type, $content_id, $user_id) {
    global $db;
    
    try {
        $db->beginTransaction();
        
        // Verificar si ya existe
        $stmt = $db->prepare("SELECT id FROM likes WHERE content_type = ? AND content_id = ? AND user_id = ?");
        $stmt->execute([$content_type, $content_id, $user_id]);
        $existing = $stmt->fetch();
        
        if ($existing) {
            // Eliminar like
            $stmt = $db->prepare("DELETE FROM likes WHERE content_type = ? AND content_id = ? AND user_id = ?");
            $stmt->execute([$content_type, $content_id, $user_id]);
            $action = 'removed';
        } else {
            // Agregar like
            $stmt = $db->prepare("INSERT INTO likes (content_type, content_id, user_id) VALUES (?, ?, ?)");
            $stmt->execute([$content_type, $content_id, $user_id]);
            $action = 'added';
        }
        
        // Actualizar contador en la tabla principal
        $table_map = [
            'blog_post' => 'blog_posts',
            'investigation' => 'investigations',
            'esoterism' => 'esoterism_content'
        ];
        
        if (isset($table_map[$content_type])) {
            $table = $table_map[$content_type];
            $count = get_likes_count($content_type, $content_id);
            $stmt = $db->prepare("UPDATE {$table} SET likes_count = ? WHERE id = ?");
            $stmt->execute([$count, $content_id]);
        }
        
        $db->commit();
        return ['success' => true, 'action' => $action, 'count' => get_likes_count($content_type, $content_id)];
        
    } catch (Exception $e) {
        $db->rollBack();
        return ['success' => false, 'error' => $e->getMessage()];
    }
}

// ============================================
// SISTEMA DE COMENTARIOS
// ============================================

/**
 * Obtener comentarios de un contenido
 */
function get_comments($content_type, $content_id, $parent_id = null) {
    global $db;
    
    $sql = "SELECT c.*, u.username, u.first_name, u.last_name, u.profile_image
            FROM comments c
            INNER JOIN users u ON c.user_id = u.id
            WHERE c.content_type = ? AND c.content_id = ? AND c.is_approved = 1";
    
    if ($parent_id === null) {
        $sql .= " AND c.parent_id IS NULL";
        $params = [$content_type, $content_id];
    } else {
        $sql .= " AND c.parent_id = ?";
        $params = [$content_type, $content_id, $parent_id];
    }
    
    $sql .= " ORDER BY c.created_at DESC";
    
    $stmt = $db->prepare($sql);
    $stmt->execute($params);
    return $stmt->fetchAll();
}

/**
 * Contar comentarios de un contenido
 */
function get_comments_count($content_type, $content_id) {
    global $db;
    $stmt = $db->prepare("SELECT COUNT(*) as count FROM comments WHERE content_type = ? AND content_id = ? AND is_approved = 1");
    $stmt->execute([$content_type, $content_id]);
    $result = $stmt->fetch();
    return $result['count'] ?? 0;
}

/**
 * Agregar comentario
 */
function add_comment($content_type, $content_id, $user_id, $comment, $parent_id = null) {
    global $db;
    
    try {
        $db->beginTransaction();
        
        // Insertar comentario
        $stmt = $db->prepare("
            INSERT INTO comments (content_type, content_id, user_id, comment, parent_id)
            VALUES (?, ?, ?, ?, ?)
        ");
        $stmt->execute([$content_type, $content_id, $user_id, $comment, $parent_id]);
        
        // Actualizar contador
        $table_map = [
            'blog_post' => 'blog_posts',
            'investigation' => 'investigations',
            'esoterism' => 'esoterism_content'
        ];
        
        if (isset($table_map[$content_type])) {
            $table = $table_map[$content_type];
            $count = get_comments_count($content_type, $content_id);
            $stmt = $db->prepare("UPDATE {$table} SET comments_count = ? WHERE id = ?");
            $stmt->execute([$count, $content_id]);
        }
        
        $db->commit();
        return ['success' => true, 'message' => 'Comentario agregado exitosamente'];
        
    } catch (Exception $e) {
        $db->rollBack();
        return ['success' => false, 'error' => $e->getMessage()];
    }
}

/**
 * Renderizar HTML de comentarios
 */
function render_comments($comments, $content_type, $content_id, $depth = 0) {
    $html = '';
    
    foreach ($comments as $comment) {
        $author_name = !empty($comment['first_name']) 
            ? $comment['first_name'] . ' ' . $comment['last_name'] 
            : $comment['username'];
        
        $avatar_letter = strtoupper(substr($author_name, 0, 1));
        $time_ago = time_ago($comment['created_at']);
        
        $html .= '<div class="comment" style="margin-left: ' . ($depth * 40) . 'px;">';
        $html .= '<div class="comment-header">';
        $html .= '<div class="comment-avatar">' . $avatar_letter . '</div>';
        $html .= '<div>';
        $html .= '<div class="comment-author">' . htmlspecialchars($author_name) . '</div>';
        $html .= '<div class="comment-date">' . $time_ago . '</div>';
        $html .= '</div>';
        $html .= '</div>';
        $html .= '<div class="comment-body">' . nl2br(htmlspecialchars($comment['comment'])) . '</div>';
        
        if (is_logged_in()) {
            $html .= '<div class="comment-actions">';
            $html .= '<span class="comment-action reply-btn" data-comment-id="' . $comment['id'] . '">💬 Responder</span>';
            $html .= '</div>';
            $html .= '<div class="reply-form" id="reply-form-' . $comment['id'] . '" style="display: none;"></div>';
        }
        
        // Respuestas
        $replies = get_comments($content_type, $content_id, $comment['id']);
        if (!empty($replies)) {
            $html .= render_comments($replies, $content_type, $content_id, $depth + 1);
        }
        
        $html .= '</div>';
    }
    
    return $html;
}

/**
 * Calcular tiempo transcurrido
 */
function time_ago($datetime) {
    $timestamp = strtotime($datetime);
    $diff = time() - $timestamp;
    
    if ($diff < 60) {
        return 'Hace un momento';
    } elseif ($diff < 3600) {
        $minutes = floor($diff / 60);
        return "Hace {$minutes} minuto" . ($minutes > 1 ? 's' : '');
    } elseif ($diff < 86400) {
        $hours = floor($diff / 3600);
        return "Hace {$hours} hora" . ($hours > 1 ? 's' : '');
    } elseif ($diff < 604800) {
        $days = floor($diff / 86400);
        return "Hace {$days} día" . ($days > 1 ? 's' : '');
    } else {
        return date('d/m/Y', $timestamp);
    }
}

// ============================================
// GALERÍA DE IMÁGENES
// ============================================

/**
 * Obtener imágenes de galería de una investigación
 */
function get_investigation_gallery($investigation_id) {
    global $db;
    $stmt = $db->prepare("
        SELECT ig.*, u.username
        FROM investigation_gallery ig
        LEFT JOIN users u ON ig.uploaded_by = u.id
        WHERE ig.investigation_id = ?
        ORDER BY ig.display_order ASC, ig.created_at ASC
    ");
    $stmt->execute([$investigation_id]);
    return $stmt->fetchAll();
}

/**
 * Agregar imagen a galería
 */
function add_gallery_image($investigation_id, $image_path, $caption, $user_id, $display_order = 0) {
    global $db;
    
    try {
        $stmt = $db->prepare("
            INSERT INTO investigation_gallery (investigation_id, image_path, caption, uploaded_by, display_order)
            VALUES (?, ?, ?, ?, ?)
        ");
        $stmt->execute([$investigation_id, $image_path, $caption, $user_id, $display_order]);
        return ['success' => true, 'message' => 'Imagen agregada a la galería'];
    } catch (Exception $e) {
        return ['success' => false, 'error' => $e->getMessage()];
    }
}

<!DOCTYPE html>
<html lang="es">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="Investigaciones paranormales y esoterismo">
    <title>Iniciar Sesión - FakeGhost</title>
    <link rel="stylesheet" href="https://test.fakeghost.cl/assets/css/style.css?v=2.1">
    </head>
<body>
    <header>
        <div class="container">
            <div class="header-content">
                <a href="https://test.fakeghost.cl" class="logo">
                                            <img src="https://test.fakeghost.cl/uploads/site/698a40e069c67_1770668256.png" 
                             alt="FakeGhost" 
                             style="height: 50px; max-width: 200px; object-fit: contain;">
                                    </a>
                
                <button class="hamburger" id="hamburger" aria-label="Menú">
                    <span></span>
                    <span></span>
                    <span></span>
                </button>
                
                <nav>
                    <ul id="navMenu">
                        <li><a href="https://test.fakeghost.cl" class="">Home</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/quienes-somos.php" class="">Quiénes Somos</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/investigacion.php" class="">Investigaciones</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/blog.php" class="">Blog</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/esoterismo.php" class="">Esoterismo</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/tienda.php" class="">Tienda</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/contacto.php" class="">Contacto</a></li>
                        
                                                    <li><a href="https://test.fakeghost.cl/auth/login.php" class="btn btn-sm btn-primary">Iniciar Sesión</a></li>
                            <li><a href="https://test.fakeghost.cl/auth/register.php" class="btn btn-sm">Registrarse</a></li>
                                            </ul>
                </nav>
            </div>
        </div>
    </header>
    
    <main>
                        
                        
                        
            <div class="container">
?>

<div class="card" style="max-width: 500px; margin: 2rem auto;">
    <div class="card-header">
        <h1>Iniciar Sesión</h1>
    </div>
    <div class="card-body">
                
        <form method="POST" action="">
            <input type="hidden" name="csrf_token" value="920a42fb5214fdfdf817eca8c319358af0599d21613dd0652277e1eb20cd3c91">
            
            <div class="form-group">
                <label for="username_or_email">Usuario o Email</label>
                <input type="text" id="username_or_email" name="username_or_email" required 
                       value=""
                       placeholder="usuario o email@ejemplo.com">
            </div>
            
            <div class="form-group">
                <label for="password">Contraseña</label>
                <input type="password" id="password" name="password" required>
            </div>
            
            <button type="submit" class="btn btn-primary" style="width: 100%;">
                Iniciar Sesión
            </button>
        </form>
        
        <p style="text-align: center; margin-top: 1.5rem;">
            <a href="https://test.fakeghost.cl/auth/forgot-password.php">¿Olvidaste tu contraseña?</a>
        </p>
        
        <p style="text-align: center; margin-top: 0.5rem;">
            ¿No tienes cuenta? 
            <a href="https://test.fakeghost.cl/auth/register.php">Regístrate aquí</a>
        </p>
    </div>

</div>
    
    <footer>
        <div class="container">
            <div class="footer-content">
                <div class="footer-section">
                    <h3>👻 FakeGhost</h3>
                    <p>Investigaciones paranormales y esoterismo</p>
                </div>
                
                <div class="footer-section">
                    <h3>Enlaces Rápidos</h3>
                    <ul>
                        <li><a href="https://test.fakeghost.cl">Home</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/quienes-somos.php">Quiénes Somos</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/investigacion.php">Investigaciones</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/blog.php">Blog</a></li>
                    </ul>
                </div>
                
                <div class="footer-section">
                    <h3>Más</h3>
                    <ul>
                        <li><a href="https://test.fakeghost.cl/pages/esoterismo.php">Esoterismo</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/tienda.php">Tienda</a></li>
                        <li><a href="https://test.fakeghost.cl/pages/contacto.php">Contacto</a></li>
                    </ul>
                </div>
                
                <div class="footer-section">
                    <h3>Síguenos</h3>
                    <ul>
                                                                                                                    </ul>
                </div>
            </div>
            
            <div class="footer-bottom">
                <p>&copy; 2026 FakeGhost. Todos los derechos reservados.</p>
            </div>
        </div>
    </footer>
    
    <script src="https://test.fakeghost.cl/assets/js/main.js"></script>
</body>
</html>