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 = 3; $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' ) ) ); ?>
sqlResult( $sql ); $i = 0; while( $row = $objdb->sqlfetch($rs) ) { $dbno = $row[no]; $dbtitle = $row[title]; $dbwriter = $row[writer]; $dbwdate = $row[listdate]; $dbreadnum = $row[readnum]; $dblevelno = $row[levelno]; $dbclipfile = $row[clipfile]; $dbchkmain = $row[chkmain]; $dbchunum = nf($row[chunum]); $dbchklock = $row[chklock]; $dbmemberid = $row[memberid]; $dbmemberlevel = $row[memberlevel]; $dbclipfile = $row[clipfile]; $dbchkbold = $row[chkbold]; $dbtitle_color = $row[title_color]; $point_ok = $row[point_ok]; $admin_write = $row[admin_write]; $cate_idx = $row[cate_idx]; if( $_BBS_ADMINIMG_CHK == "y" && $admin_write && is_file( $DOCUMENT_ROOT."/menu_image/".$_BBS_ADMINIMG ) ) { $dbwriter = make_img( "/menu_image/".$_BBS_ADMINIMG, 80, 30 ); } // 레벨아이콘 if( $dbmemberlevel && !$admin_write ) { $dbwriter = make_img( "/menu_image/".$level[$dbmemberlevel][levelicon], 14, 14 )." ".$dbwriter; } $sql = "SELECT COUNT( * ) FROM $TBLBA ". "WHERE pno = '".$dbno."' AND bbsid = '".$_REQUEST[bbs]."'"; $cnt = $objdb->sqlRowOne( $sql ); $dbcnt = nf( $cnt ); if( $dblevelno ) { echo str_repeat( "  ", $dblevelno )."$_ICOre01"; } $dbtitle = $objfunc->hancut( $dbtitle, 55 ); if( $dbchkbold == "y" ) $dbtitle = "".$dbtitle.""; if( $dbtitle_color ) $dbtitle = "".$dbtitle.""; if( $keyword ) { switch( $sl_search ) { case "title" : $dbtitle = keywordReplace( $keyword, $dbtitle ); break; case "writer" : $dbwriter = keywordReplace( $keyword, $dbwriter ); break; } } if( $dbchkmain == "y" ) $dbtitle = "".$dbtitle.""; if( $dbchkboardlock != "y" || $dbchklock != "y" || ( $dbmemberid && $dbmemberid == $_USERID ) ) { $bbsurl = "/user_page/productView.html?no=".$dbno.$addedQry; } else { $bbsurl = "/shopuser/etc/bbsPw.html?no=".$dbno."&type=check".$addedQry; } $good_name = ''; if( $row['g_code'] ) { $sql = "SELECT name FROM good ". "WHERE code = '".$objdb->esc($row['g_code'])."' AND chkmain = 1"; $good_name = $objdb->row1($sql); $good_name = ''.$good_name.'
'; $good_link = '/shopuser/goods/productView.html?code='.$row['g_code']; } ?>
sqlResult($sql); while( $row = $objdb->sqlFetch($rs) ){ ?>
[".$nameCate[$cate_idx]."] " : "" ?>
hanCut( $row[content], 55 ) $sql = "SELECT summary FROM bbs_summary WHERE no = '".$row[no]."' AND bbsid = 'daeha01'"; $dbsummary = $objdb->sqlRowOne($sql); ?> hanCut( $dbsummary, 55 )?>
등록된 게시물이 없습니다.
adminpaging( $PageNo, $PageSize,$totalRows, "", $qrystring );?>