<?php
/*
 **************************************************************************************************
 *    Copyright (c) 2010-2012 Just Another Video script
 *
 * 	  This file is part of Just Another Video Script.
 *    Version 1.4.3
 *    info@justanothervideoscript.com
 **************************************************************************************************
 *    Come to website for support or buying additional plugins/modules.
 *    http://justanothervideoscript.com/
 **************************************************************************************************
 *    By using this software you agree that you have read and acknowledged our End-User License
 *    Agreement available at http://justanothervideoscript.com/license and can be bound by it.
 **********************************************************************************
 */
session_start();
include_once("adminfunctions.inc");
if (!Beveiliging()){
    echo "Not logged in";
} else {
	$db->query("SELECT * FROM `category` ORDER BY name") ;
	$cat = $db->fetchAll() ;
?>
<script type="text/javascript">
var PageName = "dbclean";
</script>

<div id="main-content">

	<h2>DB Manager</h2>
	

	<div class="settings">
	<fieldset>
		<form method="post" id="allvideosearch" action="">
		<table>

		<tr>
			<td>Title:</td>
			<td><input type="text" name="title" id="title" /></td>
		
			<td>Description:</td>
			<td><input type="text" name="description" id="description" /></td>

			<td>Poster:</td>
			<td><input type="text" name="poster" id="poster" /></td>		
		</tr>
		<tr>		
			<td>Category:</td>
			<td>
			<select id="category">
				<option value="">-----</option>
				
			<?php
			foreach($cat as $catvalue) {
				echo '<option value="'.$catvalue['id'].'">'.$catvalue['name'].'</option>' ;
			}		
			?>
	
			</select>			
			</td>
			<td>HD/mobile:</td>
			<td>
			<select id="hdmobile">
				<option SELECTED value="">All</option>
				<option value="mobile">Mobile</option>
				<option value="hd">HD</option>
			</select>
			</td>

			<td>Video/embed:</td>
			<td>
			<select id="videoembed">
				<option SELECTED value="">All</option>
				<option value="video">Video</option>
				<option value="embed">Embed</option>
			</select>
			</td>			
			</tr>

			<tr>			
			
			<td>Items on page:</td>
			<td>
			<select id="numpages">
			<option value="3">3</option>
			<option value="5">5</option>
			<option value="7">7</option>
			<option value="10">10</option>
			<option value="15">15</option>
			<option SELECTED value="25">25</option>
			<option value="50">50</option>
			<option value="75">75</option>
			<option value="100">100</option>
			</select>
			</td>			
			
			
			<td>Order BY:</td>
			<td>
			<select id="orderby">
			<option SELECTED value="id">ID</option>
			<option value="added">Added</option>
			<option value="allviews">Allviews</option>
			<option value="lastviewed">Lastviewed</option>
			<option value="duration">Duration</option>
			<option value="category">Category</option>
			</select>
			</td>

			<td>Order:</td>
			<td>
				<select id="order">
				<option SELECTED value="DESC">DESC</option>
				<option value="ASC">ASC</option>
				</select>
			</td>
		</tr>

		</table>
		</form>
	</fieldset>
	</div>


		
		<div id="allvideoloading"></div>
		
		
		<div id="allvideocontent"></div>



</div>


<?php
}
?>