<?php require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php

if(isset($_GET['del_id']) && ( $_GET['del_id']>0 )){
mysql_select_db($database_BE2, $BE2);
$delete_SQL = sprintf("update ap1 set ra4='C' WHERE raid='%s'",$_GET['del_id']);
$Rt2 = mysql_query($delete_SQL, $BE2) or die(mysql_error());
}
 

mysql_select_db($database_BE2, $BE2);
$query_Rt2 = "SELECT * FROM ap1 where ra4<>'C' order by raid";
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2  = mysql_num_rows($Rt2); 
?>
 <div class="row">
 <div class="col-md-12">
				
 <div class="panel panel-default">
        <div class="panel-heading">
							<h3 class="panel-title">廣告頁面說明</h3>
							 
						</div>
                        
<div class="table-responsive" data-pattern="priority-columns" data-focus-btn-icon="fa-asterisk" data-sticky-table-header="true" data-add-display-all-btn="true" data-add-focus-btn="true">
							   
  <table cellspacing="0" class="table table-small-font table-bordered table-striped">

    <tr>
      <th width="3%" nowrap="nowrap" class="font2">ID</th>
      <th width="15%" nowrap="nowrap" class="font2">廣告區塊</th>
      <th nowrap="nowrap" class="font2">廣告圖檔說明</th>
      <th width="9%" nowrap="nowrap" class="font2">廣告價格</th>
      <th width="9%" nowrap="nowrap" class="font2">廣告天數</th>
      <th width="9%" nowrap="nowrap" class="font2">限制圖數</th>
      <th width="9%" nowrap="nowrap" class="font2">使用</th>
      <th nowrap="nowrap" class="font2">刪除</th>
    </tr>
    <?php 
	 if($totalRows_Rt2>0){ 
	  do { ?>
     <tr onMouseOver="this.style.backgroundColor='#CCC';" onMouseOut=this.style.backgroundColor="#fff">
      <td align="center" class="font3"><a href="main.php?act=ad_edit&amp;id=<?php echo $row_Rt2['raid']; ?>"><img src="/admin09/images/edit.png" alt="修改項目名稱" title="修改項目名稱" width="16" height="16" border="0" /></a></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ra1']." - ".$row_Rt2['raid']; ?></td>
      <td class="font3"><?php echo $row_Rt2['ra2']; ?></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ra3']; ?></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ra5']; ?></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ra6']; ?></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ra4']; ?></td>
      <td width="7%" align="center" class="font3"><a href="javascript:if(confirm('確實要刪除嗎?'))location='<? echo 'main.php?act=ad&del_id='.$row_Rt2['raid'] ;?>'"><img src="/admin09/images/del.png" alt="刪除項目" width="16" height="16" border="0"/></a></td>
    </tr>
    <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); 
	 }
	  ?>
 
    <tr>
      <td colspan="8"></td>
    
    </tr>
  </table>
</div>
</div>
</div>
</div>

<?php
mysql_free_result($Rt2);
?>
