public function select($req, $params = null) { if (!$this->autoCommit && !$this->inTransaction) { $this->begin(); } if ($params !== null) { $req = $this->emuPrepStmt($req, $params); } return parent::select($req); }
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>"; } }
} /* 정렬 기준 설정 */ 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}]");
function total_count() { $query = new mysqlConnection(); $query->select("select count(*) total_count from toony_admin_counter"); return number_format($query->fetch("total_count")); }
<?php $tpl = new skinController(); $mysql = new mysqlConnection(); /* 기본 정보 로드 */ $mysql->select("\n\t\tSELECT source\n\t\tFROM toony_admin_mailling_template\n\t\tWHERE type='mailling'\n\t"); $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $sourceCode = $mysql->fetch("source"); /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/mailTplMailling.html"); /* 템플릿 치환 */ $tpl->skin_modeling("[sourceCode]", $sourceCode); echo $tpl->skin_echo();
include_once __DIR_PATH__ . "modules/board/install/installCheck.php"; $tpl = new skinController(); $mysql = new mysqlConnection(); $method = new methodController(); $method->method_param("GET", "act,type"); /* 변수 처리 */ if (!$type) { $type = "new"; } /* 수정 모드인 경우 기본 정보 로드 */ if ($type == "modify") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id='{$act}'\n\t\t"); $mysql->fetchArray("write_point,read_point,skin,board_id,name,list_limit,length_limit,use_secret,use_comment,use_likes,use_category,category,use_reply,use_vote,use_file1,use_file2,use_list,file_limit,void_html,controll_level,write_level,read_level,secret_level,comment_level,array_level,reply_level,delete_level,top_file,bottom_file,thumb_width,thumb_height,articleIMG_width,articleIMG_height,article_length,ico_file,ico_mobile,ico_secret,ico_secret_def,ico_new,ico_new_def,ico_hot,ico_hot_def,tc_1,tc_2,tc_3,tc_4,tc_5"); $array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $array['top_source'] = $mysql->fetch("top_source"); $array['bottom_source'] = $mysql->fetch("bottom_source"); } /* 홈페이지&모바일페이지 설정 값이 함께 기록되는 필드인 경우 분리 */ $use_list_exp = explode("|", $array['use_list']); $array['use_list'] = $use_list_exp[0]; $array['use_m_list'] = $use_list_exp[1]; $list_limit_exp = explode("|", $array['list_limit']); $array['list_limit'] = $list_limit_exp[0];
$__toony_board_view = $session->session_selector('__toony_board_view_' . $board_id . '_' . $read); //조회수 세션 /* 패스워드가 submit된 경우 */ if ($s_password != "") { $method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page,where,keyword"); $board_id = $s_board_id; $read = $s_read; $mode = $s_mode; $page = $s_page; } /* 게시물 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t"); $mysql->fetchArray("write_point,read_point,skin,name,use_category,use_comment,use_list,use_likes,use_reply,use_file1,use_file2,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,top_file,bottom_file,articleIMG_width,articleIMG_height,tc_1,tc_2,tc_3,tc_4,tc_5"); $c_array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("top_source,bottom_source"); $c_array = $mysql->array; /* 설정 필드가 홈페이지+모바일페이지의 설정 값을 같이 사용하는 경우 분리 */ if ($viewType == "p") { $ex_slt = 0; } else { $ex_slt = 1; } $use_list_ex = explode("|", $c_array['use_list']);
if ($useMenu_side_val == "disabled" || $useMenu_side == "checked") { $useMenu_side = "Y"; } else { $useMenu_side = "N"; } if ($useMenu_header_val == "disabled" || $useMenu == "checked") { $useMenu = "Y"; } else { $useMenu = "N"; } /* 검사 */ //수정 모든인 경우 검사 if ($type == "modify") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_admin_menuInfo\n\t\t\tWHERE idno='{$org}'\n\t\t"); $lockMenu = $mysql->fetch("lockMenu"); $thisDepth = $mysql->fetch("depth"); $thisClass = $mysql->fetch("class"); $validator->validt_null("name", ""); if ($href == "pm" && trim($link) == "" && $lockMenu != "Y") { $validator->validt_diserror("link", "연결할 페이지 또는 모듈을 선택해 주세요."); } if ($href == "mp" && trim($linkDoc) == "" && $lockMenu != "Y") { $validator->validt_diserror("linkDoc", ""); } if ($href == "fm" && trim($forward) == "" && $lockMenu != "Y") { $validator->validt_diserror("forward", "포워딩 메뉴를 선택해 주세요."); } //1차 메뉴의 header 노출 옵션이 꺼져 있으면, 2차 메뉴는 옵션 활성화 불가 if ($thisDepth == 2 && $useMenu == "Y") {
//원본 게시물을 로드 $mysql->select("\n\t\t\t\tSELECT *\n\t\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\t\tWHERE idno='{$cnum_ex[$i]}'\n\t\t\t"); $ln[$i] = $mysql->fetch("ln"); $rn[$i] = $mysql->fetch("rn"); } for ($i = 0; $i < sizeof($cnum_ex); $i++) { //rn이 0인 부모글인 경우만 이동 실행 if ($rn[$i] == 0) { //글의 최소/최대 ln값 구함 $ln_min = (int) (ceil($ln[$i] / 1000) * 1000) - 1000; $ln_max = (int) (ceil($ln[$i] / 1000) * 1000); //글의 자식들의 범위를 구함 $where = "ln>{$ln_min} AND ln<={$ln_max}"; $mysql->select("\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM toony_module_board_data_{$board_id} \n\t\t\t\t\tWHERE {$where}\n\t\t\t\t"); //대상 게시판의 최대 ln값 불러옴 $tar_mysql->select("\n\t\t\t\t\tSELECT MAX(ln)+1000 AS ln_max\n\t\t\t\t\tFROM toony_module_board_data_{$tar_board_id}\n\t\t\t\t\tWHERE 1\n\t\t\t\t\tORDER BY ln DESC\n\t\t\t\t\tLIMIT 1\n\t\t\t\t"); $tar_ln = $tar_mysql->fetch("ln_max"); if (!$tar_ln) { $tar_ln = 1000; } $tar_ln = ceil($tar_ln / 1000) * 1000; do { $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("idno,category,ln,rn,me_idno,writer,password,email,ment,subject,file1,file1_cnt,file2,file2_cnt,link1,link2,use_secret,use_notice,use_html,use_email,view,ip,regdate,td_1,td_2,td_3,td_4,td_5"); $array = $mysql->array; //가져온 원본들의 내용을 addslashes 시킴 foreach ($array as $key => $value) { $array[$key] = addslashes($array[$key]); } //대상 게시판으로 첨부파일을 복사
<?php $tpl = new skinController(); $header = new skinController(); $loop = new skinController(); $footer = new skinController(); $mysql = new mysqlConnection(); $lib = new libraryClass(); $paging = new pagingClass(); $method = new methodController(); $method->method_param("GET", "page,where,keyword,order,orderby"); /* 기본 정보 로드 */ $mysql->select("\n\t\tSELECT\n\t\tCOUNT(*) total_member,\n\t\t(\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM toony_member_list\n\t\t\tWHERE me_idCheck='Y' AND me_admin!='Y' AND me_drop_regdate IS NULL\n\t\t) total_idCheckMember,\n\t\t(\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM toony_member_list\n\t\t\tWHERE me_idCheck='N' AND me_admin!='Y' AND me_drop_regdate IS NULL\n\t\t) total_noIdCheckMember\n\t\tFROM toony_member_list\n\t\tWHERE me_admin!='Y' AND me_drop_regdate IS NULL\n\t"); $mysql->fetchArray("total_member,total_idCheckMember,total_noIdCheckMember"); $total_info = $mysql->array; /* 검색 키워드 설정 */ if (trim($keyword) != "") { $array_where = $where . " LIKE '%" . $keyword . "%' AND me_admin!='Y' AND me_drop_regdate IS NULL"; } else { $array_where = "me_admin!='Y' AND me_drop_regdate IS NULL"; } /* 정렬 기준 설정 */ if (!$order) { $order = "me_regdate"; }
function call_admin_mainPage($vtype) { global $viewType, $site_config, $member, $viewDir, $member_type_var, $article, $m, $p; //type 변수 내용에 따른 DB 필드명 선언 if ($vtype == "p") { $field = "ad_site_jsmain"; } else { $field = "ad_msite_jsmain"; } //DB에서 메인화면 디자인을 불러옴 $mysql = new mysqlConnection(); $mysql->select("\n\t\t\tSELECT {$field}\n\t\t\tFROM toony_admin_siteconfig\n\t\t"); $items = $mysql->fetch($field); //DB에서 불러온 아이템 문자열을 나누어 각각의 아이템으로 분리 $item = explode("#", $items); $item_count = count($item); //아이템이 어떤 형태인지 구분 for ($i = 1; $i < $item_count; $i++) { $nameLen = substr($item[$i], 0, 7); if (stristr($nameLen, "latest")) { $itemType[$i] = "latest"; } else { if (stristr($nameLen, "banner")) { $itemType[$i] = "banner"; } else { if (stristr($nameLen, "href")) { $itemType[$i] = "href"; } } } } //아이템을 HTML로 변환하여 출력함 (홈페이지) if ($vtype == "p") { for ($i = 1; $i < $item_count; $i++) { $data = explode("|", $item[$i]); $pixel_x = 92; $pixel_y = 40; switch ($itemType[$i]) { case "latest": //박스 크기, 위치 계산 $box_left = ($pixel_x + 10) * ($data[12] - 1); $box_top = $pixel_y * $data[13] - $pixel_y; $box_width = $pixel_x * $data[14] + (($data[14] - 1) * 10 - 10); $box_height = $pixel_y * $data[15] - 20; //게시판 모듈 최근게시물 출력 echo "\n\t\t\t\t\t\t\t<div class=\"latest_" . $data[4] . " " . $data[2] . "\" style=\"position:absolute; left:{$box_left}px; top:{$box_top}px; width:{$box_width}px; height:{$box_height}px; overflow:hidden;\">\n\t\t\t\t\t\t" . call_board_latest($vtype, $data[3], $data[1], $data[5], $data[6], $data[7], $data[4], $data[8], $data[9], $data[10], $data[11]) . "\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t"; break; case "banner": //박스 크기, 위치 계산 $box_left = ($pixel_x + 10) * ($data[6] - 1); $box_top = $pixel_y * $data[7] - $pixel_y; $box_width = $pixel_x * $data[8] + (($data[8] - 1) * 10 - 10); $box_height = $pixel_y * $data[9]; //배너공간 출력 if (!call_admin_mainPage_item(__DIR_PATH__ . "upload/siteInformations/" . $data[2])) { echo "\n\t\t\t\t\t\t\t\t<div class=\"banner\" style=\"position:absolute; left:{$box_left}px; top:{$box_top}px; width:{$box_width}px; height:{$box_height}px;\">\n\t\t\t\t\t\t\t\t\t설정한 배너 이미지 파일이 존재하지 않습니다.\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } else { echo "\n\t\t\t\t\t\t\t\t<div class=\"banner\" style=\"position:absolute; left:{$box_left}px; top:{$box_top}px; width:{$box_width}px; height:{$box_height}px; overflow:hidden;\">\n\t\t\t\t\t\t\t\t\t<a href=\"{$data[3]}\" target=\"_{$data[4]}\" title=\"{$data[5]}\"><img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $data[2] . "\" width=\"{$box_width}\" height=\"{$box_height}\" /></a>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } break; case "href": //박스 크기, 위치 계산 $box_left = ($pixel_x + 10) * ($data[3] - 1); $box_top = $pixel_y * $data[4] - $pixel_y; $box_width = $pixel_x * $data[5] + (($data[5] - 1) * 10 - 10); $box_height = $pixel_y * $data[6]; //외부 문서 출력 if (!call_admin_mainPage_item(__DIR_PATH__ . $data[2] . ".php")) { echo "\n\t\t\t\t\t\t\t\t<div class=\"include\" style=\"position:absolute; left:{$box_left}px; top:{$box_top}px; width:{$box_width}px; height:{$box_height}px;\">\n\t\t\t\t\t\t\t\t\t설정한 외부 문서 파일이 존재하지 않습니다.\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } else { ob_start(); include __DIR_PATH__ . $data[2] . ".php"; $include_html = ob_get_contents(); ob_end_clean(); echo "\n\t\t\t\t\t\t\t\t<div class=\"include\" style=\"position:absolute; left:{$box_left}px; top:{$box_top}px; width:{$box_width}px; height:{$box_height}px; overflow:hidden;\">\n\t\t\t\t\t\t\t" . $include_html . "\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } break; } //화면의 총 height를 구함 $box_total_height = $box_top + $box_height; if ($i == 1) { $total_height = $box_total_height; } if ($box_total_height > $total_height) { $total_height = $box_total_height; } } //아이템을 HTML로 변환하여 출력함 (모바일페이지) } else { $sort = array(); $sort_html = array(); for ($i = 1; $i < $item_count; $i++) { $data = explode("|", $item[$i]); switch ($itemType[$i]) { case "latest": if ($data[4] == "list") { $data[4] = "default"; } //게시판 모듈 최근게시물 출력 $sort[$i] = $data[13]; $sort_html[$i] = "\n\t\t\t\t\t\t\t<div class=\"latest_" . $data[4] . " " . $data[2] . "\" style=\"margin-bottom:10px;\">\n\t\t\t\t\t\t" . call_board_latest($vtype, $data[3], $data[1], $data[5], $data[6], $data[7], $data[4], $data[8], $data[9], $data[10], $data[11]) . "\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t"; break; case "banner": //배너공간 출력 $sort[$i] = $data[7]; if (!call_admin_mainPage_item(__DIR_PATH__ . "upload/siteInformations/" . $data[2])) { $sort_html[$i] = "\n\t\t\t\t\t\t\t\t<div class=\"banner\" style=\"margin-bottom:10px;\">\n\t\t\t\t\t\t\t\t\t설정한 배너 이미지 파일이 존재하지 않습니다.\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } else { $sort_html[$i] = "\n\t\t\t\t\t\t\t\t<div class=\"banner\" style=\"margin-bottom:10px;\">\n\t\t\t\t\t\t\t\t\t<a href=\"{$data[3]}\" target=\"_{$data[4]}\" title=\"{$data[5]}\"><img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $data[2] . "\" style=\"width:100%;\" /></a>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } break; case "href": //외부 문서 출력 $sort[$i] = $data[4]; if (!call_admin_mainPage_item(__DIR_PATH__ . $data[2] . ".php")) { $sort_html[$i] = "\n\t\t\t\t\t\t\t\t<div class=\"include\" style=\"margin-bottom:10px;\">\n\t\t\t\t\t\t\t\t\t설정한 외부 문서 파일이 존재하지 않습니다.\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } else { ob_start(); include __DIR_PATH__ . $data[2] . ".php"; $include_html = ob_get_contents(); ob_end_clean(); $sort_html[$i] = "\n\t\t\t\t\t\t\t\t<div class=\"include\" style=\"margin-bottom:10px;\">\n\t\t\t\t\t\t\t" . $include_html . "\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t"; } break; } } //높이가 높은 순으로 아이템 HTML 출력 asort($sort); foreach ($sort as $key => $val) { echo $sort_html[$key]; } } //화면의 총 height만큼 임의 DIV를 생성 if ($vtype == "p") { echo "\n\t\t\t\t<div style=\"height:" . $total_height . "px;\"></div>\n\t\t\t"; } }
$lib = new libraryClass(); $mysql = new mysqlConnection(); $method = new methodController(); $method->method_param("GET", "act"); /* DB 조건 변수 처리 */ if ($act) { $where = "idno={$act}"; } else { $where = "1"; } /* 메일링 정보 로드 */ $mysql->select("\n\t\tSELECT A.*,B.*\n\t\tFROM toony_admin_mailling A\n\t\tLEFT OUTER JOIN toony_member_list B\n\t\tON A.me_idno=B.me_idno\n\t\tWHERE {$where}\n\t\tORDER BY regdate DESC\n\t\tLIMIT 1\n\t"); $mysql->fetchArray("idno,min_level,max_level,subject,regdate,me_idno,me_nick"); $array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $array['memo'] = $mysql->fetch("memo"); /* 검사 */ if ($mysql->numRows() < 1) { $lib->error_alert_location("존재하지 않는 메일링 입니다.", $site_config['ad_site_url'], "A"); } /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/maillingList_view.html");
$mysql = new mysqlConnection(); $method = new methodController(); $validator = new validator(); $method->method_param("POST", "type,cnum,id,memo,ip"); $lib->security_filter("referer"); $lib->security_filter("request_get"); /************************************************** 추가 모드인 경우 **************************************************/ if ($type == "new") { /* 검사 */ $validator->validt_null("ip", ""); $validator->validt_null("memo", ""); $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_admin_security_ip\n\t\t\tWHERE ip='{$ip}'\n\t\t"); if ($mysql->numRows() > 0) { $validator->validt_diserror("ip", "이미 등록된 ip입니다."); } /* DB 저장 */ $mysql->query("\n\t\t\tINSERT INTO toony_admin_security_ip (ip,memo,regdate)\n\t\t\tVALUES\n\t\t\t('{$ip}','{$memo}',now())\n\t\t"); /* 완료 후 리턴 */ $validator->validt_success("성공적으로 추가 되었습니다.", "admin/?p=blockIP"); /************************************************** 삭제 모드인 경우 **************************************************/ } else {
<?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();
include __DIR_PATH__ . "capcha/zmSpamFree.php"; $method = new methodController(); $lib = new libraryClass(); $mysql = new mysqlConnection(); $session = new sessionController(); $mailSender = new mailSender(); $fileUploader = new fileUploader(); $validator = new validator(); $lib->security_filter("referer"); $lib->security_filter("request_get"); $method->method_param("POST", "article,category,category_ed,board_id,writer,subject,use_secret,use_notice,use_html,use_email,ment,password,email,file1_ed,file2_ed,file1_del,file2_del,read,mode,type,page,where,keyword,capcha,td_1,td_2,td_3,td_4,td_5"); $method->method_param("FILE", "file1,file2"); /* 게시물 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t"); $mysql->fetchArray("write_point,read_point,viewType,name,use_secret,use_comment,use_list,use_reply,use_file1,use_file2,use_vote,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,tc_1,tc_2,tc_3,tc_4,tc_5"); $c_array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $c_array['point_board_name'] = $mysql->fetch("name"); /* 수정/답글 모드인 경우 원본 글 가져옴 */ if ($mode == "modify" || $mode == "reply") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\tWHERE idno={$read}\n\t\t"); $mysql->fetchArray("ln,category,writer,me_idno,idno,use_notice,use_html,use_secret,password,use_email,email,td_1,td_2,td_3,td_4,td_5"); $wquery = $mysql->array; } /* 옵션값 처리
}); </script> </head> <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>
$tpl->skin_file_path("layoutskin/" . CALLED_LAYOUTDIR . "sub.html"); /* 서브페이지 네비게이션 선언 */ if (CALLED_DEPTH == 1) { $where = "callName='" . CALLED_ARTICLE . "'"; } else { if (CALLED_DEPTH == 2) { $where = "(callName='" . CALLED_ARTICLE . "') OR (class='" . CALLED_CLASS . "' AND depth=1)"; } else { if (CALLED_DEPTH == 3) { $where = "(callName='" . CALLED_ARTICLE . "') OR (class='" . CALLED_CLASS . "' AND depth=1) OR (idno='" . CALLED_PARENT . "' AND depth=2)"; } } } $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE vtype='" . CALLED_VIEWTYPE . "' AND drop_regdate IS NULL AND ({$where})\n\t\tORDER BY depth ASC\n\t"); $naviTxt = "<a href=\"{$site_config['ad_site_url']}" . CALLED_VIEWDIR . "\">{$site_config['ad_site_name']}</a>"; //depth가 1인 경우 1차 메뉴 출력 if (CALLED_DEPTH == 1) { $naviTxt .= " > <a href=\"?article=" . $mysql->fetch("callName") . "\">" . $mysql->fetch("name") . "</a>"; //depth가 2 이상인 경우 2차 메뉴 출력 } else { do { $naviTxt .= " > <a href=\"?article=" . $mysql->fetch("callName") . "\">" . $mysql->fetch("name") . "</a>"; } while ($mysql->nextRec()); } /* 템플릿 치환 */ $tpl->skin_modeling("[/layoutskinDir/]", __URL_PATH__ . "layoutskin/" . CALLED_LAYOUTDIR); $tpl->skin_modeling("[subpage_title]", $mysql->fetch("name"));
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; }
패스워드가 submit 된 경우 GET변수를 POST변수로 변환 */ if ($s_password != "") { $method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page"); $board_id = $s_board_id; $read = $s_read; $mode = $s_mode; $page = $s_page; } if (isset($HTTP_POST_VARS['keyword'])) { $method->method_param("POST", "where,keyword"); } /* 게시물 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t"); $mysql->fetchArray("skin,title,use_comment,use_list,use_secret,use_category,category,use_reply,use_file1,use_file2,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,top_file,bottom_file,ico_secret_def,tc_1,tc_2,tc_3,tc_4,tc_5"); $c_array = $mysql->array; $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("top_source,bottom_source"); $c_array = $mysql->array; /* 수정 혹은 답글 모드인 경우 원본글 정보를 로드 */ if ($mode == "modify" || $mode == "reply") { $mysql->select("\n\t\t\tSELECT A.*,CEIL(A.ln) ceil_ln,\n\t\t\t(\n\t\t\t\tSELECT COUNT(*)\n\t\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\t\tWHERE ln<=((ceil_ln/1000)*1000) AND ln>((ceil_ln/1000)*1000)-1000 AND rn>0\n\t\t\t) reply_count\n\t\t\tFROM toony_module_board_data_{$board_id} A\n\t\t\tWHERE A.idno='{$read}'\n\t\t"); $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("idno,reply_count,me_idno,subject,writer,category,me_nick,view,vote,password,email,ment,use_notice,use_secret,use_email,use_html,me_idno,file1,file2,rn,td_1,td_2,td_3,td_4,td_5"); $array = $mysql->array;
<?php include "../../include/engine.inc.php"; include __DIR_PATH__ . "include/global.php"; $lib = new libraryClass(); $mysql = new mysqlConnection(); $method = new methodController(); $validator = new validator(); $lib->security_filter("referer"); $lib->security_filter("request_get"); $method->method_param("POST", "writer,comment,reply_writer_o,reply_comment_o,comment_modify,cidno,type,mode,board_id,read,page,where,keyword,tr_1,tr_2,tr_3,tr_4,tr_5"); /* 게시물 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t"); $mysql->fetchArray("viewType,name,use_comment,use_list,use_reply,use_file1,use_file2,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,tc_1,tc_2,tc_3,tc_4,tc_5"); $c_array = $mysql->array; /* 검사 */ mb_internal_encoding('UTF-8'); if ($c_array['use_comment'] == "N") { $validator->validt_diserror("", "댓글 기능이 비활성 중입니다."); } if ($member['me_level'] > $c_array['comment_level']) { $validator->validt_diserror("", "권한이 없습니다."); } /* 댓글 등록 */ if ($mode == 1) {
//입력값 검사 if ($type == "new" || $type == "modify") { $validator->validt_idx("name", 1, ""); $validator->validt_null("memo", ""); $validator->validt_number("btop", 0, 5, 1, ""); $validator->validt_number("bleft", 0, 5, 1, ""); if ($start_level < $end_level) { $validator->validt_diserror("start_level", "최소 레벨이 최대 레벨보다 클 수 없습니다."); } if ($pop_article == "select" && trim($pop_article_txt) == "") { $validator->validt_diserror("pop_article_txt", ""); } } //추가 모드인 경우 추가 입력값 검사 if ($type == "new") { $mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_admin_popupconfig\n\t\t\tWHERE name='{$name}'\n\t\t"); if ($mysql->numRows() > 0) { $validator->validt_diserror("name", "이미 존재하는 코드입니다."); } if (!$img['name']) { $validator->validt_diserror("img", "팝업 이미지를 등록해 주세요."); } } /* 팝업 이미지 업로드 */ $fileUploader->savePath = __DIR_PATH__ . "upload/siteInformations/"; $fileUploader->filedotType = "jpg,bmp,gif,png"; if ($type == "modify" || $type == "new") { if ($img['size'] > 0) { $fileUploader->saveFile = $img;
$subpage = new skinController(); $mysql = new mysqlConnection(); $method->method_param("GET", "article,m,p,saveViewType,keepViewType"); /* 검사 */ if (!$article && ($m || $p)) { $lib->error_alert_location("올바르지 않은 접근 입니다.", $site_config['ad_site_url'], "A"); } if (!$article) { $article = "main"; } /* 메뉴 타입이 포워딩인 경우 포워딩 대상 메뉴로 article 변환 */ $mysql->select("\n\t\tSELECT href,forward\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE callName='{$article}' AND vtype='p' AND drop_regdate IS NULL\n\t"); if ($mysql->fetch("href") == "fm") { $article = $mysql->fetch("forward"); } /* article로 DB를 색인하여 페이지 링크,링크문서 정보를 로드함 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE callName='{$article}' AND drop_regdate IS NULL AND vtype='p'\n\t"); $mysql->fetchArray("link,linkDoc,class,href,depth,parent"); $menuInfo = $mysql->array; /* 메뉴 타입이 수동 문서 연결인 경우 */ if ($menuInfo['href'] == "mp") { $p = $lib->htmldecode($menuInfo['linkDoc']); /*
<?php include "../../include/engine.inc.php"; include __DIR_PATH__ . "include/global.php"; $mysql = new mysqlConnection(); $method = new methodController(); $method->method_param("GET", "board_id,file"); $file = urldecode($file); $filepath = __DIR_PATH__ . "modules/board/upload/" . $board_id . "/" . $file; $filename = iconv("UTF-8", "EUC-KR", $file); /* 게시물 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_data_{$board_id}\n\t\tWHERE file1='{$file}' OR file2='{$file}'\n\t"); $file1_name = $mysql->fetch("file1"); $file2_name = $mysql->fetch("file2"); /* 첨부된 파일이 file1 인지 file2 인지 확인 */ if ($file1_name == $file) { $file_tar = 'file1'; $td_tar = 'file1_cnt'; } else { if ($file2_name == $file) { $file_tar = 'file2'; $td_tar = 'file2_cnt'; } else { exit; } } /*
<?php include_once "../include/pageJustice.inc.php"; $tpl = new skinController(); $method = new methodController(); $lib = new libraryClass(); $mysql = new mysqlConnection(); $method->method_param("GET", "redirect"); /* 검사 */ if ($member['me_level'] < 10) { $lib->error_alert_location("이미 로그인 되어 있습니다.", $site_config['ad_site_url'], "A"); } /* 최고 운영자 이메일 로드 */ $mysql->select("\n\t\tSELECT me_id\n\t\tFROM toony_member_list\n\t\tWHERE me_admin='Y' AND me_drop_regdate IS NULL\n\t\tLIMIT 1\n\t"); $admin_email = $mysql->fetch("me_id"); /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/login.html"); /* 템플릿 치환 */ $tpl->skin_modeling("[admin_email]", $admin_email); $tpl->skin_modeling("[redirectUri]", urlencode($redirect)); echo $tpl->skin_echo();
<?php $tpl = new skinController(); $lib = new libraryClass(); $mysql = new mysqlConnection(); /* 검사 */ if ($member['me_admin'] != "Y") { $lib->error_alert_location("접근 권한이 없습니다.", $site_config[ad_site_url], "A"); } /* 최고 운영자 기본 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_member_list\n\t\tWHERE me_admin='Y' AND me_level=1\n\t"); $mysql->fetchArray("me_id,me_nick,me_sex,me_phone,me_telephone,me_password,me_point"); $array = $mysql->array; /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/adminInfo.html"); /* 템플릿 함수 */ function sex_checked_value_func($obj) { global $array; switch ($array['me_sex']) { case "M": if ($obj == "M") { return "checked";
<?php $mysql = new mysqlConnection(); $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE 1\n\t\tORDER BY regdate DESC\n\t"); $moduleOption = "<optgroup label=\"게시판\">"; do { if ($mysql->numRows() > 0) { $linkRe = "?m=board&board_id=" . $mysql->fetch("board_id"); $selected_var = ""; if ($linkRe == $array[link]) { $selected_var = "selected"; } $moduleOption .= "<option value=\"" . $linkRe . "\" " . $selected_var . ">" . $mysql->fetch("name") . " (" . $mysql->fetch("board_id") . ")</option>\n"; } } while ($mysql->nextRec()); $moduleOption .= "</optgroup>"; echo $moduleOption;
} $validator->validt_checked("chk_agreement", "이용약관에 동의해야 합니다."); $validator->validt_checked("chk_private", "개인정보취급방침에 동의해야 합니다."); $validator->validt_email("id", 1, ""); $validator->validt_password("password", 1, ""); if ($password != $password02) { $validator->validt_diserror("password02", ""); } $validator->validt_nick("nick", 1, ""); $validator->validt_phone("phone", 0, ""); $validator->validt_phone("telephone", 0, ""); $password_val = "password('{$password}')"; /* 이미 존재하는 아이디인지 검사 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_member_list\n\t\tWHERE me_id='{$id}' AND me_drop_regdate IS NULL\n\t"); if ($mysql->numRows() > 0) { $validator->validt_diserror("id", "이미 존재하는 아이디입니다."); } /* DB 기록 */ $mysql->query("\n\t\tINSERT INTO toony_member_list\n\t\t(me_id,me_password,me_nick,me_sex,me_phone,me_telephone,me_regdate)\n\t\tVALUES\n\t\t('{$id}',{$password_val},'{$nick}','{$sex}','{$phone}','{$telephone}',now())\n\t"); /* 회원 코드를 가져옴 */ $mysql->select("\n\t\tSELECT me_idno\n\t\tFROM toony_member_list\n\t\tWHERE me_id='{$id}' AND me_password=password('{$password}') AND me_drop_regdate IS NULL\n\t"); $member['me_idno'] = $mysql->fetch("me_idno"); /* 가입 이력이 없는 새로운 가입인 경우 아이디 인증 메일 발송 */
$('table').visualize({ 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());
<?php include "../../include/engine.inc.php"; include __DIR_PATH__ . "include/global.php"; $lib = new libraryClass(); $mysql = new mysqlConnection(); $method = new methodController(); $validator = new validator(); $lib->security_filter("referer"); $lib->security_filter("request_get"); $method->method_param("POST", "board_id,read_idno,mode"); /* 게시물 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t"); $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) {
<?php $tpl = new skinController(); $mysql = new mysqlConnection(); $lib = new libraryClass(); $method->method_param("GET", "vtype"); /* 변수 처리 */ if (!$vtype || $vtype != "p" && $vtype != "m") { $vtype = "p"; } /* 기본 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_admin_design_mainVisual\n\t\tWHERE vtype='{$vtype}'\n\t"); $mysql->htmlspecialchars = 0; $mysql->nl2br = 0; $mysql->fetchArray("scriptCode,sourceCode"); $array = $mysql->array; /* 템플릿 로드 */ $tpl->skin_file_path("admin/_tpl/mainVisual.html"); /* 템플릿 함수 */ function tab_active($tab_vtype) { global $vtype; if ($vtype == $tab_vtype) {