OXIESEC PANEL

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: subscribers.php

<?php include('includes/header.php');?>
<?php include('includes/login/auth.php');?>
<?php include('includes/subscribers/main.php');?>
<?php include('includes/helpers/short.php');?>
<?php
	//IDs
	$lid = isset($_GET['l']) && is_numeric($_GET['l']) ? mysqli_real_escape_string($mysqli, $_GET['l']) : exit;
			
	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')).'/list?i='.get_app_info('restricted_to_app').'"</script>';
			exit;
		}
		$q = 'SELECT app FROM lists WHERE id = '.$lid;
		$r = mysqli_query($mysqli, $q);
		if ($r)
		{
		    while($row = mysqli_fetch_array($r))
		    {
				$a = $row['app'];
		    }  
		    if($a!=get_app_info('restricted_to_app'))
		    {
			    echo '<script type="text/javascript">window.location="'.addslashes(get_app_info('path')).'/list?i='.get_app_info('restricted_to_app').'"</script>';
				exit;
		    }
		}
	}
	
	//vars
	$s = isset($_GET['s']) ? htmlentities(mysqli_real_escape_string($mysqli, trim($_GET['s']))) : '';
	if(isset($_GET['c'])) $c = is_numeric($_GET['c']) ? $_GET['c'] : exit;
	else $c = '';
	if(isset($_GET['p'])) $p = is_numeric($_GET['p']) ? $_GET['p'] : exit;
	else $p = '';
	if(isset($_GET['a'])) $a = is_numeric($_GET['a']) ? $_GET['a'] : exit;
	else $a = '';
	if(isset($_GET['u'])) $u = is_numeric($_GET['u']) ? $_GET['u'] : exit;
	else $u = '';
	if(isset($_GET['b'])) $b = is_numeric($_GET['b']) ? $_GET['b'] : exit;
	else $b = '';
	if(isset($_GET['cp'])) $cp = is_numeric($_GET['cp']) ? $_GET['cp'] : exit;
	else $cp = '';
	if(isset($_GET['g'])) $g = is_numeric($_GET['g']) ? $_GET['g'] : exit;
	else $g = '';
?>
<link href="<?php echo get_app_info('path');?>/css<?php echo get_app_info('dark_mode') ? '/dark' : '';?>/tablesorter.css?30" rel="stylesheet">
<script type="text/javascript" src="<?php echo get_app_info('path');?>/js/tablesorter/jquery.tablesorter.min.js"></script>
<script type="text/javascript" src="<?php echo get_app_info('path');?>/js/tablesorter/jquery.tablesorter.widgets.min.js"></script>
<script type="text/javascript">
	$(document).ready(function() {
		$('table').tablesorter({
			widgets        : ['saveSort'],
			usNumberFormat : true,
			sortReset      : true,
			sortRestart    : true,
			headers: { 2: { sorter: false}, 4: {sorter: false}, 5: {sorter: false} }	
		});
	});
</script>
<div class="row-fluid">
    <div class="span2">
        <?php include('includes/sidebar.php');?>
    </div> 
    <div class="span10">
    	<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 _('Subscriber lists');?></h2> <br/>

<button class="btn" onclick="window.location='<?php echo get_app_info('path');?>/update-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>'"><i class="icon-plus-sign"></i> <?php echo _('Add subscribers');?></button> 
    	<button class="btn" onclick="window.location='<?php echo get_app_info('path');?>/delete-from-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>'"><i class="icon-minus-sign"></i> <?php echo _('Delete subscribers');?></button> 
    	<button class="btn" onclick="window.location='<?php echo get_app_info('path');?>/unsubscribe-from-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>'"><i class="icon-ban-circle"></i> <?php echo _('Mass unsubscribe');?></button> 
    	<?php 
    		//export according to which section user is on
    		if($a=='' && $c=='' && $u=='' && $b=='' && $cp=='' && $g=='')
    		{
	    		$filter = '';
	    		$filter_val = '';
	    		$export_title = _('all subscribers');
    		}
    		else if($a!='')
    		{
	    		$filter = 'a';
	    		$filter_val = $a;
	    		$export_title = _('active subscribers');
    		}
    		else if($c!='')
    		{
	    		$filter = 'c';
	    		$filter_val = $c;
	    		$export_title = _('unconfirmed subscribers');
    		}  
    		else if($u!='')
    		{
	    		$filter = 'u';
	    		$filter_val = $u;
	    		$export_title = _('unsubscribers');
    		} 
    		else if($b!='')
    		{
	    		$filter = 'b';
	    		$filter_val = $b;
	    		$export_title = _('bounced subscribers');
    		}
    		else if($cp!='')
    		{
	    		$filter = 'cp';
	    		$filter_val = $cp;
	    		$export_title = _('subscribers who marked your email as spam');
    		}  
    		else if($g!='')
    		{
	    		$filter = 'g';
	    		$filter_val = $g;
	    		$export_title = _('GDPR subscribers');
    		}     	
    	?>
    	<button class="btn" onclick="window.location='<?php echo get_app_info('path');?>/includes/subscribers/export-csv.php?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>&<?php echo $filter.'='.$filter_val;?>'"><i class="icon-download-alt"></i> <?php echo _('Export').' '.$export_title;?></button>
		
		<form class="form-search" action="<?php echo get_app_info('path');?>/subscribers" method="GET" style="float:right;">
    		<input type="hidden" name="i" value="<?php echo get_app_info('app');?>">
    		<input type="hidden" name="l" value="<?php echo $lid;?>">
    		<?php if($a!=''):?>
    		<input type="hidden" name="a" value="<?php echo $a;?>">
    		<?php elseif($c!=''):?>
    		<input type="hidden" name="c" value="<?php echo $c;?>">
    		<?php elseif($u!=''):?>
    		<input type="hidden" name="u" value="<?php echo $u;?>">
    		<?php elseif($b!=''):?>
    		<input type="hidden" name="b" value="<?php echo $b;?>">
    		<?php elseif($cp!=''):?>
    		<input type="hidden" name="cp" value="<?php echo $cp;?>">
    		<?php elseif($g!=''):?>
    		<input type="hidden" name="g" value="<?php echo $g;?>">
    		<?php endif;?>
			<input type="text" class="input-medium search-query" name="s">
			<button type="submit" class="btn"><i class="icon-search"></i> <?php echo _('Search');?></button>
		</form>
    	
    	<br/><br/>
    	<p class="well"><?php echo _('List');?>: <a href="<?php echo get_app_info('path');?>/subscribers?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>" title=""><span class="label label-info"><?php echo get_lists_data('name', $lid);?></span></a> | <a href="<?php echo get_app_info('path')?>/list?i=<?php echo get_app_info('app');?>" title=""><?php echo _('Back to lists');?></a>
    	<a href="<?php echo get_app_info('path');?>/edit-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>" style="float:right;"><i class="icon-wrench"></i> <?php echo _('List settings');?></a>
    	<a href="#subscribeform" style="float:right;margin-right:20px;" data-toggle="modal"><i class="icon-list-alt"></i> <?php echo _('Subscribe form');?></a>
    	
    	
    	<span class="badge" style="float:right;margin:0 20px 0 -15px;"><?php echo get_segments_count();?></span>
    	<a href="<?php echo get_app_info('path');?>/segments-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>" style="float:right;margin-right:20px;"><i class="icon-filter"></i> <?php echo _('Segments');?></a>
    	
    	<?php 
	    	$q = 'SELECT cron_ares FROM login WHERE id = '.get_app_info('main_userID');
	    	$r = mysqli_query($mysqli, $q);
	    	if ($r)
	    	{
	    	    while($row = mysqli_fetch_array($r)) 
	    	    	$cron_ares = $row['cron_ares'];
	    	}	    	
	    	if($cron_ares):
    	?>    	
    	<span class="badge" style="float:right;margin:0 20px 0 -15px;"><?php echo get_autoresponder_count();?></span>
    	<a href="<?php echo get_app_info('path');?>/autoresponders-list?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>" style="float:right;margin-right:20px;"><i class="icon-time"></i> <?php echo _('Autoresponders');?></a>
    	<?php else:?>
    	<a href="#ares_cron" style="float:right;margin-right:20px;" data-toggle="modal"><i class="icon-time"></i> <?php echo _('Autoresponders');?></a>
    	<?php endif;?>
    	<span class="badge" style="float:right;margin:0 20px 0 -15px;"><?php echo get_custom_fields_count();?></span>
    	<a href="<?php echo get_app_info('path');?>/custom-fields?i=<?php echo get_app_info('app');?>&l=<?php echo $lid;?>" style="float:right;margin-right:20px;"><i class="icon-list"></i> <?php echo _('Custom fields');?></a>
    	</p><br/>
    	
    	<?php 
	    	//Get gdpr_options
			$q = 'SELECT gdpr_options, custom_domain, custom_domain_protocol, custom_domain_enabled FROM apps WHERE id = '.get_app_info('app');
			$r = mysqli_query($mysqli, $q);
			if ($r) 
			{
				while($row = mysqli_fetch_array($r)) 
				{
					$gdpr_options = $row['gdpr_options'];
					$custom_domain = $row['custom_domain'];
					$custom_domain_protocol = $row['custom_domain_protocol'];
					$custom_domain_enabled = $row['custom_domain_enabled'];
					if($custom_domain!='' && $custom_domain_enabled)
					{
						$parse = parse_url(get_app_info('path'));
						$domain = $parse['host'];
						$protocol = $parse['scheme'];
						$app_path = str_replace($domain, $custom_domain, get_app_info('path'));
						$app_path = str_replace($protocol, $custom_domain_protocol, $app_path);
					}
					else $app_path = get_app_info('path');
				}
			}
    	?>
    	
    	<div id="subscribeform" class="modal hide fade" style="width: <?php echo $gdpr_options ? '900' : '516';?>px; margin-left: <?php echo $gdpr_options ? '-450' : '-258';?>px;">
            <div class="modal-header">
              <button type="button" class="close" data-dismiss="modal">&times;</button>
              <h3><span class="icon icon-list-alt"></span> <?php echo _('Subscribe form');?></h3>
            </div>
            <div class="modal-body">
	        
	        <div class="subscribeform-left">
		    <p><strong><?php echo _('Ready-to-use subscribe form');?></strong></p>
	        <p><?php echo _('The following is a \'ready-to-use\' subscription form URL you can immediately use to collect sign ups to this list');?>:</p>
	        
	        <?php 
		        if(version_compare(PHP_VERSION, '5.3.0') >= 0 && function_exists('openssl_encrypt'))
			        $subscription_form_url = $app_path.'/subscription?f='.encrypt_val('{"brand":"'.get_app_info('app').'", "list":"'.encrypt_val($lid).'"}');
		        else
			        $subscription_form_url = $app_path.'/subscription?i='.get_app_info('app').'&l='.encrypt_val($lid);
		    ?>
		        <pre id="form-url"><?php echo $subscription_form_url;?></pre>
	        <br/>
	        
	        <p><strong>Subscribe form HTML code</strong></p>
            <p><?php echo _('The following is an embeddable subscribe form HTML code for this list');?>.</p>
            
            <?php 
	            $q = 'SELECT gdpr_enabled, marketing_permission, what_to_expect FROM lists WHERE id = '.$lid;
				$r = mysqli_query($mysqli, $q);
				if ($r)
				{
				    while($row = mysqli_fetch_array($r))
				    {
						$gdpr_enabled = $row['gdpr_enabled'];
						$marketing_permission = $row['marketing_permission'];
						$what_to_expect = $row['what_to_expect'];
				    } 
				}
            ?>
            
<pre id="form-code"></pre>

</div>
            <div class="modal-footer">
              <a href="#" class="btn btn-inverse" data-dismiss="modal"><i class="icon icon-ok-sign"></i> <?php echo _('Okay');?></a>
            </div>
          </div>
		
		<?php if($s!=''):?>
		<p><?php echo _('Keyword');?>: <span class="label"><?php echo $s;?></span></p><br/>
		<?php endif;?>
		
		<?php 
		    //Get subscriber numbers for each tab
		    $subs_all = get_totals('', '');
		    $subs_active = get_totals('a', '');
		    $subs_gdpr = get_totals('gdpr', 1);
		    $subs_unconfirmed = get_totals('confirmed', 0);
		    $subs_unsubscribed = get_totals('unsubscribed', 1);
		    $subs_bounced = get_totals('bounced', 1);
		    $subs_complaint = get_totals('complaint', 1);
	    ?>
		
		<div class="row-fluid">
			<div class="span3">
				<div id="container2"></div>
	    	</div>
    		<div class="span9">
	    		<div style="margin: -20px 0px 20px 0px; color: #666666;"><?php echo _('Subscribers activity chart');?> <a href="#last-activity-info" data-toggle="modal" class="last-activity-info" title="<?php echo _('Click to learn more');?>"><i class="icon icon-question-sign" style="color: #666666;"></i></a></div>
		    	<div id="container" style="min-height:200px;margin:0 0 30px 0;"></div>
	    	</div>
	    </div>
	    
	    <?php 
    		//Count number of emails skipped during last import
    		$q = 'SELECT COUNT(*) FROM skipped_emails WHERE list = '.$lid;
    		$r = mysqli_query($mysqli, $q);
    		if ($r) while($row = mysqli_fetch_array($r)) $no_of_skipped_emails = $row['COUNT(*)'];
    		if($no_of_skipped_emails!=0):
		?>
	    <div class="row-fluid" id="skipped-emails">
    		<div class="span12">
	    		<div class="alert">
		    		<span>
			    		<span class="icon icon-info-sign"></span> <?php echo $no_of_skipped_emails;?> <?php echo _('emails were skipped from your last import');?>. <?php echo _('To see the list and reasons, export the CSV.');?> <a href="<?php echo get_app_info('path');?>/includes/list/export-skipped-emails.php?l=<?php echo $lid;?>" title="<?php echo _('Export skipped email addresses from your last import');?>"><span class="icon icon-download-alt"></span></a> 
		    		</span>
		    		<span style="float:right;">
			    		<a href="javascript:void(0)" id="dismiss" title="<?php echo _('Dismiss this notice (CSV will no longer be available for download)');?>"><?php echo _('Dismiss');?> <span class="icon icon-remove"></span></a>
		    		</span>
		    		<script type="text/javascript">
			    		$(document).ready(function() {
				    		$("#dismiss").click(function(){
					    		$.post("<?php echo get_app_info('path');?>/includes/list/dismiss.php", { l: <?php echo $lid;?> },
			    				  function(data) {
			    				      if(data) $("#skipped-emails").fadeOut();
			    				      else alert("Sorry, unable to dismiss. Please try again later!");
			    				  }
			    				);
				    		});
			    		});
		    		</script>
	    		</div>
    		</div>
	    </div>
	    <?php endif;?>
	    
	    <div class="row-fluid">
		    <div class="span12">				
				<ul class="nav nav-tabs">
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>" id="all"><?php echo _('All');?> <span class="badge badge-info"><?php echo $subs_all;?></span></a></li>
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&a=1" id="active"><?php echo _('Active');?> <span class="badge badge-success"><?php echo $subs_active;?></span></a></li>
				  
				  <?php if(get_totals('gdpr', 1)!=0): //Show GDPR tab only when there are GDPR subscribers?>
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&g=1" id="gdpr"><?php echo _('GDPR');?> <span class="badge badge-warning"><?php echo $subs_gdpr;?></span></a></li>
				  <?php endif;?>
					  
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&c=0" id="unconfirmed"><?php echo _('Unconfirmed');?> <span class="badge"><?php echo $subs_unconfirmed;?></span></a></li>
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&u=1" id="unsubscribed"><?php echo _('Unsubscribed');?> <span class="badge badge-important"><?php echo $subs_unsubscribed;?></span></a></li>
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&b=1" id="bounced"><?php echo _('Bounced');?> <span class="badge badge-inverse"><?php echo $subs_bounced;?></span></a></li>
				  <li><a href="<?php echo get_app_info('path')?>/subscribers?i=<?php echo get_app_info('app')?>&l=<?php echo $lid?>&cp=1" id="complaint"><?php echo _('Marked as spam');?> <span class="badge badge-inverse"><?php echo $subs_complaint;?></span></a></li>
				</ul>
		    </div>
	    </div>
	    <script type="text/javascript">
			$(document).ready(function() {
				<?php if($a=='' && $c=='' && $u=='' && $b=='' && $cp=='' && $g==''):?>
				$("#all").addClass("tab-active");
				<?php elseif($a!=''):?>
				$("#active").addClass("tab-active");
				<?php elseif($c!=''):?>
				$("#unconfirmed").addClass("tab-active");
				<?php elseif($u!=''):?>
				$("#unsubscribed").addClass("tab-active");
				<?php elseif($b!=''):?>
				$("#bounced").addClass("tab-active");
				<?php elseif($cp!=''):?>
				$("#complaint").addClass("tab-active");
				<?php elseif($g!=''):?>
				$("#gdpr").addClass("tab-active");
				<?php endif;?>
				
				$("#single").click(function(){
					$("#opt_in").val("0");
				});
				$("#double").click(function(){
					$("#opt_in").val("1");
				});
			});
		</script>
		
	    <table class="table table-striped table-condensed responsive">
		  <thead>
		    <tr>
		      <th><?php echo _('Name');?></th>
		      <th><?php echo _('Email');?></th>
		      <th><?php echo _('Last activity');?> <a href="#last-activity-info" data-toggle="modal" class="last-activity-info"><i class="icon icon-question-sign"></i></a></th>
		      <th><?php echo _('Status');?></th>
		      <th><?php echo _('Unsubscribe');?></th>
		      <th><?php echo _('Delete');?></th>
		    </tr>
		  </thead>
		  <tbody>
		  	
		  	<?php 	  			
		  		$limit = 20;
				$total_subs = totals($lid);
				$total_pages = ceil($total_subs/$limit);
				$offset = $p!=null ? ($p-1) * $limit : 0;
		  		
		  		$search_line = $s=='' ? '' : 'AND (name LIKE "%'.$s.'%" OR email LIKE "%'.$s.'%" OR custom_fields LIKE "%'.$s.'%" OR notes LIKE "%'.$s.'%")';
		  		
		  		if($a=='' && $c=='' && $u=='' && $b=='' && $cp=='' && $g=='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($a!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND confirmed = 1 AND unsubscribed = 0 AND bounced = 0 AND complaint = 0 '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($c!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND confirmed = '.$c.' AND bounced = 0 AND complaint = 0 '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($u!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND unsubscribed = '.$u.' AND bounced = 0 '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($b!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND bounced = '.$b.' '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($cp!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND complaint = '.$cp.' '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
				else if($g!='')
					$q = 'SELECT * FROM subscribers WHERE list = '.mysqli_real_escape_string($mysqli, $lid).' AND unsubscribed = 0 AND bounced = 0 AND complaint = 0 AND confirmed = 1 AND gdpr = '.$g.' '.$search_line.' ORDER BY timestamp DESC LIMIT '.$offset.','.$limit;
			  	$r = mysqli_query($mysqli, $q);
			  	if ($r && mysqli_num_rows($r) > 0)
			  	{
			  	    while($row = mysqli_fetch_array($r))
			  	    {
			  			$id = $row['id'];
			  			$name = stripslashes($row['name']);
			  			$email = stripslashes($row['email']);
			  			$unsubscribed = $row['unsubscribed'];
			  			$bounced = $row['bounced'];
			  			$complaint = $row['complaint'];
			  			$confirmed = $row['confirmed'];
			  			$timestamp = parse_date($row['timestamp'], 'short', true);
			  			if($unsubscribed==0)
			  				$unsubscribed = '<span class="label label-success">'._('Subscribed').'</span>';
			  			else if($unsubscribed==1)
			  				$unsubscribed = '<span class="label label-important">'._('Unsubscribed').'</span>';
			  			if($bounced==1)
				  			$unsubscribed = '<span class="label label-inverse">'._('Bounced').'</span>';
				  		if($complaint==1)
				  			$unsubscribed = '<span class="label label-inverse">'._('Marked as spam').'</span>';
				  		if($confirmed==0)
			  				$unsubscribed = '<span class="label">'._('Unconfirmed').'</span>';
			  			if($confirmed==0 && $bounced==1)
			  				$unsubscribed = '<span class="label label-inverse">'._('Bounced').'</span>';
			  			if($confirmed==0 && $complaint==1)
			  				$unsubscribed = '<span class="label label-inverse">'._('Marked as spam').'</span>';
				  			
				  		if($name=='')
				  			$name = '['._('No name').']';
			  			
			  			echo '
			  			
			  			<tr id="'.$id.'">
			  			  <td><a href="#subscriber-info" data-id="'.$id.'" data-toggle="modal" class="subscriber-info">'.$name.'</a></td>
					      <td><a href="#subscriber-info" data-id="'.$id.'" data-toggle="modal" class="subscriber-info">'.$email.'</a></td>
					      <td>'.$timestamp.'</td>
					      <td id="unsubscribe-label-'.$id.'">'.$unsubscribed.'</td>
					      <td>
					    ';
					    
					    if($row['unsubscribed']==0)
							$action_icon = '
								<a href="javascript:void(0)" title="'._('Unsubscribe').' '.$email.'" data-action'.$id.'="unsubscribe" id="unsubscribe-btn-'.$id.'">
									<i class="icon icon-ban-circle"></i>
								</a>
								';
						else if($row['unsubscribed']==1)
							$action_icon = '
								<a href="javascript:void(0)" title="'._('Resubscribe').' '.$email.'" data-action'.$id.'="resubscribe" id="unsubscribe-btn-'.$id.'">
									<i class="icon icon-ok"></i>
								</a>
							';
						if($row['bounced']==1 || $row['complaint']==1)
							$action_icon = '
								-
							';
						if($row['confirmed']==0 && $row['bounced']==0 && $row['complaint']==0)
							$action_icon = '
								<a href="javascript:void(0)" title="'._('Confirm').' '.$email.'" data-action'.$id.'="confirm" id="unsubscribe-btn-'.$id.'">
									<i class="icon icon-ok"></i>
								</a>
							';
						
						echo $action_icon;
					    
					    echo'
					      </td>
					      <td><a href="#delete-subscriber" title="'._('Delete').' '.$email.'?" data-toggle="modal" id="delete-btn-'.$id.'" class="delete-subscriber"><i class="icon icon-trash"></i></a></td>
					      <script type="text/javascript">
					        $("#delete-btn-'.$id.'").click(function(e){
								e.preventDefault(); 
								$("#delete-subscriber-1, #delete-subscriber-2").attr("data-id", '.$id.');
								$("#email-to-delete").text("'.$email.'");
							});
							$("#unsubscribe-btn-'.$id.'").click(function(e){
								e.preventDefault(); 
								action = $("#unsubscribe-btn-'.$id.'").data("action'.$id.'");
								$.post("includes/subscribers/unsubscribe.php", { subscriber_id: '.$id.', action: action},
								  function(data) {
								      if(data)
								      {
								      	if($("#unsubscribe-label-'.$id.'").text()=="'._('Subscribed').'")
								      	{
								      		$("#unsubscribe-btn-'.$id.'").html("<li class=\'icon icon-ok\'></li>");
								      		$("#unsubscribe-btn-'.$id.'").data("action'.$id.'", "resubscribe");
									      	$("#unsubscribe-label-'.$id.'").html("<span class=\'label label-important\'>'._('Unsubscribed').'</span>");
									    }
									    else
									    {
									    	$("#unsubscribe-btn-'.$id.'").html("<li class=\'icon icon-ban-circle\'></li>");
								      		$("#unsubscribe-btn-'.$id.'").data("action'.$id.'", "unsubscribe");
									      	$("#unsubscribe-label-'.$id.'").html("<span class=\'label label-success\'>'._('Subscribed').'</span>");
									    }
									    if($("#unsubscribe-label-'.$id.'").text()=="'._('Unconfirmed').'")
									    {
									    	$("#unsubscribe-btn-'.$id.'").html("<li class=\'icon icon-ban-circle\'></li>");
								      		$("#unsubscribe-btn-'.$id.'").data("action'.$id.'", "confirm");
									      	$("#unsubscribe-label-'.$id.'").html("<span class=\'label label-success\'>'._('Subscribed').'</span>");
									    }
								      }
								      else
								      {
								      	alert("'._('Sorry, unable to unsubscribe. Please try again later!').'");
								      }
								  }
								);
							});
							</script>
					    </tr>
						
			  			';
			  	    }  
			  	}
			  	else
			  	{
			  		echo '
			  			<tr>
			  				<td>'._('No subscribers found.').'</td>
			  				<td></td>
			  				<td></td>
			  				<td></td>
			  				<td></td>
			  				<td></td>
			  			</tr>
			  		';
			  	}
		  	?>
		    
		  </tbody>
		</table>
		<?php pagination($limit);?>
    </div>   
</div>

<div id="delete-subscriber" class="modal hide fade">
  <div class="modal-header">
    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
    <h3><?php echo _('Delete subscriber');?></h3>
  </div>
  <div class="modal-body">
    <p><?php echo _('Delete <span id="email-to-delete" style="font-weight:bold;"></span> from \'this list only\' or \'ALL lists\' in this brand?');?></p>
  </div>
  <div class="modal-footer">
    <a href="javascript:void(0)" id="delete-subscriber-1" data-id="" class="btn"><?php echo _('This list only');?></a>
    <a href="javascript:void(0)" id="delete-subscriber-2" data-id="" class="btn btn-primary"><?php echo _('ALL lists in this brand');?></a>
  </div>
</div>

<div id="subscriber-info" class="modal hide fade">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal">&times;</button>
      <h3><?php echo _('Subscriber info');?></h3>
    </div>
    <div class="modal-body">
	    <p id="subscriber-text"></p>
    </div>
    <div class="modal-footer">
      <a href="#" class="btn btn-inverse" data-dismiss="modal"><i class="icon icon-ok-sign" style="margin-top: 5px;"></i> <?php echo _('Close');?></a>
    </div>
  </div>
<script type="text/javascript">
	$("#delete-subscriber-1").click(function(e){
		e.preventDefault(); 
		$.post("includes/subscribers/delete.php", { subscriber_id: $(this).attr("data-id"), option: 1, app: <?php echo get_app_info('app')?> },
		  function(data) {
		      if(data) 
		      {
			      $("#delete-subscriber").modal('hide');
			      $("#"+$("#delete-subscriber-1").attr("data-id")).fadeOut(); 
			  }
		      else alert("<?php echo _('Sorry, unable to delete. Please try again later!')?>");
		  }
		);
	});
	$("#delete-subscriber-2").click(function(e){
		e.preventDefault(); 
		$.post("includes/subscribers/delete.php", { subscriber_id: $(this).attr("data-id"), option: 2, app: <?php echo get_app_info('app')?> },
		  function(data) {
		      if(data) 
		      {
			      $("#delete-subscriber").modal('hide');
			      $("#"+$("#delete-subscriber-2").attr("data-id")).fadeOut(); 
			  }
		      else alert("<?php echo _('Sorry, unable to delete. Please try again later!')?>");
		  }
		);
	});
	$(".subscriber-info").click(function(){
		s_id = $(this).data("id");
		$("#subscriber-text").html("<?php echo _('Fetching');?>..");
		
		$.post("<?php echo get_app_info('path');?>/includes/subscribers/subscriber-info.php", { id: s_id, app:<?php echo get_app_info('app');?> },
		  function(data) {
		      if(data)
		      {
		      	$("#subscriber-text").html(data);
		      }
		      else
		      {
		      	$("#subscriber-text").html("<?php echo _('Oops, there was an error getting the subscriber\'s info. Please try again later.');?>");
		      }
		  }
		);
	});
</script>

<div id="last-activity-info" class="modal hide fade">
<div class="modal-header">
  <button type="button" class="close" data-dismiss="modal">&times;</button>
  <h3><?php echo _('What changes a subscriber\'s \'Last activity\' timestamp?');?></h3>
</div>
<div class="modal-body">
    <p><?php echo _('A subscriber\'s \'Last activity\' timestamp is updated when the user:');?></p>
	    <pre><?php echo _('• opened a campaign or autoresponder
• clicked a link in a campaign or autoresponder
• subscribed to a list
• unsubscribed from a list
• bounced
• marked as spam
• confirmed a double opt-in subscription');?></pre>
	</p>
	<p><?php echo _('Subscribers are sorted by \'Last activity\' in the list. Therefore, subscribers who did any of the above activity will float to the top of the subscriber list. You will also see changes in the \'Subscribers activity chart\'.');?></p>
</div>
<div class="modal-footer">
  <a href="#" class="btn btn-inverse" data-dismiss="modal"><i class="icon icon-ok-sign" style="margin-top: 5px;"></i> <?php echo _('Close');?></a>
</div>
</div>

<?php 
	if(!$cron_ares):
	$server_path_array = explode('subscribers.php', $_SERVER['SCRIPT_FILENAME']);
    $server_path = $server_path_array[0];
?>

<div id="ares_cron" class="modal hide fade">
<div class="modal-header">
  <button type="button" class="close" data-dismiss="modal">&times;</button>
  <h3><i class="icon icon-time" style="margin-top: 5px;"></i> <?php echo _('Add a cron job');?></h3>
</div>
<div class="modal-body">
<p><?php echo _('To activate autoresponders, add a');?> <a href="http://en.wikipedia.org/wiki/Cron" target="_blank" style="text-decoration:underline"><?php echo _('cron job');?></a> <?php echo _('with the following command.');?></p>
<h3><?php echo _('Time Interval');?></h3>
<pre id="command">*/1 * * * * </pre>
<h3><?php echo _('Command');?></h3>
<pre id="command">php <?php echo $server_path;?>autoresponders.php > /dev/null 2>&amp;1</pre>
<p><?php echo _('This command needs to be run every minute in order to check the database for any autoresponder emails to send.');?> <br/><em>(<?php echo _('Note that adding cron jobs vary from hosts to hosts, most offer a UI to add a cron job easily. Check your hosting control panel or consult your host if unsure.');?>)</em>.</p>
<p><?php echo _('Once added, wait one minute. If your cron job is functioning correctly, you\'ll see the autoresponder options instead of this modal window when you click on the "Autoresponders" button.');?></p>
</div>
<div class="modal-footer">
  <a href="#" class="btn btn-inverse" data-dismiss="modal"><i class="icon icon-ok-sign"></i> <?php echo _('Okay');?></a>
</div>
</div>
<script type="text/javascript">
	$(document).ready(function() {
		$("#command, #cronjob").click(function(){
			$(this).selectText();
		});
	});
</script>
<?php endif;?>

var chart;
	var chart2;
	$(document).ready(function() {
		
		<?php 
			$bounced_complaint_color = get_app_info('dark_mode') ? '#ececec' : '#333333';
			$unconfirmed_color = get_app_info('dark_mode') ? '#404040' : '#f5f5f5';
		?>
		
		Highcharts.setOptions({
	        colors: ['<?php echo $subs_all==0 ? '#e3e5e7' : '#52C162';?>', '<?php echo $unconfirmed_color;?>', '#DF5352', '<?php echo $bounced_complaint_color;?>', '<?php echo $bounced_complaint_color;?>']
	    });
				
		chart2 = new Highcharts.Chart({
			chart: {
				renderTo: 'container2',
				plotBackgroundColor: null,
				plotBorderWidth: null,
				plotShadow: false,
				height: 210
			},
			title: {
				text: ''
			},
			tooltip: {
				formatter: function() {
					return '<b>'+ this.point.name +'</b>: '+Math.round(this.percentage) +' %';
				}
			},
			plotOptions: {
				pie: {
					size: 180,
					borderWidth: 0,
					shadow: false,
					allowPointSelect: true,
					cursor: 'pointer',
					dataLabels: {
						enabled: false
					},
					showInLegend: false
				}
			},
			credits: {
                enabled: false
            },
			series: [{
				dataLabels: {
		            style:{
		                fontWeight: 'normal',
		                textOutline: '0px',
		                color: "#797979"
		            }
		        },
				type: 'pie',
				name: 'Countries',
				data: [
					<?php 
						$ct = 0;
						if($subs_all==0)
						{
							echo '
				  			[\'No subscribers yet\',   100],
				  			';
						}
						else
						{
							echo '
								{
									name: "'._('Active').'",
									y: '.str_replace( ',', '', $subs_active).',
									sliced: true,
									selected: true
								},
					  			["Unconfirmed",   '.str_replace( ',', '', $subs_unconfirmed).'],
					  			["Unsubscribed",   '.str_replace( ',', '', $subs_unsubscribed).'],
					  			["Bounced",   '.str_replace( ',', '', $subs_bounced).'],
					  			["Marked as spam",   '.str_replace( ',', '', $subs_complaint).']
							';
					  	}
					?>
				]
			}],
			exporting: { enabled: false }
		});
		
		Highcharts.setOptions({
	        colors: ['#579fc8', '#ce5c56', '#333333']
	    });
		chart = new Highcharts.Chart({
			chart: {
				renderTo: 'container',
				type: 'areaspline',
				marginBottom: 25
			},
			title: {
				text: ''
			},
			subtitle: {
				text: ''
			},
			xAxis: {
				categories: [
				<?php 
					$month_array = array();
					$year_array = array();
					$q = 'SELECT MAX(timestamp) FROM subscribers use index (s_list) WHERE list = '.$lid;
					$r = mysqli_query($mysqli, $q);
					if ($r && mysqli_num_rows($r) > 0)
					{
					    while($row = mysqli_fetch_array($r))
					    {
					    	$month_max = $row['MAX(timestamp)'];
					    	
					    	if($month_max=='')
						    	$month_max = time();
						    	
					    	$month = strftime('%m', $month_max)-1;
							$year = strftime('%y', $month_max);
					    }  
					}
					
					for($i=0;$i<12;$i++)
					{
						array_push($month_array, $month);
						array_push($year_array, $year);
						$month--;
						if($month<0)
						{
							$month = 11;
							$year--;
						}
					}
					
					$month_array = array_reverse($month_array);
					$year_array = array_reverse($year_array);
					
					for($i=0;$i<12;$i++)
					{
						echo 'month['.$month_array[$i].']'.'+" '.$year_array[$i].'"';
						if($i<11)
							echo ',';
					}
				?>
				]
			},
			yAxis: {
				title: {
					text: false
				},
				plotLines: [{
					value: 0,
					width: 1,
					color: '#808080'
				}]
			},
			plotOptions: {
				line: {
					stacking: 'normal'
				},
				series: {
	                marker: {
	                    enabled: false
	                }
	            }
			},
			tooltip: {
				formatter: function() {
						return '<b>'+ this.series.name +'</b><br/>'+
						this.x +': '+ this.y;
				}
			},
			legend: {
				enabled: false
			},
			credits: {
                enabled: false
            },
			series: [{
                name: 'Subscribers',
                data: [
                <?php 
/*
                	$graph_array = array();
                	$onemonth = 2629746;
                	$maxmonth = $month_max;
	                for($i=0;$i<12;$i++)
	                {
		                $q = 'SELECT timestamp FROM subscribers WHERE timestamp <= '.$maxmonth.' AND list = '.$lid.' AND unsubscribed=0 AND bounced = 0 AND complaint = 0 AND confirmed = 1';
		                $r = mysqli_query($mysqli, $q);
		                if ($r && mysqli_num_rows($r) > 0)
		                {
		                    array_push($graph_array, mysqli_num_rows($r));
		                }
		                else
		                	array_push($graph_array, '0');
		                
		                $maxmonth = $maxmonth - $onemonth;
	                }
	                
	                $graph_array = array_reverse($graph_array);
	                
	                for($i=0;$i<12;$i++)
	                {
		                echo $graph_array[$i];
		                
		                if($i<11)
							echo ',';
	                }
*/
					//Contributed by Rob Henley
					$zeros = '0,0,0,0,0,0,0,0,0,0,0,0';
					
					$q = 'SELECT SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 11 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 10 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 9 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 8 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 7 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 6 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 5 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 4 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 3 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 2 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW() - INTERVAL 1 MONTH), 1, 0 ) ),
						SUM( IF( s.timestamp <= UNIX_TIMESTAMP(NOW()), 1, 0 ) )

FROM subscribers s use index (s_list) WHERE list = '.intval($lid).' AND unsubscribed=0 AND bounced = 0 AND complaint = 0 AND confirmed = 1';
						
			            $r = mysqli_query($mysqli, $q);
	 				if ($r && mysqli_num_rows($r)  > 0)
	 				{
	 				    $graph = implode(",", mysqli_fetch_array($r, MYSQLI_NUM));
	 				    echo trim($graph)==',,,,,,,,,,,' ? $zeros : $graph;
	 				}
	 				else 
	 				{
	 					echo $zeros;
	 				}
	                
                ?>
                ]
            }]
		});
	});
</script>

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