OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	02/18/2024 06:33:29 AM	rwxr-xr-x
📄 about.php	2.42 KB	02/08/2022 02:27:36 PM	rw-r--r--
📁 accjournal	-	12/26/2021 06:46:23 AM	rwxr-xr-x
📁 cms	-	02/06/2022 09:24:57 AM	rwxr-xr-x
📄 contact.php	1.6 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 contributors.php	3.21 KB	02/08/2022 02:27:36 PM	rw-r--r--
📁 data	-	07/17/2025 12:14:38 PM	rwxrwxrwx
📄 editor.desk.php	4.17 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 editorial.php	5.39 KB	07/15/2022 06:28:48 AM	rw-r--r--
📁 grfx	-	02/06/2022 09:24:57 AM	rwxr-xr-x
📁 inc	-	05/19/2022 07:20:39 AM	rwxr-xr-x
📄 index.php	1.29 KB	05/13/2022 10:55:12 AM	rw-r--r--
📄 list.articles.php	4.28 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 list.authors.php	2.94 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 list.categories.php	2.45 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 list.volumes.php	3.6 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 puzzle.corner.php	987 bytes	02/08/2022 02:27:36 PM	rw-r--r--
📄 search.php	3.51 KB	05/20/2022 10:53:27 AM	rw-r--r--
📄 show.article.php	3.32 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 show.author.php	3.38 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 show.category.php	2.89 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 show.issue.php	3.87 KB	05/19/2022 06:18:04 AM	rw-r--r--
📄 show.topic.php	3.31 KB	05/20/2022 10:53:50 AM	rw-r--r--
📄 show.volume.php	2.65 KB	02/08/2022 02:27:36 PM	rw-r--r--
📄 z_editorial.php	4.01 KB	02/08/2022 02:27:36 PM	rw-r--r--

Editing: show.topic.php

<!DOCTYPE html>
<html>
<head>
<title>A Quarterly Publication of ACCS</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="inc/jquery-3.6.0.min.js"></script>
<script src="inc/bootstrap.min.js"></script>
<script src="inc/moment.min.js"></script>
<script src="inc/common.js"></script>
<link rel="stylesheet" type="text/css" href="inc/bootstrap.min.css" />
<link rel="stylesheet" type="text/css" href="inc/fontawesome/css/all.min.css" />
<link rel="stylesheet" type="text/css" href="inc/style.css" />
</head>
<body>
<? include 'inc/config.php' ?>
<? include 'inc/header.php' ?>

<?
 $type = isset($_GET["type"]) ? $_GET["type"] : '';
 if ($type == '') die();
?>

<div class="col-12 col-md-8">
   <div class="txtMedium txtBlue mb-2 py-2">Topic: <?=$type?></div>
<?
 $sql = "SELECT A.volume_num,A.issue_num,A.article_id,A.article_title,B.category_id,B.category_name,C.issue_date FROM ((articles A INNER JOIN categories B ON A.category_id=B.category_id) INNER JOIN issues C ON A.volume_num=C.volume_num AND A.issue_num=C.issue_num) WHERE (A.article_tag1='$type' OR A.article_tag2='$type' OR A.article_tag3='$type') AND A.is_active=1 ORDER BY A.volume_num DESC,A.issue_num DESC,A.article_title ASC";
 $result = mysqli_query($dbpro,$sql);
 $numRows = mysqli_num_rows($result);
 if ($numRows == 0) {
?>
  No articles could be found!
<?
 } else {
?>
   <ul style="padding-left:20px">
<?
  while ($row = $result->fetch_assoc()) {
   $articleId = $row['article_id'];
   $articleTitle = $row['article_title'];
   $articleCategoryId = $row['category_id'];
   $articleCategoryName = $row['category_name'];
   $articleVolumeNum = $row['volume_num'];
   $articleIssueNum = $row['issue_num'];
   $articleIssueNum = subStr('00' . $articleIssueNum, -2);
   $articleIssueDate = date("d F, Y", strtotime($row['issue_date']));
?>
    <li class="mt-3">
     <a href="show.article.php?id=<?=$articleId?>"><b><?=$articleTitle?></b></a><br>
     <a href="show.category.php?id=<?=$articleCategoryId?>"><span class="txtBlue"><?=$articleCategoryName?></span></a> | <a href="show.issue.php?volume=<?=$articleVolumeNum?>&issue=<?=$articleIssueNum?>">Volume <?=$articleVolumeNum?>, Issue <?=$articleIssueNum?></a> | <?=$articleIssueDate?><br>
<?
   $txtAuthor = '';
   $sql = "SELECT B.author_id,B.first_name,B.last_name FROM article_authors A INNER JOIN authors B ON A.author_id=B.author_id WHERE A.article_id=$articleId ORDER BY A.id";
   $resultAuthor = mysqli_query($dbpro,$sql);
   while ($rowAuthor = $resultAuthor->fetch_assoc()) {
    if (trim($rowAuthor['last_name'] == '')) {
     $txtAuthor .= '<a href="show.author.php?id=' . $rowAuthor['author_id'] . '">' . trim($rowAuthor['first_name']) . '</a>; ';
    } else {
     $txtAuthor .= '<a href="show.author.php?id=' . $rowAuthor['author_id'] . '">' . trim($rowAuthor['first_name']) . ' ' . trim($rowAuthor['last_name']) . '</a>, ';
    }
   }
   if ($txtAuthor <> '') {
    $txtAuthor = rtrim($txtAuthor, ', ');
    echo $txtAuthor;
   }
   echo "<br>";
?>
    </li>
<?
  }
?>
   </ul>
<?
 }
 mysqli_free_result($result);
?>
  </div>

</div>
</div>

<? include 'inc/footer.php' ?>
</body>
</html>