File Source for rainBoard.php

<?
/**
* 레인 게시판 - 객체지향적게시판
* @package com.rain
* @version 9.0
* @author http://cafen.net (outmind@cafen.net)
*/
class rainBoard {
/**
* 게시판 아이디
*
* @var String
*/
var $board_id = "";
/**
* MYSQL CLASS
*
* @var rainMysql
*/
var $db_class = null;
/**
* 기본 쿼리
*
* @var String
*/
var $base_query = "";
/**
* 마지막 입력 고유번호
*
* @var Int
*/
var $last_muid;
/**
* 오류 메세지
*
* @var String
*/
var $error_msg = "";
/**
* 게시판 환경 정보
*
* @var rainProperties
*/
var $board_conf = null;
/**
* 생성자
*
* @param String 게시판 아이디
*/
function rainBoard($board_id) {
$this->board_conf = new rainProperties("board_" . $board_id);
$this->db_class = new rainMysql("mysql");
$this->board_id = $board_id;
$this->base_query = "select * from multi_board where board_id = '" . $this->board_id . "' ";
}
/**
* 게시판 환경 정보 읽기
*
* @param String 읽을 키값
* @return String value
*/
function getConf($name) {
return $this->board_conf->get($name);
}
/**
* 권한 확인
*
* @param String 상태구분 [BOARD :게시판확인, REPLY : 답변권한 확인, WRITE : 작성권한, TAIL : 덧글 사용여부]
* @return Boolean 권한 여부
*/
function checkAuth ($mode) {
switch($mode) {
case 'BOARD' :
return ($this->board_conf->file_loaded) ? true:false;
break;
case 'REPLY' :
case 'WRITE' :
$mode_value = $this->getConf(($mode == 'REPLY')?"reply_mode":"write_mode");
switch($mode_value) {
case 'A' :
return rainUtil::chkUser('');
break;
case 'M' :
return rainUtil::isLogined();
break;
case '' :
return true;
break;
default :
return rainUtil::chkUser($mode_value);
break;
}
break;
case 'TAIL' :
$mode = $this->getConf("tail_mode");
return ($mode) ? true:false;
break;
default :
return false;
break;
}
}
/**
* 덧글 Class 가져오기
*
* @param Int 글 고유번호
* @return rainTail 덧글 Class
*/
function getTailClass($muid) {
return new rainTail($this->board_id, $muid);
}
/**
* 게시판 목록 가져오기
*
* @param Int 현재 라인번호
* @param rainRequest Request 객체
* @param Int 가져올 글 갯수
* @return rainData 게시판 목록
*/
function getList($cline, $req , $getnum) {
$qm = $this->base_query;
if ($req->get("sk") != '') {
$sk = rainUtil::addslashesQuery($req->get("sk"));
switch($req->get("so")) {
case 'T' :
$qm .= " and title like '%". $sk ."%' ";
break;
case 'N' :
$qm .= " and user_nm like '%". $sk ."%' ";
break;
case 'C' :
$qm .= " and contents_text like '%". $sk ."%' ";
break;
default :
$qm .= " and (title like '%". $sk ."%' or user_nm like '%". $sk ."%' or contents_text like '%". $sk ."%') ";
break;
}
}
$qm .= " order by board_uid desc ";
return $this->db_class->query2Array($qm, $cline, $getnum);
}
/**
* 게시판 글 내용가져오기
*
* @param Int 글 고유번호
* @param Boolean 조횟수 추가 여부
* @return rainData
*/
function getView($muid, $addhits = false) {
if ($addhits) {
$boardhit = new rainBoardHit($muid);
$boardhit->insertData();
}
$qm = $this->base_query ." and muid = '" . $muid . "' ";
return $this->db_class->queryFetch($qm);
}
/**
* 이전글 가져오기
*
* @param Int 기준 글 번호
* @return rainData
*/
function getPrev($board_uid) {
$qm = $this->base_query . " and board_uid > '". $board_uid ."' order by board_uid asc ";
return $this->db_class->queryFetch($qm);
}
/**
* 다음글 가져오기
*
* @param Int 기준 글 번호
* @return rainData
*/
function getNext($board_uid) {
$qm = $this->base_query . " and board_uid < '" . $board_uid . "' order by board_uid desc ";
return $this->db_class->queryFetch($qm);
}
/**
* 게시판 관련 URL 가져오기
*
* @param String 상태 [view : 보기, list : 목록]
* @return String URL
*/
function getUrl($mode) {
if ($mode == "view")
return $this->getConf("url_view") . "?board_id=" . $this->board_id . "&muid=" . $this->last_muid;
else
return $this->getConf("url_list") . "?board_id=" . $this->board_id;
}
/**
* 게시판 자료 삭제
*
* @param Int 글 고유번호
* @param String 관리 암호
* @return Boolean 삭제성공여부
*/
function deleteData($muid, $passwd = '') {
if ($this->checkPass($muid, $passwd)) {
$old_result = $this->getView($muid);
if ($old_result->first()) {
$rfile = new rainFile(rainUtil::getConf("path_uploads"));
$old_contents = $old_result->getString("contents");
$rfile->RainEditAttachSaveDelete("", $old_contents);
}
$tail_class = $this->getTailClass($muid);
$tail_class->deleteAllData();
$boardhit = new rainBoardHit($muid);
$boardhit->deleteAllData();
$this->db_class->change("delete from multi_board where muid = '" . $muid . "' ");
return true;
} else {
$this->error_msg = "해당 글의 접근 권한이 없습니다";
return false;
}
}
/**
* 게시판 접근 권한 확인
* @param Int 글 고유번호
* @param String 관리 암호
* @return Boolean 접근 가능 여부
*/
function checkPass($muid, $passwd) {
$result = $this->getView($muid);
if ($result->first()) {
$old_passwd = $result->getString("user_pw");
$user_id = $result->getString("user_id");
if (rainUtil::chkUser($user_id) || rainUtil::chkPass($old_passwd, $passwd))
return true;
else
return false;
} else
return false;
}
/**
* 게시판 글 작성
*
* @param rainRequest 입력 받을 데이타
* @param Int 관련 답글
* @return Boolean 입력 성공 여부
*/
function insertData($req, $reply_uid = 0) {
if (!rainUtil::chkAuth($req->get("authcode"))) {
$this->error_msg = "인증코드가 달라서 처리 할수 없습니다 바른인증코드(" . rainUtil::getPassCode() .") ";
return false;
} else if (!$this->checkAuth(($reply_uid == 0)?'WRITE':'REPLY')) {
$this->error_msg = "해당 게시판의 접근 권한이 없습니다. 권한을 관리자에게 문의 바랍니다. ";
return false;
}
$muid = $this->db_class->getLastID("multi_board", "muid");
$rfile = new rainFile(rainUtil::getConf("path_uploads"));
$title = rainUtil::htmlSpecialchars($req->get("title"));
$contents= $req->get("contents");
$contents = $rfile->rainEditAttachSaveDelete($contents);
$contents_view = rainUtil::addslashes($rfile->rainContents_html);
$contents_text = $rfile->stripTags($rfile->rainContents_html);
$contents_attach = $rfile->rainAttachParse(false);
$contents_image = $rfile->rainAttach_image;
$is_movie = $rfile->rainAttach_movie;
$attach_size = $rfile->totalattach_size;
$user_id = $req->getID();
$user_nm = $req->getName($req->get("user_nm"));
$user_email = $req->getEmail($req->get("user_email"));
$user_pw = $req->get("user_pw");
$user_ip = $req->getIP();
$board_uid = "";
$board_dep = "";
$qm = "";
if ($reply_uid == 0) {
$board_uid = $this->db_class->queryOne("select ifnull(max(board_uid)+1,1) as board_uid from multi_board where board_id = '" . $this->board_id . "' ");
$board_dep = "0";
} else{
$qm = "select board_uid, board_dep+1 as board_dep from multi_board where board_id = '" . $this->board_id . "' and muid = '" . $reply_uid . "' ";
$check_result = $this->db_class->queryFetch($qm);
if ($check_result->first()) {
$board_uid = $check_result->getString("board_uid");
$board_dep = $check_result->getString("board_dep");
$qm = "update multi_board set board_uid = board_uid + 1 where board_id = '" . $this->board_id . "' and board_uid >= '" . $board_uid . "' ";
$this->db_class->change($qm);
} else {
$board_uid = $this->db_class->queryOne("select ifnull(max(board_uid)+1,1) as board_uid from multi_board where board_id = '" . $this->board_id . "' ");
$board_dep = "0";
}
}
$regdate = $req->getNow();
$qm = ""
. "insert into multi_board ( "
. " muid, "
. " board_id,"
. " board_uid,"
. " board_dep,"
. " user_nm,"
. " user_email,"
. " user_ip,"
. " user_id,"
. " user_pw,"
. " title,"
. " contents,"
. " contents_view,"
. " contents_text,"
. " contents_attach,"
. " contents_image,"
. " tail,"
. " regdate,"
. " attach_size,"
. " is_movie,"
. " hits"
. ")values("
. " '". $muid. "',"
. " '" . $this->board_id . "',"
. " '" . $board_uid . "',"
. " '". $board_dep. "',"
. " '". $user_nm. "',"
. " '". $user_email. "',"
. " '". $user_ip. "',"
. " '". $user_id. "',"
. " '". $user_pw. "',"
. " '". $title. "',"
. " '". $contents. "',"
. " '". $contents_view. "',"
. " '". $contents_text. "',"
. " '". $contents_attach. "',"
. " '". $contents_image. "',"
. " '0',"
. " '". $regdate. "',"
. " '". $attach_size. "',"
. " '". $is_movie. "',"
. " '0'"
. ")";
$this->last_muid = $muid;
$this->db_class->change($qm);
return true;
}
/**
* 게시판 글 수정
*
* @param Int 수정할 글 고유번호
* @param rainRequest 입력 받을 데이타
* @return Boolean 수정 성공 여부
*/
function modifyData($muid,$req) {
if (!rainUtil::chkAuth($req->get("authcode"))) {
$this->error_msg = "인증코드가 달라서 처리 할수 없습니다 바른인증코드(" . rainUtil::getPassCode() .") ";
return false;
} else if (!$this->checkAuth('WRITE')) {
$this->error_msg = "해당 게시판의 접근 권한이 없습니다. 권한을 관리자에게 문의 바랍니다. ";
return false;
}
$old_passwd = $req->get("user_pw");
if ($this->checkPass($muid, $old_passwd)) {
$rfile = new rainFile(rainUtil::getConf("path_uploads"));
$old_contents = "";
$old_result = $this->getView($muid);
if ($old_result->first())
$old_contents = $old_result->getString("contents");
$title = rainUtil::htmlSpecialchars($req->get("title"));
$contents= $req->get("contents");
$contents = $rfile->rainEditAttachSaveDelete($contents, $old_contents);
$contents_view = rainUtil::addslashes($rfile->rainContents_html);
$contents_text = $rfile->stripTags($rfile->rainContents_html);
$contents_attach = $rfile->rainAttachParse(false);
$contents_image = $rfile->rainAttach_image;
$attach_size = $rfile->totalattach_size;
$is_movie = $rfile->rainAttach_movie;
$user_id = $req->getID();
$user_nm = $req->getName($req->get("user_nm"));
$user_email = $req->getEmail($req->get("user_email"));
$user_ip = $req->getIP();
$qm = "update multi_board set "
. " user_id = '". $user_id. "', "
. " user_nm = '". $user_nm. "', "
. " user_email = '". $user_email. "', "
. " user_ip = '". $user_ip. "', "
. " title = '". $title. "', "
. " contents = '". $contents. "', "
. " contents_view = '". $contents_view. "', "
. " contents_text = '". $contents_text. "', "
. " contents_attach = '". $contents_attach. "', "
. " contents_image = '". $contents_image. "', "
. " attach_size = '". $attach_size. "', "
. " is_movie = '". $is_movie. "' "
. " where board_id = '" . $this->board_id . "' and muid = '". $muid. "' ";
$this->db_class->change($qm);
rainUtil::errorLog($qm);
$this->last_muid = $muid;
return true;
} else {
$this->error_msg = "기존 암호와 일치 하지 않습니다.";
return false;
}
}
/**
* Unix 타임을 특정 형태로 변경
*
* @param Int Unix 타임
* @param String 일자 포맷
* @return String 특정 포맷의 일자
*/
function getDate($date_str, $date_fmat) {
return date($date_fmat,$date_str);
}
/**
* Date 을 특정 형태로 변경
*
* @param Int Date 객체
* @param String 일자 포맷
* @return String 특정 포맷의 일자
*/
function getDateFormat($today, $date_fmat) {
return $this->getDate($today, $date_fmat);
}
}
?>

Source for file rainBoard.php