Show number of category members in a module

[lnino]

Hi,

I am using Phoca Download on Joomla 3.

It would be great having a module which displays the number of category members.
For instance: This site hosts 85 videos.

Is there an existing module for that?

Thanks for your help.

greetings
Nino

[Jan]

Hi, for now I don't know any such module, this can be displayed in the component next to category name

Jan

[lnino]

Isn't there something simple like a global var?

For example:

This website hosts {pdcategorymax} videos!

The number of the category members are some kind of stored like you said.
Can't I access this var via HTML?

Thanks for your help.

[lnino]

Is there maybe a way to display the number of files of a category via HTML?
It don't have to be a component or plugin.
I can also put it somwhere on the website via HTML.

The number has to stored somewhere, right?
Is there no way to access the number?

I am looking forward to your reply.

[Jan]

Hi, HTML is static part, so you need to use php and mysql - php for programming it and mysql for getting the data from database - if you will add it to some new module or you will paste it to some part of your site, this does not matter, as in both cases, you need to program it

Jan

[lnino]

Hi,

thanks for your reply.

I am familiar with php, this should not be the problem.
I have to google how to connect to a mysql db.

So you say that the values of phoca download are stored in a mysql database.
Can you tell me in which cell and table the information for the number of category members is stored?
So I can read it out of the database and store it in a variable for displaying it on my website.

greetings
Nino

[Jan]

Hi, you can find all the information about the sql tables in ZIP installation package:

in install/sql/mysql/install.utf8.sql

Jan