<? 
require "header.php"; 

if($_POST['niche']) {
	foreach($_POST['niche'] as $i) {
		if(is_numeric($i)) {
			mysql_query("DELETE FROM paysites WHERE record_num = '$i'");
		}
	}
}

if($_POST[name]) {
	$_POST = mysql_real_escape_array($_POST); 
	if($_FILES[horizontal][tmp_name]) {
		$name = uniqid().$_FILES[horizontal][name]; 
		move_uploaded_file($_FILES[horizontal][tmp_name], 'media/ads/'.$name); 
	}
	if($_FILES[postroll][tmp_name]) {
		$name = uniqid().$_FILES[postroll][name]; 
		move_uploaded_file($_FILES[postroll][tmp_name], 'media/ads/'.$name); 
	}
	mysql_query("INSERT INTO paysites (name, url, user, postroll, ad0, ad1, ad2, ad3, ad4, ad5, ad6, ad7, ad8, ad9) VALUES ('$_POST[name]', '$_POST[url]', '$_POST[sponsor]', '$_POST[postroll]', '$_POST[ad0]', '$_POST[ad1]', '$_POST[ad2]', '$_POST[ad3]', '$_POST[ad4]', '$_POST[ad5]', '$_POST[ad6]', '$_POST[ad7]', '$_POST[ad8]', '$_POST[ad9]')") or die(mysql_error());
}
?>

     <div id="right_column">
        <!-- RIGHT -->
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            <span><a href="paysites.php">Manage Paysites</a></span>  
            </div>
        </div>
        
        
        
        <div id="right_bg">
        
      		<h2>Manage<strong>Paysites</strong></h2>
            <p>Below is a listing of all the paysites currently in the system. The listing of ad spots next to the paysite name display in green if an ad has been entered in that spot for that site, or red if there is no ad. The content column represents how many *published* videos are assigned to that paysite.</p>
            <div id="index_left" style='width: 100%;'>            
            
           <form id="form1" name="form1" method="post" action="">
  <table width="98%" border="0" align="center" cellpadding="3" cellspacing="0" class="pagetable">
  <thead>
    <tr>
      <th width="145" align='left'>Paysite Name</th>
	  <th width="491" align='left'>Ad Spots</th>
      <th width="48" align="center">Content</th>
	  <th width="48" align="center">Edit</th>
      <th width="42" align="center">Delete</th>
    </tr>
    </thead>
<?
$bgcolor = '#ffffff';
$result = mysql_query("SELECT * FROM paysites ORDER BY name ASC");
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td class="style4"><? echo $row[name]; ?></td>
	  <td class="style4">
      <table style='border: none;' cellspacing=1 cellpadding=1>
        <tr>
          <td width=42 align='center' <? if($row[ad0]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad0</td>
          <td width=42 align='center' <? if($row[ad1]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad1</td>
          <td width=42 align='center' <? if($row[ad2]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad2</td>
          <td width=42 align='center' <? if($row[ad3]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad3</td>
          <td width=42 align='center' <? if($row[ad4]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad4</td>
          <td width=42 align='center' <? if($row[ad5]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad5</td>
          <td width=42 align='center' <? if($row[ad6]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad6</td>
          <td width=42 align='center' <? if($row[ad7]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad7</td>
          <td width=42 align='center' <? if($row[ad8]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad8</td>
          <td width=42 align='center' <? if($row[ad9]) { echo "style='background-color: #d6fedb;'"; } else { echo "style='background-color: #ffd7d7;'"; } ?>>ad9</td>
        </tr>
      </table>
      </td>
      <td align="center"><? echo mysql_num_rows(mysql_query("SELECT record_num FROM content WHERE paysite = '$row[record_num]' AND enabled = 1 AND approved = 2")); ?></td>
	  <td align="center"><a href="edit_paysite.php?id=<? echo $row[record_num]; ?>">Edit</a></td>
      <td align="center"><input name="niche[]" type="checkbox" class="style4" value="<? echo $row[record_num]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#ffffff') { $bgcolor = "#EBEBEB"; } else { $bgcolor = '#ffffff'; }
}
?>
    <tr>
      <td colspan="6" class="style4"><center><br />
           <input name="Submit" type="submit" value="Delete Selected" />
      </center></td>
    </tr>
</table>
  <p>&nbsp;</p>
</form>
            </div>
            
          
        
        </div>
        
        <div id="right_bottom"></div>
       
        <!-- RIGHT -->
        
        
        
        <!-- STATYSTYKI -->
      
        
      
        </div>
       <!-- STATYSTYKI -->       
        
    
    
    </div>
  



</div>







<? require "footer.php"; ?>