<?php

$rowParentShow = getRecord($tableUpdateAll, "id=" . $_REQUEST['id']);
if ($rowParentShow['parent'] == '1') {
    //kiem tra neu la menu cap 1
    ///UPDATE BANG CATEGORY------------------------------------------------------------------------
    $result = @mysql_query('update ' . $tableUpdateAll . ' set ' . $status . '=0 where parent_1 =' . $rowParentShow['parent_1'], $conn);
    ///UPDATE BANG CONNERT ID------------------------------------------------------------------------
    $resultContentId = @mysql_query('update ' . $tableUpdateAllContentID . ' set ' . $status . '=0 where parent_1 =' . $rowParentShow['parent_1'], $conn);
    $resultContent = @mysql_query('update ' . $tableUpdateAllContent . ' set ' . $status . '=0 where parent_1 =' . $rowParentShow['parent_1'], $conn);
} else {
    //neu ko phai la menu cap 1--------------------
    $strlenCode = strlen($rowParentShow['code']);
    $maxForShow = maxRecord($tableUpdateAll, 'havechildren', "substring(code, 1, " . $strlenCode . ")='" . $rowParentShow['code'] . "'");
    //lay tong so menu con lon nhat trong cung mot danh mục
    //
    $parentMaxForShow = getRecord($tableUpdateAll, "havechildren=" . $maxForShow . " and parent_1=" . $rowParentShow['parent_1']);
    //lay code cua menu thap nhat
    //echo $parentMaxForShow['code'];
    //exit();
    $parentCapShow = explode("_", $parentMaxForShow['code']);
    //echo $parentCapShow['1'];
    //exit();
    for ($jShow = 1; $jShow <= $maxForShow; $jShow++) {
        //vong for lay tu dong nhung thang co con
        //update bang category---------------------------
        $resultok = @mysql_query('update ' . $tableUpdateAll . ' set ' . $status . '=0 where id =' . $parentCapShow[$jShow] . " and substring(code, 1, " . $strlenCode . ")='" . $rowParentShow['code'] . "'", $conn);
        ///UPDATE BANG CONNERT ID------------------------------------------------------------------------
        $parentBangcon = getRecord($tableUpdateAll, "id =" . $parentCapShow[$jShow] . " and substring(code, 1, " . $strlenCode . ")='" . $rowParentShow['code'] . "'");
        //lay code cua menu thap nhat
        $resultContentId = @mysql_query('update ' . $tableUpdateAllContentID . ' set ' . $status . '=0 where parent =' . $parentBangcon['id'], $conn);
//==========THONG TIN GUI MAI=========================================================KÊ THUC=====================================
/*if($urlAjax=='ok'){
require("../".$folderSendmail."/mailHost.php"); // Path to phpmailer.php
require("../".$folderSendmail."/phpmailer.php"); // Path to phpmailer.php
}else{
require($folderSendmail."/mailHost.php"); // Path to phpmailer.php
require($folderSendmail."/phpmailer.php"); // Path to phpmailer.php
}*/
//===========CAU HINH FILE PHPMAILER.PHP======================KET THUC
require "mailHost.php";
// Path to phpmailer.php
require "phpmailer.php";
// Path to phpmailer.php
$emailAdd = explode(",", $send_to);
$totleEmailAdd = count($emailAdd);
$rowSession = maxRecord($tableSendEmailSuccessful, "id");
$session = md5($rowSession['id']);
for ($jEmail = 0; $jEmail < $totleEmailAdd; $jEmail++) {
    $email_member = $emailMember;
    //email thanh vien
    $email_to = $emailAdd[$jEmail];
    //email nhan thu
    //======VIET HAM GUI MAIL======================================
    if ($htmlProduct == 'ok') {
        $type_business = "pref_mm";
        $sending_time = $_SESSION['memberlogin'];
        $refSendEmail = "?ref_d=" . $sending_time . "&ref_p=" . $id_product . "&" . $type_business . "=" . md5($emailMember) . "&ref_email_to=" . md5($emailAdd[$jEmail]);
        //THEM THEM TAT CA NHUNG EMAIL DA GUI VO BANG tbl_module_email_send_successful===========KET THUC
        //share_sendemail_product_group.php
        include $folderSendmailHtml . "/share_sendemail_product" . $showHtmlGroup . ".php";
    } elseif ($htmlSupport == 'ok') {