<?
include "head.php";
if(!$member[mb_id]) goto_url("$g4[path]/m/login.php");





$sql_common = " from g4_write_askin ";

$sql_search = " where wr_is_comment='0' and mb_id='$member[mb_id]' and wr_10='채택' ";
if ($stx) {
    $sql_search .= " and ( ";
            $sql_search .= " ($sfl = '$stx') ";
    $sql_search .= " ) ";
}

if (!$sst) {
    $sst = "wr_id";
    $sod = "desc";
}

$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
        $sql_common
        $sql_search
        $sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함


$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
$result = sql_query($sql);





?>

<table cellpadding=10 cellspacing=1 bgcolor=ECECEC cellspacing=0 width="100%">
<TR bgcolor="F8F8F8">
<TD width="40">상태</TD>
<TD>질문과 답변</TD>
</TR>
<?
while($write = mysql_fetch_array($result)){
?>
<TR bgcolor="FFFFFF">
<TD><?=$write[wr_10]?></TD>
<TD style="word-break:break-all;word-wrap:break-word;" >
질문 : <?=$write[wr_content]?>(<?=$write[mb_id]?>) <br>
<?
if($write[wr_19]){
echo "<br>답변 : $write[wr_19]($write[wr_18] : 답변 만족 평균&nbsp;";
$data = sql_fetch("select avg(wr_20)*10 as av from g4_write_askin where `wr_datetime` > date_add(now(),interval -15 day) and wr_18='$write[wr_18]'");
echo (int)$data[av]."점)";


}
?>
<? iconnfor($data[av]); ?>





<br><br>질문일자 : <?=$write[wr_datetime]?>

<br><br>
<?
if($write[wr_10]=="채택"){

if($write[wr_20]){

for($i=0; $i<($write[wr_20]/2); $i++){
echo "<img src='$g4[path]/images/star1.gif'>";
}

for($i=0; $i<5-($write[wr_20]/2); $i++){
echo "<img src='$g4[path]/images/star0.gif'>";
}


} else{

for($i=1; $i<6; $i++){
?><a href='star.php?wr_id=<?=$write[wr_id]?>&wr_20=<?=$i*2?>'><img src='<?=$g4[path]?>/images/star0.gif' alt='<?=$i*2?>점'></a><?

}

}

}
?>
</TD>
</TR>
<?}?>
</TABLE>
<?
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<table width=100% cellpadding=3 cellspacing=1>";
echo "<tr>";
echo "<td align=center>$pagelist</td></tr></table>\n";


include "tail.php";
?>