<? 
require "header.php"; 

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

if($_POST[niche_name]) {
	$niche_name = mysql_real_escape_string($_POST[niche_name]);
	$_POST[description] = mysql_real_escape_string($_POST[description]);
	$_POST[metakw] = mysql_real_escape_string($_POST[metakw]);
	$_POST[metadesc] = mysql_real_escape_string($_POST[metadesc]);
	$result = mysql_query("SELECT * FROM niches WHERE name LIKE '$niche_name'");
	if(mysql_num_rows($result) < 1) {
		mysql_query("INSERT INTO niches (name, description, metakw, metadesc, csv_match) VALUES ('$niche_name', '$_POST[description]', '$_POST[metakw]', 
'$_POST[metadesc]','$_POST[csv_match]')") or 
die(mysql_error());
		$insertid = mysql_insert_id();
		if($_FILES[postroll][tmp_name]) {
			$name = 'cat'.$insertid.'.jpg';
			move_uploaded_file($_FILES[postroll][tmp_name], $misc_path.'/'.$name); 
		}
	}
	else { 
		$error = "<p style='font-weight: bold;' align='center'>Error: That niche already exists!</p>";
	}
}

if(!isset($_GET['page']) || $_GET[page] == '') { 
	$page = 1; 
} else { 
	$page = $_GET['page']; 
}
if(!$_GET[setmax]) { $max_results = 100; } else { $max_results = $_GET[setmax]; }
$from = (($page * $max_results) - $max_results); 
?>

     <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="niches.php">Channels</a></span>  
            </div>
        </div>
        
        
        
        <div id="right_bg">
        
      		<h2>Edit<strong>Channels</strong></h2>
            
            <div id="index_left" style='width: 100%;'>            
           
        
<? if($error) { ?><p><? echo $error; ?></p><? } ?>
<form id="form1" name="form1" method="post" action="" enctype='multipart/form-data'>
  <table border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'> 
  <thead>
  <tr>
  <th colspan=2 align='left'>Add Channel</th>
  </tr>
  </thead>
    <tr>
      <td width="99" height="25" class="style4">Name</td>
      <td width="446" height="25" align="left" class="style4"><input name="niche_name" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Meta KW</td>
      <td height="25" align="left" class="style4"><input name="metakw" type="text" class="style4" id="name3" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Meta Desc</td>
      <td height="25" align="left" class="style4"><input name="metadesc" type="text" class="style4" id="name4" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Description</td>
      <td height="25" align="left" class="style4"><textarea name="description" cols="35" rows="4" class="style4" id="name2"></textarea></td>
    </tr>
<tr>
      <td height="25" class="style4">Import Match</td>
      <td height="25" align="left" class="style4"><input name="csv_match" type="text" class="style4" id="name3" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Image</td>
      <td height="25" align="left" class="style4"><input type="file" name="postroll" id="postroll" />
        (JPEG)</td>
    </tr>
    <tr>
      <td height="25" colspan="2" align="center" class="style4"><input type="submit" name="Submit2" value="Save" /></td>
    </tr>
  </table>
<br />
  <br />
  <table border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
  	<thead>
    <tr>
      <th width="131" align='left'>Thumbnail</th>
      <th width="446" align='left'>Name</th>
      <th width="47" align="center">Edit</th>
      <th width="52" align="center">Delete</th>
    </tr>
    </thead>
    
<?
$bgcolor = '#ffffff';
$result_count = mysql_query("SELECT record_num FROM niches");
$result = mysql_query("SELECT * FROM niches ORDER BY name ASC LIMIT $from,$max_results");
$total_results = mysql_num_rows($result_count);
$total_pages = ceil($total_results / $max_results);
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td valign="top" class="style4"><? if(file_exists($misc_path.'/cat'.$row[record_num].'.jpg')) { ?>
        	<img src="<? echo $misc_url; ?>/cat<? echo $row[record_num]; ?>.jpg" alt="<? echo $row[name]; ?>" height="90" width="120" border=0 />						 		<? } else { ?>
            <img src="<? echo $basehttp; ?>/core/images/catdefault.jpg" alt="<? echo $row[name]; ?>">
        <? } ?></td>
      <td valign="top" class="style4">
	  <? echo $row[name]; ?><br />
      Content Amount: <? echo mysql_num_rows(mysql_query("SELECT content.record_num FROM content WHERE content.record_num IN (SELECT content FROM content_niches WHERE niche = '$row[record_num]')")); ?><br />
      </td>
      <td align="center" valign="top"><a href="edit_niche.php?id=<? echo $row[record_num]; ?>">Edit</a></td>
      <td align="center" valign="top"><input name="niche[]" type="checkbox" class="style4" value="<? echo $row[record_num]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#ffffff') { $bgcolor = "#EBEBEB"; } else { $bgcolor = '#ffffff'; }
}
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td colspan="5" class="style4"><center><br />
           <input name="Submit" type="submit" value="Delete Selected" />
      </center></td>
    </tr>
</table>
</form>
<div id='adminPagination'><center><? echo showAdminPagination($total_pages); ?></center></div>           
           
            </div>
            
          
        
        </div>
        
        <div id="right_bottom"></div>
       
        <!-- RIGHT -->
        
        
        
        <!-- STATYSTYKI -->
      
        
      
        </div>
       <!-- STATYSTYKI -->       
        
    
    
    </div>
  



</div>


      
        





<? require "footer.php"; ?>