OXIESEC PANEL

	Name	Size	Modified	Perms
	📁 ..	-	07/15/2022 06:28:55 AM	rwxr-xr-x
	📄 bootstrap.min.css	155.78 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 bootstrap.min.js	58.6 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 common.js	1.25 KB	05/20/2022 10:54:41 AM	rw-r--r--
	📄 config.php	7.64 KB	05/19/2022 07:20:38 AM	rw-r--r--
	📁 fontawesome	-	02/06/2022 09:24:57 AM	rwxr-xr-x
	📄 footer.php	2.24 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 header.php	4.75 KB	05/20/2022 12:31:00 PM	rw-r--r--
	📄 jquery-3.6.0.min.js	87.4 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 moment.min.js	52.07 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 side.php	1.4 KB	02/08/2022 02:27:35 PM	rw-r--r--
	📄 style.css	1.97 KB	05/20/2022 12:31:08 PM	rw-r--r--
	📄 track.download.php	1.31 KB	02/08/2022 02:27:35 PM	rw-r--r--

Editing: config.php

<?

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

ini_set('default_charset', 'UTF-8');
date_default_timezone_set("Asia/Kolkata");

$servername = "localhost";
$username = "root";
$dbname = "accsindia_journal";
//$password = "1234";
$password = "accsadmin";

$dbpro = new mysqli($servername, $username, $password, $dbname);
if ($dbpro ->connect_error) {
 die("Connection failed: " . $dbpro ->connect_error);
}
mysqli_query($dbpro, "SET NAMES utf8");
mysqli_query($dbpro, "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))");

function buildIssue($volumeNum, $issueNum, $layoutFirst, $borderBottom) {
 global $dbpro;
 $issueM = '';
 $issueY = '';
 $sql = "SELECT issue_date FROM issues WHERE volume_num=$volumeNum AND issue_num=$issueNum";
 $result = mysqli_query($dbpro,$sql);
 $numRows = mysqli_num_rows($result);
 if ($numRows > 0) {
  $row = $result->fetch_assoc();
  $issueDate = $row['issue_date'];
  $issueM = date('F', strtotime($issueDate));
  $issueY = date('Y', strtotime($issueDate));
 } 
 echo '<div class="container">';
 echo ' <span class="txtMed txtBlue">Volume ' . $volumeNum . ' Issue ' . $issueNum . ' - ' . $issueM . ' ' . $issueY . '</span><br>';
 echo ' <div class="row no-gutters">';
 $sql = "SELECT A.article_id,A.article_title,A.article_img,B.category_name FROM articles A LEFT JOIN categories B ON A.category_id=B.category_id WHERE A.volume_num=$volumeNum AND A.issue_num=$issueNum ORDER BY A.is_cover DESC";
 $result = mysqli_query($dbpro,$sql);
 $numRows = mysqli_num_rows($result);
 for ($i=0;$i<$numRows;$i++) {
  $row = $result->fetch_assoc();
  $articleCategory = $row['category_name'];
  $articleId = $row['article_id'];
  $articleTitle = $row['article_title'];
  $articleImgExt = $row['article_img'];
  $articleImg = "data/articles/$articleId.$articleImgExt";
  $txtAuthor = '';
  $sql = "SELECT first_name,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 .= trim($rowAuthor['first_name']) . ', ';
   } else {
    $txtAuthor .= trim($rowAuthor['first_name']) . ' ' . trim($rowAuthor['last_name']) . ', ';
   }
  }
  if ($txtAuthor <> '') $txtAuthor = rtrim($txtAuthor, ', ');
  if ($layoutFirst) {
   if ($i == 0) {
    echo '  <div class="col-12 col-md-6 px-1">';
    echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');height:400px;">';
    echo '    <div class="thumbText" style="bottom:10px">';
    echo '     <div class="mb-2 txtMedium text-left" style="line-height:1.15em"><a href="show.article.php?id=' . $articleId . '">' . $articleTitle . '</a></div>';
    echo '     <div class="txtWhite text-left">' . $txtAuthor . '</div>';
    echo '    </div>';
    echo '   </div>';
    echo '  </div>';
   } else if ($i == 1) {
    echo '  <div class="col-12 col-md-6 px-1">';
   }
   if ($i > 0) {
    if ($i > 2) {
     echo '  </div><div class="col-12 col-md-4 px-1 hello">';
    }
    echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');height:196px;">';
    echo '    <div class="thumbText" style="bottom:10px">';
    echo '     <div class="mb-2 txtMedium text-left" style="line-height:1.15em"><a href="show.article.php?id=' . $articleId . '">' . $articleTitle . '</a></div>';
    echo '     <div class="txtWhite text-left">' . $txtAuthor . '</div>';
    echo '    </div>';
    echo '   </div>';
    if ($i > 2) {
     echo '  </div>';
    }
   }
   if ($i == 2 && $numRows == 3) {
    echo '  </div></div>';
   } else if ($i == $numRows-1) {
    echo '  </div>';
   }
  } else {
   echo '  <div class="col-12 col-md-4 px-1">';
   echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');">';
   echo '    <div class="thumbText" style="top:50%;transform: translateY(-33%);">';
   echo '     <div class="mb-2 txtMedium" style="line-height:1.15em"><a href="show.article.php?id=' . $articleId . '">' . $articleTitle . '</a></div>';
   echo '     <div class="txtWhite">' . $txtAuthor . '</div>';
   echo '    </div>';
   echo '   </div>';
   echo '  </div>';
  }
 }
 if ($layoutFirst <> 1) echo ' </div>';
 if ($borderBottom) echo ' <hr style="position:relative;border:none;height:1px;background-color:#d0d0d0;">';
 echo '</div>';
}

function buildIssue_old($volumeNum, $issueNum, $layoutFirst, $borderBottom) {
 global $dbpro;
 echo '<div class="container">';
 echo ' <span class="txtMed txtBlue">Volume ' . $volumeNum . ' Issue ' . $issueNum . '</span><br>';
 echo ' <div class="row no-gutters">';
 $sql = "SELECT A.article_id,A.article_title,A.article_img,B.category_name FROM articles A LEFT JOIN categories B ON A.category_id=B.category_id WHERE A.volume_num=$volumeNum AND A.issue_num=$issueNum";
 $result = mysqli_query($dbpro,$sql);
 $numRows = mysqli_num_rows($result);
 for ($i=0;$i<$numRows;$i++) {
  $row = $result->fetch_assoc();
  $articleCategory = $row['category_name'];
  $articleId = $row['article_id'];
  $articleTitle = $row['article_title'];
  $articleImgExt = $row['article_img'];
  $articleImg = "data/articles/$articleId.$articleImgExt";
  if ($layoutFirst && $i == 0) {
   echo '  <div class="col-12 col-md-6 px-1">';
   echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');height:400px;">';
  } else {
   if ($layoutFirst) {
    if ($i == 1) {
     echo '  <div class="col-12 col-md-6 px-1">';
    }
   } else {
    echo '  <div class="col-12 col-md-4 px-1">';
   }
   if ($layoutFirst) {
    echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');height:196px;">';
   } else {
    echo '   <div class="thumbImg mt-2" style="background:linear-gradient(rgba(0,0,0,.35), rgba(0,0,0,.35)), url(' . $articleImg . ');">';
   }
  }
  if ($layoutFirst) {
   echo '    <div class="thumbText" style="bottom:10px">';
   echo '     <div class="mb-2 txtMedium text-left" style="line-height:1.15em"><a href="show.article.php?id=' . $articleId . '">' . $articleTitle . '</a></div>';
   echo '     <div class="txtWhite text-left">';
  } else {
   echo '    <div class="thumbText" style="top:50%;transform: translateY(-33%);">';
   echo '     <div class="mb-2 txtMedium" style="line-height:1.15em"><a href="show.article.php?id=' . $articleId . '">' . $articleTitle . '</a></div>';
   echo '     <div class="txtWhite">';
  }
  $txtAuthor = '';
  $sql = "SELECT first_name,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 .= trim($rowAuthor['first_name']) . ', ';
   } else {
    $txtAuthor .= trim($rowAuthor['first_name']) . ' ' . trim($rowAuthor['last_name']) . ', ';
   }
  }
  if ($txtAuthor <> '') $txtAuthor = rtrim($txtAuthor, ', ');
  echo $txtAuthor;
  echo '     </div>';
  echo '    </div>';
  if ($layoutFirst) {
   if ($i == 0 || $i == $numRows-1) {
    echo '   </div>';
   }
  } else {
   echo '   </div>';
  }
  echo '  </div>';
 }
 echo ' </div>';
 if ($borderBottom) echo ' <hr style="position:relative;border:none;height:1px;background-color:#d0d0d0;">';
 echo '</div>';
}