Cyb3r Drag0nz Team Shell

Viewing: /home/atwiofrxug/mylittletelaviv/wp-content/plugins/knews/admin/knews_admin_stats.php

<?php
global $Knews_plugin, $wpdb;

//Security for CSRF attacks
$knews_nonce_action='kn-admin-stats';
$knews_nonce_name='_statsadm';
if (!empty($_POST)) $w=check_admin_referer($knews_nonce_action, $knews_nonce_name);
//End Security for CSRF attacks

if (isset($_POST['reset_KnewsStats'])) {
	$query='DELETE FROM ' . KNEWS_STATS;
	$results=$wpdb->query($query);
	
	$query = "DELETE FROM ".KNEWS_NEWSLETTERS_SUBMITS." WHERE blog_id=" . get_current_blog_id() . " AND finished=1";
	$results=$wpdb->query($query);

	echo '<div class="updated"><p>The stats was reseted.</p></div>';
}

?>
<script type="text/javascript" src="<?php echo KNEWS_URL; ?>/admin/scripts.js"></script>
<script type="text/javascript" src="<?php echo '/' . '/'; ?>www.google.com/jsapi"></script>
<script type="text/javascript">
	
	// Load the Visualization API and the piechart package.
	google.load('visualization', '1', {'packages':['corechart']});
</script>
<link href="<?php echo KNEWS_URL; ?>/admin/styles.css" rel="stylesheet" type="text/css" />
<div class="wrap knews_stats">
<?php
$tab = $Knews_plugin->get_safe('tab', $Knews_plugin->post_safe('tab') );
?>
<div class="icon32" style="background:url(<?php echo KNEWS_URL; ?>/images/icon32.png) no-repeat 0 0;"><br></div><h2 class="nav-tab-wrapper">
	<a class="nav-tab <?php if ($tab=='') echo 'nav-tab-active'; ?>" href="admin.php?page=knews_stats"><?php _e('Global Stats','knews'); ?></a>
	<a class="nav-tab <?php if ($tab=='news') echo 'nav-tab-active'; ?>" href="admin.php?<?php echo (($Knews_plugin->im_pro()) ? 'page=knews_stats&tab=news' : 'page=knews_config&tab=pro'); ?>"><?php _e('One News Stats','knews'); ?></a>
	<a class="nav-tab <?php if ($tab=='user') echo 'nav-tab-active'; ?>" href="admin.php?<?php echo (($Knews_plugin->im_pro()) ? 'page=knews_users&msg=selectuser' : 'page=knews_config&tab=pro'); ?>"><?php _e('One User Stats','knews'); ?></a>
</h2>
<?php

function knews_hardCut($str, $maxlen=8, $right='.') {
	if (strlen($str) <= $maxlen) return $str;
	return substr($str, 0, $maxlen) . $right;
}

function knews_print_options($start, $end, $active) {
	for ($a = $start; $a <= $end; $a++) {
		echo '<option value="' . $a . '"';
		if ($a==$active) echo ' selected="selected"';
		echo '>' . $a . '</option>';
	}
}
function knews_safe_percent($p1, $p2) {
	if ($p2==0) return 0;
	$p3 = round($p1 * 1000 / $p2);
	if ($p3==0) return 0;
	return $p3 / 10;
}
function knews_safe_js($text) {
	$text = str_replace("'","\'",$text);
	$text = str_replace("\\'","\'",$text);
	echo $text;
}

	if (! $Knews_plugin->initialized) $Knews_plugin->init();

	$today = mktime(0, 0, 0, date('n'), date('j'), date('Y'));
	$yesterday = strtotime ('-1 day', $today);
	
	// Pixel tracking start
	$query='SELECT MIN(date) AS min_tracking FROM ' . KNEWS_STATS . ' WHERE what=7';
	$results=$wpdb->get_results($query);
	if ($results[0]->min_tracking == '') {
		$min_tracking=$today;
	} else {
		$min_tracking=intval($Knews_plugin->sql2time($results[0]->min_tracking));
	}

	if ($tab == 'news') {
		require ('knews_admin_stats_news.php');
	} elseif ($tab == 'user') {
		require ('knews_admin_stats_user.php');
	} else {

	// Min & max user date
	$query='SELECT MIN(joined) AS min_joined FROM ' . KNEWS_USERS;
	$results=$wpdb->get_results($query);
	$min_joined=$Knews_plugin->sql2time($results[0]->min_joined);
	if (intval($results[0]->min_joined)==0) $min_joined = $yesterday;
	
	// Min & max stats
	$query='SELECT MIN(date) AS min_block FROM ' . KNEWS_STATS;
	$results=$wpdb->get_results($query);
	$min_block=$Knews_plugin->sql2time($results[0]->min_block);
	if (intval($results[0]->min_block)==0) $min_block = $yesterday;

	// Min & max submit date
	$query='SELECT MIN(start_time) AS min_submit FROM ' . KNEWS_NEWSLETTERS_SUBMITS . ' WHERE blog_id=' . get_current_blog_id() . ' AND users_ok <> 0 OR users_error <> 0';
	$results=$wpdb->get_results($query);
	$min_submit=$Knews_plugin->sql2time($results[0]->min_submit);
	if (intval($results[0]->min_submit)==0) $min_submit = $yesterday;

	$min_date_chart = $min_joined;
	if ($min_block < $min_joined) $min_date_chart = $min_block;
	if ($min_submit < $min_date_chart) $min_date_chart = $min_submit;
	
	$max_date_chart=time();

	$select_min_year = date("Y", $min_date_chart);
	$select_max_year = date("Y", $max_date_chart);

	if ($Knews_plugin->post_safe('day_1') != '') {
	
		$selected_min_date_chart = mktime(0, 0, 0, $Knews_plugin->post_safe('month_1'), $Knews_plugin->post_safe('day_1'), $Knews_plugin->post_safe('year_1'));
		$selected_max_date_chart = mktime(0, 0, 0, $Knews_plugin->post_safe('month_2'), $Knews_plugin->post_safe('day_2'), $Knews_plugin->post_safe('year_2'));
		$fast_select='';
				
	} else {
		$fast_select = $Knews_plugin->get_safe('sel','all');
		
		if ($fast_select=='all') {
			$selected_min_date_chart = $min_date_chart;
			$selected_max_date_chart = $max_date_chart;

		} elseif($fast_select=='7') {
			$selected_min_date_chart = strtotime ('-7 day', $today);
			$selected_max_date_chart = time();

		} elseif($fast_select=='30') {
			$selected_min_date_chart = strtotime ('-30 day', $today);
			$selected_max_date_chart = time();

		} elseif($fast_select=='week') {
			$selected_max_date_chart = $today + 1 - date('w') * 60 * 60 *24;
			$selected_min_date_chart = strtotime ('-6 day', $selected_max_date_chart);

		} elseif($fast_select=='month') {
			$month = date('m')-1;
			$year = date('Y');
			if ($month == 0) { $month=12; $year--; }
			$selected_min_date_chart = mktime(0, 0, 0, $month, 1, $year);
			$selected_max_date_chart = mktime(0, 0, 0, $month, date('t',$selected_min_date_chart), $year);
		}
	
	}

	if ($selected_min_date_chart > $selected_max_date_chart) {
		if ($fast_select != 'all' && $fast_select != '') $fast_select=='error';
		$aux = $selected_min_date_chart;
		$selected_min_date_chart = $selected_max_date_chart;
		$selected_max_date_chart = $aux;
	}
	
	if ($selected_min_date_chart > $max_date_chart || $selected_max_date_chart < $min_date_chart) {
		if ($fast_select != 'all' && $fast_select != '') $fast_select=='error';
		$selected_min_date_chart = $min_date_chart;
		$selected_max_date_chart = $max_date_chart;		
	}
	
	$selected_max_date_chart = mktime(23, 59, 59, date('n', $selected_max_date_chart), date('j', $selected_max_date_chart), date('Y', $selected_max_date_chart));

		if ($selected_min_date_chart == $selected_max_date_chart) $selected_min_date_chart = $selected_min_date_chart - 24*60*60;
		
		
		$timezone_format = strtolower (_x('Y-m-d G:i:s', 'timezone date format'));
		$order_date = 'ymd';
		if ($timezone_format=='d-m-y' || $timezone_format=='j-m-y' || $timezone_format=='d-f-y' || $timezone_format=='j-f-y' || $timezone_format=='d-n-y' || $timezone_format=='j-n-y') $order_date = 'dmy';
		if ($timezone_format=='m-d-y' || $timezone_format=='m-j-y' || $timezone_format=='f-d-y' || $timezone_format=='f-j-y' || $timezone_format=='n-d-y' || $timezone_format=='n-j-y') $order_date = 'mdy';
		if ($timezone_format=='y-d-m' || $timezone_format=='y-j-m' || $timezone_format=='y-d-f' || $timezone_format=='y-j-f' || $timezone_format=='y-d-n' || $timezone_format=='y-j-n') $order_date = 'ydm';
	?>
		<div class="stats_filter">
		<form method="post" action="admin.php?page=knews_stats">
			<p><?php _e('From date:','knews'); ?>

			<?php if ($order_date == 'ymd') { ?>

				<select name="year_1"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_min_date_chart)); ?></select>
				<select name="month_1"><?php knews_print_options(1,12,date("m", $selected_min_date_chart)); ?></select>
				<select name="day_1"><?php knews_print_options(1,31,date("d", $selected_min_date_chart)); ?></select>

			<?php } elseif ($order_date == 'dmy') { ?>

			<select name="day_1"><?php knews_print_options(1,31,date("d", $selected_min_date_chart)); ?></select>
			<select name="month_1"><?php knews_print_options(1,12,date("m", $selected_min_date_chart)); ?></select>
			<select name="year_1"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_min_date_chart)); ?></select>
			
			<?php } elseif ($order_date == 'mdy') { ?>

				<select name="month_1"><?php knews_print_options(1,12,date("m", $selected_min_date_chart)); ?></select>
				<select name="day_1"><?php knews_print_options(1,31,date("d", $selected_min_date_chart)); ?></select>
				<select name="year_1"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_min_date_chart)); ?></select>

			<?php } elseif ($order_date == 'ydm') { ?>

				<select name="year_1"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_min_date_chart)); ?></select>
				<select name="day_1"><?php knews_print_options(1,31,date("d", $selected_min_date_chart)); ?></select>
				<select name="month_1"><?php knews_print_options(1,12,date("m", $selected_min_date_chart)); ?></select>

			<?php } ?>
			
			| <?php _e('to date:','knews'); ?>
			
			<?php if ($order_date == 'ymd') { ?>

				<select name="year_2"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_max_date_chart)); ?></select>
				<select name="month_2"><?php knews_print_options(1,12,date("m", $selected_max_date_chart)); ?></select>
				<select name="day_2"><?php knews_print_options(1,31,date("d", $selected_max_date_chart)); ?></select>

			<?php } elseif ($order_date == 'dmy') { ?>

				<select name="day_2"><?php knews_print_options(1,31,date("d", $selected_max_date_chart)); ?></select>
			<select name="month_2"><?php knews_print_options(1,12,date("m", $selected_max_date_chart)); ?></select>
			<select name="year_2"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_max_date_chart)); ?></select>

			<?php } elseif ($order_date == 'mdy') { ?>

				<select name="month_2"><?php knews_print_options(1,12,date("m", $selected_max_date_chart)); ?></select>
				<select name="day_2"><?php knews_print_options(1,31,date("d", $selected_max_date_chart)); ?></select>
				<select name="year_2"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_max_date_chart)); ?></select>

			<?php } elseif ($order_date == 'ydm') { ?>

				<select name="year_2"><?php knews_print_options($select_min_year, $select_max_year, date("Y", $selected_max_date_chart)); ?></select>
				<select name="day_2"><?php knews_print_options(1,31,date("d", $selected_max_date_chart)); ?></select>
				<select name="month_2"><?php knews_print_options(1,12,date("m", $selected_max_date_chart)); ?></select>

			<?php } ?>
	
			<input type="submit" value="<?php _e('Filter','knews');?>" class="button-secondary" /></p>
			<p class="selector"><?php _e('Fast selection:','knews'); if ($fast_select=='all') echo '<strong>';?><a href="admin.php?page=knews_stats&sel=all"><?php _e('All','knews'); ?></a><?php if ($fast_select=='all') echo '</strong>';?> | 
			<?php if ($fast_select=='7') echo '<strong>';?><a href="admin.php?page=knews_stats&sel=7"><?php _e('last 7 days','knews'); ?></a><?php if ($fast_select=='7') echo '</strong>';?> | 
			<?php if ($fast_select=='30') echo '<strong>';?><a href="admin.php?page=knews_stats&sel=30"><?php _e('last 30 days','knews'); ?></a><?php if ($fast_select=='30') echo '</strong>';?> | 
			<?php if ($fast_select=='week') echo '<strong>';?><a href="admin.php?page=knews_stats&sel=week"><?php _e('last week','knews'); ?></a><?php if ($fast_select=='week') echo '</strong>';?> | 
			<?php if ($fast_select=='month') echo '<strong>';?><a href="admin.php?page=knews_stats&sel=month"><?php _e('last month','knews'); ?></a><?php if ($fast_select=='month') echo '</strong>';?></p>
			<?php 
			//Security for CSRF attacks
			wp_nonce_field($knews_nonce_action, $knews_nonce_name); 
			?>
		</form>
		</div>
		<?php
		
		if ($fast_select=='error') {
			echo '<div class="updated"><p>' . __('The date range you have selected is not available.','knews') . '</p></div>';
		}
		/////////////////////////// General users
		
		// Not confirmed users
		$query='SELECT COUNT(state) AS notconf FROM ' . KNEWS_USERS . ' WHERE state=1';
		$results=$wpdb->get_results($query);
		$not_confirmed_users=$results[0]->notconf;

		// Active users
		$query='SELECT COUNT(state) AS active FROM ' . KNEWS_USERS . ' WHERE state=2';
		$results=$wpdb->get_results($query);
		$active_users=$results[0]->active;
		
		// Blocked users
		$query='SELECT COUNT(state) AS blocked FROM ' . KNEWS_USERS . ' WHERE state=3';
		$results=$wpdb->get_results($query);
		$blocked_users=$results[0]->blocked;
		
		// Bounced users
		$query='SELECT COUNT(state) AS bounced FROM ' . KNEWS_USERS . ' WHERE state=4';
		$results=$wpdb->get_results($query);
		$bounced_users=$results[0]->bounced;
		
		$total_users = $not_confirmed_users + $active_users + $blocked_users + $bounced_users;

		?>		
		<h3><span><?php _e('Current status of subscriptions','knews'); ?></span></h3>
		<?php
		if ($total_users != 0) {

		?>
			<div class="table_float">
				<table border="0" cellpadding="0" cellspacing="0" width="350">
					<tr class="alt">
						<td><img src="<?php echo KNEWS_URL; ?>/images/legend_blue.gif" width="13" height="13" alt="1" /> <?php _e('Active users:','knews'); ?></td><td align="right"><?php echo $active_users; ?></td><td align="right"><?php echo knews_safe_percent($active_users, $total_users); ?>%</td>
					</tr>
					<tr>
						<td><img src="<?php echo KNEWS_URL; ?>/images/legend_orange.gif" width="13" height="13" alt="2" /> <?php _e('Not confirmed:','knews'); ?></td><td align="right"><?php echo $not_confirmed_users; ?></td><td align="right"><?php echo knews_safe_percent($not_confirmed_users, $total_users); ?>%</td>
					</tr>
					<tr class="alt">
						<td><img src="<?php echo KNEWS_URL; ?>/images/legend_red.gif" width="13" height="13" alt="3" /> <?php _e('Unsubscribed users:','knews'); ?></td><td align="right"><?php echo $blocked_users; ?></td><td align="right"><?php echo knews_safe_percent($blocked_users, $total_users); ?>%</td>
					</tr>
					<tr>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_gray.gif" width="13" height="13" alt="3" /> <?php _e('Bounced users:','knews'); ?></td><td align="right"><?php echo $bounced_users; ?></td><td align="right"><?php echo knews_safe_percent($bounced_users, $total_users); ?>%</td>
					</tr>
					<tr class="alt">
						<td><img src="<?php echo KNEWS_URL; ?>/images/legend_plus.gif" width="13" height="13" alt="4" /> <?php _e('Total:','knews'); ?></td><td align="right"><?php echo $total_users; ?></td><td>&nbsp;</td>
					</tr>
				</table>
			</div>
			<div class="pie_float" id="status_of_subscribers"></div>
			<div class="clear"></div>
			<script type="text/javascript">
								
				// Set a callback to run when the Google Visualization API is loaded.
				google.setOnLoadCallback(drawChart);
				
				// Callback that creates and populates a data table, 
				// instantiates the pie chart, passes in the data and
				// draws it.
				function drawChart() {
				
				// Create the data table.
				var data = new google.visualization.DataTable();
				data.addColumn('string', 'Topping');
				data.addColumn('number', 'Slices');
				data.addRows([
					['<?php _e('Active users:','knews'); ?>', <?php echo $active_users; ?>],
					['<?php _e('Not confirmed:','knews'); ?>', <?php echo $not_confirmed_users; ?>],
					['<?php _e('Unsubscribed users:','knews'); ?>', <?php echo $blocked_users; ?>],
					['<?php _e('Bounced users:','knews'); ?>', <?php echo $bounced_users; ?>]
				]);
				
				// Set chart options
				var options = { 'title':'', 
								'width':300, 
								'height':240, 
								pieHole: 0.4,
								legend: {position: 'none'},
								chartArea: { left:80, right:20, top:20, bottom:20 },
								backgroundColor: 'transparent',
								colors: ['#2175a8', '#fc8300', '#ff0000', '#525252', '#000000'],
							};
				
				// Instantiate and draw our chart, passing in some options.
				var chart = new google.visualization.PieChart(document.getElementById('status_of_subscribers'));
				chart.draw(data, options);
				}
			</script>
		<?php
			
		} else {
			echo '<div class="updated"><p>' . __('Currently have no subscribers.','knews') . '</p></div>';
		}

		/////////////////////////// Subscriptions / Blocks
		?>
			<h3><span><?php _e('Accumulated sign ups and unsubscribes from date:','knews'); echo ' ' . $Knews_plugin->localize_date($selected_min_date_chart) . ' '; _e('to date:','knews'); echo ' ' . $Knews_plugin->localize_date($selected_max_date_chart); ?></span></h3>
		<?php		

		$cols=21;
		$days = ($selected_max_date_chart - $selected_min_date_chart) / (60 * 60 * 24);
		
	if ($days < 1) {
		
		echo '<div class="error"><p>' . __('You must select a right date range','knews') . '</p></div>';

	} else {
			 
		if ($days < $cols) $cols=$days;
		
		$interval = intval(($days / $cols) * (60 * 60 * 24));
		
		$s_joined=0;
		$s_blocked=0;

		// Subscriptions previous
		$query='SELECT COUNT(joined) AS joined FROM ' . KNEWS_USERS . " WHERE joined < '" . $Knews_plugin->get_mysql_date($selected_min_date_chart) . "'";
		$results=$wpdb->get_results($query);
		$s_joined=$results[0]->joined;
		
		// Blocks previous
		$query='SELECT COUNT(id) AS blocked FROM ' . KNEWS_STATS . " WHERE what=3 AND date < '" . $Knews_plugin->get_mysql_date($selected_min_date_chart) . "'";
		$results=$wpdb->get_results($query);
		$s_blocked=$results[0]->blocked;

		for ($i=0; $i<$cols; $i++) {
			$date1 = $Knews_plugin->get_mysql_date($selected_min_date_chart + $i * $interval);
			$date2 = $Knews_plugin->get_mysql_date($selected_min_date_chart + ($i + 1) * $interval);
			$date_caption[] =  date("d/m/y", $selected_min_date_chart + ($i + 0.5) * $interval);
			
			// Subscriptions
			$query='SELECT COUNT(joined) AS joined FROM ' . KNEWS_USERS . " WHERE joined BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$s_joined += $results[0]->joined;
			$serie1[]=$s_joined;
			
			// Blocks
			$query='SELECT COUNT(id) AS blocked FROM ' . KNEWS_STATS . " WHERE what=3 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$s_blocked += $results[0]->blocked;
			$serie2[]=$s_blocked;

		}
 ?>

<script type="text/javascript">
	//google.load('visualization', '1.1', {'packages':['line', 'corechart']});
	google.setOnLoadCallback(drawChart2);
		
	function drawChart2() {

		var data2 = new google.visualization.arrayToDataTable([
		['Date', '<?php knews_safe_js(__('Sign ups','knews'));  ?>', '<?php knews_safe_js(__('Unsubscriptions','knews')); ?>'],
		<?php for ($x=0; $x<count($serie1); $x++) { ?>
		['<?php echo $date_caption[$x]; ?>',  <?php echo $serie1[$x]; ?>, <?php echo $serie2[$x]; ?>],
		<?php } ?>
		]);
		
		var data3 = new google.visualization.arrayToDataTable([
		['Date', '<?php knews_safe_js(__('Sign ups','knews'));  ?>'],
		<?php for ($x=0; $x<count($serie1); $x++) { ?>
		['<?php echo $date_caption[$x]; ?>',  <?php echo $serie1[$x]; ?>],
		<?php } ?>
		]);

		var data4 = new google.visualization.arrayToDataTable([
		['Date', '<?php knews_safe_js(__('Unsubscriptions','knews')); ?>'],
		<?php for ($x=0; $x<count($serie1); $x++) { ?>
		['<?php echo $date_caption[$x]; ?>', <?php echo $serie2[$x]; ?>],
		<?php } ?>
		]);

		var options = {
			//title: 'Company Performance',
			//curveType: 'function',
			legend: { position: 'right' },
			chartArea: { left:70, right:30, top:30, bottom:10, backgroundColor: '#fff' },
			backgroundColor: '#f9f9f9',
			width: 800,
			height: 400,
			pointSize:6,
			colors: ['#2175a8', '#ff0000'],
			vAxis: { 
				viewWindowMode:'explicit',
				viewWindow:{
					min:0
				}
			}
		};
		
		var chart2 = new google.visualization.LineChart(document.getElementById('chart_2'));
		chart2.draw(data2, options);

		var chart3 = new google.visualization.LineChart(document.getElementById('chart_3'));
		chart3.draw(data3, options);

		options.colors = new Array('#ff0000');
		var chart4 = new google.visualization.LineChart(document.getElementById('chart_4'));
		chart4.draw(data4, options);
		
	}
</script>


<script type="text/javascript">
	function view_graph(n_custom, n_lang) {
		jQuery('div.pestanyes_'+n_custom+' a').removeClass('on');
		jQuery('a.link_'+n_custom+'_'+n_lang).addClass('on');
	
		target='div.pregunta_'+n_custom+' > div.on';
		jQuery('div.pregunta_'+n_custom+' > div').css('display','none').removeClass('on').addClass('off');
		jQuery('div.custom_lang_'+n_custom+'_'+n_lang).css('display','block').addClass('on').removeClass('off');
	}
</script>
 		<div class="pestanyes pestanyes_1">
			<a onclick="view_graph(1,1); return false;" class="link_1_1 on" href="#"><?php _e('Sign Ups & Blocks','knews'); ?></a>
			<a onclick="view_graph(1,2); return false;" class="link_1_2" href="#"><img src="<?php echo KNEWS_URL; ?>/images/legend_blue.gif" width="13" height="13" alt="1" /> <?php _e('Sign ups','knews'); ?></a>
			<a onclick="view_graph(1,3); return false;" class="link_1_3" href="#"><img src="<?php echo KNEWS_URL; ?>/images/legend_red.gif" width="13" height="13" alt="2" /> <?php _e('Unsubscriptions','knews'); ?></a>
		</div>
		<div class="pregunta pregunta_1">
			<div id="chart_2" class="custom_lang_1_1 on"></div>
			<div id="chart_3" class="custom_lang_1_2 off"></div>
			<div id="chart_4" class="custom_lang_1_3 off"></div>
		</div>
<?php

/* ------------------------------------------------------------------------------------------ */

		$enviaments_ok=0;
		$enviaments_error=0;
		$cant_read=0;
		$blocks=0;
		$clicks=0;
			$mobile=0;
		$opens=0;
			$sbounced=0;
			$hbounced=0;

		for ($i=0; $i<$cols; $i++) {
			$date1 = $Knews_plugin->get_mysql_date($selected_min_date_chart + $i * $interval);
				$date2_num = $selected_min_date_chart + ($i + 1) * $interval-1;
			$date2 = $Knews_plugin->get_mysql_date($date2_num);
			
			// Enviaments OK i Error
			$query='SELECT users_ok, users_error FROM ' . KNEWS_NEWSLETTERS_SUBMITS . " WHERE blog_id=" . get_current_blog_id() . " AND start_time BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$e_ok=0;
			$e_err=0;
			foreach ($results as $r) {
				$e_ok += $r->users_ok;
				$e_err += $r->users_error;
			}
			$enviaments_ok += $e_ok;
			$enviaments_error += $e_err;
			$e_serie1[] = $e_ok;
			$e_serie2[] = $e_err;

			// Cant read
			$query='SELECT COUNT(*) AS cant_read FROM ' . KNEWS_STATS . " WHERE what = 2 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$cant_read += $results[0]->cant_read;
			$e_serie3[] = $results[0]->cant_read;

			// Block
			$query='SELECT COUNT(*) AS blocks FROM ' . KNEWS_STATS . " WHERE what = 3 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$blocks += $results[0]->blocks;
			$e_serie4[] = $results[0]->blocks;

			// Click
			$query='SELECT COUNT(*) AS clicks FROM ' . KNEWS_STATS . " WHERE what = 1 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			$results=$wpdb->get_results($query);
			$clicks += $results[0]->clicks;
			$e_serie5[] = $results[0]->clicks;

			// Opened
			if ($date2_num < $min_tracking) {
				$query='SELECT COUNT(*) AS opens FROM ' . KNEWS_STATS . " WHERE what = 1 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			} else {
					$query='SELECT COUNT(*) AS opens FROM ' . KNEWS_STATS . " WHERE what = 7 AND date BETWEEN '" . $date1 . "' AND '" . $date2 . "'";
			}
			$results=$wpdb->get_results($query);
			$opens += $results[0]->opens;
			$e_serie6[] = $results[0]->opens;
		}
?>
	<script type="text/javascript">
		google.setOnLoadCallback(drawChart3);
			
		function drawChart3() {
			var data5 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Sendings OK','knews')); ?>', '<?php knews_safe_js(__('Opened','knews')); ?>', '<?php knews_safe_js(__('Sendings Error','knews')); ?>', '<?php knews_safe_js(__('Link clicks','knews')); ?>', '<?php knews_safe_js(__('Cant read','knews')); ?>', '<?php knews_safe_js(__('Unsubscriptions','knews')); ?>'<?php
			
			if ($Knews_plugin->im_pro()) {
				echo ", '";
				knews_safe_js(__('Soft bounced','knews'));
				echo "', '";
				knews_safe_js(__('Hard bounced','knews'));
				echo "'";
			}
?>],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie1[$x]; ?>, <?php echo $e_serie6[$x]; ?>, <?php echo $e_serie2[$x]; ?>, <?php echo $e_serie5[$x]; ?>, <?php echo $e_serie3[$x]; ?>, <?php echo $e_serie4[$x]; ?><?php 
			
			if ($Knews_plugin->im_pro()) echo ', ' . $e_serie7[$x] . ', ' . $e_serie8[$x]; 
			
			?>],
			<?php } ?>
			]);

			var options = {
				//title: 'Company Performance',
				//curveType: 'function',
				legend: { position: 'right' },
				chartArea: { left:70, right:30, top:30, bottom:10, backgroundColor: '#fff' },
				backgroundColor: '#f9f9f9',
				width: 800,
				height: 400,
				pointSize:6,
				colors: ['#2175a8', '#24c11c', '#fc8300', '#ff00fd', '#a0cee9', '#ff0000', '#525252', '#000000'],
				vAxis: { 
					viewWindowMode:'explicit',
					viewWindow:{
						min:0
					}
				}
			};
			
			var chart5 = new google.visualization.LineChart(document.getElementById('chart_5'));
			chart5.draw(data5, options);
		
			var data6 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Sendings OK','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie1[$x]; ?>],
			<?php } ?>
			]);
			var chart6 = new google.visualization.LineChart(document.getElementById('chart_6'));
			chart6.draw(data6, options);

			options.colors = new Array('#24c11c');
			var data7 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Opened','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie6[$x]; ?>],
			<?php } ?>
			]);
			var chart7 = new google.visualization.LineChart(document.getElementById('chart_7'));
			chart7.draw(data7, options);

			options.colors = new Array('#fc8300');
			var data8 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Sendings Error','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie2[$x]; ?>],
			<?php } ?>
			]);
			var chart8 = new google.visualization.LineChart(document.getElementById('chart_8'));
			chart8.draw(data8, options);

			options.colors = new Array('#ff00fd');
			var data9 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Link clicks','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie5[$x]; ?>],
			<?php } ?>
			]);
			var chart9 = new google.visualization.LineChart(document.getElementById('chart_9'));
			chart9.draw(data9, options);

			options.colors = new Array('#a0cee9');
			var data10 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Cant read','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie3[$x]; ?>],
			<?php } ?>
			]);
			var chart10 = new google.visualization.LineChart(document.getElementById('chart_10'));
			chart10.draw(data10, options);

			options.colors = new Array('#ff0000');
			var data11 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Unsubscriptions','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie4[$x]; ?>],
			<?php } ?>
			]);
			var chart11 = new google.visualization.LineChart(document.getElementById('chart_11'));
			chart11.draw(data11, options);
<?php
if ($Knews_plugin->im_pro()) {
?>
			options.colors = new Array('#525252');
			var data12 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Soft bounced','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie7[$x]; ?>],
			<?php } ?>
			]);
			var chart12 = new google.visualization.LineChart(document.getElementById('chart_12'));
			chart12.draw(data12, options);

			options.colors = new Array('#000000');
			var data13 = new google.visualization.arrayToDataTable([
			['Date', '<?php knews_safe_js(__('Hard bounced','knews')); ?>'],
			<?php for ($x=0; $x<count($e_serie1); $x++) { ?>
			['<?php echo $date_caption[$x]; ?>',  <?php echo $e_serie8[$x]; ?>],
			<?php } ?>
			]);
			var chart13 = new google.visualization.LineChart(document.getElementById('chart_13'));
			chart13.draw(data13, options);
<?php
}
?>
		}
	</script>
<?php

	?>
		<p>&nbsp;</p>
			<h3><span><?php _e('Newsletters & clicks from date:','knews'); echo ' ' . $Knews_plugin->localize_date($selected_min_date_chart) . ' '; _e('to date:','knews'); echo ' ' . $Knews_plugin->localize_date($selected_max_date_chart); ?></span></h3>
 		<div class="pestanyes pestanyes_2">
			<a onclick="view_graph(2,1); return false;" class="link_2_1 on" href="#"><?php _e('All','knews'); ?></a>
			<a onclick="view_graph(2,2); return false;" class="link_2_2" href="#" title="<?php _e('Sendings OK','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_blue.gif" width="13" height="13" alt="1" /> <?php echo knews_hardCut(__('Sendings OK','knews')); ?></a>
			<a onclick="view_graph(2,3); return false;" class="link_2_3" href="#" title="<?php _e('Opened','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_green.gif" width="13" height="13" alt="1" /> <?php echo knews_hardCut(__('Opened','knews')); ?></a>
			<a onclick="view_graph(2,4); return false;" class="link_2_4" href="#" title="<?php _e('Sendings Error','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_orange.gif" width="13" height="13" alt="2" /> <?php echo knews_hardCut(__('Sendings Error','knews')); ?></a>
			<a onclick="view_graph(2,5); return false;" class="link_2_5" href="#" title="<?php _e('Link clicks','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_magenta.gif" width="13" height="13" alt="5" /> <?php echo knews_hardCut(__('Link clicks','knews')); ?></a>
			<a onclick="view_graph(2,6); return false;" class="link_2_6" href="#" title="<?php _e('Cant read','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_cian.gif" width="13" height="13" alt="3" /> <?php echo knews_hardCut(__('Cant read','knews')); ?></a>
			<a onclick="view_graph(2,7); return false;" class="link_2_7" href="#" title="<?php _e('Unsubscriptions','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_red.gif" width="13" height="13" alt="4" /> <?php echo knews_hardCut(__('Unsubscriptions','knews')); ?></a>
<?php
if ($Knews_plugin->im_pro()) {
?>
		<a onclick="view_graph(2,8); return false;" class="link_2_8" href="#" title="<?php _e('Soft Bounced','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_gray.gif" width="13" height="13" alt="4" /> <?php echo knews_hardCut(__('Soft bounced','knews')); ?></a>
		<a onclick="view_graph(2,9); return false;" class="link_2_9" href="#" title="<?php _e('Hard Bounced','knews'); ?>"><img src="<?php echo KNEWS_URL; ?>/images/legend_black.gif" width="13" height="13" alt="4" /> <?php echo knews_hardCut(__('Hard bounced','knews')); ?></a>
<?php
}
?>
		</div>
		<div class="pregunta pregunta_2">
		<div id="chart_5" class="custom_lang_2_1 on"></div>
		<div id="chart_6" class="custom_lang_2_2 off"></div>
		<div id="chart_7" class="custom_lang_2_3 off"></div>
		<div id="chart_8" class="custom_lang_2_4 off"></div>
		<div id="chart_9" class="custom_lang_2_5 off"></div>
		<div id="chart_10" class="custom_lang_2_6 off"></div>
		<div id="chart_11" class="custom_lang_2_7 off"></div>
<?php
if ($Knews_plugin->im_pro()) {
?>
		<div id="chart_12" class="custom_lang_2_8 off"></div>
		<div id="chart_13" class="custom_lang_2_9 off"></div>
<?php
}
?>
		</div>
			<div style="padding:20px 0;">
				<table border="0" cellpadding="0" cellspacing="0">
				<tr class="alt">
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_blue.gif" width="13" height="13" alt="1" /> <?php _e('Sendings OK','knews'); ?>:</td><td align="right"><?php echo $enviaments_ok; ?></td><td align="right"><?php echo knews_safe_percent($enviaments_ok, $enviaments_ok + $enviaments_error); ?>%</td>
					<td width="20">&nbsp;</td>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_green.gif" width="13" height="13" alt="2" /> <?php _e('Opened','knews'); ?>:</td><td align="right"><?php echo $opens; ?></td><td align="right"><?php echo knews_safe_percent($opens, $enviaments_ok + $enviaments_error); ?>%</td>
						<td width="20">&nbsp;</td>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_red.gif" width="13" height="13" alt="5" /> <?php _e('Unsubscriptions','knews'); ?>:</td><td align="right"><?php echo $blocks; ?></td><td align="right"><?php echo knews_safe_percent($blocks, $enviaments_ok + $enviaments_error); ?>%</td>
				</tr>
				<tr>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_orange.gif" width="13" height="13" alt="3" /> <?php _e('Sendings Error','knews'); ?>:</td><td align="right"><?php echo $enviaments_error; ?></td><td align="right"><?php echo knews_safe_percent($enviaments_error, $enviaments_ok + $enviaments_error); ?>%</td>
					<td>&nbsp;</td>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_magenta.gif" width="13" height="13" alt="6" /> <?php _e('Link clicks','knews'); ?>:</td><td align="right"><?php echo $clicks; ?></td><td align="right"><?php echo knews_safe_percent($clicks, $enviaments_ok + $enviaments_error); ?>%</td>
						<td width="20">&nbsp;</td>
					<td></td><td align="right"></td>
				</tr>
				<tr class="alt">
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_plus.gif" width="13" height="13" alt="4" /> <?php _e('Total submits','knews'); ?>:</td><td align="right"><?php echo ($enviaments_ok + $enviaments_error); ?></td><td align="right">&nbsp;</td>
					<td>&nbsp;</td>
					<td><img src="<?php echo KNEWS_URL; ?>/images/legend_cian.gif" width="13" height="13" alt="4" /> <?php _e('Cant read','knews'); ?>:</td><td align="right"><?php echo $cant_read; ?></td>
<?php //_e('Total clicks','knews'); ?></td><td align="right"><?php echo knews_safe_percent($cant_read, $enviaments_ok + $enviaments_error); ?>%<?php //echo $clicks; ?></td>
						<td width="20">&nbsp;</td>
					<td></td><td align="right"></td><td align="right"></td>
				</tr>
			</table>
		</div>
<?php
	}
?>
	<form method="post" action="admin.php?page=knews_stats">
	<p><input type="checkbox" name="knews_reset_stats" class="knews_on_off align_left" value="1" autocomplete="off" /><label><strong>Reset stats. <span style="color:#e00;">Warning:</span></strong> this action delete all statistic data and <strong>all done submissions data</strong> and can't be recovered. </label></p>
<?php
	//Security for CSRF attacks
	wp_nonce_field($knews_nonce_action, $knews_nonce_name); 
?>
		<div class="submit">
			<input type="submit" name="reset_KnewsStats" id="reset_KnewsStats" value="<?php _e('Reset Stats','knews');?>" class="button-primary" />
		</div>
	</form>
	<?php
}
?>
</div>