<?
$banner_hit = 10000; // 노출 횟수 

// 포인트 배너광고 
$banner_table = "B13";  //배너 게시판 테이블
$sql = " select wr_id, wr_subject, mb_id, wr_1, wr_2, wr_hit from {$g4[write_prefix]}{$banner_table} 
          where wr_is_comment = '0' 
            and wr_1 = '' 
            and wr_hit < '".($banner_hit+1)."' 
          order by rand() limit 1 "; 
$row = sql_fetch($sql);

$sql3 = " select bo_1 from {$g4[board_table]}
			where bo_table = '".$banner_table."' ";
$row3 = sql_fetch($sql3);

list($imgw, $imgh) = explode("x", $row3[bo_1]);

if ($row[mb_id]) 
{
	$sql1 = " select mb_id ,mb_point from $g4[member_table] 
          where mb_id = '".$row[mb_id]."' "; 
	$row1 = sql_fetch($sql1);

$banner_point = 100; // 최저 포인트 
    if ($row1[mb_point] <= $banner_point) 
        sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_1 = '중지' where wr_id = '$row[wr_id]' "); 
}

if ($row[wr_id]) 
{ 
    if ($row[wr_hit] >= $banner_hit) 
        sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_1 = '종료' where wr_id = '$row[wr_id]' "); 

    $sql2 = " select bf_file from $g4[board_file_table] 
              where bo_table = '$banner_table' 
                and wr_id = '$row[wr_id]' 
                and bf_no = 0 "; 
    $row2= sql_fetch($sql2); 
    if ($row2[bf_file]) 
        $banner_img = "$g4[path]/data/file/$banner_table/$row2[bf_file]"; 
    else 
        $banner_img = "$g4[path]/img/banner01.gif"; 

    $subj = get_text($row[wr_subject]); 
    $href = "$g4[bbs_path]/link.php?bo_table={$banner_table}&wr_id={$row[wr_id]}&no=1&id=point&mb_id={$row1[mb_id]}"; 
	echo "<table cellpadding='0' cellspacing='0' border='0'>";
    echo "<a href='$href' target='_blank' title='$subj'><img src='$banner_img' border='0' width='$imgw' height='$imgh' style='border:solid 0 #555555;'></a>"; 
	echo "<tr><td height='2'></td></tr>";
	echo "<tr><td height='16' align='left'><font color=#4f4f4f>{$subject}</td></tr>";
	echo "<tr><td height='2'></td></tr>";
	echo "<tr><td height='14' align='left'><img src='{$latest_skin_path}/img/b_productlist_price.gif' align=\"absmiddle\"> <span $style><font color=#FF9900>{$list[$i][wr_8]}원</span>&nbsp;&nbsp;&nbsp;&nbsp;<span $style><font color=#4f4f4f>Hit : <B>{$list[$i][link_hit][1]}</font></B></span></td></tr>";
	echo "<tr><td height='3'></td></tr>";
	echo "<tr><td height='14' align='left'><img src='{$latest_skin_path}/img/i_home.gif' align=\"absmiddle\"> <a href=\"{$list[$i][wr_link2]}\" target=\"_blank\"<span $style><font color=#4f4f4f>{$list[$i][wr_7]}</span></a></td></tr>";
	echo "<tr><td height='5'></td></tr>";
	echo "</table>";
    // View(Hit) 
    sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_hit = wr_hit + 1 where wr_id = '$row[wr_id]' "); 
}
?>