// ȸ¿øÂ÷´Ü - ±¸´©º¸µå
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}";