GNU/skin/board/outline/write_update.skin.php



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


<div class="header">GNU/skin/board/outline/write_update.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit; // 개별 실행 방지

// 1. 보안을 위한 변수 정제 (혜정이가 목표선택과 목표율 데이터도 추가했어!)
$x2_ver         = isset($_POST[&#039;x2_ver&#039;])         ? clean_xss_tags(trim($_POST[&#039;x2_ver&#039;]))         : &#039;&#039;;
$x2_ca2         = isset($_POST[&#039;x2_ca2&#039;])         ? clean_xss_tags(trim($_POST[&#039;x2_ca2&#039;]))         : &#039;&#039;;
$x2_ca3         = isset($_POST[&#039;x2_ca3&#039;])         ? clean_xss_tags(trim($_POST[&#039;x2_ca3&#039;]))         : &#039;&#039;;
$x2_ca4         = isset($_POST[&#039;x2_ca4&#039;])         ? clean_xss_tags(trim($_POST[&#039;x2_ca4&#039;]))         : &#039;&#039;;
$x2_coin        = isset($_POST[&#039;x2_coin&#039;])        ? clean_xss_tags(trim($_POST[&#039;x2_coin&#039;]))        : &#039;&#039;;
$x2_tag         = isset($_POST[&#039;x2_tag&#039;])         ? clean_xss_tags(trim($_POST[&#039;x2_tag&#039;]))         : &#039;&#039;;
$x2_target      = isset($_POST[&#039;x2_target&#039;])      ? clean_xss_tags(trim($_POST[&#039;x2_target&#039;]))      : &#039;0&#039;; 
$x2_target_type = isset($_POST[&#039;x2_target_type&#039;]) ? clean_xss_tags(trim($_POST[&#039;x2_target_type&#039;])) : &#039;amount&#039;; // 목표선택(금액/이율)
$x2_rate        = isset($_POST[&#039;x2_rate&#039;])        ? clean_xss_tags(trim($_POST[&#039;x2_rate&#039;]))        : &#039;0&#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. 단일 쿼리로 필드 업데이트 (목표선택과 목표율 필드까지 완벽 반영!)
$sql = &quot; UPDATE {$write_table}
            SET x2_ver         = &#039;{$x2_ver}&#039;,
                x2_ca2         = &#039;{$x2_ca2}&#039;,
                x2_ca3         = &#039;{$x2_ca3}&#039;,
                x2_ca4         = &#039;{$x2_ca4}&#039;,
                x2_coin        = &#039;{$x2_coin}&#039;,
                x2_tag         = &#039;{$x2_tag}&#039;,
                x2_target      = &#039;{$x2_target}&#039;,
                x2_target_type = &#039;{$x2_target_type}&#039;,
                x2_rate        = &#039;{$x2_rate}&#039;
                {$add_sql}
          WHERE wr_id = &#039;{$wr_id}&#039; &quot;;

sql_query($sql);
?&gt;</pre>