$row->name
$row->cdate
$row->reads
No. |
제목 |
작성자 |
작성일 |
조회 |
|---|
";
if(($bbrow->id != $row->id) && ($bbrow->gid == $row->gid)) $s .= mktr($bbrow, '#dddffe', $depthstr);
else {
if($bbrow->id == $row->id) $s .= mktr($bbrow, '#aaaccb', $depthstr);
else $s .= mktr($bbrow,"", $depthstr);
}
}
}
}
$s .= "접근 권한 없음
\n"; $errormsg .= "이 작업은 오직 " . getGroupNames($pgdb,$allowgroups) . " 그룹 회원들만 허용합니다."; include("html/error.php"); exit; } // 페이지 우측 상단 서브 섹션 처리 $res = $pgdb->exec("select * from menus where criteria = '$criteria' and subcrit <> '' order by sortnum"); $i = 0; $subcrits = ""; $havesubcrit = false; $nothadsub = false; while($subrow = @pg_fetch_object($res,$i++)){ if($i > 1) $subcrits .= " | "; if($subcrit != $subrow->subcrit) { if((!$subcrit) && (! $keyword) && ($subrow->subcrit == "qna")) { $nothadsub = true; $subcrit = "qna"; $subcrits .= ""; } else $subcrits .= ""; } else $subcrits .= ""; $subcrits .= $subrow->name; if($subcrit != $subrow->subcrit) { if((!$subcrit) && (! $keyword) && ($subrow->subcrit == "qna")) $subcrits .= ""; else $subcrits .= ""; } else $subcrits .= ""; $havesubcrit = true; } if($havesubcrit && $nothadsub){ $subcritinfo = pg_fetch_object($pgdb->exec("select * from menus where criteria = '$criteria' and subcrit = 'qna'"),0); $menuinfo = $subcritinfo; $worktable = "bd_$critinfo->menuid"; } if($worktable == "bd_1"){ $errormsg = "요청하신 페이지의 주소가 타당치 못해서 바르게 처리하질 못했습니다.페이지 주소를 다시 한번 확인해 보시고 바르게 호출해 주십시오."; include("html/error.php"); exit; } $aid || $aid = '0'; // 게시물 읽은 횟수 증가 if($userinfo->num) $pgdb->exec("update $worktable set reads = reads + 1 where id = '$aid' and usernum <> $userinfo->num"); else $pgdb->exec("update $worktable set reads = reads + 1 where id = '$aid'"); $row = @pg_fetch_object($pgdb->exec("select * from $worktable where id = '$aid'"),0); if($menuinfo->subcrit != $row->topic){ $subcritinfo = pg_fetch_object($pgdb->exec("select * from menus where criteria = '$criteria' and subcrit = '$row->topic'"),0); } if(! $row->id){ $errormsg .= "
해당 게시물 없음
삭제된 게시물
"; $row->name = ""; $row->uid = 0; $row->reads = 0; $row->cdate = 0; } // 파일 다운로드 처리 // if($menuinfo->allowupload == 't'){ if($userinfo->groups[1] || $userinfo->groups[3] || ($userinfo->num == $row->usernum)){ $deleteattach = "'Ｘ' as dowork"; } else{ $deleteattach = "' ' as dowork"; } $uploadres = new upres($pgdb->conn, $pgdb->exec("select '' || fname || '' as 파일이름, case when fsize > 1048576 then to_char(fsize::float / 1048576, 'FM999,999,999,999.99') || ' MB' when fsize > 1024 then to_char(fsize::float / 1024, 'FM999,999,999,999.99') || ' KB' else to_char(fsize, 'FM999,999,999,999') || ' bytes' end as 크기, case when fwidth > 0 then to_char(fwidth, 'FM999,999,999,999') || 'px * ' || to_char(fheight, 'FM999,999,999,999') || 'px' else '' end || case when ftype = 4 then ', ' else '' end || case when ftime > 0 then text(ftime)::interval::text else '' end as \"Info\", $deleteattach from uploadfiles where menuid = $subcritinfo->menuid and pid = $aid order by num")); $uptableinfo->class = "uploadtable"; $uptableinfo->cellspacing = "0"; $uptableinfo->cellpadding = "3"; $uptableinfo->border = "0"; $tUpload = $uploadres->printtable($uptableinfo); //} // 댓글 처리 // 코드가 지저분한 이유가 로그인했을때와 안했을때, 관리자일때와 아닐때, 등 온갖 경우 때문임 $comment_list = ""; if($row->comments){ $res = $pgdb->exec("select * from comments where ptable = '$worktable' and pid = '$row->id' order by cdate"); $i = 0; while($corow = @pg_fetch_object($res, $i++)){ $corow->content = highlight($corow->content, $arrkeyword); if((! ereg("^<", $corow->content)) && (!ereg("", $corow->content))){ $corow->content = ereg_replace("\r", "
", $corow->content); $corow->content = ereg_replace("\n", "\n", $corow->content); if(! ereg("
\n$", $corow->content)) $corow->content .= "\n"; $corow->content = ereg_replace("[ \t]{0,}
", "", $corow->content); $corow->content = "
" . $corow->content; } else{ $corow->content = str_replace("
","
",$corow->content); $corow->content = str_replace("
","",$corow->content); } $comment_list .= "
이 댓글은 " . date("Y-m-d H:i:s", $corow->mdate) . "에 마지막으로 수정되었습니다."; } if($corow->usernum < 1){ $comment_list .= " Edit "; if($userinfo->groups[1] || $userinfo->groups[3]){ $comment_list .= "Ｘ"; } else{ $comment_list .= "Ｘ"; } } else { if(($corow->usernum == $userinfo->num) || ($userinfo->groups[1])){ if($corow->usernum == $userinfo->num){ $comment_list .= " Edit "; } $comment_list .= "Ｘ"; } } $comment_list .= "