if(isset($_POST['add'])) {
    $video_id = $_POST['video_id'];
    $episode_name = $_POST['episode_name'];
    $episode_number = $_POST['episode_number'];
    $season_number = $_POST['season_number'];
    $episode_description = $db->real_escape_string($_POST['episode_description']);
    $video_format = $_POST['video_format'];
    $video_embed_code = $_POST['video_embed_code'];
    $video_file_mp4 = $_POST['video_file_mp4'];
    if($video_format == 1) {
        $source = $video_embed_code;
    } else {
        $source = $video_file_mp4;
    }
    // Thumbnail Photo
    if(isset($_FILES['episode_thumbnail']['name'])) {
        $extension = strtolower(end(explode('.', $_FILES['episode_thumbnail']['name'])));
        if($extension == 'png' || $extension == 'jpg' || $extension == 'jpeg') {
            if(!$_FILES['episode_thumbnail']['error']) {
                $new_file_name = md5(mt_rand()).$_FILES['episode_thumbnail']['name'];
                if($_FILES['episode_thumbnail']['size'] > (10024000)) {
                    $valid_file = false;
                    $error = 'Oops! One of the photos you uploaded is too large';
                } else {
                    $valid_file = true;
                }
                if($valid_file) {
                    move_uploaded_file($_FILES['episode_thumbnail']['tmp_name'], '../uploads/episodes/'.$new_file_name);
                    $uploaded = true;
                }
            }
            else {
                $error = 'Error occured:  '.$_FILES['episode_thumbnail']['error'];
            }
        }
    }
    $admin->db->query("UPDATE movies SET is_series='1' WHERE id='".$video_id."'");
    $countseasons = $db->query("SELECT * FROM `seasons` WHERE movie_id='".$video_id."' && season_number='".$season_number."'");
    $row = $countseasons->fetch_row();
    if ($row[1] == $video_id && $row[2] == $season_number) {
        $season_id = $row[0];
    } else {
        $db->query("INSERT INTO seasons (movie_id,season_number) VALUES ('".$video_id."','".$season_number."')");
        $season_id = $db->insert_id;
    }

    $db->query("INSERT INTO `episodes`(`season_id`, `movie_id`, `episode_number`, `episode_name`, `episode_description`, `episode_thumbnail`, `episode_source`, `is_embed`) VALUES
    ('".$season_id."','".$video_id."','".$episode_number."','".$episode_name."','".$episode_description."',".$new_file_name."','".$source."','".$is_embed."')");

    header('Location: episodes.php?success=1');
    exit;
}