GNU/skin/board/daily/write_update.skin.php



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


<div class="header">GNU/skin/board/daily/write_update.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit; // 개별 실행 방지

$x2_ver = isset($_POST[&#039;x2_ver&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_ver&#039;])) : &#039;&#039;;
$x2_ca2 = isset($_POST[&#039;x2_ca2&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_ca2&#039;])) : &#039;&#039;;
$x2_ca3 = isset($_POST[&#039;x2_ca3&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_ca3&#039;])) : &#039;&#039;;
$x2_ca4 = isset($_POST[&#039;x2_ca4&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_ca4&#039;])) : &#039;&#039;;
$x2_txt = isset($_POST[&#039;x2_txt&#039;]) ? sql_real_escape_string($_POST[&#039;x2_txt&#039;]) : &#039;&#039;;
$x2_top = (isset($_POST[&#039;x2_top&#039;]) &amp;&amp; $_POST[&#039;x2_top&#039;] == &#039;1&#039;) ? &#039;1&#039; : &#039;0&#039;;
$x2_project = isset($_POST[&#039;x2_project&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_project&#039;])) : &#039;&#039;;

$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_note = isset($_POST[&#039;x2_note&#039;]) ? sql_real_escape_string($_POST[&#039;x2_note&#039;]) : &#039;&#039;;
$x2_weather = isset($_POST[&#039;x2_weather&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_weather&#039;])) : &#039;&#039;;

$x2_way = &#039;&#039;;
if (isset($_POST[&#039;x2_way&#039;]) &amp;&amp; is_array($_POST[&#039;x2_way&#039;])) {
    $x2_way_tokens = array();
    foreach ($_POST[&#039;x2_way&#039;] as $way_token) {
        $way_token = trim($way_token);
        if ($way_token === &#039;&#039;) continue;
        $x2_way_tokens[] = str_replace(&#039;|&#039;, &#039;&#039;, $way_token);
    }
    if (!empty($x2_way_tokens)) {
        $x2_way = sql_real_escape_string(implode(&#039; | &#039;, $x2_way_tokens));
    }
}

$x2_point = &#039;&#039;;
if (isset($_POST[&#039;x2_point&#039;]) &amp;&amp; is_array($_POST[&#039;x2_point&#039;])) {
    $x2_point_tokens = array();
    foreach ($_POST[&#039;x2_point&#039;] as $point_token) {
        $point_token = trim($point_token);
        if ($point_token === &#039;&#039;) continue;
        $x2_point_tokens[] = str_replace(&#039;|&#039;, &#039;&#039;, $point_token);
    }
    if (!empty($x2_point_tokens)) {
        $x2_point = sql_real_escape_string(implode(&#039; | &#039;, $x2_point_tokens));
    }
}

$x2_healing = &#039;&#039;;
if (isset($_POST[&#039;x2_healing&#039;]) &amp;&amp; is_array($_POST[&#039;x2_healing&#039;])) {
    $x2_healing_tokens = array();
    foreach ($_POST[&#039;x2_healing&#039;] as $healing_token) {
        $healing_token = trim($healing_token);
        if ($healing_token === &#039;&#039;) continue;
        $x2_healing_tokens[] = str_replace(&#039;|&#039;, &#039;&#039;, $healing_token);
    }
    if (!empty($x2_healing_tokens)) {
        $x2_healing = sql_real_escape_string(implode(&#039; | &#039;, $x2_healing_tokens));
    }
}

$x2_routine = &#039;&#039;;
if (isset($_POST[&#039;x2_routine&#039;]) &amp;&amp; is_array($_POST[&#039;x2_routine&#039;])) {
    $x2_routine_tokens = array();
    foreach ($_POST[&#039;x2_routine&#039;] as $routine_token) {
        $routine_token = trim($routine_token);
        if ($routine_token === &#039;&#039;) continue;
        $x2_routine_tokens[] = str_replace(&#039;|&#039;, &#039;&#039;, $routine_token);
    }
    if (!empty($x2_routine_tokens)) {
        $x2_routine = sql_real_escape_string(implode(&#039; | &#039;, $x2_routine_tokens));
    }
}

$x2_health = &#039;&#039;;
if (isset($_POST[&#039;x2_health&#039;]) &amp;&amp; is_array($_POST[&#039;x2_health&#039;])) {
    $x2_health_tokens = array();
    foreach ($_POST[&#039;x2_health&#039;] as $health_token) {
        $health_token = trim($health_token);
        if ($health_token === &#039;&#039;) continue;
        $x2_health_tokens[] = str_replace(&#039;|&#039;, &#039;&#039;, $health_token);
    }
    if (!empty($x2_health_tokens)) {
        $x2_health = sql_real_escape_string(implode(&#039; | &#039;, $x2_health_tokens));
    }
}

$x2_week = &#039;&#039;;
if (isset($_POST[&#039;x2_week&#039;]) &amp;&amp; is_array($_POST[&#039;x2_week&#039;])) {
    $x2_week_tokens = array();
    for ($week_idx = 0; $week_idx &lt; 7; $week_idx++) {
        $week_token = isset($_POST[&#039;x2_week&#039;][$week_idx]) ? trim($_POST[&#039;x2_week&#039;][$week_idx]) : &#039;&#039;;
        $week_token = str_replace(&#039;^&#039;, &#039; &#039;, $week_token);
        $x2_week_tokens[] = $week_token;
    }
    $x2_week = sql_real_escape_string(implode(&#039; ^ &#039;, $x2_week_tokens));
}

$x2_daily = isset($_POST[&#039;x2_daily&#039;]) ? sql_real_escape_string($_POST[&#039;x2_daily&#039;]) : &#039;&#039;;
$x2_key = isset($_POST[&#039;x2_key&#039;]) ? sql_real_escape_string($_POST[&#039;x2_key&#039;]) : &#039;&#039;;
$x2_ess = isset($_POST[&#039;x2_ess&#039;]) ? sql_real_escape_string($_POST[&#039;x2_ess&#039;]) : (isset($_POST[&#039;x2_Ess&#039;]) ? sql_real_escape_string($_POST[&#039;x2_Ess&#039;]) : &#039;&#039;);

$x2_extra1 = isset($_POST[&#039;x2_extra1&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_extra1&#039;])) : &#039;&#039;;
$x2_extra2 = isset($_POST[&#039;x2_extra2&#039;]) ? sql_real_escape_string(trim($_POST[&#039;x2_extra2&#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. 폼 입력값 기준으로 커스텀 컬럼 업데이트
$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_txt = &#039;{$x2_txt}&#039;,
                x2_top = &#039;{$x2_top}&#039;,
                x2_project = &#039;{$x2_project}&#039;,
                x2_label = &#039;{$x2_label}&#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_weather = &#039;{$x2_weather}&#039;,
                x2_see = &#039;{$x2_see}&#039;,
                x2_way = &#039;{$x2_way}&#039;,
                x2_point = &#039;{$x2_point}&#039;,
                x2_healing = &#039;{$x2_healing}&#039;,
                x2_routine = &#039;{$x2_routine}&#039;,
                x2_health = &#039;{$x2_health}&#039;,
                x2_week = &#039;{$x2_week}&#039;,
                x2_daily = &#039;{$x2_daily}&#039;,
                x2_key = &#039;{$x2_key}&#039;,
                x2_ess = &#039;{$x2_ess}&#039;,
                x2_extra1 = &#039;{$x2_extra1}&#039;,
                x2_extra2 = &#039;{$x2_extra2}&#039;
                {$add_sql}
          WHERE wr_id = &#039;{$wr_id}&#039; &quot;;

$result = sql_query($sql, false);

if (!$result) {
    $sql_extra = &quot; UPDATE {$write_table}
                      SET x2_way = &#039;{$x2_way}&#039;,
                          x2_point = &#039;{$x2_point}&#039;,
                          x2_healing = &#039;{$x2_healing}&#039;,
                          x2_routine = &#039;{$x2_routine}&#039;,
                          x2_health = &#039;{$x2_health}&#039;,
                          x2_note = &#039;{$x2_note}&#039;,
                          x2_weather = &#039;{$x2_weather}&#039;,
                          x2_week = &#039;{$x2_week}&#039;,
                          x2_daily = &#039;{$x2_daily}&#039;,
                          x2_key = &#039;{$x2_key}&#039;,
                          x2_ess = &#039;{$x2_ess}&#039;,
                          x2_extra1 = &#039;{$x2_extra1}&#039;,
                          x2_extra2 = &#039;{$x2_extra2}&#039;
                    WHERE wr_id = &#039;{$wr_id}&#039; &quot;;

    sql_query($sql_extra, false);
}
?&gt;
</pre>