| 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/ab-location-services.fr/seo-mailing/users/ |
Upload File : |
<script>
jQuery.noConflict()(function($){
$(document).ready(function()
{
$(".cheackall").click(function()
{
var checked_status = this.checked;
var clickId = this.id;
for (i=1; i<=<?php echo $_SET['users_page']?>; i++){
$('#tab'+i+clickId).each(function()
{
this.checked = checked_status;
});
}
});
});
});
</script>
<?php
if(count($_POST) and isset($_POST['id'])){
foreach($_POST['id'] as $v){
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id=".$v." LIMIT 1";
mysql_query($query) or exit("delet error" . mysql_error());
}?>
<script type="text/javascript">
document.location.href="?users";
</script>
<?php } ?>
<div class="page-header">
<h1><i class="icon-user icon-large"></i> <?php echo __('Users Mailing List');?> <div class="pull-right btn-group"><a href="" id="form" class="btn btn-primary"><i class="icon-plus-sign icon-white"></i> <?php echo __('Add');?></a>
<a href="?users_feature" class="btn btn-primary"><i class="icon-magic"></i> <?php echo __('Features')?></a>
<?php if($_SESSION['PERM'][8]['d'] == 1){?><a href="?unsubscribe" class="btn btn-primary"><i class="icon-ban-circle icon-white"></i> <?php echo __('List unsubscribed');?></a><?php } ?>
<a href="?users_blacklist" class="btn btn-inverse"><i class="icon-bolt"></i> <?php echo __('Blacklist');?></a></div></h1>
</div>
<?php
if(count($_POST) && !empty($_POST['email'])){
$email_array = '';
$email_array = explode(',',trim($_POST['email']));
foreach($email_array as $email){
if(!filter_var(trim($email), FILTER_VALIDATE_EMAIL)){?>
<div class="alert alert-block">
<h4><?php echo __('Warning!');?></h4>
<?php echo __('E-mail is not valid');?> - <?php echo $email?>
</div>
<?php }else{
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '".trim($email)."' AND id_cat = {$_POST['group']}
AND SUBSTRING_INDEX('".trim($email)."','@',-1) NOT IN (SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist)
LIMIT 1";
$result = mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
if(mysqli_num_rows($result) == 0){
if(isset($_POST['feature'])){
$feature = serialize($_POST['feature']);
}else{
$feature = '';
}
$unsubscribe_code = substr(md5(trim($_POST['name']).trim($_POST['email'])), 0, 7);
$query = "SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist WHERE domain = SUBSTRING_INDEX('".trim($email)."','@',-1) LIMIT 1";
$result = mysqli_query($db,$query);
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']}', '{$_POST['group']}', '{$_POST['name']}', '{$_POST['email']}','".$unsubscribe_code."', '{$feature}','0','0','0')";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
}
?>
<script type="application/javascript">
document.location.href="?users";
</script>
<?php }
}
}
}elseif(count($_POST) && empty($_POST['email']) && !isset($_POST['table'])){?>
<div class="alert alert-block">
<h4><?php echo __('Warning!');?></h4>
<?php echo __('Please enter E-mail');?>
</div>
<hr>
<?php }elseif(isset($_POST['table']) && count($_POST['table']) > 0 && is_array($_POST['table'])){
foreach($_POST['table'] as $k=>$v){
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id=".$k." LIMIT 1";
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
}
?>
<script type="application/javascript">
document.location.href="?users";
</script>
<?php }?>
<div id="form-content" style="display:none">
<form class="form-horizontal" method="post" action="">
<h4><?php echo __('Add new');?></h4>
<div class="control-group">
<label class="control-label" for="name"><?php echo __('Name');?></label>
<div class="controls">
<input type="text" class="input-xlarge" id="name" name="name">
</div>
</div>
<div class="control-group">
<label class="control-label" for="email"><?php echo __('E-mail');?></label>
<div class="controls">
<input type="email" class="input-xlarge" id="email" name="email">
</div>
</div>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Group');?></label>
<div class="controls">
<select name="group">
<?php
if($_SESSION['PERM'][4]['v'] == 1){
$where = "WHERE id_user = {$_SESSION['id']}";
}else{
$where = "";
}
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ";
$result = mysqli_query($db,$query) or exit("select advice error");
if(mysqli_num_rows($result) > 0){
while($group = mysqli_fetch_array($result)){ ?>
<option value="<?php echo $group['id']?>"><?php echo $group['name']?></option>
<?php }
$error=false;
?>
<?php }else{
$error= true;
?>
<option value="0"><?php echo __('Error: First, you need to add a user group');?></option>
<?php } ?>
</select>
</div>
</div>
<?php $fea_res = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user_feature");
if(mysqli_num_rows($fea_res) > 0){
while($fea = mysqli_fetch_array($fea_res)){
?>
<div class="control-group">
<label class="control-label"><?php echo $fea['name']?></label>
<div class="controls">
<input type="text" class="input-xlarge" id="fea" name="feature[<?php echo $fea['id']?>][]">
</div>
</div>
<?php } ?>
<?php }?>
<div class="form-actions">
<button type="submit" class="btn btn-primary<?php if($error == true){?>disabled" disabled="disabled"<?php }else{ echo '"'; }?>><?php echo __('Save');?></button>
</div>
</form>
</div>
<?php $alf = array_merge(range('0','9'),range('A','Z'));?>
<div class="btn-group">
<a class="btn btn-small btn-inverse" data-toggle="dropdown" href="#" style="">
<?php echo __('Action');?>
<span class="caret"></span>
</a>
<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
<li><a href='?users=all' ><i class="icon-group"></i> <?php echo __('All group');?></a></li>
<?php $result = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ") or exit("select advice error");
if(mysqli_num_rows($result)>0){?>
<li class="dropdown-submenu">
<a tabindex="-1" href="#"><?php echo __('Select a group');?></a>
<ul class="dropdown-menu">
<?php while($group = mysqli_fetch_array($result)){
?>
<li><a href='?users=all&group=<?php echo $group['id']?>' ><i class="icon-angle-right"></i> <?php echo $group['name']?></a></li>
<?php }?>
</ul>
</li>
<?php } ?>
</ul>
<?php if($_SESSION['PERM'][4]['v'] == 1){
$wher= " AND id_user=".$_SESSION['id'];
}else{
$wher = "";
}
if(isset($_GET['group'])){
$wher .= " AND id_cat = {$_GET['group']}";
$gr = '&group='.$_GET['group'];
}else{
$gr='';
}
foreach($alf as $v){
$v = strtolower($v);
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email LIKE '{$v}%' AND status = 0 {$wher}";
$result = mysqli_query($db,$query) or exit("select advice error");
if(mysqli_num_rows($result)>0){
echo "<a href='?users={$v}{$gr}' class='btn btn-small btn-inverse'>".$v."</a>";
}else{
echo "<a href='#' class='btn btn-small btn-inverse disabled'>".$v."</a>";
}?>
<?php }
$co = 0;
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE status = 0 {$wher}";
$result = mysqli_query($db,$query) or exit("select advice error");
while($ema = mysqli_fetch_array($result)){
if($mail_array = explode(", ", $ema['email'])){
$co = $co+count($mail_array);
}else{
$co++;
}
}
?>
<a href="#" class='btn btn-small btn-inverse disabled'><?php echo __('Counts');?>: <span class="label label-info"><?php echo $co;?></span></a>
</div>
<hr/>
<?php if($_GET['users'] == 'all'){
$where = " WHERE status = 0";
if(isset($_GET['group'])){
$where .= " AND id_cat = {$_GET['group']}";
}
}elseif(empty($_GET['users'])){
$where = " WHERE status = 0";
}elseif($_GET['users'] <> '' && $_GET['users'] <> 'all'){
$where = " WHERE email LIKE '{$_GET['users']}%' and status = 0";
}
function page()
{
if(empty($_GET["page"])){
$page = 0;
} else {
if(!is_numeric($_GET["page"])) die("<div class='alert alert-danger'>".__('Invalid format for the page number!')."</div>");
$page = $_GET["page"];
}
return $page;
}
function sql_query($onpage, $page, $table)
{
global $db, $lng, $INFO, $where, $wher;
$begin = $page*$onpage;
$sql = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user {$where} {$wher} ORDER by name LIMIT ".$begin.", ".$onpage;
$result = mysqli_query($db,$sql) or die(mysqli_error().$count);
return $result;
}
function navigation($onpage, $page, $table)
{
global $db, $lng, $INFO,$where, $wher;
if(!empty($_GET['users']) && $_GET['users'] <> "all"){
$gr = '='.$_GET['users'];
}else{
$gr = '';
}
if(isset($_GET['group'])){
$gr .= "&group=".$_GET['group'];
}
$re = '';
$count = mysqli_query($db,"SELECT COUNT(id) FROM ".$INFO['sql_tbl_prefix']."mail_user {$where} {$wher}") or die(mysql_error().$count);
$count = mysqli_fetch_array($count);
$count = $count[0];
$pages = $count/$onpage;
$itemscount= $count;
$itemsperpage=$onpage;
if (isset($_GET['page']))
{ $cpage=$_GET['page']; }
else { $cpage=1; }
$pagedisprange=3;
$pagescount=ceil($itemscount/$itemsperpage) -1 ;
$stpage=$cpage-$pagedisprange;
if ($stpage<1) { $stpage=1; }
$endpage=$cpage+$pagedisprange;
if ($endpage>$pagescount) { $endpage=$pagescount; }
if ($cpage>=1) {
if($cpage==1){
$re .= "<a href='#' class='btn btn-small disabled'>".__('First')."</a>";
$re .= "<a href='#' class='btn btn-small disabled'>".__('Previous')."</a>";
}else{
$re .= "<a href='?users".$gr."&page=1' class='btn btn-small'>".__('First')."</a>";
$re .= "<a href='?users".$gr."&page=".($cpage-1)."' class='btn btn-small'>".__('Previous')."</a>";
}
}
if ($stpage>1) $re .= "<a href='#' class='btn btn-small disabled'>...</a>"; // если начало вывода не 1, то напечатаем три точки
for ($i=$stpage;$i<=$endpage;$i++) {
if ($i==$cpage) { $re .= '<a href="#" class="btn btn-small disabled">'.$i.'</a> '; }
else { $re .= '<a href="?users'.$gr.'&page='.$i.'" class="btn btn-small">'.$i.'</a> '; }
}
if ($endpage<$pagescount) $re .= "<a href='#' class='btn btn-small disabled'>...</a>"; // если начало конец вывода не последняя страница, то напечатаем три точки
if ($cpage<=$pagescount) {
if($cpage == $pagescount){
$re .= '<a href="#" class="btn btn-small disabled">'.__('Next').'</a>';
$re .= "<a href='#' class='btn btn-small disabled'>".__('Last')."</a>";
}else{
$re .= '<a href="?users'.$gr.'&page='.($cpage+1).'" class="btn btn-small">'.__('Next').'</a>';
$re .= "<a href='?users".$gr."&page=".($pagescount)."' class='btn btn-small'>".__('Last')."</a>";
}
}
return $re;
}
$onpage = $_SET['users_page'];
$table = $INFO['sql_tbl_prefix']."mail_user";
$page = page();
$result = sql_query($onpage, $page, $table);
$navigation = navigation($onpage, $page, $table);
?> <div class="btn-group">
<?php echo $navigation?>
</div>
<hr>
<?php if(mysqli_num_rows($result)>0){
$result_fea = mysqli_query($db,"SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_user_feature");
if(mysqli_num_rows($result_fea) > 0){
$feature = mysqli_fetch_array($result_fea);
$fea_row = $feature['count(*)'];
}
?>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="span1" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>>##</th>
<th <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><input type="checkbox" class="cheackall"></th>
<th class="span1" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?> ><?php echo __('Created')?></th>
<th class="span2" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('User');?></th>
<th class="span2" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('Group');?></th>
<th class="span2" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('E-mail');?></th>
<th <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('Name');?></th>
<th class="span1" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('Status')?></th>
<?php if(isset($fea_row) && $fea_row > 0){?>
<th colspan="<?php echo $fea_row?>"><?php echo __('Features')?></th>
<?php } ?>
<th class="span1" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('Unsubscribe code');?></th>
<?php if(($_SESSION['PERM'][4]['r'] == 1 && $_SESSION['PERM'][4]['e'] == 1) ||
$_SESSION['PERM'][4]['r'] + $_SESSION['PERM'][4]['e'] > 0
){?>
<th class="span1" <?php if(isset($fea_row)){?> rowspan="2" <?php } ?>><?php echo __('Operations');?></th>
<?php } ?>
</tr>
<?php if(isset($fea_row) && $fea_row > 0){?>
<tr>
<?php $fea_res = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user_feature");
while($fea = mysqli_fetch_array($fea_res)){
?>
<td><?php echo $fea['name']?></td>
<?php } ?>
</tr>
<?php } ?>
</thead>
<form method="post" action="">
<tbody>
<?php $i=1; while($user = mysqli_fetch_array($result)){ ?>
<tr class="font11">
<td><?php echo $user['id']?></td>
<td style="width:5px;">
<input type="checkbox" id="tab<?php echo $i++?>" name="table[<?php echo $user['id'];?>]" value="<?php echo $user['id']?>">
</td>
<td><?php if(isset($user['insert_date']) && $user['insert_date'] > 0){
echo date("H:i d.m.Y", $user['insert_date']);
}else{
echo "<span class='label'>".__('Not date')."</span>";
}?></td>
<td><?php $user_name = mysqli_fetch_array(mysqli_query($db,"SELECT name, id_cat FROM ".$INFO['sql_tbl_prefix']."user WHERE id = {$user['id_user']} LIMIT 1"));
if($user_name['id_cat'] > 0){
echo $user_name['name'];
}else{
echo "<i class='icon-globe'></i> ".__('Added from outside');
}
?></td>
<td><?php $que = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id = {$user['id_cat']} LIMIT 1";
$res = mysqli_query($db,$que) or exit("select advice error");
$group = mysqli_fetch_array($res);
echo $group['name'];
?></td>
<td><ul style="list-style:none; margin:0px; padding:0px"><?php $email_array = '';
$email_array = explode(',',trim($user['email']));
foreach($email_array as $email){
if(!filter_var(trim($email), FILTER_VALIDATE_EMAIL)){
echo "<li><span class='label label-important'>".__('E-mail is not valid')."</span> ";
}else{
echo "<li>";
}
echo $email."</li>";
}?></ul></td>
<td><?php echo $user['name']?></td>
<td class="center"><?php
if($user['valid'] == 1){
echo "<span class='label'>".__('Checked')."</span>";
}else{
echo "<span class='label label-important'>".__('No checked')."</span>";
}
?></td>
<?php if(isset($fea_row)){
$feature_array = unserialize($user['feature']);
$fea_res = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user_feature");
while($fea = mysqli_fetch_array($fea_res)){
?>
<td><?php echo $feature_array[$fea['id']][0]?></td>
<?php } ?>
<?php } ?>
<td class="center"><code><?php echo $user['unsubscribe_code']?></code></td>
<?php if(($_SESSION['PERM'][4]['r'] == 1 && $_SESSION['PERM'][4]['e'] == 1) ||
$_SESSION['PERM'][4]['r'] + $_SESSION['PERM'][4]['e'] > 0
){?>
<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">
<?php if($_SESSION['PERM'][4]['e'] == 1){?>
<!-- dropdown menu links -->
<li><a href="?user_edit=<?php echo $user['id']?>" title="<?php echo __('Edit');?>" ><i class="icon-pencil"></i> <?php echo __('Edit');?></a></li>
<?php } ?>
<?php if($_SESSION['PERM'][4]['r'] == 1){?>
<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>
<?php } ?>
</ul>
</div>
</td>
<?php } ?>
</tr>
<?php } ?>
</tbody>
<tfoot>
<tr>
<td colspan="3"><button type="submit" class="btn btn-mini btn-danger" onClick="return confirm('<?php echo __('Remove?');?>');"><i class="icon-remove-sign"></i> <?php echo __('Delete Selected')?></button></td>
<td colspan="<?php if(isset($fea_row) && $fea_row > 0){ echo $fea_row+7;}else{ echo 7;}?>"></td>
</tr>
</tfoot>
</table>
</form>
<div class="btn-group">
<?php echo $navigation?>
</div>
<hr/>
<?php }else{?>
<div class="alert alert-info">
<h4><i class="icon-info-sign"></i> <?php echo __('Information');?></h4>
<?php echo __('List of Users is empty. Please add.');?>
</div>
<?php } ?>