alexanderjank

I’ve found a way, to sort by date….
In the database-tabel “ahm_files”, you start with the mysql command:

ALTER TABLE `ahm_files` CHANGE `description` `description` DATE NOT NULL

Then go ahead to your WordPress and go to File Manager > Manage.
Edit waht you want and write the date of the file into the field for the description, it’s the tall field.
Edit the php-file of the manager and write “order by description asc” or “order by description desc” in the specified lines(600 or 345).
Now it is sorted by date.

I’m working on sorting by date.
I must add a columm named date to the tabel “ahm_files”.
The plugin must only write the date of all new Downloads to the database.
And there you are.
The mysql command must be “order by date asc”
It’s a lot of work.

Thank you for replying.
Alexander Jank

You cannot sort the items by creation-date.
Because tthe creation-date is not given to the MySQL Database.

Thank you for your replys.
Alexander Jank, Germany

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 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

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

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

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.