OXIESEC PANEL

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

Editing: autoresponders-list.php

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

<?php 
	//IDs
	$lid = isset($_GET['l']) && is_numeric($_GET['l']) ? mysqli_real_escape_string($mysqli, (int)$_GET['l']) : exit;
	$app = isset($_GET['i']) && is_numeric($_GET['i']) ? get_app_info('app') : 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')).'/autoresponders-list?i='.get_app_info('restricted_to_app').'&l='.$lid.'"</script>';
			exit;
		}
	}
	
	if(isset($_GET['e'])) $err = $_GET['e'];
	else $err = '';
?>

<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 _('Autoresponders');?></h2>
				<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>
		    	</p><br/>
	    	</div>
	    </div>
	    
	    <?php if($err==1):?>
	    <div class="alert alert-danger"><?php echo _('You can\'t create an autoresponder based on a custom field already in use by another autoresponder.');?></div>
	    <?php endif;?>
	    
		<?php 
	      //check if drip campaign has been created
	  	  $all_used = 0;
		  $q = 'SELECT type FROM ares WHERE list = '.$lid.' AND type = 1';
		  if(mysqli_num_rows(mysqli_query($mysqli, $q)) > 0)
		  	$all_used++;
		  	
		  //check if custom fields has been used up
		  $inuse = 0;
  		  $total_dates = 0;
		  $q = 'SELECT custom_fields FROM lists WHERE id = '.$lid;
		  $r = mysqli_query($mysqli, $q);
		  if (mysqli_num_rows($r) > 0)
		  {
			  while($row = mysqli_fetch_array($r)) $list_custom_fields = stripslashes($row['custom_fields']);
			  $list_custom_fields_array = explode('%s%', $list_custom_fields);
			    foreach($list_custom_fields_array as $cf)
			    {
					  $cf_array = explode(':', $cf);
					  if($cf_array[1]=='Date')
					  {
						  $total_dates++;
						  //check if custom field has been used in any autoresponders before
						  $q2 = 'SELECT custom_field FROM ares WHERE custom_field = "'.$cf_array[0].'" AND list = '.$lid;
						  $r2 = mysqli_query($mysqli, $q2);
						  if (mysqli_num_rows($r2) > 0)
							  $inuse++;
					  }
			    }
		  }
		  //if all custom fields has been used up
		  if($inuse == $total_dates)
			  $all_used++;
	    ?>
	    
	    <?php if($all_used != 2): //if not all autoresponders have been created ?>
	    
	    <p><a href="javascript:void(0)" id="new-autoresponder-btn" class="btn btn-inverse btn-large"><i class="icon-plus icon-white"></i> <?php echo _('Create a new autoresponder');?></a></p>
	    
	    <?php else: ?>
				  
	    <div class="alert alert-info">
		    <h3><i class="icon icon-info-sign"></i> <?php echo _('All types of autoresponders have been created');?></h3><br/>
		    <ul>
			    <li><?php echo _('You can create more emails in each type of autoresponder that you have previously created below.');?></li>
			    <li><?php echo _('To create more \'Send annually\' and \'Send on date\' autoresponders, add more \'Date based\' custom fields to this list.');?></li>
			</ul>
		</div>
				  
	    <?php endif;?>
	    
	    <div class="row-fluid" id="autoresponder-form">
	    	<div class="span12 well">
				<form method="POST" action="<?php echo get_app_info('path');?>/includes/ares/add-autoresponder.php" id="add-autoresponder-form">
				  <h3><i class="icon icon-plus" style="margin-top: 4px;"></i> <?php echo _('Create a new autoresponder');?></h3><hr/>
				  
				  <?php if($all_used != 2): //if not all autoresponders have been created ?>
				  
				  <div class="row-fluid">
					  <div class="span3">
						  <label for="autoresponder_name"><?php echo _('Autoresponder name');?></label>
						  <input type="text" name="autoresponder_name" id="autoresponder_name" placeholder="Name" style="width: 98%;">
						  <br/><br/>
					  </div>
					  <div class="span9">
						  <p><?php echo _('Autoresponder type');?></p>
						  <?php 
						  	  $drip_created = false;
							  $q = 'SELECT type FROM ares WHERE list = '.$lid.' AND type = 1';
							  if(mysqli_num_rows(mysqli_query($mysqli, $q)) == 0):
						  ?>
						  
						  <label class="radio">
						  	<input type="radio" name="autoresponder_type" id="autoresponder_type1" value="1" checked>
						  	<strong><?php echo _('Drip campaign');?></strong><br/>
						  	<?php echo _('Create a sequence of emails that automatically sends to subscribers after they sign up.');?> 
						  </label><br/>
						  
						  <?php else:
							  $drip_created = true;
						  ?>
						  
						  <div class="alert alert-info"><?php echo _('A drip campaign autoresponder has already been created. You cannot create another drip campaign but you can add more emails to the sequence.');?></div>
						  
						  <?php endif;?>
						  
						  <?php 
						  		$inuse = 0;
						  		$total_dates = 0;
								$q = 'SELECT custom_fields FROM lists WHERE id = '.$lid;
								$r = mysqli_query($mysqli, $q);
								if (mysqli_num_rows($r) > 0)
								{
									while($row = mysqli_fetch_array($r)) $list_custom_fields = stripslashes($row['custom_fields']);
									$list_custom_fields_array = explode('%s%', $list_custom_fields);
									  foreach($list_custom_fields_array as $cf)
									  {
											$cf_array = explode(':', $cf);
											if($cf_array[1]=='Date')
											{
												$total_dates++;
												//check if custom field has been used in any autoresponders before
												$q2 = 'SELECT custom_field FROM ares WHERE custom_field = "'.$cf_array[0].'" AND list = '.$lid;
												$r2 = mysqli_query($mysqli, $q2);
												if (mysqli_num_rows($r2) > 0)
													$inuse++;
											}
									  }
								}
								//if all custom fields has been used up
								if($inuse == $total_dates):
						  ?>
						  
						  <div class="alert alert-info"><?php echo _('There are no available \'date based custom fields\' to create anniversary or date based autoresponders.');?></div>
						  
						  <?php else:?>
							  <?php 
									$q = 'SELECT custom_fields FROM lists WHERE id = '.$lid;
									$r = mysqli_query($mysqli, $q);
									if (mysqli_num_rows($r) > 0):
									while($row = mysqli_fetch_array($r)) $list_custom_fields = stripslashes($row['custom_fields']);
									if($list_custom_fields!=''):
							  ?>
							  <label class="radio" id="ares_type2">
							  	<input type="radio" name="autoresponder_type" id="autoresponder_type2" value="2" <?php if($drip_created) echo 'checked'; ?>>
								<strong><?php echo _('Send annually');?></strong><br/>
								<?php echo _('Create emails that automatically sends annually to subscribers, eg. anniversaries or birthdays.');?>
								<br/><br/>
								<?php echo _('Based on this date');?>:<br/>
								<select id="type2_custom_fields" name="type2_custom_fields">
								  <?php 
									  $list_custom_fields_array = explode('%s%', $list_custom_fields);
									  foreach($list_custom_fields_array as $cf)
									  {
											$cf_array = explode(':', $cf);
											if($cf_array[1]=='Date')
											{
												//check if custom field has been used in any autoresponders before
												$q2 = 'SELECT custom_field FROM ares WHERE custom_field = "'.$cf_array[0].'" AND list = '.$lid;
												$r2 = mysqli_query($mysqli, $q2);
												if (mysqli_num_rows($r2) > 0)
													echo '<option value="'.$cf_array[0].'%s%inuse">'.$cf_array[0].' (in use)</option>';
												else
													echo '<option value="'.$cf_array[0].'">'.$cf_array[0].'</option>';
											}
									  }
								  ?>
								</select>	
								<br/>			
							   </label>
							  <?php endif; endif; ?>
							  
							  <?php 
									$q = 'SELECT custom_fields FROM lists WHERE id = '.$lid;
									$r = mysqli_query($mysqli, $q);
									if (mysqli_num_rows($r) > 0):
									while($row = mysqli_fetch_array($r)) $list_custom_fields = stripslashes($row['custom_fields']);
									if($list_custom_fields!=''):
							  ?>
							  <label class="radio" id="ares_type3" style="margin-top: 18px;">
							  	<input type="radio" name="autoresponder_type" id="autoresponder_type3" value="3">
								<strong><?php echo _('Send on date');?></strong><br/>
								<?php echo _('Create one off emails that sends automatically on a specific date. eg. one off reminders.');?>
								<br/><br/>
								<?php echo _('Based on this date');?>:<br/>
								<select id="type3_custom_fields" name="type3_custom_fields">
								  <?php 
									  $list_custom_fields_array = explode('%s%', $list_custom_fields);
									  foreach($list_custom_fields_array as $cf)
									  {
											$cf_array = explode(':', $cf);
											if($cf_array[1]=='Date')
											{
												//check if custom field has been used in any autoresponders before
												$q2 = 'SELECT custom_field FROM ares WHERE custom_field = "'.$cf_array[0].'" AND list = '.$lid;
												$r2 = mysqli_query($mysqli, $q2);
												if (mysqli_num_rows($r2) > 0)
													echo '<option value="'.$cf_array[0].'%s%inuse">'.$cf_array[0].' (in use)</option>';
												else
													echo '<option value="'.$cf_array[0].'">'.$cf_array[0].'</option>';
											}
									  }
								  ?>
							  
							  
							</select>	
							<br/>				
						   </label>
						  <?php endif; endif; ?>
						  
						  <?php endif; ?>
						  
						  <br/>
						  <input type="hidden" name="id" value="<?php echo $app;?>"></input>
						  <input type="hidden" name="list" value="<?php echo $lid;?>"></input>
						  <button class="btn btn-inverse" type="submit"><?php echo _('Save & next');?></button> 
						  <a href="javascript:void(0)" id="cancel-btn"><span class="icon icon-remove-sign"></span> <?php echo _('Cancel');?></a>
					  </div>
				  </div>
				  
				  <?php endif;?>
				</form>
			</div>
	    </div>
	    
	    <br/><br/>
	    
	    <div class="row-fluid">
		    <div class="span12">
		    	<h3><?php echo _('Existing autoresponders');?></h3><hr/>
				<table class="table table-striped responsive">
	              <thead>
	                <tr>
	                  <th><?php echo _('Autoresponder');?></th>
	                  <th><?php echo _('Type');?></th>
	                  <th><?php echo _('Emails sent');?></th>
	                  <th><?php echo _('Delete');?></th>
	                </tr>
	              </thead>
	              <tbody>
	                	<?php 
		                	$q = 'SELECT id, name, type, custom_field FROM ares WHERE list = '.$lid.' ORDER BY type ASC';
		                	$r = mysqli_query($mysqli, $q);
		                	if ($r && mysqli_num_rows($r) > 0)
		                	{
		                	    while($row = mysqli_fetch_array($r))
		                	    {
		                	    	$ares_id = $row['id'];
		                			$ares_name = $row['name'];
		                			$ares_type = $row['type'];
		                			$ares_custom_field = $row['custom_field'];
		                			
		                			$q2 = 'SELECT recipients FROM ares_emails WHERE ares_id = '.$ares_id;
		                			$r2 = mysqli_query($mysqli, $q2);
		                			if ($r2 && mysqli_num_rows($r2) > 0)
		                			{
		                				$recipients = 0;
		                			    while($row = mysqli_fetch_array($r2))
		                			    {
		                					$recipients += $row['recipients'];
		                			    }  
		                			}
		                			else $recipients = _('No emails have been set up');
		                			
		                			switch($ares_type)
		                			{
										case '1':
											$ares_type_name = _('Drip campaign');
									    	break;
									    case '2':
									    	$ares_type_name = _('Send annually').' ('.$ares_custom_field.')';
									    	break;
									    case '3':
									    	$ares_type_name = _('Send on date').' ('.$ares_custom_field.')';
									    	break;
									}
		                			
		                			echo '
		                			<tr id="ares-'.$ares_id.'">
			                			<td><a href="'.get_app_info('path').'/autoresponders-emails?i='.get_app_info('app').'&a='.$ares_id.'">'.$ares_name.'</a></td>
			                			<td>'.$ares_type_name.'</td>
			                			<td>'.$recipients.'</td>
			                			<td><a href="javascript:void(0)" title="" id="delete-'.$ares_id.'" data-id="'.$ares_id.'"><i class="icon-trash"></i></a></td>
			                			<script type="text/javascript">
						            	$("#delete-'.$ares_id.'").click(function(e){
						            		e.preventDefault(); 
											c = confirm("'._('All associated autoresponder emails will be permanently deleted.').' '._('Confirm delete').' \''.$ares_name.'\'?");
											if(c)
											{
								            	$.post("'.get_app_info('path').'/includes/ares/delete-ares.php", { id: $(this).data("id") },
							            		  function(data) {
							            		      if(data)
							            		      {
							            		      	$("#ares-'.$ares_id.'").fadeOut(function(){
							            		      		window.location = "'.get_app_info('path').'/autoresponders-list?i='.get_app_info('app').'&l='.$lid.'";
							            		      	});
							            		      }
							            		      else
							            		      {
							            		      	alert("'._('Sorry, unable to delete. Please try again later!').'");
							            		      }
							            		  }
							            		);
							            	}
						            	});
							            </script>
		                			</tr>
		                			';
		                	    }  
		                	}	
		                	else
		                	{
			                	echo '
			                	<tr>
			                		<td colspan="4">'._('No autoresponders').'</td>
			                	</tr>
			                	';
		                	}
	                	?>                
	              </tbody>
	            </table>
			</div>
	    </div>
    </div>
</div>

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