Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.0.30

User:

u885320773

Directory:

/home/u885320773/domains/sugatu.in/public_html/admin/process

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: change_sequence.php

<?php
// process/change_sequence.php
include_once __DIR__ . '/../config.php'; // adjust path if needed

if (!isset($_GET['id'], $_GET['dir'])) {
    header('Location: ../bnr-slider-30121989.php'); // go back
    exit;
}

$id = (int)$_GET['id'];
$dir = $_GET['dir'] === 'up' ? 'up' : 'down';

try {
    // Start transaction
    $conn->begin_transaction();

// Fetch current slider's sequence (lock row)
    $stmt = $conn->prepare("SELECT id, COALESCE(sequence, 0) AS sequence FROM bannerslider WHERE id = ? FOR UPDATE");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $res = $stmt->get_result();
    if ($res->num_rows === 0) {
        $conn->rollback();
        $stmt->close();
        header('Location: ../bnr-slider-30121989.php');
        exit;
    }
    $current = $res->fetch_assoc();
    $current_seq = (int)$current['sequence'];
    $stmt->close();

if ($dir === 'up') {
        // find nearest item with sequence < current_seq (largest among those)
        $stmt2 = $conn->prepare("SELECT id, COALESCE(sequence, 0) AS sequence FROM bannerslider WHERE sequence < ? ORDER BY sequence DESC LIMIT 1 FOR UPDATE");
        $stmt2->bind_param("i", $current_seq);
        $stmt2->execute();
    } else {
        // down: nearest with sequence > current_seq (smallest among those)
        $stmt2 = $conn->prepare("SELECT id, COALESCE(sequence, 0) AS sequence FROM bannerslider WHERE sequence > ? ORDER BY sequence ASC LIMIT 1 FOR UPDATE");
        $stmt2->bind_param("i", $current_seq);
        $stmt2->execute();
    }

$res2 = $stmt2->get_result();
    if ($res2->num_rows === 0) {
        // nothing to swap (already top/bottom)
        $conn->commit();
        $stmt2->close();
        header('Location: ../bnr-slider-30121989.php');
        exit;
    }
    $other = $res2->fetch_assoc();
    $other_id = (int)$other['id'];
    $other_seq = (int)$other['sequence'];
    $stmt2->close();

// swap sequences
    $upd = $conn->prepare("UPDATE bannerslider SET sequence = ? WHERE id = ?");
    $upd->bind_param("ii", $other_seq, $id);
    $upd->execute();
    $upd->close();

$upd2 = $conn->prepare("UPDATE bannerslider SET sequence = ? WHERE id = ?");
    $upd2->bind_param("ii", $current_seq, $other_id);
    $upd2->execute();
    $upd2->close();

$conn->commit();

} catch (Exception $e) {
    if ($conn->errno) {
        $conn->rollback();
    }
    // optional: log error
}

// redirect back to list
header('Location: ../bnr-slider-30121989.php');
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: change_sequence.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation