• Počet návštev
• Návštevy za mesiac
• Hodinové návštevy za mesiac
• Operačné systémy celkom
• Prehliadače celkom - percentuálne
• Hosty celkom - top 10
• Stránky za deň - top 10

Nasledujúci PHP skript používa záznamy modulu VTS (Visitors Tracking System) na určenie celkového počtu návštev stránok. V premennej $client_id je potrebné nastaviť číslo klienta podľa VTS. Skritp môže byť vložený na stránke ako obsahový element.

<?php 

function countVisitors( $client_id = 1 ) {

	$query = '
		SELECT COUNT(*) AS total_visitors, client_id, 
			COUNT(DISTINCT(visitor_id)) AS total_unique,
			(COUNT(*) - COUNT(DISTINCT(visitor_id))) AS total_returning,
			\'total\' AS total  
		FROM tx_dephpot_pot_visitors  
		WHERE client_id = '.$client_id.'
		GROUP BY total
	';
		
	$res = mysql( TYPO3_db, $query );
	if( $res )
		$row = mysql_fetch_assoc( $res );
	return $row;
}
	
// Configuration
$client_id = 3;
$countTotal = countVisitors( $client_id );

// Output
$out = 'Počet návštev: '.$countTotal['total_visitors'];
echo $out;

?>

Parametre

• ID klienta = 1
• rok a mesiac = '200802'

SELECT FROM_UNIXTIME( `timestamp`, '%Y%m') AS unixtime ,
	COUNT(*) AS total_visitors,
	COUNT(DISTINCT(visitor_id)) AS total_unique,
	(COUNT(*) - COUNT(DISTINCT(visitor_id))) AS total_returning,
	'total' AS total	
FROM tx_dephpot_pot_visitors 	
WHERE client_id = 1
	AND FROM_UNIXTIME( `timestamp`, '%Y%m') = '200802'
GROUP BY total

Výstup

Parametre

• ID klienta
• rok a mesiac

SELECT FROM_UNIXTIME( `timestamp`, '%H') AS `hour`,
	COUNT(*) AS total_visitors,
	COUNT(DISTINCT(visitor_id)) AS total_unique,
	(COUNT(*) - COUNT(DISTINCT(visitor_id))) AS total_returning	 
FROM tx_dephpot_pot_visitors 	
WHERE client_id = 1
	AND FROM_UNIXTIME( `timestamp`, '%Y%m') = '200802'
GROUP BY `hour`

Výstup

Parametre

• ID klienta

SELECT tx_dephpot_pot_operating_systems.string AS title,
	COUNT(*) AS operating_systems
FROM tx_dephpot_pot_visitors 
	JOIN tx_dephpot_pot_operating_systems 
		ON tx_dephpot_pot_operating_systems.data_id = tx_dephpot_pot_visitors.operating_system_id
WHERE tx_dephpot_pot_visitors.client_id = 1
GROUP BY tx_dephpot_pot_operating_systems.data_id
ORDER BY operating_systems DESC

Výsledok

Parametre

• ID klienta

SET @sum_value = ( SELECT SUM(user_agents) AS `sum` FROM (
	SELECT tx_dephpot_pot_user_agents.string AS title,
		COUNT(*) AS user_agents
	FROM tx_dephpot_pot_visitors 
		JOIN tx_dephpot_pot_user_agents 
			ON tx_dephpot_pot_user_agents.data_id = tx_dephpot_pot_visitors.user_agent_id
	WHERE tx_dephpot_pot_visitors.client_id = 1
	GROUP BY tx_dephpot_pot_user_agents.data_id
	ORDER BY user_agents DESC
	LIMIT 20
) AS count );

SELECT tx_dephpot_pot_user_agents.string AS title,
	COUNT(*) AS user_agents,
	ROUND( ( COUNT(*) / @sum_value * 100 ), 2 ) AS per,
	@sum_value AS summary	
FROM tx_dephpot_pot_visitors 
	JOIN tx_dephpot_pot_user_agents 
		ON tx_dephpot_pot_user_agents.data_id = tx_dephpot_pot_visitors.user_agent_id
WHERE tx_dephpot_pot_visitors.client_id = 1
GROUP BY tx_dephpot_pot_user_agents.data_id
ORDER BY user_agents DESC
LIMIT 20;

Výsledok

Parametre

• ID klienta

SELECT tx_dephpot_pot_hostnames.string AS title,
	COUNT(*) AS hostnames
FROM tx_dephpot_pot_visitors 
	JOIN tx_dephpot_pot_hostnames 
		ON tx_dephpot_pot_hostnames.data_id = tx_dephpot_pot_visitors.host_id 
WHERE tx_dephpot_pot_visitors.client_id = 1
GROUP BY tx_dephpot_pot_hostnames.data_id
ORDER BY hostnames DESC
LIMIT 10

Výsledok

Parametre

• ID klienta
• rok, mesiac, deň

SELECT pages.title AS title,
	tx_dephpot_pot_documents.string AS uid,
	tx_dephpot_pot_documents.document_url AS document_url,
	COUNT(*) AS documents
FROM tx_dephpot_pot_documents 
	JOIN pages 
		ON pages.uid = tx_dephpot_pot_documents.string  
	JOIN tx_dephpot_pot_accesslog 
		ON tx_dephpot_pot_documents.data_id = tx_dephpot_pot_accesslog.document_id  
	JOIN tx_dephpot_pot_visitors 
		ON tx_dephpot_pot_visitors.accesslog_id = tx_dephpot_pot_accesslog.accesslog_id  
WHERE tx_dephpot_pot_visitors.client_id = 1
	AND FROM_UNIXTIME( tx_dephpot_pot_visitors.timestamp, '%Y%m%d') = '20080229'
GROUP BY tx_dephpot_pot_documents.data_id
ORDER BY documents DESC
LIMIT 10

Výsledok

Dotaz zabral 0.3171 sekúnd