Popular Links
HTML;
function show_top($numdays,$numlinks) {
global $ydb;
$base = YOURLS_SITE;
$table_url = YOURLS_DB_TABLE_URL;
//
$links = '';
$query = $ydb->get_results("SELECT title, timestamp, url, keyword, clicks FROM `$table_url` WHERE timestamp >= SUBDATE(CURDATE(), $numdays) order by clicks desc limit $numlinks");
if ($query) {
foreach( $query as $query_result ) {
$thisURLArray = parse_url(stripslashes($query_result->url));
$diff = abs( time() - strtotime( $query_result->timestamp ) );
$days = floor( $diff / (60*60*24) );
if( $days <1) {
$created = 'today';
}
else if( $days <2) {
$created = ' 1 day ago';
}
else {
$created = $days. ' days ago';
}
$links .= '(' . $query_result->clicks . ') - ' .$thisURLArray[host] .' - ';
$links .= str_replace('www.', '', $query_result->title) . ' Created ' . $created . '
';
}
}
echo '