'."\n";
} else {
$output .= ''.__('N/A', 'wp-downloadmanager').' '."\n";
}
if($display) {
echo $output;
} else {
return $output;
}
}
}
### Function: Get Newest Downloads
if(!function_exists('get_recent_downloads')) {
function get_recent_downloads($limit = 10, $chars = 0, $display = true) {
global $wpdb, $user_ID;
$output = '';
$files = $wpdb->get_results("SELECT * FROM $wpdb->downloads WHERE file_permission != -2 ORDER BY FROM_UNIXTIME(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 = (int) $file->file_permission;
$template_download_most = $template_download_most_temp;
if( $file_permission === -1 || ( $file_permission === 0 && (int) $user_ID > 0) || ( $file_permission > 0 && get_wp_user_level() >= $file_permission && (int) $user_ID > 0 ) ) {
$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%", (int) $file->file_category, $template_download_most);
$template_download_most = str_replace("%FILE_CATEGORY_NAME%", stripslashes($download_categories[(int) $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 = ''.__('N/A', 'wp-downloadmanager').' '."\n";
}
if($display) {
echo $output;
} else {
return $output;
}
}
}
### Function: Get Downloads By Category ID
if(!function_exists('get_downloads_category')) {
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 (".implode(',', $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 FROM_UNIXTIME(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 = (int) $file->file_permission;
$template_download_most = $template_download_most_temp;
if( $file_permission === -1 || ( $file_permission === 0 && (int) $user_ID > 0 ) || ( $file_permission > 0 && get_wp_user_level() >= $file_permission && (int) $user_ID > 0 ) ) {
$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%", (int) $file->file_category, $template_download_most);
$template_download_most = str_replace("%FILE_CATEGORY_NAME%", stripslashes($download_categories[(int) $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 = ''.__('N/A', 'wp-downloadmanager').' '."\n";
}
if($display) {
echo $output;
} else {
return $output;
}
}
}
### Function: Plug Into WP-Stats
add_action( 'plugins_loaded','downloadmanager_wp_stats' );
function downloadmanager_wp_stats() {
add_filter( 'wp_stats_page_admin_plugins', 'downloadmanager_page_admin_general_stats' );
add_filter( 'wp_stats_page_admin_recent', 'downloadmanager_page_admin_recent_stats' );
add_filter( 'wp_stats_page_admin_most', 'downloadmanager_page_admin_most_stats' );
add_filter( 'wp_stats_page_plugins', 'downloadmanager_page_general_stats' );
add_filter( 'wp_stats_page_recent', 'downloadmanager_page_recent_stats' );
add_filter( 'wp_stats_page_most', 'downloadmanager_page_most_stats' );
}
### Function: Add WP-DownloadManager General Stats To WP-Stats Page Options
function downloadmanager_page_admin_general_stats($content) {
$stats_display = get_option('stats_display');
if( (int) $stats_display['downloads'] === 1 ) {
$content .= '
'."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager Top Recent Stats To WP-Stats Page Options function downloadmanager_page_admin_recent_stats($content) { $stats_display = get_option('stats_display'); $stats_mostlimit = (int) get_option('stats_mostlimit'); if( (int) $stats_display['recent_downloads'] === 1) { $content .= '
'."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager Top Most/Highest Stats To WP-Stats Page Options function downloadmanager_page_admin_most_stats($content) { $stats_display = get_option('stats_display'); $stats_mostlimit = (int) get_option('stats_mostlimit'); if( (int) $stats_display['downloaded_most'] === 1) { $content .= '
'."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager General Stats To WP-Stats Page function downloadmanager_page_general_stats($content) { global $wpdb; $stats_display = get_option('stats_display'); if( (int) $stats_display['downloads'] === 1 ) { $download_stats = $wpdb->get_row("SELECT COUNT(file_id) as total_files, SUM(file_size) total_size, SUM(file_hits) as total_hits FROM $wpdb->downloads"); $content .= '%FILE_NAME% (%FILE_SIZE%'.__(',', 'wp-downloadmanager').' %FILE_HITS% '.__('hits', 'wp-downloadmanager').') ', '%FILE_NAME% (%FILE_SIZE%'.__(',', 'wp-downloadmanager').' %FILE_HITS% '.__('hits', 'wp-downloadmanager').')
'.__('You do not have permission to download this file.', 'wp-downloadmanager').' '), 'Most Download Template');
// Database Upgrade For WP-DownloadManager 1.30
$check_for_130 = $wpdb->get_var("SELECT option_value FROM $wpdb->options WHERE option_name = 'download_nice_permalink'");
if(!$check_for_130) {
maybe_add_column($wpdb->downloads, 'file_updated_date', "ALTER TABLE $wpdb->downloads ADD file_updated_date VARCHAR(20) NOT NULL AFTER file_date;");
$wpdb->query("UPDATE $wpdb->downloads SET file_updated_date = file_date;");
maybe_add_column($wpdb->downloads, 'file_last_downloaded_date', "ALTER TABLE $wpdb->downloads ADD file_last_downloaded_date VARCHAR(20) NOT NULL AFTER file_updated_date;");
$wpdb->query("UPDATE $wpdb->downloads SET file_last_downloaded_date = file_date;");
}
add_option('download_template_pagingheader', '', 'Displayed Before Paging In The Downloads Page');
add_option('download_template_pagingfooter', '', 'Displayed After Paging In The Downloads Page');
add_option('download_nice_permalink', 1, 'Use Download Nice Permalink');
add_option('download_template_download_page_link', '
'."\n";
}
$output .= ' '.sprintf(__('Page %s of %s', 'wp-downloadmanager'), number_format_i18n($page), number_format_i18n($max_page)).' ';
if ($start_page >= 2 && $pages_to_show < $max_page) {
$output .= ' '.__('« First', 'wp-downloadmanager').' ';
$output .= '...';
}
if($page > 1) {
$output .= ' '.__('«', 'wp-downloadmanager').' ';
}
for($i = $start_page; $i <= $end_page; $i++) {
if($i === $page) {
$output .= ' '.number_format_i18n($i).' ';
} else {
$output .= ' '.number_format_i18n($i).' ';
}
}
if(empty($page) || ($page+1) <= $max_page) {
$output .= ' '.__('»', 'wp-downloadmanager').' ';
}
if ($end_page < $max_page) {
$output .= '...';
$output .= ' '.__('Last »', 'wp-downloadmanager').' ';
}
$output .= '
';
$output .= stripslashes(get_option('download_template_pagingfooter'));
}
return apply_filters('downloads_page', $output);
}
### Function: List Out All Files In Downloads Directory
function list_downloads_files($dir, $orginal_dir) {
global $download_files, $download_files_subfolder;
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if($file != '.' && $file != '..' && $file != '.htaccess') {
if(is_dir($dir.'/'.$file)) {
list_downloads_files($dir.'/'.$file, $orginal_dir);
} else {
$folder_file =str_replace($orginal_dir, '', $dir.'/'.$file);
$sub_dir = explode('/', $folder_file);
if(sizeof($sub_dir) > 2) {
$download_files_subfolder[] = $folder_file;
} else {
$download_files[] = $folder_file;
}
}
}
}
closedir($dh);
}
}
}
### Function: List Out All Files In Downloads Directory
function list_downloads_folders($dir, $orginal_dir) {
global $download_folders;
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if($file != '.' && $file != '..') {
if(is_dir($dir.'/'.$file)) {
$folder =str_replace($orginal_dir, '', $dir.'/'.$file);
$download_folders[] = $folder;
list_downloads_folders($dir.'/'.$file, $orginal_dir);
}
}
}
closedir($dh);
}
}
}
### Function: Print Listing Of Files In Alphabetical Order
function print_list_files($dir, $orginal_dir, $selected = '') {
global $download_files, $download_files_subfolder;
list_downloads_files($dir, $orginal_dir);
if($download_files) {
natcasesort($download_files);
}
if($download_files_subfolder) {
natcasesort($download_files_subfolder);
}
if($download_files) {
foreach($download_files as $download_file) {
if($download_file == $selected) {
echo ''."\n";
} else {
echo ''."\n";
}
}
}
if($download_files_subfolder) {
foreach($download_files_subfolder as $download_file_subfolder) {
if($download_file_subfolder == $selected) {
echo ''."\n";
} else {
echo ''."\n";
}
}
}
}
### Function: Print Listing Of Folders In Alphabetical Order
function print_list_folders($dir, $orginal_dir) {
global $download_folders;
list_downloads_folders($dir, $orginal_dir);
if($download_folders) {
natcasesort($download_folders);
echo ''."\n";
foreach($download_folders as $download_folder) {
echo ''."\n";
}
}
}
### Function: Rename File To Ensure (Credits: imvain2)
function download_rename_file($file_path, $file) {
$rename = false;
$file_old = $file;
$file = str_replace(' ', '_', $file);
$file = preg_replace('/[^A-Za-z0-9\-._\/]/', '', $file);
if($file !== $file_old) {
$rename = rename($file_path.$file_old, $file_path.$file);
}
if($rename) {
return $file;
}
return $file_old;
}
### Function: Editable Timestamp
function file_timestamp($file_timestamp) {
global $month;
$day = (int) gmdate('j', $file_timestamp);
echo ' '."\n";
$month2 = (int) gmdate('n', $file_timestamp);
echo ' '."\n";
$year = (int) gmdate('Y', $file_timestamp);
$current_year = (int) gmdate('Y');
echo ' @'."\n";
echo ''."\n";
$hour = (int) gmdate('H', $file_timestamp);
echo ' :'."\n";
$minute = (int) gmdate('i', $file_timestamp);
echo ' :'."\n";
$second = (int) gmdate('s', $file_timestamp);
echo ''."\n";
echo ''."\n";
}
function get_wp_user_level() {
// Everyone
$current_user = wp_get_current_user();
if( empty( $current_user ) ) {
return -1;
}
// At Least Administrator Role
if( current_user_can( 'activate_plugins' ) ) {
return 10;
}
// At Least Editor Role
if( current_user_can( 'delete_others_posts' ) ) {
return 7;
}
// At Least Author Role
if( current_user_can( 'publish_posts' ) ) {
return 2;
}
// At Least Contributor Role
if( current_user_can( 'edit_posts' ) ) {
return 1;
}
// Registered Users Only
if( current_user_can( 'read' ) ) {
return 0;
}
// In case
return -1;
}
### Function: File Permission
function file_permission($file_permission) {
$file_permission_name = '';
switch( (int) $file_permission ) {
case -2:
$file_permission_name = __('Hidden', 'wp-downloadmanager');
break;
case -1:
$file_permission_name = __('Everyone', 'wp-downloadmanager');
break;
case 0:
$file_permission_name = __('Registered Users Only', 'wp-downloadmanager');
break;
case 1:
$file_permission_name = __('At Least Contributor Role', 'wp-downloadmanager');
break;
case 2:
$file_permission_name = __('At Least Author Role', 'wp-downloadmanager');
break;
case 7:
$file_permission_name = __('At Least Editor Role', 'wp-downloadmanager');
break;
case 10:
$file_permission_name = __('At Least Administrator Role', 'wp-downloadmanager');
break;
}
return $file_permission_name;
}
### Function: Get Total Download Files
function get_download_files($display = true) {
global $wpdb;
$totalfiles = $wpdb->get_var("SELECT COUNT(file_id) FROM $wpdb->downloads");
if($display) {
echo number_format_i18n($totalfiles);
} else {
return number_format_i18n($totalfiles);
}
}
### Function Get Total Download Size
function get_download_size($display = true) {
global $wpdb;
$totalsize = $wpdb->get_var("SELECT SUM(file_size) FROM $wpdb->downloads");
if($display) {
echo format_filesize($totalsize);
} else {
return format_filesize($totalsize);
}
}
### Function: Get Total Download Hits
function get_download_hits($display = true) {
global $wpdb;
$totalhits = $wpdb->get_var("SELECT SUM(file_hits) FROM $wpdb->downloads");
if($display) {
echo number_format_i18n($totalhits);
} else {
return number_format_i18n($totalhits);
}
}
### Function: Download Embedded
function download_embedded($condition = '', $display = 'both', $sort_by = 'file_id', $sort_order = 'asc', $stream_limit = 0) {
global $wpdb, $user_ID;
$valid_sort_by = array('file_id', 'file', 'file_name', 'file_size', 'file_date', 'file_hits');
$valid_sort_order = array('asc', 'desc');
if (!in_array($sort_by, $valid_sort_by, true)) {
$sort_by = 'file_id';
}
if (!in_array($sort_order, $valid_sort_order, true)) {
$sort_order = 'asc';
}
if ( $sort_by === 'file_date' ) {
$sort_by = 'FROM_UNIXTIME(file_date)';
}
$stream_limit = max( (int) $stream_limit, 0);
$output = '';
if($condition !== '') {
$condition .= ' AND ';
}
$query_string = "SELECT * FROM $wpdb->downloads WHERE $condition file_permission != -2 ORDER BY {$sort_by} {$sort_order}";
if (!is_single() && $stream_limit != 0) {
// We don't need to retrieve ALL matching files, we just need to know if there are more files than $stream_limit.
// This can cut down on memory usage if there are many many matching files but the $stream_limit is relatively small.
$query_limit = $stream_limit + 1;
$query_string .= " LIMIT {$query_limit}";
}
$files = $wpdb->get_results($query_string);
if($files) {
$current_user = wp_get_current_user();
$file_extensions_images = file_extension_images();
$download_categories = get_option('download_categories');
$template_download_embedded_temp = get_option('download_template_embedded');
if (is_single() || $stream_limit === 0)
{
$stream_limit = count($files);
}
else
{
$stream_limit = min($stream_limit, count($files));
}
for ($i = 0; $i < $stream_limit; $i++) {
$file = $files[$i];
$file_permission = (int) $file->file_permission;
$template_download_embedded = $template_download_embedded_temp;
if( $file_permission === -1 || ( $file_permission === 0 && (int) $user_ID > 0 ) || ( $file_permission > 0 && get_wp_user_level() >= $file_permission && (int) $user_ID > 0 ) ) {
$template_download_embedded = stripslashes($template_download_embedded[0]);
} else {
$template_download_embedded = stripslashes($template_download_embedded[1]);
}
$template_download_embedded = str_replace("%FILE_ID%", $file->file_id, $template_download_embedded);
$template_download_embedded = str_replace("%FILE%", stripslashes($file->file), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_NAME%", stripslashes($file->file_name), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_EXT%", file_extension(stripslashes($file->file)), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_ICON%", file_extension_image(stripslashes($file->file), $file_extensions_images), $template_download_embedded);
if( $display === 'both' ) {
$template_download_embedded = str_replace("%FILE_DESCRIPTION%", stripslashes($file->file_des), $template_download_embedded);
} else {
$template_download_embedded = str_replace("%FILE_DESCRIPTION%", '', $template_download_embedded);
}
$template_download_embedded = str_replace("%FILE_SIZE%", format_filesize($file->file_size), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_SIZE_DEC%", format_filesize_dec($file->file_size), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_CATEGORY_ID%", (int) $file->file_category, $template_download_embedded);
$template_download_embedded = str_replace("%FILE_CATEGORY_NAME%", stripslashes($download_categories[(int) $file->file_category]), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_DATE%", mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', (int) $file->file_date)), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_TIME%", mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', (int) $file->file_date)), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_UPDATED_DATE%", mysql2date(get_option('date_format'), gmdate('Y-m-d H:i:s', (int) $file->file_updated_date)), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_UPDATED_TIME%", mysql2date(get_option('time_format'), gmdate('Y-m-d H:i:s', (int) $file->file_updated_date)), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_HITS%", number_format_i18n($file->file_hits), $template_download_embedded);
$template_download_embedded = str_replace("%FILE_DOWNLOAD_URL%", download_file_url($file->file_id, $file->file), $template_download_embedded);
$output .= $template_download_embedded;
}
if (!is_single() && $stream_limit != 0 && $stream_limit < count($files)) {
$output .= ''.__('More …', 'wp-downloadmanager').'
'; } return apply_filters('download_embedded', $output); } } ### Function: Get Most Downloaded Files if(!function_exists('get_most_downloaded')) { function get_most_downloaded($limit = 10, $chars = 0, $display = true) { global $wpdb, $user_ID; $output = ''; $files = $wpdb->get_results("SELECT * FROM $wpdb->downloads WHERE file_permission != -2 ORDER BY file_hits 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 = (int) $file->file_permission; $template_download_most = $template_download_most_temp; if( $file_permission === -1 || ( $file_permission === 0 && (int) $user_ID > 0 ) || ( $file_permission > 0 && get_wp_user_level() >= $file_permission && (int) $user_ID > 0) ) { $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%", (int) $file->file_category, $template_download_most); $template_download_most = str_replace("%FILE_CATEGORY_NAME%", stripslashes($download_categories[(int) $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 = ''."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager Top Recent Stats To WP-Stats Page Options function downloadmanager_page_admin_recent_stats($content) { $stats_display = get_option('stats_display'); $stats_mostlimit = (int) get_option('stats_mostlimit'); if( (int) $stats_display['recent_downloads'] === 1) { $content .= '
'."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager Top Most/Highest Stats To WP-Stats Page Options function downloadmanager_page_admin_most_stats($content) { $stats_display = get_option('stats_display'); $stats_mostlimit = (int) get_option('stats_mostlimit'); if( (int) $stats_display['downloaded_most'] === 1) { $content .= '
'."\n"; } else { $content .= '
'."\n"; } return $content; } ### Function: Add WP-DownloadManager General Stats To WP-Stats Page function downloadmanager_page_general_stats($content) { global $wpdb; $stats_display = get_option('stats_display'); if( (int) $stats_display['downloads'] === 1 ) { $download_stats = $wpdb->get_row("SELECT COUNT(file_id) as total_files, SUM(file_size) total_size, SUM(file_hits) as total_hits FROM $wpdb->downloads"); $content .= '
'.__('WP-DownloadManager', 'wp-downloadmanager').'
'."\n"; $content .= '- '."\n";
$content .= '
- '.sprintf(_n('%s file was added.', '%s files were added.', $download_stats->total_files, 'wp-downloadmanager'), number_format_i18n($download_stats->total_files)).' '."\n"; $content .= '
- '.sprintf(_n('%s worth of files.', '%s worth of files.', $download_stats->total_size, 'wp-downloadmanager'), format_filesize($download_stats->total_size)).' '."\n"; $content .= '
- '.sprintf(_n('%s hit was generated.', '%s hits were generated.', $download_stats->total_hits, 'wp-downloadmanager'), number_format_i18n($download_stats->total_hits)).' '."\n"; $content .= '
'.sprintf(_n('%s Most Recent Download', '%s Most Recent Downloads', $stats_mostlimit, 'wp-downloadmanager'), number_format_i18n($stats_mostlimit)).'
'."\n"; $content .= '- '."\n";
$content .= get_recent_downloads($stats_mostlimit, 0, false);
$content .= '
'.sprintf(_n('%s Most Downloaded File', '%s Most Downloaded Files', $stats_mostlimit, 'wp-downloadmanager'), number_format_i18n($stats_mostlimit)).'
'."\n"; $content .= '- '."\n";
$content .= get_most_downloaded($stats_mostlimit, 0, false);
$content .= '
- '."\n";
switch($type) {
case 'downloads_category':
get_downloads_category($cat_ids, $limit, $chars);
break;
case 'recent_downloads':
get_recent_downloads($limit, $chars);
break;
case 'most_downloaded':
get_most_downloaded($limit, $chars);
break;
}
echo '
0 to disable.', 'wp-downloadmanager'); ?>
has_cap( 'collation' ) ) { if(!empty($wpdb->charset)) { $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset"; } if(!empty($wpdb->collate)) { $charset_collate .= " COLLATE $wpdb->collate"; } } // Create WP-Downloads Table $create_table = "CREATE TABLE $wpdb->downloads (". "file_id int(10) NOT NULL auto_increment,". "file tinytext NOT NULL,". "file_name text character set utf8 NOT NULL,". "file_des text character set utf8 NOT NULL,". "file_size varchar(20) NOT NULL default '',". "file_category int(2) NOT NULL default '0',". "file_date varchar(20) NOT NULL default '',". "file_updated_date varchar(20) NOT NULL default '',". "file_last_downloaded_date varchar(20) NOT NULL default '',". "file_hits int(10) NOT NULL default '0',". "file_permission TINYINT(2) NOT NULL default '0',". "PRIMARY KEY (file_id)) $charset_collate;"; maybe_create_table($wpdb->downloads, $create_table); // WP-Downloads Options if (function_exists('is_site_admin')) { add_option('download_path', WP_CONTENT_DIR.'/blogs.dir/'.$blog_id.'/files', 'Download Path'); add_option('download_path_url', WP_CONTENT_URL.'/blogs.dir/'. $blog_id.'/files', 'Download Path URL'); } else { add_option('download_path', WP_CONTENT_DIR.'/files', 'Download Path'); add_option('download_path_url', content_url('files'), 'Download Path URL'); } add_option('download_page_url', site_url('downloads'), 'Download Page URL'); add_option('download_method', 1, 'Download Type'); add_option('download_categories', array('General'), 'Download Categories'); add_option('download_sort', array('by' => 'file_name', 'order' => 'asc', 'perpage' => 20, 'group' => 1), 'Download Sorting Options'); add_option('download_template_header', '
'.__('There are %TOTAL_FILES_COUNT% files, weighing %TOTAL_SIZE% with %TOTAL_HITS% hits in %FILE_CATEGORY_NAME%.
Displaying %RECORD_START% to %RECORD_END% of %TOTAL_FILES_COUNT% files.', 'wp-downloadmanager').'
', 'Download Page Header Template'); add_option('download_template_footer', '', 'Download Page Footer Template'); add_option('download_template_category_header', '%FILE_CATEGORY_NAME%
', 'Download Category Header Template'); add_option('download_template_category_footer', '', 'Download Category Footer Template'); add_option('download_template_listing', array('.'/%FILE_ICON%)
» %FILE_SIZE% - %FILE_HITS% '.__('hits', 'wp-downloadmanager').' - %FILE_DATE%
%FILE_DESCRIPTION%
» %FILE_SIZE% - %FILE_HITS% '.__('hits', 'wp-downloadmanager').' - %FILE_DATE%
'.__('You do not have permission to download this file.', 'wp-downloadmanager').'
%FILE_DESCRIPTION%
'.__('You do not have permission to download this file.', 'wp-downloadmanager').'
'.__('You do not have permission to download this file.', 'wp-downloadmanager').'
'.__('Downloads Page', 'wp-downloadmanager').'
', 'Template For Download Page Link'); add_option('download_template_none', ''.__('No Files Found.', 'wp-downloadmanager').'
', 'Template For No Downloads Found'); // Database Upgrade For WP-DownloadManager 1.50 $check_for_150 = $wpdb->get_var("SELECT option_value FROM $wpdb->options WHERE option_name = 'download_options'"); if(!$check_for_150) { $update_permission_1 = $wpdb->query("UPDATE $wpdb->downloads SET file_permission = -2 WHERE file_permission = -1;"); if($update_permission_1) { $update_permission_2 = $wpdb->query("UPDATE $wpdb->downloads SET file_permission = -1 WHERE file_permission = 0;"); if($update_permission_2) { $wpdb->query("UPDATE $wpdb->downloads SET file_permission = 0 WHERE file_permission = 1;"); } } } add_option('download_options', array('use_filename' => 0, 'rss_sortby' => 'file_date', 'rss_limit' => 20), 'Download Options'); // Create Files Folder if (function_exists('is_site_admin')) { if(!is_dir(WP_CONTENT_DIR.'/blogs.dir/'.$blog_id.'/files/') && is_writable(WP_CONTENT_DIR.'/blogs.dir/'.$blog_id.'/files/')) { mkdir(WP_CONTENT_DIR.'/blogs.dir/'.$blog_id.'/files/', 0777, true); } } else { if(!is_dir(WP_CONTENT_DIR.'/files/') && is_writable(WP_CONTENT_DIR.'/files/')) { mkdir(WP_CONTENT_DIR.'/files/', 0777, true); } } delete_option('widget_download_recent_downloads'); delete_option('widget_download_most_downloaded'); // Set 'manage_downloads' Capabilities To Administrator $role = get_role('administrator'); if(!$role->has_cap('manage_downloads')) { $role->add_cap('manage_downloads'); } flush_rewrite_rules(); }