Sorting Download Files

Hi donkeymusic

Change line #591 to the following:

$ndata = $wpdb->get_results(“select * from ahm_files where category like ‘%\”$id\”%’ order by id desc limit $start, $item_per_page”,ARRAY_A);

I just added the SQL command “order by id desc” after the current SQL Search query already on line #591 “select * from ahm_files where category like ‘%\”$id\”%’”. The SQL command just sorts the files into reverse order on the live front end that your visitors will see. I edited the download-manager.php file directly as I host the web server myself, I didn’t change any existing code, I only added to it, Maybe it’s error if you have copied the code directly from the forum, try putting your original download-manager.php file back on you server so all is working the just add the code “order by id desc” as I did. Hope this helps.

I have updated myself and couldn’t find any option either. I asked for the shortcode in an existing post as I thought the update would alow the same as you but have had no reply.

If I find anything out I will post and let you know. Please do the same if you manage to sort it out.

Did someone manage to sort this problem out?

Hi bradmillar, as of yet there has been no response to confirm the shortcode or what is required to do this in the latest version. I have downgraded to the previous version and added in the SQL to do it for me.

Thanks Welford. Can you help me do the same? Where can I find the old version and how do I add SQL and what is the SQL I need to add? I would really appreciate help on this…

Hi bradmiller, I have zipped and uploaded my copy of download manager 2.4.0 with the added code in the functions file, I have put it up for download on my school site, please use the link below to download it, If you could let me know once you have so I can remove it I would appreciate it.

http://www.welford.bham.sch.uk/download-manager-2.4.0.zip

The code I have added is on line #591, I just added the following to the SQL “order by id desc” so that it orders them the opposie way.

Hope this helps, Welford

You are a champion, Welford. Thanks so much! I have downloaded the file so you may remove it. Thanks again!

Hi there. I chose the online support help section on this site and a chap asked for a temporary FTP password from me and did the coding for me. He was a great help! http://www.wpdownloadmanager.com/live-support/

Did the ever get resolved? I am running WPDM v 2.4.9 and would like to be able to sort my documents by name. Unable to do so. I seem to already have the code mentioned for Line 591.

Thanks for the reply. I suppose I should be thankful that I didn’t purchase the Pro version yet!