| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ODLDDD_2/seo-mailing/users/ |
Upload File : |
<?php
if(isset($_GET['cancel'])){
$query = "UPDATE ".$INFO['sql_tbl_prefix']."mail_user SET status = '0', time_unsubscribe = '0', ip_unsubscribe= '0' WHERE id = '".$_GET['cancel']."' LIMIT 1";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
?>
<script type="application/javascript">
document.location.href="?unsubscribe";
</script>
<?php }
if(isset($_POST) && isset($_POST['email'])){
$time_unsubscribe = time();
$ip_unsubscribe = $_SERVER["HTTP_CLIENT_IP"];
$id_task_unsubscribe = 0;
$unsubscribe_code = substr(md5(trim($_POST['name']).trim($_POST['email'])), 0, 7);
$result = mysqli_query($db,"SELECT email FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '{$_POST['email']}' AND status = 1 LIMIT 1");
if(mysqli_num_rows($result) == 0){
$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."mail_user
(id, insert_date, id_user, id_cat, name, email, unsubscribe_code,feature, time_unsubscribe, ip_unsubscribe, status) VALUES
('', '".time()."', '{$_SESSION['id']}', '0', '{$_POST['name']}', '{$_POST['email']}','".$unsubscribe_code."', '','{$time_unsubscribe}','{$ip_unsubscribe}','1')";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
}
?>
<script type="application/javascript">
document.location.href="?unsubscribe";
</script>
<?php }
?>
<div class="page-header">
<h1><i class="icon-ban-circle icon-large"></i> <?php echo __('List unsubscribed');?>
<div class="pull-right">
<div class="btn-group">
<a href="?users" class="btn btn-primary"><i class="icon-arrow-left"></i> <?php echo __('Users base')?></a>
<a href="" class="btn btn-primary" id="form"><i class="icon-plus"></i> <?php echo __('Add')?></a>
</div>
</div></h1>
</div>
<div id="form-content" style="display:none">
<form action="" method="post" class="form-horizontal">
<h4><?php echo __('Add new unsibscribe');?></h4>
<div class="control-group">
<label class="control-label" for="name"><?php echo __('Name');?></label>
<div class="controls">
<input type="text" name="name" id="name" value="" placeholder="<?php echo __('Name');?>" required="required">
</div>
</div>
<div class="control-group">
<label class="control-label" for="email"><?php echo __('Email');?></label>
<div class="controls">
<input type="email" name="email" id="email" value="" placeholder="<?php echo __('Email');?>" required="required">
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary"><?php echo __('Save');?></button>
</div>
</form>
<hr>
</div>
<?php $query = "SELECT *,
(SELECT name FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE ".$INFO['sql_tbl_prefix']."mail_task.id = ".$INFO['sql_tbl_prefix']."mail_user.id_task_unsubscribe) as task_name
FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE status = 1";
$result = mysqli_query($db,$query) or exit("select advice error");
if(mysqli_num_rows($result) != 0){?>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>##</th>
<th><?php echo __('E-newsletter Subject')?></th>
<th><?php echo __('Name');?></th>
<th><?php echo __('E-mail');?></th>
<th><?php echo __('Ip-address');?></th>
<th><?php echo __('Date');?></th>
<th class="span1"><?php echo __('Operations');?></th>
</tr>
</thead>
<tbody>
<?php while($user = mysqli_fetch_array($result)){?>
<tr class="font11">
<td><?php echo $user['id']?></td>
<td><?php if(!empty($user['task_name'])){echo $user['task_name'];}else{ echo '<span class="label label-info">'.__('Added manually').'</span>';}?></td>
<td><?php echo $user['name']?></td>
<td><?php echo $user['email']?></td>
<td><?php echo $user['ip_unsubscribe']?></td>
<td><?php echo date("d.m.Y H:i",$user['time_unsubscribe'])?></td>
<td><div class="btn-group">
<a class="btn btn-primary btn-small dropdown-toggle" data-toggle="dropdown" href="#">
<?php echo __('Action');?>
<span class="caret"></span>
</a>
<ul class="dropdown-menu">
<!-- dropdown menu links -->
<li><a href="?unsubscribe&cancel=<?php echo $user['id']?>"><i class="icon-ok"></i> <?php echo __('Cancel Unsubscribe');?></a></li>
<li><a href="?user_edit=<?php echo $user['id']?>" title="<?php echo __('Edit');?>" ><i class="icon-pencil"></i> <?php echo __('Edit');?></a></li>
<li class="divider"></li>
<li><a href="?user_del=<?php echo $user['id']?>" onClick="return confirm('<?php echo __('Remove?');?>');"><i class="icon-remove-sign"></i> <?php echo __('Remove');?></a></li>
</ul>
</div></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php }else{ ?>
<div class="alert alert-info">
<h4><i class="icon-info-sign"></i> <?php echo __('Information');?></h4>
<?php echo __('Unsubscribed list is empty.');?>
</div>
<?php } ?>