<? 
require "header.php"; 

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

if($_POST[name]) {
	$_POST = mysql_real_escape_array($_POST);
	$_POST[hotlink] = (int)$_POST[hotlink];
	mysql_query("INSERT INTO xml_feeds (name, url, hotlink, paysite) VALUES ('$_POST[name]', '$_POST[url]', '$_POST[hotlink]', '$_POST[paysite]')") or die(mysql_error());
}
?>
<div id="right_column">
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            <span><a href="xml_feeds.php">XML Feeds</a></span>  
            </div>
        </div>
        <div id="right_bg">  
      		<h2>XML<strong>Feeds</strong></h2>
            <p>XML Imports use the <a href='example.xml'>standard tube xml format</a>. It is the same format most of the other popular tube scripts support. Use this page to add/edit/remove xml feeds. These feeds will update automatically and store videos in your approval queue.<br /><br />
</p>
            <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 width="750" border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
    <thead>
    <tr class='menutop'>
      <th colspan="2" align='left'>Add New Feed</th>
    </tr>
    </thead>
    <tr>
      <td width="99" height="25" class="style4">Name</td>
      <td width="446" height="25" align="left" class="style4"><input name="name" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td width="99" height="25" class="style4">URL</td>
      <td width="446" height="25" align="left" class="style4"><input name="url" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
     <tr>
      <td width="99" height="25" class="style4">Hotlink?</td>
      <td width="446" height="25" align="left" class="style4">
      <select name='hotlink'>
      	<option value='0'>Hosted</option>
        <option value='1'>Hotlinked</option>
      </select>
      </td>
    </tr>
	
	<tr>
      <td width="99" height="25" class="style4">Paysite</td>
      <td width="446" height="25" align="left" class="style4">
      <select name='paysite'>
	  	<option value='0'>None</option>
					<?
        $rresult = mysql_query("SELECT * FROM paysites ORDER BY name ASC");
        while($rrow = mysql_fetch_array($rresult)) {
            if($row[paysite] == $rrow[record_num]) { $selected = 'selected'; } else { $selected = ''; }
            echo "<option $selected value='$rrow[record_num]'>$rrow[name]</option>";
        }
        ?>
				</select>
      </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 width="750" border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
    <thead>
    <tr>
      <th width="153" align='left' >Name</th>
      <th width="474" align='left' >URL</th>
      <th width="47" align="center" class="style5">Edit</th>
      <th width="52" align="center" class="style5">Delete</th>
    </tr>
    </thead>
<?
$bgcolor = '#ffffff';
$result = mysql_query("SELECT * FROM xml_feeds ORDER BY name ASC");
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td valign="top" class="style4"><? echo $row[name]; ?></td>
      <td valign="top" class="style4">
	  <? echo $row[url]; ?><br />      </td>
      <td align="center" valign="top"><a href="edit_feed.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" class="style4" value="Delete Selected" />
      </center></td>
    </tr>
</table>
  <p>&nbsp;</p>
  <p align="center">&nbsp;</p>
</form>
            </div>
        </div>
        <div id="right_bottom"></div>
        </div>
    </div>
</div>



<? require "footer.php"; ?>