325 lines
8.3 KiB
PHP
325 lines
8.3 KiB
PHP
|
<?php
|
|||
|
|
/**
|
|||
|
|
* @version $Id: k2item.php 1901 2013-02-08 19:29:12Z lefteris.kavadas $
|
|||
|
|
* @package K2
|
|||
|
|
* @author JoomlaWorks http://www.joomlaworks.net
|
|||
|
|
* @copyright Copyright (c) 2006 - 2013 JoomlaWorks Ltd. All rights reserved.
|
|||
|
|
* @license GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
// no direct access
|
|||
|
|
defined('_JEXEC') or die ;
|
|||
|
|
|
|||
|
|
class TableK2Item extends K2Table
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
var $id = null;
|
|||
|
|
var $title = null;
|
|||
|
|
var $alias = null;
|
|||
|
|
var $catid = null;
|
|||
|
|
var $published = null;
|
|||
|
|
var $introtext = null;
|
|||
|
|
var $fulltext = null;
|
|||
|
|
var $image_caption = null;
|
|||
|
|
var $image_credits = null;
|
|||
|
|
var $video = null;
|
|||
|
|
var $video_caption = null;
|
|||
|
|
var $video_credits = null;
|
|||
|
|
var $gallery = null;
|
|||
|
|
var $extra_fields = null;
|
|||
|
|
var $extra_fields_search = null;
|
|||
|
|
var $created = null;
|
|||
|
|
var $created_by = null;
|
|||
|
|
var $created_by_alias = null;
|
|||
|
|
var $modified = null;
|
|||
|
|
var $modified_by = null;
|
|||
|
|
var $publish_up = null;
|
|||
|
|
var $publish_down = null;
|
|||
|
|
var $checked_out = null;
|
|||
|
|
var $checked_out_time = null;
|
|||
|
|
var $trash = null;
|
|||
|
|
var $access = null;
|
|||
|
|
var $ordering = null;
|
|||
|
|
var $featured = null;
|
|||
|
|
var $featured_ordering = null;
|
|||
|
|
var $hits = null;
|
|||
|
|
var $metadata = null;
|
|||
|
|
var $metadesc = null;
|
|||
|
|
var $metakey = null;
|
|||
|
|
var $params = null;
|
|||
|
|
var $plugins = null;
|
|||
|
|
var $language = null;
|
|||
|
|
|
|||
|
|
function __construct(&$db)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
parent::__construct('#__k2_items', 'id', $db);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
function check()
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
jimport('joomla.filter.output');
|
|||
|
|
$params = JComponentHelper::getParams('com_k2');
|
|||
|
|
$this->title = JString::trim($this->title);
|
|||
|
|
if ($this->title == '')
|
|||
|
|
{
|
|||
|
|
$this->setError(JText::_('K2_ITEM_MUST_HAVE_A_TITLE'));
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
if (!$this->catid)
|
|||
|
|
{
|
|||
|
|
$this->setError(JText::_('K2_ITEM_MUST_HAVE_A_CATEGORY'));
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
if (empty($this->alias))
|
|||
|
|
{
|
|||
|
|
$this->alias = $this->title;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (K2_JVERSION == '15')
|
|||
|
|
{
|
|||
|
|
if (JPluginHelper::isEnabled('system', 'unicodeslug') || JPluginHelper::isEnabled('system', 'jw_unicodeSlugsExtended'))
|
|||
|
|
{
|
|||
|
|
$this->alias = JFilterOutput::stringURLSafe($this->alias);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
mb_internal_encoding("UTF-8");
|
|||
|
|
mb_regex_encoding("UTF-8");
|
|||
|
|
$this->alias = trim(mb_strtolower($this->alias));
|
|||
|
|
$this->alias = str_replace('-', ' ', $this->alias);
|
|||
|
|
$this->alias = str_replace('/', '-', $this->alias);
|
|||
|
|
$this->alias = mb_ereg_replace('[[:space:]]+', ' ', $this->alias);
|
|||
|
|
$this->alias = trim(str_replace(' ', '-', $this->alias));
|
|||
|
|
$this->alias = str_replace('.', '', $this->alias);
|
|||
|
|
$this->alias = str_replace('"', '', $this->alias);
|
|||
|
|
$this->alias = str_replace("'", '', $this->alias);
|
|||
|
|
$stripthese = ',|~|!|@|%|^|(|)|<|>|:|;|{|}|[|]|&|`|„|‹|’|‘|“|â€<C3A2>|•|›|«|´|»|°|«|»|…';
|
|||
|
|
$strips = explode('|', $stripthese);
|
|||
|
|
foreach ($strips as $strip)
|
|||
|
|
{
|
|||
|
|
$this->alias = str_replace($strip, '', $this->alias);
|
|||
|
|
}
|
|||
|
|
if (trim(str_replace('-', '', $this->alias)) == '')
|
|||
|
|
{
|
|||
|
|
$datenow = JFactory::getDate();
|
|||
|
|
$this->alias = $datenow->toFormat("%Y-%m-%d-%H-%M-%S");
|
|||
|
|
}
|
|||
|
|
$this->alias = trim($this->alias, '-.');
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
if (JFactory::getConfig()->get('unicodeslugs') == 1)
|
|||
|
|
{
|
|||
|
|
$this->alias = JFilterOutput::stringURLUnicodeSlug($this->alias);
|
|||
|
|
}
|
|||
|
|
// Transliterate properly...
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
// Detect the site language we will transliterate
|
|||
|
|
if ($this->language == '*')
|
|||
|
|
{
|
|||
|
|
$langParams = JComponentHelper::getParams('com_languages');
|
|||
|
|
$languageTag = $langParams->get('site');
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
$languageTag = $this->language;
|
|||
|
|
}
|
|||
|
|
$language = JLanguage::getInstance($languageTag);
|
|||
|
|
$this->alias = $language->transliterate($this->alias);
|
|||
|
|
$this->alias = JFilterOutput::stringURLSafe($this->alias);
|
|||
|
|
if (trim(str_replace('-', '', $this->alias)) == '')
|
|||
|
|
{
|
|||
|
|
$this->alias = JFactory::getDate()->format('Y-m-d-H-i-s');
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (K2_JVERSION == '15' || $params->get('enforceSEFReplacements'))
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
$SEFReplacements = array();
|
|||
|
|
$items = explode(',', $params->get('SEFReplacements'));
|
|||
|
|
foreach ($items as $item)
|
|||
|
|
{
|
|||
|
|
if (!empty($item))
|
|||
|
|
{
|
|||
|
|
@list($src, $dst) = explode('|', trim($item));
|
|||
|
|
$SEFReplacements[trim($src)] = trim($dst);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
foreach ($SEFReplacements as $key => $value)
|
|||
|
|
{
|
|||
|
|
$this->alias = str_replace($key, $value, $this->alias);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$this->alias = trim($this->alias, '-.');
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (K2_JVERSION == '15')
|
|||
|
|
{
|
|||
|
|
if (trim(str_replace('-', '', $this->alias)) == '')
|
|||
|
|
{
|
|||
|
|
$datenow = JFactory::getDate();
|
|||
|
|
$this->alias = $datenow->toFormat("%Y-%m-%d-%H-%M-%S");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// Check if alias already exists. If so warn the user
|
|||
|
|
$params = JComponentHelper::getParams('com_k2');
|
|||
|
|
if ($params->get('k2Sef') && !$params->get('k2SefInsertItemId'))
|
|||
|
|
{
|
|||
|
|
$db = JFactory::getDBO();
|
|||
|
|
$db->setQuery("SELECT id FROM #__k2_items WHERE alias = ".$db->quote($this->alias)." AND id != ".(int)$this->id);
|
|||
|
|
$result = count($db->loadObjectList());
|
|||
|
|
if ($result > 1)
|
|||
|
|
{
|
|||
|
|
$this->alias .= '-'.(int)$result + 1;
|
|||
|
|
$application = JFactory::getApplication();
|
|||
|
|
$application->enqueueMessage(JText::_('K2_WARNING_DUPLICATE_TITLE_ALIAS_DETECTED'), 'notice');
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return true;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
function bind($array, $ignore = '')
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if (key_exists('params', $array) && is_array($array['params']))
|
|||
|
|
{
|
|||
|
|
$registry = new JRegistry();
|
|||
|
|
$registry->loadArray($array['params']);
|
|||
|
|
$array['params'] = $registry->toString();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (key_exists('plugins', $array) && is_array($array['plugins']))
|
|||
|
|
{
|
|||
|
|
$registry = new JRegistry();
|
|||
|
|
$registry->loadArray($array['plugins']);
|
|||
|
|
$array['plugins'] = $registry->toString();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return parent::bind($array, $ignore);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
function getNextOrder($where = '', $column = 'ordering')
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
$query = "SELECT MAX({$column}) FROM #__k2_items";
|
|||
|
|
$query .= ($where ? " WHERE ".$where : "");
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
$maxord = $this->_db->loadResult();
|
|||
|
|
if ($this->_db->getErrorNum())
|
|||
|
|
{
|
|||
|
|
$this->setError($this->_db->getErrorMsg());
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
return $maxord + 1;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
function reorder($where = '', $column = 'ordering')
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
$k = $this->_tbl_key;
|
|||
|
|
$query = "SELECT {$this->_tbl_key}, {$column} FROM #__k2_items WHERE {$column}>0";
|
|||
|
|
$query .= ($where ? " AND ".$where : "");
|
|||
|
|
$query .= " ORDER BY {$column}";
|
|||
|
|
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
if (!($orders = $this->_db->loadObjectList()))
|
|||
|
|
{
|
|||
|
|
$this->setError($this->_db->getErrorMsg());
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
for ($i = 0, $n = count($orders); $i < $n; $i++)
|
|||
|
|
{
|
|||
|
|
if ($orders[$i]->$column >= 0)
|
|||
|
|
{
|
|||
|
|
if ($orders[$i]->$column != $i + 1)
|
|||
|
|
{
|
|||
|
|
$orders[$i]->$column = $i + 1;
|
|||
|
|
$query = "UPDATE #__k2_items SET {$column}=".(int)$orders[$i]->$column;
|
|||
|
|
$query .= ' WHERE '.$k.' = '.$this->_db->Quote($orders[$i]->$k);
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
$this->_db->query();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
function move($dirn, $where = '', $column = 'ordering')
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
$k = $this->_tbl_key;
|
|||
|
|
|
|||
|
|
$sql = "SELECT $this->_tbl_key, {$column} FROM $this->_tbl";
|
|||
|
|
|
|||
|
|
if ($dirn < 0)
|
|||
|
|
{
|
|||
|
|
$sql .= ' WHERE '.$column.' < '.(int)$this->$column;
|
|||
|
|
$sql .= ($where ? ' AND '.$where : '');
|
|||
|
|
$sql .= ' ORDER BY '.$column.' DESC';
|
|||
|
|
}
|
|||
|
|
else if ($dirn > 0)
|
|||
|
|
{
|
|||
|
|
$sql .= ' WHERE '.$column.' > '.(int)$this->$column;
|
|||
|
|
$sql .= ($where ? ' AND '.$where : '');
|
|||
|
|
$sql .= ' ORDER BY '.$column;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
$sql .= ' WHERE '.$column.' = '.(int)$this->$column;
|
|||
|
|
$sql .= ($where ? ' AND '.$where : '');
|
|||
|
|
$sql .= ' ORDER BY '.$column;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$this->_db->setQuery($sql, 0, 1);
|
|||
|
|
|
|||
|
|
$row = null;
|
|||
|
|
$row = $this->_db->loadObject();
|
|||
|
|
|
|||
|
|
if (isset($row))
|
|||
|
|
{
|
|||
|
|
$query = 'UPDATE '.$this->_tbl.' SET '.$column.' = '.(int)$row->$column.' WHERE '.$this->_tbl_key.' = '.$this->_db->Quote($this->$k);
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
|
|||
|
|
if (!$this->_db->query())
|
|||
|
|
{
|
|||
|
|
$err = $this->_db->getErrorMsg();
|
|||
|
|
JError::raiseError(500, $err);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$query = 'UPDATE '.$this->_tbl.' SET '.$column.' = '.(int)$this->$column.' WHERE '.$this->_tbl_key.' = '.$this->_db->Quote($row->$k);
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
|
|||
|
|
if (!$this->_db->query())
|
|||
|
|
{
|
|||
|
|
$err = $this->_db->getErrorMsg();
|
|||
|
|
JError::raiseError(500, $err);
|
|||
|
|
}
|
|||
|
|
$this->$column = $row->$column;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
$query = 'UPDATE '.$this->_tbl.' SET '.$column.' = '.(int)$this->$column.' WHERE '.$this->_tbl_key.' = '.$this->_db->Quote($this->$k);
|
|||
|
|
$this->_db->setQuery($query);
|
|||
|
|
|
|||
|
|
if (!$this->_db->query())
|
|||
|
|
{
|
|||
|
|
$err = $this->_db->getErrorMsg();
|
|||
|
|
JError::raiseError(500, $err);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|