|
|
|
$sql = "SELECT * FROM bbs_category WHERE bbsid = 'daeha01' ORDER BY sortno";
$rs = $objdb->sqlResult($sql);
while( $row = $objdb->sqlFetch($rs) ){
?>
}?>
|
|
|
$sql = "SELECT ".
"no, title, writer, writer_img, DATE_FORMAT( wdate, '%Y.%m.%d' ) AS listdate, wdate, readnum, ".
"levelno, clipfile, chkmain, chunum, chklock, memberid, memberlevel, ".
"chkbold, title_color, point_ok, content, htmlcheck, admin_write, cate_idx, g_code, content ".
"FROM $TBLB ".
"WHERE bbsid = '".$bbs."' $WHEREQRY $CATEQRY ".
"ORDER BY chkmain DESC, sortno DESC ".
"LIMIT $START, $PageSize";
$rs = $objdb->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'];
}
?>
|
}?>
|
$i++;
}
if( $i == 0 ) {
?>
등록된 게시물이 없습니다. |
}?>
$objfunc->adminpaging( $PageNo, $PageSize,$totalRows, "", $qrystring );?>
|
|