Admin Control Panel v2.0

✎ Editing: newsletter.php ← Back

<?php
ob_start();
include('../includes/inc.config.php');

function newsletter_data($label){
global $database;
$email_nr = $database->execute("select * from newsletter_config where label = '$label'");
while($row = $database->fetch($email_nr )){
$result = $row['value'];
}
return $result;
}

if(isset($_GET['action']) && ($_GET['action'] == 'send')){

$step = (int) (!isset($_GET["step"]) ? 1 : $_GET["step"]);
    	$limit = newsletter_data('email_nr');
    	$startpoint = ($step * $limit) - $limit;
		$url = 'module.config.php?module=newsletter&action=add&send=true&step='.($step+1).'';

if(isset($_GET['m']) && ($_GET['m'] == 'ok')){
$mestxt = "Newsletter added successfully!";
$type = 'succ';
}

if(isset($_POST['send'])){
if($_POST['title'] == ''){
$mestxt = "Please enter title!";
$type = 'err';
}else if($_POST['text'] == ''){
$mestxt = "Please write some text!";
$type = 'err';
}else{

$get_users = $database->execute("select * from subscriptions");

$send_result = array();
while($row = $database->fetch($get_users)){
$to = $row['email'];
$from = $data->settings('admin_email');
$from_name = $data->settings('website_title');
$subject = $_POST['title'];
$text = $_POST['text'];
if($data->send_mail($to,$from,$from_name='',$subject,$text)){
$send_result[] = ''.$row['email'].'';
}else{
$send_result[] = ''.$row['email'].'';
}
}
$send_to = implode(', ',$send_result);
$add_page = $database->execute("insert into newsletter(`title`, `content`, `indate`, `to`)
values('".htmlentities($_POST['title'], ENT_QUOTES)."', '".htmlentities($_POST['text'], ENT_QUOTES)."', '".time()."', '".$_POST['rule']."')");

$get_last = $database->execute("select * from newsletter where title = '".htmlentities($_POST['title'], ENT_QUOTES)."' order by id desc limit 1");
while($row = $database->fetch($get_last)){
$_SESSION['title'] = html_entity_decode($row['title']);
$_SESSION['content'] = html_entity_decode($row['content']);
$_SESSION['to'] = $row['to'];
}

$totsteps = $data->email_limit($statement,$limit,$step,$url);
$mestxt = "Newsletter send successfully to green emails only, you can view the list bellow.";
$type = 'succ';

if($totsteps > 1){
$step_nr = "Step $step of $totsteps, Please wait...";
echo "<meta http-equiv=\"refresh\" content=\"3;URL='$url'\" />";
}
}

}else if(isset($_GET['send'])){
$get_users = $database->execute("select * from {$statement} LIMIT {$startpoint} , {$limit}");

$send_result = array();
while($row = $database->fetch($get_users)){
$to = $data->client_data($row['user_id'],'email');
$from = $data->settings('admin_email');
$from_name = $data->settings('website_title');
$subject = $_SESSION['title'];
$text = $_SESSION['content'];
if($data->send_mail($to,$from,$from_name='',$subject,$text)){
$send_result[] = ''.$data->client_data($row['user_id'],'email').'';
}else{
$send_result[] = ''.$data->client_data($row['user_id'],'email').'';
}
}
$send_to = implode(', ',$send_result);
$smarty->assign('title', $_SESSION['title']);
$smarty->assign('content', $_SESSION['content']);
$smarty->assign('to', $_SESSION['to']);

$totsteps = $data->email_limit($statement,$limit,$step,$url);
$mestxt = "Newsletter send successfully to green emails only, you can view the list bellow.";
$type = 'succ';

if($totsteps == $step){
$step_nr = "Step $step of $totsteps, Done!";
}else{
$step_nr = "Step $step of $totsteps, Please wait...";
echo "<meta http-equiv=\"refresh\" content=\"3;URL='$url'\" />";
}

}
$smarty->assign("type", $type);
$smarty->assign("message", $mestxt);
$smarty->assign('steps', $step_nr);
$smarty->assign('send_result', $send_to);
$smarty->display(END_PATH.'send.newsletter.tpl');

}else if(isset($_GET['action']) && ($_GET['action'] == 'view')){

if(isset($_GET['m']) && ($_GET['m'] == 'ok')){
$mestxt = "Newsletter send successfully!";
$type = 'succ';
}

if(isset($_POST['edit'])){
if($_POST['title'] == ''){
$mestxt = "Please enter title!";
$type = 'err';
}else if($_POST['text'] == ''){
$mestxt = "Please write somethink!";
$type = 'err';
}else{

$get_users = $database->execute("select * from subscriptions");

$send_result = array();
while($row = $database->fetch($get_users)){
$to = $row['email'];
$from = $data->settings('admin_email');
$from_name = $data->settings('website_title');
$subject = $_POST['title'];
$text = $_POST['text'];
if($data->send_mail($to,$from,$from_name='',$subject,$text)){
$send_result[] = ''.$row['email'].'';
}else{
$send_result[] = ''.$row['email'].'';
}
}
$send_to = implode(', ',$send_result);
$edit_page = $database->execute("UPDATE `newsletter` SET `title` = '".htmlentities($_POST['title'], ENT_QUOTES)."', `content` = '".htmlentities($_POST['text'], ENT_QUOTES)."', `to` = '".$_POST['rule']."' where id = '".$_GET['id']."'");

$get_last = $database->execute("select * from newsletter  where id = '".$_GET['id']."'");
while($row = $database->fetch($get_last)){
$_SESSION['title'] = html_entity_decode($row['title']);
$_SESSION['content'] = html_entity_decode($row['content']);
$_SESSION['to'] = $row['to'];
}
$totsteps = $data->email_limit($statement,$limit,$step,$url);
$mestxt = "Newsletter send successfully to green emails only, you can view the list bellow.";
$type = 'succ';

if($totsteps > 1){
$step_nr = "Step $step of $totsteps, Please wait...";
echo "<meta http-equiv=\"refresh\" content=\"3;URL='$url'\" />";
}

}
}else if(isset($_GET['send'])){
$get_users = $database->execute("select * from `subscriptions`");

$send_result = array();
while($row = $database->fetch($get_users)){
$to = $row['email'];
$from = $data->settings('admin_email');
$from_name = $data->settings('website_title');
$subject = $_SESSION['title'];
$text = $_SESSION['content'];
if($data->send_mail($to,$from,$from_name='',$subject,$text)){
$send_result[] = ''.$row['email'].'';
}else{
$send_result[] = ''.$row['email'].'';
}
}
$send_to = implode(', ',$send_result);
$smarty->assign('title', $_SESSION['title']);
$smarty->assign('content', $_SESSION['content']);
$smarty->assign('to', $_SESSION['to']);

$totsteps = $data->email_limit($statement,$limit,$step,$url);
$mestxt = "Newsletter send successfully to green emails only, you can view the list bellow.";
$type = 'succ';

if($totsteps == $step){
$step_nr = "Step $step of $totsteps, Done!";
}else{
$step_nr = "Step $step of $totsteps, Please wait...";
echo "<meta http-equiv=\"refresh\" content=\"3;URL='$url'\" />";
}

}

$getnews = $database->execute("select * from `newsletter` where id = '".$_GET['id']."'");
while($row = $database->fetch($getnews)){
$smarty->assign('title', $row['title']);
$smarty->assign('content', $row['content']);
$smarty->assign('to', $row['to']);
}

$smarty->assign('message', $message);
$smarty->assign('send_result', $send_to);
$smarty->display(END_PATH.'view.newsletter.tpl');

}else{

if(isset($_GET['a']) && ($_GET['a'] == 'del')){
$delete = $database->execute("delete from `newsletter` where id = '".$_GET['id']."'");
if($delete){
$mestxt = "Newsletter deleted successfully!";
$type = 'succ';
}
}
if(isset($_GET['m']) && ($_GET['m'] == 'ok')){
$mestxt = "Newsletter send successfully!";
$type = 'succ';
}

$result = array();
$get_news = $database->execute("select * from `newsletter`");
while($row = $database->fetch($get_news)){
$result[] = $row;
}
$smarty->assign('newsletter', $result);

$smarty->assign('message', $message);
$smarty->display(END_PATH.'newsletters.tpl');
}

Cancel