<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
<!--
wr_4 는 시간에서 (시)구요(분 말고)

  -->





$intime= substr($wr_4,0,2);
$intime1 = $intime + 1;
$intime2 = $intime + 2;
$intime3 = $intime + 3;


$IntId = $wr_id;
$inDate = $wr_3;


if($wr_1 == "SMS완료" || $wr_1 == "대신완료" ){
$query3 = "UPDATE g4_write_KTX SET wr_15 ='1', wr_11 ='$intime1', wr_12 ='$intime2', wr_13 ='$intime3' WHERE wr_id = '$IntId' ";

sql_query($query3, $connect);

for($Idcnt=1;$Idcnt<=21;$Idcnt++){
$query1 = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt'";
$result1 = sql_query($query1, $connect);
while($row1 = sql_fetch_array($result1)){
    $cnt1 = $row1[wr_9];
  }
$total=mysql_num_rows($result1);
$Idcnt1 = 4;

if($total<=$Idcnt1){
$query4 = "UPDATE g4_write_KTX SET wr_15 ='$Idcnt' WHERE wr_id = '$IntId' ";
sql_query($query4, $connect);

$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_11='$intime' or wr_12='$intime' or wr_13='$intime') ";

$result = sql_query($query, $connect);
while($row = sql_fetch_array($result)){
$cnt = $row[wr_9];
  }
$total1=mysql_num_rows($result);

    if($total1==0){
    break;
    }
}
}
} elseif($wr_1 != "SMS완료" || $wr_1 != "대신완료" ){
$query5 = "UPDATE g4_write_KTX SET wr_15 ='0', wr_11 ='0', wr_12 ='0', wr_13 ='0' WHERE wr_id = '$IntId' ";
sql_query($query5, $connect);
}
?>

한마디로 wr4 는 시각 예를들어 12시 인데요
wr_4(12시 에서 +3시간까지가 시간이 중복이 되면 안되는거에요...
$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_11='$intime' or wr_12='$intime' or wr_13='$intime') ";


이 부분이 잘못된거 같은데... 모르겠어요 ㅠㅠ 고수님들 도와주세요~