<?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"); /* 검색 키워드 설정 */ if (trim($keyword) != "") { $array_where = $where . " LIKE '%" . $keyword . "%' AND me_admin!='Y' AND me_drop_regdate IS NOT NULL"; } else { $array_where = "me_admin!='Y' AND me_drop_regdate IS NOT NULL"; } /* 정렬 기준 설정 */ if (!$order) { $order = "me_drop_regdate"; } if (!$orderby) { $orderby = "DESC"; } $array_order = $order . " " . $orderby; /* 페이징 설정
<?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"); /* 검색 키워드 설정 */ if (trim($keyword) != "") { $array_where = $where . " LIKE '%" . $keyword . "%'"; } else { $array_where = "1"; } /* 페이징 설정 */ $paging_query = "\n\t\tSELECT *\n\t\tFROM toony_admin_security_member\n\t\tWHERE {$array_where}\n\t\tORDER BY regdate DESC\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();
<?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,vtype"); /* 변수 처리 */ if (!$vtype || $vtype != "p" && $vtype != "m") { $vtype = "p"; } /* 페이징 설정 */ $paging_query = "\n\t\tSELECT * \n\t\tFROM toony_page_list\n\t\tWHERE vtype='{$vtype}'\n\t\tORDER BY regdate DESC\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(); /* 템플릿 함수
<?php include_once __DIR_PATH__ . "include/pageJustice.inc.php"; $tpl = new skinController(); $header = new skinController(); $notice_loop = new skinController(); $array_loop = new skinController(); $footer = new skinController(); $method = new methodController(); $lib = new libraryClass(); $mysql = new mysqlConnection(); $paging = new pagingClass(); $method->method_param("GET", "where,keyword,page,read,category"); /* 게시판 설정 정보 로드 */ $mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config \n\t\tWHERE board_id='{$board_id}'\n\t"); $mysql->fetchArray("board_id,name,use_list,use_comment,use_category,use_likes,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,controll_level,reply_level,regdate,skin,top_file,bottom_file,thumb_width,thumb_height,article_length,ico_file,ico_secret,ico_new,ico_new_def,ico_hot,ico_hot_def,ico_mobile,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,category"); $c_array = $mysql->array; /* 설정 필드가 홈페이지+모바일페이지의 설정 값을 같이 사용하는 경우 분리 */ if ($viewType == "p") { $ex_slt = 0; } else { $ex_slt = 1; }
<?php include_once "../include/engine.inc.php"; include_once __DIR_PATH__ . "include/global.php"; $tpl = new skinController(); $header = new skinController(); $loop = new skinController(); $footer = new skinController(); $mysql = new mysqlConnection(); $paging = new pagingClass(); $method = new methodController(); $method->method_param("GET", "day,page,keyword"); /* 시간&키워드 초기화 */ $day_var = $day; if (trim($keyword) != "") { $searchKeyword = "AND B.me_id LIKE '%{$keyword}%'"; } else { $searchKeyword = ""; } /* 페이징 설정 */ $paging_query = "\n\t\tSELECT A.me_idno AS g_me_idno,A.me_id AS g_me_id,A.ip,A.regdate,B.me_idno,B.me_id,B.me_nick,B.me_drop_regdate\n\t\tFROM toony_admin_counter A\n\t\tLEFT OUTER JOIN toony_member_list B\n\t\tON A.me_idno=B.me_idno\n\t\tWHERE DATE_FORMAT(A.regdate,'%Y.%m.%d')='{$day_var}' {$searchKeyword}\n\t\tORDER BY A.regdate DESC\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);
<?php include_once "include/pageJustice.inc.php"; $tpl = new skinController(); $header = new skinController(); $loop = new skinController(); $footer = new skinController(); $method = new methodController(); $lib = new libraryClass(); $mysql = new mysqlConnection(); $paging = new pagingClass(); $method->method_param("GET", "page"); /* 검사 */ $lib->func_page_level(__URL_PATH__ . "{$viewDir}?article=login&redirect=" . urlencode("?article=") . $article, 9); /* 페이징 설정 */ $paging_query = "\n\t\tSELECT *\n\t\tFROM toony_member_point\n\t\tWHERE me_idno='{$member['me_idno']}'\n\t\tORDER BY regdate DESC\n\t"; $mysql->select($paging_query); $paging_query_no = $mysql->numRows(); $paging->page_param($page); $total_num = $paging->setTotal($paging_query_no); $paging->setListPerPage(15); $sql = $paging->getPaggingQuery($paging_query); $mysql->select($sql); $array_total = $mysql->numRows(); /* 템플릿 로드 */