<?php
// NEWZXT - Advanced Automated News Portal & Aggregator
// Powered by UARES GROUP (info@newzxt.com)

// --- Contabo Database Configuration ---
$db_host = 'localhost';
$db_name = 'u22948_newz2x';      
$db_user = 'u22948_newz2x';      
$db_pass = 'u22948_newz2x';  

try {
    $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Auto-create articles table if not exists with proper indexes
    $pdo->exec("CREATE TABLE IF NOT EXISTS articles (
        id INT AUTO_INCREMENT PRIMARY KEY,
        source VARCHAR(100),
        title VARCHAR(255) UNIQUE,
        short_summary TEXT,
        full_description TEXT,
        link TEXT,
        date DATETIME,
        image TEXT
    )");
} catch (PDOException $e) {
    die("Database Connection Failed: " . $e->getMessage());
}

$search_query = isset($_GET['q']) ? trim($_GET['q']) : '';
$filter_date = isset($_GET['date']) ? $_GET['date'] : '';
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) $page = 1;
$limit = 12; // Articles per page
$offset = ($page - 1) * $limit;

// Expanded Multi-Source RSS Feeds (BBC, TOI, Zee, ANI, Al Jazeera)
$rss_sources = [
    "BBC News" => "http://feeds.bbci.co.uk/news/rss.xml",
    "Times of India" => "https://timesofindia.indiatimes.com/rssfeedstopstories.cms",
    "Zee News" => "https://zeenews.india.com/rss/india-national-news.xml",
    "ANI News" => "https://www.aninews.in/rss/category/national/general-news",
    "Al Jazeera" => "https://www.aljazeera.com/xml/rss/all.xml"
];

$options = [
    "http" => [
        "method" => "GET",
        "header" => "User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36\r\n"
    ]
];
$context = stream_context_create($options);

// Fetching & Storing News Continuously
foreach ($rss_sources as $source_name => $url) {
    $rss_raw = @file_get_contents($url, false, $context);
    if (!$rss_raw) continue;
    
    $rss_feed = @simplexml_load_string($rss_raw);
    if ($rss_feed && isset($rss_feed->channel->item)) {
        foreach ($rss_feed->channel->item as $item) {
            $title = (string)$item->title;
            $link = (string)$item->link;
            $date_raw = (string)$item->pubDate;
            $formatted_date = date('Y-m-d H:i:s', strtotime($date_raw));
            if(empty($formatted_date) || $formatted_date == '1970-01-01 00:00:00') {
                $formatted_date = date('Y-m-d H:i:s');
            }
            
            $full_desc = strip_tags((string)$item->description);
            if (empty($full_desc)) $full_desc = "Official network direct verified update.";
            
            $short_summary = mb_strimwidth($full_desc, 0, 140, "...");

            try {
                $stmt = $pdo->prepare("INSERT IGNORE INTO articles (source, title, short_summary, full_description, link, date, image) VALUES (?, ?, ?, ?, ?, ?, ?)");
                $stmt->execute([$source_name, $title, $short_summary, $full_desc, $link, $formatted_date, '']);
            } catch (Exception $e) {}
        }
    }
}

// Count total items for pagination
$count_sql = "SELECT COUNT(*) FROM articles WHERE 1=1";
$count_params = [];
if (!empty($search_query)) {
    $count_sql .= " AND (title LIKE ? OR short_summary LIKE ?)";
    $count_params[] = "%$search_query%";
    $count_params[] = "%$search_query%";
}
if (!empty($filter_date)) {
    $count_sql .= " AND DATE(date) = ?";
    $count_params[] = $filter_date;
}
$stmt_count = $pdo->prepare($count_sql);
$stmt_count->execute($count_params);
$total_articles = $stmt_count->fetchColumn();
$total_pages = ceil($total_articles / $limit);
if ($total_pages < 1) $total_pages = 1;

// Fetching Paginated Items
$sql = "SELECT * FROM articles WHERE 1=1";
$params = [];
if (!empty($search_query)) {
    $sql .= " AND (title LIKE ? OR short_summary LIKE ?)";
    $params[] = "%$search_query%";
    $params[] = "%$search_query%";
}
if (!empty($filter_date)) {
    $sql .= " AND DATE(date) = ?";
    $params[] = $filter_date;
}
$sql .= " ORDER BY date DESC LIMIT $limit OFFSET $offset";
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$news_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>NEWZXT - No Faltu News, Only True Updates</title>
    <script src="https://cdn.tailwindcss.com"></script>
    <style>
        @keyframes fadeIn { from { opacity: 0; transform: translateY(10px); } to { opacity: 1; transform: translateY(0); } }
        .animate-fade { animation: fadeIn 0.4s ease-out forwards; }
        .goog-te-combo { background-color: #f8fafc; border: 1px solid #cbd5e1; padding: 6px 12px; border-radius: 0.75rem; font-size: 0.875rem; color: #1e293b; outline: none; cursor: pointer; }
        .goog-logo-link, div.goog-te-gadget span { display: none !important; }
        .goog-te-gadget { color: transparent !important; font-size: 0; }
        html { scroll-behavior: smooth; }
    </style>
</head>
<body class="bg-slate-100 font-sans text-slate-900 antialiased selection:bg-rose-600 selection:text-white">

    <!-- Top Corporate Bar with Real-Time Clock -->
    <div class="bg-slate-900 text-slate-300 text-xs py-2 px-4 border-b border-slate-800">
        <div class="container mx-auto flex flex-col sm:flex-row justify-between items-center gap-2">
            <span>A Venture of <strong class="text-white">UARES GROUP</strong> | <a href="mailto:info@newzxt.com" class="text-rose-400 hover:underline">info@newzxt.com</a></span>
            <div class="flex items-center space-x-4">
                <span id="live-clock" class="bg-slate-800 text-rose-300 px-2.5 py-1 rounded font-mono text-[11px] border border-slate-700 shadow-inner">
                    Loading Time...
                </span>
                <span class="text-rose-400 font-semibold italic hidden lg:inline">"No faltu news, no bakwas, only true news!"</span>
                <div class="flex items-center space-x-3">
                    <a href="#" class="bg-rose-600 hover:bg-rose-700 text-white px-3 py-1 rounded-full font-bold transition shadow-sm">Become a Reporter</a>
                    <a href="#" class="text-slate-300 hover:text-white font-semibold transition">Login</a>
                </div>
            </div>
        </div>
    </div>

    <!-- Sticky Main Navigation Header -->
    <header class="bg-white/95 backdrop-blur-md sticky top-0 z-50 border-b border-slate-200 shadow-sm">
        <div class="container mx-auto px-4 py-3 flex flex-col md:flex-row justify-between items-center gap-3">
            <div class="flex items-center space-x-3">
                <a href="index.php" class="text-3xl font-black tracking-tight text-slate-900">
                    NEWZ<span class="text-rose-600">XT</span>
                </a>
                <span class="text-[10px] bg-slate-900 text-white px-2 py-0.5 rounded font-extrabold uppercase tracking-widest shadow">Direct Edition</span>
            </div>

            <!-- Search & Calendar Filter Bar -->
            <form method="GET" action="index.php" class="flex flex-wrap items-center gap-2 w-full md:w-auto">
                <input type="text" name="q" value="<?php echo htmlspecialchars($search_query); ?>" placeholder="Search keyword..." class="bg-slate-50 border border-slate-300 text-xs rounded-xl px-3 py-2 text-slate-800 focus:ring-2 focus:ring-rose-500 focus:outline-none flex-grow md:w-56">
                <input type="date" name="date" value="<?php echo htmlspecialchars($filter_date); ?>" class="bg-slate-50 border border-slate-300 text-xs rounded-xl px-3 py-2 text-slate-800 focus:ring-2 focus:ring-rose-500 focus:outline-none">
                <button type="submit" class="bg-slate-900 hover:bg-rose-600 text-white text-xs font-semibold px-4 py-2 rounded-xl transition shadow">Filter</button>
            </form>

            <div id="google_translate_element"></div>
        </div>
    </header>

    <!-- Main Dynamic Content Container -->
    <main class="container mx-auto px-4 py-8 max-w-6xl">
        
        <div class="flex flex-col sm:flex-row items-start sm:items-center justify-between mb-8 border-b border-slate-200 pb-4 gap-2">
            <div>
                <h2 class="text-2xl md:text-3xl font-black text-slate-900 tracking-tight animate-fade">Live Direct News Stream</h2>
                <p class="text-xs text-slate-500 mt-1">Bina time-pass ke, seedhe kaam ki baat — Zero Bakwas.</p>
            </div>
            <span class="text-xs bg-rose-50 text-rose-600 font-bold px-3 py-1 rounded-full border border-rose-200 shadow-sm">Total Archives: <?php echo $total_articles; ?></span>
        </div>

        <!-- News Grid Blocks -->
        <?php if (!empty($news_items)): ?>
            <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6">
                <?php foreach ($news_items as $news): ?>
                    <article class="bg-white rounded-2xl border border-slate-200 shadow-sm overflow-hidden flex flex-col justify-between transition-all duration-300 hover:shadow-xl hover:-translate-y-1 animate-fade">
                        <div>
                            <!-- Clean Branded Custom Banner -->
                            <div class="relative h-36 bg-gradient-to-br from-slate-900 via-slate-800 to-slate-950 p-5 flex flex-col justify-between overflow-hidden border-b border-slate-800">
                                <span class="absolute -right-4 -bottom-6 text-7xl font-black text-slate-800/40 select-none pointer-events-none">XT</span>
                                
                                <div class="flex justify-between items-start z-10">
                                    <span class="bg-rose-600 text-white text-[9px] font-extrabold uppercase tracking-widest px-2 py-0.5 rounded shadow">
                                        Verified Report
                                    </span>
                                    <span class="text-[9px] text-slate-400 font-mono">LIVE FEED</span>
                                </div>
                                
                                <div class="z-10 text-center my-auto">
                                    <h4 class="text-xl font-black tracking-tight text-white">
                                        NEWZ<span class="text-rose-500">XT</span>
                                    </h4>
                                    <p class="text-[10px] text-rose-400 font-semibold italic mt-0.5">
                                        "No faltu news, no bakwas, only true news!"
                                    </p>
                                </div>
                            </div>

                            <div class="p-5">
                                <time class="text-[11px] font-bold text-rose-600 block mb-2">
                                    <?php echo date('d M Y, h:i A', strtotime($news['date'])); ?>
                                </time>
                                
                                <h3 class="text-base font-bold text-slate-900 mb-3 leading-snug line-clamp-2">
                                    <?php echo htmlspecialchars($news['title']); ?>
                                </h3>
                                
                                <div class="bg-slate-50 border-l-2 border-rose-500 p-3 rounded-r-lg mb-4">
                                    <span class="text-[10px] font-extrabold text-rose-600 uppercase tracking-widest block mb-1">Conclusion</span>
                                    <p class="text-slate-600 text-xs leading-relaxed">
                                        <?php echo htmlspecialchars($news['short_summary']); ?>
                                    </p>
                                </div>
                            </div>
                        </div>

                        <div class="p-5 pt-0">
                            <a href="<?php echo htmlspecialchars($news['link']); ?>" target="_blank" rel="noopener noreferrer" class="inline-flex items-center justify-center w-full bg-slate-900 hover:bg-rose-600 text-white font-medium text-xs py-2.5 px-4 rounded-xl transition shadow">
                                Read Full Report &rarr;
                            </a>
                        </div>
                    </article>
                <?php endforeach; ?>
            </div>

            <!-- Smart Pagination -->
            <?php if ($total_pages > 1): ?>
                <div class="flex flex-wrap justify-center items-center gap-1.5 mt-12">
                    <?php 
                    $max_links = 7;
                    $start_page = max(1, $page - floor($max_links / 2));
                    $end_page = min($total_pages, $start_page + $max_links - 1);
                    if (($end_page - $start_page + 1) < $max_links) {
                        $start_page = max(1, $end_page - $max_links + 1);
                    }
                    
                    if ($page > 1): ?>
                        <a href="?page=1<?php echo !empty($search_query) ? '&q='.urlencode($search_query) : ''; ?><?php echo !empty($filter_date) ? '&date='.$filter_date : ''; ?>" class="px-3 py-1.5 text-xs font-bold rounded-lg bg-white text-slate-700 border border-slate-200 hover:bg-slate-50 shadow-sm">&laquo; First</a>
                    <?php endif; ?>

                    <?php for ($i = $start_page; $i <= $end_page; $i++): ?>
                        <a href="?page=<?php echo $i; ?><?php echo !empty($search_query) ? '&q='.urlencode($search_query) : ''; ?><?php echo !empty($filter_date) ? '&date='.$filter_date : ''; ?>" 
                           class="px-3 py-1.5 text-xs font-bold rounded-lg transition shadow-sm <?php echo ($page == $i) ? 'bg-rose-600 text-white' : 'bg-white text-slate-700 border border-slate-200 hover:bg-slate-50'; ?>">
                            <?php echo $i; ?>
                        </a>
                    <?php endfor; ?>

                    <?php if ($page < $total_pages): ?>
                        <a href="?page=<?php echo $total_pages; ?><?php echo !empty($search_query) ? '&q='.urlencode($search_query) : ''; ?><?php echo !empty($filter_date) ? '&date='.$filter_date : ''; ?>" class="px-3 py-1.5 text-xs font-bold rounded-lg bg-white text-slate-700 border border-slate-200 hover:bg-slate-50 shadow-sm">Last &raquo;</a>
                    <?php endif; ?>
                </div>
            <?php endif; ?>

        <?php else: ?>
            <div class="text-center py-20 bg-white rounded-2xl border border-slate-200 shadow-sm">
                <p class="text-slate-500 text-sm">Koi matching news nahi mili.</p>
                <a href="index.php" class="inline-block mt-4 bg-slate-900 text-white text-xs px-4 py-2 rounded-xl">Reset Filter</a>
            </div>
        <?php endif; ?>

    </main>

    <!-- Professional Footer -->
    <footer class="bg-slate-900 text-slate-400 py-10 mt-20 border-t border-slate-800 text-center text-xs">
        <div class="container mx-auto px-4 space-y-2">
            <h3 class="text-white text-lg font-black tracking-tight">NEWZ<span class="text-rose-500">XT</span></h3>
            <p class="text-rose-400 italic font-medium">"No faltu news, no bakwas, only true news!"</p>
            <p class="text-slate-400">A Venture of <strong>UARES GROUP</strong> | <a href="mailto:info@newzxt.com" class="text-rose-400 hover:underline">info@newzxt.com</a></p>
            <div class="flex justify-center space-x-4 pt-2">
                <a href="#" class="text-rose-400 hover:underline">Become a Reporter</a>
                <span class="text-slate-700">|</span>
                <a href="#" class="text-slate-300 hover:underline">Login Portal</a>
            </div>
            <p class="text-[10px] text-slate-600 pt-2">&copy; <?php echo date('Y'); ?> NEWZXT. All rights reserved.</p>
        </div>
    </footer>

    <!-- Real-Time Clock Script -->
    <script>
        function updateLiveClock() {
            const now = new Date();
            const options = { 
                weekday: 'short', 
                year: 'numeric', 
                month: 'short', 
                day: 'numeric', 
                hour: '2-digit', 
                minute: '2-digit', 
                second: '2-digit',
                hour12: true 
            };
            document.getElementById('live-clock').innerText = now.toLocaleString('en-US', options);
        }
        setInterval(updateLiveClock, 1000);
        updateLiveClock();
    </script>

    <!-- Google Translate Script -->
    <script type="text/javascript">
        function googleTranslateElementInit() {
            new google.translate.TranslateElement({
                pageLanguage: 'en',
                includedLanguages: 'en,bn,hi,ta,te,gu,pa',
                layout: google.translate.TranslateElement.InlineLayout.SIMPLE
            }, 'google_translate_element');
        }
    </script>
    <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>

</body>
</html>