File manager - Edit - /home/jardides/www/Jardi-design/old/administrator/components/com_phocadownload/helpers/phocauserstat.php
Back
<?php /* * @package Joomla 1.5 * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved. * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php * * @component Phoca Component * @copyright Copyright (C) Jan Pavelka www.phoca.cz * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL */ // Check to ensure this file is included in Joomla! defined('_JEXEC') or die(); jimport('joomla.application.component.model'); class PhocaUserStatHelper { function createUserStatEntry($downloadId) { $db = JFactory::getDBO(); $user = JFactory::getUser(); $query = ' SELECT * FROM '.$db->quoteName('#__phocadownload_user_stat') .' WHERE '. $db->quoteName('userid') .' = ' .$db->Quote((int)$user->id) .' AND '. $db->quoteName('fileid') .' = ' .$db->Quote((int)$downloadId); $db->setQuery($query); $results = $db->loadObjectList(); $date = gmdate('Y-m-d H:i:s'); if ($results) { // Update count $query = 'UPDATE '.$db->quoteName('#__phocadownload_user_stat') .' SET count = (count + 1),' .' date = '.$db->Quote($date) .' WHERE userid = '.$db->Quote((int)$user->id) .' AND fileid = '.$db->Quote((int)$downloadId); $db->setQuery($query); $db->query(); } else { $query = 'INSERT INTO '.$db->quoteName('#__phocadownload_user_stat') .' ('.$db->quoteName('count').',' .' '.$db->quoteName('userid').',' .' '.$db->quoteName('fileid').',' .' '.$db->quoteName('date').')' .' VALUES ('.$db->Quote(1).',' .' '.$db->Quote((int)$user->id).',' .' '.$db->Quote((int)$downloadId).',' .' '.$db->Quote($date).')'; $db->setQuery($query); $db->query(); } return true; } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings