경매 포인트 차감 소스좀 바주세요

======================================소스===================================

function auction_successful($wr_id) {

    global $g5, $write_table, $tender_table, $auction, $write, $board, $member, $bo_table;

 

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

    //if (!$auction)

    $auction = get_info_auction($wr_id);

 

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

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

 

    // 경매가 시작전이면 return

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

 

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

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

 

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

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

//    $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 ");

      $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 ");

 

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

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

        sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");

 

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

        return $res;

    } else {

        // 낙찰된 입찰정보 가져오기

===================================== td_status 1 ===================

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

      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' ");

      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]' ");

 

===================================== td_status 2 ===================

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

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

      sql_query(" update $tender_table set td_status = '3' where td_status = '2' ");

===================================///////////////////////////////////////////

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

 return $res;

    }

}