| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/administrator/modules/mod_k2_stats/ |
Upload File : |
<?php
/**
* @version 2.6.x
* @package K2
* @author JoomlaWorks http://www.joomlaworks.net
* @copyright Copyright (c) 2006 - 2014 JoomlaWorks Ltd. All rights reserved.
* @license GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
*/
// no direct access
defined('_JEXEC') or die ;
class modK2StatsHelper
{
public static function getLatestItems()
{
$db = JFactory::getDBO();
$query = "SELECT i.*, v.name AS author FROM #__k2_items as i
LEFT JOIN #__k2_categories AS c ON c.id = i.catid
LEFT JOIN #__users AS v ON v.id = i.created_by
WHERE i.trash = 0 AND c.trash = 0
ORDER BY i.created DESC";
if (K2_JVERSION != '15')
{
$query = JString::str_ireplace('#__groups', '#__viewlevels', $query);
$query = JString::str_ireplace('g.name', 'g.title', $query);
}
$db->setQuery($query, 0, 10);
$rows = $db->loadObjectList();
return $rows;
}
public static function getPopularItems()
{
$db = JFactory::getDBO();
$query = "SELECT i.*, v.name AS author FROM #__k2_items as i
LEFT JOIN #__k2_categories AS c ON c.id = i.catid
LEFT JOIN #__users AS v ON v.id = i.created_by
WHERE i.trash = 0 AND c.trash = 0
ORDER BY i.hits DESC";
$db->setQuery($query, 0, 10);
$rows = $db->loadObjectList();
return $rows;
}
public static function getMostCommentedItems()
{
$db = JFactory::getDBO();
$query = "SELECT i.*, v.name AS author, (SELECT COUNT(*) FROM #__k2_comments WHERE itemID = i.id) AS numOfComments FROM #__k2_items as i
LEFT JOIN #__k2_categories AS c ON c.id = i.catid
LEFT JOIN #__users AS v ON v.id = i.created_by
WHERE i.trash = 0 AND c.trash = 0
ORDER BY numOfComments DESC";
$db->setQuery($query, 0, 10);
$rows = $db->loadObjectList();
return $rows;
}
public static function getLatestComments()
{
$db = JFactory::getDBO();
$query = "SELECT * FROM #__k2_comments ORDER BY commentDate DESC";
$db->setQuery($query, 0, 10);
$rows = $db->loadObjectList();
return $rows;
}
public static function getStatistics()
{
$statistics = new stdClass;
$statistics->numOfItems = self::countItems();
$statistics->numOfTrashedItems = self::countTrashedItems();
$statistics->numOfFeaturedItems = self::countFeaturedItems();
$statistics->numOfComments = self::countComments();
$statistics->numOfCategories = self::countCategories();
$statistics->numOfTrashedCategories = self::countTrashedCategories();
$statistics->numOfUsers = self::countUsers();
$statistics->numOfUserGroups = self::countUserGroups();
$statistics->numOfTags = self::countTags();
return $statistics;
}
public static function countItems()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_items";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countTrashedItems()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_items WHERE trash=1";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countFeaturedItems()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_items WHERE featured=1";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countComments()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_comments";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countCategories()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_categories";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countTrashedCategories()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_categories WHERE trash=1";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countUsers()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_users";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countUserGroups()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_user_groups";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
public static function countTags()
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_tags";
$db->setQuery($query);
$result = $db->loadResult();
return $result;
}
}