0) $moreCond .= " and p.ID = ".wpdm_query_var('pid', 'int'); if(wpdm_query_var('uid') > 0) $moreCond .= " and s.uid = ".wpdm_query_var('uid', 'int'); if(wpdm_query_var('ip') != '' && get_option('__wpdm_noip') == 0) $moreCond .= " and s.ip = '".esc_sql(wpdm_query_var('ip', 'txt'))."'"; $res = $wpdb->get_results("select p.ID as pid,p.post_title,s.* from {$wpdb->prefix}posts p, {$wpdb->prefix}ahm_download_stats s where s.pid = p.ID $moreCond order by `timestamp` desc limit $start, $items_per_page"); foreach($res as $stat){ ?>


post_title; ?> \|	timestamp + (get_option('gmt_offset') * 3600))); ?>	uid > 0?"".get_user_by('id', $stat->uid)->display_name . " ".((get_option('__wpdm_noip') == 0)?' / ':''):''; ?> ip; ?>
1 ? $current = (int)$_GET['pgd'] : $current = 1; $pagination = array( 'base' => @add_query_arg('pgd','%#%'), 'format' => '', 'total' => ceil($wpdb->get_var("select count(*) from {$wpdb->prefix}ahm_download_stats")/$items_per_page), 'current' => $current, 'show_all' => false, 'type' => 'list', 'prev_next' => True, 'prev_text' => ' Previous', 'next_text' => 'Next ', ); //if( $wp_rewrite->using_permalinks() && !is_search()) // $pagination['base'] = user_trailingslashit( trailingslashit( remove_query_arg('s',get_pagenum_link(1) ) ) . 'paged=%#%', 'paged'); if( !empty($wp_query->query_vars['s']) ) $pagination['add_args'] = array('s'=>get_query_var('s')); echo ' ' . str_replace(' ',' ', paginate_links($pagination)) . ' '; ?>