Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/udan.org.in/public_htmlbkp/webadmin

Free Space:

1.92 TB

🔧 Quick Actions

✏️ Editing: viewvideossg.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');
$heading = "Video";
$addpage = "addvideosg.php";
$listpage = "viewvideossg.php";
$table = "videos";
$pkey = "v_id";
$status = "status";
if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
	mysqli_query($con, "delete from `" . $table . "` where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$_SESSION['msg'] = "Entry is deleted successfully.";
	header("Location:" . $listpage);
	exit();
}
if (isset($_REQUEST['approve']) && $_REQUEST['approve'] == "yes") {
	$d = date("Y-m-d");
	mysqli_query($con, "update `" . $table . "` set `" . $status . "`='1' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$got = "go" . $_REQUEST['got'];
	$_SESSION['msg'] = $heading . " is approved successfully.";
	header("Location:" . $listpage . "?topic=" . $_REQUEST['topic'] . "#" . $got);
	exit();
}
if (isset($_REQUEST['reject']) && $_REQUEST['reject'] == "yes") {
	mysqli_query($con, "update `" . $table . "` set `" . $status . "`='0' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$got = "go" . $_REQUEST['got'];
	$_SESSION['msg'] = $heading . " is rejected successfully.";
	header("Location:" . $listpage . "?topic=" . $_REQUEST['topic'] . "#" . $got);
	exit();
}
if ($_GET['pg']) {
	$pg = $_GET['pg'];
} else {
	$pg = 1;
}
$upper = 25;
$lower = $upper * ($pg - 1);
$sql = "select * from `" . $table . "` where 1";
if (isset($_REQUEST['name']) && $_REQUEST['name'] != "") {
	$sql .= " and `name` like '%" . $_REQUEST['name'] . "%'";
}
$res = mysqli_query($con, $sql);
$num = mysqli_num_rows($res);
$pgno = intval($num / $upper);
if ($num % $upper != 0) {
	$pgno = $pgno + 1;
}
include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
	function del(page, id) {
		var fd = confirm("Are you sure to delete this entry?");
		if (fd == true) {
			location.href = page + "?id=" + id + "&delete=yes";
		}
	}

function approve(page, id, got, tpk) {
		location.href = page + "?id=" + id + "&got=" + got + "&approve=yes&topic=" + tpk;
	}

function reject(page, id, got) {
		location.href = page + "?id=" + id + "&got=" + got + "&reject=yes&topic=" + tpk;
	}
</script>

<body>
	
	
	<div id="preloader">
		<div class="loader"></div>
	</div>
	
	
	<div class="page-container">
		
		<?php include("includes/leftmenu.php"); ?>
		
		
		<div class="main-content">
			
			<?php include("includes/header.php"); ?>
			
			<div class="main-content-inner">
				
				<div> 
					<div class="col-lg-12 mt-4">
						<div class="card">
							<div class="card-body">
								<h4 class="header-title">List of <?php print $heading; ?>(s)</h4>
								<form action="#" method="post">
									<div class="form-group">
										
										<input class="form-control" type="text" name="topic" id="topic" value="<?php print $_REQUEST['topic']; ?>" placeholder="By Topic">
									</div>
									<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
								</form>
								<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
								<div class="cleaner h20"></div>
								<?php if ($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr'];
																						$_SESSION['msgerr'] = ""; ?></span>
									<div class="cleaner h10"></div><?php } ?>
								<?php if ($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg'];
																					$_SESSION['msg'] = ""; ?></span>
									<div class="cleaner h10"></div><?php } ?>
								<table class="table text-center">
									<thead class="text-uppercase bg-primary">
										<tr class="text-white">
											<td align="left">Sl.</td>
											<td align="left">Date</td>
											<td align="left">Course</td>
											<td align="left">Subject</td>
											<td align="left">Topic</td>
											<td align="left">Youtube Link</td>
											<td align="left">Added By</td>
											<td align="left">Options</td>
										</tr>
									</thead>
									<tbody>
										<?php
										if ($lower == 0) {
											$flag = 0;
										} else {
											$flag = $lower;
										}
										$sql = "select * from `" . $table . "` where `type`='lms'";
										if (isset($_REQUEST['topic']) && $_REQUEST['topic'] != "") {
											$sql .= " and `topic` like '%" . $_REQUEST['topic'] . "%'";
										}
										$sql .= " order by `" . $pkey . "` desc limit $lower,$upper";
										//print $sql;
										$res = mysqli_query($con, $sql);
										if (mysqli_num_rows($res) >= 1) {
											while ($row = mysqli_fetch_assoc($res)) {
												$rowc = mysqli_fetch_array(mysqli_query($con, "select * from `categories` where `id`='" . $row['course'] . "'"));
												$rows = mysqli_fetch_array(mysqli_query($con, "select * from `subjects` where `id`='" . $row['subject'] . "'"));
										?>
												<tr <?php if ($row[$status] == "0") { ?>class="bg-red" <?php } ?> id="go<?php print $flag++; ?>">
													<td align="left"><?php print $flag; ?></td>
													<td align="left"><?php print dtconvert($row['date']); ?></td>
													<td align="left"><?php print $rowc['name']; ?></td>
													<td align="left"><?php print $rows['name']; ?></td>
													<td align="left"><?php print $row['topic']; ?></td>
													<td align="left"><a href="<?php print $row['mainvideo']; ?>" target="_new"><?php print $row['mainvideo']; ?></a></td>

<td align="left">
														<?php
														// Fetch admin record for created_by ID
														$admin = mysqli_fetch_assoc(mysqli_query($con, "SELECT username, type, ref FROM `admin` WHERE id='" . $row['created_by'] . "'"));

if ($admin['type'] == "user") {
															// If admin type is 'user', fetch name from users table using ref
															$user = mysqli_fetch_assoc(mysqli_query($con, "SELECT name FROM `users` WHERE id='" . $admin['ref'] . "'"));
															echo htmlspecialchars($user['name']);
														} else {
															// Otherwise, just show admin username
															echo htmlspecialchars($admin['username']);
														}
														?>
													</td>

<td align="left">
														<?php if ($_SESSION['logtype'] == "superadmin" || $_SESSION['logtype'] == "user") { ?>
															<a href="<?php print $addpage; ?>?eid=<?php print $row[$pkey]; ?>&action=Update&name=<?php print $_REQUEST['name']; ?>&flag=<?php print $flag; ?>">Edit</a>
															<?php if ($_SESSION['logtype'] == "superadmin") { ?>
																<br><a href="#" onClick="del('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>');return false;">Delete</a>
															<?php } ?>
															<?php if ($row[$status] == "1") { ?>
																<br><a href="#" onClick="reject('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['topic']; ?>');return false;">Deactivate</a>
															<?php } else { ?>
																<br><a href="#" class="redtxt" onClick="approve('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['topic']; ?>');return false;">Activate</a>
															<?php } ?>
														<?php } ?>
													</td>
												</tr>
											<?php }
										} else { ?>
											<tr>
												<td colspan="10">Sorry, nothing found.</td>
											</tr>
										<?php } ?>
									</tbody>
								</table>
								<?php if ($num >= 1) { ?>
									<div class="cleaner h20"></div>
									
									<?php include("includes/pagination.php"); ?>
									
								<?php } ?>
							</div>
						</div>
					</div>
				</div>
				
			</div>
		</div>
		
		<?php include("includes/footer.php"); ?>
	</div>
	
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewvideossg.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation