Topic: most yes, recent no!

[Jaihoon]

hi

the download plugin is working like a breeze.. but only for the latest download widget. I am not getting any display for the recent download widget.

i even tried the code via a text widget

<?php if (function_exists('get_newest_downloads')): ?>
   <?php get_newest_downloads(); ?>
<?php endif; ?>

but this gives no results

Any suggestions

http://jaihoon.tv

[GaMerZ]

what version of wp-downloadmanager are you using?

How about:

Code: [Select]

<?php if (function_exists('get_recent_downloads')): ?>
   <?php get_recent_downloads(); ?>
<?php endif; ?>

[Jaihoon]

thanx for reply

i am using 1.0 and the new code did not yield any results. Do I need to use plugin which executes php?

[GaMerZ]

yeap of course as it is a PHP code. In that case get a PHP Exec Widget and then the code you posted in the first post should work fine.

[Jaihoon]

i used exec-php plugin and it worked.

thanks

i have another doubt though. On what basis the recent downlaod widget lists the files? I wish to do the follwoing:

- list the files of most recent date (but past only or till today)
- Hide the files of future dates from being shown

Can I do this...  it wud be of great help

thanx again

[GaMerZ]

In downloadmanager.php
Find (Line 773):

Code: [Select]

$files = $wpdb->get_results("SELECT * FROM $wpdb->downloads ORDER BY file_date DESC LIMIT $limit");Replace:

Code: [Select]

$files = $wpdb->get_results("SELECT * FROM $wpdb->downloads WHERE file_date <= ".gmdate('U')." ORDER BY file_date DESC LIMIT $limit");

[Jaihoon]

wow. thankx. it worked fine.

keep up the coding

[Ttech]

Glad it works..

[Jaihoon]

Hi

I am back with a minor issue. When I put the php code in a text widget, it of course yields results. However, I am forced to use/position it as the last widget or else it creates alignment problems, the bulleted list gets out of the side-bar.

Anyone help

[GaMerZ]

you can edit the template in WP-Admin -> Downloads -> Download Templates