|
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE); ?>
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where status='C'"); ?>
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where status='S'"); ?>
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where status='U'"); ?>
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where status='B'"); ?>
|
is_multilanguage()) { ?>
By language
get_languages(); ?>
|
|
$label) { ?>
|
get_var($wpdb->prepare("select count(*) from " . NEWSLETTER_USERS_TABLE . " where language=%s", $code)); ?>
|
|
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where language=''"); ?>
|
| |
|
(*) |
get_lists(); ?>
| id ?> |
name) ?> |
get_var("select count(*) from " . NEWSLETTER_USERS_TABLE . " where list_" . $list->id . "=1 and status='C'"); ?>
|
(*)
panel_help('https://www.thenewsletterplugin.com/documentation/subscribers-statistics#referrer') ?>
get_results("select referrer, SUM(if(status='C', 1, 0)) as confirmed, SUM(if(status='S', 1, 0)) as unconfirmed, SUM(if(status='B', 1, 0)) as bounced, SUM(if(status='U', 1, 0)) as unsubscribed from " . NEWSLETTER_USERS_TABLE . " group by referrer order by confirmed desc");
?>
|
|
|
|
|
| referrer) ? '[not set]' : esc_html($row->referrer) ?> |
confirmed; ?> |
unconfirmed; ?> |
unsubscribed; ?> |
bounced; ?> |
panel_help('https://www.thenewsletterplugin.com/documentation/subscribers-statistics#source') ?>
get_results("select http_referer, SUM(if(status='C', 1, 0)) as confirmed, SUM(if(status='S', 1, 0)) as unconfirmed, SUM(if(status='B', 1, 0)) as bounced, SUM(if(status='U', 1, 0)) as unsubscribed from " . NEWSLETTER_USERS_TABLE . " group by http_referer order by count(*) desc limit 100");
?>
| URL |
|
|
|
|
| http_referer) ? '[not set]' : $controls->print_truncated($row->http_referer, 120) ?> |
confirmed; ?> |
unconfirmed; ?> |
unsubscribed; ?> |
bounced; ?> |
get_row("select SUM(if(status='C', 1, 0)) as confirmed, SUM(if(status='S', 1, 0)) as unconfirmed, SUM(if(status='B', 1, 0)) as bounced, SUM(if(status='U', 1, 0)) as unsubscribed from " . NEWSLETTER_USERS_TABLE . " where sex='m'");
$female_count = $wpdb->get_row("select SUM(if(status='C', 1, 0)) as confirmed, SUM(if(status='S', 1, 0)) as unconfirmed, SUM(if(status='B', 1, 0)) as bounced, SUM(if(status='U', 1, 0)) as unsubscribed from " . NEWSLETTER_USERS_TABLE . " where sex='f'");
$none_count = $wpdb->get_row("select SUM(if(status='C', 1, 0)) as confirmed, SUM(if(status='S', 1, 0)) as unconfirmed, SUM(if(status='B', 1, 0)) as bounced, SUM(if(status='U', 1, 0)) as unsubscribed from " . NEWSLETTER_USERS_TABLE . " where sex='n'");
?>
|
|
|
|
|
|
confirmed; ?> |
unconfirmed; ?> |
unsubscribed; ?> |
bounced; ?> |
|
confirmed; ?> |
unconfirmed; ?> |
unsubscribed; ?> |
bounced; ?> |
|
confirmed; ?> |
unconfirmed; ?> |
unsubscribed; ?> |
bounced; ?> |