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
$id = $CORE->input['id'];
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_truyen WHERE truyen_id='$id'"));
$q_chuong = $DB->query("SELECT * FROM tb_chuong WHERE truyen_id='$id' ");
while($r_chuong = $DB->fetch_row($q_chuong)){
$chuong_id = $r_chuong['chuong_id'];
/*$q_chuong_img = $DB->query("SELECT * FROM tb_chuong_img WHERE chuong_id='$chuong_id' ");
while($r_chuong_img = $DB->fetch_row($q_chuong_img)){
$remote_dir = $r_chuong_img['url_dir'].'/'.$r_chuong_img['file_name'];
unlink($remote_dir);
}*/
$DB->query("DELETE FROM tb_chuong WHERE chuong_id='$chuong_id' ");
$DB->query("DELETE FROM tb_chuong_img WHERE chuong_id='$chuong_id' ");
}
if($row_check){
if($row_check['truyen_thumb']!='' && file_exists($row_check['truyen_thumb'])){
unlink($row_check['truyen_thumb']);
}
}
$DB->query("DELETE FROM tb_truyen WHERE truyen_id='$id'");
$DB->query("DELETE FROM tb_menus_pages WHERE truyen_id='$id'");
$q_table = $DB->query("SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
COLUMN_NAME IN('truyen_id');");
while ($r_table = $DB->fetch_row($q_table)){
$txt_table = $r_table['TABLE_NAME'];
$DB->query("DELETE FROM $txt_table WHERE truyen_id='".$id."' ");
}
$q_table = $DB->query("SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
COLUMN_NAME IN('chuong_id');");
while ($r_table = $DB->fetch_row($q_table)){
$txt_table = $r_table['TABLE_NAME'];
$DB->query("DELETE FROM $txt_table WHERE chuong_id='".$id."' ");
}
close_popup('Deleted manga!');
?>