<? 
require "header.php"; 
if($_POST) {
	$_POST = mysql_real_escape_array($_POST); 
	$_POST[title] = strip_tags($_POST[title]); 
	$_POST[description] = strip_tags($_POST[description]); 
	$_POST[keywords] = strip_tags($_POST[keywords]); 
	mysql_query("INSERT INTO content (length, title, description, keywords, date_added, approved, embed, submitter, paysite) VALUES ('$_POST[length]', '$_POST[title]', '$_POST[description]', '$_POST[keywords]', NOW(), 2, '$_POST[embed]', '$_POST[submitter]','$_POST[paysite]')") or die(mysql_error());
	$insert = mysql_insert_id(); 
	if($_FILES[postroll][tmp_name]) {
		$name = $insert.'.jpg';
		@mkdir($thumb_path.'/embedded'); 
		move_uploaded_file($_FILES[postroll][tmp_name], $thumb_path.'/embedded/'.$name); 
	}	$success = true;
	$error = '<h1>Success!</h1>';
	mysql_query("INSERT INTO content_views (content,views) VALUES ($insert,0)") or die(mysql_error());
	if($_POST[niche]) {
		foreach($_POST[niche] as $i) {	
			if(is_numeric($i)) {
				mysql_query("INSERT INTO content_niches (content,niche) VALUES ('$insert','$i')");
			}
		}
	}	
	if($_POST[pornstar]) {
				foreach($_POST[pornstar] as $i) {
					if(is_numeric($i)) {
						mysql_query("INSERT INTO content_pornstars (content,pornstar) VALUES ('$insert','$i')");
					}
				}
			}		
}
?>
 <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="add_embedded.php">Add Embedded Video</a></span>  
            </div>
        </div>
        <div id="right_bg">  
      		<h2>Add<strong>Embedded</strong></h2>
            <div id="index_left" style='width: 100%;'>            
<? if($error) { ?><p><? echo $error; ?></p><? } ?>
<form action="" method="POST" enctype="multipart/form-data" name="form2" id="form2">
  <table width="750" border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable' >
    <thead>
    <tr>
      <th colspan="2" align='left'>Video Details</th>
    </tr>
    </thead>
    <tr>
      <td width="102" height="25" class="style4">Title</td>
      <td width="592" height="25" align="left" class="style4"><input name="title" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td width="102" height="25" class="style4">Description</td>
      <td width="592" height="25" align="left" class="style4"><textarea name="description" id="textarea" cols="50" rows="8"></textarea></td>
    </tr>
    <tr>
      <td height="25" class="style4">Length (seconds)</td>
      <td height="25" align="left" class="style4"><input name="length" type="text" class="style4" id="name4" size="5" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Keywords</td>
      <td height="25" align="left" class="style4"><input name="keywords" type="text" class="style4" id="name2" size="35" maxlength="255" /></td>
    </tr>
     <tr>

      <td valign="top" class="style4">Categories</td>

      <td colspan="3" align="left" class="style4">
                    <?
unset($thisniche); 
$sresult = mysql_query("SELECT * FROM content_niches WHERE content = '$_REQUEST[id]'");
while($srow = mysql_fetch_array($sresult)) {
	$thisniche[] = $srow[niche];
}
?>
<select name='niche[]' size="10" multiple="multiple">
<?
$presult =  mysql_query("SELECT * FROM niches ORDER BY name ASC");
while($srow = mysql_fetch_array($presult)) {
	if(in_array($srow[record_num],$thisniche)) { $checked = 'selected'; } else { $checked = ''; }
	echo "<option $checked value='$srow[record_num]'>$srow[name]</option>";
}
?>
</select>
<br />
(Hold CTRL to make multiple selections)
  </td>

    </tr>
    <tr>

      <td valign="top" class="style4">Pornstars</td>

      <td colspan="3" align="left" class="style4">
     
     

       

                    <?
unset($thisniche); 
$sresult = mysql_query("SELECT * FROM content_pornstars WHERE content = '$_REQUEST[id]'");
while($srow = mysql_fetch_array($sresult)) {
	$thisniche[] = $srow[pornstar];
}
?>
<select name='pornstar[]' size="10" multiple="multiple">
<?
$presult =  mysql_query("SELECT * FROM pornstars ORDER BY name ASC");
while($srow = mysql_fetch_array($presult)) {
	if(in_array($srow[record_num],$thisniche)) { $checked = 'selected'; } else { $checked = ''; }
	echo "<option $checked value='$srow[record_num]'>$srow[name]</option>";
}
?>
</select>
<br />
(Hold CTRL to make multiple selections)     </td>

    </tr>    
    <tr>
      <td height="25" class="style4">Paysite</td>
      <td height="25" align="left" class="style4"><select name='paysite'>
        <? $result = mysql_query("SELECT * FROM paysites ORDER BY name ASC");
							while($row = mysql_fetch_array($result)) {
								echo "<option value='$row[record_num]'>$row[name]</option>"; 
							}
							?>
      </select></td>
    </tr>
    <tr>
      <td height="25" class="style4">User</td>
      <td height="25" align="left" class="style4"><select name='submitter'>
        <? $result = mysql_query("SELECT * FROM users ORDER BY username ASC");
							while($row = mysql_fetch_array($result)) {
								echo "<option value='$row[record_num]'>$row[username]</option>"; 
							}
							?>
      </select></td>
    </tr>
    <tr>
      <td height="25" class="style4">Thumb (jpeg)</td>
      <td height="25" align="left" class="style4"><input type="file" name="postroll" id="fileField" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Embed Code</td>
      <td height="25" align="left" class="style4"><textarea name="embed" cols="50" rows="5" class="style4" id="name3"></textarea></td>
    </tr>
    <tr>
      <td height="25" colspan="2" align="center" class="style4"><p>
        <input type="submit" name="button" id="button" value="Submit" />
      </p>    </td>
      </tr>
  </table>
  <p align='center'>&nbsp;</p>
</form>
            </div>
        </div>
        <div id="right_bottom"></div>
        </div>
    </div>
</div>




<? require "footer.php"; ?>