Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/cheapsubs.shop/public_html

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: update-database.php

<?php
/**
 * Database Update Script
 * Run this file to update the database with correct CCAvenue credentials
 */

require_once __DIR__ . '/includes/config.php';

try {
    $db = getDB();
    
    echo "<h2>Updating Database...</h2>";
    
    // Update payment gateway settings with correct credentials
    $stmt = $db->prepare("UPDATE payment_gateway_settings SET 
        merchant_id = ?, 
        access_code = ?, 
        working_key = ?,
        redirect_url = ?,
        cancel_url = ?
        WHERE id = 1");
    
    $stmt->execute([
        CCAVENUE_MERCHANT_ID,
        CCAVENUE_ACCESS_CODE,
        CCAVENUE_WORKING_KEY,
        APP_URL . '/payment-response.php',
        APP_URL . '/payment-cancel.php'
    ]);
    
    if ($stmt->rowCount() > 0) {
        echo "<p style='color:green;'>✓ Payment gateway settings updated successfully!</p>";
    } else {
        // Insert if not exists
        $stmt = $db->prepare("INSERT INTO payment_gateway_settings 
            (merchant_id, access_code, working_key, test_mode, redirect_url, cancel_url, is_active) 
            VALUES (?, ?, ?, 1, ?, ?, 1)");
        $stmt->execute([
            CCAVENUE_MERCHANT_ID,
            CCAVENUE_ACCESS_CODE,
            CCAVENUE_WORKING_KEY,
            APP_URL . '/payment-response.php',
            APP_URL . '/payment-cancel.php'
        ]);
        echo "<p style='color:green;'>✓ Payment gateway settings inserted successfully!</p>";
    }
    
    // Verify the settings
    $stmt = $db->query("SELECT * FROM payment_gateway_settings WHERE is_active = 1 LIMIT 1");
    $settings = $stmt->fetch();
    
    echo "<h3>Current Settings:</h3>";
    echo "<pre>";
    echo "Merchant ID: " . $settings['merchant_id'] . "\n";
    echo "Access Code: " . substr($settings['access_code'], 0, 10) . "...\n";
    echo "Working Key: " . substr($settings['working_key'], 0, 10) . "...\n";
    echo "Test Mode: " . ($settings['test_mode'] ? 'Yes' : 'No') . "\n";
    echo "Redirect URL: " . $settings['redirect_url'] . "\n";
    echo "</pre>";
    
    echo "<p><a href='payment.php'>Test Payment</a></p>";
    
} catch (PDOException $e) {
    echo "<p style='color:red;'>Error: " . $e->getMessage() . "</p>";
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update-database.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation