include $_SERVER['DOCUMENT_ROOT']."/include/config.inc.php";
include $_SERVER['DOCUMENT_ROOT']."/page_inc/top.inc.php";
include $DOCUMENT_ROOT."/lib/file.icon.lib.php";
if( is_file($DOCUMENT_ROOT."/config/board.conf.php") ) include $DOCUMENT_ROOT."/config/board.conf.php";
$TBLB = "bbs";
$TBLBA = "bbs_answer";
$TBLBC = "bbs_category";
$TBLBCC = "bbs_chuchun";
$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];
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" );
if( $_REQUEST[mode] == "insertAnswer" ) {
// 모든 변수가 정상적으로 있는지 확인
$chkInsert = true;
if( !$_REQUEST[no] ) $chkInsert = false;
if( !$_REQUEST[ans_writer] ) $chkInsert = false;
if( !$_REQUEST[ans_passwd] ) $chkInsert = false;
if( !$_REQUEST[ans_content] ) $chkInsert = false;
if( !$_REQUEST[bbs] ) $chkInsert = false;
if( !$chkInsert ) exit;
// 부모글이없으면 댓글등록 방지 by DGOH in 080721
$sql = "SELECT count(no) FROM $TBLB WHERE no = '".$_REQUEST[no]."' and bbsid = '".$_REQUEST[bbs]."'";
$cntNo = $objdb->sqlRowOne($sql);
if(!$cntNo) exit;
$sql = "SELECT MAX( no ) FROM $TBLBA";
$maxno = $objdb->sqlMaxNo( $sql );
$sql = "INSERT INTO $TBLBA ( ".
"no, pno, id, writer, passwd, content, bbsid, wdate, level ".
") VALUES ( ".
"'".$maxno."', '".$_REQUEST[no]."', '".$_USERID."', '".$_REQUEST[ans_writer]."', '".$_REQUEST[ans_passwd]."', '".$_REQUEST[ans_content]."', '".$_REQUEST[bbs]."', SYSDATE(), '".$_USERLEVELNO."' ".
")";
$objdb->sqlExe( $sql );
$objfunc->reloadParent();
}
else if( $_REQUEST[mode] == "deleteAnswer" ) {
if( $_USERID ) {
$sql = "SELECT id FROM $TBLBA ".
"WHERE bbsid = '".$_REQUEST[bbs]."' AND no = '".$_REQUEST[ans_no]."'";
$dbid = $objdb->sqlRowOne( $sql );
if( $_USERID != $dbid ) {
$objfunc->alert( "삭제할 권한이 없습니다." );
}
}
else {
if( trim( $_REQUEST[ans_passwd] ) == "" ) {
$objfunc->alert( "비밀번호가 비었습니다." );
}
$sql = "SELECT passwd FROM $TBLBA ".
"WHERE bbsid = '".$_REQUEST[bbs]."' AND no = '".$_REQUEST[ans_no]."'";
$dbpasswd = $objdb->sqlRowOne( $sql );
if( $_REQUEST[ans_passwd] != $dbpasswd && $_REQUEST[ans_passwd] != $_MASTERPASS ) {
$objfunc->alert( "비밀번호가 틀렸습니다." );
}
}
$sql = "DELETE FROM $TBLBA ".
"WHERE bbsid = '".$_REQUEST[bbs]."' AND no = '".$_REQUEST[ans_no]."'";
$objdb->sqlExe( $sql );
$objfunc->reloadParent();
}
$sql = "SELECT no, memberid, passwd, clipfile, refno FROM $TBLB ".
"WHERE no = '".$_REQUEST[no]."' AND bbsid = '".$_REQUEST[bbs]."'";
$row = $objdb->sqlRow( $sql );
$dbno = $row[no];
$dbpasswd = $row[passwd];
$dbclipfile = $row[clipfile];
$dbrefno = $row[refno];
// no 에 해당하는 데이타가 없으면 강제로 리스트로 보낸다.
if( !$dbno ) {
$objfunc->goUrl( "bbsList.html?bbs=".$_REQUEST[bbs] );
}
if( $dbrefno ) {
$sql = "SELECT passwd FROM $TBLB ".
"WHERE no = '".$dbrefno."' AND bbsid = '".$bbs."'";
$refpasswd = $objdb->sqlRowone( $sql );
}
if( $mode == "check" && $check != "ok" ) {
if( !( $passwd == $dbpasswd || ( $refpasswd && $passwd == $refpasswd ) || $passwd == $_MASTERPASS ) ) {
$objfunc->alertBack( "비밀번호가 틀렸습니다." );
}
}
if( $dbprivread == "y" && empty( $_USERID ) ) {
LoginRedirect( $_SERVER["PHP_SELF"]."?no=".$no."&bbs=".$bbs."&PageNo=".$PageNo );
}
if( $dbchkboardlock == "y" ) {
$sql = "SELECT memberid, chklock FROM $TBLB ".
"WHERE no = '".$no."' AND bbsid = '".$bbs."'";
$row = $objdb->sqlRow( $sql );
$dbchklock = $row[chklock];
$dbmemberid = $row[memberid];
if( $dbchklock == "y" && $mode != "check" && !( $_USERID && $_USERID == $dbmemberid ) ) {
$objfunc->goUrl( "bbsPw.html?bbs=".$bbs."&no=".$no."&type=check&PageNo=".$PageNo );
}
}
if( !eregi( $PHP_SELF, $HTTP_REFERER ) ) {
$sql = "UPDATE $TBLB SET ".
"readnum = readnum + 1 ".
"WHERE no = '".$no."' AND bbsid = '".$bbs."'";
$objdb->sqlExe( $sql );
}
$sql = "SELECT * FROM $TBLBC ".
"WHERE bbsid = '".$_REQUEST[bbs]."' ".
"ORDER BY sortno";
$dataCate = $objdb->sqlArray( $sql );
foreach( $dataCate as $k => $data ) {
$nameCate[$data[cate_idx]] = $data[cate_name];
}
?>
sqlRow( $sql );
$dbtitle = $row[title];
$dbwriter = $row[writer];
$dbhtmlcheck = $row[htmlcheck];
$dbwdate = $row[wdate];
$dbcontent = $row[content];
$dbclipfile = $row[clipfile];
$dbrefno = $row[refno];
$dbreadnum = $row[readnum];
$dbchunum = $row[chunum];
$dbsortno = $row[sortno];
$dbmemberid = $row[memberid];
$dbmemberlevel = $row[memberlevel];
$dbchkbold = $row[chkbold];
$dbtitle_color = $row[title_color];
$admin_write = $row[admin_write];
$cate_idx = $row[cate_idx];
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;
case "content" :
if( $dbhtmlcheck != "y" ) {
$dbcontent = keywordReplace( $keyword, $dbcontent );
}
break;
}
}
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;
}
?>
$code = $row['g_code'];
include 'bbsGood.inc.html';
?>
|
|
= $dbtitle ?> |
|
|
|
|
= space2br( $dbwdate ) ?> |
|
|
= $objfunc->htmlText( $dbcontent, $dbhtmlcheck ) ?> |
|
|
if( ( $dbprivanswer == "y" && $_USERID ) || !in_array( $dbprivanswer, array( "a", "y" ) ) ) { ?>
|
} ?>
|
$sql = "SELECT * FROM $TBLBA ".
"WHERE pno = '".$_REQUEST[no]."' AND bbsid = '".$_REQUEST[bbs]."' ".
"ORDER BY no desc" ;
$rs = $objdb->sqlResult( $sql );
while( $row = $objdb->sqlFetch( $rs ) ) {
$dbans_no = $row[no];
$dbid = $row[id];
$dbwriter = $row[writer];
$dbcontent = $row[content];
$dbwdate = $row[wdate];
$admin_write = $row[admin_write];
$dblevel = $row[level];
$dateArr = explode( " ", $dbwdate );
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( $dblevel && !$admin_write ) {
$dbwriter = make_img( "/menu_image/".$level[$dblevel][levelicon], 14, 14 )." ".$dbwriter;
}
?>
=$dbwriter?> |
|
=$dateArr[0]?> =$dateArr[1]?> |
= $objfunc->htmlText( $dbcontent, "n" ) ?> |
|
|
|
|
}?>
|
|
|
"> |
|
include $_SERVER['DOCUMENT_ROOT']."/page_inc/bottom.inc.php";
?>