OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .gitignore	42 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .htaccess	803 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .htaccess.swp	12 KB	03/05/2025 10:49:45 AM	rw-r--r--
📄 .travis.yml	199 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 09-01-25navbar.php	23.78 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 15-02-25viewList.php	15.21 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 17-02-25newCompaign.php	13.09 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 NLEditor	-	05/28/2025 07:37:39 AM	rwxrwxrwx
📄 addList.php	6.89 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 adi_deliveryViewList.php	11.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_choose.php	6.13 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_choose_template.php	7.73 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_viewCampaign.php	25.53 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 adityanewCompaign.php	18.61 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 adityaprocess_emails.php	12.93 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 arvind_choose_templates.php	11.17 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 assets	-	03/05/2025 10:50:21 AM	rwxr-xr-x
📄 back_choose_template.php	8.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 blacklist.php	13.47 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 bounceViewList.php	15.04 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 bounce_handler.php	5.05 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 choose_template.php	9.2 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 clickViewList.php	13.34 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 complaintsViewList.php	8.78 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 composer.json	200 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 composer.lock	39.12 KB	03/05/2025 10:49:45 AM	rw-r--r--
📄 createList.php	19.88 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 credentials	-	03/05/2025 10:49:47 AM	rwxr-xr-x
📄 csv.php	13.12 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 data	-	03/05/2025 10:50:45 AM	rwxr-xr-x
📄 db.php	1000 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 deleteTemplate.php	1.55 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 delete_list.php	903 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 deliveryViewList.php	13.13 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_Complaints.php	1.16 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_open.php	1.22 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_report.php	3.33 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 edit_list.php	11.92 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 fetch_template.php	493 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 footer.php	1.36 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 grfx	-	03/05/2025 10:49:48 AM	rwxr-xr-x
📄 himanshu_index.php	6.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 himanshu_newCompaign.php	11.92 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 housekeeping.php	25.61 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 index.php	10.15 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 js	-	03/05/2025 10:49:48 AM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📁 log	-	03/05/2025 10:49:56 AM	rwxr-xr-x
📄 main.css	1.3 KB	03/05/2025 11:02:42 AM	rw-r--r--
📄 navbar.php	22.64 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 navbar_menu.php	1.89 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 newCompaign.php	16.72 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 obc_cards.php	8.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 openViewList.php	14.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 process_emails.php	13.27 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	03/05/2025 10:49:46 AM	rw-r--r--
📄 resubscribe.php	7.17 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sample.csv	55 bytes	03/05/2025 10:49:46 AM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 saved_content.html	8 bytes	05/14/2025 08:36:09 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 showListMembers.php	12.16 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 template_index.php	10.29 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 test-mail.csv	337 bytes	03/05/2025 10:49:47 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 test_choose_template.php	6.85 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 unsubscribe.php	7.63 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📁 uploads	-	05/23/2025 09:06:53 AM	rwxrwxrwx
📁 vendor	-	05/19/2025 10:07:17 AM	rwxr-xr-x
📄 verify.html	486 bytes	03/05/2025 10:49:47 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 viewCampaign.php	27.83 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 viewList.php	18.1 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 xpress_handler.php	10.38 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 znewCompaign.php	11.22 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zunsubscribe.php	6.02 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zzindex.php	6.89 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zzzzindex.php	6.76 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zzzzzindex.php	6.88 KB	05/19/2025 10:07:17 AM	rw-r--r--

Editing: csv.php

<?php
include '../assets/php/validate.logged.php';
include 'db.php';
include '../assets/php/config.php';
include '../assets/php/function.php';
$list_name = "";
$list_id = "";

// Check if the form was submitted to add a list
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['list_name'])) {
    $list_name = $_POST['list_name'];
    // echo $list_name;die;
    $sql = "INSERT INTO list (list_name, user_id) VALUES ('$list_name', '$gUserId')";
    if (mysqli_query($conn, $sql)) {
        $list_id = mysqli_insert_id($conn); // Get the ID of the inserted list
        echo "<script>alert('List data stored successfully');</script>";
    } else {
        echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
    }
}

// Check if the form was submitted to import CSV
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_FILES['csv_file']) && isset($_POST['list_id'])) {
    $list_id = $_POST['list_id']; // Get the list ID
    $file = $_FILES['csv_file']['tmp_name'];
    $handle = fopen($file, "r");
    if ($handle !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $name = mysqli_real_escape_string($conn, $data[0]);
            $email = mysqli_real_escape_string($conn, $data[1]);
            $sql = "INSERT INTO subscribers (name, email, list_id) VALUES ('$name', '$email', '$list_id')";
            if (!mysqli_query($conn, $sql)) {
                echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
            }
        }
        fclose($handle);
        echo "<script>alert('CSV data imported successfully');</script>";
    } else {
        echo "<script>alert('Error opening the file');</script>";
    }
    // Redirect to newCompaign.php after processing CSV
    echo "<script>window.location = 'newCompaign.php';</script>";
}

// Check if the form was submitted to add data via textarea
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['line']) && isset($_POST['list_id'])) {
    $list_id = $_POST['list_id'];
    $lines = explode("\n", $_POST['line']);
    foreach ($lines as $line) {
        $data = explode(",", $line);
        if (count($data) == 2) {
            $name = mysqli_real_escape_string($conn, trim($data[0]));
            $email = mysqli_real_escape_string($conn, trim($data[1]));
            $sql = "INSERT INTO subscribers (name, email, list_id) VALUES ('$name', '$email', '$list_id')";
            if (!mysqli_query($conn, $sql)) {
                echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
            }
        }
    }
    echo "<script>alert('Textarea data imported successfully');</script>";
    echo "<script>window.location = 'newCompaign.php';</script>";
}
?>

<!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>
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
    <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="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"
        integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.0.0/animate.min.css" />

/* Light mode */
        .table-bordered td,
        .table-bordered th {
            border: 1px solid #000000 !important;
        }

.table td,
        .table th {
            padding: .75rem;
            vertical-align: top;
            border-top: 1px solid #000000 !important;
        }
    </style>
    <style>
        .sideWithMainContainer {
            display: flex;
            flex-direction: row;
            gap: 10px;
            overflow-x: hidden;

}

.sideMaincontent {
            height: 85vh;
            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;
        }
    </style>
</head>

<div class="xpressMainConatiner" style="display: flex; flex-direction:column">
        <div class="sideWithMainContainer">
            <div class="col-md-2">
                <? include 'assets/php/sidebar.php' ?>
            </div>
            <div id="layoutSidenav" class="col-sm-12 col-md-10 sideMaincontent">
                <? include 'navbar_menu.php' ?>
                <div id="layoutSidenav_content">
                    <main>
                        <div id="panelContent" class="container-fluid">
                            <div class="main-content">
                                <div class="container">
                                    <?php if (!empty($list_name) && !empty($list_id)): ?>
                                        <p>List: <span class="badge badge-info"><?php echo htmlspecialchars($list_name); ?></span>
                                        </p>
                                    <?php endif; ?>
                                    <form action="csv.php" method="POST" enctype="multipart/form-data"
                                        class="form-vertical well" onsubmit="return validateForm()">
                                        <label for="csv_file"><em>CSV format:</em></label>
                                        <ul>
                                            <li>Format your CSV the same way as the example below <a href="sample.csv" download
                                                    style="background-color: yellow; color: black;">Click here, to download
                                                    sample csv file</a></li>
                                            <li>Your CSV columns should be separated by commas, not semi-colons or any other
                                                characters</li>
                                            <li>The number of columns in your CSV should be the same as the example below</li>

</ul>
                                        <table class="table table-bordered">
                                            <thead>
                                                <tr>
                                                    <th>Name</th>
                                                    <th>Email</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr>
                                                    <td>John Morris</td>
                                                    <td>john@gmail.com</td>
                                                </tr>
                                                <tr>
                                                    <td>Jane root</td>
                                                    <td>rootj@gmail.com</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <div class="form-group">
                                            <input type="file" class="form-control-file" id="csv_file" name="csv_file" required>
                                        </div>

<input type="hidden" name="list_id" value="<?php echo htmlspecialchars($list_id); ?>">
                                        <button type="submit" class="btn btn-inverse"
                                            style="background-color: #4CAF50; color: white; border: none; padding: 12px 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 16px; margin: 4px 2px; cursor: pointer; border-radius: 8px;">
                                            <i class="fas fa-file-import"></i> Import CSV
                                        </button>
                                    </form>

<hr>
                                    <h2>Add name and email per line</h2>
                                    <form action="csv.php" method="POST" class="form-vertical well"
                                        onsubmit="return validateForm()">
                                        <div class="form-group">
                                            <label for="line">Name and email<br><em style="color:#A1A1A1">(to import more than
                                                    just name and email, import via CSV)</em></label>
                                            <textarea class="form-control" id="line" name="line" rows="10"
                                                placeholder="Eg. Jane root, rootj@gmail.com"></textarea>
                                        </div>
                                        <input type="hidden" name="list_id" value="<?php echo htmlspecialchars($list_id); ?>"
                                            required>
                                        <button type="submit" class="btn btn-inverse"
                                            style="background-color: #4CAF50; color: white; border: none; padding: 12px 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 16px; margin: 4px 2px; cursor: pointer; border-radius: 8px;"><i
                                                class="fas fa-plus"></i> Add</button>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </main>
                </div>
            </div>
        </div>
        <?php include 'footer.php'; ?>
        <?php include '../assets/php/bottom_navbar.php'; ?>
    </div>

if (!csvFile && !manualInput) {
                alert("Please enter a name and email either via CSV or manually.");
                return false; // Prevent form submission
            }
            return true; // Allow form submission
        }
    </script>

</body>

</html>