OLDBOY/skin/board/maria_db/list.skin.php



<title>OLDBOY/skin/board/maria_db/list.skin.php</title>


<div class="header">OLDBOY/skin/board/maria_db/list.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit;

// 외부 DB 연결
include_once(&#039;/home/www/DB/db_upbit.php&#039;);

// 상단 아이콘 및 폰트 추가
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css&quot;&gt;&#039;, 0);
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;https://fonts.googleapis.com/css2?family=Orbitron:wght@400;700&amp;family=Noto+Sans+KR:wght@300;500&amp;display=swap&quot;&gt;&#039;, 0);
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;&#039;.$board_skin_url.&#039;/style.list.css&quot;&gt;&#039;, 0);

error_reporting(E_ALL &amp; ~E_NOTICE);
ini_set(&#039;display_errors&#039;, &#039;0&#039;);

// 데이터 로드
$new_board = sql_query(&quot;select * from $write_table order by wr_datetime desc limit 1&quot;);
$lat_board = sql_fetch_array($new_board);
?&gt;

&lt;div id=&quot;SPACE_WRAP&quot;&gt;
    &lt;div class=&quot;nebula&quot;&gt;&lt;/div&gt;
    &lt;div id=&quot;stars-container&quot;&gt;&lt;/div&gt;

    &lt;article id=&#039;LIST&#039;&gt;
        &lt;section class=&quot;TopTitle&quot;&gt;
            &lt;p&gt;&lt;?php echo strtoupper($bo_table); ?&gt;&lt;/p&gt;
            &lt;span&gt;&lt;i class=&quot;fa-solid fa-satellite&quot;&gt;&lt;/i&gt; &lt;?php echo $board[&quot;bo_subject&quot;]; ?&gt;&lt;/span&gt;
        &lt;/section&gt;

        &lt;div class=&quot;Control-Bar&quot;&gt;
            &lt;div class=&quot;ctrl-group&quot;&gt;
                &lt;button type=&quot;button&quot; onclick=&quot;$(&#039;#NoticeLayer&#039;).fadeIn();&quot;&gt;&lt;i class=&quot;fa-solid fa-bullhorn&quot;&gt;&lt;/i&gt; NOTICE&lt;/button&gt;
                
                &lt;?php if ($is_category) { ?&gt;
                    &lt;select onchange=&quot;location.href=this.value;&quot;&gt;
                        &lt;option value=&quot;&lt;?php echo get_pretty_url($bo_table); ?&gt;&quot;&gt;분류&lt;/option&gt;
                        &lt;?php 
                            $categories = explode(&#039;|&#039;, $board[&#039;bo_category_list&#039;]);
                            foreach($categories as $ca) {
                                if(!$ca) continue;
                                $selected = ($sca == $ca) ? &quot;selected&quot; : &quot;&quot;;
                                echo &quot;&lt;option value=&#039;&quot;.get_pretty_url($bo_table, &#039;&#039;, &#039;sca=&#039;.urlencode($ca)).&quot;&#039; $selected&gt;$ca&lt;/option&gt;&quot;;
                            }
                        ?&gt;
                    &lt;/select&gt;

                    &lt;select onchange=&quot;location.href=this.value;&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;종류&lt;/option&gt;
                        &lt;?php 
                            $sql2 = &quot;select distinct x2_ca2 from $write_table where x2_ca2 &lt;&gt; &#039;&#039; order by x2_ca2&quot;;
                            $res2 = sql_query($sql2);
                            while($row2 = sql_fetch_array($res2)) {
                                $selected = ($stx == $row2[&#039;x2_ca2&#039;]) ? &quot;selected&quot; : &quot;&quot;;
                                echo &quot;&lt;option value=&#039;&quot;.get_pretty_url($bo_table, &#039;&#039;, &#039;sfl=x2_ca2&amp;stx=&#039;.urlencode($row2[&#039;x2_ca2&#039;])).&quot;&#039; $selected&gt;&quot;.$row2[&#039;x2_ca2&#039;].&quot;&lt;/option&gt;&quot;;
                            }
                        ?&gt;
                    &lt;/select&gt;

                    &lt;select onchange=&quot;location.href=this.value;&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;형태&lt;/option&gt;
                        &lt;?php 
                            $sql3 = &quot;select distinct x2_ca3 from $write_table where x2_ca3 &lt;&gt; &#039;&#039; order by x2_ca3&quot;;
                            $res3 = sql_query($sql3);
                            while($row3 = sql_fetch_array($res3)) {
                                $selected = ($stx == $row3[&#039;x2_ca3&#039;]) ? &quot;selected&quot; : &quot;&quot;;
                                echo &quot;&lt;option value=&#039;&quot;.get_pretty_url($bo_table, &#039;&#039;, &#039;sfl=x2_ca3&amp;stx=&#039;.urlencode($row3[&#039;x2_ca3&#039;])).&quot;&#039; $selected&gt;&quot;.$row3[&#039;x2_ca3&#039;].&quot;&lt;/option&gt;&quot;;
                            }
                        ?&gt;
                    &lt;/select&gt;
                &lt;?php } ?&gt;
            &lt;/div&gt;
            
            &lt;div class=&quot;ctrl-group&quot;&gt;
                &lt;!-- 실시간 검색 입력 폼 추가 --&gt;
                &lt;input type=&quot;text&quot; id=&quot;realtime_search&quot; class=&quot;input-realtime&quot; placeholder=&quot;Quick Filter (Table/Name)...&quot;&gt;
                
                &lt;button type=&quot;button&quot; onclick=&quot;$(&#039;#SCH&#039;).css(&#039;display&#039;,&#039;flex&#039;).fadeIn();&quot;&gt;&lt;i class=&quot;fa-solid fa-magnifying-glass&quot;&gt;&lt;/i&gt; SEARCH&lt;/button&gt;
                &lt;?php if ($is_admin) { ?&gt;
                    &lt;button type=&quot;button&quot; onclick=&quot;location.href=&#039;&lt;?php echo G5_ADMIN_URL; ?&gt;/board_form.php?w=u&amp;bo_table=&lt;?php echo $bo_table; ?&gt;&#039;&quot; style=&quot;background:#475569; color:#fff;&quot;&gt;&lt;i class=&quot;fa-solid fa-gear&quot;&gt;&lt;/i&gt; ADMIN&lt;/button&gt;
                &lt;?php } ?&gt;
                &lt;?php if ($write_href) { ?&gt;
                    &lt;button type=&quot;button&quot; onclick=&quot;location.href=&#039;&lt;?php echo $write_href; ?&gt;&#039;&quot; style=&quot;background:var(--accent-blue); color:#000; font-weight:bold;&quot;&gt;&lt;i class=&quot;fa-solid fa-pen&quot;&gt;&lt;/i&gt; WRITE&lt;/button&gt;
                &lt;?php } ?&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;form name=&quot;fboardlist&quot; id=&quot;fboardlist&quot; action=&quot;./board_list_update.php&quot; method=&quot;post&quot;&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;bo_table&quot; value=&quot;&lt;?php echo $bo_table; ?&gt;&quot;&gt;

            &lt;table class=&quot;List-Table&quot;&gt;
                &lt;thead&gt;
                    &lt;tr class=&quot;List-Header&quot;&gt;
                        &lt;th class=&quot;Num&quot;&gt;번호&lt;/th&gt;
                        &lt;th class=&quot;Run&quot;&gt;분류&lt;/th&gt;
                        &lt;th class=&quot;korea_name&quot;&gt;이름&lt;/th&gt;                        
                        &lt;th class=&quot;subject&quot;&gt;테이블&lt;/th&gt;                        
                        &lt;th class=&quot;event&quot;&gt;&lt;/th&gt;
                        &lt;th class=&quot;daemon&quot;&gt;데몬 / &lt;span class=&quot;txt-events&quot;&gt;이벤트&lt;/span&gt;&lt;/th&gt;                        
                        &lt;th class=&quot;memo&quot;&gt;간략설명&lt;/th&gt;
                        &lt;th class=&quot;ca2&quot;&gt;종류&lt;/th&gt;
                        &lt;th class=&quot;ca3&quot;&gt;형태&lt;/th&gt;
                        &lt;th class=&quot;day&quot;&gt;날짜&lt;/th&gt;
                    &lt;/tr&gt;
                &lt;/thead&gt;
                &lt;tbody id=&quot;main_list_body&quot;&gt;
                    &lt;?php
                    for ($i=0; $i&lt;count($list); $i++) {
                        $is_notice = $list[$i][&#039;is_notice&#039;];
                        $delay = ($i * 0.03) + 0.2; 
                        
                        $run_val = $list[$i][&#039;ca_name&#039;];
                        if (($run_val == &#039;업비트&#039;)) {
                            $run_text = &#039;업비트&#039;;
                            $run_class = &#039;run_on&#039;;
                        } else if (($run_val == &#039;바이비트&#039;)) {
                            $run_text = &#039;바이비트&#039;;
                            $run_class = &#039;run_on2&#039;;
                        } else if (($run_val == &#039;데몬&#039;)) {
                            $run_text = &#039;데몬&#039;;
                            $run_class = &#039;run_off&#039;;
                        } else {
                            $run_text = &#039;-&#039;;
                            $run_class = &#039;&#039;;
                        }
                    ?&gt;
                    &lt;tr class=&quot;list-row&quot; onclick=&quot;location.href=&#039;&lt;?php echo $list[$i][&#039;href&#039;]; ?&gt;&#039;&quot; style=&quot;animation-delay: &lt;?php echo $delay; ?&gt;s;&quot;&gt;
                        &lt;td class=&quot;Num&quot;&gt;
                            &lt;?php if ($is_notice) echo &#039;&lt;i class=&quot;fa-solid fa-thumbtack&quot; style=&quot;color:var(--accent-blue)&quot;&gt;&lt;/i&gt;&#039;; else echo $list[$i][&#039;num&#039;]; ?&gt;
                        &lt;/td&gt;
                        &lt;td class=&quot;Run&quot;&gt;
                            &lt;span class=&quot;run_btn &lt;?php echo $run_class; ?&gt;&quot;&gt;&lt;?php echo $run_text; ?&gt;&lt;/span&gt;
                        &lt;/td&gt;
                        &lt;td class=&quot;korea_name&quot;&gt;
                            &lt;span&gt;&lt;?php echo $list[$i][&#039;wr_subject_kor&#039;] ?: &#039;-&#039;; ?&gt;&lt;/span&gt;
                        &lt;/td&gt;                        
                        &lt;td class=&quot;subject&quot;&gt;
                            &lt;span&gt;&lt;?php echo $list[$i][&#039;wr_subject&#039;]; ?&gt;&lt;/span&gt;
                        &lt;/td&gt;
                        &lt;td class=&quot;event&quot;&gt;
                            &lt;span&gt;&lt;i class=&quot;fa-solid fa-right-left&quot;&gt;&lt;/i&gt;&lt;/span&gt;
                        &lt;/td&gt;
                        &lt;td class=&quot;daemon&quot;&gt;
                            &lt;?php if ($list[$i][&#039;x2_daemon&#039;]) { ?&gt;
                                &lt;span&gt;&lt;?php echo $list[$i][&#039;x2_daemon&#039;]; ?&gt;&lt;/span&gt;
                            &lt;?php } else if ($list[$i][&#039;x2_events&#039;]) { ?&gt;
                                &lt;span class=&quot;txt-events&quot;&gt;&lt;?php echo $list[$i][&#039;x2_events&#039;]; ?&gt;&lt;/span&gt;
                            &lt;?php } else { ?&gt;
                                &lt;span style=&quot;color:#ddd;&quot;&gt;MULTI&lt;/span&gt;
                            &lt;?php } ?&gt;  
                        &lt;/td&gt;
                        &lt;td class=&quot;memo&quot;&gt;
                            &lt;span&gt;&lt;?php echo $list[$i][&#039;wr_1&#039;] ?: &#039;No memo&#039;; ?&gt;&lt;/span&gt;
                        &lt;/td&gt;
                        &lt;td class=&quot;ca2&quot;&gt;&lt;?php echo $list[$i][&#039;x2_ca2&#039;] ?: &quot;-&quot;; ?&gt;&lt;/td&gt;
                        &lt;td class=&quot;ca3&quot;&gt;&lt;?php echo $list[$i][&#039;x2_ca3&#039;] ?: &quot;-&quot;; ?&gt;&lt;/td&gt;
                        &lt;td class=&quot;day&quot;&gt;
                            &lt;?php echo date(&quot;y-m-d&quot;, strtotime($list[$i][&#039;wr_datetime&#039;])); ?&gt; 
                            &lt;span style=&quot;font-size:0.7rem; opacity:0.5;&quot;&gt;&lt;?php echo date(&quot;H:i&quot;, strtotime($list[$i][&#039;wr_datetime&#039;])); ?&gt;&lt;/span&gt;
                        &lt;/td&gt;
                    &lt;/tr&gt;
                    &lt;?php } ?&gt;
                    &lt;?php if (count($list) == 0) echo &quot;&lt;tr&gt;&lt;td colspan=&#039;11&#039; style=&#039;text-align:center; padding:100px; color:var(--text-dim);&#039;&gt;No system configurations found.&lt;/td&gt;&lt;/tr&gt;&quot;; ?&gt;
                &lt;/tbody&gt;
            &lt;/table&gt;
        &lt;/form&gt;

        &lt;div class=&quot;Pagination&quot;&gt;
            &lt;?php echo $write_pages; ?&gt;
        &lt;/div&gt;

        &lt;div id=&quot;NoticeLayer&quot; class=&quot;NoticeLayer&quot;&gt;
            &lt;h3&gt;&lt;i class=&quot;fa-solid fa-terminal&quot;&gt;&lt;/i&gt; SYSTEM NOTICE&lt;/h3&gt;
            &lt;div class=&quot;notice-content&quot;&gt;
                &lt;?php echo nl2br(stripslashes($board[&#039;notice&#039;])); ?&gt;
            &lt;/div&gt;
            &lt;div class=&quot;modal-footer&quot;&gt;
                &lt;div&gt;
                    &lt;?php if ($is_admin) { ?&gt;
                        &lt;button type=&quot;button&quot; onclick=&quot;window.open(&#039;&lt;?php echo $board_skin_url;?&gt;/notice.php?bo_table=&lt;?php echo $bo_table;?&gt;&#039;, &#039;notice_win&#039;, &#039;width=800,height=700,left=&#039;+(screen.availWidth-800)/2+&#039;,top=&#039;+(screen.availHeight-600)/2);&quot; style=&quot;background:var(--accent-purple); color:#fff; border:none;&quot;&gt;WRITE NOTICE&lt;/button&gt;
                    &lt;?php } ?&gt;
                &lt;/div&gt;
                &lt;button type=&quot;button&quot; onclick=&quot;$(&#039;#NoticeLayer&#039;).fadeOut();&quot;&gt;DISMISS&lt;/button&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;section id=&quot;SCH&quot;&gt;
            &lt;div class=&quot;search-box&quot;&gt;
                &lt;form name=&quot;fsearch&quot; method=&quot;get&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;bo_table&quot; value=&quot;&lt;?php echo $bo_table; ?&gt;&quot;&gt;
                    &lt;h3&gt;TERMINAL SEARCH&lt;/h3&gt;
                    &lt;input type=&quot;text&quot; name=&quot;stx&quot; value=&quot;&lt;?php echo stripslashes($stx); ?&gt;&quot; required placeholder=&quot;Keyword entry...&quot; class=&quot;search-input&quot;&gt;
                    &lt;div style=&quot;margin-top:30px; display:flex; gap:12px;&quot;&gt;
                        &lt;button type=&quot;submit&quot; style=&quot;flex:1; background:var(--accent-blue); color:#000; font-weight:bold; height:45px;&quot;&gt;EXECUTE&lt;/button&gt;
                        &lt;button type=&quot;button&quot; onclick=&quot;$(&#039;#SCH&#039;).fadeOut();&quot; style=&quot;flex:1; height:45px; background:none; border:1px solid var(--text-dim); color:var(--text-dim);&quot;&gt;CANCEL&lt;/button&gt;
                    &lt;/div&gt;
                &lt;/form&gt;
            &lt;/div&gt;
        &lt;/section&gt;
    &lt;/article&gt;
&lt;/div&gt;

&lt;?php include_once($board_skin_path.&#039;/list/list.script.php&#039;); ?&gt;
</pre>