<?php
include('../helpers/init.php');

if(isset($_POST['addVideo'])){
	 $vcode =  slug($name);
    $code = $_POST['name'];
    
	
	$sql = "insert into video(code) values('$code')";
		if(query($sql)){
			header('Location:../pages/manage_video_gallery.php?result=success');
		}else{
			header('Location:../pages/manage_video_gallery.php?result=failer');
		}
}
//----- Add Video function ends here --------------------

if(isset($_GET['action']) && $_GET['action']=="deleteVideo")
{
	$id=$_GET['id'];
	$data = getWhere("video","id",$id);    
	$error = "";
    
	$delete_record = "delete from video where id=$id";
    if(query($delete_record)){
			header("Location:../pages/manage_video_gallery.php?result=vsuccess");
			}else{
				$error = error();
			header("Location:../pages/manage_video_gallery.php?result=vfailer".$error);
			}

}

//----------- Delete Video Ends Here --------------

if(isset($_POST['createAlbum'])){
	 $name = str_replace("'","",$_POST['name']);
	 $name = str_replace('"','\"',$name);
	 $slug = slug($name);
    /*check for the pre-existed category*/
	if(num_rows(checkSlugPre("albums",$slug))){
			header('Location:../pages/add_album.php?result=duplicate'); 
	}else{
    
	
	$sql = "insert into albums(title,slug) values('$name','$slug')";
		if(query($sql)){
			header('Location:../pages/manage-gallery.php?result=success');
		}else{
			header('Location:../pages/add_album.php?result=failer');
		}
    }
}
//----- create function ends here --------------------



if(isset($_GET['action']) && $_GET['action']=="deleteAlbum")
{
	$id=$_GET['id'];
	$data = getWhere("albums","id",$id);
    /*check for the default image*/
    $clients = getWhere("gallery","albumid",$id);
    if(num_rows($clients))
        {
		$error = " Album Cannot be deleted. Delete all its images then again try to delete this album.";
		header("Location:../pages/manage-gallery.php?result=failer&message=".$error);
	   }
        else
        {
		$sql = "delete from albums where id=$id";
		if(query($sql))
        {
			header("Location:../pages/manage-gallery.php?result=dsuccess");
		}
            else{
			$error =  error();
			header("Location:../pages/manage-gallery.php?result=failer");
		  }
	}

}

// -------------- gallery album ends here ---------

if(isset($_POST['addGalImage'])){
    
	$client = $_POST['clid'];
    $error = "";    
	$image="ab_".rand(111,999)."_".basename($_FILES['file']['name']);
    $fileinfo = @getimagesize($_FILES["file"]["tmp_name"]);
        $width = $fileinfo[0];
        $height = $fileinfo[1];
    
	if($_FILES['file']['size']>200000){
			header('Location:../pages/album-gallery.php?id='.$client.'&result=picfailer');
	}
    
    if($width > "800" || $height > "600"){
			header('Location:../pages/album-gallery.php?id='.$client.'&result=picfaild');
	}
    else{
		if (do_upload($image,"image-gallery")){
		$sql = "insert into gallery(image,albumid) values('$image','$client')";
		if(query($sql)){
			header('Location:../pages/album-gallery.php?id='.$client.'&result=success');
		}else{
			$error = error();
			header('Location:../pages/album-gallery.php?id='.$client.'&result=failer');
		}
		}
	}/*end else for size validation*/
	
	
}

//-----------------------Add Image Ends Here ---------------


if(isset($_GET['action']) && $_GET['action']=="deleteGalImage"){
	$id=$_GET['id'];
	$data = getWhere("gallery","id",$id);
    foreach($data as $row){
		$clid= $row['albumid'];
        $image= $row['image'];
        $banner = "../uploads/image-gallery/".$image;
        
		$sql = "delete from gallery where id=$id";
        
		if(query($sql)){  
            unlink($banner);
			header('Location:../pages/album-gallery.php?id='.$clid.'&result=dsuccess');
		}else{
			header('Location:../pages/album-gallery.php?id='.$clid.'&result=failer');
		}
	}
}

?>