| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 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/administrator/components/com_comment/models/ |
Upload File : |
<?php
/**
* @author Daniel Dimitrov - compojoom.com
* @date: 02.04.13
*
* @copyright Copyright (C) 2008 - 2013 compojoom.com . All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE
*/
defined('_JEXEC') or die('Restricted access');
jimport('joomla.application.component.modellist');
class ccommentModelDashboard extends JModelList
{
public function getLatest()
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select("*")->from('#__comment')->order('date DESC');
$db->setQuery($query, 0, 5);
return $db->loadObjectList();
}
public function getStats($type) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select("COUNT('*') as count, COUNT(DISTINCT userid) as users, COUNT(DISTINCT ip) as ip, DATE(date) as date")->from('#__comment')
->where('DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date')
->group('DATE(date)');
$db->setQuery($query);
return $db->loadObjectList();
}
}