Counting Totals and Recent Comments

[kopojib]

Hello,

I looked at the forum and it seems that there were no similar posts before.

We would like to have some stats on the frontpage. The idea is to show:

1. total number of "News" for all site
2. total number of "News" for each category
3. total number of "Comments" for all site
4. "Recent Comments" to show as a module in a newslist style

Would you be so kind to let me know how these could be done?

Thank you very much

Cantao 2.9.0 on LAMP stack.

[kopojib]

Can somebody from support reply with the advise, please?

[ramjet]

Can somebody from support reply

there isn't anyone from "support" kopojib, just Contao users like yourself
you would probably need to make a frontend module to do this, unless anyone has written something similar in the extension repository...
it could also be done via a php script placed in the templates folder, and called with the file inserttag via a article element or custom html module.
the php code would need to sql query the database, and echo back the results wrapped in the appropriate html

[kopojib]

ramjet,

thanks for reply ;-) There is nothing similar in extensions.

I figured out how to do SQL: SELECT Count(*) FROM `tl_news` WHERE `pid`=1

same stuff can be done for RECENT COMMENTS.

However, I do not have experience how to integrate this into php (

Would anybody be interested to help? we are launching football tournament website and need this feature to display basic stats about site.