Files
Testing/include/class_he_mass_message.php

192 lines
6.0 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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']);
}
}
?>