File Metadata

Created: Sat, Jan 31, 10:14 PM

filenames_helper.php
View Options

	<?php
	/**
	* @version $Id: filenames_helper.php 12734 2009-10-20 19:28:11Z alex $
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class kFilenamesHelper extends kHelper {

	/**
	* Character, that should replace disallowed symbols in filename
	*
	* @var string
	*/
	var $_escapeChar = '_';

	/**
	* Sequences, that should be replaced with mathing sequences from _filenameReplaceTo property
	*
	* @var Array
	*/
	var $_filenameReplaceFrom = Array ();

	/**
	* Sequences, that will replace matching sequences from _filenameReplaceFrom property
	*
	* @var Array
	*/
	var $_filenameReplaceTo = Array ();


	function kFilenamesHelper()
	{
	parent::kHelper();

	$this->_escapeChar = $this->Application->ConfigValue('FilenameSpecialCharReplacement');

	$language =& $this->Application->recallObject('lang.current');
	/* @var $language kDBItem */

	$replacements = $language->GetDBField('FilenameReplacements');
	if ($replacements) {
	$replacements = explode("\r\n", $replacements);
	foreach ($replacements as $replacement) {
	list ($replace_from, $replace_to) = explode('=', $replacement);
	$this->_filenameReplaceFrom[] = trim($replace_from);
	$this->_filenameReplaceTo[] = trim($replace_to);
	}
	}
	}

	function replaceSequences($filename)
	{
	$not_allowed = Array (
	' ', '\\', '/', ':', '*', '?', '"', '<', '>', '\|', '`',
	'~', '!', '@', '#', '$', '%', '^', '&', '(', ')', '~',
	'+', '=', '-', '{', '}', ']', '[', "'", ';', '.', ',', "\r", "\n"
	);

	if ($this->_filenameReplaceFrom) {
	// replace predefined sequences
	$filename = str_replace($this->_filenameReplaceFrom, $this->_filenameReplaceTo, $filename);
	}

	$filename = str_replace($not_allowed, $this->_escapeChar, $filename);
	$filename = preg_replace('/(' . $this->_escapeChar . '+)/', $this->_escapeChar, $filename);
	return trim($filename, $this->_escapeChar); // remove trailing escape chars
	}

	/**
	* replace not allowed symbols with "_" chars + remove duplicate "_" chars in result
	*
	* @param string $string
	* @return string
	*/
	function stripDisallowed($table, $id_field, $item_id, $filename)
	{
	$filename = $this->replaceSequences($filename);

	return $this->checkAutoFilename($table, $id_field, $item_id, $filename);
	}

	function checkAutoFilename($table, $id_field, $item_id, $filename)
	{
	if(!$filename) return $filename;

	$item_id = !$item_id ? 0 : $item_id;

	if ($table == TABLE_PREFIX.'CategoryItems') {
	$item_categories_cur = $this->Conn->GetCol('SELECT CategoryId FROM '.$table.' WHERE ItemResourceId = '.$item_id);
	$item_categories_live = $this->Application->IsTempTable($table) ? $this->Conn->GetCol('SELECT CategoryId FROM '.$this->Application->GetLiveName($table).' WHERE ItemResourceId = '.$item_id) : array();

	$item_categories = array_unique(array_merge($item_categories_cur, $item_categories_live));
	if (!$item_categories) {
	$item_categories = array($this->Application->GetVar('m_cat_id')); // this may happen when creating new item
	}
	$cat_filter = ' AND CategoryId IN ('.implode(',', $item_categories).')';
	}
	else {
	$cat_filter = '';
	}

	// check current table (temp or live)
	$sql_temp = 'SELECT '.$id_field.' FROM '.$table.' WHERE Filename = '.$this->Conn->qstr($filename).$cat_filter;
	$found_temp_ids = $this->Conn->GetCol($sql_temp);

	// check live table if current is temp
	if ( $this->Application->IsTempTable($table) ) {
	$sql_live = 'SELECT '.$id_field.' FROM '.$this->Application->GetLiveName($table).' WHERE Filename = '.$this->Conn->qstr($filename).$cat_filter;
	$found_live_ids = $this->Conn->GetCol($sql_live);
	}
	else {
	$found_live_ids = array();
	}

	$found_item_ids = array_unique( array_merge($found_temp_ids, $found_live_ids) );

	$has_page = preg_match('/(.)_([\d]+)([a-z])$/', $filename, $rets);

	$duplicates_found = (count($found_item_ids) > 1) \|\| ($found_item_ids && $found_item_ids[0] != $item_id);
	if ($duplicates_found \|\| $has_page) // other category has same filename as ours OR we have filename, that ends with _number
	{
	$append = $duplicates_found ? '_a' : '';
	if($has_page)
	{
	$filename = $rets[1].'_'.$rets[2];
	$append = $rets[3] ? $rets[3] : '_a';
	}

	// check live & temp table
	$sql_cur = 'SELECT '.$id_field.' FROM '.$table.' WHERE (Filename = %s) AND ('.$id_field.' != '.$item_id.')'.$cat_filter;
	$sql_live = $this->Application->IsTempTable($table) ? 'SELECT '.$id_field.' FROM '.$this->Application->GetLiveName($table).' WHERE (Filename = %s) AND ('.$id_field.' != '.$item_id.')'.$cat_filter : false;
	while ( $this->Conn->GetOne( sprintf($sql_cur, $this->Conn->qstr($filename.$append)) ) > 0 \|\|
	( $sql_live
	&&
	( $this->Conn->GetOne( sprintf($sql_live, $this->Conn->qstr($filename.$append)) ) > 0 )
	)
	)
	{
	if (mb_substr($append, -1) == 'z') $append .= 'a';
	$append = mb_substr($append, 0, mb_strlen($append) - 1) . chr( ord( mb_substr($append, -1) ) + 1 );
	}

	return $filename.$append;
	}

	return $filename;
	}
	}

filenames_helper.php
No OneTemporary
Actions

File Metadata

filenames_helper.php
View Options

Event Timeline

filenames_helper.phpNo OneTemporaryActions

File Metadata

filenames_helper.phpView Options

Event Timeline

filenames_helper.php
No OneTemporary
Actions

filenames_helper.php
View Options