OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
3-31-025chanakya
/
sendy
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/31/2025 06:36:42 AM
rwxr-xr-x
📄
.htaccess
643 bytes
03/26/2025 03:48:11 AM
rw-r--r--
📄
_compatibility.php
3.83 KB
03/26/2025 03:48:13 AM
rw-r--r--
📄
_install.php
7.3 KB
03/26/2025 03:48:13 AM
rw-r--r--
📁
api
-
03/26/2025 04:20:09 AM
rwxr-xr-x
📄
app.php
33.77 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders-create.php
23.29 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders-edit.php
28.89 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders-emails.php
26.81 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders-list.php
15.85 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders-report.php
40.18 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
autoresponders.php
77.28 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
blacklist-blocked-domains.php
13.39 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
blacklist-suppression.php
13.34 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
campaigns-rss.php
8.35 KB
03/26/2025 03:48:11 AM
rw-r--r--
📁
certs
-
03/26/2025 04:15:54 AM
rwxr-xr-x
📄
clear-queue.php
996 bytes
03/26/2025 03:48:11 AM
rw-r--r--
📄
confirm.php
9.34 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
create-template.php
3.99 KB
03/26/2025 03:48:11 AM
rw-r--r--
📄
create.php
15.92 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
css
-
03/26/2025 04:20:09 AM
rwxr-xr-x
📄
custom-fields.php
8.5 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
delete-from-list.php
5.29 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
detect-table-conflicts.php
2.47 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
edit-brand.php
57.32 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
edit-list.php
20.97 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
edit-template.php
4.65 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
edit.php
19.04 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
eula.txt
6.5 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
housekeeping-inactive.php
12.54 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
housekeeping-unconfirmed.php
14.01 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
img
-
03/26/2025 04:15:54 AM
rwxr-xr-x
📄
import-csv.php
18.68 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
includes
-
03/26/2025 04:20:12 AM
rwxr-xr-x
📄
index.php
18.77 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
js
-
03/26/2025 04:20:15 AM
rwxr-xr-x
📄
l.php
10.63 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
list.php
12.3 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
locale
-
03/26/2025 04:21:20 AM
rwxr-xr-x
📄
login.php
4.84 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
logout.php
133 bytes
03/26/2025 03:48:12 AM
rw-r--r--
📄
new-brand.php
46.35 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
new-list.php
1.98 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
payment.php
7.41 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
phpinfo.php
1.39 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
r.php
11 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
reconsent-success.php
3.91 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
remove-duplicates.php
2.94 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
report.php
48.79 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
reports.php
10.7 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
reset-cron.php
999 bytes
03/26/2025 03:48:12 AM
rw-r--r--
📄
rules.php
37.35 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
scheduled.php
39.51 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
search-all-brands.php
7.07 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
search-all-lists.php
10.68 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
search-campaigns.php
30.29 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
segment.php
45.8 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
segments-list.php
6.84 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
send-to.php
57.72 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
sending.php
8.9 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
settings.php
41.29 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
subscribe.php
29.26 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
subscribers.php
44.09 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
subscription.php
9.01 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
t.php
4.22 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
template-preview.php
4.55 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
templates.php
7.35 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
two-factor.php
4.33 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
unsubscribe-from-list.php
5.33 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
unsubscribe-success.php
3.9 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
unsubscribe.php
16.19 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
update-list.php
13.88 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
update-segments.php
3.09 KB
03/26/2025 03:48:12 AM
rw-r--r--
📁
uploads
-
03/26/2025 04:21:20 AM
rwxr-xr-x
📄
verification-status.php
3.63 KB
03/26/2025 03:48:12 AM
rw-r--r--
📄
w.php
17.76 KB
03/26/2025 03:48:13 AM
rw-r--r--
📄
webhooks-log.php
4.28 KB
03/26/2025 03:48:13 AM
rw-r--r--
Editing: remove-duplicates.php
Close
<?php include('includes/header.php');?> <?php include('includes/login/auth.php');?> <?php $listID = mysqli_real_escape_string($mysqli, (int)$_GET['list_id']); $delete = $_POST['delete']; //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__); if($listID != '' AND $listID != 0) { $q = 'SELECT name FROM lists WHERE id = '.$listID; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while($row = mysqli_fetch_array($r)) { $list_name = $row['name']; } } $q = 'SELECT id FROM subscribers WHERE list = '.$listID.' GROUP BY email HAVING (COUNT(email) > 1)'; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { $i = 0; while($row = mysqli_fetch_array($r)) { $id = $row['id']; if(count($_POST)!=0 && $_POST['delete']==1) { $q2 = 'DELETE FROM subscribers WHERE id = '.$id; mysqli_query($mysqli, $q2); } $i++; } if(count($_POST)!=0) { echo '<b>'.$i.'</b> '._('duplicate emails deleted from').' <b>'.$list_name.'</b>.<br/><br/><a href="'.get_app_info('path').'/remove-duplicates" style="text-decoration:underline;">← '._('Back').'</a>'; } else { echo '<form action="" method="post">'; echo '<b>'.$i.'</b> '._('duplicate email(s) found in').' <b>'.$list_name.'</b>, '._('delete them?'); echo '<input type="hidden" name="delete" value="1"/> <br/><br/><input type="submit" name="submit" class="btn" value="Delete"/> </form><br/><a href="'.get_app_info('path').'/remove-duplicates" style="text-decoration:underline;">← '._('Back').'</a>'; } } else { echo _('No duplicate emails found.').'<br/><br/><a href="'.get_app_info('path').'/remove-duplicates" style="text-decoration:underline;">← '._('Back').'</a>'; } } else { echo ' <h2>'._('Check and remove duplicate emails').'</h2><br/> '._('Select the list that have duplicates so that you can remove them').':<br/><br/><h3>'._('All available lists').'</h3><br/> '; $q = 'SELECT id, name FROM lists WHERE userID = '.get_app_info('main_userID'); $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while($row = mysqli_fetch_array($r)) { $id = $row['id']; $list_name = $row['name']; $q2 = 'SELECT id FROM subscribers WHERE list = '.$id.' GROUP BY email HAVING (COUNT(email) > 1)'; $r2 = mysqli_query($mysqli, $q2); if ($r2 && mysqli_num_rows($r2) > 0) { $i = 0; while($row = mysqli_fetch_array($r2)) { $i++; } } echo '<a href="'.get_app_info('path').'/remove-duplicates?list_id='.$id.'" style="text-decoration:underline;">'.$list_name.'</a> ('.mysqli_num_rows($r2).' '._('duplicates').')<br/>'; } } } ?> <?php include('includes/footer.php');?>