PHP getDbDelete Examples

Example #1

File: a.deletepopup.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
getDbDelete($table['s_popup'], 'uid=' . $uid);
getLink('reload', 'parent.', $alert, $history);

Example #2

File: a.multi_delete.php Project: hanacody/rb2

function getuFileType($R)
{
    if ($R['type'] == 2 || $R['type'] == -1) {
        return 1;
    }
    if ($R['type'] == 5 || $R['type'] == 0) {
        return 2;
    }
    return 0;
}
include $g['dir_module'] . 'var/var.php';
$_MEMBERS = array();
foreach ($upfile_members as $val) {
    $R = getUidData($table['s_upload'], $val);
    if ($R['uid']) {
        getDbDelete($table['s_upload'], 'uid=' . $R['uid']);
        if ($R['type'] > 0) {
            if ($R['fserver'] && $R['url'] == $d['mediaset']['ftp_urlpath']) {
                $FTP_CONNECT = ftp_connect($d['mediaset']['ftp_host'], $d['mediaset']['ftp_port']);
                $FTP_CRESULT = ftp_login($FTP_CONNECT, $d['mediaset']['ftp_user'], $d['mediaset']['ftp_pass']);
                if (!$FTP_CONNECT) {
                    continue;
                }
                if (!$FTP_CRESULT) {
                    continue;
                }
                if ($d['mediaset']['ftp_pasv']) {
                    ftp_pasv($FTP_CONNECT, true);
                }
                ftp_delete($FTP_CONNECT, $d['mediaset']['ftp_folder'] . $R['folder'] . '/' . $R['tmpname']);
                if ($R['type'] == 2) {

Example #3

File: a.comment_delete.php Project: kiminmug/rb_module_bbs

                //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]';
?>

Example #4

File: a.write_h.php Project: kiminmug/rb_module_bbs

 $_tagarr1 = array();
 $_tagarr2 = explode(',', $tag);
 $_tagdate = $date['today'];
 if ($R['uid'] && $reply != 'Y') {
     $_tagdate = substr($R['d_regis'], 0, 8);
     $_tagarr1 = explode(',', $R['tag']);
     foreach ($_tagarr1 as $_t) {
         if (!$_t || in_array($_t, $_tagarr2)) {
             continue;
         }
         $_TAG = getDbData($table['s_tag'], "site=" . $R['site'] . " and date='" . $_tagdate . "' and keyword='" . $_t . "'", '*');
         if ($_TAG['uid']) {
             if ($_TAG['hit'] > 1) {
                 getDbUpdate($table['s_tag'], 'hit=hit-1', 'uid=' . $_TAG['uid']);
             } else {
                 getDbDelete($table['s_tag'], 'uid=' . $_TAG['uid']);
             }
         }
     }
 }
 foreach ($_tagarr2 as $_t) {
     if (!$_t || in_array($_t, $_tagarr1)) {
         continue;
     }
     $_TAG = getDbData($table['s_tag'], 'site=' . $s . " and date='" . $_tagdate . "' and keyword='" . $_t . "'", '*');
     if ($_TAG['uid']) {
         getDbUpdate($table['s_tag'], 'hit=hit+1', 'uid=' . $_TAG['uid']);
     } else {
         getDbInsert($table['s_tag'], 'site,date,keyword,hit', "'" . $s . "','" . $_tagdate . "','" . $_t . "','1'");
     }
 }

Example #5

File: a.multi_delete.php Project: kieregh/rb1.2

                    ftp_close($FTP_CONNECT);
                } else {
                    unlink($g['path_file'] . $U['folder'] . '/' . $U['tmpname']);
                    if ($U['type'] == 2) {
                        unlink($g['path_file'] . $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']);
    getDbDelete($table['s_xtralog'], "module='" . $m . "' and parent='" . $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']);
    }
}
getLink('reload', 'parent.', '', '');

Example #6

File: a.friend_unfollow.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['uid']) {
    getLink('', '', '정상적인 접근이 아닙니다.', '');
}
foreach ($members as $val) {
    $R = getUidData($table['s_friend'], $val);
    getDbDelete($table['s_friend'], 'uid=' . $R['uid'] . ' and my_mbruid=' . $my['uid']);
    if ($R['rel']) {
        getDbUpdate($table['s_friend'], 'rel=0', 'my_mbruid=' . $R['by_mbruid'] . ' and by_mbruid=' . $R['my_mbruid']);
    }
}
getLink('reload', 'parent.', '', '');

Example #7

File: a.add_package.php Project: hanacody/rb2

             @unlink($g['path_var'] . 'menu/' . $_M['imghead']);
             @unlink($g['path_var'] . 'menu/' . $_M['imgfoot']);
             getDbDelete($table['s_seo'], 'rel=1 and parent=' . $_M['uid']);
         }
         getDbDelete($table['s_menu'], 'site=' . $S['uid']);
         db_query("OPTIMIZE TABLE " . $table['s_menu'], $DB_CONNECT);
         db_query("OPTIMIZE TABLE " . $table['s_seo'], $DB_CONNECT);
         DirDelete($g['path_page'] . $S['id'] . '-menus');
     }
     //기존페이지삭제
     if ($ACT_DP) {
         $_PAGES = getDbSelect($table['s_page'], 'site=' . $S['uid'] . ' order by uid asc', '*');
         while ($_P = db_fetch_array($_PAGES)) {
             getDbDelete($table['s_seo'], 'rel=2 and parent=' . $_P['uid']);
         }
         getDbDelete($table['s_page'], 'site=' . $S['uid']);
         db_query("OPTIMIZE TABLE " . $table['s_page'], $DB_CONNECT);
         db_query("OPTIMIZE TABLE " . $table['s_seo'], $DB_CONNECT);
         DirDelete($g['path_page'] . $S['id'] . '-pages');
     }
     @rename($g['path_tmp'] . 'app/' . $package_folder . '/pages/' . $d['package']['siteid'] . '-menus', $g['path_tmp'] . 'app/' . $package_folder . '/pages/' . $S['id'] . '-menus');
     @rename($g['path_tmp'] . 'app/' . $package_folder . '/pages/' . $d['package']['siteid'] . '-pages', $g['path_tmp'] . 'app/' . $package_folder . '/pages/' . $S['id'] . '-pages');
 } else {
     $MAXC = getDbCnt($table['s_site'], 'max(gid)', '');
     $gid = $MAXC + 1;
     $name = 'SITE ' . $gid;
     $id = 's' . date('His');
     $QKEY = "gid,id,name,title,titlefix,icon,layout,startpage,m_layout,m_startpage,lang,open,dtd,nametype,timecal,rewrite,buffer,usescode,headercode,footercode";
     $QVAL = "'" . $gid . "','" . $id . "','" . $name . "','{subject} | {site}','0','glyphicon glyphicon-home','" . $d['package']['layout'] . "','0','" . $d['package']['layout_mobile'] . "','0','','1','','nic','0','0','0','1','',''";
     getDbInsert($table['s_site'], $QKEY, $QVAL);
     $LASTUID = getDbCnt($table['s_site'], 'max(uid)', '');

Example #8

File: a.mobile.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
$agentlist = trim($agentlist);
$QKEY = "usemobile,startsite,startdomain";
$QVAL = "'{$usemobile}','{$startsite}','{$startdomain}'";
getDbDelete($table['s_mobile'], '');
getDbInsert($table['s_mobile'], $QKEY, $QVAL);
$mfile = $g['path_var'] . 'mobile.agent.txt';
$fp = fopen($mfile, 'w');
fwrite($fp, $agentlist);
fclose($fp);
@chmod($mfile, 0707);
getLink('reload', 'parent.', '', '');

Example #9

File: a.delete.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['admin']) {
    getLink('', '', '권한이 없습니다.', '');
}
$R = getUidData($table['s_trackback'], $uid);
if (!$R['uid']) {
    getLink(RW(0), '', '', '');
}
$cyncArr = getArrayString($R['cync']);
getDbDelete($table['s_trackback'], 'uid=' . $R['uid']);
if ($R['type'] == 1) {
    getDbUpdate($table[$cyncArr['data'][0] . 'data'], 'trackback=trackback-1', 'uid=' . $cyncArr['data'][1]);
    getDbUpdate($table['s_numinfo'], 'rcvtrack=rcvtrack-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site']);
} else {
    getDbUpdate($table['s_numinfo'], 'sndtrack=sndtrack-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site']);
}
getLink('reload', 'parent.', '', '');

Example #10

File: a.deletepage.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
$R = getUidData($table['s_page'], $uid);
getDbDelete($table['s_page'], 'uid=' . $R['uid']);
unlink($g['path_page'] . $R['id'] . '.php');
unlink($g['path_page'] . $R['id'] . '.widget.php');
@unlink($g['path_page'] . $R['id'] . '.mobile.php');
@unlink($g['path_page'] . $R['id'] . '.css');
@unlink($g['path_page'] . $R['id'] . '.js');
@unlink($g['path_page'] . $R['id'] . '.txt');
@unlink($g['path_page'] . $R['id'] . '.cache');
@unlink($g['path_page'] . $R['id'] . '.mobile.cache');
if ($_HS['startpage'] && $_HS['startpage'] == $R['uid']) {
    getDbUpdate($table['s_site'], 'startpage=0', 'uid=' . $s);
}
db_query("OPTIMIZE TABLE " . $table['s_page'], $DB_CONNECT);
getLink('reload', 'parent.', '', '');

Example #11

File: a.point_multi_delete.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
$pointType = $pointType ? $pointType : 'point';
foreach ($point_members as $val) {
    $P = getUidData($table['s_' . $pointType], $val);
    if (!$P['uid']) {
        continue;
    }
    getDbDelete($table['s_' . $pointType], 'uid=' . $P['uid']);
    //getDbUpdate($table['s_mbrdata'],$pointType.'='.$pointType.'-'.$P['price'],'memberuid='.$P['my_mbruid']);
}
getLink('reload', 'parent.', '', '');

Example #12

File: main.php Project: eosliebe/rb

             getDbInsert($table['s_inkey'], 'site,date,keyword,hit', "'" . $s . "','" . $date['today'] . "','" . $_keyword . "','1'");
         }
     }
 } else {
     $_referer = $referer ? urldecode($referer) : $_SERVER['HTTP_REFERER'];
     $_sengine = getSearchEngine($_referer);
     $_outkeyw = getKeyword($_referer);
     $_browser = getBrowzer($g['agent']);
     $_QKEY = 'site,mbruid,ip,referer,agent,d_regis';
     $_QVAL = "'" . $s . "','" . $my['uid'] . "','" . $g['ip'] . "','" . $_referer . "','" . $g['agent'] . "','" . $date['totime'] . "'";
     getDbInsert($table['s_referer'], $_QKEY, $_QVAL);
     $_REFCNT = getDbRows($table['s_referer'], '');
     if ($_REFCNT > 1000000) {
         $_REFOVER = getDbArray($table['s_referer'], '', '*', 'uid', 'asc', $_REFCNT - 1000000, 1);
         while ($_REFK = db_fetch_array($_REFOVER)) {
             getDbDelete($table['s_referer'], $_REFK['uid']);
         }
     }
     if ($_outkeyw) {
         $_OUTKEY = getDbData($table['s_outkey'], 'site=' . $s . " and date='" . $date['today'] . "' and keyword='" . $_outkeyw . "'", '*');
         if ($_OUTKEY['uid']) {
             getDbUpdate($table['s_outkey'], $_sengine . '=' . $_sengine . '+1,total=total+1', 'uid=' . $_OUTKEY['uid']);
         } else {
             getDbInsert($table['s_outkey'], 'site,date,keyword,' . $_sengine . ',total', "'" . $s . "','" . $date['today'] . "','" . $_outkeyw . "','1','1'");
         }
     }
     $_ISBROWER = getDbData($table['s_browser'], 'site=' . $s . " and date='" . $date['today'] . "' and browser='" . $_browser . "'", '*');
     if ($_ISBROWER['uid']) {
         getDbUpdate($table['s_browser'], 'hit=hit+1', 'uid=' . $_ISBROWER['uid']);
     } else {
         getDbInsert($table['s_browser'], 'site,date,browser,hit', "'" . $s . "','" . $date['today'] . "','" . $_browser . "','1'");

Example #13

File: action.func.php Project: kieregh/test_comment

function DeletePlace($R)
{
    global $table;
    getDbDelete($table['s_place'], 'parent=' . $R['uid']);
}

Example #14

File: a.sosok_delete.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
getDbDelete($table['s_mbrgroup'], 'uid=' . $uid);
getLink('reload', 'parent.', '', '');

Example #15

File: a.module_delete.php Project: hanacody/rb2

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
$R = getDbData($table['s_module'], "id='" . $moduleid . "'", '*');
if (!$R['id']) {
    getLink('', '', '존재하지 않는 모듈입니다.', '');
}
if ($R['system']) {
    getLink('', '', '시스템모듈은 삭제할 수 없습니다.', '');
}
getDbDelete($table['s_module'], "id='" . $moduleid . "'");
include_once $g['path_core'] . 'function/dir.func.php';
$table_db = $g['path_module'] . $moduleid . '/_setting/db.table.php.done';
$_tmptfile = $g['path_var'] . 'table.info.php';
if (is_file($table_db)) {
    $module = $moduleid;
    $_table = $table;
    $table = array();
    include_once $table_db;
    $fp = fopen($_tmptfile, 'w');
    fwrite($fp, "<?php\n");
    foreach ($_table as $key => $val) {
        if (!$table[$key]) {
            fwrite($fp, "\$table['{$key}'] = \"{$val}\";\n");
        }
    }
    fwrite($fp, "?>");
    fclose($fp);

Example #16

File: a.category_delete.php Project: hanacody/rb2

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['uid'] || $category < 1) {
    getLink('', '', _LANG('a0001', 'mediaset'), '');
}
$_CT = getUidData($table['s_uploadcat'], $category);
if (!$_CT['uid']) {
    getLink('', '', _LANG('a0001', 'mediaset'), '');
}
if ($my['uid'] != $_CT['mbruid']) {
    getLink('', '', _LANG('a1001', 'mediaset'), '');
}
getDbDelete($table['s_uploadcat'], 'uid=' . $_CT['uid']);
getDbUpdate($table['s_uploadcat'], 'r_num=r_num+' . $_CT['r_num'], "mbruid=" . $my['uid'] . " and type=" . $ablum_type . " and name='trash'");
getDbUpdate($table['s_upload'], 'category=-1', 'category=' . $_CT['uid']);
getLink('reload', 'parent.', '', '');

Example #17

File: a.multi_delete.php Project: kieregh/test_comment

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
foreach ($object_members as $val) {
    getDbDelete($table[$m . 'object'], 'uid=' . $val);
}
getLink('reload', 'parent.', '', '');

Example #18

File: a.multi_delete.php Project: hanacody/rb2

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
if ($deltype == 'all') {
    getDbDelete($table['s_notice'], 'mbruid=' . $my['uid']);
    getDbUpdate($table['s_mbrdata'], 'num_notice=0', 'memberuid=' . $my['uid']);
} else {
    if ($deltype == 'read') {
        getDbDelete($table['s_notice'], 'mbruid=' . $my['uid'] . " and d_read<>''");
        getDbUpdate($table['s_mbrdata'], 'num_notice=' . getDbRows($table['s_notice'], 'mbruid=' . $my['uid'] . " and d_read=''"), 'memberuid=' . $my['uid']);
    } else {
        // 관리자모드 선택삭제
        foreach ($noti_members as $val) {
            $NT = getDbData($table['s_notice'], "uid='" . $val . "'", 'uid,mbruid,d_read');
            getDbDelete($table['s_notice'], "uid='" . $NT['uid'] . "'");
            if (!$NT['d_read']) {
                getDbUpdate($table['s_mbrdata'], 'num_notice=' . getDbRows($table['s_notice'], 'mbruid=' . $NT['mbruid'] . " and d_read=''"), 'memberuid=' . $NT['mbruid']);
            }
        }
    }
}
getLink('reload', 'parent.', '', '');

Example #19

File: a.deletebbs.php Project: hoya0704/trevia.co.kr

                    getDbDelete($table['s_tag'], 'uid=' . $_TAG['uid']);
                }
            }
        }
    }
    getDbUpdate($table[$m . 'month'], 'num=num-1', "date='" . substr($_R['d_regis'], 0, 6) . "' and site=" . $_R['site'] . ' and bbs=' . $_R['bbs']);
    getDbUpdate($table[$m . 'day'], 'num=num-1', "date='" . substr($_R['d_regis'], 0, 8) . "' and site=" . $_R['site'] . ' and bbs=' . $_R['bbs']);
    getDbDelete($table['s_trackback'], "parent='" . $_R['bbsid'] . $_R['uid'] . "'");
    if ($_R['point1'] && $_R['mbruid']) {
        getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $_R['mbruid'] . "','0','-" . $_R['point1'] . "','게시물삭제(" . getStrCut($_R['subject'], 15, '') . ")환원','" . $date['totime'] . "'");
        getDbUpdate($table['s_mbrdata'], 'point=point-' . $_R['point1'], 'memberuid=' . $_R['mbruid']);
    }
}
getDbDelete($table[$m . 'idx'], 'bbs=' . $R['uid']);
getDbDelete($table[$m . 'data'], 'bbs=' . $R['uid']);
getDbDelete($table[$m . 'list'], 'uid=' . $R['uid']);
unlink($g['dir_module'] . 'var/var.' . $R['id'] . '.php');
if ($R['imghead'] && is_file($g['dir_module'] . 'var/files/' . $R['imghead'])) {
    unlink($g['dir_module'] . 'var/files/' . $R['imghead']);
}
if ($R['imgfoot'] && is_file($g['dir_module'] . 'var/files/' . $R['imgfoot'])) {
    unlink($g['dir_module'] . 'var/files/' . $R['imgfoot']);
}
$mfile = $g['dir_module'] . 'var/code/' . $R['id'];
if (is_file($mfile . '.header.php')) {
    unlink($mfile . '.header.php');
}
if (is_file($mfile . '.footer.php')) {
    unlink($mfile . '.footer.php');
}
getLink('reload', 'parent.', '', '');

Example #20

File: a.multi_delete_user.php Project: hanacody/rb2

}
if (!$my['uid']) {
    getLink('', '', _LANG('block', 'notification'), '');
}
if ($deltype == 'delete_all') {
    getDbDelete($table['s_notice'], 'mbruid=' . $my['uid']);
    getDbUpdate($table['s_mbrdata'], 'num_notice=0', 'memberuid=' . $my['uid']);
} else {
    if ($deltype == 'delete_read') {
        getDbDelete($table['s_notice'], 'mbruid=' . $my['uid'] . " and d_read<>''");
        getDbUpdate($table['s_mbrdata'], 'num_notice=' . getDbRows($table['s_notice'], 'mbruid=' . $my['uid'] . " and d_read=''"), 'memberuid=' . $my['uid']);
    } else {
        if ($deltype == 'delete_select') {
            foreach ($noti_members as $val) {
                $exp = explode('|', $val);
                getDbDelete($table['s_notice'], "uid='" . $exp[0] . "' and mbruid=" . $my['uid']);
            }
            getDbUpdate($table['s_mbrdata'], 'num_notice=' . getDbRows($table['s_notice'], 'mbruid=' . $my['uid'] . " and d_read=''"), 'memberuid=' . $my['uid']);
        } else {
            if ($deltype == 'cut_member') {
                $NT_DATA = explode('|', $my['noticeconf']);
                $nt_members = $NT_DATA[4];
                foreach ($noti_members as $val) {
                    $exp = explode('|', $val);
                    if (!$exp[1]) {
                        continue;
                    }
                    if ($exp[1] == $my['uid']) {
                        $isMe = true;
                        continue;
                    }

Example #21

File: a.deletebbs.php Project: kiminmug/rb_module_bbs

            }
        }
    }
    getDbUpdate($table[$m . 'month'], 'num=num-1', "date='" . substr($_R['d_regis'], 0, 6) . "' and site=" . $_R['site'] . ' and bbs=' . $_R['bbs']);
    getDbUpdate($table[$m . 'day'], 'num=num-1', "date='" . substr($_R['d_regis'], 0, 8) . "' and site=" . $_R['site'] . ' and bbs=' . $_R['bbs']);
    getDbDelete($table['s_trackback'], "parent='" . $_R['bbsid'] . $_R['uid'] . "'");
    if ($_R['point1'] && $_R['mbruid']) {
        getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $_R['mbruid'] . "','0','-" . $_R['point1'] . "','게시물삭제(" . getStrCut($_R['subject'], 15, '') . ")환원','" . $date['totime'] . "'");
        getDbUpdate($table['s_mbrdata'], 'point=point-' . $_R['point1'], 'memberuid=' . $_R['mbruid']);
    }
}
getDbDelete($table[$m . 'idx'], 'bbs=' . $R['uid']);
getDbDelete($table[$m . 'data'], 'bbs=' . $R['uid']);
getDbDelete($table[$m . 'list'], 'uid=' . $R['uid']);
getDbDelete($table[$m . 'xtra'], 'bbs=' . $R['uid']);
getDbDelete($table['s_seo'], 'rel=3 and parent=' . $R['uid']);
unlink($g['dir_module'] . 'var/var.' . $R['id'] . '.php');
if ($R['imghead'] && is_file($g['dir_module'] . 'var/files/' . $R['imghead'])) {
    unlink($g['dir_module'] . 'var/files/' . $R['imghead']);
}
if ($R['imgfoot'] && is_file($g['dir_module'] . 'var/files/' . $R['imgfoot'])) {
    unlink($g['dir_module'] . 'var/files/' . $R['imgfoot']);
}
$mfile = $g['dir_module'] . 'var/code/' . $R['id'];
if (is_file($mfile . '.header.php')) {
    unlink($mfile . '.header.php');
}
if (is_file($mfile . '.footer.php')) {
    unlink($mfile . '.footer.php');
}
getLink('reload', 'parent.', '', '');

Example #22

File: a.admin_action.php Project: hoya0704/trevia.co.kr

     if ($level != $M['level']) {
         getDbUpdate($table['s_mbrdata'], 'level=' . $level, 'memberuid=' . $M['memberuid']);
         getDbUpdate($table['s_mbrlevel'], 'num=num-1', 'uid=' . $M['level']);
         getDbUpdate($table['s_mbrlevel'], 'num=num+1', 'uid=' . $level);
     }
 }
 //회원삭제
 if ($act == 'tool_delete') {
     getDbDelete($table['s_mbrid'], 'uid=' . $M['memberuid']);
     getDbDelete($table['s_mbrdata'], 'memberuid=' . $M['memberuid']);
     getDbDelete($table['s_mbrcomp'], 'memberuid=' . $M['memberuid']);
     getDbDelete($table['s_paper'], 'my_mbruid=' . $M['memberuid']);
     getDbDelete($table['s_point'], 'my_mbruid=' . $M['memberuid']);
     getDbDelete($table['s_scrap'], 'mbruid=' . $M['memberuid']);
     getDbDelete($table['s_simbol'], 'mbruid=' . $M['memberuid']);
     getDbDelete($table['s_friend'], 'my_mbruid=' . $M['memberuid'] . ' or by_mbruid=' . $M['memberuid']);
     getDbUpdate($table['s_mbrlevel'], 'num=num-1', 'uid=' . $M['level']);
     getDbUpdate($table['s_mbrgroup'], 'num=num-1', 'uid=' . $M['sosok']);
     if (is_file($g['path_var'] . 'simbol/' . $M['photo'])) {
         unlink($g['path_var'] . 'simbol/' . $M['photo']);
     }
     $fp = fopen($g['path_tmp'] . 'out/' . $M['id'] . '.txt', 'w');
     fwrite($fp, $date['totime']);
     fclose($fp);
     @chmod($g['path_tmp'] . 'out/' . $M['id'] . '.txt', 0707);
 }
 //회원탈퇴
 if ($act == 'tool_out') {
     getDbUpdate($table['s_mbrdata'], 'auth=4', 'memberuid=' . $M['memberuid']);
 }
 //포인트지급

Example #23

File: a.bookmark_delete.php Project: eosliebe/rb

    $bookmark_rcd = getDbData($table['s_admpage'], 'memberuid=' . $memberuid . " and url='" . $url . "'", 'uid');
    $bookmark_uid = $bookmark_rcd['uid'];
    if (!$bookmark_uid) {
        getLink('', '', '등록되지 않았거나 이미 삭제된 북마크입니다.', '');
    }
    getDbDelete($table['s_admpage'], 'uid=' . $bookmark_uid);
    ?>
	<script>
	parent.getId('_bookmark_star_').className = 'fa fa-lg fa-star-o';
	parent.getId('_bookmark_notyet_').className = 'btn-group btn-group-sm dropdown';
	parent.getId('_bookmark_already_').className = 'btn-group btn-group-sm dropdown hidden';
	parent.getId('_now_bookmark_<?php 
    echo $bookmark_uid;
    ?>
').className = 'list-group-item hidden';
	<?php 
    if (!getDbRows($table['s_admpage'], 'memberuid=' . $my['uid'])) {
        ?>
	parent.getId('_add_bookmark_').innerHTML = '<a class="list-group-item"><i class="fa fa-fw fa-file-text-o"></i>등록된 북마크가 없습니다</a>';
	<?php 
    }
    ?>
	</script>
	<?php 
    exit;
} else {
    foreach ($bookmark_pages as $val) {
        getDbDelete($table['s_admpage'], 'uid=' . $val . ' and memberuid=' . $my['uid']);
    }
    getLink('reload', 'parent.', '', '');
}

Example #24

File: a.admin_delete.php Project: hanacody/rb2

 }
 $M1 = getDbData($table['s_mbrdata'], 'memberuid=' . $val, '*');
 $M2 = getUidData($table['s_mbrid'], $val);
 if ($auth) {
     if ($auth == 'D') {
         getDbDelete($table['s_mbrid'], 'uid=' . $M1['memberuid']);
         getDbDelete($table['s_mbrdata'], 'memberuid=' . $M1['memberuid']);
         getDbDelete($table['s_mbrcomp'], 'memberuid=' . $M1['memberuid']);
         getDbDelete($table['s_paper'], 'my_mbruid=' . $M1['memberuid']);
         getDbDelete($table['s_point'], 'my_mbruid=' . $M1['memberuid']);
         getDbDelete($table['s_scrap'], 'mbruid=' . $M1['memberuid']);
         getDbDelete($table['s_simbol'], 'mbruid=' . $M1['memberuid']);
         getDbDelete($table['s_friend'], 'my_mbruid=' . $M1['memberuid'] . ' or by_mbruid=' . $M1['memberuid']);
         getDbUpdate($table['s_mbrlevel'], 'num=num-1', 'uid=' . $M1['level']);
         getDbUpdate($table['s_mbrgroup'], 'num=num-1', 'uid=' . $M1['mygroup']);
         getDbDelete($table['s_mbrsns'], 'memberuid=' . $M1['memberuid']);
         if (is_file($g['path_var'] . 'avatar/' . $M1['photo'])) {
             unlink($g['path_var'] . 'avatar/' . $M1['photo']);
         }
         if (is_file($g['path_var'] . 'avatar/180.' . $M1['photo'])) {
             unlink($g['path_var'] . 'avatar/180.' . $M1['photo']);
         }
         $fp = fopen($g['path_tmp'] . 'out/' . $M2['id'] . '.txt', 'w');
         fwrite($fp, $date['totime']);
         fclose($fp);
         @chmod($g['path_tmp'] . 'out/' . $M2['id'] . '.txt', 0707);
     } else {
         if ($auth == 'A') {
             getDbUpdate($table['s_mbrdata'], "admin=1,adm_view='[admin]'", 'memberuid=' . $M2['uid']);
         } else {
             getDbUpdate($table['s_mbrdata'], "auth='{$auth}'", 'memberuid=' . $M2['uid']);

Example #25

File: a.delete.php Project: hoya0704/trevia.co.kr

if ($R['tag']) {
    $_tagdate = substr($R['d_regis'], 0, 8);
    $_tagarr1 = explode(',', $R['tag']);
    foreach ($_tagarr1 as $_t) {
        if (!$_t) {
            continue;
        }
        $_TAG = getDbData($table['s_tag'], "site=" . $R['site'] . " and date='" . $_tagdate . "' and keyword='" . $_t . "'", '*');
        if ($_TAG['uid']) {
            if ($_TAG['hit'] > 1) {
                getDbUpdate($table['s_tag'], 'hit=hit-1', 'uid=' . $_TAG['uid']);
            } else {
                getDbDelete($table['s_tag'], 'uid=' . $_TAG['uid']);
            }
        }
    }
}
getDbUpdate($table[$m . 'month'], 'num=num-1', "date='" . substr($R['d_regis'], 0, 6) . "' and site=" . $R['site'] . ' and bbs=' . $R['bbs']);
getDbUpdate($table[$m . 'day'], 'num=num-1', "date='" . substr($R['d_regis'], 0, 8) . "' and site=" . $R['site'] . ' and bbs=' . $R['bbs']);
getDbDelete($table[$m . 'idx'], 'gid=' . $R['gid']);
getDbDelete($table[$m . 'data'], 'uid=' . $R['uid']);
getDbUpdate($table[$m . 'list'], 'num_r=num_r-1', 'uid=' . $R['bbs']);
if ($cuid) {
    getDbUpdate($table['s_menu'], "num='" . getDbCnt($table[$m . 'month'], 'sum(num)', 'site=' . $s . ' and bbs=' . $R['bbs']) . "'", 'uid=' . $cuid);
}
getDbDelete($table['s_trackback'], "parent='" . $R['bbsid'] . $R['uid'] . "'");
if ($R['point1'] && $R['mbruid']) {
    getDbInsert($table['s_point'], 'my_mbruid,by_mbruid,price,content,d_regis', "'" . $R['mbruid'] . "','0','-" . $R['point1'] . "','게시물삭제(" . getStrCut($R['subject'], 15, '') . ")환원','" . $date['totime'] . "'");
    getDbUpdate($table['s_mbrdata'], 'point=point-' . $R['point1'], 'memberuid=' . $R['mbruid']);
}
getLink($backUrl, 'parent.', $alert, $history);

Example #26

File: a.delete_attach.php Project: kiminmug/rb_module_bbs

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
$U = getUidData($table[$m . 'upload'], $uid);
if ($U['uid']) {
    getDbUpdate($table['s_numinfo'], 'upload=upload-1', "date='" . substr($U['d_regis'], 0, 8) . "' and site=" . $U['site']);
    getDbDelete($table[$m . 'upload'], 'uid=' . $U['uid']);
    if ($U['url'] == $d['mediaset']['ftp_urlpath']) {
        $FTP_CONNECT = ftp_connect($d['mediaset']['ftp_host'], $d['mediaset']['ftp_port']);
        $FTP_CRESULT = ftp_login($FTP_CONNECT, $d['mediaset']['ftp_user'], $d['mediaset']['ftp_pass']);
        if (!$FTP_CONNECT) {
            getLink('', '', 'FTP서버 연결에 문제가 발생했습니다.', '');
        }
        if (!$FTP_CRESULT) {
            getLink('', '', 'FTP서버 아이디나 패스워드가 일치하지 않습니다.', '');
        }
        if ($d['mediaset']['ftp_pasv']) {
            ftp_pasv($FTP_CONNECT, true);
        }
        ftp_delete($FTP_CONNECT, $d['mediaset']['ftp_folder'] . $U['folder'] . '/' . $U['tmpname']);
        if ($U['type'] == 2) {
            ftp_delete($FTP_CONNECT, $d['mediaset']['ftp_folder'] . $U['folder'] . '/' . $U['thumbname']);
        }
        ftp_close($FTP_CONNECT);
    } else {
        unlink('./modules/bbs/upload/' . $U['folder'] . '/' . $U['tmpname']);
        if ($U['type'] == 2) {
            unlink('./modules/bbs/upload/' . $U['folder'] . '/' . $U['thumbname']);

Example #27

File: a.deletesite.php Project: eosliebe/rb

if ($R['uid']) {
    getDbDelete($table['s_start'], 'site=' . $R['uid']);
    getDbDelete($table['s_site'], 'uid=' . $R['uid']);
    $_MENUS = getDbSelect($table['s_menu'], 'site=' . $R['uid'] . ' order by gid asc', '*');
    while ($_M = db_fetch_array($_MENUS)) {
        $_xfile = $g['path_page'] . 'menu/' . sprintf('%05d', $_M['uid']);
        unlink($_xfile . '.php');
        unlink($_xfile . '.widget.php');
        @unlink($_xfile . '.mobile.php');
        @unlink($_xfile . '.css');
        @unlink($_xfile . '.js');
        @unlink($_xfile . '.header.php');
        @unlink($_xfile . '.footer.php');
        @unlink($_xfile . '.txt');
        @unlink($_xfile . '.cache');
        @unlink($_xfile . '.widget.cache');
        @unlink($_xfile . '.mobile.cache');
        @unlink($g['path_var'] . 'menu/' . $_M['imghead']);
        @unlink($g['path_var'] . 'menu/' . $_M['imgfoot']);
        getDbDelete($table['s_seo'], 'rel=1 and parent=' . $_M['uid']);
    }
    getDbDelete($table['s_menu'], 'site=' . $R['uid']);
    db_query("OPTIMIZE TABLE " . $table['s_site'], $DB_CONNECT);
    db_query("OPTIMIZE TABLE " . $table['s_menu'], $DB_CONNECT);
    unlink($g['path_var'] . 'sitephp/' . $account . '.php');
}
if (!getDbRows($table['s_site'], '')) {
    getLink($g['s'] . '/', 'parent.parent.', '', '');
} else {
    getLink($g['s'] . '/?m=admin&module=' . $m, 'parent.', '', '');
}

Example #28

File: a.point_delete.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
if (!$my['uid']) {
    getLink('', '', '정상적인 접근이 아닙니다.', '');
}
$pointType = $pointType ? $pointType : 'point';
if ($my['admin']) {
    foreach ($members as $val) {
        $P = getUidData($table['s_' . $pointType], $val);
        if (!$P['uid']) {
            continue;
        }
        getDbDelete($table['s_' . $pointType], 'uid=' . $P['uid']);
        //getDbUpdate($table['s_mbrdata'],$pointType.'='.$pointType.'-'.$P['price'],'memberuid='.$P['my_mbruid']);
    }
} else {
    foreach ($members as $val) {
        $P = getUidData($table['s_' . $pointType], $val);
        if (!$P['uid'] || $my['uid'] != $P['my_mbruid']) {
            continue;
        }
        getDbDelete($table['s_' . $pointType], 'uid=' . $R['uid'] . ' and my_mbruid=' . $my['uid']);
        //getDbUpdate($table['s_mbrdata'],$pointType.'='.$pointType.'-'.$P['price'],'memberuid='.$my['uid']);
    }
}
getLink('reload', 'parent.', '', '');

Example #29

File: a.multi_oneline_delete.php Project: hoya0704/trevia.co.kr

<?php

if (!defined('__KIMS__')) {
    exit;
}
checkAdmin(0);
foreach ($oneline_members as $val) {
    $R = getUidData($table['s_oneline'], $val);
    if (!$R['uid']) {
        continue;
    }
    $C = getUidData($table['s_comment'], $R['parent']);
    getDbDelete($table['s_oneline'], 'uid=' . $R['uid']);
    getDbUpdate($table['s_comment'], 'oneline=oneline-1', 'uid=' . $C['uid']);
    getDbUpdate($table['s_numinfo'], 'oneline=oneline-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(str_replace('&amp;', ' ', strip_tags($R['content'])), 15, '') . ")환원','" . $date['totime'] . "'");
        getDbUpdate($table['s_mbrdata'], 'point=point-' . $R['point'], 'memberuid=' . $R['mbruid']);
    }
    //동기화
    $cyncArr = getArrayString($C['cync']);
    $fdexp = explode(',', $cyncArr['data'][2]);
    if ($fdexp[0] && $fdexp[2] && $cyncArr['data'][3]) {
        getDbUpdate($cyncArr['data'][3], $fdexp[2] . '=' . $fdexp[2] . '-1', $fdexp[0] . '=' . $cyncArr['data'][1]);
    }
}
getLink('reload', 'parent.', '', '');

Example #30

File: a.out.php Project: hoya0704/trevia.co.kr

include_once $g['dir_module'] . 'var/var.join.php';
if (!$my['uid'] || !$pw1 || !$pw2 || $pw1 != $pw2) {
    getLink('', '', '정상적인 접근이 아닙니다.', '');
}
if (md5($pw1) != $my['pw']) {
    getLink('', '', '패스워드가 일치하지 않습니다.', '');
}
if ($d['member']['join_out'] == 1) {
    getDbDelete($table['s_mbrid'], 'uid=' . $my['uid']);
    getDbDelete($table['s_mbrdata'], 'memberuid=' . $my['uid']);
    getDbDelete($table['s_mbrcomp'], 'memberuid=' . $my['uid']);
    getDbDelete($table['s_paper'], 'my_mbruid=' . $my['uid']);
    getDbDelete($table['s_point'], 'my_mbruid=' . $my['uid']);
    getDbDelete($table['s_scrap'], 'mbruid=' . $my['uid']);
    getDbDelete($table['s_simbol'], 'mbruid=' . $my['uid']);
    getDbDelete($table['s_friend'], 'my_mbruid=' . $my['uid'] . ' or by_mbruid=' . $my['uid']);
    getDbUpdate($table['s_mbrlevel'], 'num=num-1', 'uid=' . $my['level']);
    getDbUpdate($table['s_mbrgroup'], 'num=num-1', 'uid=' . $my['sosok']);
    if (is_file($g['path_var'] . 'simbol/' . $my['photo'])) {
        unlink($g['path_var'] . 'simbol/' . $my['photo']);
    }
    $fp = fopen($g['path_tmp'] . 'out/' . $my['id'] . '.txt', 'w');
    fwrite($fp, $date['totime']);
    fclose($fp);
    @chmod($g['path_tmp'] . 'out/' . $my['id'] . '.txt', 0707);
} else {
    getDbUpdate($table['s_mbrdata'], 'auth=4', 'memberuid=' . $my['uid']);
}
getDbUpdate($table['s_numinfo'], 'mbrout=mbrout-1', "date='" . $date['today'] . "' and site=" . $s);
setcookie('svshop', '', 0, '/');
$_SESSION['mbr_uid'] = '';