OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📁 NW_images	-	03/26/2025 04:16:42 AM	rwxr-xr-x
📁 assets	-	03/26/2025 04:16:42 AM	rwxr-xr-x
📄 db_gallery.php	292 bytes	03/26/2025 03:48:04 AM	rw-r--r--
📄 edit_template.php	658 bytes	03/26/2025 03:48:04 AM	rw-r--r--
📄 fetch_data.php	773 bytes	03/26/2025 03:48:04 AM	rw-r--r--
📄 fetch_titles.php	0 bytes	03/26/2025 03:48:04 AM	rw-r--r--
📄 form.js	7.64 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 getAnalyticsData.php	1.45 KB	03/26/2025 03:48:04 AM	rw-r--r--
📁 images2	-	03/26/2025 04:07:44 AM	rwxr-xr-x
📁 images3	-	03/26/2025 04:07:45 AM	rwxr-xr-x
📁 images4	-	03/26/2025 04:07:46 AM	rwxr-xr-x
📄 index.php	11.32 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 load_template.php	2.21 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 nleditor_navbar.php	22.5 KB	03/26/2025 03:48:04 AM	rw-r--r--
📁 pages	-	03/26/2025 04:16:46 AM	rwxr-xr-x
📁 process	-	03/26/2025 04:07:46 AM	rwxr-xr-x
📄 process.js	30.37 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 processb.js	31.17 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 save-template.php	2.75 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 savedPages.php	20.61 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 script.js	34.02 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 styles.css	2.43 KB	03/26/2025 03:48:04 AM	rw-r--r--
📄 upload.php	858 bytes	03/26/2025 03:48:04 AM	rw-r--r--
📁 uploads	-	03/26/2025 04:16:47 AM	rwxr-xr-x

Editing: savedPages.php

<?
include '../assets/php/validate.logged.php';
include '../assets/php/db_config.php';
include '../assets/php/function.php';

function getSavedLandingPages($userId)
{
    global $creamdb;

$query = "SELECT id, title, url, created_at FROM user_landing_page WHERE user_id = ? AND deleteFlag='N' ORDER BY created_at DESC";
    $stmt = $creamdb->prepare($query);
    $stmt->bind_param("i", $userId);
    $stmt->execute();
    $result = $stmt->get_result();

$pages = [];
    while ($row = $result->fetch_assoc()) {
        $pages[] = $row;
    }

return $pages;
}

// Replace the <div class="marginDiv"></div> with this code
$savedPages = getSavedLandingPages($gUserId);

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

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Create Landing Page</title>
    <link rel="stylesheet" href="../assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="../assets/css/all.min.css">

<link rel="stylesheet" href="../assets/css/animate.min.css" />

<link rel="stylesheet" href="../assets/old/style.css" />
    <link rel="stylesheet" href="../assets/css/styles.css" />

<link rel="icon" type="image/x-icon" href="/img/logo.ico">

<link href="../assets/css/bootstrap.min.css" rel="stylesheet">

<link href="../assets/css/cropper.min.css" rel="stylesheet">

.dashboard {
            display: grid;
            /* grid-template-columns: repeat(4, 1fr); */
            /* 4 cards per row */
            gap: 20px;
        }

.card {
            background-color: #ffffff;
            border-radius: 10px;
            overflow: hidden;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            text-decoration: none;
            color: inherit;
            transition: transform 0.3s ease, box-shadow 0.3s ease, filter 0.3s ease;
            position: relative;
            display: block;
            width: 250px;
            height: auto;
        }

.card:hover {
            transform: translateY(-8px);
            box-shadow: 0 10px 20px rgba(0, 0, 0, 0.15);
        }

.card img {
            width: 100%;
            height: 180px;
            object-fit: cover;
            transition: opacity 0.3s ease;
        }

.card img:hover {
            opacity: 0.8;
        }

.card h3 {
            margin: 10px 0;
            font-size: 1.2rem;
            font-weight: bold;
            color: #333;
            padding-left: 11px;
        }

.card p {
            font-size: 1rem;
            color: #777;
        }

.card .card-content {
            padding: 15px;
        }

.card .card-content p {
            margin-top: 10px;
            color: #666;
        }

.card .card-footer {
            position: absolute;
            bottom: 0;
            left: 0;
            right: 0;
            padding: 10px;
            background: rgba(0, 0, 0, 0.5);
            color: white;
            font-size: 0.9rem;
            text-align: center;
        }

.go-back-bar {
            top: 90px !important;
            left: 20px !important;
        }

.cont {
            /* padding-top: 85px; */
        }

.card:hover .card-footer {
            background: rgba(0, 0, 0, 0.7);
        }

.heading {
            color: black;
        }

@media (max-width:768px) {
            .heading {
                font-size: x-large;
            }

.go-back-bar {
                top: 70px !important;
                left: 10px !important;
            }
        }

@media (max-width:425px) {
            .heading {
                font-size: larger;
            }

.go-back-bar {
                top: 65px !important;
                left: 0px !important;
                padding: 0px 10px !important;
            }

.dashboard {
                grid-template-columns: repeat(1, 1fr) !important;
            }

.cont {
                padding-top: 70px;
            }

.marginDiv {
                margin: 20vw;
            }
        }

.marginDiv {
            margin: 10vw;
        }

.saved-pages {
            margin-top: 2rem;
        }

.saved-page {
            position: relative;
            width: 100%;
            transition: transform 0.3s ease-in-out;
            background: #fff;
            border: 1px solid rgba(0, 0, 0, 0.1);
            border-radius: 8px;
        }

.saved-page:hover {
            transform: translateY(-5px);
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);
        }

.card-body {
            padding: 1.5rem;
        }

.card-body h3 {
            margin: 0;
            font-size: 1.2rem;
            color: black;
            font-weight: 600;
        }

.card-body p {
            font-size: 0.9rem;
            margin: 0.5rem 0;
            color: #666;
        }

.action-buttons {
            display: flex;
            gap: 0.8rem;
            margin-top: 1rem;
        }

.btn-sm {
            padding: 0.4rem 0.8rem;
            font-size: 0.9rem;
        }

.btn-sm i {
            margin-right: 0.4rem;
        }

.no-pages {
            text-align: center;
            padding: 3rem;
            background: #fff;
            border-radius: 10px;
            color: #666;
            border: 2px dashed #ddd;
        }

.heading {
            margin-bottom: 1.5rem;
            font-weight: 600;
            position: relative;
            padding-bottom: 0.5rem;
        }

.heading::after {
            content: '';
            position: absolute;
            bottom: 0;
            left: 0;
            width: 50px;
            height: 3px;
            background: #db5919;
        }

/* Responsive Grid */
        .dashboard {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
            gap: 1.5rem;
            padding: 1rem;
        }

@media (max-width: 768px) {
            .dashboard {
                grid-template-columns: repeat(2, 1fr);
            }
        }

@media (max-width: 425px) {
            .dashboard {
                grid-template-columns: 1fr;
            }

.saved-page {
                /* width: 60%; */
            }

.card-body {
                padding: 1rem;
            }
        }
    </style>

.modal-content {
            /* background-color: #ffffff; */
            border-radius: 8px;
            /* Rounded corners */
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.15);
            /* Subtle shadow */
            width: 90%;
            /* Responsive width */
            max-width: 800px;
            /* Maximum width */
            overflow: hidden;
            /* Prevent content overflow */
            display: flex;
            flex-direction: column;
            /* Stack content vertically */
        }

.modal-content h4 {
            padding: 20px;
            margin: 0;
            border-bottom: 1px solid #eee;
            font-size: 1.5rem;
            font-weight: 600;
            color: #333;
        }

#analyticsData {
            padding: 20px;
            overflow-x: auto;
            /* Enable horizontal scrolling for tables */
        }

#analyticsData table {
            width: 100%;
            border-collapse: collapse;
            font-size: 0.9rem;
        }

#analyticsData th,
        #analyticsData td {
            padding: 12px 15px;
            text-align: left;
            border-bottom: 1px solid #eee;
        }

#analyticsData th {
            /* background-color: #f8f8f8; */
            font-weight: 600;
        }

#analyticsData tr:hover {
            /* background-color: #f0f0f0; */
        }

.modal-footer {
            padding: 20px;
            text-align: right;
            border-top: 1px solid #eee;
        }

.modal-close {
            background-color: #e53935;
            /* Modern red */
            color: white;
            padding: 12px 20px;
            border: none;
            border-radius: 6px;
            cursor: pointer;
            font-size: 1rem;
            transition: background-color 0.3s ease;
            /* Smooth transition */
        }

.modal-content {
            color: black !important;
            ;
        }

.modal-close:hover {
            background-color: #d32f2f;
        }

/* Responsive adjustments */
        @media (max-width: 600px) {
            .modal-content {
                width: 95%;
            }

#analyticsData th,
            #analyticsData td {
                padding: 8px 10px;
                font-size: 0.85rem;
            }
        }

.card {
            color: black;
            background-color: #f0f2f5 !important;
        }
    </style>
    <script src="../assets/js/jquery-3.6.0.min.js"></script>
    <script src="../assets/js/popper.min.js"></script>
    <script src="../assets/js/bootstrap.min.js"></script>

<script src="../assets/js/bootstrap.bundle.min.js"></script>

<script src="../assets/js/bootstrap.bundle.min.js"></script>
    <style>
        .sideWithMainContainer {
            display: flex;
            flex-direction: row;
            gap: 10px;
            overflow-x: hidden;

}

.sideMaincontent {
            height: 85vh;
            overflow-y: scroll;
            padding: 30px 20px;
        }

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

}

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

}

.create-new-page {
            display: flex;
            flex-direction: column;
            align-items: center;
            justify-content: center;
            height: 100%;
            transition: background-color 0.3s;
        }

.create-new-page:hover {
            background-color: #f8f9fa;
        }

.plus-icon {
            font-size: 2rem;
            margin: 0;
        }

.create-text {
            margin: 0;
            font-size: 0.9rem;
        }

@media (min-width:1350px) {
            .dashboard {
                grid-template-columns: repeat(4, 1fr);
            }
        }
    </style>
</head>

<div class="sideWithMainContainer">
        <div class="col-md-2">
            <? include '../assets/php/sidebar.php' ?>
        </div>
        <div class=" container-fluid col-sm-12 col-md-10 sideMaincontent" style="padding-bottom: 70px;">
            <h1 class="heading">Lead Pages</h1>

<div class="dashboard saved-pages">
                <? if ($gUserPlan == 0) {
                ?>
                    <div class="alert alert-success" role="alert">Creating <b>LeadPages</b> is only available for <b>Pro</b> users! Click on Upgrade to Upgrade your account-<a href="../premium.php">Upgrade</a> .</div>
                <?
                } else { ?>
                    <div class="card saved-page">
                        <div class="card-body create-new-page" onclick="window.location.href='index.php';" style="cursor: pointer; padding: 0px;">
                            <h3 class="heading">Create New Page</h3>
                            <p class="plus-icon" style="font-size:40px; color:#db5919">+</p>
                        </div>
                    </div>
                <? } ?>
                <?
                if (count($savedPages) > 0) {

foreach ($savedPages as $page) {
                        $pageName = str_replace('.html', '', htmlspecialchars($page['title']));
                        echo '
        <div class="card saved-page">
            <div class="card-body">
                <h3 class="heading">' . $pageName . '</h3>
                <p class="text-muted">Created: ' . date('M d, Y', strtotime($page['created_at'])) . '</p>
                <div class="action-buttons">
                    <a href="leadpage/landingPage.php?id=' . $page['id'] . '" class="btn btn-primary btn-sm" target="_blank">
                        <i class="fas fa-external-link-alt"></i> View
                    </a>
                    <button class="btn btn-danger btn-sm delete-page" data-id="' . $page['id'] . '">
                        <i class="fas fa-trash"></i> Delete
                    </button>
                    <button class="analytics-btn btn btn-primary btn-sm" data-id="' . $page['id'] . '">
                        <i class="fa-solid fa-circle-info"></i> Analytics
                    </button>
                </div>
            </div>
        </div>';
                    }
                } else {
                    echo '<div class="no-pages">
        <i class="fas fa-folder-open fa-3x text-muted"></i>
        <p class="mt-3">No saved Lead pages yet</p>
    </div>';
                }
                echo '</div>';
                ?>
                <div class="marginDiv"></div>
                
                <div id="analyticsModal" class="modal">
                    <div class="modal-content" style="color:black;">
                        <h4>Analytics Data</h4>
                        <div id="analyticsData"></div> 
                        <div class="modal-footer">
                            <a href="javascript:void(0);" class="modal-close btn">Close</a>
                        </div>
                    </div>
                </div>
            </div>
        </div>

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

// Listen for click event on the Analytics button
                $('.analytics-btn').click(function() {
                    var pageId = $(this).data('id'); // Get the page ID from the data attribute

// Send the AJAX request to fetch the analytics data
                    $.ajax({
                        url: 'getAnalyticsData.php', // The URL to send the request to
                        type: 'POST', // The request method (POST)
                        data: {
                            id: pageId
                        }, // Send the page ID as data
                        dataType: 'json', // Expecting JSON response
                        success: function(data) {
                            var html = '';
                            if (data.success) {
                                // If data is fetched successfully, display it in a table
                                html = `
                    <table>
                        <tr>
                            <th>Name</th>
                            <th>Email</th>
                            <th>Mobile</th>
                            <th>Message</th>
                            <th>Time</th>
                        </tr>
                    `;
                                // Loop through all the rows and generate HTML for each row
                                $.each(data.data, function(index, row) {
                                    html += `
                            <tr>
                                <td>${row.name}</td>
                                <td>${row.email}</td>
                                <td>${row.mobile}</td>
                                <td>${row.query}</td>
                                <td>${row.created_at}</td>
                            </tr>
                        `;
                                });
                                html += `</table>`;
                            } else {
                                // If no data is found, show the "No data found" message
                                html = '<p>No data found.</p>';
                            }

// Insert the HTML content into the modal's #analyticsData div
                            $('#analyticsData').html(html);

// Open the modal
                            $('#analyticsModal').fadeIn();
                        },
                        error: function(xhr, status, error) {
                            console.error("AJAX Error: " + error);
                            $('#analyticsData').html('<p>An error occurred while fetching the data.</p>');
                            $('#analyticsModal').fadeIn();
                        }
                    });
                });

// Close the modal when clicking the close button
                $('.modal-close').click(function() {
                    $('#analyticsModal').fadeOut();
                });
            });
        </script>
        <script>
            $(document).ready(function() {
                // Delete landing page functionality
                $('.delete-page').click(function(e) {
                    e.preventDefault();
                    const pageId = $(this).data('id');

if (confirm('Are you sure you want to delete this landing page?')) {
                        $.ajax({
                            url: 'process/delete_landing_page.php',
                            type: 'POST',
                            data: {
                                id: pageId
                            },
                            success: function(response) {
                                console.log(response);
                                // Remove the card from the UI
                                $(e.target).closest('.card').fadeOut(300, function() {
                                    $(this).remove();

// Check if there are any remaining cards
                                    if ($('.saved-page').length === 0) {
                                        $('.saved-pages').replaceWith(`
                                    <div class="no-pages">
                                        <i class="fas fa-folder-open fa-3x text-muted"></i>
                                        <p class="mt-3">No saved landing pages yet</p>
                                    </div>
                                `);
                                    }
                                });
                            },
                            error: function() {
                                alert('Error connecting to the server. Please try again.');
                            }
                        });
                    }
                });
            });
        </script>
</body>

</html>