OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 chk.logged.in.php	1.16 KB	01/10/2021 12:30:27 PM	rw-r--r--
📄 chk.login.php	1.31 KB	02/10/2022 03:03:00 PM	rw-r--r--
📄 get.section.account.php	15.11 KB	12/28/2024 08:09:41 AM	rw-r--r--
📄 get.section.analytics.php	28.73 KB	03/02/2025 09:40:12 AM	rw-r--r--
📄 get.section.collection.php	69.19 KB	03/04/2025 05:15:01 AM	rw-r--r--
📄 get.section.community.php	7.71 KB	09/09/2024 09:46:26 AM	rw-r--r--
📄 get.section.create.php	22.41 KB	05/22/2024 11:08:28 AM	rw-r--r--
📄 get.section.curated.php	33.87 KB	03/02/2025 10:52:06 AM	rw-r--r--
📄 get.section.dashboard.php	3.31 KB	02/10/2022 02:58:26 PM	rw-r--r--
📄 get.section.feed.php	6.87 KB	03/09/2023 05:28:34 AM	rw-r--r--
📄 get.section.genai.php	9.87 KB	08/21/2024 07:23:47 AM	rw-r--r--
📄 get.section.genaicreative.php	10.55 KB	08/21/2024 07:23:45 AM	rw-r--r--
📄 get.section.general.php	9.31 KB	08/22/2023 09:34:25 AM	rw-r--r--
📄 get.section.newsletter.php	18.97 KB	08/22/2024 06:42:01 AM	rw-r--r--
📄 get.section.request.article.php	13.34 KB	03/02/2025 06:07:24 AM	rw-r--r--
📄 get.section.settings.php	42.64 KB	03/02/2025 10:13:44 AM	rw-r--r--
📄 get.section.team.php	6.73 KB	05/23/2024 04:45:44 AM	rw-r--r--
📄 get.section.utils.php	4.1 KB	06/26/2021 06:06:51 AM	rw-r--r--
📄 logout.php	428 bytes	08/16/2020 11:22:29 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	03/09/2021 04:01:36 AM	rw-r--r--
📄 upload.php	2.4 KB	08/22/2020 01:33:43 PM	rw-r--r--
📄 zget.section.analytics.php	11.45 KB	03/02/2025 06:25:31 AM	rw-r--r--

Editing: get.section.dashboard.php

<?
// Cream: Dashboard

require_once '../inc/validate.logged.php';
require_once '../inc/config.php';

$act = '';

// Default
if ($act == '') {
 $sql = "SELECT COUNT(id) AS countArticle FROM user_collection WHERE user_id=$gUserId";
 $result = mysqli_query($db, $sql);
 $row = mysqli_fetch_assoc($result);
 $countArticle = $row['countArticle'];

$sql = "SELECT COUNT(user_id) AS countFeed FROM user_feeds WHERE user_id=$gUserId";
 $result = mysqli_query($db, $sql);
 $row = mysqli_fetch_assoc($result);
 $countFeed = $row['countFeed'];

$sql = "SELECT COUNT(user_id) AS countNewsletter FROM user_newsletter WHERE user_id=$gUserId";
 $result = mysqli_query($db, $sql);
 $row = mysqli_fetch_assoc($result);
 $countNewsletter = $row['countNewsletter'];

$sql = "SELECT COUNT(A.article_id) AS countVisit FROM metrics A INNER JOIN user_collection B ON A.article_id=B.id AND B.user_id=$gUserId";
 $result = mysqli_query($db, $sql);
 $row = mysqli_fetch_assoc($result);
 $countVisit = $row['countVisit'];
?>
<ol class="breadcrumb my-3">
 <li class="breadcrumb-item"><h4 class="m-0">Dashboard</h4></li>
</ol>
<div class="row">
 <div class="col-12 col-md-6 col-xl-3">
  <div class="card bg-primary text-white mb-4">
   <div class="card-body">Articles</div>
   <div class="card-footer text-right"><h3><?=$countArticle?></h3></div>
  </div>
 </div>
 <div class="col-12 col-md-6 col-xl-3">
  <div class="card bg-success text-white mb-4">
   <div class="card-body">Feeds</div>
   <div class="card-footer text-right"><h3><?=$countFeed?></h3></div>
  </div>
 </div>
 <div class="col-12 col-md-6 col-xl-3">
  <div class="card bg-warning text-white mb-4">
   <div class="card-body">Newsletter</div>
   <div class="card-footer text-right"><h3><?=$countNewsletter?></h3></div>
  </div>
 </div>
 <div class="col-12 col-md-6 col-xl-3">
  <div class="card bg-danger text-white mb-4">
   <div class="card-body">Visits</div>
   <div class="card-footer text-right"><h3><?=$countVisit?></h3></div>
  </div>
 </div>
</div>
<ol class="breadcrumb my-3">
 <li class="breadcrumb-item"><h4 class="m-0">Top 5 Visited Articles</h4></li>
</ol>
<?
 $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 LIMIT 5";
 $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>
<?
 }
?>
<script type="text/javascript">
$(function() {
});
</script>
<?
}
?>