OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .gitignore	42 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess	803 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess.swp	12 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 .travis.yml	199 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 addList.php	4.7 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 allTemplates.php	5 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 blacklist.php	14.07 KB	08/22/2024 05:43:02 AM	rw-r--r--
📄 bounceViewList.php	7.67 KB	08/22/2024 05:07:15 AM	rw-r--r--
📄 bounce_handler.php	5 KB	08/23/2024 09:54:48 AM	rw-rw-rw-
📄 bprocess_emails.php	6.73 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	08/14/2024 10:49:56 AM	rw-r--r--
📁 check_identity	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 click_handler.php	1.75 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 combined.php	11.28 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 complaintsViewList.php	6.8 KB	08/22/2024 05:20:43 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.json	200 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.lock	39.12 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 createList.php	11.23 KB	08/21/2024 11:56:25 AM	rw-r--r--
📁 credentials	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 csv.php	10.1 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 db.php	1000 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_list.php	565 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_users.php	435 bytes	08/20/2024 04:49:00 AM	rw-r--r--
📄 deliveryViewList.php	6.6 KB	08/22/2024 05:16:19 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_delivered.php	971 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 edit_list.php	10.01 KB	11/11/2024 12:41:09 PM	rw-r--r--
📄 feedback.php	1.71 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 footer.php	4.2 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 groupchatnavbar.php	607 bytes	09/01/2024 07:28:02 AM	rw-r--r--
📄 housekeeping.php	10.6 KB	08/20/2024 06:05:30 AM	rw-r--r--
📄 index.php	8.12 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 insert_list.php	2.64 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 log	-	08/14/2024 10:50:00 AM	rwxr-xr-x
📄 navbar.php	1.63 KB	08/20/2024 04:55:53 AM	rw-r--r--
📄 newCompaign.php	7.59 KB	08/21/2024 11:50:50 AM	rw-r--r--
📄 new_table.php	13.36 KB	10/07/2024 11:02:11 AM	rw-r--r--
📄 open_handler.php	1.75 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 process	-	08/20/2024 05:01:41 AM	rwxr-xr-x
📄 process_emails.php	10.36 KB	08/22/2024 05:44:39 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 resubscribe.php	5.38 KB	08/19/2024 11:32:36 AM	rw-r--r--
📄 sample.csv	55 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email.php	987 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 showListMembers.php	12.44 KB	08/22/2024 05:39:43 AM	rw-r--r--
📄 showcase.php	7.93 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sidebar.php	3.12 KB	09/01/2024 07:23:43 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 submit_form.php	2.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 test-mail.csv	337 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test.php	969 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 unsubscribe.php	3.36 KB	08/19/2024 11:32:22 AM	rw-r--r--
📄 upload_image.php	606 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📁 uploads	-	03/20/2025 06:55:44 AM	rwxrwxrwx
📁 vendor	-	08/14/2024 11:08:43 AM	rwxr-xr-x
📄 verify.html	486 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify.php	3.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify_email.php	5.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	08/21/2024 11:46:34 AM	rw-r--r--
📄 viewList.php	9.82 KB	08/21/2024 12:24:20 PM	rw-r--r--
📄 zprocess_emails.php	10.21 KB	08/14/2024 11:34:54 AM	rw-r--r--
📄 zshowListMembers.php	4.59 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zzedit_list.php	8.42 KB	08/22/2024 05:34:33 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	08/14/2024 10:49:58 AM	rw-r--r--

Editing: edit_list.php

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include '../inc/validate.logged.php';
include 'db.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"; ?>
    <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>
                                    <a href="viewList.php" class="btn btn-primary" style="background-color: #007bff; border-color: #007bff;">
                                        <i class="bi bi-arrow-left"></i> Back
                                    </a>
                                </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>

</html>