Invalid media ID."; exit(); } //IS VIDEO IN ALBUM WITH RESTRICTED ACCESS? $albumPermission = 1;//set flag to public viewing //GET ALBUM INFO $stmt = $db->prepare("SELECT albummedia.albumID, albums.album, albums.permission FROM albummedia LEFT JOIN albums ON albummedia.albumID = albums.albumID WHERE albummedia.mediaID = :mediaID"); $stmt->execute(array(':mediaID'=> $mediaID)); $row = $stmt->fetch(PDO::FETCH_ASSOC); //IF ALBUM PERMISSION RESTRICTED REDIRECT TO HTTPS if(isset($row['permission'])){ if($row['permission'] != 'public'){ $albumPermission = 0;//change flag to restricted viewing } } //GET VIDEO INFO $stmt = $db->prepare("SELECT * FROM media WHERE mediaID=:mediaID"); $stmt->execute(array(':mediaID'=> $mediaID)); $row = $stmt->fetch(); $title = $row['title']; $type = $row['type'];//is multi bitrate available? $permission = $row['permission'];//get permissions - public or limited? $caption = $row['caption'];//are captions available? $chapters = $row['chapters'];//are chapters available? $format = $row['format']; $size = $row['size']; $tracking = $row['tracking']; $posterimage = $row['posterimage'];//poster image uploaded or use default? $viewcount = $row['viewcount'] + 1; $download = $row['download']; $speed = $row['speed']; if($stmt->rowCount() > 0){//video ID exists //CHECK VIDEO PERMISSION if($permission == 'public'){ //show video }elseif($permission == 'hidden'){ echo"
This video has restricted viewing access.
"; exit(); }elseif(($permission == 'album') && ($albumPermission == 1)){ //show video }else{ //redirect to secure page //header("Azure Authentication".$loginWebAccess); header("Location:mediasecure.php?id=" . $mediaID); } } //set aspect ratio if($format == "wide"){ $aspectratio = "16:9"; }else{ $aspectratio = "4:3"; } //set video poster image include "functions/playerimage.php"; //set video size include "functions/playersize.php"; $db=null; ?> LiberalArtsOnline MEDIA