header('Content-Type: text/html; charset=utf-8');
include($_SERVER['DOCUMENT_ROOT']."/_includes/_conn.php");
if (is_numeric($_REQUEST['id']) === false) {
header("location: /");
exit();
} else {
$projectid = addslashes($_REQUEST['id']);
};
$sql1 = "SELECT * FROM screen_projects WHERE ProjectID = " . $projectid;
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_array($result);
$projecttitle = $row['ProjectTitle'];
$projectgenre = $row['ProjectGenre'];
$projectruntime = $row['ProjectRunTime'];
$projectlang = $row['ProjectLanguage'];
$projectsynopsis = $row['ProjectSynopsis'];
$projectimg1 = $row['ProjectImg1'];
$projectimg2 = $row['ProjectImg2'];
$projectimg3 = $row['ProjectImg3'];
$projectimg4 = $row['ProjectImg4'];
$projecttrailer = $row['ProjectTrailer'];
$projectfullfilm = $row['ProjectFullFilm'];
if ($row['ProjectBuyLink'] == "") {
$projectbuylink = 0;
} else {
$projectbuylink = $row['ProjectBuyLink'];
};
if (strlen($projecttrailer) < 5) {
$projecttrailer = 0;
};
if (strlen($projectfullfilm) < 5) {
$projectfullfilm = 0;
};
$projectposter = $row['ProjectPoster'];
if (is_null($row['ProjectImg1']) !== true) {
$projectimg1 = "";
};
if (is_null($row['ProjectImg2']) !== true) {
$projectimg2 = "
";
};
if (is_null($row['ProjectImg3']) !== true) {
$projectimg3 = "
";
};
if (is_null($row['ProjectImg4']) !== true) {
$projectimg4 = "
";
};
$projectsales = $row['ProjectSales'];
$projectyear = $row['ProjectYear'];
$projectstatus = $row['ProjectStatus'];
$projecttitletag = $row['ProjectTitleTag'];
$projectmetakeywords = $row['ProjectMetaKeywords'];
$projectmetadesc = $row['ProjectMetaDescription'];
if (is_null($row['ProjectHeaderImg']) !== true) {
$projectheaderimg = "/_images/" . $row['ProjectHeaderImg'];
} else {
$projectheaderimg = "/_images/wfg-thin.jpg";
};
$sql2 = "SELECT * FROM screen_projects_credits WHERE ProjectID = " . $projectid . " Order by CreditNameOrder";
$result2 = mysqli_query($con, $sql2);
$num_rows = 0;
?>