OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📄 _get.section.collection.php	58.55 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 _get.section.create.php	21.82 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 _get.section.general.php	8.06 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 b.get.section.newsletter.php	18.36 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 bbget.section.curated.php	33.74 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 bget.section.newsletter.php	18.39 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 bget.section.request.article.php	6.04 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 chk.logged.in.php	1.16 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 chk.login.php	1.31 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 d_get.section.collection.php	57.93 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 d_get.section.create.php	21.87 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 fget.section.curated.php	17.04 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 fget.section.settings.php	33.55 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.account.php	8.55 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.analytics.php	11.45 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.collection copy.php	67.57 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.collection.php	69.19 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.community.php	7.7 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.create.php	22.41 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.curated.php	33.74 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.dashboard.php	3.31 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.feed.php	6.87 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.genai.php	9.84 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.genaicreative.php	10.52 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.general.php	2.28 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.newsletter.php	18.94 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.request.article - Copy.php	5.82 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.request.article.php	16.31 KB	03/26/2025 03:48:10 AM	rw-r--r--
📄 get.section.settings.php	41.71 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 get.section.team.php	6.72 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 get.section.test.php	529 bytes	03/26/2025 03:48:11 AM	rw-r--r--
📄 get.section.utils.php	4.77 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 logout.php	428 bytes	03/26/2025 03:48:11 AM	rw-r--r--
📄 my-get.section.curated.php	18.56 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 old.get.section.genai.php	10.22 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 old1get.section.create.php	30.29 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 upload.php	2.4 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 z.get.section.feed.php	6.88 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 zget.section.newsletter.php	17.97 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 zget.section.settings.php	34.6 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 zzget.section.curated.php	13.95 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 zzget.section.genai.php	12.7 KB	03/26/2025 03:48:11 AM	rw-r--r--

Name

Size

Modified

Perms

📁 ..

03/31/2025 06:36:42 AM

rwxr-xr-x

📄 _get.section.collection.php

58.55 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 _get.section.create.php

21.82 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 _get.section.general.php

8.06 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 b.get.section.newsletter.php

18.36 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 bbget.section.curated.php

33.74 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 bget.section.newsletter.php

18.39 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 bget.section.request.article.php

6.04 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 chk.logged.in.php

1.16 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 chk.login.php

1.31 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 d_get.section.collection.php

57.93 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 d_get.section.create.php

21.87 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 fget.section.curated.php

17.04 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 fget.section.settings.php

33.55 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.account.php

8.55 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.analytics.php

11.45 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.collection copy.php

67.57 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.collection.php

69.19 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.community.php

7.7 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.create.php

22.41 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.curated.php

33.74 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.dashboard.php

3.31 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.feed.php

6.87 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.genai.php

9.84 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.genaicreative.php

10.52 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.general.php

2.28 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.newsletter.php

18.94 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.request.article - Copy.php

5.82 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.request.article.php

16.31 KB

03/26/2025 03:48:10 AM

rw-r--r--

📄 get.section.settings.php

41.71 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 get.section.team.php

6.72 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 get.section.test.php

529 bytes

03/26/2025 03:48:11 AM

rw-r--r--

📄 get.section.utils.php

4.77 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 logout.php

428 bytes

03/26/2025 03:48:11 AM

rw-r--r--

📄 my-get.section.curated.php

18.56 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 old.get.section.genai.php

10.22 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 old1get.section.create.php

30.29 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 sendgrid.php

3.62 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 upload.php

2.4 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 z.get.section.feed.php

6.88 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 zget.section.newsletter.php

17.97 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 zget.section.settings.php

34.6 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 zzget.section.curated.php

13.95 KB

03/26/2025 03:48:11 AM

rw-r--r--

📄 zzget.section.genai.php

12.7 KB

03/26/2025 03:48:11 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>
<?
}
?>