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/truyentranh/code/admin/posts/ |
<?php
function showListMenus($categories, $parent_id = 0, $char = '',$arr_menu_check)
{
// BƯỚC 2.1: LẤY DANH SÁCH CATE CON
$cate_child = array();
foreach ($categories as $key => $item)
{
// Nếu là chuyên mục con thì hiển thị
if ($item['menus_parentid'] == $parent_id)
{
$cate_child[] = $item;
unset($categories[$key]);
}
}
// BƯỚC 2.2: HIỂN THỊ DANH SÁCH CHUYÊN MỤC CON NẾU CÓ
if ($cate_child)
{
echo '<ul class="list-inline" id="tree" style="font-size: 11px;">';
foreach ($cate_child as $key => $item)
{
$checked= '';
if(in_array($item['menus_id'],$arr_menu_check)){
$checked = 'checked';
}
// Hiển thị tiêu đề chuyên mục
echo '<li class="list-inline-item">
<input type="checkbox" name="menus_id[]" id="menus_id_'.$item['menus_id'].'" value="'.$item['menus_id'].'" '.$checked.' /> <label for="menus_id_'.$item['menus_id'].'">'.$item['menus_name'].'</label>';
// Tiếp tục đệ quy để tìm chuyên mục con của chuyên mục đang lặp
showListMenus($categories, $item['menus_id'], $char.' ',$arr_menu_check);
echo '</li>';
}
echo '</ul>';
}
}
$query = $DB->query("SELECT * FROM tb_menus WHERE menus_type='page' ORDER BY `menus_pos` ASC");
$arr_menus = array();
while($row = $DB->fetch_row($query))
{
$arr_menus[] = $row;
}
$id = (isset($CORE->input['id']) && $CORE->input['id']>0) ? $CORE->input['id'] : 0;
$arr_menu_check = array();
if($id==0){
$row_check = $DB->get_colum_tb('tb_truyen');
}else{
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_truyen WHERE truyen_id='$id'"));
$q_menu = $DB->query("SELECT * FROM tb_menus_pages WHERE truyen_id='$id'");
while ($r_menu = $DB->fetch_row($q_menu)){
$arr_menu_check[] = $r_menu['menus_id'];
}
}
$txt_op_author = '';
if($row_check['truyen_tacgia']!=''){
$arr_author = explode('@',$row_check['truyen_tacgia']);
$txt_author = implode("','",$arr_author);
$q_author = $DB->query("SELECT * FROM tb_author WHERE author_fname IN ('".$txt_author."') ORDER BY author_fname");
while($r_author = $DB->fetch_row($q_author)){
$txt_op_author .= '<option value="'.$r_author['author_fname'].'" selected>'.$r_author['author_name'].'</option>';
}
}
$q_server = $DB->query("SELECT * FROM tb_server ORDER BY server_pos");
$txt_op_server = '';
while($r_server = $DB->fetch_row($q_server)){
if($row_check['server_id']==$r_server['server_id']){
$txt_op_server .= '<option value="'.$r_server['server_id'].'" selected>'.$r_server['server_name'].'</option>';
}else{
$txt_op_server .= '<option value="'.$r_server['server_id'].'">'.$r_server['server_name'].'</option>';
}
}
if(isset($CORE->input['submitbt'])){
$f = $CORE->input['f'];
$txt_truyen_tacgia ='';
if(isset($CORE->input['truyen_tacgia'])) {
$truyen_tacgia = $CORE->input['truyen_tacgia'];
if (isset($truyen_tacgia) and !empty($truyen_tacgia)) {
$txt_truyen_tacgia = implode('@', $truyen_tacgia) . '@';
}
}
if(isset($CORE->input['tags']) and $CORE->input['tags']!='') {
$tags = str_replace(array('[{', '}]', '},{'), array('', '', ','), $CORE->input['tags']);
$arr_tags = explode(',', $tags);
}
$txt_tags = '';
if(isset($arr_tags) and !empty($arr_tags)) {
foreach ($arr_tags as $val) {
$arr_val = explode(':',$val);
$arr_tags2[] = str_replace(array('"','"'),array('',''),$arr_val[1]);
}
$txt_tags = implode(',',$arr_tags2);
}
$truyen_fname = $func->format_string(trim($f['truyen_name']));
if($f['truyen_id']==0){
$row_check = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_truyen WHERE truyen_fname='$truyen_fname' "));
if($row_check['total']>=1){
$truyen_fname = $truyen_fname.'-'.($row_check['total']+1);
}
$arr_insert = array('truyen_name'=>trim($f['truyen_name']),'truyen_fname'=>$truyen_fname,'truyen_othername'=>trim($f['truyen_othername']),'truyen_noidung'=>trim($f['truyen_noidung']),'truyen_tacgia'=>$txt_truyen_tacgia,'truyen_tags'=>$txt_tags,'truyen_status'=>$f['truyen_status'],'truyen_hot'=>intval($f['truyen_hot']),'truyen_decu'=>intval($f['truyen_decu']),'truyen_active_status'=>$f['truyen_active_status'],'time_post'=>date('Y-m-d H:i:s'),'user_post'=>$ob_user->user_id,'server_id'=>$f['server_id']);
$id = $DB->do_insert('tb_truyen',$arr_insert);
//insert menu
if(isset($CORE->input['menus_id']) and !empty($CORE->input['menus_id'])) {
$menus_id = $CORE->input['menus_id'];
foreach ($menus_id as $val) {
$row_menu = $DB->fetch_row($DB->query("SELECT menus_fname FROM tb_menus WHERE menus_id='$val'"));
$arr_insert2 = array('menus_id' => $val, 'truyen_id' => $id, 'menus_fname' => $row_menu['menus_fname']);
$DB->do_insert('tb_menus_pages', $arr_insert2);
}
}
}else{
$id = $f['truyen_id'];
$row_check = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_truyen WHERE truyen_fname='$truyen_fname' AND truyen_id!='".$id."' "));
if($row_check['total']>=1){
$truyen_fname = $truyen_fname.'-'.($row_check['total']+1);
}
$arr_update = array('truyen_name'=>trim($f['truyen_name']),'truyen_fname'=>$truyen_fname,'truyen_othername'=>trim($f['truyen_othername']),'truyen_noidung'=>trim($f['truyen_noidung']),'truyen_tacgia'=>$txt_truyen_tacgia,'truyen_tags'=>$txt_tags,'truyen_status'=>$f['truyen_status'],'truyen_hot'=>intval($f['truyen_hot']),'truyen_decu'=>intval($f['truyen_decu']),'truyen_active_status'=>$f['truyen_active_status'],'user_update'=>$ob_user->user_id,'server_id'=>$f['server_id']);
$DB->do_update('tb_truyen',$arr_update," WHERE truyen_id='$id' ");
//delete old img
if($_FILES['image_field'] && $_FILES['image_field']['name']!=''){
$row_check_thumb = $DB->fetch_row($DB->query("SELECT truyen_thumb FROM tb_truyen WHERE truyen_id='$id' "));
if($row_check_thumb['truyen_thumb']!='' && file_exists($row_check_thumb['truyen_thumb'])){
unlink($row_check_thumb['truyen_thumb']);
$DB->query("UPDATE tb_truyen SET truyen_thumb='' WHERE truyen_id='$id' ");
}
}
//delete menu
$DB->query("DELETE FROM tb_menus_pages WHERE truyen_id='$id' ");
//insert menu
if(isset($CORE->input['menus_id']) and !empty($CORE->input['menus_id'])) {
$menus_id = $CORE->input['menus_id'];
foreach ($menus_id as $val) {
$row_menu = $DB->fetch_row($DB->query("SELECT menus_fname FROM tb_menus WHERE menus_id='$val'"));
$arr_insert2 = array('menus_id' => $val, 'truyen_id' => $id, 'menus_fname' => $row_menu['menus_fname']);
$DB->do_insert('tb_menus_pages', $arr_insert2);
}
}
//$print->refresh('?act=admin&code=posts&type=post&id='.$id);
}
//upload image
if($_FILES['image_field'] && $_FILES['image_field']['name']!=''){
$url_img = truyen_thumb($_FILES['image_field']);
if ($url_img!='') {
$DB->query("UPDATE tb_truyen SET truyen_thumb='$url_img' WHERE truyen_id='$id' ");
}
}
//update the loai
$q_menu_page = $DB->query(" SELECT a.menus_id,a.menus_name,a.menus_fname FROM tb_menus a LEFT JOIN tb_menus_pages b ON a.menus_id=b.menus_id WHERE b.truyen_id='".$id."' AND a.menus_parentid!=0 ");
$arr_menu = $arr_fmenu=array();
while ($r_menu_page = $DB->fetch_row($q_menu_page)){
$arr_menu[]=$r_menu_page['menus_name'];
$arr_fmenu[]=$r_menu_page['menus_fname'];
}
$txt_menu = $txt_fmenu = '';
if(!empty($arr_menu)){
$txt_menu = implode(', ',$arr_menu);
$txt_fmenu = implode('@',$arr_fmenu).'@';
}
$DB->query("UPDATE tb_truyen SET truyen_theloai='$txt_menu',truyen_ftheloai='$txt_fmenu' WHERE truyen_id='$id' ");
if($f['truyen_id']==0) {
$print->refresh('?act=admin&code=posts&type=chapter&id=' . $id);
}else {
$print->refresh('?act=admin&code=posts&type=post&id=' . $id);
}
}
?>