Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2026-03-13 15:14
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
hania	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
includes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
user	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
.user.ini	578 B	-rw-r--r--	2026-03-13 17:04
add_maintenance_setting.php	669 B	-rw-r--r--	2026-03-12 12:31
check_db.php	161 B	-rw-r--r--	2026-03-12 15:16
check_withdrawals.php	156 B	-rw-r--r--	2026-03-12 15:17
contact.php	6.42 KB	-rw-r--r--	2026-03-28 15:18
database.sql	19.53 KB	-rw-r--r--	2026-03-11 23:07
debug.php	5.09 KB	-rw-r--r--	2026-03-30 15:21
error_log	8.83 KB	-rw-r--r--	2026-03-30 15:27
forgot-password.php	2.16 KB	-rw-r--r--	2026-03-30 15:26
how-it-works.php	1.99 KB	-rw-r--r--	2026-03-11 22:52
index.php	9.37 KB	-rw-r--r--	2026-03-12 00:13
login.php	5.17 KB	-rw-r--r--	2026-03-30 15:28
logout.php	56 B	-rw-r--r--	2026-03-11 23:27
maintenance.php	4.5 KB	-rw-r--r--	2026-03-12 12:39
php.ini	578 B	-rw-r--r--	2026-03-13 17:04
plans.php	2.72 KB	-rw-r--r--	2026-03-12 00:10
register.php	8.79 KB	-rw-r--r--	2026-03-30 15:27
reset-password.php	6.39 KB	-rw-r--r--	2026-03-14 18:08
update_db.php	421 B	-rw-r--r--	2026-03-12 15:17
update_withdrawals.php	417 B	-rw-r--r--	2026-03-12 15:18
wp-blog-header.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once 'includes/config.php';

echo "<h1>System Compatibility Check</h1>";
echo "<b>PHP Version:</b> " . PHP_VERSION . "<br>";

if (version_compare(PHP_VERSION, '7.0.0') < 0) {
    echo "❌ <b>CRITICAL:</b> Your PHP version is too old. Please upgrade to PHP 7.4 or 8.x.<br>";
} else {
    echo "✅ PHP version is compatible.<br>";
}

try {
    $pdo->query("SELECT 1");
    echo "✅ Database connected.<br>";
} catch (Exception $e) {
    echo "❌ Database connection failed: " . $e->getMessage() . "<br>";
}

// Check email_codes table
try {
    $pdo->query("SELECT * FROM email_codes LIMIT 1");
    echo "⚠️ 'email_codes' table still EXISTS in database. <b>Use the button below to delete it.</b><br>";
} catch (Exception $e) {
    echo "✅ 'email_codes' table is DELETED (Clean).<br>";
}

// Check password_resets table
try {
    $pdo->query("SELECT * FROM password_resets LIMIT 1");
    echo "⚠️ 'password_resets' table still EXISTS in database. <b>Use the button below to delete it.</b><br>";
} catch (Exception $e) {
    echo "✅ 'password_resets' table is DELETED (Clean).<br>";
}

try {
    $stmt = $pdo->query("SELECT role FROM users LIMIT 1");
    echo "✅ 'role' column exists in users table.<br>";
} catch (Exception $e) {
    echo "❌ 'role' column is MISSING in users table.<br>";
}

echo "<h3>Check Complete.</h3>";

// --- DROP EMAIL TABLES ---
if (isset($_POST['drop_email_tables'])) {
    echo "<div style='background:#fff0f0; padding:20px; border:2px solid #e74c3c; border-radius:10px; margin-top:20px;'>";
    echo "<h2>🗑️ Dropping Email Tables...</h2><ul style='font-family:monospace;'>";

$tables_to_drop = ['email_codes', 'password_resets'];

foreach ($tables_to_drop as $table) {
        try {
            $pdo->exec("DROP TABLE IF EXISTS `$table`");
            echo "<li style='color:green;'>✅ Table '<b>$table</b>' dropped successfully.</li>";
        } catch (Exception $e) {
            echo "<li style='color:red;'>❌ Failed to drop '$table': " . htmlspecialchars($e->getMessage()) . "</li>";
        }
    }

echo "</ul><p><b>Done! Refresh this page to confirm.</b></p></div>";
}

// --- DATABASE UPDATE LOGIC ---
if (isset($_POST['run_db_update'])) {
    echo "<div style='background:#f0f0f0; padding:20px; border-radius:10px; margin-top:20px;'>";
    echo "<h2>Running Database Updates...</h2><ul style='font-family:monospace;'>";

$migrations = [
        "ALTER TABLE withdraw_methods ADD COLUMN bank_field VARCHAR(100) DEFAULT NULL AFTER bank_name",
        "ALTER TABLE users ADD COLUMN assignment_active_until TIMESTAMP NULL DEFAULT NULL",
        "ALTER TABLE users ADD COLUMN last_refill_referral_count INT DEFAULT 0",
        "ALTER TABLE users ADD COLUMN assignment_work_started_at TIMESTAMP NULL DEFAULT NULL",
        "ALTER TABLE users ADD COLUMN last_login_verified_at TIMESTAMP NULL DEFAULT NULL",
        "ALTER TABLE users ADD role ENUM('user','admin') DEFAULT 'user'",
        "ALTER TABLE users MODIFY COLUMN status enum('active','inactive') DEFAULT 'inactive'"
    ];

foreach ($migrations as $sql) {
        try {
            $pdo->exec($sql);
            echo "<li style='color:green;'>✅ Success: " . htmlspecialchars($sql) . "</li>";
        } catch (Exception $e) {
            if (strpos($e->getMessage(), 'Duplicate column name') !== false) {
                echo "<li style='color:orange;'>ℹ️ Already exists (skipped).</li>";
            } else {
                echo "<li style='color:red;'>❌ Error: " . htmlspecialchars($e->getMessage()) . "</li>";
            }
        }
    }

echo "</ul><p><b>Updates Finished!</b></p></div>";
}
?>

<hr>

<div style="margin: 30px 0; padding: 20px; border: 2px dashed #e74c3c; background: rgba(231,76,60,0.05); border-radius:10px;">
    <h3>🗑️ Delete Email Verification Tables</h3>
    <p>Yeh button <b>email_codes</b> aur <b>password_resets</b> tables ko database se hamesha ke liye delete kar dega. Verification system ab use nahi hota is liye yeh tables zaroorat nahi.</p>
    <form method="POST">
        <button type="submit" name="drop_email_tables" onclick="return confirm('Are you sure? This will permanently delete email_codes and password_resets tables!')" style="padding:15px 30px; background:#e74c3c; color:white; border:none; border-radius:5px; cursor:pointer; font-weight:bold; font-size:1.1rem;">🗑️ DELETE EMAIL TABLES NOW</button>
    </form>
</div>

<hr>
<div style="margin: 30px 0; padding: 20px; border: 2px dashed #f39c12; background: #fffdf0; border-radius:10px;">
    <h3>⚠️ Database Auto-Updater</h3>
    <p>Click the button below to automatically add missing columns and update the database schema. Safe to run multiple times.</p>
    <form method="POST">
        <button type="submit" name="run_db_update" style="padding:15px 30px; background:#f39c12; color:white; border:none; border-radius:5px; cursor:pointer; font-weight:bold; font-size:1.1rem;">🛠️ RUN DATABASE UPDATES</button>
    </form>
</div>