Пример #1
0
function views_post_excerpt($post_excerpt, $post_content, $post_password, $chars = 200)
{
    if (!empty($post_password)) {
        if (!isset($_COOKIE['wp-postpass_' . COOKIEHASH]) || $_COOKIE['wp-postpass_' . COOKIEHASH] != $post_password) {
            return __('There is no excerpt because this is a protected post.', 'wp-postviews');
        }
    }
    if (empty($post_excerpt)) {
        return snippet_text(strip_tags($post_content), $chars);
    } else {
        return $post_excerpt;
    }
}
Пример #2
0
function expand_ratings_template($template, $post_data, $post_ratings_data = null, $max_post_title_chars = 0, $is_main_loop = true)
{
    global $post;
    // Get global variables
    $ratings_image = get_option('postratings_image');
    $ratings_max = intval(get_option('postratings_max'));
    $ratings_custom = intval(get_option('postratings_customrating'));
    $ratings_options = get_option('postratings_options');
    if (is_object($post_data)) {
        $post_id = $post_data->ID;
    } else {
        $post_id = $post_data;
    }
    // Most likely from coming from Widget
    if (isset($post_data->ratings_users)) {
        $post_ratings_users = intval($post_data->ratings_users);
        $post_ratings_score = intval($post_data->ratings_score);
        $post_ratings_average = floatval($post_data->ratings_average);
        // Most Likely coming from the_ratings_vote or the_ratings_rate
    } else {
        if (isset($post_ratings_data->ratings_users)) {
            $post_ratings_users = intval($post_ratings_data->ratings_users);
            $post_ratings_score = intval($post_ratings_data->ratings_score);
            $post_ratings_average = floatval($post_ratings_data->ratings_average);
        } else {
            if (get_the_ID() != $post_id) {
                $post_ratings_data = get_post_custom($post_id);
            } else {
                $post_ratings_data = get_post_custom();
            }
            $post_ratings_users = is_array($post_ratings_data) && array_key_exists('ratings_users', $post_ratings_data) ? intval($post_ratings_data['ratings_users'][0]) : 0;
            $post_ratings_score = is_array($post_ratings_data) && array_key_exists('ratings_score', $post_ratings_data) ? intval($post_ratings_data['ratings_score'][0]) : 0;
            $post_ratings_average = is_array($post_ratings_data) && array_key_exists('ratings_average', $post_ratings_data) ? floatval($post_ratings_data['ratings_average'][0]) : 0;
        }
    }
    if ($post_ratings_score == 0 || $post_ratings_users == 0) {
        $post_ratings = 0;
        $post_ratings_average = 0;
        $post_ratings_percentage = 0;
    } else {
        $post_ratings = round($post_ratings_average, 1);
        $post_ratings_percentage = round($post_ratings_score / $post_ratings_users / $ratings_max * 100, 2);
    }
    $post_ratings_text = '<span class="post-ratings-text" id="ratings_' . $post_id . '_text"></span>';
    // Get the image's alt text
    if ($ratings_custom && $ratings_max == 2) {
        if ($post_ratings_score > 0) {
            $post_ratings_score = '+' . $post_ratings_score;
        }
        $post_ratings_alt_text = sprintf(_n('%s rating', '%s rating', $post_ratings_score, 'wp-postratings'), number_format_i18n($post_ratings_score)) . __(',', 'wp-postratings') . ' ' . sprintf(_n('%s vote', '%s votes', $post_ratings_users, 'wp-postratings'), number_format_i18n($post_ratings_users));
    } else {
        $post_ratings_score = number_format_i18n($post_ratings_score);
        $post_ratings_alt_text = sprintf(_n('%s vote', '%s votes', $post_ratings_users, 'wp-postratings'), number_format_i18n($post_ratings_users)) . __(',', 'wp-postratings') . ' ' . __('average', 'wp-postratings') . ': ' . number_format_i18n($post_ratings_average, 2) . ' ' . __('out of', 'wp-postratings') . ' ' . number_format_i18n($ratings_max);
    }
    // Check for half star
    $insert_half = 0;
    $average_diff = abs(floor($post_ratings_average) - $post_ratings);
    if ($average_diff >= 0.25 && $average_diff <= 0.75) {
        $insert_half = ceil($post_ratings_average);
    } elseif ($average_diff > 0.75) {
        $insert_half = ceil($post_ratings);
    }
    // Replace the variables
    $value = $template;
    if (strpos($template, '%RATINGS_IMAGES%') !== false) {
        $post_ratings_images = get_ratings_images($ratings_custom, $ratings_max, $post_ratings, $ratings_image, $post_ratings_alt_text, $insert_half);
        $value = str_replace("%RATINGS_IMAGES%", $post_ratings_images, $value);
    }
    if (strpos($template, '%RATINGS_IMAGES_VOTE%') !== false) {
        $ratings_texts = get_option('postratings_ratingstext');
        $post_ratings_images = get_ratings_images_vote($post_id, $ratings_custom, $ratings_max, $post_ratings, $ratings_image, $post_ratings_alt_text, $insert_half, $ratings_texts);
        $value = str_replace("%RATINGS_IMAGES_VOTE%", $post_ratings_images, $value);
    }
    $value = str_replace("%RATINGS_ALT_TEXT%", $post_ratings_alt_text, $value);
    $value = str_replace("%RATINGS_TEXT%", $post_ratings_text, $value);
    $value = str_replace("%RATINGS_MAX%", number_format_i18n($ratings_max), $value);
    $value = str_replace("%RATINGS_SCORE%", $post_ratings_score, $value);
    $value = str_replace("%RATINGS_AVERAGE%", number_format_i18n($post_ratings_average, 2), $value);
    $value = str_replace("%RATINGS_PERCENTAGE%", number_format_i18n($post_ratings_percentage, 2), $value);
    $value = str_replace("%RATINGS_USERS%", number_format_i18n($post_ratings_users), $value);
    // Post Template Variables
    $post_link = get_permalink($post_data);
    $post_title = get_the_title($post_data);
    if ($max_post_title_chars > 0) {
        $post_title = snippet_text($post_title, $max_post_title_chars);
    }
    $value = str_replace("%POST_ID%", $post_id, $value);
    $value = str_replace("%POST_TITLE%", $post_title, $value);
    $value = str_replace("%POST_URL%", $post_link, $value);
    if (strpos($template, '%POST_EXCERPT%') !== false) {
        if (get_the_ID() != $post_id) {
            $post =& get_post($post_id);
        }
        $post_excerpt = ratings_post_excerpt($post_id, $post->post_excerpt, $post->post_content, $post->post_password);
        $value = str_replace("%POST_EXCERPT%", $post_excerpt, $value);
    }
    if (strpos($template, '%POST_CONTENT%') !== false) {
        if (get_the_ID() != $post_id) {
            $post =& get_post($post_id);
        }
        $value = str_replace("%POST_CONTENT%", get_the_content(), $value);
    }
    // Google Rich Snippet
    $ratings_options['richsnippet'] = isset($ratings_options['richsnippet']) ? $ratings_options['richsnippet'] : 1;
    if ($ratings_options['richsnippet'] && (is_single() || is_page()) && $is_main_loop && $post_ratings_average > 0) {
        $itemtype = apply_filters('wp_postratings_schema_itemtype', 'itemscope itemtype="http://schema.org/Article"');
        if (empty($post_excerpt)) {
            $post_excerpt = ratings_post_excerpt($post_id, $post->post_excerpt, $post->post_content, $post->post_password);
        }
        $post_meta = '<meta itemprop="headline" content="' . esc_attr($post_title) . '" />';
        $post_meta .= '<meta itemprop="description" content="' . wp_kses($post_excerpt, array()) . '" />';
        $post_meta .= '<meta itemprop="datePublished" content="' . get_the_time('c') . '" />';
        $post_meta .= '<meta itemprop="url" content="' . $post_link . '" />';
        if (has_post_thumbnail()) {
            $thumbnail = wp_get_attachment_image_src(get_post_thumbnail_id(null));
            if (!empty($thumbnail)) {
                $post_meta .= '<meta itemprop="image" content="' . $thumbnail[0] . '" />';
            }
        }
        $ratings_meta = '<div style="display: none;" itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">';
        $ratings_meta .= '<meta itemprop="bestRating" content="' . $ratings_max . '" />';
        $ratings_meta .= '<meta itemprop="worstRating" content="1" />';
        $ratings_meta .= '<meta itemprop="ratingValue" content="' . $post_ratings_average . '" />';
        $ratings_meta .= '<meta itemprop="ratingCount" content="' . $post_ratings_users . '" />';
        $ratings_meta .= '</div>';
        $value = empty($itemtype) ? $value . $ratings_meta : $value . $post_meta . $ratings_meta;
    }
    return apply_filters('expand_ratings_template', $value);
}
Пример #3
0
 function get_mostemailed($mode = '', $limit = 10, $chars = 0, $echo = true)
 {
     global $wpdb, $post;
     $temp_post = $post;
     $where = '';
     $temp = '';
     if (!empty($mode) && $mode != 'both') {
         $where = "post_type = '{$mode}'";
     } else {
         $where = '1=1';
     }
     $mostemailed = $wpdb->get_results("SELECT {$wpdb->posts}.*, COUNT({$wpdb->email}.email_postid) AS email_total FROM {$wpdb->email} LEFT JOIN {$wpdb->posts} ON {$wpdb->email}.email_postid = {$wpdb->posts}.ID WHERE post_date < '" . current_time('mysql') . "' AND {$where} AND post_password = '' AND post_status = 'publish' GROUP BY {$wpdb->email}.email_postid ORDER  BY email_total DESC LIMIT {$limit}");
     if ($mostemailed) {
         if ($chars > 0) {
             foreach ($mostemailed as $post) {
                 $post_title = get_the_title();
                 $email_total = intval($post->email_total);
                 $temp .= "<li><a href=\"" . get_permalink() . "\">" . snippet_text($post_title, $chars) . "</a> - " . sprintf(_n('%s email', '%s emails', $email_total, 'wp-email'), number_format_i18n($email_total)) . "</li>\n";
             }
         } else {
             foreach ($mostemailed as $post) {
                 $post_title = get_the_title();
                 $email_total = intval($post->email_total);
                 $temp .= "<li><a href=\"" . get_permalink() . "\">{$post_title}</a> - " . sprintf(_n('%s email', '%s emails', $email_total, 'wp-email'), number_format_i18n($email_total)) . "</li>\n";
             }
         }
     } else {
         $temp = '<li>' . __('N/A', 'wp-email') . '</li>' . "\n";
     }
     $post = $temp_post;
     if ($echo) {
         echo $temp;
     } else {
         return $temp;
     }
 }
Пример #4
0
function expand_ratings_template($template, $post_id, $post_ratings_data = null, $max_post_title_chars = 0)
{
    global $post;
    global $txt_vote;
    global $txt_votes;
    global $txt_average;
    global $txt_out_of;
    $temp_post = $post;
    // Get global variables
    $ratings_image = get_option('postratings_image');
    $ratings_max = intval(get_option('postratings_max'));
    $ratings_custom = intval(get_option('postratings_customrating'));
    // Get post related variables
    if (is_null($post_ratings_data)) {
        # Orig:
        #$post_ratings_data = get_post_custom($post_id);
        #get data from PriceDB
        $post_ratings_data = lhg_get_post_ratings_data($post_id);
        # Orig:
        #$post_ratings_users = intval($post_ratings_data['ratings_users'][0]);
        #$post_ratings_score = intval($post_ratings_data['ratings_score'][0]);
        #$post_ratings_average = floatval($post_ratings_data['ratings_average'][0]);
        $post_ratings_users = intval($post_ratings_data['ratings_users']);
        $post_ratings_score = intval($post_ratings_data['ratings_score']);
        $post_ratings_average = floatval($post_ratings_data['ratings_average']);
    } else {
        $post_ratings_users = intval($post_ratings_data->ratings_users);
        $post_ratings_score = intval($post_ratings_data->ratings_score);
        $post_ratings_average = floatval($post_ratings_data->ratings_average);
    }
    if ($post_ratings_score == 0 || $post_ratings_users == 0) {
        $post_ratings = 0;
        $post_ratings_average = 0;
        $post_ratings_percentage = 0;
    } else {
        $post_ratings = round($post_ratings_average, 1);
        $post_ratings_percentage = round($post_ratings_score / $post_ratings_users / $ratings_max * 100, 1);
    }
    $post_ratings_text = '<span class="post-ratings-text" id="ratings_' . $post_id . '_text"></span>';
    // Get the image's alt text
    if ($ratings_custom && $ratings_max == 2) {
        if ($post_ratings_score > 0) {
            $post_ratings_score = '+' . $post_ratings_score;
        }
        $post_ratings_alt_text = sprintf(_n('%s ' . $txt_vote, '%s ' . $txt_vote, $post_ratings_score, 'wp-postratings'), number_format_i18n($post_ratings_score)) . __(',', 'wp-postratings') . ' ' . sprintf(_n('%s ' . $txt_vote, '%s ' . $txt_votes, $post_ratings_users, 'wp-postratings'), number_format_i18n($post_ratings_users));
    } else {
        $post_ratings_score = number_format_i18n($post_ratings_score);
        $post_ratings_alt_text = sprintf(_n('%s ' . $txt_vote, '%s ' . $txt_votes, $post_ratings_users, 'wp-postratings'), number_format_i18n($post_ratings_users)) . __(',', 'wp-postratings') . ' ' . __($txt_average, 'wp-postratings') . ': ' . number_format_i18n($post_ratings_average, 1) . ' ' . __($txt_out_of, 'wp-postratings') . ' ' . number_format_i18n($ratings_max);
    }
    // Check for half star
    $insert_half = 0;
    $average_diff = abs(floor($post_ratings_average) - $post_ratings);
    if ($average_diff >= 0.25 && $average_diff <= 0.75) {
        $insert_half = ceil($post_ratings_average);
    } elseif ($average_diff > 0.75) {
        $insert_half = ceil($post_ratings);
    }
    // Replace the variables
    $value = $template;
    if (strpos($template, '%RATINGS_IMAGES%') !== false) {
        $post_ratings_images = get_ratings_images($ratings_custom, $ratings_max, $post_ratings, $ratings_image, $post_ratings_alt_text, $insert_half);
        $value = str_replace("%RATINGS_IMAGES%", $post_ratings_images, $value);
    }
    if (strpos($template, '%RATINGS_IMAGES_VOTE%') !== false) {
        $ratings_texts = get_option('postratings_ratingstext');
        $post_ratings_images = get_ratings_images_vote($post_id, $ratings_custom, $ratings_max, $post_ratings, $ratings_image, $post_ratings_alt_text, $insert_half, $ratings_texts);
        $value = str_replace("%RATINGS_IMAGES_VOTE%", $post_ratings_images, $value);
        //$value .= "AA";
    }
    //$image = self::get_post_image($post_id,$imgsize) ;
    $image = get_the_post_thumbnail($post_id);
    if (strpos($template, '%POST_IMAGE%') !== false) {
        $post_link = get_permalink($post_id);
        $value = str_replace("%POST_IMAGE%", '<a href="' . $post_link . '">' . $image . "</a>", $value);
    }
    if (strpos($template, '%PRICE%') !== false) {
        //$myFile = "/home/wordpressftp/amazon.txt";
        //$fh = fopen($myFile, 'a') or die("can't open file");
        //$stringData = $post->ID.";".$newPrice."\n";
        //fwrite($fh, $stringData);
        //fclose($fh);
        $myFile = "/home/wordpressftp/amazon.txt";
        $file = file($myFile);
        $file = array_reverse($file);
        foreach ($file as $f) {
            if (strpos($f, $post_id) !== false) {
                $out = "OUT:" . $post_id . ":" . $f . " ";
                $price = explode(";", $f);
                //return chop($price[1]);
            } else {
            }
        }
        $value = str_replace("%PRICE%", chop($price[1]), $value);
    }
    $value = str_replace("%RATINGS_ALT_TEXT%", $post_ratings_alt_text, $value);
    $value = str_replace("%RATINGS_TEXT%", $post_ratings_text, $value);
    $value = str_replace("%RATINGS_MAX%", number_format_i18n($ratings_max), $value);
    $value = str_replace("%RATINGS_SCORE%", $post_ratings_score, $value);
    $value = str_replace("%RATINGS_AVERAGE%", number_format_i18n($post_ratings_average, 2), $value);
    $value = str_replace("%RATINGS_PERCENTAGE%", number_format_i18n($post_ratings_percentage, 2), $value);
    $value = str_replace("%RATINGS_USERS%", number_format_i18n($post_ratings_users), $value);
    if (strpos($template, '%POST_URL%') !== false) {
        $post_link = get_permalink($post_id);
        $value = str_replace("%POST_URL%", $post_link, $value);
    }
    if (strpos($template, '%POST_TITLE%') !== false) {
        $post_title = get_the_title($post_id);
        if ($max_post_title_chars > 0) {
            $post_title = snippet_text($post_title, $max_post_title_chars);
        }
        $value = str_replace("%POST_TITLE%", $post_title, $value);
    }
    if (strpos($template, '%POST_EXCERPT%') !== false) {
        if ($post->ID != $post_id) {
            $post =& get_post($post_id);
        }
        $post_excerpt = ratings_post_excerpt($post_id, $post->post_excerpt, $post->post_content, $post->post_password);
        $value = str_replace("%POST_EXCERPT%", $post_excerpt, $value);
    }
    if (strpos($template, '%POST_CONTENT%') !== false) {
        if ($post->ID != $post_id) {
            $post =& get_post($post_id);
        }
        $value = str_replace("%POST_CONTENT%", get_the_content(), $value);
    }
    // Return value
    $post = $temp_post;
    return apply_filters('expand_ratings_template', htmlspecialchars_decode($value));
}
Пример #5
0
 function get_downloads_category($cat_id = 0, $limit = 10, $chars = 0, $display = true)
 {
     global $wpdb, $user_ID;
     if (is_array($cat_id)) {
         $category_sql = "file_category IN (" . join(',', $cat_id) . ')';
     } else {
         $category_sql = "file_category = {$cat_id}";
     }
     $output = '';
     $files = $wpdb->get_results("SELECT * FROM {$wpdb->downloads} WHERE {$category_sql} AND file_permission != -2 ORDER BY file_date DESC LIMIT {$limit}");
     if ($files) {
         $current_user = wp_get_current_user();
         $file_extensions_images = file_extension_images();
         $download_categories = get_option('download_categories');
         $template_download_most_temp = get_option('download_template_most');
         foreach ($files as $file) {
             $file_permission = intval($file->file_permission);
             $template_download_most = $template_download_most_temp;
             if ($file_permission > 0 && intval($current_user->wp_user_level) >= $file_permission && intval($user_ID) > 0 || $file_permission == 0 && intval($user_ID) > 0 || $file_permission == -1) {
                 $template_download_most = stripslashes($template_download_most[0]);
             } else {
                 $template_download_most = stripslashes($template_download_most[1]);
             }
             if ($chars > 0) {
                 $file_name = snippet_text(stripslashes($file->file_name), $chars);
             } else {
                 $file_name = stripslashes($file->file_name);
             }
             $template_download_most = str_replace("%FILE_ID%", $file->file_id, $template_download_most);
             $template_download_most = str_replace("%FILE%", stripslashes($file->file), $template_download_most);
             $template_download_most = str_replace("%FILE_NAME%", $file_name, $template_download_most);
             $template_download_most = str_replace("%FILE_EXT%", file_extension(stripslashes($file->file)), $template_download_most);
             $template_download_most = str_replace("%FILE_ICON%", file_extension_image(stripslashes($file->file), $file_extensions_images), $template_download_most);
             $template_download_most = str_replace("%FILE_DESCRIPTION%", stripslashes($file->file_des), $template_download_most);
             $template_download_most = str_replace("%FILE_SIZE%", format_filesize($file->file_size), $template_download_most);
             $template_download_most = str_replace("%FILE_SIZE_DEC%", format_filesize_dec($file->file_size), $template_download_most);
             $template_download_most = str_replace("%FILE_CATEGORY_ID%", intval($file->file_category), $template_download_most);
             $template_download_most = str_replace("%FILE_CATEGORY_NAME%", stripslashes($download_categories[intval($file->file_category)]), $template_download_most);
             $template_download_most = str_replace("%FILE_DATE%", mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', $file->file_date)), $template_download_most);
             $template_download_most = str_replace("%FILE_TIME%", mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', $file->file_date)), $template_download_most);
             $template_download_most = str_replace("%FILE_UPDATED_DATE%", mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', $file->file_updated_date)), $template_download_most);
             $template_download_most = str_replace("%FILE_UPDATED_TIME%", mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', $file->file_updated_date)), $template_download_most);
             $template_download_most = str_replace("%FILE_HITS%", number_format_i18n($file->file_hits), $template_download_most);
             $template_download_most = str_replace("%FILE_DOWNLOAD_URL%", download_file_url($file->file_id, $file->file), $template_download_most);
             $output .= $template_download_most;
         }
     } else {
         $output = '<li>' . __('N/A', 'wp-downloadmanager') . '</li>' . "\n";
     }
     if ($display) {
         echo $output;
     } else {
         return $output;
     }
 }
 /**
  * 获取浏览次数最多的文章列表
  * 目前没有用
  */
 public function get_most_viewed($mode = '', $limit = 10, $chars = 0, $display = true)
 {
     global $wpdb;
     $views_options = get_option('views_options');
     $where = '';
     $temp = '';
     $output = '';
     if (!empty($mode) && $mode != 'both') {
         if (is_array($mode)) {
             $mode = implode("','", $mode);
             $where = "post_type IN ('" . $mode . "')";
         } else {
             $where = "post_type = '{$mode}'";
         }
     } else {
         $where = '1=1';
     }
     $most_viewed = $wpdb->get_results("SELECT DISTINCT {$wpdb->posts}.*, (meta_value+0) AS views FROM {$wpdb->posts} LEFT JOIN {$wpdb->postmeta} ON {$wpdb->postmeta}.post_id = {$wpdb->posts}.ID WHERE post_date < '" . current_time('mysql') . "' AND {$where} AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER BY views DESC LIMIT {$limit}");
     if ($most_viewed) {
         foreach ($most_viewed as $post) {
             $post_views = intval($post->views);
             $post_title = get_the_title($post);
             if ($chars > 0) {
                 $post_title = snippet_text($post_title, $chars);
             }
             $post_excerpt = views_post_excerpt($post->post_excerpt, $post->post_content, $post->post_password, $chars);
         }
     } else {
     }
 }
Пример #7
0
                $file_time = mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', $file->file_date));
                $file_updated_date = mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', $file->file_updated_date));
                $file_updated_time = mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', $file->file_updated_date));
                $file_last_downloaded_date = mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', $file->file_last_downloaded_date));
                $file_last_downloaded_time = mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', $file->file_last_downloaded_date));
                $file_hits = intval($file->file_hits);
                $file_permission = file_permission($file->file_permission);
                $file_name_actual = basename($file_name);
                if ($i % 2 == 0) {
                    $style = '';
                } else {
                    $style = ' class="alternate"';
                }
                echo "<tr{$style}>\n";
                echo '<td valign="top">' . number_format_i18n($file_id) . '</td>' . "\n";
                echo "<td>{$file_nicename}<br /><strong>&raquo;</strong> <i dir=\"ltr\">" . snippet_text($file_name, 45) . "</i><br /><br /><i>" . sprintf(__('Last Updated: %s, %s', 'wp-downloadmanager'), $file_updated_time, $file_updated_date) . "</i><br /><i>" . sprintf(__('Last Downloaded: %s, %s', 'wp-downloadmanager'), $file_last_downloaded_time, $file_last_downloaded_date) . "</i></td>\n";
                echo '<td style="text-align: center;">' . format_filesize($file_size) . '</td>' . "\n";
                echo '<td style="text-align: center;">' . number_format_i18n($file_hits) . '</td>' . "\n";
                echo '<td style="text-align: center;">' . $file_permission . '</td>' . "\n";
                echo '<td style="text-align: center;">' . $file_categories[$file_cat] . '</td>' . "\n";
                echo "<td>{$file_time}, {$file_date}</td>\n";
                echo "<td style=\"text-align: center;\"><a href=\"{$base_page}&amp;mode=edit&amp;id={$file_id}\" class=\"edit\">" . __('Edit', 'wp-downloadmanager') . "</a></td>\n";
                echo "<td style=\"text-align: center;\"><a href=\"{$base_page}&amp;mode=delete&amp;id={$file_id}\" class=\"delete\">" . __('Delete', 'wp-downloadmanager') . "</a></td>\n";
                echo '</tr>';
                $i++;
            }
        } else {
            echo '<tr><td colspan="9" align="center"><strong>' . __('No Files Found', 'wp-downloadmanager') . '</strong></td></tr>';
        }
        ?>
			</table>
Пример #8
0
function get_post_category_list($mode = '', $view_type = 'normal', $output_type = 'content', $time_span = 'total', $order_type = 'views', $order_by = 'DESC', $limit = 10, $chars = 0)
{
    global $wpdb, $post;
    for ($i = 0; $i < $limit; $i++) {
        $pv_views[$i] = array('title' => '', 'views' => '', 'time' => '');
    }
    if (!empty($mode) && $mode != 'both') {
        $mode = "post_type = '{$mode}'";
    } else {
        $mode = '1=1';
    }
    if ($time_span == 'today') {
        $time_span = 'post_views_today';
    } else {
        if ($time_span == 'week') {
            $time_span = 'post_views_week';
        } else {
            if ($time_span == 'month') {
                $time_span = 'post_views_month';
            } else {
                if ($time_span == 'halfyear') {
                    $time_span = 'post_views_halfyear';
                } else {
                    if ($time_span == 'year') {
                        $time_span = 'post_views_year';
                    } else {
                        $time_span = 'post_views_total';
                    }
                }
            }
        }
    }
    $user_cat_tag = "INNER JOIN {$wpdb->term_relationships} ON ({$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id) INNER JOIN {$wpdb->term_taxonomy} ON ({$wpdb->term_relationships}.term_taxonomy_id = {$wpdb->term_taxonomy}.term_taxonomy_id and {$wpdb->term_taxonomy}.taxonomy = 'category') INNER JOIN {$wpdb->terms} ON ( {$wpdb->terms}.term_id = {$wpdb->term_taxonomy}.term_id) ";
    $groupby = " group by {$wpdb->term_taxonomy}.term_id";
    $order_by = strtolower($order_by);
    if ($orderby != 'asc') {
        $orderby = 'desc';
    }
    $sql = "SELECT {$wpdb->terms}.term_id as id, {$wpdb->terms}.name as name, sum(" . $time_span . " + 0) AS views, latest_view_time FROM {$wpdb->posts} LEFT JOIN " . WP_POST_VIEWS_TABLE . " ON " . WP_POST_VIEWS_TABLE . ".post_id = {$wpdb->posts}.ID  {$user_cat_tag}  WHERE  post_date < '" . current_time('mysql') . "' AND post_status = 'publish' AND " . WP_POST_VIEWS_TABLE . ".view_type = '" . $view_type . "' AND " . WP_POST_VIEWS_TABLE . ".output_type = '" . $output_type . "' AND {$mode} AND post_password = '' {$groupby} ORDER  BY {$order_type} {$order_by} LIMIT {$limit}";
    $post_viewed = $wpdb->get_results($sql);
    $count = 0;
    if ($post_viewed) {
        foreach ($post_viewed as $post) {
            $post_views = intval($post->views);
            $post_title = $post->name;
            if ($chars > 0) {
                if (!function_exists('cut_str')) {
                    $post_title = snippet_text($post_title, $chars);
                } else {
                    $post_title = cut_str($post_title, $chars);
                }
            }
            $pv_views[$count] = array('title' => '<a href="' . get_category_link($post->id) . '"  class="dashedline" >' . $post_title . '</a>', 'views' => number_format($post_views), 'time' => "", 'post_id' => "");
            $count++;
        }
    }
    return $pv_views;
}