포인트경매에서 10명이하로 경매하였을경우 유찰되게끔할려면.... 정보
포인트경매에서 10명이하로 경매하였을경우 유찰되게끔할려면....
본문
포인트경매에서 입찰수가 10명이하로 경매입찰하였을경우 경매완료일에 유찰되게끔할려면 어떻게 해야하는지요
포인트 경매의 auction.lib.php파일을 수정할것 같은데요
아래와 같이 하면 되는지요 고수님들의 한번 봐주세요~
=====================================================================
auction.lib.php 파일원본
=====================================================================
//auction.lib.php파일 231줄쯤
// 중복되었거나 입찰내역이 없을 경우 유찰
if ($row[cnt] > 1 || !$row)
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
else
{
// 낙찰된 입찰정보 가져오기
$row = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' ");
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' ");
$qry = sql_query(" select * from $tender_table where td_tender_point <> '$row[td_tender_point]' and wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
// insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 낙찰안됨, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
==================================================================================
수정본
==================================================================================
//auction.lib.php
// 명수
$sql = "select count( distinct mb_id ) as cnt from $tender_table where wr_id = '$wr_id' ";
$row = sql_fetch($sql);
$tender_mb_id_count = number_format($row[cnt]);
//
if ($row[cnt] > 1 || !$row)
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
// 10명이하로 입찰하였을 경우 유찰
else if ($tender_mb_id_count > 10 )
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
else
{
// 낙찰된 입찰정보 가져오기
$row = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' ");
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' ");
$qry = sql_query(" select * from $tender_table where td_tender_point <> '$row[td_tender_point]' and wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
// insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 낙찰안됨, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
================================================================
고수님들 한번 봐주세요
포인트 경매의 auction.lib.php파일을 수정할것 같은데요
아래와 같이 하면 되는지요 고수님들의 한번 봐주세요~
=====================================================================
auction.lib.php 파일원본
=====================================================================
//auction.lib.php파일 231줄쯤
// 중복되었거나 입찰내역이 없을 경우 유찰
if ($row[cnt] > 1 || !$row)
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
else
{
// 낙찰된 입찰정보 가져오기
$row = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' ");
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' ");
$qry = sql_query(" select * from $tender_table where td_tender_point <> '$row[td_tender_point]' and wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
// insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 낙찰안됨, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
==================================================================================
수정본
==================================================================================
//auction.lib.php
// 명수
$sql = "select count( distinct mb_id ) as cnt from $tender_table where wr_id = '$wr_id' ";
$row = sql_fetch($sql);
$tender_mb_id_count = number_format($row[cnt]);
//
if ($row[cnt] > 1 || !$row)
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
// 10명이하로 입찰하였을 경우 유찰
else if ($tender_mb_id_count > 10 )
{
sql_query(" update $write_table set wr_8 = '3' where wr_id = '$wr_id' ");
$qry = sql_query(" select * from $tender_table where wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 유찰, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
else
{
// 낙찰된 입찰정보 가져오기
$row = sql_fetch(" select * from $tender_table where td_tender_point = '$row[point]' and wr_id = '$wr_id' ");
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' ");
$qry = sql_query(" select * from $tender_table where td_tender_point <> '$row[td_tender_point]' and wr_id = '$wr_id' ");
while ($row = sql_fetch_array($qry))
{
// insert_point($row[mb_id], $row[td_tender_point], "$wr_id 경매 낙찰안됨, 입찰 포인트 환급", $bo_table, $wr_id, "입찰 $row[td_tender_point] 포인트 환급");
}
$res = sql_fetch(" select wr_7, wr_8, wr_9, wr_10 from $write_table where wr_id = '$wr_id' ");
return $res;
}
================================================================
고수님들 한번 봐주세요
댓글 전체
제가 해결했어요...