prefix . "top_ten_daily"; $is_widget = intval($_GET['widget']); $tptn_settings = tptn_read_options(); $limit = $tptn_settings['limit']; $daily_range = $tptn_settings[daily_range]. ' DAY'; $current_date = $wpdb->get_var("SELECT DATE_ADD(DATE_SUB(CURDATE(), INTERVAL $daily_range), INTERVAL 1 DAY) "); $sql = "SELECT postnumber, SUM(cntaccess) as sumCount, dp_date, ID, post_type, post_status "; $sql .= "FROM $table_name INNER JOIN ". $wpdb->posts ." ON postnumber=ID " ; if ($tptn_settings['exclude_pages']) $sql .= "AND post_type = 'post' "; $sql .= "AND post_status = 'publish' AND dp_date >= '$current_date' "; $sql .= "GROUP BY postnumber "; $sql .= "ORDER BY sumCount DESC LIMIT $limit"; $results = $wpdb->get_results($sql); $output = ''; echo "document.write('".$output."')"; } tptn_daily_lists(); ?>