prev next

새글

    최근 30일 이내 등록된 새글 이에요.
  • Re: 조회수가 가장 높은 글 추출 　
    rainbi.kr index에 적용<?phpif (!defined('_GNUBOARD_')) exit;// =========================// 1. 제외 게시판 설정// =========================$exclude_boards = ['02_04', '02_05', '02_06'];// SQL용 escape$escaped = array_map(function($v) {    return "'" . addslashes($v) . "'";}, $exclude_boards);$exclude_sql = "";if (!empty($escaped)) {    $exclude_sql = "AND bo_table NOT IN (" . implode(',', $escaped) . ")";}// =========================// 2. 기준 날짜 (1개월)// =========================$one_month_ago = date('Y-m-d H:i:s', strtotime('-1 month'));// =========================// 3. 게시판 목록 가져오기 (여기 핵심)// =========================$boards = [];$result = sql_query("    SELECT bo_table, bo_subject    FROM {$g5['board_table']}    WHERE bo_use_search = 1    {$exclude_sql}");while ($row = sql_fetch_array($result)) {    $boards[] = $row;}// 게시판 없으면 종료if (empty($boards)) return;// =========================// 4. UNION 쿼리 생성// =========================$union_sql = [];foreach ($boards as $b) {    $bo_table   = $b['bo_table'];    $bo_subject = addslashes($b['bo_subject']);    $union_sql[] = "        SELECT             wr_id,            wr_subject,            wr_hit,            wr_datetime,            '{$bo_table}' AS bo_table,            '{$bo_subject}' AS bo_subject        FROM {$g5['write_prefix']}{$bo_table}        WHERE wr_is_comment = 0          AND wr_datetime > '{$one_month_ago}'    ";}// =========================// 5. 최종 인기글 TOP10// =========================$sql = "    SELECT * FROM (        " . implode(" UNION ALL ", $union_sql) . "    ) AS total    ORDER BY wr_hit DESC    LIMIT 10";$result = sql_query($sql);$top_posts = [];while ($row = sql_fetch_array($result)) {    $top_posts[] = $row;}// 결과 없으면 종료if (empty($top_posts)) return;?><!-- =========================     6. 출력========================= --><div class="most-viewed-posts">    <div class="mv-header">        <h3>???? 최근 1개월 인기글 TOP 10</h3>    </div>    <ul class="mv-list">        <?php        $rank = 1;        foreach ($top_posts as $row) {            $board_url = get_pretty_url($row['bo_table']);            $write_url = get_pretty_url($row['bo_table'], $row['wr_id']);            $datetime  = substr($row['wr_datetime'], 2, 8);        ?>        <li class="mv-item">            <div class="rank"><?php echo $rank; ?></div>            <div class="content">                <a href="<?php echo $write_url; ?>" class="title">                    <?php echo get_text(cut_str($row['wr_subject'], 50)); ?>                </a>                <div class="meta">                    <span class="board">                        <a href="<?php echo $board_url; ?>">                            <?php echo $row['bo_subject']; ?>                        </a>                    </span>                    <span class="hit">???? <?php echo number_format($row['wr_hit']); ?></span>                    <span class="date"><?php echo $datetime; ?></span>                </div>            </div>        </li>        <?php $rank++; } ?>    </ul></div>-----------------css.most-viewed-posts {    background: #ffffff;    border-radius: 14px;    padding: 20px;    box-shadow: 0 6px 18px rgba(0,0,0,0.08);}.mv-header h3 {    font-size: 18px;    font-weight: 700;    margin-bottom: 15px;}.mv-list {    list-style: none;    padding: 0;    margin: 0;}.mv-item {    display: flex;    align-items: center;    padding: 12px;    border-radius: 10px;    margin-bottom: 8px;    transition: all 0.2s ease;}.mv-item:hover {    background: #f9fafb;    transform: translateX(4px);}/* TOP3 강조 */.mv-item:nth-child(1) { background: #fff1f0; }.mv-item:nth-child(2) { background: #fff7e6; }.mv-item:nth-child(3) { background: #f6ffed; }.rank {    width: 36px;    font-size: 16px;    font-weight: bold;    color: #ff4d4f;    text-align: center;}.content {    flex: 1;}.title {    font-size: 15px;    font-weight: 600;    color: #222;    text-decoration: none;}.title:hover {    color: #1677ff;}.meta {    font-size: 12px;    color: #888;    margin-top: 6px;}.meta span {    margin-right: 10px;}.hit {    color: #fa541c;    font-weight: 500;}
    복진선　2026-04-29　수첩
  • 잔잔한 플레이리스트 / K-Pop 　
    0:00 서랍 - 10CM3:59 이 밤을 빌려 말해요 (바른연애 길잡이 X 10CM) - 10CM7:06 나랑 같이 걸을래 (바른연애 길잡이 X 적재) - 적재10:51 Christmas Tree - V14:21 Love Me Again - V17:24 Sweet Night - V20:56 나의 마음에 (Seed) - 태양25:07 봄 내음보다 너를 - 김나영28:44 이별후회 - 김나영32:24 숲 - 최유리36:10 밤, 바다 - 최유리40:23 너는 내 세상이었어 - 볼빨간사춘기44:57 바람사람 - 볼빨간사춘기48:34 Lonely - 볼빨간사춘기52:09 나의 사춘기에게 - 볼빨간사춘기55:52 그때 그 아인 - 김필1:00:38 잘 가 - 권진아1:04:31 위로 - 권진아1:07:47 바람이 분다 - 이소라1:11:43 바람이 부네요 - 이소라1:16:14 신청곡 (Feat. SUGA of BTS) - 이소라1:20:55 봄여름가을겨울 (Still Life) - BIGBANG (빅뱅)1:24:02 LAST DANCE - BIGBANG (빅뱅)1:28:42 IF YOU - BIGBANG (빅뱅)1:33:05 마침표 - 아이유1:37:01 이런 엔딩 - 아이유1:41:10 팔레트 (Feat. G-DRAGON) - 아이유1:44:48 무제(無題) (Untitled, 2014) - G-DRAGON1:48:31 Missing You (Feat. 김윤아 Of 자우림) - G-DRAGON1:51:57 결국 (Feat. 로제 of BLACKPINK) - G-DRAGON1:56:00 Gone - 로제 (ROSÉ)1:59:25 STAY - BLACKPINK2:03:15 달리 표현할 수 없어요 - 로이킴2:07:09 살아가는 거야 - 로이킴2:10:56 봄이 와도 - 로이킴2:14:52 북두칠성 - 로이킴2:18:39 너를 사랑하고 있어 - 백현 (BAEKHYUN)2:21:52 그렇게 살아가는 것 - 허회경2:25:05 비와 당신 - 이무진2:29:25 오늘에게 (Good Night) - 도경수 (D.O.)2:32:25 어른 - Sondia2:36:45 마음을 드려요 - 아이유2:41:26 Love poem - 아이유2:45:44 무릎 - 아이유2:50:57 꽃이 되어줄게 - 이창섭2:54:14 0+0 - 한로로2:57:26 나무 - 카더가든
    복진선　2026-03-22　음악실
  • 처제내와 점심 　[댓글]
    어머님 병환으로 취소
    rainbi2026　2026-03-20　일정
  • 어머님 뇌경색 진단 　
    한국병원 응급실
    rainbi2026　2026-03-20　일정
  • 어머님 전원 　
    한국병원(2,530,000) -> 웰니스재활병원 / 4층 405호
    복진선　2026-03-17　일정