OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/11/2024 12:41:09 PM	rwxr-xr-x
📄 _get.section.collection.php	58.55 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 _get.section.create.php	21.82 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 _get.section.general.php	8.06 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 autoload.php	771 bytes	08/14/2024 10:50:08 AM	rw-r--r--
📁 aws	-	08/14/2024 10:50:12 AM	rwxr-xr-x
📁 bin	-	08/14/2024 10:50:10 AM	rwxr-xr-x
📄 bounceViewList.php	5.86 KB	08/14/2024 11:08:43 AM	rw-r--r--
📄 chk.logged.in.php	1.16 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 chk.login.php	1.31 KB	08/14/2024 10:50:08 AM	rw-r--r--
📁 composer	-	08/14/2024 10:50:11 AM	rwxr-xr-x
📄 d_get.section.collection.php	57.93 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 d_get.section.create.php	21.87 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.account.php	8.47 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.analytics.php	11.46 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.collection.php	58.52 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.community.php	5.89 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.create.php	22.41 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.curated.php	5.07 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.dashboard.php	3.31 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.feed.php	6.87 KB	08/14/2024 10:50:08 AM	rw-r--r--
📄 get.section.general.php	9.31 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 get.section.newsletter.php	9.25 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 get.section.request.article.php	5.82 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 get.section.settings.php	21.15 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 get.section.team.php	6.73 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 get.section.utils.php	4.1 KB	08/14/2024 10:50:09 AM	rw-r--r--
📁 guzzlehttp	-	08/14/2024 10:50:14 AM	rwxr-xr-x
📄 logout.php	428 bytes	08/14/2024 10:50:09 AM	rw-r--r--
📁 mtdowling	-	08/14/2024 10:50:15 AM	rwxr-xr-x
📁 phpmailer	-	08/14/2024 10:50:15 AM	rwxr-xr-x
📁 psr	-	08/14/2024 10:50:16 AM	rwxr-xr-x
📁 ralouphie	-	08/14/2024 10:50:16 AM	rwxr-xr-x
📄 sendgrid.php	3.62 KB	08/14/2024 10:50:09 AM	rw-r--r--
📁 symfony	-	08/14/2024 10:50:17 AM	rwxr-xr-x
📄 upload.php	2.4 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 verify.php	3.12 KB	08/14/2024 10:50:09 AM	rw-r--r--
📄 verify_email.php	7.13 KB	08/14/2024 10:50:09 AM	rw-r--r--
📁 wildbit	-	08/14/2024 10:50:17 AM	rwxr-xr-x
📄 z.get.section.feed.php	6.88 KB	08/14/2024 10:50:09 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>
<?
}
?>