OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
old_sendy
/
includes
/
subscribers
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
05/19/2025 10:07:16 AM
rwxr-xr-x
📄
custom-fields.php
2.13 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete-blocked-domain.php
500 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete-inactive.php
1.53 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete-suppressed-email.php
496 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete-unconfirmed.php
2.17 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
delete.php
1.38 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
edit.php
4.93 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
export-blocked-domains.php
1.75 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
export-csv.php
7.22 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
export-suppression-list.php
1.75 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
housekeeping-no-clicks.php
407 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
housekeeping-no-opens.php
406 bytes
05/19/2025 10:07:16 AM
rw-r--r--
📄
housekeeping.php
12.14 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-add.php
1.06 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-blocked-domain-list.php
2.91 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-blocked-domain-list2.php
1.91 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-delete.php
1.98 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-suppression-list.php
2.88 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-suppression-list2.php
1.89 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-unsubscribe.php
2.01 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
import-update.php
13.07 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
line-delete.php
1.02 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
line-unsubscribe.php
1.04 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
line-update.php
5.34 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
main.php
8.13 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
sample-csv.php
1.2 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
save-gdpr.php
1.15 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
subscribe-form.php
4.09 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
subscriber-info.php
17.55 KB
05/19/2025 10:07:16 AM
rw-r--r--
📄
unsubscribe.php
881 bytes
05/19/2025 10:07:16 AM
rw-r--r--
Editing: delete-unconfirmed.php
Close
<?php include('../functions.php');?> <?php include('../login/auth.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; //If delete unconfirmed subscribers from individual lists if($app == 0) { $list_line = 'list = '.$lid; } else //If delete unconfirmed subscribers from ALL lists { $lids = ''; $q = 'SELECT id FROM lists WHERE app = '.$app.' AND opt_in = 1'; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while($row = mysqli_fetch_array($r)) $lids .= $row['id'].','; $lids = substr($lids, 0, -1); } $list_line = 'list IN ('.$lids.')'; } if($action==1) //Delete unconfirmed subscribers who didn't confirm their subscription for 1 week $q = 'DELETE FROM subscribers WHERE '.$list_line.' AND confirmed = 0 AND bounced = 0 AND complaint = 0 AND UNIX_TIMESTAMP() - timestamp < 604800'; else if($action==2) //Delete unconfirmed subscribers who didn't confirm their subscription for more than 1 week $q = 'DELETE FROM subscribers WHERE '.$list_line.' AND confirmed = 0 AND bounced = 0 AND complaint = 0 AND (UNIX_TIMESTAMP() - timestamp < 1209600 AND UNIX_TIMESTAMP() - timestamp > 604800)'; else if($action==3) //Delete unconfirmed subscribers who didn't confirm their subscription for more than 2 weeks $q = 'DELETE FROM subscribers WHERE '.$list_line.' AND confirmed = 0 AND bounced = 0 AND complaint = 0 AND UNIX_TIMESTAMP() - timestamp >= 1209600'; else if($action==0) //Delete all unconfirmed subscribers $q = 'DELETE FROM subscribers WHERE '.$list_line.' AND confirmed = 0 AND bounced = 0 AND complaint = 0'; $r = mysqli_query($mysqli, $q); if ($r) { $q2 = 'SELECT COUNT(*) FROM subscribers WHERE list = '.$lid.' AND confirmed = 0 AND bounced = 0 AND complaint = 0'; $r2 = mysqli_query($mysqli, $q2); if ($r2) { while($row = mysqli_fetch_array($r2)) echo $row['COUNT(*)']; } } else echo false; ?>