コード例 #1
0
ファイル: leaveMember.php プロジェクト: devwit/toonytool
<?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;
/*
페이징 설정
コード例 #2
0
ファイル: blockMember.php プロジェクト: devwit/toonytool
<?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();
コード例 #3
0
ファイル: pageList.php プロジェクト: devwit/toonytool
<?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();
/*
템플릿 함수
コード例 #4
0
ファイル: index.php プロジェクト: devwit/toonytool
<?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;
}
コード例 #5
0
ファイル: countResult_list.php プロジェクト: devwit/toonytool
<?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);
コード例 #6
0
ファイル: myPoint.php プロジェクト: devwit/toonytool
<?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();
/*
템플릿 로드
*/