=$temp_mem["nick"]?> 님의 정보 🎖️
-
가입일
=$temp_mem["wdate"]?>
최종방문일 =$temp_mem["last_login"]?>
-
활동정보
레벨 =$temp_mem["user_level"]?>
포인트 =$temp_mem["total_point"]?>
전체순위 =$mem_point_rank?>
-
작성글
게시글 =$mem_cnt_board?>
댓글 =$mem_cnt_board_comment?>
-
if($tab_gubun == "A"): ?>
$sw = $_REQUEST['sw'];
$sword = $_REQUEST['sword'];
$scale = 20; // 1페이지당 자료수
$c_page = max(1, (int)($_REQUEST['c_page'] ?? 1));
$ord1 = $_REQUEST['ord1'];
if( $ord1 == "" ) $ord1 = "wdate";
$ord2 = $_REQUEST['ord2'];
if( $ord2 == "" ) $ord2 = "desc";
$sql = " from board ";
$whereq = " where idx_write='$t_mem_idx' and is_del='N' ";
$whereq .= " and is_notice = 'N' ";
if($sword != "")
{
if($sw != "")
$whereq .= " and ( $sw like '%$sword%' ) ";
else
$whereq .= " and ( ( title like '%$sword%') or ( cont like '%$sword%') ) ";
}
if($sword != "" && $sw != "")
$whereq .= " and $sw like '%$sword%' ";
if($s_date != "")
{
if($e_date != "")
$whereq .= " and ( left(wdate,8) between '$s_date' and '$e_date') ";
else
$whereq .= " and left(wdate,8) >= '$s_date' ";
}
else
{
if($e_date != "")
$whereq .= " and left(wdate,8) <= '$e_date' ";
}
$page_list_scale = 10; // 페이지 리스트 수
$list_total = mysql_one_data($DB_name,"Select count(*) $sql $whereq ");
If (!$c_page) $c_page = 1;
If (!$_no) $_no = 0;
$last_page = floor($list_total/$scale);
If ($last_page != $list_total/$scale) $last_page++;
$start_article = ($c_page-1)*$scale;
$ord = " ".$ord1." ".$ord2." ";
$query = "Select * $sql $whereq order by $ord Limit $start_article, $scale";
$result = mysqli_query($con, $query) or die("DB Error");
$_seq = $list_total - ($c_page - 1) * $scale;
$_no = ($c_page - 1) * $scale;
$page_para = "scale=$scale&sw=$sw&sword=$sword&tab_gubun=A&t_mem_idx=$t_mem_idx&ord1=$ord1&ord2=$ord2&ord3=$ord3";
$page_para_mini = "scale=$scale&sw=$sw&sword=$sword&tab_gubun=A&t_mem_idx=$t_mem_idx";
?>
-
카테고리 구분 제목 if($ord1 == "wdate"): ?> if($ord2 == "desc"): ?> 등록일▼ else: ?> 등록일▲ endif; ?> else: ?> 등록일- endif; ?> if($ord1 == "cnt_visit"): ?> if($ord2 == "desc"): ?> 조회▼ else: ?> 조회▲ endif; ?> else: ?> 조회- endif; ?> if($ord1 == "cnt_recom"): ?> if($ord2 == "desc"): ?> 추천▼ else: ?> 추천▲ endif; ?> else: ?> 추천- endif; ?> =$board_cate1_name?> =$board_cate3_name?> =$title?>=$cnt_comment_disp?> =changeDate($temp["wdate"],"M")?> =$temp["cnt_visit"]?> =$temp["cnt_recom"]?> 해당 카테고리에 글이 등록되지 않았습니다. -
if($list_total > 0)
pagelist_user ($PHP_SELF,$last_page,$c_page,$page_list_scale,$page_para);
?>
elseif($tab_gubun == "B"): ?>
$sw = $_REQUEST['sw'];
$sword = $_REQUEST['sword'];
$scale = 20; // 1페이지당 자료수
$c_page = max(1, (int)($_REQUEST['c_page'] ?? 1));
$sql = " from board_comment ";
$whereq = " where idx_write='$t_mem_idx' ";
if($sword != "")
{
if($sw != "")
$whereq .= " and ( $sw like '%$sword%' ) ";
else
$whereq .= " and ( ( title like '%$sword%') or ( cont like '%$sword%') ) ";
}
if($sword != "" && $sw != "")
$whereq .= " and $sw like '%$sword%' ";
if($s_date != "")
{
if($e_date != "")
$whereq .= " and ( left(wdate,8) between '$s_date' and '$e_date') ";
else
$whereq .= " and left(wdate,8) >= '$s_date' ";
}
else
{
if($e_date != "")
$whereq .= " and left(wdate,8) <= '$e_date' ";
}
$page_list_scale = 10; // 페이지 리스트 수
$list_total = mysql_one_data($DB_name,"Select count(*) $sql $whereq ");
If (!$c_page) $c_page = 1;
If (!$_no) $_no = 0;
$last_page = floor($list_total/$scale);
If ($last_page != $list_total/$scale) $last_page++;
$start_article = ($c_page-1)*$scale;
$ord = " main_idx desc, main_depth asc ";
$query = "Select * $sql $whereq order by $ord Limit $start_article, $scale";
$result = mysqli_query($con, $query) or die("DB Error");
$_seq = $list_total - ($c_page - 1) * $scale;
$_no = ($c_page - 1) * $scale;
$page_para = "scale=$scale&sw=$sw&sword=$sword&tab_gubun=B&t_mem_idx=$t_mem_idx";
?>
-
카테고리 구분 제목 닉네임 등록일 ▼ 추천 ▼ =$board_cate1_name?> =$board_cate3_name?> =$temp_b["title"]?>=$cnt_comment_disp?> =$user_level?>=$temp_b["name_write"]?> =changeDate($temp_b["wdate"],"M")?> =$temp_b["cnt_recom"]?> =iconv_substr($temp["comment"], 0, 60, "utf-8")?>.. =$user_level_com?>=$temp["name_write"]?> =changeDate($temp["wdate"],"M")?> =$temp["cnt_recom"]?> 해당 카테고리에 글이 등록되지 않았습니다. if($list_total > 0) pagelist_user ($PHP_SELF,$last_page,$c_page,$page_list_scale,$page_para); ?>
elseif($tab_gubun == "C"): ?>
$sw = $_REQUEST['sw'];
$sword = $_REQUEST['sword'];
$scale = 20; // 1페이지당 자료수
$c_page = max(1, (int)($_REQUEST['c_page'] ?? 1));
$sql = " from board_scrap ";
$whereq = " where idx_write='$t_mem_idx' ";
if($sword != "")
{
if($sw != "")
$whereq .= " and ( $sw like '%$sword%' ) ";
else
$whereq .= " and ( ( title like '%$sword%') or ( cont like '%$sword%') ) ";
}
if($sword != "" && $sw != "")
$whereq .= " and $sw like '%$sword%' ";
if($s_date != "")
{
if($e_date != "")
$whereq .= " and ( left(wdate,8) between '$s_date' and '$e_date') ";
else
$whereq .= " and left(wdate,8) >= '$s_date' ";
}
else
{
if($e_date != "")
$whereq .= " and left(wdate,8) <= '$e_date' ";
}
$page_list_scale = 10; // 페이지 리스트 수
$list_total = mysql_one_data($DB_name,"Select count(*) $sql $whereq ");
If (!$c_page) $c_page = 1;
If (!$_no) $_no = 0;
$last_page = floor($list_total/$scale);
If ($last_page != $list_total/$scale) $last_page++;
$start_article = ($c_page-1)*$scale;
$ord = " idx desc ";
$query = "Select * $sql $whereq order by $ord Limit $start_article, $scale";
$result = mysqli_query($con, $query) or die("DB Error");
$_seq = $list_total - ($c_page - 1) * $scale;
$_no = ($c_page - 1) * $scale;
$page_para = "scale=$scale&sw=$sw&sword=$sword&tab_gubun=C&t_mem_idx=$t_mem_idx";
?>
-
if($list_total > 0) pagelist_user ($PHP_SELF,$last_page,$c_page,$page_list_scale,$page_para); ?>
endif; ?>