From b3536a5823d25847df08ba5a1775853793b54e8a Mon Sep 17 00:00:00 2001 From: ozhozh Date: Tue, 24 Nov 2009 21:30:11 +0000 Subject: [PATCH] Part of Base 62 fix (issue 164) git-svn-id: http://yourls.googlecode.com/svn/trunk@245 12232710-3e20-11de-b438-597f59cd7555 --- yourls-infos.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/yourls-infos.php b/yourls-infos.php index 97e21be..5938894 100644 --- a/yourls-infos.php +++ b/yourls-infos.php @@ -33,12 +33,12 @@ if( $aggregate ) { $keywords = join( "', '", $keyword_list ); // Fetch information for all keywords pointing to $longurl - $hits = $ydb->get_results( "SELECT `shorturl`, `click_time`, `referrer`, `user_agent`, `country_code` FROM `$table` WHERE `shorturl` IN ( '$keywords' );" ); + $hits = $ydb->get_results( "SELECT `keyword`, `click_time`, `referrer`, `user_agent`, `country_code` FROM `$table` WHERE `keyword` IN ( '$keywords' );" ); } else { // Fetch information for current keyword only - $hits = $ydb->get_results( "SELECT `click_time`, `referrer`, `user_agent`, `country_code` FROM `$table` WHERE `shorturl` = '$keyword';" ); + $hits = $ydb->get_results( "SELECT `click_time`, `referrer`, `user_agent`, `country_code` FROM `$table` WHERE `keyword` = '$keyword';" ); } - + $referrers = array(); $direct = $notdirect = 0; $countries = array(); -- 2.45.0