function confCopy_options() { global $array; $options = NULL; $mysql = new mysqlConnection(); $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id!='{$array['board_id']}'\n\t\t\tORDER BY name ASC\n\t\t"); if ($mysql->numRows() > 0) { $options = "<option value=\"NONE\">게시판 선택</option>"; do { $options .= "<option value=\"" . $mysql->fetch("board_id") . "\">" . $mysql->fetch("name") . " (" . $mysql->fetch("board_id") . ")</option>"; } while ($mysql->nextRec()); return $options; } else { return $options .= "<option value=\"NONE\">복사 대상 없음</option>"; } }
$mysql->fetchArray("use_likes"); $c_array = $mysql->array; /* 검사 */ if ($c_array['use_likes'] == "N") { $validator->validt_diserror("", "추천 기능 비활성 중입니다."); } if ($member['me_level'] > 9) { $validator->validt_diserror("", "추천 권한이 없습니다.\n\n추천/비추천은 회원만 가능합니다."); } /* 이미 추천.비추천 했는지 검사 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_like\n\t\tWHERE board_id='{$board_id}' AND read_idno='{$read_idno}' AND me_idno='{$member['me_idno']}'\n\t"); if ($mysql->numRows() > 0) { $validator->validt_diserror("", "이미 참여 하였습니다."); } /* 추천/비추천 처리 */ if ($mode == "likes") { $likes = 1; $unlikes = 0; $return_where = "AND likes>0"; } else { $likes = 0; $unlikes = 1; $return_where = "AND unlikes>0"; } $mysql->query("\n\t\tINSERT INTO toony_module_board_like\n\t\t(board_id,read_idno,me_idno,likes,unlikes,regdate)\n\t\tVALUES\n\t\t('{$board_id}','{$read_idno}','{$member['me_idno']}','{$likes}','{$unlikes}',now())\n\t");
/* 정렬 기준 설정 */ if (!$order) { $order = "me_drop_regdate"; } if (!$orderby) { $orderby = "DESC"; } $array_order = $order . " " . $orderby; /* 페이징 설정 */ $paging_query = "\n\t\tSELECT * \n\t\tFROM toony_member_list\n\t\tWHERE {$array_where}\n\t\tORDER BY {$array_order}\n\t"; $mysql->select($paging_query); $paging_query_no = $mysql->numRows(); $paging->page_param($page); $total_num = $paging->setTotal($paging_query_no); $paging->setListPerPage(10); $sql = $paging->getPaggingQuery($paging_query); $mysql->select($sql); $array_total = $mysql->numRows(); /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/leaveMember.html"); $header->skin_html_load($tpl->skin); $header->skin_loop_header("[{loop_start}]"); $loop->skin_html_load($tpl->skin); $loop->skin_loop_array("[{loop_start}]", "[{loop_end}]"); $footer->skin_html_load($tpl->skin);
$array['use_ico_secret_m'] = $ico_secret_exp[1]; $array['use_ico_secret_def'] = $array['ico_secret_def']; $ico_new_exp = explode("|", $array['ico_new']); $array['use_ico_new_p'] = $ico_new_exp[0]; $array['use_ico_new_m'] = $ico_new_exp[1]; $ico_hot_exp = explode("|", $array['ico_hot']); $array['use_ico_hot_p'] = $ico_hot_exp[0]; $array['use_ico_hot_m'] = $ico_hot_exp[1]; $ico_hot_def_exp = explode("|", $array['ico_hot_def']); $array['ico_hot_def0'] = $ico_hot_def_exp[0]; $array['ico_hot_def1'] = $ico_hot_def_exp[1]; $array['ico_hot_def2'] = $ico_hot_def_exp[2]; /* 검사 */ if ($type == "modify" && $mysql->numRows() < 1) { $lib->error_alert_location("게시판이 존재하지 않습니다.", $site_config['ad_site_url'], "A"); } if (!$type) { $lib->error_alert_location("호출 값이 없습니다.", $site_config['ad_site_url'], "A"); } /* 템플릿 로드 */ $tpl->skin_file_path("modules/board/admin/_tpl/boardList_modify.html"); /* 템플릿 함수 */ function use_checked($var, $fieldName) { global $array;
if ($viewType == "p") { $ex_slt = 0; } else { $ex_slt = 1; } $use_list_ex = explode("|", $c_array['use_list']); $c_array['use_list'] = $use_list_ex[$ex_slt]; $articleIMG_width_ex = explode("|", $c_array['articleIMG_width']); $c_array['articleIMG_width'] = $articleIMG_width_ex[$ex_slt]; $articleIMG_height_ex = explode("|", $c_array['articleIMG_height']); $c_array['articleIMG_height'] = $articleIMG_height_ex[$ex_slt]; /* 게시물 정보 로드 */ $mysql->select("\n\t\tSELECT\n\t\t(\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM toony_module_board_like\n\t\t\tWHERE board_id='{$board_id}' AND read_idno='{$read}' AND likes>0\n\t\t) likes_count,\n\t\t(\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM toony_module_board_like\n\t\t\tWHERE board_id='{$board_id}' AND read_idno='{$read}' AND unlikes>0\n\t\t) unlikes_count,\n\t\tA.*\n\t\tFROM toony_module_board_data_{$board_id} A\n\t\tWHERE A.idno='{$read}'\n\t"); if ($mysql->numRows() < 1) { $lib->error_alert_location("해당 게시물이 존재하지 않습니다.", __URL_PATH__ . $viewDir, "A"); } $mysql->htmlspecialchars = 1; $mysql->nl2br = 1; $mysql->fetchArray("rn,ln,category,regdate,subject,writer,me_idno,cmtnum,view,vote,password,use_secret,use_notice,use_html,me_idno,file1,file1_cnt,file2,file2_cnt,likes_count,unlikes_count,td_1,td_2,td_3,td_4,td_5"); $array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("ment"); $array = $mysql->array; /* 게시물이 답글이고, 회원에 대한 답글인 경우 부모글의 정보를 로드 */ if ($array['rn'] > 0 && $array['password'] == "") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\tWHERE ln>{$array['ln']} AND rn={$array['rn']}-1\n\t\t\tORDER BY ln ASC\n\t\t\tLIMIT 1\n\t\t");
include "../../../include/engine.inc.php"; include __DIR_PATH__ . "include/global.php"; $lib = new libraryClass(); $mysql = new mysqlConnection(); $method = new methodController(); $validator = new validator(); $method->method_param("POST", "type,board_id,skin,name,use_list,use_m_list,use_secret,use_comment,use_likes,use_reply,use_category,category,use_file1,use_file2,file_limit,list_limit,list_m_limit,length_limit,length_m_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,controll_level,reply_level,write_point,read_point,top_file,top_source,bottom_file,bottom_source,thumb_width,thumb_m_width,thumb_height,thumb_m_height,articleIMG_width,articleIMG_m_width,articleIMG_height,articleIMG_m_height,article_length,article_m_length,ico_file_p,ico_file_m,ico_mobile_p,ico_mobile_m,ico_secret_p,ico_secret_m,ico_secret_def,ico_new_p,ico_new_m,ico_new_def,ico_hot_def_v,ico_hot_def_r,ico_hot_def_type,ico_hot_p,ico_hot_m,tc_1,tc_2,tc_3,tc_4,tc_5"); $lib->security_filter("referer"); $lib->security_filter("request_get"); /* 검사 */ if ($type == "new") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id='{$board_id}'\n\t\t"); if ($mysql->numRows() > 0) { $validator->validt_diserror("board_id", "이미 존재하는 코드입니다."); } $validator->validt_idx("board_id", 1, ""); } $validator->validt_null("name", ""); $validator->validt_number("list_limit", 1, 10, 1, ""); $validator->validt_number("list_m_limit", 1, 10, 1, ""); $validator->validt_number("length_limit", 1, 10, 1, ""); $validator->validt_number("length_m_limit", 1, 10, 1, ""); $validator->validt_number("file_limit", 1, 10, 1, ""); $validator->validt_number("article_length", 1, 10, 1, ""); $validator->validt_number("article_m_length", 1, 10, 1, ""); $validator->validt_number("write_point", 1, 10, 1, ""); $validator->validt_number("read_point", 1, 10, 1, ""); $validator->validt_number("thumb_width", 1, 10, 1, "");
<body> <table style="display:none;"> <thead> <tr> <th>여자</th> <th>남자</th> </tr> </thead> <tbody> <tr> <th>여자</th> <?php $mysql->select("\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM toony_member_list\n\t\t\t\t\tWHERE me_sex='F'\n\t\t\t\t"); ?> <td><?php echo (int) $mysql->numRows(); ?> </td> </tr> <tr> <th>남자</th> <?php $mysql->select("\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM toony_member_list\n\t\t\t\t\tWHERE me_sex='M'\n\t\t\t\t"); ?> <td><?php echo (int) $mysql->numRows(); ?> </td> </tr> </tbody> </table>
type:'area', width:'557px', height:'130px', lineWeight:'2' }); }); </script> </head> <body> <table style="display:none;"> <thead> <tr> <td></td> <?php $mysql->select("\n\t\t\t\t\tSELECT DATE_FORMAT(regdate,'%m') month,DATE_FORMAT(regdate,'%Y') year\n\t\t\t\t\tFROM toony_admin_counter \n\t\t\t\t\tWHERE regdate>DATE_SUB(now(),INTERVAL 5 month)\n\t\t\t\t\tGROUP BY year,month\n\t\t\t\t\tORDER BY year ASC, month ASC\n\t\t\t\t\tLIMIT 6\n\t\t\t\t"); $monthCount = $mysql->numRows(); if ($mysql->numRows() > 0) { do { $mysql->fetchArray("year,month"); $array = $mysql->array; ?> <th><?php echo $array['year']; ?> .<?php echo $array['month']; ?> </th> <?php } while ($mysql->nextRec()); }
function call_board_latest($viewType, $article, $board_id, $line, $length, $ment_length, $skin, $width, $height, $margin, $quard) { if ($viewType == "p") { $viewDir = ""; $viewSkinType = ""; } else { $viewDir = "m/"; $viewSkinType = "_mobile"; } $mysql = new mysqlConnection(); $tpl = new skinController(); $lib = new libraryClass(); $tpl = new skinController(); $header = new skinController(); $loop = new skinController(); $footer = new skinController(); $mysql->select("\n\t\t\tSELECT name\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id='{$board_id}'\n\t\t"); $mysql->fetchArray("name"); $array = $mysql->array; //게시판이 존재하지 않는다면 오류 출력 if (!$array['name']) { return "최근게시물에서 설정된 게시판이 존재하지 않습니다."; } //게시판이 존재한다면 게시물 출력 $mysql->select("\n\t\t\tSELECT\n\t\t\t(\n\t\t\t\tSELECT COUNT(*)\n\t\t\t\tFROM toony_module_board_comment_{$board_id}\n\t\t\t\tWHERE bo_idno=A.idno\n\t\t\t) comment,\n\t\t\t(\n\t\t\t\tSELECT ico_new_def\n\t\t\t\tFROM toony_module_board_config\n\t\t\t\tWHERE board_id='{$board_id}'\n\t\t\t) ico_new_def,\n\t\t\t(\n\t\t\t\tSELECT ico_hot_def\n\t\t\t\tFROM toony_module_board_config\n\t\t\t\tWHERE board_id='{$board_id}'\n\t\t\t) ico_hot_def,\n\t\t\tA.*\n\t\t\tFROM toony_module_board_data_{$board_id} A\n\t\t\tWHERE A.use_notice='N' AND rn=0\n\t\t\tORDER BY A.ln DESC, A.regdate DESC\n\t\t\tLIMIT {$line}\n\t\t"); //최근게시물 템플릿 로드 $tpl->skin_file_path("modules/board/latestskin/{$skin}/index{$viewSkinType}.html"); $header->skin_html_load($tpl->skin); $header->skin_loop_header("[{loop_start}]"); $loop->skin_html_load($tpl->skin); $loop->skin_loop_array("[{loop_start}]", "[{loop_end}]"); $footer->skin_html_load($tpl->skin); $footer->skin_loop_footer("[{loop_end}]"); //header 템플릿 치환 $header->skin_modeling('[/latestskinDir/]', __URL_PATH__ . "modules/board/latestskin/" . $skin . "/"); $header->skin_modeling('[title]', htmlspecialchars($array['name'])); $header->skin_modeling('[board_link]', __URL_PATH__ . $viewDir . '?article=' . $article); $tpl = $header->skin_echo(); //loop 템플릿 치환 if ($mysql->numRows() > 0) { do { $array['memo'] = strip_tags($mysql->fetch("memo")); $mysql->htmlspecialchars = 0; $mysql->fetchArray("board_id,idno,subject,ment,regdate,idno,file1,file2,comment,writer,ico_new_def,ico_hot_def,view,use_secret"); $array = $mysql->array; $loop->skin_modeling('[/latestskinDir/]', __URL_PATH__ . "modules/board/latestskin/" . $skin . "/"); $loop->skin_modeling('[thumbnail]', call_board_latest_thumbnail_func($viewType, $article, $board_id, $array['idno'], $array['file1'], $array['file2'], $array['ment'], $width, $height, $quard, $margin)); $loop->skin_modeling('[subject]', $lib->func_length_limit($array['subject'], 0, $length)); $loop->skin_modeling('[ment]', $lib->func_length_limit(strip_tags($array['ment']), 0, $ment_length)); $loop->skin_modeling('[date]', date("Y.m.d", strtotime($array['regdate']))); $loop->skin_modeling('[nick]', $array['writer']); $loop->skin_modeling('[comment]', latest_comment_func($array['comment'])); $loop->skin_modeling('[link]', __URL_PATH__ . $viewDir . '?article=' . $article . '&p=read&read=' . $array['idno']); $loop->skin_modeling('[new_ico]', latest_new_ico($array['ico_new_def'], $array['regdate'])); $loop->skin_modeling('[hot_ico]', latest_hot_ico($array['ico_hot_def'], $array['likes_count'], $array['view'])); $loop->skin_modeling('[secret_ico]', latest_secret_ico($array['use_secret'])); $tpl .= $loop->skin_echo(); } while ($mysql->nextRec()); } //footer 템플릿 치환 if ($mysql->numRows() < 1) { $footer->skin_modeling_hideArea("[{not_loop_start}]", "[{not_loop_end}]", "show"); } else { $footer->skin_modeling_hideArea("[{not_loop_start}]", "[{not_loop_end}]", "hide"); } $footer->skin_modeling('[/latestskinDir/]', __URL_PATH__ . "modules/board/latestskin/" . $skin . "/"); $footer->skin_modeling('[title]', htmlspecialchars($array['name'])); $footer->skin_modeling('[board_link]', __URL_PATH__ . $viewDir . '?article=' . $article); $tpl .= $footer->skin_echo(); return $tpl; }
$tar_mysql->query("\n\t\t\t\t\t\tINSERT INTO\n\t\t\t\t\t\ttoony_module_board_data_{$tar_board_id}\n\t\t\t\t\t\t(category,ln,rn,me_idno,writer,password,email,ment,subject,file1,file1_cnt,file2,file2_cnt,link1,link2,use_secret,use_html,use_email,view,ip,regdate,td_1,td_2,td_3,td_4,td_5)\n\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t('{$array['category']}','{$tar_ln}','{$array['rn']}','{$array['me_idno']}','{$array['writer']}','{$array['password']}','{$array['email']}','{$array['ment']}','{$array['subject']}','{$file1Name}','{$array['file1_cnt']}','{$file2Name}','{$array['file2_cnt']}','{$array['link1']}','{$array['link2']}','{$array['use_secret']}','{$array['use_html']}','{$array['use_email']}','{$array['view']}','{$array['ip']}',now(),'{$array['td_1']}','{$array['td_2']}','{$array['td_3']}','{$array['td_4']}','{$array['td_5']}')\n\t\t\t\t\t"); //이동된 글의 idno값을 다시 불러옴 $tar_mysql->select("\n\t\t\t\t\t\tSELECT idno\n\t\t\t\t\t\tFROM toony_module_board_data_{$tar_board_id}\n\t\t\t\t\t\tWHERE ln='{$tar_ln}'\n\t\t\t\t\t"); $tar_read_idno = $tar_mysql->fetch("idno"); //좋아요 이동 $tar_mysql->query("\n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\ttoony_module_board_like\n\t\t\t\t\t\tSET\n\t\t\t\t\t\tboard_id='{$tar_board_id}',read_idno='{$tar_read_idno}'\n\t\t\t\t\t\tWHERE board_id='{$board_id}' AND read_idno='{$array['idno']}'\n\t\t\t\t\t"); //댓글 복사를 위한 대상 댓글 테이블의 ln값 구함 $tar_mysql->select("\n\t\t\t\t\t\tSELECT MAX(ln)+1000 AS ln_max\n\t\t\t\t\t\tFROM toony_module_board_comment_{$tar_board_id}\n\t\t\t\t\t\tWHERE 1\n\t\t\t\t\t\tORDER BY ln DESC\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t"); $c_tar_ln = $tar_mysql->fetch("ln_max"); if (!$c_tar_ln) { $c_tar_ln = 1000; } $c_tar_ln = ceil($c_tar_ln / 1000) * 1000; //댓글 복사를 위한 원본 댓글 테이블의 댓글 추출 $tar_mysql->select("\n\t\t\t\t\t\tSELECT *\n\t\t\t\t\t\tFROM toony_module_board_comment_{$board_id}\n\t\t\t\t\t\tWHERE bo_idno='{$array['idno']}'\n\t\t\t\t\t"); if ($tar_mysql->numRows() > 0) { do { $tar_mysql->htmlspecialchars = 0; $tar_mysql->nl2br = 0; $tar_mysql->fetchArray("ln,rn,bo_idno,me_idno,writer,comment,ip,regdate,tr_1,tr_2,tr_3,tr_4,tr_5"); $c_array = $tar_mysql->array; //가져온 원본들의 내용을 addslashes 시킴 foreach ($c_array as $key => $value) { $c_array[$key] = addslashes($c_array[$key]); } $c_tar_mysql->query("\n\t\t\t\t\t\t\t\tINSERT INTO\n\t\t\t\t\t\t\t\ttoony_module_board_comment_{$tar_board_id}\n\t\t\t\t\t\t\t\t(ln,rn,bo_idno,me_idno,writer,comment,ip,regdate,tr_1,tr_2,tr_3,tr_4,tr_5)\n\t\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t\t('{$c_array['ln']}','{$c_array['rn']}','{$tar_read_idno}','{$c_array['me_idno']}','{$c_array['writer']}','{$c_array['comment']}','{$c_array['ip']}','{$c_array['regdate']}','{$c_array['tr_1']}','{$c_array['tr_2']}','{$c_array['tr_3']}','{$c_array['tr_4']}','{$c_array['tr_5']}')\n\t\t\t\t\t\t\t"); } while ($tar_mysql->nextRec()); } //기존 댓글 삭제 $tar_mysql->query("\n\t\t\t\t\t\tDELETE\n\t\t\t\t\t\tFROM toony_module_board_comment_{$board_id}\n\t\t\t\t\t\tWHERE bo_idno='{$array['idno']}'\n\t\t\t\t\t"); //원본글 삭제
<?php include "../include/engine.inc.php"; include __DIR_PATH__ . "include/global.php"; $lib = new libraryClass(); $mysql = new mysqlConnection(); $method = new methodController(); $mailSender = new mailSender(); $lib->security_filter("referer"); $lib->security_filter("request_get"); $method->method_param("POST", "min_level,max_level"); /* 검사 */ if ($min_level == "none") { echo '<!--error::null_min_level-->'; exit; } if ($max_level == "none") { echo '<!--error::null_max_level-->'; exit; } /* 발송 대상 인원수 구함 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_member_list\n\t\tWHERE (me_level<={$min_level} AND me_level>={$max_level}) AND me_drop_regdate IS NULL\n\t\tORDER BY me_regdate DESC\n\t"); /* 완료 후 리턴 */ echo $mysql->numRows();
$btn .= "<li><a href=\"" . __URL_PATH__ . "admin/\">관리모드</a></li>"; } return $btn; } /* 템플릿 치환 */ //header $header->skin_modeling("[logo]", site_logo()); $header->skin_modeling("[site_url]", site_url_func()); $header->skin_modeling("[site_name]", $site_config['ad_site_name']); $header->skin_modeling("[status]", status_func()); $header->skin_modeling("[/layoutskinDir/]", __URL_PATH__ . "layoutskin/" . CALLED_LAYOUTDIR); echo $header->skin_echo(); //loop $max_repeat = $mysql->numRows(); if ($mysql->numRows() > 0) { $depthRound = 0; $repeatCount = 0; do { $mysql->fetchArray("idno,callName,name,class,depth,zindex,link,linkDoc,img,img2,lockMenu,href"); $array = $mysql->array; //현재 페이지가 메뉴의 링크와 같을 경우 '.active' 클래스 추가, //메뉴 이미지가 있는 경우 메뉴명을 이미지로 대체 if ((CALLED_ARTICLE == $array['callName'] || CALLED_CLASS == $array['idno']) && $array['lockMenu'] == "N") { if ($array['img2']) { $menu_img = "<img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $array['img2'] . "\" />"; } else { if ($array['img']) { $menu_img = "<img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $array['img'] . "\" />"; } else {