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
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
No country data."; } ?>
Top 5 countries
Overall traffic
Traffic Sources
No referrer data."; } ?>
Referrer shares
1 ) $referrer_sort['Others'] = count( $referrers ); yourls_stats_pie( $referrer_sort, 5, '440x220', '902020,FF6060' ); unset( $referrer_sort['Others'] ); ?>Referrers
Direct vs Referrer Traffic
$direct, 'Referrers'=> $ref_traffic), 5, '440x220', '902020,FF6060' ); ?>Direct traffic:
Referrer traffic: