OLDBOY/skin/board/routine/write_update.skin.php



<title>OLDBOY/skin/board/routine/write_update.skin.php</title>


<div class="header">OLDBOY/skin/board/routine/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_ds = (isset($_POST[&#039;x2_ds&#039;]) &amp;&amp; $_POST[&#039;x2_ds&#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_style_values = isset($_POST[&#039;x2_style&#039;]) &amp;&amp; is_array($_POST[&#039;x2_style&#039;]) ? $_POST[&#039;x2_style&#039;] : array();
$x2_shadow_values = isset($_POST[&#039;x2_shadow&#039;]) &amp;&amp; is_array($_POST[&#039;x2_shadow&#039;]) ? $_POST[&#039;x2_shadow&#039;] : array();

$x2_style_values = array_filter(array_map(&#039;trim&#039;, $x2_style_values));
$x2_shadow_values = array_filter(array_map(&#039;trim&#039;, $x2_shadow_values));

$x2_style = sql_real_escape_string(implode(&#039;|&#039;, $x2_style_values));
$x2_shadow = sql_real_escape_string(implode(&#039;|&#039;, $x2_shadow_values));

// 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_label = &#039;{$x2_label}&#039;,
                x2_ds = &#039;{$x2_ds}&#039;,
                x2_de = &#039;{$x2_de}&#039;,
                x2_style = &#039;{$x2_style}&#039;,
                x2_shadow = &#039;{$x2_shadow}&#039;,
                x2_line = &#039;{$x2_line}&#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>