PHP getDbInsert函数代码示例

function DeleteOneline($C, $d, $sync_arr)
{
    global $table, $date;
    $_ONELINE = getDbSelect($table['s_oneline'], 'parent=' . $C['uid'], '*');
    while ($_O = db_fetch_array($_ONELINE)) {
        if ($d['comment']['give_opoint'] && $_O['mbruid']) {
            getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $_O['mbruid'] . "','0','-" . $d['comment']['give_opoint'] . "','한줄의견삭제(" . getStrCut(str_replace('&', ' ', strip_tags($_O['content'])), 15, '') . ")환원','" . $date['totime'] . "'");
            getDbUpdate($table['s_mbrdata'], 'point=point-' . $d['comment']['give_opoint'], 'memberuid=' . $_O['mbruid']);
        }
    }
    getDbDelete($table['s_oneline'], 'parent=' . $C['uid']);
    // 댓글 수량 동기화
    $sync_arr = explode('|', $R['sync']);
    $feed_table = $sync_arr[0];
    $feed_uid = $sync_arr[1];
    getDbUpdate($feed_table, 'oneline=oneline-1', 'uid=' . $feed_uid);
}

        getLink('', '', '로그인해 주세요.', '');
    }
    $scorelog = '[' . $my['uid'] . ']';
} else {
    $scorelog = '[' . $_SERVER['REMOTE_ADDR'] . ']';
    if ($my['uid']) {
        $scorelog .= '[' . $my['uid'] . ']';
    }
}
$R = getUidData($table[$m . 'data'], $uid);
if (!$R['uid']) {
    getLink('', '', '존재하지 않는 게시물입니다.', '');
}
$UT = getDbData($table[$m . 'xtra'], 'parent=' . $R['uid'], '*');
$scoreset = array('good' => 'score1', 'bad' => 'score2');
// 공감,비공감 또는 추천,비추천 등 2개이상의 체크가 가능할 경우 둘중 하나라도 체크했을때 중복을 제한하려면 주석을 풀어주세요.
//if (strpos('_'.$UT['score1'],'['.$my['uid'].']') || strpos('_'.$UT['score1'],'['.$_SERVER['REMOTE_ADDR'].']') || strpos('_'.$UT['score2'],'['.$my['uid'].']') || strpos('_'.$UT['score2'],'['.$_SERVER['REMOTE_ADDR'].']'))
//{
//	getLink('','','이미 반영된 글입니다.','');
//}
if (!strpos('_' . $UT[$scoreset[$value]], '[' . $my['uid'] . ']') && !strpos('_' . $UT[$scoreset[$value]], '[' . $_SERVER['REMOTE_ADDR'] . ']')) {
    getDbUpdate($table[$m . 'data'], $scoreset[$value] . '=' . $scoreset[$value] . '+' . $score, 'uid=' . $R['uid']);
    if (!$UT['parent']) {
        getDbInsert($table[$m . 'xtra'], 'parent,site,bbs,' . $scoreset[$value], "'" . $R['uid'] . "','" . $s . "','" . $R['bbs'] . "','" . $scorelog . "'");
    } else {
        getDbUpdate($table[$m . 'xtra'], $scoreset[$value] . "='" . $UT[$scoreset[$value]] . $scorelog . "'", 'parent=' . $R['uid']);
    }
} else {
    getLink('', '', '이미 반영된 글입니다.', '');
}
getLink('', '', '반영되었습니다.', '');

                //if($U['type']==2) unlink($g['path_file'].$U['folder'].'/'.$U['thumbname']);
                unlink('./modules/bbs/upload/' . $U['folder'] . '/' . $U['tmpname']);
                if ($U['type'] == 2) {
                    unlink('./modules/bbs/upload/' . $U['folder'] . '/' . $U['thumbname']);
                }
            }
        }
    }
}
//한줄의견삭제
if ($R['oneline']) {
    $_ONELINE = getDbSelect($table['s_oneline'], 'parent=' . $R['uid'], '*');
    while ($_O = db_fetch_array($_ONELINE)) {
        getDbUpdate($table['s_numinfo'], 'oneline=oneline-1', "date='" . substr($_O['d_regis'], 0, 8) . "' and site=" . $_O['site']);
        if ($_O['point'] && $_O['mbruid']) {
            getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $_O['mbruid'] . "','0','-" . $_O['point'] . "','한줄의견삭제(" . getStrCut(str_replace('&', ' ', strip_tags($_O['content'])), 15, '') . ")환원','" . $date['totime'] . "'");
            getDbUpdate($table['s_mbrdata'], 'point=point-' . $_O['point'], 'memberuid=' . $_O['mbruid']);
        }
    }
    getDbDelete($table['s_oneline'], 'parent=' . $R['uid']);
}
getDbDelete($table['s_comment'], 'uid=' . $R['uid']);
getDbUpdate($table['s_numinfo'], 'comment=comment-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site']);
if ($R['point'] && $R['mbruid']) {
    getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $R['mbruid'] . "','0','-" . $R['point'] . "','댓글삭제(" . getStrCut($R['subject'], 15, '') . ")환원','" . $date['totime'] . "'");
    getDbUpdate($table['s_mbrdata'], 'point=point-' . $R['point'], 'memberuid=' . $R['mbruid']);
}
echo '[RESULT:ok:RESULT]';
?>

} else {
    $upfileNum = 1;
    $name = _LANG('a5002', 'mediaset');
    $fileExt = 'mp4';
    $mingid = getDbCnt($table['s_upload'], 'min(gid)', '');
    $gid = $mingid ? $mingid - 1 : 100000000;
    $QKEY = "gid,pid,category,hidden,tmpcode,site,mbruid,fileonly,type,ext,fserver,url,folder,name,tmpname,thumbname,size,width,height,alt,caption,description,src,linkto,license,down,d_regis,d_update,sync,linkurl";
    $QVAL = "'{$gid}','{$gid}','{$category}','0','{$tmpcode}','{$s}','{$mbruid}','{$_fileonly}','0','{$fileExt}','0','','','{$name}','','','0','0','0','','','','{$src}','0','0','0','{$d_regis}','','',''";
    getDbInsert($table['s_upload'], $QKEY, $QVAL);
    if ($gid == 100000000) {
        db_query("OPTIMIZE TABLE " . $table['s_upload'], $DB_CONNECT);
    }
}
if ($fileonly != 'Y') {
    if (!getDbRows($table['s_uploadcat'], 'mbruid=' . $my['uid'] . ' and type=2')) {
        getDbInsert($table['s_uploadcat'], 'gid,site,mbruid,type,hidden,users,name,r_num,d_regis,d_update', "'0','" . $s . "','" . $my['uid'] . "','2','0','','none','0','" . $date['totime'] . "',''");
        getDbInsert($table['s_uploadcat'], 'gid,site,mbruid,type,hidden,users,name,r_num,d_regis,d_update', "'1','" . $s . "','" . $my['uid'] . "','2','0','','trash','0','" . $date['totime'] . "',''");
    }
    $_tname = 'uid=' . (int) $category;
    if (!$category) {
        $_tname = "name='none'";
    }
    if ($category == -1) {
        $_tname = "name='trash'";
    }
    getDbUpdate($table['s_uploadcat'], 'r_num=r_num+' . $upfileNum, 'mbruid=' . $my['uid'] . ' and type=2 and ' . $_tname);
}
if ($link == 'Y') {
    getLink('reload', 'parent.', '', '');
}
exit;

        $fileExt = $fileExt == 'jpeg' ? 'jpg' : $fileExt;
        $userimg = $id . '_' . $imgset[$i] . '.' . $fileExt;
        $saveFile = $g['dir_module'] . 'var/files/' . $userimg;
        if (is_uploaded_file($tmpname)) {
            if (!strstr('[gif][jpg][png][swf]', $fileExt)) {
                getLink('', '', '헤더/풋터파일은 gif/jpg/png/swf 파일만 등록할 수 있습니다.', '');
            }
            move_uploaded_file($tmpname, $saveFile);
            @chmod($saveFile, 0707);
            ${'img' . $imgset[$i]} = $userimg;
        }
    }
    $Ugid = getDbCnt($table[$m . 'list'], 'max(gid)', '') + 1;
    $QKEY = "gid,id,name,category,num_r,d_last,d_regis,imghead,imgfoot,puthead,putfoot,addinfo,writecode";
    $QVAL = "'{$Ugid}','{$id}','{$name}','{$category}','0','','" . $date['totime'] . "','{$imghead}','{$imgfoot}','{$puthead}','{$putfoot}','{$addinfo}','{$writecode}'";
    getDbInsert($table[$m . 'list'], $QKEY, $QVAL);
    $mfile = $g['dir_module'] . 'var/code/' . $id;
    if (trim($codhead)) {
        $fp = fopen($mfile . '.header.php', 'w');
        fwrite($fp, trim(stripslashes($codhead)));
        fclose($fp);
        @chmod($mfile . '.header.php', 0707);
    }
    if (trim($codfoot)) {
        $fp = fopen($mfile . '.footer.php', 'w');
        fwrite($fp, trim(stripslashes($codfoot)));
        fclose($fp);
        @chmod($mfile . '.footer.php', 0707);
    }
    $backUrl = $g['s'] . '/?r=' . $r . '&m=admin&module=' . $m . '&front=makebbs&iframe=Y&uid=' . getDbCnt($table[$m . 'list'], 'max(uid)', '');
}

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['uid']) {
    getLink('', '', '정상적인 접근이 아닙니다.', '');
}
$R = getUidData($table[$m . 'data'], $uid);
if (!$R['uid']) {
    getLink('', '', '삭제되었거나 존재하지 않는 게시물입니다.', '');
}
$B = getUidData($table[$m . 'list'], $R['bbs']);
if (!$B['uid']) {
    getLink('', '', '존재하지 않는 게시판입니다.', '');
}
$mbruid = $my['uid'];
$category = $_HM['name'] ? $_HM['name'] : $B['name'];
$subject = addslashes($R['subject']);
$url = getLinkFilter($g['s'] . '/?' . ($_HS['usescode'] ? 'r=' . $r . '&amp;' : '') . ($c ? 'c=' . $c : 'm=' . $m), array('bid', 'skin', 'iframe'));
$d_regis = $date['totime'];
if (getDbRows($table['s_scrap'], "mbruid=" . $mbruid . " and url='" . $url . "'")) {
    getLink('', '', '이미 스크랩된 게시물입니다.', '');
}
$_QKEY = 'mbruid,category,subject,url,d_regis';
$_QVAL = "'{$mbruid}','{$category}','{$subject}','{$url}','{$d_regis}'";
getDbInsert($table['s_scrap'], $_QKEY, $_QVAL);
getLink('', '', '스크랩 되었습니다.', '');

    $marr2 = 0;
    $sms = 1;
    $mailing = 1;
    $smail = 0;
    $point = 0;
    $usepoint = 0;
    $money = 0;
    $cash = 0;
    $num_login = 1;
    $pw_q = '';
    $pw_a = '';
    $now_log = 0;
    $last_log = '';
    $last_pw = $date['totime'];
    $is_paper = 0;
    $d_regis = $date['totime'];
    $sns = '';
    $noticeconf = '';
    $num_notice = 0;
    $addfield = '';
    $_QKEY = "memberuid,site,auth,mygroup,level,comp,admin,adm_view,";
    $_QKEY .= "email,name,nic,grade,photo,home,sex,birth1,birth2,birthtype,tel1,tel2,zip,";
    $_QKEY .= "addr0,addr1,addr2,job,marr1,marr2,sms,mailing,smail,point,usepoint,money,cash,num_login,pw_q,pw_a,now_log,last_log,last_pw,is_paper,d_regis,tmpcode,sns,noticeconf,num_notice,addfield";
    $_QVAL = "'{$memberuid}','{$s}','{$auth}','{$mygroup}','{$level}','{$comp}','{$admin}','{$adm_view}',";
    $_QVAL .= "'{$email}','{$name}','{$nic}','','{$photo}','{$home}','{$sex}','{$birth1}','{$birth2}','{$birthtype}','{$tel1}','{$tel2}','{$zip}',";
    $_QVAL .= "'{$addr0}','{$addr1}','{$addr2}','{$job}','{$marr1}','{$marr2}','{$sms}','{$mailing}','{$smail}','{$point}','{$usepoint}','{$money}','{$cash}','{$num_login}','{$pw_q}','{$pw_a}','{$now_log}','{$last_log}','{$last_pw}','{$is_paper}','{$d_regis}','','{$sns}','{$noticeconf}','{$num_notice}','{$addfield}'";
    getDbInsert($table['s_mbrdata'], $_QKEY, $_QVAL);
    getDbUpdate($table['s_mbrlevel'], 'num=num+1', 'uid=' . $level);
    getDbUpdate($table['s_mbrgroup'], 'num=num+1', 'uid=' . $mygroup);
}
getLink('reload', 'parent.', '', '');

}
if ($uid) {
    $R = getUidData($table['s_oneline'], $uid);
    if (!$R['uid']) {
        echo '[RESULT:존재하지 않는 한줄의견입니다. :RESULT]';
    }
    if (!$my['admin'] && $my['uid'] != $R['mbruid']) {
        echo '[RESULT:정상적인 접근이 아닙니다.:RESULT]';
    }
    $QVAL = "hidden='{$hidden}',content='{$content}',html='{$html}',d_modify='{$d_regis}',adddata='{$adddata}'";
    getDbUpdate($table['s_oneline'], $QVAL, 'uid=' . $R['uid']);
} else {
    //댓글의 부모글에 한줄의견 수량 추가
    $sync_arr = explode('|', $R['sync']);
    $feed_table = $sync_arr[0];
    $feed_uid = $sync_arr[1];
    getDbUpdate($feed_table, 'oneline=oneline+1', 'uid=' . $feed_uid);
    $maxuid = getDbCnt($table['s_oneline'], 'max(uid)', '');
    $uid = $maxuid ? $maxuid + 1 : 1;
    $QKEY = "uid,site,parent,parentmbr,hidden,name,nic,mbruid,id,content,html,report,point,d_regis,d_modify,ip,agent,adddata";
    $QVAL = "'{$uid}','{$s}','{$parent}','{$parentmbr}','{$hidden}','{$name}','{$nic}','{$mbruid}','{$id}','{$content}','{$html}','{$report}','{$point}','{$d_regis}','{$d_modify}','{$ip}','{$agent}','{$adddata}'";
    getDbInsert($table['s_oneline'], $QKEY, $QVAL);
    getDbUpdate($table['s_comment'], "oneline=oneline+1,d_oneline='" . $d_regis . "'", 'uid=' . $parent);
    getDbUpdate($table['s_numinfo'], 'oneline=oneline+1', "date='" . $date['today'] . "' and site=" . $s);
    if ($point && $my['uid']) {
        getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $my['uid'] . "','0','" . $point . "','한줄의견(" . getStrCut(str_replace('&', ' ', strip_tags($content)), 15, '') . ")포인트','" . $date['totime'] . "'");
        getDbUpdate($table['s_mbrdata'], 'point=point+' . $point, 'memberuid=' . $my['uid']);
    }
}
echo '[RESULT:ok:RESULT]';
exit;

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
// history에 저장
$arrCP = explode(",", $cpnumber);
for ($i = 0; $i < count($arrCP); $i++) {
    //$arrTemp = explode("||", $arrCP[$i]);
    //if( strlen($arrTemp[0]) == 11 )
    //	$receiver = substr($arrTemp[0], 0, 3) . "-" . substr($arrTemp[0], 3, 4) . "-" . substr($arrTemp[0], 7, 4);
    //else
    //	$receiver = substr($arrTemp[0], 0, 3) . "-" . substr($arrTemp[0], 3, 3) . "-" . substr($arrTemp[0], 6, 4);
    $key = "cp,writer,content,send_date,from_type";
    $val = "'" . $arrCP[$i] . "','" . $my['uid'] . "','" . $receiver . "','" . $smsText . "','" . date("YmdHis") . "','batch'";
    echo "<script>alert('" . $arrCP[$i] . "');</script>";
    getDbInsert($table['smshistory'], $key, $val);
}
// 전송
getSendSMS("_sms", "sms", $cpnumber, "대량전송(관리자)", $smsText, $xms);
// 페이지 이동
getLink($g['s'] . "/?r=" . $r . "&m=sms&a=a_refresh", 'self.', '전송이 완료되었습니다.', '');
//getLink($g['s']."/",'self.','전송이 완료되었습니다.','');

$my['admin'] = 1;
$nick = $nick ? $nick : _LANG('a008', 'install');
$sex = $sex ? $sex : 0;
$cellphone = $tel_1 && $tel_2 && $tel_3 ? $tel_1 . '-' . $tel_2 . '-' . $tel_3 : '';
$birth1 = $birth_1 ? $birth_1 : 0;
$birth2 = $birth_2 && $birth_3 ? $birth_2 . $birth_3 : 0;
$QUE = "insert into " . $table['s_mbrdata'] . " \n(memberuid,site,auth,mygroup,level,comp,admin,adm_view,\nemail,name,nic,grade,photo,home,sex,birth1,birth2,birthtype,tel1,tel2,zip,\naddr0,addr1,addr2,job,marr1,marr2,sms,mailing,smail,point,usepoint,money,cash,num_login,pw_q,pw_a,now_log,last_log,last_pw,is_paper,d_regis,tmpcode,sns,noticeconf,num_notice,addfield)\nvalues\n('1','1','1','1','1','0','" . $my['admin'] . "','',\n'" . $email . "','" . $name . "','" . $nick . "','','','','" . $sex . "','" . $birth1 . "','" . $birth2 . "','" . $birthtype . "','','" . $cellphone . "','',\n'','','','','0','0','1','1','0','0','0','0','0','1','" . _LANG('a09', 'install') . "','','1','" . $date['totime'] . "','" . $date['today'] . "','0','" . $date['totime'] . "','','','','0','')";
db_query($QUE, $DB_CONNECT);
$groupset = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H');
$i = 0;
foreach ($groupset as $_val) {
    getDbInsert($table['s_mbrgroup'], 'gid,name,num', "'" . $i . "','" . _LANG('a010', 'install') . $_val . "','" . (!$i ? 1 : 0) . "'");
    $i++;
}
for ($i = 1; $i < 101; $i++) {
    getDbInsert($table['s_mbrlevel'], 'gid,name,num,login,post,comment', "'" . ($i == 20 ? 1 : 0) . "','" . _LANG('a011', 'install') . $i . "','" . ($i == 1 ? 1 : 0) . "','0','0','0'");
}
$_tmpdfile = $g['path_module'] . 'admin/var/var.system.php';
include $_tmpdfile;
if ($d['admin']['syslang'] != $sitelang) {
    $d['admin']['syslang'] = $sitelang;
    $fp = fopen($_tmpdfile, 'w');
    fwrite($fp, "<?php\n");
    foreach ($d['admin'] as $key => $val) {
        fwrite($fp, "\$d['admin']['" . $key . "'] = \"" . addslashes(stripslashes($val)) . "\";\n");
    }
    fwrite($fp, "?>");
    fclose($fp);
    @chmod($_tmpdfile, 0707);
}
setcookie('svshop', $id . '|' . $pw1, time() + 60 * 60 * 24 * 30, '/');

$_QVAL .= "zip='{$zip}',addr0='{$addr0}',addr1='{$addr1}',addr2='{$addr2}',job='{$job}',marr1='{$marr1}',marr2='{$marr2}',sms='{$sms}',mailing='{$mailing}',pw_q='{$pw_q}',pw_a='{$pw_a}',sns='{$sns}',addfield='{$addfield}'";
getDbUpdate($table['s_mbrdata'], $_QVAL, 'memberuid=' . $memberuid);
$isCOMP = getDbData($table['s_mbrcomp'], 'memberuid=' . $memberuid, '*');
if ($comp) {
    $comp_num = $comp_num_1 && $comp_num_2 && $comp_num_3 ? $comp_num_1 . $comp_num_2 . $comp_num_3 : 0;
    //$comp_type	= $comp_type;
    $comp_name = trim($comp_name);
    $comp_ceo = trim($comp_ceo);
    $comp_upte = trim($comp_upte);
    $comp_jongmok = trim($comp_jongmok);
    $comp_tel = $comp_tel_1 && $comp_tel_2 ? $comp_tel_1 . '-' . $comp_tel_2 . ($comp_tel_3 ? '-' . $comp_tel_3 : '') : '';
    $comp_fax = $comp_fax_1 && $comp_fax_2 && $comp_fax_3 ? $comp_fax_1 . '-' . $comp_fax_2 . '-' . $comp_fax_3 : '';
    $comp_zip = $comp_zip_1 . $comp_zip_2;
    $comp_addr0 = $comp_addr1 && $comp_addr2 ? substr($comp_addr1, 0, 6) : '';
    $comp_addr1 = $comp_addr1 && $comp_addr2 ? $comp_addr1 : '';
    $comp_addr2 = trim($comp_addr2);
    $comp_part = trim($comp_part);
    $comp_level = trim($comp_level);
    if ($isCOMP['memberuid']) {
        $_QVAL = "comp_num='{$comp_num}',comp_type='{$comp_type}',comp_name='{$comp_name}',comp_ceo='{$comp_ceo}',comp_upte='{$comp_upte}',comp_jongmok='{$comp_jongmok}',";
        $_QVAL .= "comp_tel='{$comp_tel}',comp_fax='{$comp_fax}',comp_zip='{$comp_zip}',comp_addr0='{$comp_addr0}',comp_addr1='{$comp_addr1}',comp_addr2='{$comp_addr2}',comp_part='{$comp_part}',comp_level='{$comp_level}'";
        getDbUpdate($table['s_mbrcomp'], $_QVAL, 'memberuid=' . $isCOMP['memberuid']);
    } else {
        $_QKEY = "memberuid,comp_num,comp_type,comp_name,comp_ceo,comp_upte,comp_jongmok,";
        $_QKEY .= "comp_tel,comp_fax,comp_zip,comp_addr0,comp_addr1,comp_addr2,comp_part,comp_level";
        $_QVAL = "'{$memberuid}','{$comp_num}','{$comp_type}','{$comp_name}','{$comp_ceo}','{$comp_upte}','{$comp_jongmok}',";
        $_QVAL .= "'{$comp_tel}','{$comp_fax}','{$comp_zip}','{$comp_addr0}','{$comp_addr1}','{$comp_addr2}','{$comp_part}','{$comp_level}'";
        getDbInsert($table['s_mbrcomp'], $_QKEY, $_QVAL);
    }
}
getLink('reload', 'parent.', '변경되었습니다.', '');

$memberuid = $my['uid'];
$url = $g['s'] . '/?r=' . $r . '&m=' . $m . '&module=' . $_addmodule . '&front=' . $_addfront;
if (getDbRows($table['s_admpage'], 'memberuid=' . $memberuid . " and url='" . $url . "'")) {
    getLink('', '', '이미 등록된 북마크입니다.', '');
}
$maxgid = getDbCnt($table['s_admpage'], 'max(gid)', 'memberuid=' . $memberuid);
$MD = getDbData($table['s_module'], "id='" . $_addmodule . "'", '*');
$varfile = $g['path_module'] . $_addmodule . '/lang.' . $_HS['lang'] . '/admin/var/var.menu.php';
if (is_file($varfile)) {
    include $varfile;
    $name = $MD['name'] . ' - ' . $d['amenu'][$_addfront];
} else {
    $name = $MD['name'];
}
$gid = $maxgid + 1;
getDbInsert($table['s_admpage'], 'memberuid,gid,name,url', "'{$memberuid}','{$gid}','{$name}','{$url}'");
$bookmark_uid = getDbCnt($table['s_admpage'], 'max(uid)', '');
if ($_addmodule == 'admin' && $_addfront == 'bookmark') {
    getLink('reload', 'parent.', '', '');
} else {
    ?>
<script>
parent.getId('_bookmark_star_').className = 'fa fa-lg fa-star rb-star-fill';
parent.getId('_bookmark_notyet_').className = 'btn-group btn-group-sm dropdown hidden';
parent.getId('_bookmark_already_').className = 'btn-group btn-group-sm dropdown';
parent.getId('_add_bookmark_').innerHTML <?php 
    if (getDbRows($table['s_admpage'], 'memberuid=' . $my['uid']) > 1) {
        ?>
+<?php 
    }
    ?>

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['uid']) {
    getLink('', '', '정상적인 접근이 아닙니다.', '');
}
$memberuid = 0;
$price = 0;
if ($my['admin']) {
    foreach ($members as $val) {
        $P = getUidData($table['s_' . $pointType], $val);
        $price = $price + $P['price'];
        $memberuid = $P['my_mbruid'];
        getDbDelete($table['s_' . $pointType], 'uid=' . $P['uid']);
    }
    getDbInsert($table['s_' . $pointType], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $memberuid . "','0','{$price}','내역을 정리하였습니다.','" . $date['totime'] . "'");
} else {
    foreach ($members as $val) {
        $P = getUidData($table['s_' . $pointType], $val);
        $price = $price + $P['price'];
        getDbDelete($table['s_' . $pointType], 'uid=' . $P['uid'] . ' and my_mbruid=' . $my['uid']);
    }
    getDbInsert($table['s_' . $pointType], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $my['uid'] . "','0','{$price}','내역을 정리하였습니다.','" . $date['totime'] . "'");
}
getLink('reload', 'parent.', '', '');

     @chmod($g['path_tmp'] . 'out/' . $M['id'] . '.txt', 0707);
 }
 //회원탈퇴
 if ($act == 'tool_out') {
     getDbUpdate($table['s_mbrdata'], 'auth=4', 'memberuid=' . $M['memberuid']);
 }
 //포인트지급
 if ($act == 'give_point') {
     getDbUpdate($table['s_mbrdata'], $pointType . '=' . $pointType . '+' . $price, 'memberuid=' . $M['memberuid']);
     getDbInsert($table['s_' . $pointType], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $M['memberuid'] . "','0','" . $price . "','" . $comment . "','" . $date['totime'] . "'");
 }
 //쪽지전송
 if ($act == 'send_paper') {
     $QKEY = 'parent,my_mbruid,by_mbruid,inbox,content,html,upload,d_regis,d_read';
     $QVAL = "'0','" . $M['memberuid'] . "','" . $my['uid'] . "','1','" . $memo . "','{$html}','{$upload}','" . $send_time . "',''";
     getDbInsert($table['s_paper'], $QKEY, $QVAL);
     getDbUpdate($table['s_mbrdata'], 'is_paper=1', 'memberuid=' . $M['memberuid']);
 }
 //문자전송
 if ($act == 'send_sms') {
     $frame = "_sms_" . $sms_cnt;
     $form = "sms" . $sms_cnt;
     $title = "관리자전송(" . $M['name'] . ")";
     getSendSMS($frame, $form, $M['tel2'], $title, $sms);
     $sms_cnt++;
 }
 //메일전송
 if ($act == 'send_email') {
     if ($mailing && !$M['mailing']) {
         continue;
     }

 $MAXC = getDbCnt($table['s_menu'], 'max(gid)', 'depth=' . ($depth + 1) . ' and parent=' . $parent);
 $sarr = explode(',', trim($name));
 $slen = count($sarr);
 for ($i = 0; $i < $slen; $i++) {
     if (!$sarr[$i]) {
         continue;
     }
     $gid = $MAXC + 1 + $i;
     $xdepth = $depth + 1;
     $xname = trim($sarr[$i]);
     $xnarr = explode('=', $xname);
     $QKEY = "gid,site,isson,parent,depth,id,menutype,mobile,hidden,reject,name,target,redirect,joint,perm_g,perm_l,layout,imghead,imgfoot,addattr,num,d_last,addinfo";
     $QVAL = "'{$gid}','{$account}','0','{$parent}','{$xdepth}','{$xnarr['1']}','{$menutype}','{$mobile}','{$hidden}','{$reject}','{$xnarr['0']}','{$target}','{$redirect}','{$joint}','{$perm_g}','{$perm_l}','{$layout}','','','{$addattr}','0','',''";
     getDbInsert($table['s_menu'], $QKEY, $QVAL);
     $lastmenu = getDbCnt($table['s_menu'], 'max(uid)', '');
     getDbInsert($table['s_seo'], 'rel,parent,title,keywords,description', "'1','{$lastmenu}','{$title}','{$keywords}','{$description}'");
     if (!$redirect && $menutype == 1 && strstr($joint, 'cync=Y')) {
         $ctarr = getMenuCodeToPath($table['s_menu'], $lastmenu, 0);
         $catcode = '';
         $ctnum = count($ctarr);
         for ($j = 0; $j < $ctnum; $j++) {
             $catcode .= $ctarr[$j]['id'] . '/';
         }
         $c = substr($catcode, 0, strlen($catcode) - 1);
         $joint = str_replace('cync=Y', 'cync=[' . $m . '][c' . $lastmenu . '][,,,][][][c:' . $c . ']', $joint);
     }
     if (!$xnarr[1]) {
         getDbUpdate($table['s_menu'], "id='" . $lastmenu . "',joint='" . $joint . "'", 'uid=' . $lastmenu);
     } else {
         $ISMCODE = getDbData($table['s_menu'], "uid<> " . $lastmenu . " and id='" . $xnarr[1] . "' and site=" . $s, '*');
         if ($ISMCODE['uid']) {