Database Connection Test

⚠️ WARNING: Delete this file after testing!

"; // Test 1: Check database connection echo "
"; echo "

Test 1: Database Connection

"; if ($db && mysqli_ping($db)) { echo "

✓ Database connection successful!

"; echo "

Connected to database

"; } else { echo "

✗ Database connection failed!

"; if ($db) { echo "

Error: " . mysqli_connect_error() . "

"; } echo "
"; exit(); } echo ""; // Test 2: Check if {$table_prefix}users table exists echo "
"; echo "

Test 2: Check {$table_prefix}users Table

"; $result = mysqli_query($db, "SHOW TABLES LIKE '{$table_prefix}users'"); if ($result && mysqli_num_rows($result) > 0) { echo "

✓ {$table_prefix}users table exists!

"; } else { echo "

✗ {$table_prefix}users table not found!

"; echo "
"; exit(); } echo ""; // Test 3: Check table structure echo "
"; echo "

Test 3: Table Structure

"; $result = mysqli_query($db, "DESCRIBE {$table_prefix}users"); if ($result) { echo "

✓ Table structure retrieved

"; echo "

Columns:

";
    while ($row = mysqli_fetch_assoc($result)) {
        echo $row['Field'] . " (" . $row['Type'] . ")\n";
    }
    echo "
"; } else { echo "

✗ Failed to retrieve table structure

"; } echo "
"; // Test 4: Count users echo "
"; echo "

Test 4: User Count

"; $result = mysqli_query($db, "SELECT COUNT(*) as count FROM {$table_prefix}users"); if ($result) { $row = mysqli_fetch_assoc($result); echo "

✓ Total users in database: " . $row['count'] . "

"; } else { echo "

✗ Failed to count users

"; } echo "
"; // Test 5: Check required columns echo "
"; echo "

Test 5: Required Columns Check

"; $required_columns = ['user_id', 'users_login', 'users_passwd', 'users_role', 'users_email']; $result = mysqli_query($db, "SHOW COLUMNS FROM {$table_prefix}users"); $existing_columns = []; while ($row = mysqli_fetch_assoc($result)) { $existing_columns[] = $row['Field']; } $all_present = true; foreach ($required_columns as $col) { if (in_array($col, $existing_columns)) { echo "

✓ Column '$col' exists

"; } else { echo "

✗ Column '$col' missing!

"; $all_present = false; } } if ($all_present) { echo "

All required columns present!

"; } else { echo "

Some required columns are missing!

"; } echo "
"; // Test 6: Test MD5 hash function echo "
"; echo "

Test 6: Password Hashing Test

"; $test_password = "testpassword"; $hashed = md5($test_password); echo "

Test password: '$test_password'

"; echo "

MD5 hash: '$hashed'

"; echo "

✓ MD5 hashing works correctly

"; echo "
"; // Test 7: Test session functionality echo "
"; echo "

Test 7: Session Test

"; session_name("gameservers_website"); session_start(); $_SESSION['test_key'] = 'test_value'; if (isset($_SESSION['test_key']) && $_SESSION['test_key'] === 'test_value') { echo "

✓ Sessions working correctly

"; echo "

Session name: " . session_name() . "

"; echo "

Session ID: " . session_id() . "

"; unset($_SESSION['test_key']); } else { echo "

✗ Session test failed

"; } echo "
"; echo "
"; echo "

Summary

"; echo "

✓ All tests passed! Login functionality should work correctly.

"; echo "

⚠️ Remember to delete this test file before deploying to production!

"; echo "
"; echo ""; ?>