OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	01/07/2025 11:52:51 AM	rw-r--r--
📄 .gitignore	42 bytes	01/07/2025 11:52:51 AM	rw-r--r--
📄 .htaccess	803 bytes	01/07/2025 11:52:51 AM	rw-r--r--
📄 .htaccess.swp	12 KB	01/07/2025 11:52:52 AM	rw-r--r--
📄 .travis.yml	199 bytes	01/07/2025 11:52:52 AM	rw-r--r--
📄 addList.php	5.23 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 aditya_navbar.php	23.72 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 allTemplates.php	5 KB	05/19/2025 10:07:24 AM	rw-r--r--
📁 assets	-	01/07/2025 11:50:15 AM	rwxr-xr-x
📄 b_navbar.php	7.84 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 blacklist.php	13.36 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 bounceViewList.php	8.39 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 bounce_handler.php	4.99 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:24 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 clickViewList.php	5.13 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 combined.php	11.23 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 complaintsViewList.php	6.78 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 composer.json	200 bytes	01/07/2025 11:52:56 AM	rw-r--r--
📄 composer.lock	39.12 KB	01/07/2025 11:52:56 AM	rw-r--r--
📄 createList.php	17.4 KB	05/19/2025 10:07:24 AM	rw-r--r--
📁 credentials	-	01/07/2025 11:52:11 AM	rwxr-xr-x
📄 csv.php	11.75 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 db.php	1000 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:24 AM	rw-r--r--
📄 delete_list.php	509 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 deliveryViewList.php	6.87 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 download_open.php	1.22 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_report.php	3.33 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 edit_list.php	9.89 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 footer.php	1.7 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 grfx	-	01/07/2025 11:52:13 AM	rwxr-xr-x
📄 groupchatnavbar.php	607 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 himanshu_navbar.php	7.84 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 housekeeping.php	13.27 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 index.php	8.57 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 js	-	01/07/2025 11:52:15 AM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:24 AM	rw-r--r--
📁 log	-	01/07/2025 11:52:18 AM	rwxr-xr-x
📄 main.css	413 bytes	01/07/2025 11:53:01 AM	rw-r--r--
📄 navbar.php	23.77 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 newCompaign.php	11.12 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 openViewList.php	8.48 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:24 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 process_emails.php	11.31 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	01/07/2025 11:53:03 AM	rw-r--r--
📄 resubscribe.php	5.51 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 sample.csv	55 bytes	01/07/2025 11:53:03 AM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 saved_content.html	6.48 KB	01/07/2025 11:53:03 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 showListMembers.php	13.98 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 test-mail.csv	337 bytes	01/07/2025 11:53:05 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 unsubscribe.php	3.8 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📁 uploads	-	01/07/2025 11:52:34 AM	rwxr-xr-x
📁 vendor	-	05/19/2025 10:07:24 AM	rwxr-xr-x
📄 verify.html	486 bytes	01/07/2025 11:53:06 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 viewCampaign.php	23.92 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 viewList.php	15.04 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 xpress_handler.php	9.79 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zcreateList.php	13.51 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 znewCompaign.php	8.29 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zprocess_emails.php	10.19 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 zviewList.php	14.63 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zzindex.php	10.24 KB	05/19/2025 10:07:24 AM	rw-r--r--
📄 zzviewCampaign.php	22.42 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zzviewList.php	14.63 KB	05/19/2025 10:07:22 AM	rw-r--r--

Editing: edit_list.php

<?php
ini_set('display_startup_errors', 1);
include '../assets/php/validate.logged.php';
include 'db.php';
include '../assets/php/config.php';
include '../assets/php/function.php';
function show_email_details($conn, $id)
{
    $stmt = $conn->prepare("SELECT sc.id, sc.name, sc.email FROM subscribers sc INNER JOIN list l ON l.id = sc.list_id WHERE sc.list_id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    $rows = array();
    while ($row = $result->fetch_assoc()) {
        $rows[] = $row;
    }
    $stmt->close();
    return $rows;
}

if (isset($_GET['id'])) {
    $list_id = $conn->real_escape_string($_GET['id']);

// Fetch current data
    $sql = "SELECT list_name, active FROM list WHERE id='$list_id' AND user_id='$gUserId'";
    $result = $conn->query($sql);
    if ($result->num_rows == 1) {
        $row = $result->fetch_assoc();
    } else {
        echo "List not found";
        exit;
    }
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $list_id = $conn->real_escape_string($_POST['id']);
    $active = $conn->real_escape_string($_POST['active']);
    $list_name = $conn->real_escape_string($_POST['list_name']);

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

try {
        // Update the list
        $sql = "UPDATE list SET list_name='$list_name', active='$active' WHERE id='$list_id' AND user_id='$gUserId'";
        $conn->query($sql);

// Delete existing email details
        $sql = "DELETE FROM subscribers WHERE list_id='$list_id'";
        $conn->query($sql);

// Insert updated email details
        if (isset($_POST['name']) && isset($_POST['email'])) {
            $stmt = $conn->prepare("INSERT INTO subscribers (list_id, name, email) VALUES (?, ?, ?)");
            foreach ($_POST['name'] as $index => $name) {
                $email = $_POST['email'][$index];
                $stmt->bind_param("iss", $list_id, $name, $email);
                $stmt->execute();
            }
            $stmt->close();
        }

// Commit transaction
        $conn->commit();
        echo "<script>alert('Update successfully');</script>";
        header('Location: viewList.php');
        exit;
    } catch (Exception $e) {
        // Rollback transaction
        $conn->rollback();
        echo "Error updating list: " . $conn->error;
    }
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Knobly Cream: Create &bull; Reach &bull; Measure</title>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css">
    <link rel="stylesheet" href="../inc/style.css">

<style>
        body {
            font-family: 'Roboto', sans-serif;
            background-color: #f4f6f9;
        }

.container-fluid {
            padding: 20px;
        }

.main-content {
            background: #fff;
            border-radius: 8px;
            padding: 20px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.05);
        }

.btn-primary {
            background-color: #007bff;
            border-color: #007bff;
        }

.btn-primary:hover {
            background-color: #0056b3;
            border-color: #004085;
        }

.form-group label {
            font-weight: bold;
        }
    </style>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.10.5/font/bootstrap-icons.min.css" rel="stylesheet">
</head>

<body class="sb-nav-fixed">
    <?php include "navbar.php"; ?>
    <?php include "../assets/php/go_backbar.php";?>
    <div id="layoutSidenav">
        <?php include 'sidebar.php'; ?>
        <div id="layoutSidenav_content">
            <main>
                <div class="container-fluid">
                    <div class="main-content mt-5">
                        <div class="container">
                            <ol class="breadcrumb my-3">
                                <li class="breadcrumb-item w-100" style="display:flex; justify-content:space-between; align-items:center;">
                                    <h4>Edit List</h4>
                                   
                                </li>
                            </ol>
                            <form method="post" action="edit_list.php">
                                <input type="hidden" name="id" value="<?php echo htmlspecialchars($list_id); ?>">
                                <div class="form-group">
                                    <label for="list_name">List Name</label>
                                    <input type="text" class="form-control" id="list_name" name="list_name" value="<?php echo htmlspecialchars($row['list_name']); ?>" required>
                                </div>
                                <div class="form-group">
                                    <label for="active">Active</label>
                                    <select class="form-control" id="active" name="active">
                                        <option value="1" <?php echo ($row['active'] == 1) ? 'selected' : ''; ?>>Yes</option>
                                        <option value="0" <?php echo ($row['active'] == 0) ? 'selected' : ''; ?>>No</option>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <label for="email_details">Email Details</label>
                                    <div id="email_details">
                                        <?php foreach (show_email_details($conn, $list_id) as $index => $email_detail) { ?>
                                            <div class="row mb-2 email-row">
                                                <div class="col">
                                                    <input type="text" class="form-control" name="name[]" value="<?php echo htmlspecialchars($email_detail['name']); ?>" placeholder="Name" required>
                                                </div>
                                                <div class="col">
                                                    <input type="email" class="form-control" name="email[]" value="<?php echo htmlspecialchars($email_detail['email']); ?>" placeholder="Email" required>
                                                </div>
                                                <div class="col-auto">
                                                    <button type="button" class="btn btn-danger btn-sm remove-email">X</button>
                                                </div>
                                            </div>
                                        <?php } ?>
                                    </div>
                                    <button type="button" id="add_email" class="btn btn-success btn-sm mt-2">Add New Entry</button>
                                </div>
                                <button type="submit" class="btn btn-primary">Update</button>
                            </form>
                            <script>
                                document.addEventListener('DOMContentLoaded', function() {
                                    document.querySelectorAll('.remove-email').forEach(function(button) {
                                        button.addEventListener('click', function() {
                                            this.closest('.email-row').remove();
                                        });
                                    });

document.getElementById('add_email').addEventListener('click', function() {
                                        const emailDetailsDiv = document.getElementById('email_details');
                                        const newRow = document.createElement('div');
                                        newRow.classList.add('row', 'mb-2', 'email-row');
                                        newRow.innerHTML = `
                                            <div class="col">
                                                <input type="text" class="form-control" name="name[]" placeholder="Name" required>
                                            </div>
                                            <div class="col">
                                                <input type="email" class="form-control" name="email[]" placeholder="Email" required>
                                            </div>
                                            <div class="col-auto">
                                                <button type="button" class="btn btn-danger btn-sm remove-email">X</button>
                                            </div>
                                        `;
                                        emailDetailsDiv.appendChild(newRow);

newRow.querySelector('.remove-email').addEventListener('click', function() {
                                            newRow.remove();
                                        });
                                    });
                                });
                            </script>
                        </div>
                    </div>
                </div>
            </main>
        </div>
    </div>
</body>
<?php include 'footer.php'?>
</html>