// ȸ¿øÂ÷´Ü - ±¸´©º¸µå 0. DB »ý¼º CREATE TABLE IF NOT EXISTS `g5_id_block` ( `mb_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `block_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `date` datetime NOT NULL, UNIQUE KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 1. extend/user.block.id.php 2. plugin/block_id/block.id.php 3. if($mb_id) $str2 .= "Àüü°Ô½Ã¹°\n"; ¸¦ ¾Æ·¡¿Í °°ÀÌ ±³Ã¼ if($mb_id) { $str2 .= "Àüü°Ô½Ã¹°\n"; if($member['mb_id']) $str2 .= "ȸ¿øÂ÷´Ü\n"; } 4. bbs/list.php 30¶óÀÎ Âë¿¡ $sop = strtolower($sop); if ($sop != 'and' && $sop != 'or') $sop = 'and'; À§°Í ¹Ù·Î ¹Ø¿¡ ¾Æ·¡ ¼Ò½º Ãß°¡ // Â÷´Ü ȸ¿ø list °¨Ãß±â if($tmp_block['block_id']) { $sql_search_block = ''; $blocks = explode(',', $tmp_block['block_id']); for ($k=0, $blockc=count($blocks); $k<$blockc; $k++) $sql_search_block .= " and mb_id <> '$blocks[$k]' "; } 5. // ¶ó¿¤´Ô Á¦¾È ÄÚµå·Î ´ëü http://sir.co.kr/bbs/board.php?bo_table=g5_bug&wr_id=2922 $sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} WHERE {$sql_search} {$sql_search_block} "; // {$sql_search_block} Ãß°¡ if ($sca || $stx) { $sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$sql_search_block} {$sql_order} limit {$from_record}, $page_rows "; // {$sql_search_block} Ãß°¡ } else { $sql = " select * from {$write_table} where wr_is_comment = 0 {$sql_search_block}"; // {$sql_search_block} Ãß°¡ 6. ¾Æ·¡ ¼Ò½º¸¦ view.php »ó´Ü¿¡ ³Ö°Å³ª $board_skin_path.'/view.head.skin.php ³Ö´Â´Ù. // Â÷´Ü ȸ¿ø list °¨Ãß±â if($tmp_block['block_id']) { $blocks = explode(',', $tmp_block['block_id']); for ($k=0, $blockc=count($blocks); $k<$blockc; $k++) { if($write['mb_id'] == $blocks[$k]) { echo ' '; break; } } } 7. bbs/new.php : »õ±Û º¸±â¿¡ $g5['title'] = '»õ±Û'; include_once('./_head.php'); À§ ¼Ò½º ¹Ù·Î ¹Ø¿¡ ¾Æ·¡ ¼Ò½º Ãß°¡ // Â÷´Ü ȸ¿ø list °¨Ãß±â if($tmp_block['block_id']) { $sql_search_block = ''; $blocks = explode(',', $tmp_block['block_id']); for ($k=0, $blockc=count($blocks); $k<$blockc; $k++) $sql_search_block .= " and a.mb_id <> '$blocks[$k]' "; } $sql_common = " from {$g5['board_new_table']} a, {$g5['board_table']} b, {$g5['group_table']} c where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = 1 {$sql_search_block}";