$value){
// $key = "DB_".$key;
// $$key = $value;
// }
}
//임원게시판 예외처리 끝
if($task == "modify" || $task == "reply" || $task == "view" || $task == "delete"){
if(!$no){
if(!$nowYear){
errorPage("글번호가 선택되지 않았습니다.");
}else{
$query_no2="select no from dbx_board_".$db." where nowYear='".$nowYear."' limit 1";
$no2_r = mysqli_query($connect,$query_no2);
$num_no2 = mysqli_num_rows($no2_r);
for ($i=0; $i <$num_no2; $i++){
$no2_row=mysqli_fetch_array($no2_r);
}
$no=$no2_row["no"];
}
}
//뷰페이지에서 행사등록 뷰페이지면 다른 테이블로 연결 검색
if($db=="regist"||$db=="regist1"){
$box = mysqli_fetch_array(mysqli_query($connect,"select * from dbx_workReg where no='$no' limit 1"));
}else{
$box = mysqli_fetch_array(mysqli_query($connect,"select * from dbx_board_".$db." where no='$no' limit 1"));
}
if(!is_array($box)){
errorPage("존재하지 않는 글입니다.");
}
else{
//나중에 없어질 부분
foreach($box as $key => $value){
$key = "DB_".$key;
${$key} = $value;
}
//나중에 없어질 부분 여기까지
// 현재까지 $SET_변수 를 $set[변수]
}
}
// 행사 자체접수 가려 내기 2010.12.20.BOX1
$eventtoday=date("Y-m-d H:i:s");
$work_registflg='0';
if ($DB_sDate <=$eventtoday && $DB_eDate > $eventtoday && $DB_work_regist=='사용'){
$work_registflg ='1';
}
$fileID = $task;
if($task == "delete"){
$fileID = "write";
}
if($task == "modify"){
$fileID = "excute";
if($box['userType'] != 1 && !$password && (!$_memberAdmin || $_memberAdmin == 0)){
$input = array();
foreach($_GET as $key => $value){
$input[$key] = "";
}
foreach($_POST as $key => $value){
$input[$key] = "";
}
$input['password'] = "";
$hiddenValue = implode("\n",$input);
include($boardDir."password.php");
exit;
}
}
if($task == "calendar"){
$fileID = "list";
}
$sktemp=explode("_",$SET_skin);
$skin_check = array_pop($sktemp); //// 스킨체크
$pageAdmission = loginCheck($fileID);
if($task == "view"){
//
// echo $pageAdmission;
// echo $limitAdmission;
//$_memberAdmin;
//exit;
/////////////////////////////////////////////////////////////////////////// START VIEW
if(($DB_secret == 1|| $db=="regist") && (!$password || (transPass($password) != $DB_password)) && (!$_memberAdmin || $_memberAdmin == 0) && $pageAdmission < 6){
if((transPass($password) != $password) && trim($password) != ""){
errorPage("비밀번호가 맞지 않습니다.");
//echo transPass($password);
//echo $password;
//echo $DB_password;
//exit;
}
//if ($db=="regist" &&($password != $password) && trim($password) != ""))
$inputValue = $_GET;
if(!$inputValue){
$inputValue = $_POST;
}
foreach($inputValue as $key => $value){
$hiddenValue = $hiddenValue."";
}
include($skinDir."password.php");
exit;
}
$DB_link1 = translt($DB_link1);
$DB_link2 = translt($DB_link2);
$DB_name = translt($DB_name);
if($siteInfo['useMemberMemo'] == 1){
if($DB_userType == 1){
$DB_name = "".$DB_name."";
}
}
$updateQuery = "update dbx_board_$db set hit = hit+1 where no='$no'";
$updateResult = mysqli_query($connect,$updateQuery);
if(!$updateResult){
errorPage("카운터 업데이트에 실패했습니다.");
}
if($DB_use_html == 1){
$DB_memo = tag_modify($DB_memo);
$DB_subject = tag_modify($DB_subject);
$DB_memo = imgMaker($DB_memo);
}
else if($DB_use_html == 2){
$DB_memo = nl2br($DB_memo);
$DB_memo = tag_modify($DB_memo);
$DB_subject = nl2br($DB_subject);
$DB_subject = tag_modify($DB_subject);
$DB_memo = imgMaker($DB_memo);
}
else if($DB_use_html == 0){
$DB_memo = htmlspecialchars($DB_memo);
$DB_memo = nl2br($DB_memo);
if(strlen($DB_memo)<=5000){
$DB_memo =f_auto_link($DB_memo);
}
$DB_subject = translt($DB_subject);
$DB_subject = nl2br($DB_subject);
}
else{
}
if($search && $searchKey){
$DB_subject = keybold($DB_subject,$search);
}
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
if(2 <= $pageAdmission){
$listLink = $PHP_SELF."?task=list&".$buttonLink;
}
if(3 <= $pageAdmission){
$viewLink = $PHP_SELF."?task=view&".$buttonLink;
}
if(4 <= $pageAdmission){
$writeLink = $PHP_SELF."?task=write&".$buttonLink;
}
if(5 <= $pageAdmission){
$replyLink = $PHP_SELF."?task=reply&".$buttonLink;
}
if(6 <= $pageAdmission || $_memberID == $DB_userID){
$modifyLink = $PHP_SELF."?task=modify&".$buttonLink;
$deleteLink = $PHP_SELF."?task=delete&".$buttonLink;
}
if($DB_prev_no){
$prevLink = $PHP_SELF."?task=view&db=".$db."&no=".$DB_prev_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
}
if($DB_next_no){
$nextLink = $PHP_SELF."?task=view&db=".$db."&no=".$DB_next_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
}
if($SET_category == "1" && $DB_category){
$DB_categoryName = "[".catName($db,$DB_category)."] ";
}
//// 뷰페이지 이미지 출력
$imgViewList = "";
for($i=1;$i<=$SET_upload;$i++){
if(${'DB_file_name'.$i} && ${'DB_file_code'.$i} && ${'DB_file_size'.$i}){
${'imgView'.$i} = imgView(${'DB_file_name'.$i},${'DB_file_code'.$i},$SET_width*0.99,$SET_width*0.99);
${'s_imgView'.$i} = imgView(${'DB_file_name'.$i},${'DB_file_code'.$i},$SET_width*0.1,$SET_width*0.1);
${'DB_file_size'.$i} = fileSizer(${'DB_file_size'.$i});
${'downloadUrl'.$i} = $boardUrl."include/download.php?no=".$DB_no."&db=".$db."&fileno=".$i;
${'imgUrl'.$i} = $boardUrl."data/".$db."/".$DB_no."/".imgNameTrans(${'DB_file_name'.$i});
if($SET_subnailUse != 1 && $i == 1){
continue;
}
else{
$imgViewList .= ${'imgView'.$i};
}
}
}
///// 뷰페이지 이미지 출력 끝
/////////////////////////////////////////////////////////////////////////// END VIEW
}
else if($task == "delete"){
/////////////////////////////////////////////////////////////////////////// START DELETE
if($pageAdmission == 6){
$inputMessage = "![](".$boardImgUrl."icon.gif)
MESSAGE 제목 : ".$DB_subject."인 글을 삭제합니다.";
}
else{
$inputMessage = "PASSWORD ";
}
/////////////////////////////////////////////////////////////////////////// END DELETE
}
else if($task == "write"){
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
$listLink = $PHP_SELF."?task=list&".$buttonLink;
}
else if($task == "reply"){
/////////////////////////////////////////////////////////////////////////// START REPLY
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
$listLink = $PHP_SELF."?task=list&".$buttonLink;
if($DB_notice == "1"){
errorPage("공지사항에는 답글을 달 수 없습니다.");
}
if($DB_secret == "1" && (!$_memberAdmin || $_memberAdmin == 0) && $pageAdmission != "6"){
errorPage("비공개글에는 관리자만이 답글을 쓸 수 있습니다.");
}
if($SET_category == "1"){
$DB_categoryName = catName($db,$DB_category);
}
unset($SET_notice);
unset($DB_name);
unset($DB_homepage);
unset($DB_email);
unset($DB_userID);
$DB_memo = str_replace("\n","\n>",stripslashes($DB_memo));
$DB_memo = "
[원글]
".$DB_memo;
/////////////////////////////////////////////////////////////////////////// END REPLY
}
else if($task == "modify"){
/////////////////////////////////////////////////////////////////////////// START MODIFY
$categoryOption = select_category($db,$DB_category);
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
$listLink = $PHP_SELF."?task=list&".$buttonLink;
/////////////////////////////////////////////////////////////////////////// END MODIFY
}
else if($task == "calendar"){
/////////////////////////////////////////////////////////////////////////// START CALENDAR
//echo calendar;
$skinUrl = $boardUrl."skin/".$SET_skin."/";
$skinDir = $boardDir."skin/".$SET_skin."/";
$is_file = file_exists($skinDir."list_head.php");
if(!$is_file){
errorPage("지정된 파일이 존재하지 않습니다.");
}else{
include($skinDir."list_head.php");
}
$is_file = file_exists($skinDir."list_tail.php");
if(!$is_file){
errorPage("지정된 파일이 존재하지 않습니다.");
}else{
include($skinDir."list_tail.php");
}
require_once($boardDir."_tail.php");
exit;
/////////////////////////////////////////////////////////////////////////// END CALENDAR
}
else if($task == "list"){
/////////////////////////////////////////////////////////////////////////// START LIST
//// 뷰페이지 이미지 출력
// $DB_no="1";
$imgViewList = "";
for($i=1;$i<=$SET_upload;$i++){
if(${'DB_file_name'.$i} && ${'DB_file_code'.$i} && ${'DB_file_size'.$i}){
${'imgView'.$i} = imgView(${'DB_file_name'.$i},${'DB_file_code'.$i},$SET_width*0.99,$SET_width*0.99);
${'s_imgView'.$i} = imgView(${'DB_file_name'.$i},${'DB_file_code'.$i},$SET_width*0.1,$SET_width*0.1);
${'DB_file_size'.$i} = fileSizer(${'DB_file_size'.$i});
${'downloadUrl'.$i} = $boardUrl."include/download.php?no=".$DB_no."&db=".$db."&fileno=".$i;
${'imgUrl'.$i} = $boardUrl."data/".$db."/".$DB_no."/".imgNameTrans(${'DB_file_name'.$i});
if($SET_subnailUse != 1 && $i == 1){
continue;
}
else{
$imgViewList .= ${'imgView'.$i};
}
}
}
///// 뷰페이지 이미지 출력 끝
if(!$page){$page='1';}
$start_num=($page-1) * $SET_list;
$CQuery = "select * from dbx_category where db='$db'";
$CResult = mysqli_query($connect,$CQuery);
$CTotal = mysqli_num_rows($CResult);
while($Cater=mysqli_fetch_array($CResult)) {
$CName =$Cater["Name"];
$CNo = $Cater["no"];
$CategoryName[$CNo] = $CName;
}
// for($C=0;$C<$CTotal;$C++){
// $CName = mysqli_result($CResult,$C,"name");
// $CNo = mysqli_result($CResult,$C,"no");
// $CategoryName[$CNo] = $CName;
// }
if($db=='relation' && ($_memberAdmin<1 || $_memberAdmin=='')) {
if($searchSubject=='' & $searchPjapji=='' & $searchPceo=='' ) {
$tdisp="display:none;";
}else {
$tdisp="display:;";
}
}
if($db=='print' && ($_memberAdmin<1 || $_memberAdmin=='')) {
if($searchSubject=='' & $searchPbcompany=='' & $searchIssn=='' ) {
$tdisp="display:none;";
}else {
$tdisp="display:;";
}
}
$query = "select * from dbx_board_$db";
$searchQuery=" where 1 ";
if($searchKey && $search){
$searchQuery = " where $searchKey like '%$search%'";
$key = "search".$searchKey;
${$key} = " selected";
}
if($searchSubject) {
$searchQuery = $searchQuery." and subject like '%$searchSubject%'";//제호
}
if($searchPbcompany) {
$searchQuery = $searchQuery." and pbcompany like '%$searchPbcompany%'";//발행처
}
if($searchIssn) {
$searchQuery = $searchQuery." and issn like '%$searchIssn%'";//ISSN
}
if($searchPjapji) {
$searchQuery = $searchQuery." and pjapji like '%$searchPjapji%'";//잡지명
}
if($searchPceo) {
$searchQuery = $searchQuery." and pceo like '%$searchPceo%'";//잡지명
}
if($category && $SET_category == "1"){
$cateInfo = mysqli_fetch_array(mysqli_query($connect,"select * from dbx_category where 1 and delState='1' and db='$db' and no=$category limit 1"));
if($cateInfo['reCnt'] != 0){
$cate_query = "select * from dbx_category where 1 and delState='1' and db='$db' and (step1=$category or step2=$category or step3=$category or no=$category)";
$cate_result = mysqli_query($connect,$cate_query);
while($cateRow = mysqli_fetch_array($cate_result)){
$categoryArr[sizeof($categoryArr)] = " category = '{$cateRow['no']}'";
}
if(is_array($categoryArr)){
$categoryQuery = " and (".implode(" or ",$categoryArr).")";
}
}
else{
$categoryQuery = " and category = '$category'";
}
}
$nowYearQuery="";
if($db=="osiamem"){
if ($nowYear!=''){
$nowYearQuery=" and nowYear = '$nowYear'";
}
$arrangeQuery = " order by category asc, no2 asc,no limit $start_num,$SET_list";
}elseif($db=="relation" || $db=="busi"){$arrangeQuery = " order by notice desc,psort desc,headnum,arrangenum limit $start_num,$SET_list";} elseif($db=="regist"||$db=="regist1"){$arrangeQuery = " order by no desc,notice desc,headnum,arrangenum limit $start_num,$SET_list";}
elseif($db=="memnews"){$arrangeQuery = " order by no desc,notice desc,headnum,arrangenum limit $start_num,$SET_list";}
elseif($db=="print"){$arrangeQuery = " order by pbdate desc,no desc,notice desc,headnum,arrangenum limit $start_num,$SET_list";}
elseif($db=="readers"){$arrangeQuery = " order by psort desc,notice desc,headnum,arrangenum limit $start_num,$SET_list";}elseif($db=='event' && ($_memberAdmin < 1 || !$_memberAdmin)) {
$nowYearQuery=" and regDate > '2016-12-31 11:59:59'";
$arrangeQuery = " order by notice desc,headnum,arrangenum limit $start_num,$SET_list";
}elseif($db=="subrule") {
$arrangeQuery = " order by dsort desc,notice desc,headnum,arrangenum limit $start_num,$SET_list";
}
else{$arrangeQuery = " order by notice desc,headnum,arrangenum limit $start_num,$SET_list";}
//등록확인일때는 완전히 다른 쿼리문이 실행된다... 다른 형태의 게시판 리스트가 나타나게 됨..
if($db=="regist"||$db=="regist1"){
$query = "select * from dbx_workReg ";
if($sNum){
$gnumq="select * from dbx_board_event where no='$sNum'";
$gnumr=mysqli_fetch_array(mysqli_query($connect,$gnumq));
if($gnumr['work_regist']!='사용') {
errorPage("정보가 없습니다.");
}
$searchQuery.= " and sNum='$sNum'";
}else{
$todayregist=date("Y-m-d H:i:s");
// $boardQuery2 ="select * from dbx_board_event where sDate<='".$todayregist."' and eDate>'".$todayregist."' and work_regist='사용' order by no desc limit 1";
$boardQuery2 ="select * from dbx_board_event where work_regist='사용' order by no desc limit 1";
$row2=mysqli_fetch_array(mysqli_query($connect,$boardQuery2));
if($row2['no']){
$sNum=$row2['no'];
$searchQuery.= " and sNum='$sNum'";
}
}
if($db=="regist1"){
if($_memberID){
$searchQuery.= " and userID='$_memberID'";
}else{
$searchQuery.= " and userID='noID'";
}
}
}
if($db=="1to1"&& $_memberAdmin<1){
$searchQuery.= " and (userID='$_memberID' or writerID='$_memberID')";
}
$query1 = $query.$searchQuery.$categoryQuery.$nowYearQuery.$arrangeQuery;
// echo $query1;
// exit;
$result = mysqli_query($connect,$query1);
$totalView = mysqli_num_rows($result);
$totalField = mysqli_num_fields($result);
// $totalResult = mysqli_query($connect,$query1);
$totalResult = mysqli_query($connect,$query.$searchQuery.$categoryQuery.$nowYearQuery);
//echo $query.$searchQuery.$categoryQuery;
//exit;
$total = mysqli_num_rows($totalResult);
$totalPage = ceil($total/$SET_list);
if($db=='print') {
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID."&searchSubject=".$searchSubject."&searchIssn=".$searchIssn."&searchPbcompany=".$searchPbcompany;
}else {
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
}
$listLink = $PHP_SELF."?task=list&".$buttonLink;
if(4 <= $pageAdmission){
$writeLink = $PHP_SELF."?task=write&".$buttonLink;
}
if($pageAdmission < 2){
alerts("권한이 없습니다.");
?>
".$DB_name."";
}
}
$DB_subject = han_substr($DB_subject,$SET_subjectStr,FALSE);
if($DB_use_html == 1){
$DB_memo = imgMaker($DB_memo);
$DB_memo = tag_modify($DB_memo);
$DB_subject = tag_modify($DB_subject);
}
else if($DB_use_html == 2){
$DB_memo = imgMaker($DB_memo);
$DB_memo = nl2br($DB_memo);
$DB_memo = tag_modify($DB_memo);
$DB_subject = nl2br($DB_subject);
$DB_subject = tag_modify($DB_subject);
}
else if($DB_use_html == 0){
$DB_memo = htmlspecialchars($DB_memo);
$DB_memo = nl2br($DB_memo);
if(strlen($DB_memo)<=5000){
$DB_memo =f_auto_link($DB_memo);
}
$DB_subject = translt($DB_subject);
$DB_subject = nl2br($DB_subject);
}
else{
}
if($search && $searchKey){
$DB_subject = keybold($DB_subject,$search);
}
if($DB_comment > 0){
$DB_subject.= " (".$DB_comment.")";
}
if($DB_category){
$DB_category = "[".$DB_category."]";
}
if($SET_newIcon){
$newIcon = newImg($DB_regDate,$SET_newIcon);
if($newIcon == "show"){
$DB_subject.= "![](".$boardImgUrl."new.gif)
";
}
}
$DB_regDate2 = $DB_regDate;
$DB_regDate = substr($DB_regDate,0,10);
if($DB_notice == "1"){
$num = "notice";
}
else{
$num = $total-($page-1)*$SET_list-$i;
}
if($_memberAdmin >= 1 || $db=='print'){
$check = "";
}
else{
$check = "";
}
$DB_space = str_repeat(" ",$DB_depth);
//버튼제어/////////////////////////////////////////////////////
$buttonLink = "db=".$db."&no=".$DB_no."&page=".$page."&search=".$search."&searchKey=".$searchKey."&category=".$category."&pageID=".$pageID;
if(3 <= $pageAdmission){
$viewLink = $PHP_SELF."?task=view&".$buttonLink;
}
else{
$viewLink = "javascript:alert('회원 로그인을 통하여 보실 수 있습니다.')";
}
if(5 <= $pageAdmission){
$replyLink = $PHP_SELF."?task=reply&".$buttonLink;
}
if(6 <= $pageAdmission){
$modifyLink = $PHP_SELF."?task=modify&".$buttonLink;
$deleteLink = $PHP_SELF."?task=delete&".$buttonLink;
}
//파일에대한설정////////////////////////////////////////////////////
for($k=1;$k<=$SET_upload;$k++){
if(${'DB_file_name'.$k} && ${'DB_file_code'.$k} && ${'DB_file_size'.$k}){
${'imgView'.$k} = imgView(${'DB_file_name'.$k},${'DB_file_code'.$k},$SET_width,$SET_width*2);
${'DB_file_size'.$k} = fileSizer(${'DB_file_size'.$k});
${'downloadUrl'.$k} = $boardUrl."include/download.php?no=".$DB_no."&db=".$db."&fileno=".$k;
}
${'DB_fileSrc'.$k} = $boardUrl."data/".$db."/".$DB_no."/".imgNameTrans(${'DB_file_name'.$k});
}
//파일에대한설정 끝//////////////////////////////////////////////////
$is_file = file_exists($skinDir."list_main.php");
if(!$is_file){
errorPage("지정된 파일이 존재하지 않습니다.");
}
else{
include($skinDir."list_main.php");
}
}//end for
$is_file = file_exists($skinDir."list_tail.php");
if(!$is_file){
errorPage("지정된 파일이 존재하지 않습니다.");
}
else{
include($skinDir."list_tail.php");
}
}
//tg 예외 처리 끝
require_once($boardDir."_tail.php");
exit;
/////////////////////////////////////////////////////////////////////////// END LIST
}
///////////////////////////////////////////////////////////////////////////// START SKIN (COMMON)
if($task != "list"){
switch($fileID){
case "excute":
$limitAdmission = 6;
break;
case "reply":
$limitAdmission = 5;
break;
case "write":
$limitAdmission = 4;
break;
case "view":
$limitAdmission = 3;
break;
case "list":
$limitAdmission = 2;
break;
case "closed":
$limitAdmission = 1;
break;
default:
$limitAdmission = 10;
break;
}
if($db!="regist"&&($pageAdmission < $limitAdmission)){
errorPage("권한이2 없습니다.");
}
if($task == "write" || $task == "modify" || $task == "reply"){
$skinFileName = "write";
///파일 쓰기,수정관련 설정
for($jj=1;$jj<=$SET_upload;$jj++){
if(!${'DB_file_code'.$jj}){
${'show'.$jj.'a'} = "none";
${'show'.$jj.'b'} = "";
${'showMessage'.$jj} = "";
}
else{
${'show'.$jj.'a'} = "";
${'show'.$jj.'b'} = "none";
${'showMessage'.$jj} = "※변경할 파일을 선택해 주십시오.";
}
}
if($task != "modify"){
for($jj=1;$jj<=$SET_upload;$jj++){
${'show'.$jj.'a'} = "none";
${'show'.$jj.'b'} = "";
${'showMessage'.$jj} = "";
}
}
///파일 쓰기 ,수정관련 설정
if($SET_html == 1){
if($DB_use_html == 1){
$DB_use_html = " checked";
}
$use_html = " 태그";
}
if($SET_secret == 1){
if($DB_secret == 1){
$DB_secret = " checked";
}
$secret = " 비공개글";
}
if($SET_notice == 1 && $pageAdmission >= 6 && $noticeAdmission == true){
if($DB_notice == 1){
$DB_notice = " checked";
}
$notice = " 공지사항";
}
}
if(!$skinFileName){
$skinFileName = $task;
}
$skinUrl = $boardUrl."skin/".$SET_skin."/";
$skinDir = $boardDir."skin/".$SET_skin."/";
$is_file = file_exists($skinDir.$skinFileName.".php");
if(!$is_file){
errorPage("지정된 파일이 존재하지 않습니다.");
}
else{
include($skinDir.$skinFileName.".php");
require_once($boardDir."_tail.php");
}
}
///////////////////////////////////////////////////////////////////////////// END SKIN (COMMON)
?>