OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/09/2025 11:18:49 AM	rwxr-xr-x
📄 about.html	3.05 KB	06/15/2021 04:56:35 AM	rw-r--r--
📄 activate.php	2.56 KB	01/10/2021 11:01:39 AM	rw-r--r--
📁 admin	-	11/06/2024 11:06:02 AM	rwxr-xr-x
📄 analytics.php	39.84 KB	11/07/2024 08:38:42 AM	rw-r--r--
📄 article.php	16.58 KB	07/22/2024 11:38:48 AM	rw-r--r--
📁 audio	-	11/05/2024 05:01:58 AM	rwxrwxrwx
📄 backend.php	11.94 KB	08/02/2024 11:50:27 AM	rw-r--r--
📄 colortest.php	24.1 KB	07/31/2024 11:46:52 AM	rw-r--r--
📄 contact.html	2.79 KB	06/15/2021 04:53:32 AM	rw-r--r--
📄 copytest.html	3.9 KB	11/05/2024 09:57:47 AM	rw-r--r--
📄 dashboard.php	12.45 KB	08/26/2024 06:33:48 AM	rw-r--r--
📁 eyecandy	-	07/28/2024 06:12:57 AM	rwxrwxrwx
📄 geo_location.php	3.55 KB	08/07/2024 10:36:18 AM	rw-r--r--
📁 grfx	-	08/15/2024 05:29:48 AM	rwxr-xr-x
📁 inc	-	08/02/2024 11:49:22 AM	rwxr-xr-x
📄 index.html	11.81 KB	07/28/2024 04:53:52 PM	rw-r--r--
📄 info.php	14 bytes	10/02/2020 04:48:53 AM	rw-r--r--
📁 newReader	-	08/13/2024 01:41:05 PM	rwxr-xr-x
📄 phonedashboard.php	24.05 KB	07/31/2024 09:31:45 AM	rw-r--r--
📄 privacy.html	9.99 KB	06/15/2021 04:53:16 AM	rw-r--r--
📁 process	-	09/12/2024 12:29:57 PM	rwxr-xr-x
📄 reader.zip	37.35 MB	10/31/2024 02:49:40 AM	rw-r--r--
📄 refund.html	7.34 KB	06/15/2021 04:53:16 AM	rw-r--r--
📄 reset.html	3.01 KB	06/15/2021 04:53:17 AM	rw-r--r--
📄 signup.html	8.08 KB	07/05/2021 07:28:05 AM	rw-r--r--
📄 splash.html	1.11 KB	01/10/2021 12:49:20 PM	rw-r--r--
📁 texttovoice	-	08/02/2024 11:50:23 AM	rwxr-xr-x
📁 thumbsUp	-	08/27/2024 07:48:23 AM	rwxr-xr-x
📄 usage.html	30.88 KB	06/15/2021 04:53:17 AM	rw-r--r--
📄 zzzdashboard.php	11.95 KB	07/28/2024 02:55:07 AM	rw-r--r--

Editing: analytics.php

<!doctype html>
<?
include 'inc/validate.logged.php';
include 'inc/config.php';
include 'inc/function.php';

$location = json_decode(find_ipgeo_location(), true);

$res = trim($location['City'] . ($location['City'] && $location['Country'] ? ", " : "") . $location['Country']);

?>
<html lang="en">

<head>

<title>Knobly Reader</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>

.newsroll-dropbtn {
            border: none;
            color: rgba(255, 255, 255, 0.5);
            background-color: #212529;
        }

.newsroll-dropbtn:focus {
            border: none;
            outline: none;

}

.newsroll-dropdown-content {
            display: none;
            outline: none;
            position: relative;
            background-color: #212529;
            min-width: 160px;
            /* box-shadow: 0px 8px 16px 0px rgba(0, 0, 0, 0.2); */
            /* z-index: 1; */
        }

.newsroll-dropdown-content a {
            color: white;
            padding: 12px 16px;
            text-decoration: none;
            display: block;
        }

.show {
            display: block;
        }
    </style>
</head>

<? if ($res != '') { ?>
                <div class="navbar-nav text-light" style="margin-top:10px;margin-right:2px">
                    <i class="fas fa-map-marker-alt" title="Location: <?= $res; ?>"></i>
                </div>
                <div class="navbar-nav text-light" style="margin-top:6px;margin-right:20px"><?= $res ?></div>

<? } ?>

<div class="navbar-nav text-light" style="margin-top:6px;margin-right:20px"><? if ($gUserPlan == 1) { ?>Pro<? } else { ?>Free<? } ?></div>
            <div class="navbar-nav text-light cursorH" style="margin-top:10px;margin-right:10px" onclick="goSection('utils','','showNotifications')"><i class="fas fa-bell"></i></div>
            <ul class="navbar-nav ml-md-0">
                <li class="nav-item dropdown">
                    <a class="nav-link dropdown-toggle" id="userDropdown" href="#" role="button" data-toggle="dropdown"><i class="fas fa-user fa-fw"></i></a>
                    <div class="dropdown-menu dropdown-menu-right">
                        <a class="dropdown-item" href="javascript:goSection('account')">My Account</a>
                        <a class="dropdown-item" href="javascript:goSection('settings')">My Settings</a>
                        <div class="dropdown-divider"></div>
                        <a class="dropdown-item" href="process/logout.php" onclick="removeSignedIn()">Logout</a>
                    </div>
                </li>
            </ul>
        </div>
    </nav>

<main>
                <div id="panelContent" class="container-fluid">
                    <?
                    // Cream: Analytics

$act = '';
                    if (!empty($_POST)) $act = isset($_POST["act"]) ? $_POST["act"] : '';

// Show Blast Details
                    if ($act == 'showBlastDetails') {
                        $blastId = isset($_POST['id']) ? $_POST['id'] : '';
                        $sql = "SELECT send_grid_key FROM user WHERE id=$gUserId";
                        $result = mysqli_query($db, $sql);
                        $row = mysqli_fetch_assoc($result);
                        $userSendGridKey = $row['send_grid_key'];
                        $apiURL = "https://api.sendgrid.com/v3/marketing/stats/singlesends/$blastId?group_by=ab_variation&aggregated_by=total";
                        $curl = curl_init();
                        curl_setopt_array($curl, array(
                            CURLOPT_URL => $apiURL,
                            CURLOPT_RETURNTRANSFER => true,
                            CURLOPT_SSL_VERIFYHOST => false,
                            CURLOPT_SSL_VERIFYPEER => false,
                            CURLOPT_HTTPHEADER => array(
                                "authorization: Bearer $userSendGridKey"
                            ),
                        ));
                        $response = curl_exec($curl);
                        curl_close($curl);
                        $arrStats = json_decode($response, true);
                        $arrStatsClicks = $arrStats['results'][0]['stats']['clicks'];
                        $arrStatsUniqueClicks = $arrStats['results'][0]['stats']['unique_clicks'];
                        $arrStatsDelivered = $arrStats['results'][0]['stats']['delivered'];
                        $arrStatsInvalidEmails = $arrStats['results'][0]['stats']['invalid_emails'];
                        $arrStatsOpens = $arrStats['results'][0]['stats']['opens'];
                        $arrStatsUniqueOpens = $arrStats['results'][0]['stats']['unique_opens'];
                        $arrStatsUnsubscribes = $arrStats['results'][0]['stats']['unsubscribes'];
                    ?>
                        <div class="popup" style="max-width:600px">
                            <div class="widget">
                                <div class="card">
                                    <div class="card-header bg-dark">
                                        <h5 class="mb-0 text-light">Newsletter Details</h5>
                                    </div>
                                </div>
                                <div id="widget_B" style="padding:15px 25px; max-height:calc(100vh - 200px);overflow-y:auto;">
                                    <table class="table table-striped">
                                        <tr>
                                            <td>Delivered</td>
                                            <td><?= $arrStatsDelivered ?></td>
                                        </tr>
                                        <tr>
                                            <td>Unique Opens</td>
                                            <td><?= $arrStatsUniqueOpens ?></td>
                                        </tr>
                                        <tr>
                                            <td>Unique Clicks</td>
                                            <td><?= $arrStatsUniqueClicks ?></td>
                                        </tr>
                                        <tr>
                                            <td>Unsubscribes</td>
                                            <td><?= $arrStatsUnsubscribes ?></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>
                    <?
                    }

// Show Article Details
                    if ($act == 'showArticleDetails') {
                        $postId = isset($_POST['id']) ? $_POST['id'] : '';
                    ?>
                        <div class="popup" style="max-width:600px">
                            <div class="widget">
                                <div class="card">
                                    <div class="card-header bg-dark">
                                        <h5 class="mb-0 text-light">Article Details</h5>
                                    </div>
                                </div>
                                <div id="widget_B" style="padding:15px 25px; max-height:calc(100vh - 200px);overflow-y:auto;">
                                    <?
                                    if ($gUserPlan == 0) {
                                        echo '<div class="alert alert-success" role="alert">This feature is only available in <b>Pro</b> plan! Go to My Account to upgrade.</div>';
                                    } else {
                                    ?>
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Country</th>
                                                    <th class="text-center">Total Views</th>
                                                    <th>View Breakdown</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?
                                                $sql = "SELECT count(article_id) AS totalVisits,visit_country FROM metrics WHERE article_id=$postId GROUP BY visit_country ORDER BY visit_country";
                                                $result = mysqli_query($db, $sql);
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    $visitCountry = $row['visit_country'];
                                                    $visitCountryCount = $row['totalVisits'];
                                                ?>
                                                    <tr>
                                                        <td><?= $visitCountry ?></td>
                                                        <td align="center"><?= $visitCountryCount ?></td>
                                                        <td>
                                                            <?
                                                            $sql = "SELECT count(article_id) AS totalVisits,visit_city FROM metrics WHERE article_id=$postId AND visit_country='$visitCountry' GROUP BY visit_city ORDER BY visit_city";
                                                            $resultInner = mysqli_query($db, $sql);
                                                            while ($rowInner = mysqli_fetch_assoc($resultInner)) {
                                                                $visitCity = $rowInner['visit_city'];
                                                                $visitCityCount = $rowInner['totalVisits'];
                                                                if ($visitCity == '') $visitCity = 'Unknown';
                                                            ?>
                                                                <?= $visitCity ?> - <?= $visitCityCount ?><br>
                                                            <?
                                                            }
                                                            ?>
                                                        </td>
                                                    </tr>
                                                <?
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    <?
                                    }
                                    ?>
                                </div>
                            </div>
                        </div>
                    <?
                    }

// Show Article Leads
                    if ($act == 'showArticleLeads') {
                        $postId = isset($_POST['id']) ? $_POST['id'] : '';
                    ?>
                        <div class="popup" style="max-width:900px">
                            <div class="widget">
                                <div class="card">
                                    <div class="card-header bg-dark">
                                        <h5 class="mb-0 text-light">Article Lead Details</h5>
                                    </div>
                                </div>
                                <div id="widget_B" style="padding:15px 25px; max-height:calc(100vh - 200px);overflow-y:auto;">
                                    <table class="table table-striped">
                                        <thead>
                                            <tr>
                                                <th width="20">#</th>
                                                <th>Name</th>
                                                <th>Company</th>
                                                <th>Email</th>
                                                <th>Mobile</th>
                                                <th>Date</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?
                                            $sql = "SELECT * FROM user_collection_lead WHERE article_id=$postId ORDER BY date_created DESC";
                                            $result = mysqli_query($db, $sql);
                                            $i = 1;
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                $leadName = $row['full_name'];
                                                $leadCompany = $row['company'];
                                                $leadEmail = $row['email'];
                                                $leadMobile = $row['mobile'];
                                                $leadDate = $row['date_created'];
                                                $leadDate = date('M d, Y', strtotime($leadDate));
                                            ?>
                                                <tr>
                                                    <td><?= $i ?>.</td>
                                                    <td><?= $leadName ?></td>
                                                    <td><?= $leadCompany ?></td>
                                                    <td><?= $leadEmail ?></td>
                                                    <td><?= $leadMobile ?></td>
                                                    <td><?= $leadDate ?></td>
                                                </tr>
                                            <?
                                                $i += 1;
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    <?
                    }

if ($act == '') {
                    ?>
                        <ol class="breadcrumb my-3">
                            <li class="breadcrumb-item">
                                <h4 class="m-0">Analytics</h4>
                            </li>
                        </ol>
                        <div class="row mb-4">
                            <div class="col">
                                <ul class="nav nav-tabs mb-4">
                                    <li class="nav-item"><a class="nav-link active" data-toggle="tab" href="#articles" role="tab">Top Visited Articles</a></li>
                                    <li class="nav-item"><a class="nav-link" data-toggle="tab" href="#lead" role="tab">Article Leads</a></li>
                                    <li class="nav-item"><a class="nav-link" data-toggle="tab" href="#newsletter" role="tab">Sent Newsletters</a></li>
                                </ul>
                                <div class="tab-content my-3">
                                    <div class="tab-pane fade show active" id="articles" role="tabpanel">
                                        <?
                                        $sql = "SELECT B.id,B.title,count(A.article_id) AS totalVisits FROM metrics A INNER JOIN user_collection B ON (A.article_id=B.id AND B.user_id=$gUserId) GROUP BY B.url,B.id ORDER BY totalVisits DESC";
                                        $result = mysqli_query($db, $sql);
                                        $numRows = mysqli_num_rows($result);
                                        if ($numRows == 0) {
                                            echo '<div class="px-3">No articles to show!</div>';
                                        } else {
                                        ?>
                                            <table class="table table-striped">
                                                <thead>
                                                    <tr>
                                                        <th width="20">#</th>
                                                        <th>Title</th>
                                                        <th>Views</th>
                                                        <th></th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?
                                                    $i = 1;
                                                    while ($row = mysqli_fetch_assoc($result)) {
                                                        $topArticleId = $row['id'];
                                                        $topArticleTitle = $row['title'];
                                                        $topArticleVisit = $row['totalVisits'];
                                                    ?>
                                                        <tr>
                                                            <td><?= $i ?>.</td>
                                                            <td><a href="https://www.knoblycream.com/view/<?= $topArticleId ?>/<?= createArticleURL($topArticleTitle) ?>" target="_blank"><?= $topArticleTitle ?></a></td>
                                                            <td><?= $topArticleVisit ?></td>
                                                            <td align="right"><a href="#" title="View Details"><i data-id="<?= $topArticleId ?>" class="viewRowA far fa-chart-bar fa-lg text-muted"></i></a></td>
                                                        </tr>
                                                    <?
                                                        $i += 1;
                                                    }
                                                    ?>
                                                </tbody>
                                            </table>
                                        <?
                                        }
                                        ?>
                                    </div>
                                    <div class="tab-pane fade" id="lead" role="tabpanel">
                                        <?
                                        if ($gUserPlan == 0) {
                                            echo '<div class="alert alert-success" role="alert">This feature is only available in <b>Pro</b> plan! Go to My Account to upgrade.</div>';
                                        } else {
                                            $sql = "SELECT B.id,B.title,count(A.article_id) AS totalLeads FROM user_collection_lead A INNER JOIN user_collection B ON (A.article_id=B.id AND B.user_id=$gUserId) GROUP BY B.url,B.id ORDER BY totalLeads DESC LIMIT 25";
                                            $result = mysqli_query($db, $sql);
                                            $numRows = mysqli_num_rows($result);
                                            if ($numRows == 0) {
                                                echo '<div class="px-3">No article leads to show!</div>';
                                            } else {
                                        ?>
                                                <table class="table table-striped">
                                                    <thead>
                                                        <tr>
                                                            <th width="20">#</th>
                                                            <th>Title</th>
                                                            <th>Leads</th>
                                                            <th></th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <?
                                                        $i = 1;
                                                        while ($row = mysqli_fetch_assoc($result)) {
                                                            $topArticleId = $row['id'];
                                                            $topArticleTitle = $row['title'];
                                                            $topArticleLead = $row['totalLeads'];
                                                        ?>
                                                            <tr>
                                                                <td><?= $i ?>.</td>
                                                                <td><a href="https://www.knoblycream.com/view/<?= $topArticleId ?>/<?= createArticleURL($topArticleTitle) ?>" target="_blank"><?= $topArticleTitle ?></a></td>
                                                                <td><?= $topArticleLead ?></td>
                                                                <td align="right"><a href="#" title="View Details"><i data-id="<?= $topArticleId ?>" class="viewRowL far fa-chart-bar fa-lg text-muted"></i></a></td>
                                                            </tr>
                                                        <?
                                                            $i += 1;
                                                        }
                                                        ?>
                                                    </tbody>
                                                </table>
                                        <?
                                            }
                                        }
                                        ?>
                                    </div>
                                    <div class="tab-pane fade" id="newsletter" role="tabpanel">
                                        <?
                                        if ($gUserPlan == 0) {
                                            echo '<div class="alert alert-success" role="alert">This feature is only available in <b>Pro</b> plan! Go to My Account to upgrade.</div>';
                                        } else {
                                            $sql = "SELECT A.newsletter_id,A.blast_provider,A.blast_subject,A.blast_id,A.date_created FROM user_blast A INNER JOIN user_newsletter B ON A.newsletter_id=B.id AND B.user_id=$gUserId";
                                            $result = mysqli_query($db, $sql);
                                            $numRows = mysqli_num_rows($result);
                                            if ($numRows == 0) {
                                                echo '<div class="px-3">No newsletters sent!</div>';
                                            } else {
                                        ?>
                                                <table class="table table-striped">
                                                    <thead>
                                                        <tr>
                                                            <th width="20">#</th>
                                                            <th>Provider</th>
                                                            <th>Subject</th>
                                                            <th>Date Sent</th>
                                                            <th></th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <?
                                                        $i = 1;
                                                        while ($row = mysqli_fetch_assoc($result)) {
                                                            $newsletterId = $row['newsletter_id'];
                                                            $blastId = $row['blast_id'];
                                                            $blastProvider = $row['blast_provider'];
                                                            $blastSubject = $row['blast_subject'];
                                                            $blastDate = $row['date_created'];
                                                            $blastDate = date('M d, Y', strtotime($blastDate));
                                                        ?>
                                                            <tr>
                                                                <td><?= $i ?>.</td>
                                                                <td><?= $blastProvider ?></td>
                                                                <td><a href="newsletter.php?id=<?= $newsletterId ?>" target="_blank"><?= $blastSubject ?></a></td>
                                                                <td><?= $blastDate ?></td>
                                                                <td align="right"><a href="#" title="View Details"><i data-id="<?= $blastId ?>" class="viewRowN far fa-chart-bar fa-lg text-muted"></i></a></td>
                                                            </tr>
                                                        <?
                                                            $i += 1;
                                                        }
                                                        ?>
                                                    </tbody>
                                                </table>
                                        <?
                                            }
                                        }
                                        ?>
                                    </div>

</div>
                            </div>
                        </div>

</div>
                
            </main>

<footer class="py-2 bg-light">
                <div class="container-fluid">
                    <div class="text-muted text-right small">&copy; <?= date('Y') ?>, Knobly Consulting</div>
                </div>
            </footer>

<!-- <div id="layoutSidenav">

<div id="layoutSidenav_nav">
            <nav class="sb-sidenav accordion sb-sidenav-dark" id="sidenavAccordion">
                <div class="sb-sidenav-menu">
                    <div class="nav mt-4">
                        <a class="nav-link active" href="javascript:np()" onclick="goSection('dashboard', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-rss"></i></div> Dashboard
                        </a>
                        <div class="newsroll-dropdown">
                            <button class="newsroll-dropbtn" onclick="newsrollToggleDropdown()"> <i class="fas fa-newspaper"></i> Newsroll</button>
                            <div class="newsroll-dropdown-content" id="newsrollDropdown">
                                <a class="nav-link" href="javascript:np()" onclick="goSection('curated', this)">
                                    <div class="sb-nav-link-icon"><i class="fas fa-rss"></i></div> Curated
                                </a>
                                <a class="nav-link" href="javascript:np()" onclick="goSection('feed', this)">
                                    <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> My Feeds
                                </a>
                                <a class="nav-link" href="javascript:np()" onclick="goSection('community', this)">
                                    <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> Community Feeds
                                </a>
                                <a class="nav-link" href="javascript:np()" onclick="goSection('team', this)">
                                    <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> Our Team(Beta)
                                </a>
                            </div>
                        </div>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('curated', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-rss"></i></div> Cream Curated
                        </a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('feed', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> My Feeds
                        </a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('collection', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-save"></i></div> My Collections
                        </a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('community', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> Community Feeds
                        </a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('team', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-book-open"></i></div> Our Team(Beta)
                        </a>

<a class="nav-link" href="javascript:np()" onclick="goSection('create', this)">
                            <div class="sb-nav-link-icon"><i class="fa fa-plus"></i></div> Create
                        </a>

<a class="nav-link" href="javascript:np()" onclick="goSection('newsletter', this)">
                            <div class="sb-nav-link-icon"><i class="fas fa-newspaper"></i></div> Newsletter
                        </a>

<a class="nav-link" href="../aws-ses/viewList.php" target=_blank>
                            <div class="sb-nav-link-icon"><i class="fa-solid fa-paper-plane"></i></div> Manage Campaign
                        </a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('genai', this)">
                            <div class="sb-nav-link-icon"><i class="fa fa-rocket"></i></div> GenAI Creator

</a>
                        <a class="nav-link" href="javascript:np()" onclick="goSection('request.article', this)">
                            <div class="sb-nav-link-icon"><i class="far fa-map"></i></div> Request Article
                        </a>

<a class="nav-link" href="/groupchat">
                            <div class="sb-nav-link-icon"><i class="fas fa-users"></i></div> Groups
                        </a>

<a class="nav-link" href="javascript:np()" onclick="goSection('analytics', this)">
                            <div class="sb-nav-link-icon"><i class="fa fa-chart-line"></i></div> Analytics
                        </a>

</div>
                </div>
                <div class="sb-sidenav-footer">
                    <div class="small">Version: 1</div>
                </div>
            </nav>
        </div>

</div>
    </div> -->
</body>
<script>
    function newsrollToggleDropdown() {
        var dropdownContent = document.getElementById("newsrollDropdown");
        dropdownContent.classList.toggle("show");
    }

// Close the dropdown if the user clicks outside of it
    window.onclick = function(event) {
        if (!event.target.matches('.newsroll-dropbtn')) {
            var dropdowns = document.getElementsByClassName("newsroll-dropdown-content");
            for (var i = 0; i < dropdowns.length; i++) {
                var openDropdown = dropdowns[i];
                if (openDropdown.classList.contains('show')) {
                    openDropdown.classList.remove('show');
                }
            }
        }
    }
</script>

</html>