경매 포인트 차감 소스좀 바주세요 채택완료

</strong></p>

<p>======================================소스===================================</p>

<p>function auction_successful($wr_id) {</p>

<p>    global $g5, $write_table, $tender_table, $auction, $write, $board, $member, $bo_table;</p>

<p> </p>

<p>    // 나중에 등록한 게시물의 종료시간이 더 짧으면 모두 종료되는 오류 수정</p>

<p>    //if (!$auction)</p>

<p>    $auction = get_info_auction($wr_id);</p>

<p> </p>

<p>    // 경매상태 조회 - 이미 종료되었으면 return</p>

<p>    if ($auction[status] > 1) return false;</p>

<p> </p>

<p>    // 경매가 시작전이면 return</p>

<p>    if ($auction[start_datetime] > G5_TIME_YMDHIS) return false;</p>

<p> </p>

<p>    // 경매날짜를 비교하여 진행중일경우 return</p>

<p>    if ($auction[start_datetime] < G5_TIME_YMDHIS && $auction[end_datetime] > G5_TIME_YMDHIS) return false;</p>

<p> </p>

<p>    // 최저로 입찰된 내역을 조회</p>

<p>       $res0 = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");</p>

<p>//    $row = sql_fetch(" select td_tender_point as point, count(td_tender_point) as cnt from $tender_table where wr_id = '$wr_id' group by td_tender_point order by cnt, td_tender_point limit 1 ");</p>

<p>      $row = sql_fetch(" select td_tender_point as point, count(td_tender_point) as cnt from $tender_table where wr_id = '$wr_id' group by td_tender_point desc ");</p>

<p> </p>

<p>    // 중복되었거나 입찰내역이 없을 경우 유찰</p>

<p>    if ($row[cnt] > 1 || !$row)     {</p>

<p>        sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");</p>

<p> </p>

<p>        $res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");</p>

<p>        return $res;</p>

<p>    } else {</p>

<p>        // 낙찰된 입찰정보 가져오기</p>

<p>===================================== td_status 1 ===================</p>

<p>  $row = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' and td_status = '1' ");</p>

<p>      sql_query(" update $write_table set wr_8 = '2', wr_9 = '$row[td_tender_point]', wr_10 = '$row[mb_id]' where wr_id = '$wr_id' ");</p>

<p>      sql_query(" update $tender_table set td_status = '2' where wr_id = '$wr_id' and '$res0[wr_8]' = '2' and '$res0[wr_9]' = '$row[td_tender_point]' and '$res0[wr_10]' = '$row[mb_id]' ");</p>

<p> </p>

<p>===================================== td_status 2 ===================</p>

<p>  $row1 = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' and td_status = '2' ");</p>

<p>      insert_point($row1['mb_id']['mb_id'], -$row1['td_tender_point'], "{$wr_id} 즉시구매{$point}", $bo_table, $wr_id, "참여 : ".G5_TIME_YMDHIS." ".get_microtime());</p>

<p>      sql_query(" update $tender_table set td_status = '3' where td_status = '2' ");</p>

<p>===================================///////////////////////////////////////////</p>

<p>        $res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");</p>

<p> return $res;</p>

<p>    }</p>

<p>}<strong>