OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
old_sendy
/
includes
/
create
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
05/19/2025 10:07:16 AM
rwxr-xr-x
📄
calculate-totals.php
3.55 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete-attachment.php
819 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
main.php
6.47 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
save-campaign.php
6.72 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
send-later.php
2.69 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
send-now.php
34.98 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
test-send.php
10.7 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
timezone.php
22.25 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
toggle-wysiwyg.php
596 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
upload.php
2.32 KB
05/19/2025 10:07:16 AM
rw-r--r--
Editing: calculate-totals.php
Close
<?php include('../functions.php');?> <?php include('../login/auth.php');?> <?php //------------------------------------------------------// // INIT // //------------------------------------------------------// $email_list_incl = isset($_POST['include_lists']) ? mysqli_real_escape_string($mysqli, $_POST['include_lists']) : exit; $email_list_excl = isset($_POST['exclude_lists']) ? mysqli_real_escape_string($mysqli, $_POST['exclude_lists']) : exit; $email_list_seg_incl = isset($_POST['include_lists_seg']) ? mysqli_real_escape_string($mysqli, $_POST['include_lists_seg']) : exit; $email_list_seg_excl = isset($_POST['exclude_lists_seg']) ? mysqli_real_escape_string($mysqli, $_POST['exclude_lists_seg']) : exit; //Check input $input = $email_list_incl.','.$email_list_excl.','.$email_list_seg_incl.','.$email_list_seg_excl; $input = str_replace(',', '', $input); if(!is_numeric($input)) exit; if($email_list_incl==0 && $email_list_seg_incl==0) { echo 0; exit; } if(($email_list_excl != 0 || $email_list_seg_excl != 0) && ($email_list_incl==0 && $email_list_seg_incl==0)) { echo 0; exit; } //Include main list query $main_query = $email_list_incl == 0 ? '' : 'subscribers.list in ('.$email_list_incl.') '; //Include segmentation query $seg_query = $main_query != '' && $email_list_seg_incl != 0 ? 'OR ' : ''; $seg_query .= $email_list_seg_incl == 0 ? '' : '(subscribers_seg.seg_id IN ('.$email_list_seg_incl.')) '; //Exclude list query $exclude_query = $email_list_excl == 0 ? '' : 'subscribers.email NOT IN (SELECT email FROM subscribers WHERE list IN ('.$email_list_excl.')) '; //Exclude segmentation query $exclude_seg_query = $exclude_query != '' && $email_list_seg_excl != 0 ? 'AND ' : ''; $exclude_seg_query .= $email_list_seg_excl == 0 ? '' : 'subscribers.email NOT IN (SELECT subscribers.email FROM subscribers LEFT JOIN subscribers_seg ON (subscribers.id = subscribers_seg.subscriber_id) WHERE subscribers_seg.seg_id IN ('.$email_list_seg_excl.'))'; //------------------------------------------------------// // FUNCTIONS // //------------------------------------------------------// //Remove ONLY_FULL_GROUP_BY from sql_mode $q = 'SET SESSION sql_mode = ""'; $r = mysqli_query($mysqli, $q); if (!$r) error_log("[Unable to set sql_mode]".mysqli_error($mysqli).': in '.__FILE__.' on line '.__LINE__); //Check if we should send to GDPR subscribers only if($email_list_incl!=0) $q = 'SELECT gdpr_only FROM apps LEFT JOIN lists ON (apps.id = lists.app) WHERE lists.id IN ('.$email_list_incl.') LIMIT 1'; else $q = 'SELECT gdpr_only FROM apps LEFT JOIN seg ON (apps.id = seg.app) WHERE seg.id IN ('.$email_list_seg_incl.') LIMIT 1'; $r = mysqli_query($mysqli, $q); if ($r) while($row = mysqli_fetch_array($r)) $gdpr_only = $row['gdpr_only']; $gdpr_line = $gdpr_only ? 'AND gdpr = 1 ' : ''; //Get totals from lists $q = 'SELECT 1 FROM subscribers'; $q .= $email_list_seg_incl==0 && $email_list_seg_excl==0 ? ' ' : ' LEFT JOIN subscribers_seg ON (subscribers.id = subscribers_seg.subscriber_id) '; $q .= 'WHERE ('.$main_query.$seg_query.') '; $q .= $exclude_query != '' || $exclude_seg_query != '' ? 'AND ('.$exclude_query.$exclude_seg_query.') ' : ''; $q .= 'AND subscribers.unsubscribed = 0 AND subscribers.bounced = 0 AND subscribers.complaint = 0 AND subscribers.confirmed = 1 '.$gdpr_line.' GROUP BY subscribers.email'; $r = mysqli_query($mysqli, $q); if ($r) { $total = mysqli_num_rows($r); echo $total; } else echo 'failed'; ?>