}
// 이름을 대신하는 아이콘 업로드시 처리
if ($HTTP_POST_FILES[private_name]) {
$private_name = $HTTP_POST_FILES[private_name][tmp_name];
$private_name_name = $HTTP_POST_FILES[private_name][name];
$private_name_type = $HTTP_POST_FILES[private_name][type];
$private_name_size = $HTTP_POST_FILES[private_name][size];
}
if (@filesize($private_name)) {
if (!is_dir("icon/private_name")) {
@mkdir("icon/private_name", 0707);
@chmod("icon/private_name", 0707);
}
if (!is_uploaded_file($private_name)) {
Error("Please make upload properly");
}
if (!eregi("\\.gif", $private_name_name)) {
Error("Only can use Gif file format for name icon");
}
@move_uploaded_file($private_name, "icon/private_name/" . $member_no . ".gif");
@chmod("icon/private_name" . $member_no . ".gif", 0707);
@chmod("icon/private_name", 0707);
}
// 관리자 자신의 비밀번호 변경시 새로이 쿠키를 설정하여 줌
//if($member_no==$member[no]&&$password&&$password1&&$password==$password1) {
//$password=mysql_fetch_array(mysql_query("select password('$password')"));
//setcookie("zetyxboard_userid",$member[user_id],'',"/");
//setcookie("zetyxboard_password",$password[0],'',"/");
//}
movepage("{$PHP_SELF}?exec=view_member&exec2=modify&no={$member_no}&group_no={$group_no}&page={$page}&keyword={$keyword}&level_search={$level_search}&page_num={$page_num}&keykind={$keykind}&like={$like}");
}
}
// 이전글이 있으면 빈자리 메꿈;;;
if ($s_data[next_no]) {
mysql_query("update {$t_board}" . "_{$id} set prev_no='{$s_data['prev_no']}' where prev_no='{$s_data['no']}'");
}
// 다음글이 있으면 빈자리 메꿈;;;
} else {
$temp = mysql_fetch_array(mysql_query("select count(*) from {$t_board}" . "_{$id} where father='{$s_data['father']}'"));
if (!$temp[0]) {
mysql_query("update {$t_board}" . "_{$id} set child='0' where no='{$s_data['father']}'");
}
// 원본글이 있으면 원본글의 자식글을 없앰;;;
}
// 간단한 답글 삭제
mysql_query("delete from {$t_comment}" . "_{$id} where parent='{$s_data['no']}'");
$total = mysql_fetch_array(mysql_query("select count(*) from {$t_board}" . "_{$id} "));
mysql_query("update {$admin_table} set total_article='{$total['0']}' where name='{$id}'");
// 카테고리 필드 조절
mysql_query("update {$t_category}" . "_{$id} set num=num-1 where no='{$s_data['category']}'", $connect);
// 회원일 경우 해당 해원의 점수 주기
if ($member[no] == $s_data[ismember]) {
@mysql_query("update {$member_table} set point1=point1-1 where no='{$member['no']}'", $connect) or error(mysql_error());
}
}
//////// MySQL 닫기 ///////////////////////////////////////////////
if ($connect) {
mysql_close($connect);
}
$query_time = getmicrotime();
movepage("zboard.php?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&sn1={$sn1}&divpage={$divpage}");
$group_data = mysql_fetch_array(mysql_query("select * from {$group_table} where no='{$member['group_no']}'"));
// 이주일 넘은 글 삭제;;
mysql_query("delete from {$send_memo_table} where (" . time() . " - reg_date) >= " . $_zbDefaultSetup[memo_limit_time]) or error(mysql_error());
// 선택된 메모 삭제;;;
if ($exec == "del_all") {
for ($i = 0; $i < count($del); $i++) {
mysql_query("delete from {$send_memo_table} where no='{$del[$i]}'");
}
mysql_close($connect);
movepage("{$PHP_SELF}?page={$page}");
}
// 메모삭제
if ($exec == "del") {
mysql_query("delete from {$send_memo_table} where no='{$no}' and member_no='{$member['no']}'");
mysql_close($connect);
movepage("{$PHP_SELF}?page={$page}");
}
// 선택된 메모가 있을시 데이타 뽑아오기;;
if ($no) {
$now_data = mysql_fetch_array(mysql_query("select a.subject as subject, a.reg_date as reg_date, a.readed as readed, b.name as name, a.member_to as member_to, a.memo as memo from {$send_memo_table} a, {$member_table} b where a.member_to=b.no and a.no='{$no}' and a.member_no='{$member['no']}'"));
}
// 읽지 않은 쪽지의 갯수 구하기
$temp1 = mysql_fetch_array(mysql_query("select count(*) from {$send_memo_table} where readed='1' and member_no='{$member['no']}'"));
$new_total = $temp1[0];
// 전체 쪽지의 갯수
$temp2 = mysql_fetch_array(mysql_query("select count(*) from {$send_memo_table} where member_no='{$member['no']}'"));
$total = $temp2[0];
// 페이지 계산
if (!$page) {
$page = 1;
}
<?php
include "lib.php";
$connect = dbConn();
$member = member_info();
if ($member[no] && $member[is_admin] < 3 && $member[is_admin] >= 1 || $member[no] && $member[board_name]) {
movepage("admin_setup.php");
} else {
if ($member[no]) {
destroyZBSessionID($member[no]);
// 4.0x 용 세션 처리
$zb_logged_no = '';
$zb_logged_time = '';
$zb_logged_ip = '';
$zb_secret = '';
$zb_last_connect_check = '0';
session_register("zb_logged_no");
session_register("zb_logged_time");
session_register("zb_logged_ip");
session_register("zb_secret");
session_register("zb_last_connect_check");
}
}
head(" bgcolor=444444 onload=write.user_id.focus()");
?>
<script>
function check_submit() {
if(!write.user_id.value) {
alert("Please input userID properly");
write.user_id.focus();
$zb_logged_no = $member_data[no];
$zb_logged_time = time();
$zb_logged_ip = $REMOTE_ADDR;
$zb_last_connect_check = '0';
session_register("zb_logged_no");
session_register("zb_logged_time");
session_register("zb_logged_ip");
session_register("zb_last_connect_check");
// 로그인 후 페이지 이동
$s_url = urldecode($s_url);
if (!$s_url && $id) {
$s_url = "zboard.php?id={$id}";
}
if ($s_url) {
movepage($s_url);
} elseif ($id) {
movepage("zboard.php?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&category={$category}&no={$no}");
} elseif ($group[join_return_url]) {
movepage($group[join_return_url]);
} elseif ($referer) {
movepage($referer);
} else {
echo "<script>history.go(-2);</script>";
}
// 회원로그인이 실패하였을 경우 에러 표시
} else {
head();
Error("Failed (login)");
foot();
}
@mysql_close($connect);
}
if (!@move_uploaded_file($upload[$i], $path . "/" . $upload_name[$i])) {
Error("이미지 업로드가 제대로 되지 않았습니다");
}
}
}
}
movepage("{$PHP_SELF}?id={$id}&image_page={$image_page}");
exit;
}
// 삭제 명령 실행시
if ($exec == "delete" && strlen($no) && $id) {
if (!z_unlink($path . "/" . $image_list[$no])) {
die("에러");
}
movepage("{$PHP_SELF}?id={$id}&image_page={$image_page}");
exit;
}
// 한페이지에 출력될 그림 갯수 지정
$listnum = 18;
// 전체갯수와 전체 페이지 수 구함
$total = count($image_list);
$total_page = (int) (($total - 1) / $listnum) + 1;
// 전체 페이지 구함
// 페이지 지정
if (!$image_page) {
$image_page = 1;
}
// 페이지가 전체 페이지보다 크면 페이지 번호 바꿈
if ($image_page > $total_page) {
$image_page = $total_page;
} else {
$get_memo_table_exists = 1;
}
if (!istable($send_memo_table, $dbname)) {
@mysql_query($send_memo_table_schema, $connect) or Error("보낸 쪽지 테이블 생성 실패");
} else {
$send_memo_table_exist = 1;
}
// 파일로 DB 정보 저장
$file = @fopen("config.php", "w") or Error("config.php 파일 생성 실패<br><br>디렉토리의 퍼미션을 707로 주십시요", "");
@fwrite($file, "<?\n{$hostname}\n{$user_id}\n{$password}\n{$dbname}\n?>\n") or Error("config.php 파일 생성 실패<br><br>디렉토리의 퍼미션을 707로 주십시요", "");
@fclose($file);
@mkdir("data", 0707);
@mkdir("icon", 0707);
@mkdir("icon/member_image_box", 0707);
@mkdir("icon/private_icon", 0707);
@mkdir("icon/private_name", 0707);
@chmod("icon/member_image_box", 0707);
@chmod("icon/private_icon", 0707);
@chmod("icon/private_name", 0707);
@chmod("data", 0707);
@chmod("icon", 0707);
@chmod("config.php", 0707);
$temp = mysql_fetch_array(mysql_query("select count(*) from {$member_table} where is_admin = '1'", $connect));
mysql_close($connect);
if ($temp[0]) {
movepage("admin.php");
} else {
movepage("install2.php");
}
// 관리자 정보가 없을때 관리자 정보 입력
**************************************************************************/
include "_head.php";
/***************************************************************************
* 설정 체크
**************************************************************************/
// 사용권한 체크
if ($setup[grant_view] < $member[level] && !$is_admin) {
Error("사용권한이 없습니다", "login.php?id={$id}&page={$page}&page_num={$page_num}&category={$category}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&no={$no}&file=zboard.php");
}
// 현재글의 Vote수 올림;;
if (!ereg($setup[no] . "_" . $no, $_SESSION["zb_vote"])) {
mysql_query("update {$t_board}" . "_{$id} set vote=vote+1 where no='{$no}'");
$vote_str = "," . $setup[no] . "_" . $no;
// 기존 세션 처리 (4.0x용 세션 처리로 인하여 주석 처리)
//$_SESSION["zb_vote"] = $_SESSION["zb_vote"] . $vote_str;
// 4.0x 용 세션 처리
$zb_vote = $_SESSION["zb_vote"] . $vote_str;
session_register("zb_vote");
}
// MySQL 닫기
if ($connect) {
mysql_close($connect);
}
// 페이지 이동
if ($setup[use_alllist]) {
$temp_href = "zboard.php";
} else {
$temp_href = "view.php";
}
movepage("{$temp_href}?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&category={$category}&no={$no}");
<?php
include_once 'header.php';
?>
<body>
<!-- Static navbar -->
<?php
include_once 'nav.php';
?>
<div class="container-fluid">
<div class="row-fluid">
<div class="col-sm-9 main">
<?php
movepage("index.php?p=1");
?>
</div>
<!--Body content-->
</div>
<div class="col-sm-3 sidebar">
<!--Sidebar content-->
<?php
url_routing(define_module_sidebar());
?>
</div>
</div>
</div>
<?php
$temp = mysql_query("select name from {$admin_table} where group_no='{$group_no}'");
while ($data = mysql_fetch_array($temp)) {
$table_name = $data[name];
$tmpData = mysql_query("select file_name1, file_name2 from {$t_board}" . "_{$table_name}") or die("An occured error when deleted attached file(s)");
while ($data = mysql_fetch_array($tmpData)) {
if ($data[file_name1]) {
@z_unlink("./" . $data[file_name1]);
}
if ($data[file_name2]) {
@z_unlink("./" . $data[file_name2]);
}
}
if (is_dir("./data/" . $table_name)) {
zRmDir("./data/" . $table_name);
}
mysql_query("delete from {$admin_table} where no='{$no}'") or Error("An occured error from admin table when deleted board");
mysql_query("drop table {$t_board}" . "_{$table_name}") or Error("An occured error when deleted board's main table");
mysql_query("drop table {$t_division}" . "_{$table_name}") or Error("An occured error when deleted board's division table");
mysql_query("drop table {$t_comment}" . "_{$table_name}") or Error("An occured error when deleted board's comment");
mysql_query("drop table {$t_category}" . "_{$table_name}") or Error("An occured error when deleted board's category table");
mysql_query("update {$group_table} set board_num=board_num-1 where no='{$group_no}'");
}
@mysql_query("delete from {$admin_table} where group_no='{$group_no}'");
}
// 그룹삭제
@mysql_query("delete from {$group_table} where no='{$group_no}'") or Error("An occured error when deleted group");
movepage("{$PHP_SELF}");
} elseif ($exec == "modify_member_join_ok") {
mysql_query("update {$group_table} set join_level='{$join_level}',use_icq='{$use_icq}',use_aol='{$use_aol}',use_msn='{$use_msn}', \n\t\tuse_jumin='{$use_jumin}',use_comment='{$use_comment}',use_job='{$use_job}',use_hobby='{$use_hobby}', \n\t\tuse_home_address='{$use_home_address}',use_home_tel='{$use_home_tel}',use_office_address='{$use_office_address}',\n\t\tuse_office_tel='{$use_office_tel}',use_handphone='{$use_handphone}',use_mailing='{$use_mailing}', \n\t\tuse_birth='{$use_birth}',use_picture='{$use_picture}' where no='{$group_no}'") or error(mysql_error());
movepage("{$PHP_SELF}?exec=modify_member_join&group_no={$group_no}");
}
$zb_hit = $HTTP_SESSION_VARS["zb_hit"] . $hitStr;
session_register("zb_hit");
// 현재글의 추천을 할수 없게 세션 등록
$voteStr = "," . $setup[no] . "_" . $no;
$zb_vote = $HTTP_SESSION_VARS["zb_vote"] . $voteStr;
session_register("zb_vote");
if ($prev_no) {
mysql_query("update {$t_board}" . "_{$id} set next_no='{$no}' where no='{$prev_no}'");
}
if ($next_no) {
mysql_query("update {$t_board}" . "_{$id} set prev_no='{$no}' where headnum='{$next_data['headnum']}' and division='{$next_data['division']}'");
}
mysql_query("update {$t_category}" . "_{$id} set num=num+1 where no='{$category}'", $connect);
}
// 글의 갯수를 다시 갱신
$total = mysql_fetch_array(mysql_query("select count(*) from {$t_board}" . "_{$id} "));
mysql_query("update {$admin_table} set total_article='{$total['0']}' where name='{$id}'");
// 회원일 경우 해당 해원의 점수 주기
if ($mode == "write" || $mode == "reply") {
@mysql_query("update {$member_table} set point1=point1+1 where no='{$member['no']}'", $connect) or error(mysql_error());
}
// MySQL 닫기
if ($connect) {
mysql_close($connect);
unset($connect);
}
// 페이지 이동
//if($setup[use_alllist]) $view_file="zboard.php"; else $view_file="view.php";
$view_file = "zboard.php";
movepage($view_file . "?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&no={$no}&category={$category}");
<?php
if (checkAuth() == false) {
movepage("index.php");
exit;
}
url_routing(define_module_combine('1001'), "Logged Out&<center>You have logged out of the application.</center>");
include 'view/logout.php';
}
// 원본글을 가져옴
$s_data = mysql_fetch_array(mysql_query("select * from {$t_comment}" . "_{$id} where no='{$c_no}'"));
// 회원일때를 확인;;
if (!$is_admin && $member[level] > $setup[grant_delete]) {
if (!$s_data[ismember]) {
if ($s_data[password] != $password) {
Error("비밀번호가 올바르지 않습니다");
}
} else {
if ($s_data[ismember] != $member[no]) {
Error("비밀번호를 입력하여 주십시요");
}
}
}
// 코멘트 삭제
mysql_query("delete from {$t_comment}" . "_{$id} where no='{$c_no}'") or error(mysql_error());
// 코멘트 갯수 정리
$total = mysql_fetch_array(mysql_query("select count(*) from {$t_comment}" . "_{$id} where parent='{$no}'"));
mysql_query("update {$t_board}" . "_{$id} set total_comment='{$total['0']}' where no='{$no}'") or error(mysql_error());
// 회원일 경우 해당 해원의 점수 주기
if ($member[no] == $s_data[ismember]) {
@mysql_query("update {$member_table} set point2=point2-1 where no='{$member['no']}'", $connect) or error(mysql_error());
}
@mysql_close($connect);
// 페이지 이동
if ($setup[use_alllist]) {
movepage("zboard.php?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&no={$no}");
} else {
movepage("view.php?id={$id}&page={$page}&page_num={$page_num}&select_arrange={$select_arrange}&desc={$des}&sn={$sn}&ss={$ss}&sc={$sc}&keyword={$keyword}&no={$no}");
}
if ($check[0] > 0) {
Error("The category's name is already exists");
}
@mysql_query("insert into {$t_category}" . "_{$table_data['name']} (name) values ('{$name}')") or error("An occured error when added category");
movepage("{$PHP_SELF}?exec=view_board&exec2=category&no={$no}&page={$page}&page_num={$page_num}&group_no={$group_no}");
} elseif ($exec2 == "del_category") {
$table_data = mysql_fetch_array(mysql_query("select name from {$admin_table} where no='{$no}'"));
mysql_query("delete from {$t_category}" . "_{$table_data['name']} where no='{$category_no}'", $connect) or Error("An occured error when deleted category");
movepage("{$PHP_SELF}?exec=view_board&exec2=category&no={$no}&page={$page}&page_num={$page_num}&group_no={$group_no}");
} elseif ($exec2 == "category_modify_ok") {
if (!$name) {
error("Please input modified category's name");
}
$table_data = mysql_fetch_array(mysql_query("select name from {$admin_table} where no='{$no}'"));
mysql_query("update {$t_category}" . "_{$table_data['name']} set name='{$name}' where no='{$category_no}'", $connect);
movepage("{$PHP_SELF}?exec=view_board&exec2=category&no={$no}&page={$page}&page_num={$page_num}&group_no={$group_no}");
} elseif ($exec2 == "category_move") {
$table_data = mysql_fetch_array(mysql_query("select name from {$admin_table} where no='{$no}'"));
for ($i = 0; $i < count($c); $i++) {
mysql_query("update {$t_board}" . "_{$table_data['name']} set category='{$movename}' where category='{$c[$i]}'", $connect);
}
$result = mysql_query("select * from {$t_category}" . "_{$table_data['name']}") or die(mysql_error());
while ($data = mysql_fetch_array($result)) {
$num = mysql_fetch_array(mysql_query("select count(*) from {$t_board}" . "_{$table_data['name']} where category='{$data['no']}'"));
mysql_query("update {$t_category}" . "_{$table_data['name']} set num='{$num['0']}' where no = '{$data['no']}'") or die(mysql_error());
}
movepage("{$PHP_SELF}?exec=view_board&exec2=category&no={$no}&page={$page}&page_num={$page_num}&group_no={$group_no}");
} elseif ($exec2 == "modify_grant_ok") {
@mysql_query("update {$admin_table} set grant_html='{$grant_html}', grant_list='{$grant_list}',\n\t\t\t\tgrant_view='{$grant_view}', grant_comment='{$grant_comment}', grant_write='{$grant_write}',\n\t\t\t\tgrant_reply='{$grant_reply}', grant_delete='{$grant_delete}', grant_notice='{$grant_notice}',\n\t\t\t\tgrant_view_secret='{$grant_view_secret}', use_showip = '{$grant_imagebox}' where no='{$no}'") or Error("It occured error when change setting permission" . mysql_error());
movepage("{$PHP_SELF}?exec=view_board&exec=view_board&exec2=grant&no={$no}&page={$page}&page_num={$page_num}&group_no={$group_no}");
}
