get_results( "SELECT `click_time`, `referrer`, `user_agent`, `country_code` FROM `$table` WHERE `shorturl` = '$keyword';" );
$referrers = array();
$direct = 0;
$countries = array();
$dates = array();
// Loop through all results and build list of referrers, countries and hits per day
foreach( $hits as $hit ) {
extract( (array)$hit );
if ( isset( $country_code ) && $country_code ) {
if( !array_key_exists( $country_code, $countries ) )
$countries[$country_code] = 0;
$countries[$country_code]++;
}
if( isset( $referrer ) ) {
if ( $referrer == 'direct' ) {
$direct++;
} else {
$parse = parse_url( $referrer );
$host = $parse['host'];
unset( $parse );
if( !array_key_exists( $host, $referrers ) )
$referrers[$host] = array( );
if( !array_key_exists( $referrer, $referrers[$host] ) )
$referrers[$host][$referrer] = 0;
$referrers[$host][$referrer]++;
}
}
if( isset( $click_time ) ) {
preg_match('/(\d+)-(\d+)-(\d+)\s(\d+):(\d+):(\d+)/', $click_time, $matches);
list( $temp, $year, $month, $day ) = $matches;
unset( $matches );
if( !array_key_exists( $year, $dates ) )
$dates[$year] = array();
if( !array_key_exists( $month, $dates[$year] ) )
$dates[$year][$month] = array();
if( !array_key_exists( $day, $dates[$year][$month] ) )
$dates[$year][$month][$day] = 0;
$dates[$year][$month][$day]++;
}
}
// Sort dates, chronologically from [2007][12][24] to [2009][02][19]
ksort( $dates );
foreach( $dates as $year=>$months ) {
ksort( $dates[$year] );
foreach( $months as $month=>$day ) {
ksort( $dates[$year][$month] );
}
}
// Sort countries, most frequent first
if ( $countries )
arsort( $countries );
// Sort referrers. $referrer_sort is a array of most frequent domains
arsort( $referrers );
$referrer_sort = array();
foreach( $referrers as $site => $urls ) {
if( count($urls) > 1 )
$referrer_sort[$site] = array_sum( $urls );
}
arsort($referrer_sort);
/**
echo "";
echo "referrers: "; print_r( $referrers );
echo "referrer sort: "; print_r( $referrer_sort );
echo "dates: "; print_r( $dates );
echo "countries: "; print_r( $countries );
die();
/**/
yourls_html_head( 'infos' );
?>
Your are logged in as: . Logout
Informations
Short URL:
Long URL:
Number of hits since : hit 1 ? 's' : ''); ?>
Traffic statistics
Best day: hit 1 ? 's' : ''); ?> on .
Click for more details
$months ) {
foreach( $months as $month=>$days) {
foreach( $days as $day=>$visits ) {
echo '- '.date("F j, Y", strtotime("$year-$month-$day"))." : $visits ".yourls_plural( 'hit', $visits )."
\n";
}
}
}
?>
Traffic location
|
Top 5 countries. Click for more details
$count ) {
echo "![](".yourls_geo_get_flag( $code ).") $code (".yourls_geo_countrycode_to_countryname( $code ).") : $count ".yourls_plural('hit', $count)."
|
Overall traffic
|
Traffic sources
- Direct:
$count ) {
$i++;
echo "- $site: $count. Details
\n";
echo "";
foreach( $referrers[$site] as $url => $count ) {
echo "- "; yourls_html_link($url); echo ": $count
\n";
}
echo "
\n";
unset( $referrers[$site] );
}
echo "- Various: ". count( $referrers ). " Details
\n";
echo "";
foreach( $referrers as $url ) {
echo "- "; yourls_html_link(key($url)); echo ": 1
\n";
}
echo "
\n"
?>
