Count the number of modules in a hook

[Nuvish]

I need to know the number of modules that appears in a hook to make a processing.

For example, if there is a number of non-pair modules, I would like to display a different module to fill in the space left.

There is there a way to do it?

[Raphaël Malié]

Hi, this is the query to get this total :

$sql = 'SELECT COUNT(hm.id_module) FROM '._DB_PREFIX_.'hook h
        INNER JOIN '._DB_PREFIX_.'hook_module hm ON h.id_hook = hm.id_hook
        WHERE h.name = \'NAME_OF_HOOK\'';
echo Db::getInstance()->getValue($sql);

[Nuvish]

Moreover, there is a need to know whether a module is appearing on the page instead of whether the module is installed.

Because i can have a module which is installed,but due to it not having any product to return,it just doesnt appear.

[Raphaël Malié]

This can't know this information, since all module have its own behavior.