OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📄 .browserslistrc	208 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .gitignore	42 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .htaccess	803 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .htaccess.swp	12 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 .travis.yml	199 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 09-01-25navbar.php	30.59 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 15-02-25viewList.php	14.86 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 17-02-25newCompaign.php	12.43 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 NLEditor	-	03/26/2025 04:21:24 AM	rwxr-xr-x
📄 addList.php	6.06 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 adi_deliveryViewList.php	11.13 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_choose.php	6 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_choose_template.php	7.52 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_viewCampaign.php	24.73 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 arvind_choose_templates.php	10.83 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 assets	-	03/26/2025 04:20:38 AM	rwxr-xr-x
📄 back_choose_template.php	7.52 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 blacklist.php	13.06 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 bounceViewList.php	14.63 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 bounce_handler.php	5.05 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 check_identity	-	03/26/2025 04:16:12 AM	rwxr-xr-x
📄 checknotif.php	1020 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 choose_template.php	6.74 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 clickViewList.php	13.01 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 click_handler.php	1.75 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 complaintsViewList.php	8.41 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 composer.json	200 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 composer.lock	39.12 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 createList.php	19.13 KB	03/26/2025 04:06:48 AM	rw-r--r--
📁 credentials	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 csv.php	12.33 KB	03/26/2025 04:06:48 AM	rw-r--r--
📁 data	-	03/26/2025 04:21:24 AM	rwxr-xr-x
📄 db.php	991 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deleteTemplate.php	1.55 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 delete_list.php	959 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 delete_users.php	435 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deliveryViewList.php	12.9 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_Complaints.php	1.16 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_open.php	1.22 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_report.php	3.33 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 duplicate_campaign.php	1.67 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 edit_list.php	11.69 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 feedback.php	1.71 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 fetch_template.php	493 bytes	03/26/2025 04:06:50 AM	rw-r--r--
📄 footer.php	1.35 KB	03/26/2025 04:06:50 AM	rw-r--r--
📁 grfx	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 himanshu_index.php	6.58 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 himanshu_newCompaign.php	11.25 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 housekeeping.php	24.85 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 index.php	9.9 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 insert_list.php	2.64 KB	03/26/2025 04:06:50 AM	rw-r--r--
📁 js	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 load.php	159 bytes	03/26/2025 04:06:50 AM	rw-r--r--
📁 log	-	03/26/2025 04:16:25 AM	rwxr-xr-x
📄 main.css	1.3 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 navbar.php	22.54 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 navbar_menu.php	1.94 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 newCompaign.php	16.25 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 obc_cards.php	7.58 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 openViewList.php	14.4 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 open_handler.php	1.75 KB	03/26/2025 04:06:51 AM	rw-r--r--
📁 process	-	03/26/2025 04:16:33 AM	rwxr-xr-x
📄 process_emails.php	12.53 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 resubscribe.php	6.41 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sample.csv	55 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 save.php	252 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 save_campaign.php	612 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 saved_content.html	6.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 send_email.php	987 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 showListMembers.php	11.44 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 showcase.php	7.79 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sidebar.php	0 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 submit_form.php	2.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 template_index.php	10.08 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 test-mail.csv	337 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 test.php	969 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 test_choose_template.php	6.51 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 unsubscribe.php	6.87 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 upload_image.php	606 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📁 uploads	-	03/26/2025 04:16:39 AM	rwxr-xr-x
📁 vendor	-	03/26/2025 04:21:35 AM	rwxr-xr-x
📄 verify.html	486 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 verify.php	2.54 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 verify_email.php	5.03 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 viewCampaign.php	26.94 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 viewList.php	17.65 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 xpress_handler.php	10.51 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 znewCompaign.php	10.52 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zunsubscribe.php	5.82 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzindex.php	6.8 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzzzindex.php	6.68 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzzzzindex.php	55.73 KB	03/26/2025 04:06:52 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 '../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="../assets/css/bootstrap.min.4.5.css">
    <link rel="stylesheet" href="../assets/css/all.min.5.15.3.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>
    <style>
        .sideWithMainContainer {
            display: flex;
            flex-direction: row;
            gap: 10px;
            overflow-x: hidden;

}

.sideMaincontent {
            height: 100vh;
            overflow-y: scroll;
            padding: 30px 0;
        }

@media (min-width: 768px) {
            .col-md-2 {
                padding: 0px !important;
            }

}

@media (max-width: 768px) {
            .col-md-2 {
                display: none !important;
            }

}

.panelContent {
            height: 80% !important;
            overflow-y: auto !important;

}

main {
            padding-bottom: 40px;
        }

.mt-5,
        .my-5 {
            margin-top: 1px !important;
        }
    </style>

<script src="../assets/js/jquery-3.6.0.min.js"></script>
    <script src="../assets/js/popper.min.2.5.js"></script>
    <script src="../assets/js/bootstrap.bundle.min.4.5.js"></script>
    <link href="../assets/css/bootstrap-icons.min.1.10.css" rel="stylesheet">
    <link rel="stylesheet" href="../assets/css/styles.css">

</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>
        </div>

<?php include 'footer.php'; ?>
        <?php include '../assets/php/bottom_navbar.php'; ?>

</div>
</body>

</html>