FM / includes

/home/techb158/workloadmatch.com/includes/

/home/techb158/workloadmatch.com/includes

Name	Size	Mode	Actions
config_loader.php	963	0644	edit dl rm
CSRF_Protect.php	2224	0644	edit dl rm
db_connect.php	568	0644	edit dl rm
error.php	485	0644	edit dl rm
firebase_auth.php	6318	0644	edit dl rm
footer.php	617	0644	edit dl rm
forgetpassword.php	10825	0644	edit dl rm
forgetpassword_Bak.php	7448	0644	edit dl rm
functions.php	31330	0644	edit dl rm
geoiploc.php	2520435	0644	edit dl rm
header.php	1804	0644	edit dl rm
hex.php	1050	0644	edit dl rm
hexbin.php	942	0644	edit dl rm
login_page.php	2993	0644	edit dl rm
logout.php	870	0644	edit dl rm
migrate_last_activity.php	1278	0644	edit dl rm
process_login.php	2119	0644	edit dl rm
psl-config-Bak.php	1213	0644	edit dl rm
psl-config.php	1883	0644	edit dl rm
reset.php	6537	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/includes/migrate_last_activity.php (1278B)

<?php
// One-time migration: add last_activity column to teacher_profile and manager_profile
// Run this once via browser, then DELETE this file.
include_once 'db_connect.php';
include_once 'functions.php';
sec_session_start();

if (!login_check($mysqli) || !isset($_SESSION['user_id'])) {
    die('Not authorized');
}

$checks = [
    "teacher_profile" => "ALTER TABLE teacher_profile ADD COLUMN last_activity DATETIME DEFAULT NULL AFTER Profile_Status",
    "manager_profile" => "ALTER TABLE manager_profile ADD COLUMN last_activity DATETIME DEFAULT NULL AFTER Profile_Status"
];

echo "<pre>";
foreach ($checks as $table => $sql) {
    $r = $mysqli->query("SELECT COUNT(*) AS cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '" . DATABASE . "' AND TABLE_NAME = '$table' AND COLUMN_NAME = 'last_activity'");
    $row = $r->fetch_assoc();
    if ((int)$row['cnt'] === 0) {
        if ($mysqli->query($sql)) {
            echo "✓ Added last_activity to $table\n";
        } else {
            echo "✗ Failed to add last_activity to $table: " . $mysqli->error . "\n";
        }
    } else {
        echo "≈ last_activity already exists in $table\n";
    }
}
echo "\nDone. DELETE this file after confirming.</pre>";
$mysqli->close();

"ALTER TABLE teacher_profile ADD COLUMN last_activity DATETIME DEFAULT NULL AFTER Profile_Status", "manager_profile" => "ALTER TABLE manager_profile ADD COLUMN last_activity DATETIME DEFAULT NULL AFTER Profile_Status" ]; echo "

";
foreach ($checks as $table => $sql) {
    $r = $mysqli->query("SELECT COUNT(*) AS cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '" . DATABASE . "' AND TABLE_NAME = '$table' AND COLUMN_NAME = 'last_activity'");
    $row = $r->fetch_assoc();
    if ((int)$row['cnt'] === 0) {
        if ($mysqli->query($sql)) {
            echo "✓ Added last_activity to $table\n";
        } else {
            echo "✗ Failed to add last_activity to $table: " . $mysqli->error . "\n";
        }
    } else {
        echo "≈ last_activity already exists in $table\n";
    }
}
echo "\nDone. DELETE this file after confirming.

"; $mysqli->close();