Files
wevads-platform/public/domain-api-hub.php
2026-04-07 03:04:16 +02:00

58 lines
5.8 KiB
PHP

<?php
require_once('/opt/wevads/config/credentials.php');
header('Content-Type: text/html; charset=utf-8');
$db = get_pdo('adx_system');
$cfStats = ['accounts' => $db->query("SELECT COUNT(*) FROM admin.cloudflare_accounts")->fetchColumn(), 'zones' => $db->query("SELECT COUNT(*) FROM admin.cloudflare_zones")->fetchColumn(), 'domains' => $db->query("SELECT COUNT(*) FROM admin.cloudflare_domains")->fetchColumn()];
$o365Domains = $db->query("SELECT COUNT(*) FROM admin.office_domains")->fetchColumn();
$fdStats = ['accounts' => $db->query("SELECT COUNT(*) FROM admin.freedns_accounts")->fetchColumn(), 'domains' => $db->query("SELECT COUNT(*) FROM admin.domain_pool WHERE source='freedns_registry'")->fetchColumn()];
$ncStats = ['accounts' => $db->query("SELECT COUNT(*) FROM admin.namecheap_accounts")->fetchColumn()];
$recentZones = $db->query("SELECT * FROM admin.cloudflare_zones ORDER BY id DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
$recentFreedns = $db->query("SELECT * FROM admin.domain_pool WHERE source='freedns_registry' ORDER BY id DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="fr">
<head><meta charset="UTF-8"><title>🌐 Domain API Hub</title><script src="https://cdn.tailwindcss.com"></script><link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
</head>
<body class="bg-gray-900 text-white min-h-screen p-6">
<div class="container mx-auto">
<h1 class="text-3xl font-bold mb-6">🌐 Domain API Hub</h1>
<div class="grid grid-cols-5 gap-4 mb-8">
<div class="bg-orange-500 rounded-lg p-4"><div class="text-3xl font-bold"><?= $cfStats['accounts'] ?></div><div class="text-sm">☁️ Cloudflare Accounts</div></div>
<div class="bg-orange-400 rounded-lg p-4"><div class="text-3xl font-bold"><?= $cfStats['zones'] ?></div><div class="text-sm">Cloudflare Zones</div></div>
<div class="bg-green-600 rounded-lg p-4"><div class="text-3xl font-bold"><?= $fdStats['accounts'] ?></div><div class="text-sm">🆓 FreeDNS Accounts</div></div>
<div class="bg-green-500 rounded-lg p-4"><div class="text-3xl font-bold"><?= $fdStats['domains'] ?></div><div class="text-sm">FreeDNS Domains</div></div>
<div class="bg-red-600 rounded-lg p-4"><div class="text-3xl font-bold"><?= $ncStats['accounts'] ?></div><div class="text-sm">🏷️ Namecheap</div></div>
</div>
<div class="grid grid-cols-4 gap-4 mb-8">
<a href="/cloudflare-setup.php" class="bg-gray-800 hover:bg-orange-500 rounded-lg p-4 text-center transition"><i class="fas fa-cloud text-2xl mb-2"></i><div>Cloudflare Setup</div></a>
<a href="/deliverads/cloudflare-manager.php" class="bg-gray-800 hover:bg-orange-400 rounded-lg p-4 text-center transition"><i class="fas fa-cog text-2xl mb-2"></i><div>Cloudflare Manager</div></a>
<a href="/freedns-config.php" class="bg-gray-800 hover:bg-green-600 rounded-lg p-4 text-center transition"><i class="fas fa-globe text-2xl mb-2"></i><div>FreeDNS Config</div></a>
<a href="/deliverads/freedns-manager.php" class="bg-gray-800 hover:bg-green-500 rounded-lg p-4 text-center transition"><i class="fas fa-list text-2xl mb-2"></i><div>FreeDNS Manager</div></a>
</div>
<div class="grid grid-cols-4 gap-4 mb-8">
<a href="/namecheap-setup.php" class="bg-gray-800 hover:bg-red-600 rounded-lg p-4 text-center transition"><i class="fas fa-shopping-cart text-2xl mb-2"></i><div>Namecheap Setup</div></a>
<a href="/deliverads/namecheap-manager.php" class="bg-gray-800 hover:bg-red-500 rounded-lg p-4 text-center transition"><i class="fas fa-tags text-2xl mb-2"></i><div>Namecheap Manager</div></a>
<a href="/dns-manager.php" class="bg-gray-800 hover:bg-blue-600 rounded-lg p-4 text-center transition"><i class="fas fa-server text-2xl mb-2"></i><div>DNS Manager</div></a>
<a href="/deliverads/domain-hub.php" class="bg-gray-800 hover:bg-cyan-600 rounded-lg p-4 text-center transition"><i class="fas fa-sitemap text-2xl mb-2"></i><div>Domain Hub</div></a>
</div>
<div class="grid grid-cols-2 gap-6">
<div class="bg-gray-800 rounded-lg p-6">
<h2 class="text-xl font-bold mb-4 text-orange-400">☁️ Recent Cloudflare Zones</h2>
<table class="w-full text-sm"><thead class="bg-gray-700"><tr><th class="p-2 text-left">ID</th><th class="p-2 text-left">Domain</th><th class="p-2 text-left">Status</th></tr></thead>
<tbody><?php foreach($recentZones as $z): ?><tr class="border-b border-gray-700"><td class="p-2"><?= $z['id'] ?></td><td class="p-2"><?= $z['name'] ?? $z['domain'] ?? '-' ?></td><td class="p-2"><span class="px-2 py-1 rounded text-xs bg-green-600"><?= $z['status'] ?? 'active' ?></span></td></tr><?php endforeach; ?></tbody></table>
</div>
<div class="bg-gray-800 rounded-lg p-6">
<h2 class="text-xl font-bold mb-4 text-green-400">🆓 Recent FreeDNS Domains</h2>
<table class="w-full text-sm"><thead class="bg-gray-700"><tr><th class="p-2 text-left">ID</th><th class="p-2 text-left">Domain</th><th class="p-2 text-left">Status</th></tr></thead>
<tbody><?php foreach($recentFreedns as $d): ?><tr class="border-b border-gray-700"><td class="p-2"><?= $d['id'] ?></td><td class="p-2"><?= $d['domain'] ?? $d['subdomain'] ?? '-' ?></td><td class="p-2"><span class="px-2 py-1 rounded text-xs bg-green-600"><?= $d['status'] ?? 'active' ?></span></td></tr><?php endforeach; ?></tbody></table>
</div>
</div>
<div class="mt-6 bg-gray-800 rounded-lg p-6">
<h2 class="text-xl font-bold mb-4 text-red-400">🔄 n8n Workflows</h2>
<div class="grid grid-cols-3 gap-4">
<a href="http://95.216.167.89:5825" target="_blank" class="bg-gray-700 hover:bg-orange-600 rounded p-3 transition"><i class="fas fa-sync mr-2"></i>DNS Sync Cloudflare</a>
<a href="http://95.216.167.89:5825" target="_blank" class="bg-gray-700 hover:bg-green-600 rounded p-3 transition"><i class="fas fa-plus mr-2"></i>FreeDNS Auto Creator</a>
<a href="http://95.216.167.89:5825" target="_blank" class="bg-gray-700 hover:bg-red-500 rounded p-3 transition"><i class="fas fa-cogs mr-2"></i>Open n8n</a>
</div></div></div>
</body></html>