Custom code to show this statistics

jimie Total numbers of listings in that section ( this probably already a option in the module )

Count all listings in section

$sql = "SELECT count(*) FROM #__js_res_record WHERE section_id = 1";

jimie Total numbers of new listings in that section

Count listings for last 3 days.

$sql = "SELECT count(*) FROM #__js_res_record WHERE section_id = 1 AND ctime > NOW() - INTERVAL 3 DAY";

jimie Total number of listings which are about to expire in that section

Count listings that expire in 3 days

$sql = "SELECT count(*) FROM #__js_res_record WHERE section_id = 1 AND extime > NOW() AND extime < NOW() + INTERVAL 3 DAY";

All $sql queries works like this.

$db = Jfactory::getDbo();
$db->setQuery($sql);
echo $db->loadResult();

And of course you have to change 1 to real section ID.

Big thanks Sergey!

+1

BTW, if the SQLs are called in a custom module or stats module... how does one cache such infos? Is there a Cobalt method or utilize J! core?

You do not need to cache it I think. Because you show it only in one place.

Hello Sergey,

What about updating those queries to show only published items but not those which are not published ?

rgds

jimie ... show only published items ...?

Simply add the following parameter:

AND published = 1

Example Section 99:

$sql = "SELECT count(*) FROM #__js_res_record WHERE section_id = 99 AND published = 1";