public static function deleteTerm($terms) { $dbm = \CADB\DBM::instance(); $que = "DELETE FROM {taxonomy_terms} WHERE `cid` = ? AND `tid` = ?"; $dbm->execute($que, array("dd", $terms['cid'], $terms['tid'])); $que = "UPDATE {taxonomy_terms} SET idx = idx - 1 WHERE `cid` = ? AND `parent` = ? AND idx >= ? ORDER BY idx ASC"; $dbm->execute($que, array("ddd", $terms['cid'], $terms['parent'], $terms['idx'])); if ($terms['parent']) { $que = "UPDATE {taxonomy_terms} SET nsubs = nsubs - 1 WHERE `cid` = ? AND `tid` = ?"; $dbm->execute($que, array("dd", $terms['cid'], $terms['parent'])); } self::$log = "분류항목 [" . $terms['name'] . "] 을 삭제했습니다.\n"; \CADB\Log::taxonomytermLog('delete', $terms['cid'], $terms['tid'], $terms['vid'], self::$log); }