OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📁 grfx	-	04/29/2021 04:36:04 PM	rwxr-xr-x
📄 index.php	3.89 KB	05/02/2021 07:04:38 AM	rw-r--r--

Editing: index.php

<!doctype html>
<html lang="en">
<head>
<title>Knobly Cream: Create &bull; Reach &bull; Measure</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous" />
<link rel="stylesheet" href="../inc/fontawesome/css/all.min.css" />
<link rel="stylesheet" href="../inc/style.css" />
<style>
body {
	background-color: #f0f2f5;
}

.boxItem {
	padding: 20px;
	margin-top: 20px;
	border-radius: 8px;
	box-shadow: 0 1px 2px rgba(0, 0, 0, 0.2);
	background-color: #fff;
}

img {
	max-width: 100%;
}
</style>
</head>
<body>
<? include '../inc/config.php'; ?>

<div style="max-width:950px;margin:0 auto;">
 <div class="row mx-3 mx-lg-0" style="border-bottom:10px #ffc107 solid">
  <div class="col-12 col-lg-6"><div style="font-family:'Crimson Text';font-size:50px;">Beat the Pandemic</div></div>
  <div class="col-12 col-lg-6 text-lg-right pt-lg-4 pb-3 pb-lg-0"><div style="font-size:18px;"><i>Info center curated by medical professionals</i></div></div>
 </div>
<?
 $sql = "SELECT * FROM user_covid ORDER BY date_created DESC";
 $result = mysqli_query($db, $sql);
 while($row = mysqli_fetch_assoc($result)) {
  $userId = $row['user_id'];
  $articleId = $row['article_id'];
  $articleDate = $row['date_created'];

$sql = "SELECT full_name FROM user WHERE id=$userId";
  $resultInner = mysqli_query($db, $sql);
  $rowInner = mysqli_fetch_assoc($resultInner);
  $articleAuthor = $rowInner['full_name'];

$sql = "SELECT * FROM user_collection WHERE id=$articleId";
  $resultInner = mysqli_query($db, $sql);
  $numRowsInner = mysqli_num_rows($resultInner);
  if ($numRowsInner > 0) {
   $rowInner = mysqli_fetch_assoc($resultInner);
   $artId = $rowInner['id'];
   $artTitle = $rowInner['title'];
   $artURL = 'https://www.knoblycream.com/view/' . $artId . '/' . createArticleURL($artTitle);
   $artDesc = $rowInner['description'];
   $artDesc = str_replace('<img src="data/posts/', '<img src="https://www.knoblycream.com/data/posts/', $artDesc);
   $artCoverImg = $rowInner['cover_img'];

$collectionURL = $rowInner['url'];
   $collectionPublisher = substr($collectionURL, strpos($collectionURL, ".") + 1);
   $collectionPublisher = ucfirst(strtok($collectionPublisher, '.'));
   if ($collectionPublisher == '') $collectionPublisher = 'Cream';
?>
 <div class="row mx-3 mx-lg-0">
  <div class="col-12 boxItem">
<?
   if ($artCoverImg <> '') {
?>
   <div style="padding-bottom:10px"><a href="<?=$artURL?>" target="_blank"><img src="https://www.knoblycream.com/data/covers/<?=$artCoverImg?>" style="max-width:650px" width="100%" /></a></div>
<?
   }
?>
   <div style="padding-bottom:10px;font-size:18px;"><a href="<?=$artURL?>" target="_blank"><strong><?=$artTitle?></strong></a></div>
   <span style="font-weight:400"><?=$artDesc?></span>
   <br clear="all">
   <div style="margin-top:10px;font-size:13px;color:#888;">
    <div style="float:left">Curated by: <?=$articleAuthor?></div>
    <div style="float:right">Publisher: <?=$collectionPublisher?></div>
    <br clear="all">
   </div>
  </div>
 </div>
<?
  }
 }
?>
 <div class="row mt-3 mx-3 mx-lg-0">
  <div class="col-12 col-lg-6">Powered by <a href="https://www.knoblycream.com/" target="_blank"><img src="../grfx/logo.png" width="100" align="middle" style="padding-bottom:10px"></a></div>
  <div class="col-12 col-lg-6 text-lg-right">Supported by <a href="https://www.yugenbharath.org/" target="_blank"><img src="grfx/logo.yb.png" height="20" align="middle" /></a> <a href="http://www.rangalakshminetralaya.com/" target="_blank"><img src="grfx/logo.ranga.png" height="40" align="middle" style="margin-left:10px;padding-bottom:10px;"></a></div>
 </div>
</div>

</body>
</html>