We run Joomla 3.4.4 with CB 2.0.10.
We would like to encourage our users to use the option to add a canvas picture to the profile.
In order to support this I would like to add a module with som HTML code, but also a SELECT statement that counts the number of records in table xxx_comprofiler where not 'canvas' is NULL.
I think a Custom HTML module is suitable for that, but what code do I need to provide in the module?
Something around the:
Code:
SELECT COUNT(canvas) AS canvascount FROM `mx5j3_comprofiler` WHERE not `canvas` is null
