GNU/skin/board/work/write_update.skin.php



<title>GNU/skin/board/work/write_update.skin.php</title>


<div class="header">GNU/skin/board/work/write_update.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit; // 개별 실행 방지

$x2_label = (isset($_POST[&#039;x2_label&#039;]) &amp;&amp; $_POST[&#039;x2_label&#039;] == &#039;1&#039;) ? &#039;1&#039; : &#039;0&#039;;
$x2_memo_clean = (isset($_POST[&#039;x2_memo_clean&#039;]) &amp;&amp; $_POST[&#039;x2_memo_clean&#039;] == &#039;1&#039;) ? &#039;1&#039; : &#039;0&#039;;
$x2_see = (isset($_POST[&#039;x2_see&#039;]) &amp;&amp; $_POST[&#039;x2_see&#039;] == &#039;1&#039;) ? &#039;1&#039; : &#039;0&#039;;
$x2_line = isset($_POST[&#039;x2_line&#039;]) ? sql_real_escape_string($_POST[&#039;x2_line&#039;]) : &#039;&#039;;
$x2_memo = isset($_POST[&#039;x2_memo&#039;]) ? sql_real_escape_string($_POST[&#039;x2_memo&#039;]) : &#039;&#039;;
$x2_relay = isset($_POST[&#039;x2_relay&#039;]) ? sql_real_escape_string($_POST[&#039;x2_relay&#039;]) : &#039;&#039;;

// 2. 날짜/시간 커스텀 업데이트 로직 정제
$add_sql = &quot;&quot;;
if (!empty($_POST[&#039;wr_date_custom&#039;]) &amp;&amp; !empty($_POST[&#039;wr_time_custom&#039;])) {
    $custom_datetime = &quot;{$_POST[&#039;wr_date_custom&#039;]} {$_POST[&#039;wr_time_custom&#039;]}&quot;;
    $add_sql = &quot; , wr_datetime = &#039;{$custom_datetime}&#039; &quot;;
}

// 3. 단일 쿼리로 최적화 업데이트 (x2_ca3 포함 및 문법 수정)
$sql = &quot; UPDATE {$write_table}
            SET x2_ver  =       &#039;{$x2_ver}&#039;,
                x2_car2 =       &#039;{$x2_car2}&#039;,
                x2_tag  =       &#039;{$x2_tag}&#039;,
                x2_ca2  =       &#039;{$x2_ca2}&#039;,
                x2_ca3  =       &#039;{$x2_ca3}&#039;,
                x2_ca4  =       &#039;{$x2_ca4}&#039;,
                x2_txt =        &#039;{$x2_txt}&#039;,
                x2_top =        &#039;{$x2_top}&#039;,
                x2_project =    &#039;{$x2_project}&#039;,
                x2_project_bt = &#039;{$x2_project_bt}&#039;,
                x2_project_txt =&#039;{$x2_project_txt}&#039;,
                x2_label =      &#039;{$x2_label}&#039;,
                x2_relay =      &#039;{$x2_relay}&#039;,
                x2_line =       &#039;{$x2_line}&#039;,
                x2_note =       &#039;{$x2_note}&#039;,
                x2_memo =       &#039;{$x2_memo}&#039;,
                x2_memo_clean = &#039;{$x2_memo_clean}&#039;,
                x2_see =        &#039;{$x2_see}&#039;
                {$add_sql}
          WHERE wr_id = &#039;{$wr_id}&#039; &quot;;

sql_query($sql);
?&gt;</pre>