0) { $res[inter_point] = (int)($res[inter_point] + (($res[inter_point] * $date[days]) * 0.1)); } } */ return $res; } // 이벤트 입찰 공통 검사 function tender_common_check($wr_id) { global $g5, $board, $member, $tender_table, $write_table, $write, $bo_table; if (!$member[mb_id]) alert_only("로그인 해주세요."); if ($board[bo_5] > 0 && ((G5_SERVER_TIME - strtotime($member[mb_datetime])) < ($board[bo_5]*86400))) alert_only("회원가입 후 $board[bo_5] 일이 지나야 참여 가능합니다."); $event = get_info_event($wr_id); //echo G5_TIME_YMDHIS.$event[start_datetime]; if (G5_TIME_YMDHIS < $event[start_datetime]) alert_only("이벤트 시작 전입니다."); if (G5_TIME_YMDHIS > $event[end_datetime]) alert_only("이벤트가 종료되었습니다."); return $event; } // 이벤트 건별 입찰 진행 function tender_send($wr_id, $point) { global $g5, $board, $member, $tender_table, $write_table, $write, $bo_table; $event = tender_common_check($wr_id); $row2 = sql_fetch(" select count(mb_id) as cnt from $tender_table where td_datetime like 'G5_TIME_YMDHIS%' and mb_id = '$member[mb_id]' and wr_id = '$wr_id' "); $tender_count = $row2[cnt]; $row3 = sql_fetch(" select count(mb_id) as cnt from $tender_table where mb_id = '$member[mb_id]' and wr_id = '$wr_id' "); $tender_count3 = $row3[cnt]; $event[tender_higher]="0"; if ($event[tender_higher]=="0" && $tender_count3) alert_only("한번만 참여 가능합니다."); $total_point = (int)$event[inter_point]; if ($member[mb_point] - $total_point < 0) alert_only("보유중인 포인트(".number_format($member[mb_point]).") 가 참여 포인트(".number_format($total_point).") 보다 부족합니다."); tender_common_update($wr_id, $point, $event); } // 입찰 DB 처리 function tender_common_update($wr_id, $point, $event) { global $g5, $board, $member, $tender_table, $write_table, $write, $bo_table; $sql = "insert into {$tender_table} set "; $sql.= " wr_id = '$wr_id' "; $sql.= ",mb_id = '$member[mb_id]' "; $sql.= ",mb_name = '$member[mb_name]' "; $sql.= ",mb_nick = '$member[mb_nick]' "; $sql.= ",mb_email = '$member[mb_email]' "; $sql.= ",mb_homepage = '$member[mb_homepage]' "; $sql.= ",td_inter_point = '$event[inter_point]' "; $sql.= ",td_tender_point = '$point' "; $sql.= ",td_status = '1' "; $sql.= ",td_last = 'G5_TIME_YMDHIS' "; $sql.= ",td_datetime = 'G5_TIME_YMDHIS' "; sql_query($sql); // 입찰 횟수 $row = sql_fetch(" select count(*) as cnt from {$tender_table} where wr_id = '$wr_id' "); $tender_count = (int)$row[cnt]; sql_query(" update $write_table set wr_7 = {$tender_count} where wr_id = '$wr_id' "); if ($event[inter_point]) { insert_point($member[mb_id], $event[inter_point]*-1, "No. {$wr_id} 이벤트에 참여하셨습니다 ", $bo_table, $wr_id, "참여 : G5_TIME_YMDHIS ".get_microtime()); } } // 이벤트의 낙찰 여부 검사 및 업데이트 function event_successful($wr_id) { global $g5, $write_table, $tender_table, $event, $write, $bo_table; // 나중에 등록한 게시물의 종료시간이 더 짧으면 모두 종료되는 오류 수정 //if (!$event) $event = get_info_event($wr_id); // 이벤트상태 조회 - 이미 종료되었으면 return if ($event[status] > 1) return false; // 이벤트가 시작전이면 return if ($event[start_datetime] > G5_TIME_YMDHIS) return false; // 이벤트날짜를 비교하여 진행중일경우 return if ($event[start_datetime] < G5_TIME_YMDHIS && $event[end_datetime] > G5_TIME_YMDHIS) return false; // 최저로 입찰된 내역을 조회 $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 "); // 중복되었거나 입찰내역이 없을 경우 취소 if (!$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 { // 낙찰된 입찰정보 가져오기 // $comment ="이벤트 $wr_id 번 당첨되셨습니다"; //include_once("$board_skin_path/config/dang.php"); // sql_query(" update $write_table set wr_8 = '2', wr_9 = '$row[td_tender_point]', wr_10 = '{$wr_10}' 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; } } function alert_only($msg='', $url='') { global $g5; echo ""; echo ""; exit; } ?>