include $_SERVER['DOCUMENT_ROOT']."/include/config.inc.php"; include $_SERVER['DOCUMENT_ROOT']."/page_inc/top.inc.php"; include $_SERVER["DOCUMENT_ROOT"]."/include/config.inc.php"; if( is_file( $DOCUMENT_ROOT."/config/board.conf.php" ) ) { include $DOCUMENT_ROOT."/config/board.conf.php"; } $_REQUEST[bbs] = "event"; $bbs = "event"; $TBLB = "bbs"; $TBLBA = "bbs_answer"; $TBLBC = "bbs_category"; $TBLMLT = "memberlevel_tbl"; $saveDir = "/data_file/"; $addedQry = "&bbs=".$_REQUEST[bbs]. "&sl_search=".$_REQUEST[sl_search]. "&keyword=".ue( $_REQUEST[keyword] ). "&srch_cate_idx=".$_REQUEST[srch_cate_idx]. "&PageNo=".$_REQUEST[PageNo]; $qrystring = "&bbs=".$_REQUEST[bbs]. "&sl_search=".$_REQUEST[sl_search]. "&keyword=".ue( $_REQUEST[keyword] ). "&srch_cate_idx=".$_REQUEST[srch_cate_idx]; include $_SERVER["DOCUMENT_ROOT"]."/include/board.inc.php"; // 레벨관련 설정 $sql = "SELECT level, levelicon FROM $TBLMLT ". "WHERE levelicon != '' AND levelicon IS NOT NULL"; $level = $objdb->sqlArray( $sql, "level" ); $sql = "SELECT * FROM $TBLBC ". "WHERE bbsid = '".$bbs."' ". "ORDER BY sortno"; $dataCate = $objdb->sqlArray( $sql ); foreach( $dataCate as $k => $data ) { $nameCate[$data[cate_idx]] = $data[cate_name]; } unset( $QRY ); if( $_REQUEST[keyword] ) { $QRY[] = $_REQUEST[sl_search]." LIKE '%".$_REQUEST[keyword]."%'"; } $WHEREQRY = ""; if( count( $QRY ) ) $WHEREQRY = "AND ".implode( " AND ", $QRY ); unset( $QRY ); if( $_REQUEST[srch_cate_idx] != "" ) { $QRY[] = "cate_idx = '".$_REQUEST[srch_cate_idx]."'"; } $CATEQRY = ""; if( count( $QRY ) ) $CATEQRY = "AND ".implode( " AND ", $QRY ); $sql = "SELECT COUNT( * ) FROM $TBLB ". "WHERE bbsid = '".$bbs."' $WHEREQRY $CATEQRY"; $totalRows = $objdb->sqlRowOne( $sql ); if( empty( $_REQUEST["PageNo"] ) ) $PageNo = 1; else $PageNo = $_REQUEST["PageNo"]; $PageSize = 20; $START = $objfunc->getDbStartNo( $PageNo, $PageSize ); $pointAct = unserialize( stripslashes( $_POINTACT ) ); $newdate = date( "Y-m-d H:i:s", mktime( date( 'H' ) - $dbnewperiod, date( 'i' ), date( 's' ), date( 'm' ), date( 'd' ), date( 'Y' ) ) ); ?>