| 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/archives/ |
Upload File : |
<?php
if(count($_POST)){
if(isset($_POST['table']) && is_array($_POST['table']) && count($_POST['table'])){
foreach($_POST['table'] as $k=>$v){
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id=".$k." LIMIT 1";
$result = mysqli_query($db,$query) or exit("select advice error");
$task = mysqli_fetch_array($result);
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."user WHERE id=".$task['id_user']." LIMIT 1";
$result = mysqli_query($db,$query) or exit("select advice error");
$user = mysqli_fetch_array($result);
mysqli_query($db,"INSERT INTO ".$INFO['sql_tbl_prefix']."system_logs
(id, id_type, id_user, ip, ddate, url, message)
VALUES
('', '5', '{$_SESSION['id']}', '{$ip}', '".time()."', '".$_SERVER['REQUEST_URI']."', 'User {$_SESSION['user']} remove task - {$task['name']}')");
if(isset($task['file'])){
$file_array = explode(";",$task['file']);
foreach($file_array as $val){
$user_name = strtolower($user['name']);
@unlink("attachments/".$user_name."/".$val);
}
}
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id=".$k." LIMIT 1";
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."statistics WHERE id_task=".$k;
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."statistic_open WHERE id_task=".$k;
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE id_task=".$k;
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
}
}?>
<script type="text/javascript">
document.location.href="?archives";
</script>
<?php }
if(isset($_GET['resend'])){
$url = $INFO['base_url']."runtask.php?resend=".$_GET['resend'];
curl_get($url);
?>
<script type="application/javascript">
document.location.href="?archives";
</script>
<?php } ?>
<div class="page-header">
<h1><i class="icon-briefcase"></i> <?php echo __('Newsletter Archive');?></h1>
</div>
<?php
if($_SESSION['PERM'][2]['v'] == 1){
$where = " AND id_user=".$_SESSION['id'];
}else{
$where = "";
}
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;
$begin = $page*$onpage;
$sql = "SELECT *,
(SELECT COUNT(*) FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE ".$INFO['sql_tbl_prefix']."mail_task_email.id_task = ".$INFO['sql_tbl_prefix']."mail_task.id AND ".$INFO['sql_tbl_prefix']."mail_task_email.status =1) as count_mail
FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE status = 1 {$where} ORDER by ddate_end DESC 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;
$re = '';
$count = mysqli_query($db,"SELECT COUNT(*) FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE status = 1 {$where} ORDER by ddate_end DESC") or die(mysqli_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='?archives&page=1' class='btn btn-small'>".__('First')."</a>";
$re .= "<a href='?archives&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="?archives&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="?archives&page='.($cpage+1).'" class="btn btn-small">'.__('Next').'</a>';
$re .= "<a href='?archives&page=".($pagescount)."' class='btn btn-small'>".__('Last')."</a>";
}
}
return $re;
}
$onpage = $_SET['archive_page'];
$table = $INFO['sql_tbl_prefix']."mail_task";
$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){?>
<script>
jQuery.noConflict()(function($){
$(document).ready(function () {
$(".cheackall").click(function()
{
var checked_status = this.checked;
for (i=1; i<=<?php echo $_SET['archive_page']?>; 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 __('Data begin');?></th>
<th class="span2"><?php echo __('Data end');?></th>
<th class="span2"><?php echo __('Group');?></th>
<th class="span2"><?php echo __('User');?></th>
<th><?php echo __('Subject');?></th>
<th class="span1"><?php echo __('Sent messages');?></th>
<!--
<th class="span1"><?php echo __('Files');?></th>
-->
<th class="span1"><?php echo __('Operations');?></th>
</tr>
</thead>
<tbody>
<?php $i=1;while($task = mysqli_fetch_array($result)){ ?>
<tr>
<td><?php echo $task['id'];?></td>
<td class="center"><input type="checkbox" id="tab<?php echo $i++;?>" name="table[<?php echo $task['id'];?>]"></td>
<td class="span2 font11"><i class="icon-time"></i> <?php echo date("d.m.Y H:i:s",$task['ddate_start'])?></td>
<td class="span2 font11"><i class="icon-time"></i> <?php echo date("d.m.Y H:i:s",$task['ddate_end'])?></td>
<td><?php $group_array = unserialize($task['id_cat']);
foreach($group_array as $key => $val){
$group = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id = {$key} LIMIT 1");
if(mysqli_num_rows($group) == 0){
echo "<span class='label label-important'><s>".$val."</s></span> ";
}else{
echo "<span class='label label-success'>".$val."</span> ";
}
}
?></td>
<td><?php $user_name = mysqli_fetch_array(mysqli_query($db,"SELECT name FROM ".$INFO['sql_tbl_prefix']."user WHERE id = {$task['id_user']} LIMIT 1"));
echo $user_name['name']?></td>
<td><?php if($task['importance'] == 'high'){ echo "<i class='icon-lightbulb'></i> ";}?><a href="?task=<?php echo $task['id']?>"><?php echo $task['name']?></a></td>
<td class="center"><?php echo $task['count_mail']?></td>
<!--
<td class="span1"><?php if(strlen($task['file'])>3){ ?>
<a href="#" class="btn btn-small" rel="popover" data-original-title="<?php echo __('Files list');?>" data-placement="left" data-content="<?php if(strstr($task['file'],';')){
$fi = explode(";", $task['file']);
foreach($fi as $v){
if(strlen($v)>0){
?>
<?php if(strlen($v) > 20) {echo substr($v,0,20)."...";}else{ echo $v;}?>
<?php }
}
}else{?>
<?php
if(strlen($task['file']) > 20) {echo substr($task['file'],0,20)."...";}else{ echo $task['file'];}
?>
<?php } ?>"><?php echo __('Files');?></a>
<?php }else{
echo "<span class='label'>".__('No attachments')."</span>";
}
?></td>
-->
<td class="span1"><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="?task=<?php echo $task['id']?>" title="<?php echo __('View');?>" ><i class="icon-eye-open"></i> <?php echo __('View');?> + Statistiques</a></li>
<li><a href="?archives&resend=<?php echo $task['id']?>" title="<?php echo __('Resend');?>" ><i class="icon-play"></i> <?php echo __('Resend');?></a></li>
<?php if($_SESSION['PERM'][7]['d'] == 1){?>
<!--
<li><a href="?stat=<?php echo $task['id']?>" title="<?php echo __('Statistic');?>"><i class="icon-bar-chart"></i> <?php echo __('Statistic');?></a></li>
-->
<?php } ?>
<?php if($_SESSION['PERM'][2]['r'] == 1){?>
<li class="divider"></li>
<li><a href="?task_del=<?php echo $task['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="3"><button type="submit" class="btn btn-mini btn-danger"><?php echo __('Delete selected');?></button></td>
<td colspan="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 Newsletter Archive is empty.');?>
</div>
<?php } ?>