0xn0l

📂 /home/brightbrai/pssss-dc-sanghar.brightbrains.pk

✎ EDIT: restore_and_audit_all_site_images.php ← BACK

<?php
require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

$db = Database::getConnection();

echo "=========================================================================\n";
echo "       AUDITING & RESTORING ALL USER-ADDED SITE IMAGES                   \n";
echo "=========================================================================\n\n";

// 1. Audit Settings Table Images
echo "--- 1. SETTINGS TABLE IMAGES ---\n";
$settings = $db->query("SELECT key, value FROM settings WHERE key LIKE '%image%' OR key LIKE '%photo%' OR key LIKE '%logo%' OR key LIKE '%banner%'")->fetchAll(PDO::FETCH_ASSOC);
foreach ($settings as $s) {
    echo "Key: {$s['key']} | Value: {$s['value']}\n";
}

// 2. Audit Department Images & HOD Photos
echo "\n--- 2. DEPARTMENT COVERS & HOD PHOTOS ---\n";
$depts = $db->query("SELECT id, name, image, hod_name, hod_photo FROM departments")->fetchAll(PDO::FETCH_ASSOC);
foreach ($depts as $d) {
    echo sprintf("Dept: %-35s | Cover: %-30s | HOD Photo: %s\n", $d['name'], $d['image'] ?: 'None', $d['hod_photo'] ?: 'None');
}

// 3. Audit Faculty Photos
echo "\n--- 3. FACULTY MEMBER PHOTOS ---\n";
$facs = $db->query("SELECT id, name, photo FROM faculty ORDER BY name ASC")->fetchAll(PDO::FETCH_ASSOC);
foreach ($facs as $f) {
    echo sprintf("ID: %-14s | Name: %-28s | Photo: %s\n", $f['id'], $f['name'], $f['photo'] ?: '(EMPTY - No photo provided)');
}

0xn0l - 0011000001111000011011100011000001101100