Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/video/ |
<?php
if(!isset($_COOKIE['cookie_logged']) or $_COOKIE['cookie_logged']!=1){
header('Location: /login.php');
}
define('ROOT_PATH', dirname(__FILE__) . '/');
require "configs.php";
require "lib/class_info.php";
global $INFO;
$CORE = new info();
require "lib/class_functions.php";
$func = new FUNC;
$CORE->input = $func->get_input();
require "lib/class_display.php";
$print = new display();
require "lib/class_db.php";
$DB = new db_driver;
$DB->connect($INFO);
function tree_menu($parentid,$arr,$sep){
if(!is_null($arr)) {
foreach ($arr as $key => $v) {
if ($v['menus_parentid'] == $parentid) {
$arr[$key]['menus_name'] = $sep . ' ' . $arr[$key]['menus_name'];
$arr = tree_menu($v['menus_id'], $arr, $sep . " <i class=\"fa-thin fa-arrow-right-from-line\"></i> ");
}
}
}
return $arr;
}
function createPath($id, $category_tbl, $except = null) {
global $DB;
$s = "SELECT * FROM ".$category_tbl." WHERE menus_id = $id";
$row = $DB->fetch_row($DB->query($s));
if($row['menus_parentid'] == 0) {
$name = $row['menus_name'];
return "<i class=\"fa-thin fa-folder\"></i> <a href='manager.php'>Root</a> / <i class=\"fa-thin fa-folder\"></i> <a href='manager.php?menus_id=$id'>".$name."</a> ";
} else {
$name = $row['menus_name'];
if(!empty($except) && $except == $name) {
return createPath($row['menus_parentid'], $category_tbl, $except) . " / <i class=\"fa-thin fa-folder\"></i> " . $name.' ';
}
}
return createPath($row['menus_parentid'],$category_tbl, $except). " / <i class=\"fa-thin fa-folder\"></i> <a href='manager.php?menus_id=$id'>".$name."</a>";
}
$where1 = " WHERE a.video_id >0 ";
$where2 = " WHERE b.menus_name is not NULL";
$where1_sub = " WHERE video_id >0 ";
$where2_sub = " WHERE menus_name is not NULL";
$menus_id = isset($CORE->input['menus_id']) ? $CORE->input['menus_id'] : 0;
$txt_bread = '<i class="fa-thin fa-folder"></i> <a href="/manager.php">Root</a>';
if($menus_id>0){
$r_check_menus = $DB->fetch_row($DB->query("SELECT menus_name FROM tb_menus WHERE menus_id = '$menus_id'"));
$txt_bread = createPath($menus_id, 'tb_menus',$r_check_menus['menus_name']);
$where1 .= " AND a.menus_id = '".$menus_id."' ";
$where2 .= " AND b.menus_parentid = '".$menus_id."' ";
$where1_sub .= " AND menus_id = '".$menus_id."' ";
$where2_sub .= " AND menus_parentid = '".$menus_id."' ";
}
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
if($keyword!='')
{
$where1 .= " AND (a.video_name LIKE '%".$keyword."%' or a.epi_name LIKE '%".$keyword."%') ";
$where2 .= " AND (b.menus_name LIKE '%".$keyword."%' or b.menus_ename LIKE '%".$keyword."%') ";
$where1_sub .= " AND (video_name LIKE '%".$keyword."%' or epi_name LIKE '%".$keyword."%') ";
$where2_sub .= " AND (menus_name LIKE '%".$keyword."%' or menus_ename LIKE '%".$keyword."%') ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 50;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT SUM(id) AS total
FROM ((SELECT count(video_id) AS id
FROM tb_video a
".$where1."
) UNION ALL
(SELECT count(menus_id) AS id
FROM tb_menus b
".$where2."
)
) t "));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT
menus_id,menus_name,menus_des,menus_pos,time_post,user_post FROM tb_menus
".$where2_sub."
UNION
SELECT video_id,video_name,video_link,video_size,time_post,video_done
FROM tb_video
".$where1_sub."
LIMIT $from,$pageSize; ");
$arr = array();
while($row = $DB->fetch_row($query))
{
$txt_video_done = 'done';
if($row['user_post']=='no'){
$txt_video_done = 'Error [<a href="javascript:void(0);" onclick="open_popup(\'video_convert.php?id='.$row['menus_id'].'\',\'Fix it\');">Fix error video</a>] [<a href="javascript:void(0);" onclick="open_popup(\'video_error.php?id='.$row['menus_id'].'\',\'Fix it\');">Error log</a>] [<a href="javascript:void(0);" onclick="open_popup(\'video_fast_convert.php?id='.$row['menus_id'].'\',\'Fast convert\');">Fast convert</a>]';
}
$txt_check = $txt_folder=$txt_time = $txt_size = '';
if(strpos($row['menus_pos'],'MB')!==false or strpos($row['menus_pos'],'GB')!==false or strpos($row['menus_pos'],'TB')!==false){//video
$txt_check = '<input class="video_id" type="checkbox" name="id[]" value="'.$row['menus_id'].'">';
$txt_time = date('d-m-Y H:i',$row['time_post']);
$txt_folder = '<i class="fa-thin fa-play"></i> ';
$txt_size = $row['menus_pos'];
$txt_name = $row['menus_name'];
$txt_link = $row['menus_des'];
$txt_play = '<a href="javascript:void(0);" onclick="open_popup(\'play.php?video_id='.$row['menus_id'].'\',\'Play\')" class="btn btn-sm btn-icon btn-pure btn-outline"><i class="fa-thin fa-play"></i> Review</a>
<a href="javascript:void(0);" onclick="open_popup(\'manager_delete.php?type=get_link&video_id='.$row['menus_id'].'\',\'Delete\')" class="btn btn-sm btn-icon btn-pure btn-outline"><i class="fa-light fa-trash"></i> Delete</a>';
}else{
$txt_folder = '<i class="fa-thin fa-folder"></i> ';
$txt_name = '<a href="manager.php?menus_id='.$row['menus_id'].'">'.$row['menus_name'].'</a>';
$txt_link = '';
$txt_play = '<a href="javascript:void(0);" onclick="open_popup(\'menus_new.php?menus_id='.$row['menus_id'].'\',\'Edit folder\')" class="btn btn-sm btn-icon btn-pure btn-outline"><i class="fa-thin fa-pen-to-square"></i> Edit</a> <a href="javascript:void(0);" class="btn btn-sm btn-icon btn-pure btn-outline delete-row-btn-menus" data-menuis="'.$row['menus_id'].'"><i class="fa-light fa-trash"></i> Delete</a>';
}
$txt_link_des = '<td><div style="width: 350px!important;max-height: 50px; overflow: auto;">'.$row['menus_des'].'</div></td>';
$txt_list_company .= '<tr>
<td>'.$txt_check.'</td>
<td>'.$txt_folder.$txt_name.'</td>
<td>'.$txt_size.'</td>
<td>'.$txt_link.'</td>
<td>'.$txt_time.'</td>
<td>'.$txt_video_done.'</td>
<td>
'.$txt_play.'
</td>
</tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','manager.php?menus_id='.$menus_id);
require "header.php";
?>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="collapse navbar-collapse w-90" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="index.php"><i class="fa-thin fa-house"></i> Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="upload.php"><i class="fa-thin fa-upload"></i> Upload</a>
</li>
<li class="nav-item active">
<a class="nav-link" href="manager.php"><i class="fa-light fa-list-check"></i> Manager</a>
</li>
<li class="nav-item">
<a class="nav-link" href="player.php"><i class="fa-solid fa-play"></i> Player</a>
</li>
</ul>
</div>
<div class="navbar-collapse collapse order-3 dual-collapse2 w-10">
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<a class="nav-link" href="logout.php"><i class="fa-thin fa-right-from-bracket"></i> Log out</a>
</li>
</ul>
</div>
</nav>
<main role="main" class="container">
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-body">
<div class="m-t-40">
<div class="d-flex">
<div class="mr-auto">
<div class="action_list form-group">
<a href="javascript:void(0);" class="action_list btn btn-primary btn-sm" rel="move_to"><i class="fa-regular fa-turn-down-right"></i> Move to
</a>
<a href="javascript:void(0);" class="action_list btn btn-success btn-sm" rel="get_link"><i class="fa-solid fa-link"></i> Get multi link
</a>
<a href="javascript:void(0);" class="action_list btn btn-danger btn-sm" rel="delete"><i class="fa-light fa-trash"></i> Delete
</a>
</div>
</div>
<div class="ml-auto">
<div class="form-group">
<input id="demo-input-search2" type="text" placeholder="Search" autocomplete="off" class="module_title_search" value="<?php echo $keyword;?>">
<input type="hidden" value="manager.php?menus_id=<?php echo $menus_id;?>" id="txt_code_search">
</div>
</div>
</div>
</div>
<form action="manager.php" method="post" id="form_quick_update">
<input type="hidden" name="type2" value="">
<table class="table table-bordered" style="font-size: 12px;">
<thead>
<tr><td colspan="5"><?php echo $txt_bread;?> /</td><td colspan="2"><a href="javascript:void(0);" onclick="open_popup('menus_new.php?act=post','New folder')">+ New folder</a></td></tr>
<tr>
<th><input type="checkbox" name="check_all" id="select_all"></th>
<th>Name</th>
<th>Size</th>
<th>Link</th>
<th>Created at</th>
<th>Status</th>
<th>#</th>
</tr>
</thead>
<tbody>
<?php echo $txt_list_company;?>
</tbody>
</table>
</form>
<div class="text-center footable">
<ul class="pagination">
<?php echo $nav;?>
</ul>
</div>
</div>
</div>
</div>
</div>
</main>
<?php
require "footer.php";
?>