<?
session_start();
$yearpostfix = date('Y');
if(!empty($_GET['id'])) {
	include_once('includes/sql.php');
	include_once('includes/functions.php');
	$id = empty($_GET['id']) ? '' : mysql_real_escape_string($_GET['id']);
	$counterquery = mysql_query("SELECT id, hiddenstats FROM counters WHERE id = '$id'") or die(mysql_error());
	if(mysql_num_rows($counterquery) != 0) {
		$row = mysql_fetch_assoc($counterquery);
		if(userallowed()) {
			if($_GET['type'] == '1') {
				header("Content-type: application/csv");
				header("Content-Disposition: inline; filename=file_".time().".csv");
				$fieldnames = array('Dato', 'Besøg', 'Sidevisninger');
				for($x = 0; $x < count($fieldnames); $x++) {
					echo $fieldnames[$x].";";
				}
				echo "\r\n";
				
				$query = mysql_query("SELECT u.time, SUM( u.hour0 + u.hour1 + u.hour2 + u.hour3 + u.hour4 + u.hour5 + u.hour6 + u.hour7 + u.hour8 + u.hour9 + u.hour10 + u.hour11 + u.hour12 + u.hour13 + u.hour14 + u.hour15 + u.hour16 + u.hour17 + u.hour18 + u.hour19 + u.hour20 + u.hour21 + u.hour22 + u.hour23 ) AS hits, SUM( p.hour0 + p.hour1 + p.hour2 + p.hour3 + p.hour4 + p.hour5 + p.hour6 + p.hour7 + p.hour8 + p.hour9 + p.hour10 + p.hour11 + p.hour12 + p.hour13 + p.hour14 + p.hour15 + p.hour16 + p.hour17 + p.hour18 + p.hour19 + p.hour20 + p.hour21 + p.hour22 + p.hour23 )  as views FROM uniquehits_2009 as u, pageviews_2009 as p WHERE u.counterid = '$id' AND p.counterid = '$id' AND p.time = u.time GROUP BY u.time ORDER BY u.time ASC") or die(mysql_error());
				if(mysql_num_rows($query) > 0) {					
					while($row = mysql_fetch_row($query)) {
						for($x = 0; $x < count($row); $x++) {
							if(mysql_fetch_field($query, $x)->name == 'time') {
								echo date("d-m-Y", $row[$x]);
							} else {
								echo $row[$x];
							}
							if(count($row) - 1 != $x) echo ";";
						}
						echo "\r\n";
					}
				}
				$query = mysql_query("SELECT u.time, SUM( u.hour0 + u.hour1 + u.hour2 + u.hour3 + u.hour4 + u.hour5 + u.hour6 + u.hour7 + u.hour8 + u.hour9 + u.hour10 + u.hour11 + u.hour12 + u.hour13 + u.hour14 + u.hour15 + u.hour16 + u.hour17 + u.hour18 + u.hour19 + u.hour20 + u.hour21 + u.hour22 + u.hour23 ) AS hits, SUM( p.hour0 + p.hour1 + p.hour2 + p.hour3 + p.hour4 + p.hour5 + p.hour6 + p.hour7 + p.hour8 + p.hour9 + p.hour10 + p.hour11 + p.hour12 + p.hour13 + p.hour14 + p.hour15 + p.hour16 + p.hour17 + p.hour18 + p.hour19 + p.hour20 + p.hour21 + p.hour22 + p.hour23 )  as views FROM uniquehits_2010 as u, pageviews_2010 as p WHERE u.counterid = '$id' AND p.counterid = '$id' AND p.time = u.time GROUP BY u.time ORDER BY u.time ASC") or die(mysql_error());
				if(mysql_num_rows($query) > 0) {					
					while($row = mysql_fetch_row($query)) {
						for($x = 0; $x < count($row); $x++) {
							if(mysql_fetch_field($query, $x)->name == 'time') {
								echo date("d-m-Y", $row[$x]);
							} else {
								echo $row[$x];
							}
							if(count($row) - 1 != $x) echo ";";
						}
						echo "\r\n";
					}
				}
				$query = mysql_query("SELECT u.time, SUM( u.hour0 + u.hour1 + u.hour2 + u.hour3 + u.hour4 + u.hour5 + u.hour6 + u.hour7 + u.hour8 + u.hour9 + u.hour10 + u.hour11 + u.hour12 + u.hour13 + u.hour14 + u.hour15 + u.hour16 + u.hour17 + u.hour18 + u.hour19 + u.hour20 + u.hour21 + u.hour22 + u.hour23 ) AS hits, SUM( p.hour0 + p.hour1 + p.hour2 + p.hour3 + p.hour4 + p.hour5 + p.hour6 + p.hour7 + p.hour8 + p.hour9 + p.hour10 + p.hour11 + p.hour12 + p.hour13 + p.hour14 + p.hour15 + p.hour16 + p.hour17 + p.hour18 + p.hour19 + p.hour20 + p.hour21 + p.hour22 + p.hour23 )  as views FROM uniquehits_2011 as u, pageviews_2011 as p WHERE u.counterid = '$id' AND p.counterid = '$id' AND p.time = u.time GROUP BY u.time ORDER BY u.time ASC") or die(mysql_error());
				if(mysql_num_rows($query) > 0) {					
					while($row = mysql_fetch_row($query)) {
						for($x = 0; $x < count($row); $x++) {
							if(mysql_fetch_field($query, $x)->name == 'time') {
								echo date("d-m-Y", $row[$x]);
							} else {
								echo $row[$x];
							}
							if(count($row) - 1 != $x) echo ";";
						}
						echo "\r\n";
					}
				}
				$query = mysql_query("SELECT u.time, SUM( u.hour0 + u.hour1 + u.hour2 + u.hour3 + u.hour4 + u.hour5 + u.hour6 + u.hour7 + u.hour8 + u.hour9 + u.hour10 + u.hour11 + u.hour12 + u.hour13 + u.hour14 + u.hour15 + u.hour16 + u.hour17 + u.hour18 + u.hour19 + u.hour20 + u.hour21 + u.hour22 + u.hour23 ) AS hits, SUM( p.hour0 + p.hour1 + p.hour2 + p.hour3 + p.hour4 + p.hour5 + p.hour6 + p.hour7 + p.hour8 + p.hour9 + p.hour10 + p.hour11 + p.hour12 + p.hour13 + p.hour14 + p.hour15 + p.hour16 + p.hour17 + p.hour18 + p.hour19 + p.hour20 + p.hour21 + p.hour22 + p.hour23 )  as views FROM uniquehits_2012 as u, pageviews_2012 as p WHERE u.counterid = '$id' AND p.counterid = '$id' AND p.time = u.time GROUP BY u.time ORDER BY u.time ASC") or die(mysql_error());
				if(mysql_num_rows($query) > 0) {					
					while($row = mysql_fetch_row($query)) {
						for($x = 0; $x < count($row); $x++) {
							if(mysql_fetch_field($query, $x)->name == 'time') {
								echo date("d-m-Y", $row[$x]);
							} else {
								echo $row[$x];
							}
							if(count($row) - 1 != $x) echo ";";
						}
						echo "\r\n";
					}
				}
				$query = mysql_query("SELECT u.time, SUM( u.hour0 + u.hour1 + u.hour2 + u.hour3 + u.hour4 + u.hour5 + u.hour6 + u.hour7 + u.hour8 + u.hour9 + u.hour10 + u.hour11 + u.hour12 + u.hour13 + u.hour14 + u.hour15 + u.hour16 + u.hour17 + u.hour18 + u.hour19 + u.hour20 + u.hour21 + u.hour22 + u.hour23 ) AS hits, SUM( p.hour0 + p.hour1 + p.hour2 + p.hour3 + p.hour4 + p.hour5 + p.hour6 + p.hour7 + p.hour8 + p.hour9 + p.hour10 + p.hour11 + p.hour12 + p.hour13 + p.hour14 + p.hour15 + p.hour16 + p.hour17 + p.hour18 + p.hour19 + p.hour20 + p.hour21 + p.hour22 + p.hour23 )  as views FROM uniquehits_2013 as u, pageviews_2013 as p WHERE u.counterid = '$id' AND p.counterid = '$id' AND p.time = u.time GROUP BY u.time ORDER BY u.time ASC") or die(mysql_error());
				if(mysql_num_rows($query) > 0) {					
					while($row = mysql_fetch_row($query)) {
						for($x = 0; $x < count($row); $x++) {
							if(mysql_fetch_field($query, $x)->name == 'time') {
								echo date("d-m-Y", $row[$x]);
							} else {
								echo $row[$x];
							}
							if(count($row) - 1 != $x) echo ";";
						}
						echo "\r\n";
					}
				}
			} elseif($_GET['type'] == '2') {
				header("Content-type: application/csv");
				header("Content-Disposition: inline; filename=file_".time().".csv");
				$query = mysql_query("SELECT count(id) AS antal, searchword FROM refsearch WHERE counterid = ".$id." GROUP BY searchword ORDER BY antal DESC LIMIT 100") or die(mysql_error());
				$total = mysql_result(mysql_query("SELECT COUNT(id) FROM refsearch WHERE counterid = ".$id), 0);
				echo "Nr;Antal;Procent;Søgeord\r\n";
				$i = 1;
				while($row = mysql_fetch_assoc($query)) {
					echo $i.';';
					echo $row['antal'].';';
					$procent = round($row['antal'] / $total * 100, 2);
					$procent = str_replace('.', ',', $procent);
					echo $procent.'%;';
					echo $row['searchword'];
					echo "\r\n";
					$i++;
				}
			}
		}
	}
} else {
	header('Location: /');
}
?>