/**
* nv_del_cat()
*
* @param mixed $catid
* @return
*/
function nv_del_cat($catid)
{
global $db, $module_name, $module_data, $admin_info, $nv_Cache;
$sql = 'SELECT parentid, title FROM ' . NV_MOD_TABLE . '_categories WHERE id=' . $catid;
list($p, $title) = $db->query($sql)->fetch(3);
$sql = 'SELECT id, fileimage FROM ' . NV_MOD_TABLE . ' WHERE catid=' . $catid;
$result = $db->query($sql);
$ids = array();
while (list($id, $fileimage) = $result->fetch(3)) {
$ids[] = $id;
nv_delete_notification(NV_LANG_DATA, $module_name, 'report', $id);
}
if (!empty($ids)) {
$ids = implode(',', $ids);
$sql = 'DELETE FROM ' . NV_PREFIXLANG . '_comment WHERE module=' . $db->quote($module_name) . ' AND id IN (' . $ids . ')';
$db->query($sql);
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_report WHERE fid IN (' . $ids . ')';
$db->query($sql);
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_detail WHERE id IN (' . $ids . ')';
$db->query($sql);
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_files WHERE download_id IN (' . $ids . ')';
$db->query($sql);
$sql = 'SELECT * FROM ' . NV_MOD_TABLE . '_tags_id WHERE id IN (' . $ids . ')';
$result = $db->query($sql);
while ($row = $result->fetch()) {
$sql = 'UPDATE ' . NV_MOD_TABLE . '_tags SET numdownload=numdownload-1 WHERE did=' . $row['did'];
$db->query($sql);
}
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_tags_id WHERE id IN (' . $ids . ')';
$db->query($sql);
}
$sql = 'DELETE FROM ' . NV_MOD_TABLE . ' WHERE catid=' . $catid;
$db->query($sql);
$sql = 'SELECT id FROM ' . NV_MOD_TABLE . '_categories WHERE parentid=' . $catid;
$result = $db->query($sql);
while (list($id) = $result->fetch(3)) {
nv_del_cat($id);
}
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_categories WHERE id=' . $catid;
$db->query($sql);
$nv_Cache->delMod($module_name);
nv_insert_logs(NV_LANG_DATA, $module_data, 'Delete Category', $title, $admin_info['userid']);
}
// Delete file on fileserver
}
}
}
$db->query('DELETE FROM ' . NV_MOD_TABLE . '_files WHERE download_id=' . $id);
$db->query('DELETE FROM ' . NV_MOD_TABLE . '_detail WHERE id=' . $id);
$sql = 'SELECT * FROM ' . NV_MOD_TABLE . '_tags_id WHERE id=' . $id;
$result = $db->query($sql);
while ($tag = $result->fetch()) {
$sql = 'UPDATE ' . NV_MOD_TABLE . '_tags SET numdownload=numdownload-1 WHERE did=' . $tag['did'];
$db->query($sql);
}
$sql = 'DELETE FROM ' . NV_MOD_TABLE . '_tags_id WHERE id=' . $id;
$db->query($sql);
// Xoa thong bao loi
nv_delete_notification(NV_LANG_DATA, $module_name, 'report', $id);
}
// Resets the contents of the opcode cache
if ($delfile and nv_function_exists('opcache_reset')) {
opcache_reset();
}
$nv_Cache->delMod($module_name);
nv_insert_logs(NV_LANG_DATA, $module_data, $lang_module['download_filequeue_del'], $row['title'], $admin_info['userid']);
die('OK');
}
// List file
$page_title = $lang_module['download_filemanager'];
$where = array();
$base_url = NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name;
$array_search = array('q' => $nv_Request->get_title('q', 'get', ''), 'catid' => $nv_Request->get_int('catid', 'get', 0), 'active' => $nv_Request->get_int('active', 'get', '-1'), 'per_page' => $nv_Request->get_int('per_page', 'get', '30'));
if (empty($list_cats)) {
}
$t = $nv_Request->get_int('t', 'get', 0);
nv_insert_logs(NV_LANG_DATA, $module_name, 'log_del', 'id ' . $t, $admin_info['userid']);
if ($t == 3) {
$result = $db->query('SELECT id FROM ' . NV_PREFIXLANG . '_' . $module_data . '_send');
while (list($id) = $result->fetch(3)) {
nv_delete_notification(NV_LANG_DATA, $module_name, 'contact_new', $id);
}
$db->query('TRUNCATE TABLE ' . NV_PREFIXLANG . '_' . $module_data . '_send');
$db->query('TRUNCATE TABLE ' . NV_PREFIXLANG . '_' . $module_data . '_reply');
} elseif ($t == 2) {
$sends = $nv_Request->get_array('sends', 'post', array());
if (!empty($sends)) {
$in = implode(',', $sends);
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_send WHERE id IN (' . $in . ')');
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_reply WHERE id IN (' . $in . ')');
foreach ($sends as $id) {
nv_delete_notification(NV_LANG_DATA, $module_name, 'contact_new', $id);
}
}
} else {
$id = $nv_Request->get_int('id', 'get', 0);
if ($id) {
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_send WHERE id = ' . $id);
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_reply WHERE id = ' . $id);
nv_delete_notification(NV_LANG_DATA, $module_name, 'contact_new', $id);
}
}
nv_del_moduleCache($module_name);
Header('Location: ' . NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name);
die;
$array_row_id = $db->query($sql)->fetchAll();
// Het Xac dinh ID cac bai viet
if (defined('NV_IS_SPADMIN')) {
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . ' WHERE cid IN (' . $listcid . ')');
} elseif (!empty($site_mod_comm)) {
$array_mod_name = array();
foreach ($site_mod_comm as $module_i => $row) {
$array_mod_name[] = "'" . $module_i . "'";
}
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . ' WHERE cid IN (' . $listcid . ') AND module IN (' . implode(', ', $array_mod_name) . ')');
} else {
Header('Location: ' . NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name);
die;
}
foreach ($cid_array as $cid) {
nv_delete_notification(NV_LANG_DATA, $module_name, 'comment_queue', $cid);
}
nv_insert_logs(NV_LANG_DATA, $module_name, $lang_module['edit_delete'], 'listcid ' . $listcid, $admin_info['userid']);
foreach ($array_row_id as $row) {
if (isset($site_mod_comm[$row['module']])) {
$mod_info = $site_mod_comm[$row['module']];
if (file_exists(NV_ROOTDIR . '/modules/' . $mod_info['module_file'] . '/comment.php')) {
include NV_ROOTDIR . '/modules/' . $mod_info['module_file'] . '/comment.php';
$nv_Cache->delMod($row['module']);
}
}
}
echo $lang_module['delete_success'];
} else {
Header('Location: ' . NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name);
die;
/**
* nv_del_content_module()
*
* @param mixed $id
* @return
*/
function nv_del_content_module($id)
{
global $db, $module_name, $module_data, $title, $lang_module;
$content_del = 'NO_' . $id;
$title = '';
list($id, $listcatid, $title, $homeimgfile) = $db->query('SELECT id, listcatid, title, homeimgfile FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE id=' . intval($id))->fetch(3);
if ($id > 0) {
$number_no_del = 0;
$array_catid = explode(',', $listcatid);
foreach ($array_catid as $catid_i) {
$catid_i = intval($catid_i);
if ($catid_i > 0) {
$_sql = 'DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_' . $catid_i . ' WHERE id=' . $id;
if (!$db->exec($_sql)) {
++$number_no_del;
}
}
}
$_sql = 'DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE id=' . $id;
if (!$db->exec($_sql)) {
++$number_no_del;
}
$_sql = 'DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_bodyhtml_' . ceil($id / 2000) . ' WHERE id = ' . $id;
if (!$db->exec($_sql)) {
++$number_no_del;
}
$_sql = 'DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_bodytext WHERE id = ' . $id;
if (!$db->exec($_sql)) {
++$number_no_del;
}
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_comment WHERE module=' . $db->quote($module_name) . ' AND id = ' . $id);
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_block WHERE id = ' . $id);
$db->query('UPDATE ' . NV_PREFIXLANG . '_' . $module_data . '_tags SET numnews = numnews-1 WHERE tid IN (SELECT tid FROM ' . NV_PREFIXLANG . '_' . $module_data . '_tags_id WHERE id=' . $id . ')');
$db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_tags_id WHERE id = ' . $id);
nv_delete_notification(NV_LANG_DATA, $module_name, 'post_queue', $id);
if ($number_no_del == 0) {
$content_del = 'OK_' . $id . '_' . nv_url_rewrite(NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name, true);
} else {
$content_del = 'ERR_' . $lang_module['error_del_content'];
}
}
return $content_del;
}