include('includes/header.php');
if(($_GET['act'] == 'pdf') && ($_GET['file'] !='')){
$sqlQryDownl = "SELECT vFile FROM ".TBL_DOWNLOADS." WHERE intDownId=".$_REQUEST['file']." LIMIT 1";
$resQryDownl = mysqli_query($con,$sqlQryDownl);
$rowQryDownl = mysqli_fetch_object($resQryDownl);
$filename = "https://".$_SERVER['HTTP_HOST']."/adminpanel/uploads/downloads/".$rowQryDownl->vFile."";
$filename1 = $_SERVER['DOCUMENT_ROOT']."/adminpanel/uploads/downloads/".$rowQryDownl->vFile."";
set_time_limit(300);
header("Expires: 0");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
header("Content-type: application/pdf");
header("Content-type: application/octet-stream");
header('Content-disposition: attachment; filename='.basename($filename));
header('Content-Transfer-Encoding: binary');
header('Pragma: public');
header('Content-length: '.filesize($filename1));
ob_clean();
flush();
readfile($filename1);
exit;
}
if($_REQUEST['nLetter']=='yes'){
$sql = "SELECT * FROM `".TBL_NEWSLETTER_USERS."` WHERE `vEmail`='".$_REQUEST['newsLetter']."' LIMIT 1";
$rs = mysqli_query($con,$sql);
$row = mysqli_fetch_object($rs);
$nEmail = $row->vEmail;
if($nEmail == $_REQUEST['newsLetter']){
$strMsg1 = "This email already exists!";
}else{
$sqlNesQry = "INSERT INTO `".TBL_NEWSLETTER_USERS."` (`intNewsLetterUid`, `vName`, `vEmail`, `cStatus`, `dtCreated`)
VALUES (NULL, '', '".$_REQUEST['newsLetter']."', 'Y', now())";
mysqli_query($con,$sqlNesQry);
$strMsg1 = "Thank you for submitting your email";
}
}
?>
