192 lines
6.0 KiB
PHP
192 lines
6.0 KiB
PHP
<?php
|
|
/**
|
|
* Mass message class
|
|
* @author Hire-Experts
|
|
* @version 2.01
|
|
*/
|
|
class he_mass_message
|
|
{
|
|
function create_campaign($subject, $message, $restriction_type, $levels = array(), $subnets = array(), $cat_selected = 0)
|
|
{
|
|
global $setting;
|
|
|
|
set_time_limit(600);
|
|
|
|
if( !$subject || !$message || !$setting['setting_mass_message_from_user'] ) return false;
|
|
|
|
$conditions = array();
|
|
$joins = array();
|
|
$conditions_glue = ' AND ';
|
|
if( $restriction_type==1 )
|
|
{
|
|
$levels = (array)$levels;
|
|
$subnets = (array)$subnets;
|
|
if( !$levels && !$subnets ) return false;
|
|
|
|
if( $levels )
|
|
$conditions[] = "user_level_id IN('".implode("', '", $levels)."')";
|
|
|
|
if( $subnets )
|
|
$conditions[] = "user_subnet_id IN('".implode("', '", $subnets)."')";
|
|
|
|
$conditions_glue = ' OR ';
|
|
}
|
|
else
|
|
{
|
|
$field = new se_field("profile");
|
|
$field->cat_list(0, 0, 1, "profilecat_id='{$cat_selected}'", "", "profilefield_search<>'0'");
|
|
$joins[] = "LEFT JOIN se_profilevalues ON se_profilevalues.profilevalue_user_id=se_users.user_id";
|
|
|
|
$conditions[] = "se_users.user_profilecat_id='$cat_selected'";
|
|
|
|
if($field->field_query != "")
|
|
$conditions[] = $field->field_query;
|
|
|
|
if( $_REQUEST['user_withphoto'] )
|
|
$conditions[] = "user_photo<>''";
|
|
}
|
|
|
|
#generate fetch users query
|
|
$email_query = "SELECT user_username, user_email FROM se_users";
|
|
|
|
|
|
|
|
if( $joins ) $email_query .= ' '.implode(' ', $joins);
|
|
$email_query .= ' WHERE se_users.user_enabled="1" ';
|
|
if( $conditions ) $email_query .= ' AND ('.implode($conditions_glue, $conditions).')';
|
|
|
|
#create campaign
|
|
$res = he_database::query($email_query);
|
|
$recipients_count = he_database::num_rows($res);
|
|
$campaign_id = he_mass_message::insert_campaign($subject, $message, $setting['setting_mass_message_from_user'], $recipients_count);
|
|
if( !$campaign_id ) return false;
|
|
|
|
while( $user = he_database::fetch_row_from_resource($res) )
|
|
{
|
|
if( $setting['setting_mass_message_from_user']==$user['user_username'] ) continue;
|
|
|
|
he_mass_message::insert_into_queue($campaign_id, $user['user_username']);
|
|
}
|
|
return true;
|
|
}
|
|
|
|
function insert_campaign($subject, $message, $sender, $recipient_count)
|
|
{
|
|
he_database::query("INSERT INTO se_mass_message_campaign SET subject='".he_database::real_escape($subject)."', message='".he_database::real_escape($message)."', sender='".he_database::real_escape($sender)."', recipient_count=$recipient_count, sent_time=UNIX_TIMESTAMP()");
|
|
return he_database::insert_id();
|
|
}
|
|
|
|
function get_campaigns($from, $count)
|
|
{
|
|
$from = intval($from);
|
|
$count = intval($count);
|
|
return he_database::fetch_array("SELECT * FROM se_mass_message_campaign ORDER BY sent_time DESC LIMIT $from, $count");
|
|
}
|
|
|
|
function get_campaign($id)
|
|
{
|
|
return he_database::fetch_row("SELECT * FROM se_mass_message_campaign WHERE id=".intval($id));
|
|
}
|
|
|
|
function insert_into_queue($campaign_id, $recipient)
|
|
{
|
|
he_database::query("INSERT INTO se_mass_message_queue SET campaign_id=$campaign_id, recipient='".he_database::real_escape($recipient)."'");
|
|
}
|
|
|
|
function get_user_levels()
|
|
{
|
|
return he_database::fetch_array("SELECT level_id, level_name, level_default FROM se_levels");
|
|
}
|
|
|
|
function get_subnets()
|
|
{
|
|
$res = he_database::query("SELECT subnet_id, subnet_name FROM se_subnets");
|
|
$subnet_array = array();
|
|
while($subnet_info = he_database::fetch_row_from_resource($res))
|
|
{
|
|
SE_Language::_preload($subnet_info['subnet_name']);
|
|
$subnet_array[] = $subnet_info;
|
|
}
|
|
|
|
return $subnet_array;
|
|
}
|
|
|
|
function update_settings($data)
|
|
{
|
|
global $setting;
|
|
|
|
if( !$data || !is_array($data) ) return false;
|
|
$fields = array();
|
|
foreach ($data as $field => $value)
|
|
{
|
|
$fields[] = "`$field`='".he_database::real_escape($value)."'";
|
|
$setting[$field] = $value;
|
|
}
|
|
$q = implode(',', $fields);
|
|
|
|
he_database::query("UPDATE se_settings SET $q");
|
|
return true;
|
|
}
|
|
|
|
function get_users($username)
|
|
{
|
|
global $database;
|
|
$username = trim($username);
|
|
if( !$username ) return array();
|
|
|
|
$result = $database->database_query("SELECT user_username FROM se_users WHERE user_username LIKE '%$username%'");
|
|
$return = array();
|
|
while($row = $database->database_fetch_assoc($result))
|
|
{
|
|
$return[] = array(
|
|
'value'=> $row['user_username'],
|
|
'info'=> $row['user_username']
|
|
);
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function send_message_from_queue($count)
|
|
{
|
|
$count = intval($count) ? intval($count) : 10;
|
|
$campaigns = array();
|
|
$senders = array();
|
|
|
|
$messages = he_database::fetch_array("SELECT * FROM se_mass_message_queue ORDER BY id LIMIT $count");
|
|
foreach ($messages as $message)
|
|
{
|
|
he_database::query("DELETE FROM se_mass_message_queue WHERE id={$message['id']}");
|
|
if( !he_database::affected_rows() ) continue;
|
|
|
|
if( !$campaigns[$message['campaign_id']] )
|
|
$campaigns[$message['campaign_id']] = he_mass_message::get_campaign($message['campaign_id']);
|
|
$campaign = $campaigns[$message['campaign_id']];
|
|
|
|
if( !$senders[$campaign['sender']] )
|
|
$senders[$campaign['sender']] = new se_user(array(0, $campaign['sender']));
|
|
|
|
$sender = $senders[$campaign['sender']];
|
|
if( !$sender->user_exists ) continue;
|
|
|
|
$user = new se_user(array(0, $message['recipient']));
|
|
if( !$user->user_exists ) continue;
|
|
|
|
$subject = str_replace(array('[displayname]', '[email]'), array($user->user_info['user_displayname'], $user->user_info['user_email']), $campaign['subject']);
|
|
$body = str_replace(array('[displayname]', '[email]'), array($user->user_info['user_displayname'], $user->user_info['user_email']), $campaign['message']);
|
|
$sender->level_info['level_message_allow']=2;
|
|
$sender->user_message_send($user->user_info['user_username'], $subject, $body);
|
|
}
|
|
}
|
|
|
|
function cron()
|
|
{
|
|
global $setting;
|
|
|
|
if( $setting['setting_mass_message_last_execute'] > time()-60 ) return;
|
|
$setting['setting_mass_message_last_execute'] = time();
|
|
he_database::query("UPDATE se_settings SET setting_mass_message_last_execute={$setting['setting_mass_message_last_execute']} WHERE setting_id='1'");
|
|
he_mass_message::send_message_from_queue($setting['setting_mass_message_per_minute']);
|
|
}
|
|
}
|
|
|
|
?>
|