OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .htaccess	643 bytes	11/18/2021 09:43:15 AM	rw-r--r--
📄 _compatibility.php	3.83 KB	11/18/2021 09:43:14 AM	rwxr-xr-x
📄 _install.php	7.3 KB	11/18/2021 09:43:11 AM	rw-r--r--
📁 api	-	11/18/2021 09:42:34 AM	rwxr-xr-x
📄 app.php	33.77 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 autoresponders-create.php	23.29 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 autoresponders-edit.php	28.89 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 autoresponders-emails.php	26.81 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 autoresponders-list.php	15.85 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 autoresponders-report.php	40.18 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 autoresponders.php	77.28 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 blacklist-blocked-domains.php	13.39 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 blacklist-suppression.php	13.34 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 campaigns-rss.php	8.35 KB	11/18/2021 09:43:12 AM	rw-r--r--
📁 certs	-	11/18/2021 09:42:17 AM	rwxr-xr-x
📄 clear-queue.php	996 bytes	11/18/2021 09:43:14 AM	rw-r--r--
📄 confirm.php	9.34 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 create-template.php	3.99 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 create.php	15.92 KB	11/18/2021 09:43:12 AM	rw-r--r--
📁 css	-	11/18/2021 09:42:15 AM	rwxr-xr-x
📄 custom-fields.php	8.5 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 delete-from-list.php	5.29 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 detect-table-conflicts.php	2.47 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 edit-brand.php	57.32 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 edit-list.php	20.97 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 edit-template.php	4.65 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 edit.php	19.04 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 eula.txt	6.5 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 housekeeping-inactive.php	12.54 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 housekeeping-unconfirmed.php	14.01 KB	11/18/2021 09:43:11 AM	rw-r--r--
📁 img	-	11/18/2021 09:43:36 AM	rwxr-xr-x
📄 import-csv.php	18.68 KB	11/18/2021 09:43:12 AM	rw-r--r--
📁 includes	-	11/18/2021 10:11:21 AM	rwxr-xr-x
📄 index.php	18.77 KB	11/18/2021 09:43:12 AM	rw-r--r--
📁 js	-	11/18/2021 09:43:37 AM	rwxr-xr-x
📄 l.php	10.63 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 list.php	12.3 KB	11/18/2021 09:43:13 AM	rw-r--r--
📁 locale	-	11/18/2021 09:41:10 AM	rwxr-xr-x
📄 login.php	4.84 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 logout.php	133 bytes	11/18/2021 09:43:12 AM	rw-r--r--
📄 new-brand.php	46.35 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 new-list.php	1.98 KB	11/18/2021 09:43:15 AM	rw-r--r--
📄 payment.php	7.41 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 phpinfo.php	1.39 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 r.php	11 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 reconsent-success.php	3.91 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 remove-duplicates.php	2.94 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 report.php	48.79 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 reports.php	10.7 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 reset-cron.php	999 bytes	11/18/2021 09:43:12 AM	rw-r--r--
📄 rules.php	37.35 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 scheduled.php	39.51 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 search-all-brands.php	7.07 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 search-all-lists.php	10.68 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 search-campaigns.php	30.29 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 segment.php	45.8 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 segments-list.php	6.84 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 send-to.php	57.72 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 sending.php	8.9 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 settings.php	41.29 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 subscribe.php	29.26 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 subscribers.php	44.09 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 subscription.php	9.01 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 t.php	4.22 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 template-preview.php	4.55 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 templates.php	7.35 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 two-factor.php	4.33 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 unsubscribe-from-list.php	5.33 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 unsubscribe-success.php	3.9 KB	11/18/2021 09:43:11 AM	rw-r--r--
📄 unsubscribe.php	16.19 KB	11/18/2021 09:43:13 AM	rw-r--r--
📄 update-list.php	13.88 KB	11/18/2021 09:43:15 AM	rw-r--r--
📄 update-segments.php	3.09 KB	11/18/2021 09:43:12 AM	rw-r--r--
📁 uploads	-	10/25/2024 06:04:31 AM	rwxrwxrwx
📄 verification-status.php	3.63 KB	11/18/2021 09:43:12 AM	rw-r--r--
📄 w.php	17.76 KB	11/18/2021 09:43:14 AM	rw-r--r--
📄 webhooks-log.php	4.28 KB	11/18/2021 09:43:14 AM	rw-r--r--

Editing: housekeeping-unconfirmed.php

<?php include('includes/header.php');?>
<?php include('includes/login/auth.php');?>
<?php include('includes/subscribers/main.php');?>
<?php include('includes/subscribers/housekeeping.php');?>

<?php 	
	if(get_app_info('is_sub_user')) 
	{
		if(get_app_info('app')!=get_app_info('restricted_to_app'))
		{
			echo '<script type="text/javascript">window.location="'.addslashes(get_app_info('path')).'/housekeeping-unconfirmed?i='.get_app_info('restricted_to_app').'"</script>';
			exit;
		}
		else if(get_app_info('campaigns_only')==1 && get_app_info('templates_only')==1 && get_app_info('lists_only')==1 && get_app_info('reports_only')==1)
		{
			echo '<script type="text/javascript">window.location="'.addslashes(get_app_info('path')).'/logout"</script>';
			exit;
		}
		else if(get_app_info('lists_only')==1)
		{
			go_to_next_allowed_section();
		}
	}
	
	//vars
	$p = isset($_GET['p']) && is_numeric($_GET['p']) ? $_GET['p'] : null;
	$loader = get_app_info('dark_mode') ? 'loader-dark.gif' : 'loader-light.gif';
?>

<div class="row-fluid">
    <div class="span2">
        <?php include('includes/sidebar.php');?>
    </div> 
    <div class="span10">
    	<div class="row-fluid">
	    	<div class="span12">
		    	<div>
			    	<p class="lead">
		    	<?php if(get_app_info('is_sub_user')):?>
			    	<?php echo get_app_data('app_name');?>
		    	<?php else:?>
			    	<a href="<?php echo get_app_info('path'); ?>/edit-brand?i=<?php echo get_app_info('app');?>" data-placement="right" title="<?php echo _('Edit brand settings');?>"><?php echo get_app_data('app_name');?> <span class="icon icon-pencil top-brand-pencil"></span></a>
		    	<?php endif;?>
		    </p>
		    	</div>
		    	<h2><?php echo _('Housekeeping');?></h2>
				<br/>
		    	<div class="well">
			    	<div class="btn-group" data-toggle="buttons-radio">
					  <a href="javascript:void(0)" title="" class="btn active"><i class="icon icon-meh"></i> <?php echo _('Unconfirmed subscribers');?></a>
					  <a href="<?php echo get_app_info('path');?>/housekeeping-inactive?i=<?php echo get_app_info('app');?>" title="" class="btn"><i class="icon icon-moon"></i> <?php echo _('Inactive subscribers');?></a>
					</div>
		    	</div>
		    	<div class="alert alert-info">
					<p><i class="icon icon-info-sign"></i> <?php echo _('Housekeeping for \'Unconfirmed subscribers\' allows you to bulk remove subscribers who signed up to double opt-in lists but did not click the confirmation link to confirm their subscription.');?></p>
				</div>
	    	</div>
	    </div>
	    
	    <br/>
	    
	    <div class="row-fluid">
		    <div class="span12">
		    	<h3><?php echo _('Unconfirmed subscribers');?></h3><hr/>
				<table class="table table-striped responsive">
	              <thead>
	                <tr>
		              <?php 
			              //Check if there are any double opt-in lists, if not, hide the table headers
			              $q = 'SELECT id FROM lists WHERE app = '.get_app_info('app').' AND opt_in = 1';
			              $r = mysqli_query($mysqli, $q);
			              if (mysqli_num_rows($r) != 0):
			              $total_lists = mysqli_num_rows($r);
		              ?>
		                  <th><?php echo _('List');?></th>
		                  <th><?php echo _('Status');?></th>
		                  <th><a href="javascript:void(0)" title="<?php echo _('Remove subscribers from all lists who did not confirm their subscription for 1 week?');?>" id="delete-btn-1week" class="delete-list"><i class="icon icon-trash"></i></a> <?php echo _('1 week');?></th>
		                  <th><a href="javascript:void(0)" title="<?php echo _('Remove subscribers from all lists who did not confirm their subscription for more than 1 week?');?>" id="delete-btn-1weekmore" class="delete-list"><i class="icon icon-trash"></i></a> <?php echo _('> 1 week');?></th>
		                  <th><a href="javascript:void(0)" title="<?php echo _('Remove subscribers from all lists who did not confirm their subscription for more than 2 weeks?');?>" id="delete-btn-2weeks" class="delete-list"><i class="icon icon-trash"></i></a> <?php echo _('> 2 weeks');?></th>
		                  <th><a href="javascript:void(0)" title="<?php echo _('Remove subscribers from all lists who did not confirm their subscription?');?>" id="delete-btn-all" class="delete-list"><i class="icon icon-trash"></i></a> <?php echo _('All');?></th>
		                  <th><?php echo _('Export');?></th>
		              <?php endif;?>
	                  
	                  <script type="text/javascript">
				        $("#delete-btn-1week, #delete-btn-1weekmore, #delete-btn-2weeks, #delete-btn-all").click(function(e){
					        c = "<?php echo _('Confirm permanently remove subscribers?');?>"
					        if(confirm(c))
					        {
						        e.preventDefault(); 
						        
						        var action = "";
						        if(e.currentTarget.id=="delete-btn-1week") action = "1";
						        else if(e.currentTarget.id=="delete-btn-1weekmore") action = "2";
						        else if(e.currentTarget.id=="delete-btn-2weeks") action = "3";
						        else if(e.currentTarget.id=="delete-btn-all") action = "0";
						        
								$.post("includes/subscribers/delete-unconfirmed.php", { app: <?php echo get_app_info('app');?>, action: action},
								  function(data) {
								      if(data)
								      	window.location = "<?php echo get_app_info('path');?>/housekeeping-unconfirmed?i=<?php echo get_app_info('app');?>";
								      else
								      	alert("<?php echo _('Sorry, unable to remove subscribers. Please try again later!');?>");
								  }
								);
							}
						});
						</script>
	                </tr>
	              </thead>
	              <tbody>
	                	<?php 	
		                	$limit = 10;
							$total_pages = ceil($total_lists/$limit);
							$offset = $p!=null ? ($p-1) * $limit : 0;
								                	
		                	$q = 'SELECT id, name FROM lists WHERE app = '.get_app_info('app').' AND userID = '.get_app_info('main_userID').' AND opt_in = 1 ORDER BY name ASC LIMIT '.$offset.','.$limit;
		                	$r = mysqli_query($mysqli, $q);
		                	if ($r && mysqli_num_rows($r) > 0)
		                	{
		                	    while($row = mysqli_fetch_array($r))
		                	    {
		                			$lid = $row['id'];
		                			$list_name = $row['name'];
		                			
		                			$unconfirmed_count_1 = get_unconfirmed_total($lid, 1);
		                			$unconfirmed_count_2 = get_unconfirmed_total($lid, 2);
		                			$unconfirmed_count_3 = get_unconfirmed_total($lid, 3);
		                			$unconfirmed_count_4 = get_unconfirmed_total($lid, 0);
		                			
		                			$unconfirmed_delete_btn1 = !$unconfirmed_count_1 ? '' : '<a href="javascript:void(0)" title="'._('Remove subscribers who did not confirm their subscription for 1 week?').'" id="delete-btn-'.$lid.'-1week" class="delete-list"><i class="icon icon-trash"></i></a>';
		                			$unconfirmed_delete_btn2 = !$unconfirmed_count_2 ? '' : '<a href="javascript:void(0)" title="'._('Remove subscribers who did not confirm their subscription for more than 1 week?').'" id="delete-btn-'.$lid.'-1weekmore" class="delete-list"><i class="icon icon-trash"></i></a>';
		                			$unconfirmed_delete_btn3 = !$unconfirmed_count_3 ? '' : '<a href="javascript:void(0)" title="'._('Remove subscribers who did not confirm their subscription for more than 2 weeks?').'" id="delete-btn-'.$lid.'-2weeks" class="delete-list"><i class="icon icon-trash"></i></a>';
		                			$unconfirmed_delete_btn4 = !$unconfirmed_count_4 ? '' : '<a href="javascript:void(0)" title="'._('Remove ALL subscribers who did not confirm their subscription?').'" id="delete-btn-'.$lid.'-all" class="delete-list"><i class="icon icon-trash"></i></a>';
		                			
		                			$subscriber_count_1week = '<span id="count-'.$lid.'-1week">'.$unconfirmed_count_1.'</span>';
		                			$subscriber_count_2week = '<span id="count-'.$lid.'-1weekmore">'.$unconfirmed_count_2.'</span>';
		                			$subscriber_count_2week_more = '<span id="count-'.$lid.'-2weeks">'.$unconfirmed_count_3.'</span>';
		                			$subscriber_count_all = '<span id="count-'.$lid.'-all">'.$unconfirmed_count_4.'</span>';
		                			
		                			echo '
		                			<tr id="uc-'.$lid.'">
			                			<td><a href="'.get_app_info('path').'/subscribers?i='.get_app_info('app').'&l='.$lid.'">'.$list_name.' <span class="badge badge-success">'.get_totals('a', '', $lid).'</span></a></td>
			                			<td><span class="label"><a href="'.get_app_info('path').'/subscribers?i='.get_app_info('app').'&l='.$lid.'&c=0">'._('Unconfirmed').'</a></span></td>
			                			<td>'.$unconfirmed_delete_btn1.' '.$subscriber_count_1week.'</td>
			                			<td>'.$unconfirmed_delete_btn2.' '.$subscriber_count_2week.'</td>
			                			<td>'.$unconfirmed_delete_btn3.' '.$subscriber_count_2week_more.'</td>
			                			<td>'.$unconfirmed_delete_btn4.' '.$subscriber_count_all.'</td>
			                			<td><a href="'.get_app_info('path').'/includes/subscribers/export-csv.php?i='.get_app_info('app').'&l='.$lid.'&c=0" title="Export all unconfirmed subscribers"><i class="icon icon-download-alt"></i></a></td>
			                			
			                			<script type="text/javascript">
								        $("#delete-btn-'.$lid.'-1week").click(function(e){
									        c = "'._('Confirm permanently remove subscribers?').'"
									        if(confirm(c))
									        {
										        e.preventDefault(); 
										        $("#count-'.$lid.'-1week").html("<img src=\''.get_app_info('path').'/img/'.$loader.'\' style=\'width:16px;\'/>");
												$.post("includes/subscribers/delete-unconfirmed.php", { lid: '.$lid.', action: "1"},
												  function(data) {
												      if(data)
												      {
												      	$("#count-'.$lid.'-1week").text("0");
												      	$("#count-'.$lid.'-all").text(data);
												      	$("#delete-btn-'.$lid.'-1week").remove();
												      	if(data==0) $("#delete-btn-'.$lid.'-all").remove();
												      }
												      else
												      	alert("'._('Sorry, unable to remove subscribers. Please try again later!').'");
												  }
												);
											}
										});
										$("#delete-btn-'.$lid.'-1weekmore").click(function(e){
									        c = "'._('Confirm permanently remove subscribers?').'"
									        if(confirm(c))
									        {
										        e.preventDefault(); 
										        $("#count-'.$lid.'-1weekmore").html("<img src=\''.get_app_info('path').'/img/'.$loader.'\' style=\'width:16px;\'/>");
												$.post("includes/subscribers/delete-unconfirmed.php", { lid: '.$lid.', action: "2"},
												  function(data) {
												      if(data)
												      {
												      	$("#count-'.$lid.'-1weekmore").text("0");
												      	$("#count-'.$lid.'-all").text(data);
												      	$("#delete-btn-'.$lid.'-1weekmore").remove();
												      	if(data==0) $("#delete-btn-'.$lid.'-all").remove();
												      }
												      else
												      	alert("'._('Sorry, unable to remove subscribers. Please try again later!').'");
												  }
												);
											}
										});
										$("#delete-btn-'.$lid.'-2weeks").click(function(e){
									        c = "'._('Confirm permanently remove subscribers?').'"
									        if(confirm(c))
									        {
										        e.preventDefault(); 
										        $("#count-'.$lid.'-2weeks").html("<img src=\''.get_app_info('path').'/img/'.$loader.'\' style=\'width:16px;\'/>");
												$.post("includes/subscribers/delete-unconfirmed.php", { lid: '.$lid.', action: "3"},
												  function(data) {
												      if(data)
												      {
												      	$("#count-'.$lid.'-2weeks").text("0");
												      	$("#count-'.$lid.'-all").text(data);
												      	$("#delete-btn-'.$lid.'-2weeks").remove();
												      	if(data==0) $("#delete-btn-'.$lid.'-all").remove();
												      }
												      else
												      	alert("'._('Sorry, unable to remove subscribers. Please try again later!').'");
												  }
												);
											}
										});
										$("#delete-btn-'.$lid.'-all").click(function(e){
									        c = "'._('Confirm permanently remove subscribers?').'"
									        if(confirm(c))
									        {
										        e.preventDefault(); 
										        $("#count-'.$lid.'-all").html("<img src=\''.get_app_info('path').'/img/'.$loader.'\' style=\'width:16px;\'/>");
												$.post("includes/subscribers/delete-unconfirmed.php", { lid: '.$lid.', action: "0"},
												  function(data) {
												      if(data)
												      {
												      	$("#count-'.$lid.'-all").text("0");
												      	$("#count-'.$lid.'-1week").text("0");
												      	$("#count-'.$lid.'-1weekmore").text("0");
												      	$("#count-'.$lid.'-2weeks").text("0");
												      	$("#delete-btn-'.$lid.'-1week").remove();
												      	$("#delete-btn-'.$lid.'-1weekmore").remove();
												      	$("#delete-btn-'.$lid.'-2weeks").remove();
												      	$("#delete-btn-'.$lid.'-all").remove();
												      }
												      else
												      	alert("'._('Sorry, unable to remove subscribers. Please try again later!').'");
												  }
												);
											}
										});
										</script>
			                			
		                			</tr>
		                			';
		                	    }  
		                	}	
		                	else
		                	{
			                	echo '
			                	<tr>
			                		<td colspan="7">'._('No housekeeping needed as no double opt-in lists are found.').'</td>
			                	</tr>
			                	';
		                	}
	                	?>                
	              </tbody>
	            </table>
	            <?php pagination_housekeeping('unconfirmed', $total_lists, $limit, get_app_info('app'));?>
			</div>
	    </div>
    </div>
</div>

<?php include('includes/footer.php');?>