OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
reader
/
sendy
/
includes
/
subscribers
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
11/18/2021 10:11:21 AM
rwxr-xr-x
📄
custom-fields.php
2.13 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
delete-blocked-domain.php
500 bytes
11/18/2021 09:43:09 AM
rw-r--r--
📄
delete-inactive.php
1.53 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
delete-suppressed-email.php
496 bytes
11/18/2021 09:43:09 AM
rw-r--r--
📄
delete-unconfirmed.php
2.17 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
delete.php
1.38 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
edit.php
4.93 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
export-blocked-domains.php
1.75 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
export-csv.php
7.22 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
export-suppression-list.php
1.75 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
housekeeping-no-clicks.php
407 bytes
11/18/2021 09:43:09 AM
rw-r--r--
📄
housekeeping-no-opens.php
406 bytes
11/18/2021 09:43:09 AM
rw-r--r--
📄
housekeeping.php
12.14 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
import-add.php
1.06 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
import-blocked-domain-list.php
2.91 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
import-blocked-domain-list2.php
1.91 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
import-delete.php
1.98 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
import-suppression-list.php
2.88 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
import-suppression-list2.php
1.89 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
import-unsubscribe.php
2.01 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
import-update.php
13.07 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
line-delete.php
1.02 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
line-unsubscribe.php
1.04 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
line-update.php
5.34 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
main.php
8.13 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
sample-csv.php
1.2 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
save-gdpr.php
1.15 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
subscribe-form.php
4.09 KB
11/18/2021 09:43:09 AM
rw-r--r--
📄
subscriber-info.php
17.55 KB
11/18/2021 09:43:10 AM
rw-r--r--
📄
unsubscribe.php
881 bytes
11/18/2021 09:43:10 AM
rw-r--r--
Editing: delete-inactive.php
Close
<?php include('../functions.php');?> <?php include('../login/auth.php');?> <?php include('housekeeping.php');?> <?php $app = isset($_POST['app']) && is_numeric($_POST['app']) ? mysqli_real_escape_string($mysqli, (int)$_POST['app']) : 0; $lid = isset($_POST['lid']) && is_numeric($_POST['lid']) ? mysqli_real_escape_string($mysqli, (int)$_POST['lid']) : 0; $action = is_numeric($_POST['action']) ? mysqli_real_escape_string($mysqli, $_POST['action']) : exit; //Delete unopen subscribers if($action==1) { //Get subscriber ids to delete $sub_ids = get_notopen_total($lid, $app, false); } //Delete unclick subscribers else if($action==2) { //Get subscriber ids to delete $sub_ids = get_notclick_total($lid, $app, false); } //Delete subscribers $q = 'DELETE FROM subscribers WHERE id IN ('.$sub_ids.')'; $r = mysqli_query($mysqli, $q); if($r) { //Return total number of subscribers after deleting if($action==1) { echo get_totals($lid).':'.get_notclick_total($lid, $app); } else if($action==2) { echo get_totals($lid).':'.get_notopen_total($lid, $app); } } else echo false; //------------------------------------------------------// function get_totals($lid='') //------------------------------------------------------// { global $mysqli; $q = 'SELECT COUNT(*) FROM subscribers WHERE list = '.$lid.' AND unsubscribed = 0 AND bounced = 0 AND complaint = 0 AND confirmed = 1'; $r = mysqli_query($mysqli, $q); if ($r) while($row = mysqli_fetch_array($r)) return number_format($row['COUNT(*)']); } ?>