| Server IP : 162.0.232.25 / Your IP : 18.217.122.223 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/learn.skilltainment.org/ |
Upload File : |
<?php
include './php/connect.php';
include './php/core.php';
include './php/filterFile.php';
include './php/compress-image.php';
include './php/time.php';
$_SESSION['last_page']=$_SERVER['REQUEST_URI'];
//selecting user data
if(isset($_COOKIE['uid'])){
$user = $_COOKIE['uid'];
$query1 = "SELECT `firstname`,`surname`,`email`,`mobile`,`password`,`type` FROM `users` WHERE `uid`='$user'";
if ($run1 = mysqli_query($conn, $query1)) {
list($firstname, $surname, $email, $mobile, $password, $user_type) = mysqli_fetch_array($run1);
} else {
die(mysqli_error($conn));
}
}
if (isset($_GET['title'])) {
if (!empty($_GET['title'])) {
$title = mysqli_real_escape_string($conn, $_GET['title']);
$title = str_replace('-', ' ', $title);
$query = "SELECT `title`,`pid`,`image`,`details`,`time` FROM `playlists` WHERE `title`='$title'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
list($title, $pid, $image, $details, $time) = mysqli_fetch_array($run);
}
}
?>
<!DOCTYPE html>
<html lang="en" class="no-js">
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<head>
<meta charset="utf-8">
<title></title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="<?php echo $details; ?>" name="description">
<script type='text/javascript' src='//platform-api.sharethis.com/js/sharethis.js#property=5b67c4f0f3815e0011ed2735&product=inline-share-buttons' async='async'></script>
<!-- Favicon -->
<link href="img/favicon.html" rel="icon">
<!-- Google Web Fonts -->
<link rel="preconnect" href="https://fonts.googleapis.com/">
<link rel="preconnect" href="https://fonts.gstatic.com/" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@400;600&family=Roboto:wght@500;700&display=swap" rel="stylesheet">
<!-- Icon Font Stylesheet -->
<link href="../../cdn.jsdelivr.net/npm/bootstrap-icons%401.4.1/font/bootstrap-icons.css" rel="stylesheet">
<!-- Libraries Stylesheet -->
<link href="lib/owlcarousel/assets/owl.carousel.min.css" rel="stylesheet">
<link href="lib/tempusdominus/css/tempusdominus-bootstrap-4.min.css" rel="stylesheet" />
<!-- Custom Upload File Type -->
<link rel="stylesheet" href="./css/component.css">
<link rel="stylesheet" href="./css/normalize.css">
<!-- Sweet Alert -->
<script src="js/sweetalert.min.js"></script>
<!-- Customized Bootstrap Stylesheet -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Font Awesome -->
<link rel="stylesheet" href="./css/all.min.css">
<!-- Template Stylesheet -->
<link href="css/style.css" rel="stylesheet">
<!-- Media Player -->
<link rel="stylesheet" href="css/watch.css">
<!-- Icon -->
<link rel="icon" type="image/png" href="./img/logo.png">
<!-- Animate.css -->
<link rel="stylesheet" href="./css/aos.css">
<!-- remove this if you use Modernizr -->
<script>
(function(e, t, n) {
var r = e.querySelectorAll("html")[0];
r.className = r.className.replace(/(^|\s)no-js(\s|$)/, "$1js$2")
})(document, window, 0);
</script>
<noscript>
<style type="text/css">
[data-aos] {
opacity: 1 !important;
transform: translate(0) scale(1) !important;
}
</style>
</noscript>
<!--og codes-->
<meta property="og:url" content="https://learn.skilltainment.org/tutorial-list.php?title=<?php echo filter_file(strtolower($title)); ?>" />
<meta property="og:type" content="website" />
<meta property="og:title" content="<?php echo $title; ?>" />
<meta property="og:image" content="https://learn.skilltainment.org/playlists/img/<?php echo $image; ?>" />
<meta property="og:description" content="<?php echo $details; ?>" />
<meta property="fb:app_id" content="197362031139140" />
</head>
<body>
<div class="container-fluid position-relative d-flex p-0">
<!-- Sidebar Start -->
<div class="sidebar pe-4 pb-3 shadow-sm">
<nav class="navbar bg-secondary navbar-dark">
<a href="home" class="navbar-brand mx-4 mb-3">
<img src="./img/logo.png" alt="LOGO" class="logo"> <span class="text-primary h5">SKILLTAINMENT</span>
</a>
<?php
if (loggedin()) {
?>
<div class="d-flex align-items-center ms-4 mb-4">
<div class="position-relative">
<img class="rounded-circle" src="img/user.png" alt="" style="width: 40px; height: 40px;">
<div class="bg-success rounded-circle border border-2 border-white position-absolute end-0 bottom-0 p-1"></div>
</div>
<div class="ms-3">
<h6 class="mb-0"><?php echo "$firstname $surname"; ?></h6>
<span>
<?php
if ($user_type == 1) {
echo "Admin";
} else {
echo "User";
}
?>
</span>
</div>
</div>
<div class="navbar-nav w-100">
<a href="home" class="nav-item nav-link"><i class="fa fa-home me-2"></i>Home</a>
<?php
if ($user_type == 1) {
?>
<a href="a=playlists" class="nav-item nav-link"><i class="fa fa-video me-2"></i>Playlists</a>
<a href="a=mail" class="nav-item nav-link"><i class="fa fa-envelope me-2"></i>Send Mail</a>
<a href="users" class="nav-item nav-link"><i class="fa fa-users me-2"></i>Users</a>
<?php
}
?>
<a href="a=workshops" class="nav-item nav-link"><i class="fa fa-tasks me-2"></i>Workshops</a>
<a href="a=projects" class="nav-item nav-link"><i class="fa fa-project-diagram me-2"></i>Projects</a>
<a href="signout" class="nav-item nav-link"><i class="fa fa-sign-out-alt me-2"></i>Sign Out</a>
</div>
<?php
} else {
?>
<div class="navbar-nav w-100">
<a href="home" class="nav-item nav-link"><i class="fa fa-home me-2"></i>Home</a>
</div>
<?php
}
?>
</nav>
</div>
<!-- Sidebar End -->
<?php
include './navbar.php';
?>
<div class="container-fluid pt-4 px-4 tutorial-list">
<div class="row g-2">
<div class="col-12 col-sm-5 bg-secondary rounded-3" data-aos="fade-up" data-aos-duration="500">
<img src="./playlists/img/<?php echo $image; ?>" class="rounded-1">
<div class="h4 my-2 ml-1"><?php echo $title; ?></div>
<div class="d-flex justify-content-between mx-1 mb-1">
<?php
$num_vids = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM `videos` WHERE `pid`=$pid"));
?>
<div class="text-white">
<?php
if ($num_vids == 1) {
echo "$num_vids video";
} else {
echo "$num_vids videos";
}
?>
</div>
<div class="text-white"><?php echo date('M d, Y', $time); ?></div>
</div>
<p><?php echo $details; ?></p>
<!-- share button -->
<div class="sharethis-inline-share-buttons"></div>
</div>
<div class="col-12 col-sm-7">
<?php
$query2 = "SELECT `vid`,`video_title`,`views`,`video_time`,UNIX_TIMESTAMP() - `video_time` as time_spent FROM `videos` WHERE `pid`=$pid ORDER BY `vid` ASC";
$run2 = mysqli_query($conn, $query2) or die(mysqli_error($conn));
$count = 1;
while ($row = mysqli_fetch_array($run2)) {
?>
<div class="bg-secondary mb-2 rounded-3 shadow-2" data-aos="zoom-in" data-aos-duration="500">
<a href="watch=<?php echo $row['vid'] . '-' . filter_file(strtolower($row['video_title'])); ?>">
<div class="row">
<div class="col-1">
<div class="ps-2"><?php echo $count; ?></div>
</div>
<div class="col-4">
<img src="./playlists/img/<?php echo $image ?>">
</div>
<div class="col-7 pt-1">
<div class="title"><?php echo $row['video_title']; ?></div>
<div class="d-flex justify-content-between mt-2">
<div>
<i class="fa fa-eye"></i>
<?php
if ($row['views'] >= 1000000) {
echo round($row['views'] / 1000000, 1) . 'M';
} else if ($row['views'] >= 1000) {
echo round($row['views'] / 1000, 1) . 'K';
} else {
echo $row['views'];
}
?>
</div>
<div class="pe-3"><i class="fa fa-clock"></i> <?php echo timeSpent($row['time_spent']); ?></div>
</div>
</div>
</div>
</a>
</div>
<?php
++$count;
}
?>
</div>
</div>
</div>
<script>
document.querySelector("title").innerText = "<?php echo $title; ?>";
document.querySelectorAll(".navbar-nav a")[0].classList.add("active");
//slicing all playlists titles
var count = document.querySelectorAll(".tutorial-list .col-sm-7 .title").length;
for (var i = 0; i < count; i++) {
var title = document.querySelectorAll(".tutorial-list .col-sm-7 .title")[i].innerText;
var slicer = title.slice(0, 40);
if (title.length >= 40) {
document.querySelectorAll(".tutorial-list .col-sm-7 .title")[i].innerHTML = slicer + '...';
} else {
document.querySelectorAll(".tutorial-list .col-sm-7 .title")[i].innerHTML = slicer;
}
}
</script>
<?php
include './footer.php';
?>
<script type="text/javascript">
$readMoreJS.init({
target: '.tutorial-list .col-sm-5 p',
numOfWords: 30,
toggle: true,
moreLink: 'read more ...',
lessLink: 'read less'
});
</script>