<?php
require_once(dirname(dirname(__FILE__))."/php/init.php");
function fs_export_csv($file)
{
	$fsdb = &fs_get_db_conn();
	$file = fopen($file,"w");
	$hits = fs_hits_table();
	$urls = fs_urls_table();
	$useragents = fs_useragents_table();
	
	$offset = 0;
	$page = 1000;
	while(true)
	{
		$rows = $fsdb->get_results("SELECT timestamp,HEX(ip_int1) ip_int1,HEX(ip_int2) ip_int2,u1.site_id,u1.url url,u2.url referer,useragent 
								 	FROM $hits,$urls u1, $urls u2, $useragents ua
								 	WHERE u1.id = url_id AND u2.id = referer_id AND ua.id = useragent_id ORDER BY timestamp LIMIT $offset, $page");
		if ($rows === false)
		{
			echo fs_db_error();
			break;						 
		}
		$c = count($rows);
		$offset += $c;
		if ($c == 0) break;
		foreach($rows as $r)
		{
			$ip = fs_ip_to_string($r->ip_int1, $r->ip_int2);
			fputs($file, "$r->timestamp,$ip,$r->site_id,$r->url,$r->referer,$r->useragent\n");
		}
		flush();
	}
	
	fclose($file);
}

?>