Download History

get_results("select p.post_title,s.* from {$wpdb->prefix}posts p, {$wpdb->prefix}ahm_download_stats s where s.uid = '{$current_user->ID}' and s.pid = p.ID order by `timestamp` desc limit $start, $items_per_page"); foreach($res as $stat){ ?>


post_title; ?>	timestamp); ?>	ip; ?>

1 ? $current = $_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 where uid = '{$current_user->ID}'")/$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)) . '

'; ?>