Sorting Download Files

I must have it, How did you do that?
I thougt I must repalace the $id parameter with something like $name to sort it by name.
How did you do that?
It works at this website: http://culchethhigh.co.uk/the-eagle-newsletter/ .
If my English is not so good, I’m a German.

For theconsolidatedlodge;

Ok, now I know it…
It’s not so good, that the developer hasn’t add this function, to sort by nme, but now, I guess, you must replace this:

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

wih this:

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

But it’s better, if you lokk in your dat-tabel, of the plugin an find out, wht, you want to sort.

Thank you for a reply,
Alexander Jank

For theconsolidatedlodge;

I edited the file named “download-manager/download-manager.php” in the plugin, it’s 100% compatible with the new version 2.5.3.
But you must search with ctrl+f for “items” and there is only one result. The line 7 after the found word is the line, you must edit.
I updated the Post, what I have writte before this, there are the compatible things.
It’s line 600.
My change is into the MySQL command.

Thank you for a reply,
Alexander Jank

For theconsolidatedlodge;

It’s to much work, I think, to add a line with filter options, it will be to much work, because you must add the Line and there some buttons must appear, you must style them with a lot of css and gthen, the user can order them in the frontdend by name.
My solution, is for the frontednd and not for the backend.
I konw, that the letters in my example are ordered, it orders the files alphabetical.
I have now added my “download-manager/download-manager.php” in the txt format to post #9467.
Here is the Link to the file I have uplouded:

http://www.wpdownloadmanager.com/wp-content/uploads/2013/10/d-manager.txt

The SQL command, what does this work ist: “SELECT * FROM ‘ahm_files‘ WHERE ‘category‘ LIKE ‘%\”$id\”%’ ORDER BY ‘title‘ ASC”
It’ correct SQL syntax.

I have made a screensshot, later, I will add it to the post, I’ve got technical problems…

Thank you for replys.
Alexander Jank

hey donkeymusic, hey theconsolidatedlodge,

Ok, my Link was false, it was password protected.
New link to the Plugin on my testblog:
http://test.alexanderjank.de/wordpress/downloads/

Ok.
Thanks for a reply
Alexander Jank

I’ve got the download manager free.
My shortcode:

{wpdm_category=download-site}

because, they are all in the category called download-site.

I’ve only made the changes in line 600 of the file.

Alexander jank

I’ve forgotten to say:
I’ve added the tree with your shortcode to my example.
look at:
http://test.alexanderjank.de/wordpress/downloads/

It’s in the end of this site.

I’ve written it before…
It’s line 345 to sort the files in the dropdown list by title.
It’s in #9494.
And, I know, we use two diffrent views, but I have fixed it for your view too, look at #9494.
And go to the link….
Under my method, there is your tree structure method.

Totally did not see your post 9494 earlier. I implemented you code on line 345 and it worked perfect. Thank you SO much, Alexander! You really helped me out!!