| Server IP : 54.36.91.62 / Your IP : 216.73.217.111 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/amisdesseniors-fr/lyon/modules/mod_djclassifieds_stats/ |
Upload File : |
<?php
/**
* @package DJ-Classifieds
* @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
* @license http://www.gnu.org/licenses GNU/GPL
* @author url: http://dj-extensions.com
* @author email contact@dj-extensions.com
*/
defined ('_JEXEC') or die('Restricted access');
class modDjClassifiedsStats
{
public static function getAdverts($pub=1, $date_from='')
{
$db = JFactory::getDBO();
$date_now = JFactory::getDate()->toSQL();
$pub_w = '';
if($pub){
$pub_w = " AND i.published=1 AND i.blocked=0 AND i.date_exp > '".$date_now."' ";
}
$date_from_w = '';
if($date_from){
$date_from_w = " AND i.date_start>='".$date_from."' ";
}
$query = "SELECT COUNT(id) FROM #__djcf_items i WHERE 1 ".$pub_w.$date_from_w;
$db->setQuery($query);
$total = $db->loadResult();
return $total;
}
public static function getAuctions()
{
$db = JFactory::getDBO();
$date_now = JFactory::getDate()->toSQL();
$query = "SELECT COUNT(id) FROM #__djcf_items i WHERE i.date_exp > '".$date_now."' AND i.auction=1 AND i.published=1 AND i.blocked=0";
$db->setQuery($query);
$total = $db->loadResult();
return $total;
}
public static function getCategories()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(id) FROM #__djcf_categories WHERE published=1";
$db->setQuery($query);
$total = $db->loadResult();
return $total;
}
}