| 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/lavignotte.com/seo-mailing/groups/ |
Upload File : |
<?php
if(count($_POST) && !isset($_POST['table']) && $_SESSION['PERM'][3]['a'] == 1){
if(isset($_POST['web'])){$web = 1;}else{$web=0;}
$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."mail_group (id, id_user, name, web) VALUES ('', '{$_SESSION['id']}', '{$_POST['name']}', '{$web}')";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
$query = IPAPI::query($ip);
mysqli_query($db,"INSERT INTO ".$INFO['sql_tbl_prefix']."system_logs
(id, id_type, id_user, ip, country, city, ddate, url, message)
VALUES
('', '3', '{$_SESSION['id']}','{$ip}','".$query->country."','".$query->regionName." - ".$query->city."','".time()."', '".$_SERVER['REQUEST_URI']."', 'User {$_SESSION['user']} add new group - {$_POST['name']}')");
?>
<?php }elseif(isset($_POST['table']) && count($_POST['table'])>0 && is_array($_POST['table'])){
foreach($_POST['table'] as $k=>$v){
if($k != 0){
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id=".$k." LIMIT 1";
$result = mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
$gr = mysqli_fetch_array($result);
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id=".$k." LIMIT 1";
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
}
$query = "SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id_cat=".$k;
$result = mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
$gr_us = mysqli_fetch_array($result);
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id_cat=".$k;
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
$query = IPAPI::query($ip);
mysqli_query($db,"INSERT INTO ".$INFO['sql_tbl_prefix']."system_logs
(id, id_type, id_user, ip, country, city, ddate, url, message)
VALUES
('', '5', '{$_SESSION['id']}','{$ip}','".$query->country."','".$query->regionName." - ".$query->city."','".time()."', '".$_SERVER['REQUEST_URI']."', 'User {$_SESSION['user']} remove group - {$gr['name']} ({$gr_us['count(*)']})')");
}
?>
<script type="application/javascript">
document.location.href="?groups";
</script>
<?php }?>
<div class="page-header">
<h1><i class="icon-group"></i> <?php echo __('Groups');?> <?php if($_SESSION['PERM'][3]['a'] == 1){?><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></div><?php } ?></h1>
</div>
<?php if(isset($_SESSION['PERM'][3]['a']) && $_SESSION['PERM'][3]['a'] == 1){?>
<div id="form-content" style="display:none">
<form action="" method="post" class="form-horizontal">
<h4><?php echo __('Add new group');?></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="form-actions">
<button type="submit" class="btn btn-primary"><?php echo __('Save');?></button>
</div>
</form>
<hr>
</div>
<?php } ?>
<?php if(isset($_SESSION['PERM'][3]['v']) && $_SESSION['PERM'][3]['v'] == 1){
$where = ' WHERE id_user ='.$_SESSION['id'];
}else{
$where = '';
}
$result = mysqli_query($db,"SELECT *,
(SELECT name FROM ".$INFO['sql_tbl_prefix']."user WHERE ".$INFO['sql_tbl_prefix']."user.id = ".$INFO['sql_tbl_prefix']."mail_group.id_user LIMIT 1) as user_name
FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ") or exit("select advice error");
if(mysqli_num_rows($result)>0){ $i=1;
$r = mysqli_query($db,"SELECT count(id) FROM ".$INFO['sql_tbl_prefix']."mail_group {$where}");
$gro = mysqli_fetch_array($r);
?>
<script>
jQuery.noConflict()(function($){
$(document).ready(function () {
$(".cheackall").click(function()
{
var checked_status = this.checked;
for (i=1; i<=<?php echo $gro['count(id)']?>; i++){
$('#tab'+i).each(function()
{
this.checked = checked_status;
});
}
});
});
});
</script>
<form action="" method="post">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="span1">#</th>
<th class="span1 center"><input type="checkbox" class="cheackall"></th>
<th class="span2"><?php echo __('Who added');?></th>
<th><?php echo __('Group title');?></th>
<th class="span1"><?php echo __('Participated in sending');?></th>
<th class="span1"><?php echo __('Emails count');?></th>
<th class="span1"><?php echo __('Operations');?></th>
</tr>
</thead>
<tbody>
<?php $a = 1; while($group = mysqli_fetch_array($result)){
?>
<tr>
<td><?php echo $i++?></td>
<td class="center">
<?php if ($group['id'] > 3) { ?>
<input type="checkbox" id="tab<?php echo $a++?>" name="table[<?php echo $group['id'];?>]">
<?php } ?>
</td>
<td><?php echo $group['user_name']?></td>
<td><a href="?group_users=<?php echo $group['id']?>"><?php echo $group['name']?></a>
<?php if ($group['id'] == 3) { echo' : Groupe System'; } ?></td>
<td class="center"><?php
//echo "SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id LIKE '%s:{$group['id']}:%'";
$count_tgroup = mysqli_fetch_array(mysqli_query($db,"SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id_cat LIKE '%i:{$group['id']}:%' OR id_cat LIKE '%i:{$group['id']};%'"));
echo $count_tgroup['count(*)'];
?></td>
<td class="center"><?php $count_email = mysqli_fetch_array(mysqli_query($db,"SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id_cat = {$group['id']} AND status = 0")); echo $count_email['count(*)']?></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 -->
<?php if(isset($_SESSION['PERM'][3]['e']) && $_SESSION['PERM'][3]['e'] == 1){?>
<li><a href="?group_edit=<?php echo $group['id']?>" title="<?php echo __('Edit');?>" ><i class="icon-pencil"></i> <?php echo __('Edit');?></a></li>
<?php } ?>
<li><a href="?users=all&group=<?php echo $group['id']?>" title="<?php echo __('Email list');?>" ><i class="icon-group"></i> <?php echo __('Email list');?></a></li>
<?php if(isset($_SESSION['PERM'][3]['r']) && $_SESSION['PERM'][3]['r'] == 1){?>
<li class="divider"></li>
<?php if ($group['id'] > 3) { ?>
<li><a href="?group_del=<?php echo $group['id']?>" onClick="return confirm('<?php echo __('Remove?');?>');" ><i class="icon-remove-sign"></i> <?php echo __('Remove');?></a></li>
<?php } } ?>
</ul>
</div>
</td>
</tr>
<?php } ?>
</tbody>
<tfoot>
<tr>
<td colspan="2"><button type="submit" class="btn btn-mini btn-danger"><?php echo __('Delete selected');?></button></td>
<td colspan="6"></td>
</tr>
</tfoot>
</table>
</form>
<?php }else{ ?>
<div class="alert alert-info">
<h4><i class="icon-info-sign"></i> <?php echo __('Information');?></h4>
<?php echo __('List of Groups is empty. Please add one group.');?>
</div>
<?php } ?>