Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
admin	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
assets	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
db	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
includes	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
uploads	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
user	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_USER_EDIT_ISSUE.md	6.15 KB	-rw-r--r--	2025-10-18 00:44
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README_DEPLOYMENT.txt	1.74 KB	-rw-r--r--	2025-10-18 01:49
README_REFERRAL_COMMISSIONS.md	4.02 KB	-rw-r--r--	2025-10-18 00:22
SQL_CHANGES_SUMMARY.md	2.02 KB	-rw-r--r--	2025-10-18 00:25
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_database_structure.php	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_duplicate_commissions.php	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_referrals_table.php	2.28 KB	-rw-r--r--	2025-10-18 00:39
complete_setup.sql	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup_for_import.sql	5.36 KB	-rw-r--r--	2025-10-18 01:59
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_referral_commissions.sql	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions_for_import.sql	705 B	-rw-r--r--	2025-10-18 01:59
index.php	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.15 KB	-rw-r--r--	2025-10-18 02:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
register.php	6.58 KB	-rw-r--r--	2025-10-18 02:05
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test_commission_application.php	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_display.php	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_fix.php	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_mobile_menu.php	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_referral.php	2.07 KB	-rw-r--r--	2025-10-17 23:55
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions_for_import.sql	710 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table.sql	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table_for_import.sql	426 B	-rw-r--r--	2025-10-18 01:59
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions_working.php	8.2 KB	-rw-r--r--	2025-10-18 00:56

Rename

<?php
// Direct database connection
$host = 'localhost';
$dbname = 'shareearn';
$username = 'root';
$password = '';

echo "<h2>Direct Table Creation</h2>";

try {
    // Connect to MySQL (without specifying database first)
    $pdo = new PDO("mysql:host=$host;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    echo "<p>✓ Connected to MySQL server</p>";
    
    // Create database if it doesn't exist
    $pdo->exec("CREATE DATABASE IF NOT EXISTS `$dbname` CHARACTER SET utf8 COLLATE utf8_general_ci");
    echo "<p>✓ Database '$dbname' checked/created</p>";
    
    // Select the database
    $pdo->exec("USE `$dbname`");
    
    // Drop table if it exists (for clean start)
    $pdo->exec("DROP TABLE IF EXISTS `referral_commissions`");
    echo "<p>✓ Previous table dropped (if existed)</p>";
    
    // Create the referral_commissions table
    $createTable = "CREATE TABLE `referral_commissions` (
        `id` INT AUTO_INCREMENT PRIMARY KEY,
        `level` INT NOT NULL UNIQUE,
        `commission_percentage` DECIMAL(5, 2) NOT NULL,
        `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )";
    
    $pdo->exec($createTable);
    echo "<p style='color: green;'>✓ referral_commissions table created successfully!</p>";
    
    // Insert default commission levels
    $insertData = "INSERT INTO `referral_commissions` (`level`, `commission_percentage`) VALUES 
        (1, 10.00),
        (2, 5.00),
        (3, 2.00)";
    
    $pdo->exec($insertData);
    echo "<p style='color: green;'>✓ Default commission levels inserted!</p>";
    
    // Verify the data
    $stmt = $pdo->prepare("SELECT * FROM `referral_commissions` ORDER BY `level` ASC");
    $stmt->execute();
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    echo "<h3>Verification:</h3>";
    if (count($results) > 0) {
        echo "<p style='color: green;'>✓ Successfully retrieved " . count($results) . " commission levels:</p>";
        echo "<table border='1' cellpadding='5'>";
        echo "<tr><th>Level</th><th>Percentage</th><th>Created</th></tr>";
        foreach ($results as $row) {
            echo "<tr>";
            echo "<td>" . $row['level'] . "</td>";
            echo "<td>" . $row['commission_percentage'] . "%</td>";
            echo "<td>" . $row['created_at'] . "</td>";
            echo "</tr>";
        }
        echo "</table>";
    } else {
        echo "<p style='color: red;'>✗ No data found in table</p>";
    }
    
    echo "<h3>Success!</h3>";
    echo "<p>The referral_commissions table has been created and populated.</p>";
    echo "<p>You should now be able to access the <a href='admin/referral_commissions.php'>Referral Commissions page</a> without errors.</p>";
    
} catch (PDOException $e) {
    echo "<p style='color: red;'>Error: " . $e->getMessage() . "</p>";
    
    // Specific error handling
    if (strpos($e->getMessage(), 'access denied') !== false) {
        echo "<p><strong>Solution:</strong> Check your database username/password in includes/db.php</p>";
    } elseif (strpos($e->getMessage(), 'Connection refused') !== false) {
        echo "<p><strong>Solution:</strong> Make sure XAMPP MySQL service is running</p>";
    }
}

echo "<p><a href='admin/referral_commissions.php'>Try Referral Commissions Page Now</a></p>";
?>