GNU/skin/board/daemon_trading_upbit/write_update.skin.php



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


<div class="header">GNU/skin/board/daemon_trading_upbit/write_update.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit; // 개별 페이지 접근 불가

// 변수 검증 및 이스케이프 처리
$wr_id = isset($wr_id) ? (int)$wr_id : 0;
if ($wr_id &lt;= 0) exit(&#039;잘못된 접근입니다.&#039;);

// 기본 필드 처리 ($_POST에서 가져오기)
$coin_criteria = isset($_POST[&#039;coin_criteria&#039;]) ? sql_real_escape_string(trim($_POST[&#039;coin_criteria&#039;])) : &#039;&#039;;
$coin_kind = isset($_POST[&#039;coin_kind&#039;]) ? sql_real_escape_string(trim($_POST[&#039;coin_kind&#039;])) : &#039;&#039;;
$price_criteria = isset($_POST[&#039;price_criteria&#039;]) ? sql_real_escape_string(trim($_POST[&#039;price_criteria&#039;])) : &#039;&#039;;
$coin_code = isset($_POST[&#039;coin_code&#039;]) ? sql_real_escape_string(trim($_POST[&#039;coin_code&#039;])) : &#039;&#039;;
$daemon_file = isset($_POST[&#039;daemon_file&#039;]) ? sql_real_escape_string(trim($_POST[&#039;daemon_file&#039;])) : &#039;&#039;;

// 토글/체크박스 필드 처리 (값이 있으면 1, 없으면 0)
$x2_ai = isset($_POST[&#039;x2_ai&#039;]) ? 1 : 0;
$x2_force = isset($_POST[&#039;x2_force&#039;]) ? 1 : 0;
$sell_stop = isset($_POST[&#039;sell_stop&#039;]) ? 1 : 0;

// UPDATE 필드 배열 생성
$update_fields = array(
    &quot;coin_criteria = &#039;{$coin_criteria}&#039;&quot;,
    &quot;coin_kind = &#039;{$coin_kind}&#039;&quot;,
    &quot;price_criteria = &#039;{$price_criteria}&#039;&quot;,
    &quot;coin_code = &#039;{$coin_code}&#039;&quot;,
    &quot;daemon_file = &#039;{$daemon_file}&#039;&quot;,
    &quot;x2_ai = &#039;{$x2_ai}&#039;&quot;,
    &quot;x2_force = &#039;{$x2_force}&#039;&quot;,
    &quot;sell_stop = &#039;{$sell_stop}&#039;&quot;
);

// 매수 필드 처리 (1~10)
for ($i = 1; $i &lt;= 10; $i++) {
    $buy_percent = isset($_POST[&#039;buy_percent_&#039; . $i]) ? sql_real_escape_string(trim($_POST[&#039;buy_percent_&#039; . $i])) : &#039;&#039;;
    $buy_amount = isset($_POST[&#039;buy_amount_&#039; . $i]) ? sql_real_escape_string(trim($_POST[&#039;buy_amount_&#039; . $i])) : &#039;&#039;;
    
    $update_fields[] = &quot;buy_percent_{$i} = &#039;{$buy_percent}&#039;&quot;;
    $update_fields[] = &quot;buy_amount_{$i} = &#039;{$buy_amount}&#039;&quot;;
}

// 매도 필드 처리 (1~10)
for ($i = 1; $i &lt;= 10; $i++) {
    $sell_percent = isset($_POST[&#039;sell_percent_&#039; . $i]) ? sql_real_escape_string(trim($_POST[&#039;sell_percent_&#039; . $i])) : &#039;&#039;;
    $sell_amount = isset($_POST[&#039;sell_amount_&#039; . $i]) ? sql_real_escape_string(trim($_POST[&#039;sell_amount_&#039; . $i])) : &#039;&#039;;
    
    $update_fields[] = &quot;sell_percent_{$i} = &#039;{$sell_percent}&#039;&quot;;
    $update_fields[] = &quot;sell_amount_{$i} = &#039;{$sell_amount}&#039;&quot;;
}

// 하나의 UPDATE 쿼리로 통합
$sql = &quot;UPDATE {$write_table} SET &quot; . implode(&#039;, &#039;, $update_fields) . &quot; WHERE wr_id = &#039;{$wr_id}&#039;&quot;;

sql_query($sql);
?&gt;</pre>