<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
foreach ($_REQUEST as $key => $value){
	$$key = $value;
}
if($action == 'DeleteMedia'){
	$sql = "SELECT * FROM `tblPhoto` where id = ".$id."";
	$result	=	mysql_query($sql) or die (mysql_error());
	$row=mysql_fetch_assoc($result);
        
	if($row['file_upload']){
	   @unlink("../cat_images/media/pics/".$row['file_upload']);
	}
        
	if($row['media']){
	   @unlink("../cat_images/media/video/".$row['media']);
	}
	$sql1	= "DELETE FROM `tblPhoto` WHERE `id` = ".$id." LIMIT 1";
	mysql_query($sql1) or die(mysql_error()); 
}


?> 
<LINK href="mel.css" type=text/css rel=stylesheet>
<LINK href="sdmenu.css" type=text/css rel=stylesheet>
<table width="94%" border="0" cellspacing="0" cellpadding="0">
	<tr> 
		<td>
			<fieldset>
				<legend>VIDEO LIST</legend>
				<table width="100%" border="0" cellspacing="2" cellpadding="0">
				<?php	if($msg	!=	""){	?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="2" align="center"><?=$msg;?></td>
					</tr>
				<?php } ?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="2"><input type="button" name="btnadd22" value="Add Video" class="button" onclick="window.location.href='media_add.php?mode=Add&page=addmedia'" style="width:150px" /></td>
					</tr>
					<tr valign="middle" class="general"> 
						<td width="43%" height="26">File</td>
						<td width="43%" height="26">Type</td>
						<td width="43%" height="26" align="center" valign="middle" >Action</td>
					</tr>
					<?php
						$query	=	"select * from `tblPhoto` WHERE `type` = 'video' order by createdOn DESC";
						$result	=	mysql_query($query) or die(mysql_error());
						while($arrayCategory=mysql_fetch_assoc($result)){	  
					?>
					<tr valign="middle" class="generaltxt"> 
						<td height="26">
							<?php 
								if($arrayCategory['type'] == 'pic'){ ?>
									<img src="../cat_images/media/pics/<?php echo $arrayCategory['media']; ?>" height="50"> 
							<?php	}  
								else{  ?>
									<img src="images/swf.png" height="50">
							<?php	}  
							?>
						</td>
						<td height="26"><?php if($arrayCategory['type'] == 'pic'){echo "Image"; }  else{ echo "Video"; }  ?></td>
                                                <td align="center">
                                                 <a href="media_add.php?id=<?=$arrayCategory['id']?>&mode=Edit&page=addmedia" class="action1"><strong>Edit</strong></a> 
						|<a href="media_list.php?id=<?=$arrayCategory['id']?>&action=DeleteMedia" onClick="return confirm('Are you sure you want to delete')" class="action1"><strong>Delete</strong></a></td>
					</tr>
					<?php } ?>
					<tr align="right" valign="middle" class="generaltxt"> 
						<td height="10" colspan="2">&nbsp;</td>
					</tr>
					<tr align="right" valign="middle" class="generaltxt"> 
						<td height="26" colspan="3"><input type="button" name="btnadd2" value="Add Video" class="button" onclick="window.location.href='media_add.php?mode=Add&page=addmedia'" style="width:150px" /></td>
					</tr>
				</table>
			</fieldset>
		</td>
	</tr>	
</table>