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( (array)$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 { $host = yourls_get_domain( $referrer ); 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(); $number_of_sites = count( array_keys( $referrers ) ); foreach( $referrers as $site => $urls ) { if( count($urls) > 1 || $number_of_sites == 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' );
?>

YOURLS: Your Own URL Shortener
YOURLS

Your are logged in as: . Logout

Informations

Short URL:

Long URL:

Number of hits since : hit 1 ? 's' : ''); ?>

Traffic statistics

Number of hits per day

Best day

hit 1 ? 's' : ''); ?> on . Click for more details

No traffic yet. Get some clicks first!

"; } ?>

Traffic location

Top 5 countries

Click for more details

Overall traffic

No country data.

"; } ?>

Traffic Sources

Referrer shares

1 ) $referrer_sort['Others'] = count( $referrers ); yourls_stats_pie( $referrer_sort, 5, '440x220', '902020,FF6060' ); unset( $referrer_sort['Others'] ); ?>

Referrers

    $count ) { $i++; echo "
  • $site: $count (details)
  • \n"; echo "\n"; unset( $referrers[$site] ); } // Any referrer left? Group in "various" if ( $referrers ) { echo "
  • Various: ". count( $referrers ). " (details)
  • \n"; echo "\n"; } ?>

Direct vs Referrer Traffic

$direct, 'Referrers'=> $ref_traffic), 5, '440x220', '902020,FF6060' ); ?>

Direct traffic:

Referrer traffic:

No referrer data.

"; } ?>

Share

Short link', '

Quick Share

'); ?>