Файловый менеджер - Редактировать - /var/www/html/components/com_community/models/phototagging.php
Ðазад
<?php /** * @copyright (C) 2013 iJoomla, Inc. - All rights reserved. * @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html) * @author iJoomla.com <webmaster@ijoomla.com> * @url https://www.jomsocial.com/license-agreement * The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0 * More info at https://www.jomsocial.com/license-agreement */ use Joomla\CMS\Factory; // Disallow direct access to this file defined('_JEXEC') or die('Restricted access'); jimport('joomla.application.component.model'); require_once( JPATH_ROOT .'/components/com_community/models/models.php' ); /** * JomSocial Model file for photo tagging */ class CommunityModelPhotoTagging extends JCCModel { // var $id = null; // var $photoid = null; // var $userid = null; // var $position = null; // var $created_by = null; // var $created = null; var $_error = null; /* public array to retrieve return value */ public $return_value = array(); public function getError( $i = null, $toString = true ) { return $this->_error; } public function isTagExists($photoId, $userId) { $db = $this->getDBO(); $query = 'SELECT COUNT(1) AS CNT FROM '.$db->quoteName('#__community_photos_tag'); $query .= ' WHERE '.$db->quoteName('photoid').' = ' . $db->Quote($photoId); $query .= ' AND '.$db->quoteName('userid').' = ' . $db->Quote($userId); $db->setQuery($query); try { $result = $db->loadResult(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); return false; } return (empty($result)) ? false : true; } public function addTag( $photoId, $userId, $position) { $db = $this->getDBO(); $my = CFactory::getUser(); $date = JDate::getInstance(); //get the time without any offset! $data = new stdClass(); $data->photoid = $photoId; $data->userid = $userId; $data->position = $position; $data->created_by = $my->id; $data->created = $date->toSql(); try { $db->insertObject('#__community_photos_tag', $data); $this->_error = null; $this->return_value[__FUNCTION__] = true; } catch (Exception $e) { $this->return_value[__FUNCTION__] = false; throw $e; } return $this; } public function removeTag( $photoId, $userId ) { $db = $this->getDBO(); $query = 'DELETE FROM '.$db->quoteName('#__community_photos_tag'); $query .= ' WHERE '.$db->quoteName('photoid').' = ' . $db->Quote($photoId); $query .= ' AND '.$db->quoteName('userid').' = ' . $db->Quote($userId); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); return false; } return true; } public function removeTagByPhoto($photoId) { $db = $this->getDBO(); $query = 'DELETE FROM '.$db->quoteName('#__community_photos_tag'); $query .= ' WHERE '.$db->quoteName('photoid').' = ' . $db->Quote($photoId); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); return false; } return true; } public function getTagId( $photoId, $userId ) { $db = $this->getDBO(); $query = 'SELECT '.$db->quoteName('id').' FROM '.$db->quoteName('#__community_photos_tag'); $query .= ' WHERE '.$db->quoteName('photoid').' = ' . $db->Quote($photoId); $query .= ' AND '.$db->quoteName('userid').' = ' . $db->Quote($userId); $db->setQuery($query); try { $result = $db->loadResult(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $result; } public function getTaggedList( $photoId ) { $db = $this->getDBO(); $query = 'SELECT a.* FROM '.$db->quoteName('#__community_photos_tag').' as a'; $query .= ' JOIN '.$db->quoteName('#__users').'as b ON a.'.$db->quoteName('userid').'=b.'.$db->quoteName('id').' AND b.'.$db->quoteName('block').'=0'; $query .= ' WHERE a.'.$db->quoteName('photoid').' = ' . $db->Quote($photoId); $query .= ' ORDER BY a.'.$db->quoteName('id'); $db->setQuery($query); try { $result = $db->loadObjectList(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $result; } public function getFriendList( $photoId ) { $db = $this->getDBO(); $my = CFactory::getUser(); $query = 'SELECT DISTINCT(a.'.$db->quoteName('connect_to').') AS id '; $query .= ' FROM '.$db->quoteName('#__community_connection').' AS a'; $query .= ' INNER JOIN '.$db->quoteName('#__users').' AS b'; $query .= ' ON a.'.$db->quoteName('connect_from').' = ' . $db->Quote( $my->id ) ; $query .= ' AND a.'.$db->quoteName('connect_to').' = b.'.$db->quoteName('id'); $query .= ' AND a.'.$db->quoteName('status').' = '.$db->Quote('1'); $query .= ' AND NOT EXISTS ('; $query .= ' SELECT '.$db->quoteName('userid').' FROM '.$db->quoteName('#__community_photos_tag').' AS c' .' WHERE c.'.$db->quoteName('userid').' = a.`'.$db->quoteName('connect_to') .' AND c.'.$db->quoteName('photoid').' = ' . $db->Quote( $photoId ); $query .= ')'; $db->setQuery($query); try { $result = $db->loadObjectList(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $result; } } ?>
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка