Module "The latest downloads"

[tetrijeb]

Is there some module that could show recently added files in frontend, something like "recently added documents"?

It's a really simple query from the base:

select singleSRC, linkTITLE from tl_content where type='download' order by tstamp desc limit 5"

but I don't know how to make a module or extension for frontend.

[Lupus]

Hello :-)

You have a extension creator in your back office. It's a very simple thing to do ;-)
The hardiest part is to program your PHP and your SQL, and you already have your SQL.

To execute une request in FrontEnd, you can use :

\Database::getInstance()->prepare('your_request')->execute() 

And in your case, if you want to limit results, just add

\Database::getInstance()->prepare('your_request')->limit(your_limit)->execute() 

[tetrijeb]

Hello :-)

You have a extension creator in your back office. It's a very simple thing to do ;-)
The hardiest part is to program your PHP and your SQL, and you already have your SQL.

Hi,

I didn't know for that extension.

Thanks for your reply!

However, I would for sure, need some time to find useful tutorial and study it more carefully. Despite my query is being quite simple, and there is no need for additional, non-existing tables, PHP file could be a problem.

PS. For tutorial, I found this: http://de.contaowiki.org/Kategorie:T...on-Entwicklung

[Lupus]

Hum, I don't speak German and the traduction of Google seems to be...

Read this blog : http://blog.qzminski.com/article/cre...he-basics.html

Create Contao modules is very simple if you know your basics ;-)

[Andreas]

You can show datasets from every table in FE with the FE listing module. It's on board.

[tetrijeb]

You can show datasets from every table in FE with the FE listing module. It's on board.

Excellent, that is what I was looking for.

Still, I have to made some modification to list_default file, since I don't need search form, etc. but that should be easier than creating my own module.

Thanks.

[Andreas]

Yes, with this module the template is just an example. In nearly all cases you have to create your own template for the listing module.