Файл: sngine-v2.8/Script/includes/ajax/admin/newsletter.php
Строк: 61
<?php
/**
* ajax -> admin -> newsletter
*
* @package Sngine
* @author Zamblek
*/
// set execution time
set_time_limit(0); /* unlimited max execution time */
// fetch bootstrap
require('../../../bootstrap.php');
// check AJAX Request
is_ajax();
// check admin|moderator permission
if(!$user->_is_admin) {
modal("MESSAGE", __("System Message"), __("You don't have the right permission to access this"));
}
// handle newsletter
try {
/* valid inputs */
if(is_empty($_POST['subject'])) {
throw new Exception(__("You must enter the email subject"));
}
if(is_empty($_POST['message'])) {
throw new Exception(__("You must enter the message subject"));
}
/* send email */
if($_POST['is_test']) {
if(!_email($system['system_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']))) {
throw new Exception(__("Email could not be sent"));
}
} else {
switch ($_POST['to']) {
case 'all_users':
$get_users = $db->query("SELECT user_email FROM users WHERE user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_activated':
$get_users = $db->query("SELECT user_email FROM users WHERE user_activated = '1' AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_activated':
$get_users = $db->query("SELECT user_email FROM users WHERE user_activated = '0' AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_week':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 1 WEEK AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_month':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 1 MONTH AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_3_months':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 3 MONTH AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_6_months':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 6 MONTH AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_9_months':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 9 MONTH AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
case 'users_not_logged_year':
$get_users = $db->query("SELECT user_email FROM users WHERE user_last_seen < NOW() - INTERVAL 1 YEAR AND user_privacy_newsletter = '1'") or _error("SQL_ERROR_THROWEN");
while($_user = $get_users->fetch_assoc()) {
_email($_user['user_email'], $_POST['subject'], $_POST['message'], strip_tags($_POST['message']));
}
break;
}
}
/* return */
return_json( array('success' => true, 'message' => __("Email has been sent successfully")) );
} catch (Exception $e) {
return_json( array('error' => true, 'message' => $e->getMessage()) );
}
?>