| Server IP : 89.108.64.180 / Your IP : 216.73.217.92 Web Server : Apache/2.4.41 (Ubuntu) System : Linux 89-108-64-180.cloudvps.regruhosting.ru 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : www-root ( 1010) PHP Version : 8.0.30 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/hotelzm.com/wp-content/plugins/newsletter/users/ |
Upload File : |
<?php
defined('ABSPATH') || exit;
?>
<div class="row">
<div class="col-md-6">
<h3><?php _e('Subscriptions by month (max 12 months)', 'newsletter') ?></h3>
<?php
$months = $wpdb->get_results("select count(*) as c, concat(year(created), '-', date_format(created, '%m')) as d from " . NEWSLETTER_USERS_TABLE . " where status='C' group by concat(year(created), '-', date_format(created, '%m')) order by d desc limit 12");
?>
<table class="widefat">
<thead>
<tr>
<th><?php _e('Year and month', 'newsletter') ?></th>
<th><?php _e('Total', 'newsletter') ?></th>
</tr>
</thead>
<?php foreach ($months as &$day) { ?>
<tr>
<td><?php echo $day->d; ?></td>
<td><?php echo $day->c; ?></td>
</tr>
<?php } ?>
</table>
</div>
<div class="col-md-6">
<h3><?php _e('Subscriptions by day (max 90 days)', 'newsletter') ?></h3>
<?php
$list = $wpdb->get_results("select count(*) as c, date(created) as d from " . NEWSLETTER_USERS_TABLE . " where status='C' group by date(created) order by d desc limit 90");
?>
<table class="widefat">
<thead>
<tr>
<th><?php _e('Date', 'newsletter') ?></th>
<th><?php _e('Total', 'newsletter') ?></th>
</tr>
</thead>
<?php foreach ($list as $day) { ?>
<tr>
<td><?php echo $day->d; ?></td>
<td><?php echo $day->c; ?></td>
</tr>
<?php } ?>
</table>
</div>
</div>