Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
cache	[ DIR ]	drwxr-x---	2025-11-08 11:17
controller	[ DIR ]	drwxr-x---	2025-11-08 11:17
db	[ DIR ]	drwxr-x---	2025-11-08 11:17
exception	[ DIR ]	drwxr-x---	2025-11-08 11:17
helper	[ DIR ]	drwxr-x---	2025-11-08 11:17
log	[ DIR ]	drwxr-x---	2025-11-08 11:17
module	[ DIR ]	drwxr-x---	2025-11-08 11:17
order	[ DIR ]	drwxr-x---	2025-11-08 11:17
pdf	[ DIR ]	drwxr-x---	2025-11-08 11:17
range	[ DIR ]	drwxr-x---	2025-11-08 11:17
shop	[ DIR ]	drwxr-x---	2025-11-08 11:17
stock	[ DIR ]	drwxr-x---	2025-11-08 11:17
tax	[ DIR ]	drwxr-x---	2025-11-08 11:17
tree	[ DIR ]	drwxr-x---	2025-11-08 11:17
webservice	[ DIR ]	drwxr-x---	2025-11-08 11:17
Address.php	12.64 KB	-rwxr-x---	2018-05-03 14:19
AddressFormat.php	16.96 KB	-rwxr-x---	2018-05-03 14:19
AdminTab.php	95.52 KB	-rwxr-x---	2018-05-03 14:19
Alias.php	3.71 KB	-rwxr-x---	2018-05-03 14:19
Attachment.php	5.85 KB	-rwxr-x---	2018-05-03 14:19
Attribute.php	10.76 KB	-rwxr-x---	2018-05-03 14:19
AttributeGroup.php	9.91 KB	-rwxr-x---	2018-05-03 14:19
CMS.php	7.16 KB	-rwxr-x---	2018-05-03 14:19
CMSCategory.php	20.26 KB	-rwxr-x---	2018-05-03 14:19
CSV.php	2.69 KB	-rwxr-x---	2018-05-03 14:19
Carrier.php	42.79 KB	-rwxr-x---	2018-05-03 14:19
Cart.php	127.88 KB	-rwxr-x---	2018-05-03 14:19
CartRule.php	53.52 KB	-rwxr-x---	2018-05-03 14:19
Category.php	54.72 KB	-rwxr-x---	2018-05-03 14:19
Chart.php	4.48 KB	-rwxr-x---	2018-05-03 14:19
Combination.php	9.76 KB	-rwxr-x---	2018-05-03 14:19
CompareProduct.php	4.75 KB	-rwxr-x---	2018-05-03 14:19
Configuration.php	17.81 KB	-rwxr-x---	2018-05-03 14:19
ConfigurationKPI.php	4.93 KB	-rwxr-x---	2018-05-03 14:19
ConfigurationTest.php	8.6 KB	-rwxr-x---	2018-05-03 14:19
Connection.php	8.67 KB	-rwxr-x---	2018-05-03 14:19
ConnectionsSource.php	4.45 KB	-rwxr-x---	2018-05-03 14:19
Contact.php	2.84 KB	-rwxr-x---	2018-05-03 14:19
Context.php	4.69 KB	-rwxr-x---	2018-05-03 14:19
Cookie.php	11.15 KB	-rwxr-x---	2018-05-03 14:19
Country.php	11.84 KB	-rwxr-x---	2018-05-03 14:19
County.php	3.22 KB	-rwxr-x---	2018-05-03 14:19
Currency.php	12.85 KB	-rwxr-x---	2018-05-03 14:19
Customer.php	27.11 KB	-rwxr-x---	2018-05-03 14:19
CustomerMessage.php	3.63 KB	-rwxr-x---	2018-05-03 14:19
CustomerThread.php	7.03 KB	-rwxr-x---	2018-05-03 14:19
Customization.php	4.46 KB	-rwxr-x---	2018-05-03 14:19
DateRange.php	2.08 KB	-rwxr-x---	2018-05-03 14:19
Delivery.php	2.8 KB	-rwxr-x---	2018-05-03 14:19
Discount.php	7.4 KB	-rwxr-x---	2018-05-03 14:19
Dispatcher.php	28.81 KB	-rwxr-x---	2018-05-03 14:19
Employee.php	13.4 KB	-rwxr-x---	2018-05-03 14:19
Feature.php	10.15 KB	-rwxr-x---	2018-05-03 14:19
FeatureValue.php	6.11 KB	-rwxr-x---	2018-05-03 14:19
FileUploader.php	9.02 KB	-rwxr-x---	2018-05-03 14:19
Gender.php	2.06 KB	-rwxr-x---	2018-05-03 14:19
Group.php	11.13 KB	-rwxr-x---	2018-05-03 14:19
GroupReduction.php	8.05 KB	-rwxr-x---	2018-05-03 14:19
Guest.php	6.25 KB	-rwxr-x---	2018-05-03 14:19
Hook.php	23.36 KB	-rwxr-x---	2018-05-03 14:19
Image.php	20.18 KB	-rwxr-x---	2018-05-03 14:19
ImageManager.php	14.55 KB	-rwxr-x---	2018-05-03 14:19
ImageType.php	4.99 KB	-rwxr-x---	2018-05-03 14:19
Language.php	31.94 KB	-rwxr-x---	2018-05-03 14:19
Link.php	23.51 KB	-rwxr-x---	2018-05-03 14:19
LocalizationPack.php	13.46 KB	-rwxr-x---	2018-05-03 14:19
Mail.php	16.12 KB	-rwxr-x---	2018-05-03 14:19
Manufacturer.php	14.33 KB	-rwxr-x---	2018-05-03 14:19
Media.php	29.56 KB	-rwxr-x---	2018-05-03 14:19
Message.php	5.28 KB	-rwxr-x---	2018-05-03 14:19
Meta.php	14.7 KB	-rwxr-x---	2018-05-03 14:19
Notification.php	5.54 KB	-rwxr-x---	2018-05-03 14:19
ObjectModel.php	51.85 KB	-rwxr-x---	2018-05-03 14:19
Pack.php	8.91 KB	-rwxr-x---	2018-05-03 14:19
Page.php	3.69 KB	-rwxr-x---	2018-05-03 14:19
PaymentCC.php	2.34 KB	-rwxr-x---	2018-05-03 14:19
PaymentModule.php	40.95 KB	-rwxr-x---	2018-05-03 14:19
PrestaShopBackup.php	8.64 KB	-rwxr-x---	2018-05-03 14:19
PrestaShopCollection.php	16.84 KB	-rwxr-x---	2018-05-03 14:19
PrestaShopLogger.php	5.38 KB	-rwxr-x---	2018-05-03 14:19
Product.php	190.49 KB	-rwxr-x---	2018-05-03 14:19
ProductDownload.php	8.74 KB	-rwxr-x---	2018-05-03 14:19
ProductSale.php	10.32 KB	-rwxr-x---	2018-05-03 14:19
ProductSupplier.php	6.71 KB	-rwxr-x---	2018-05-03 14:19
Profile.php	4.52 KB	-rwxr-x---	2018-05-03 14:19
QuickAccess.php	2.4 KB	-rwxr-x---	2018-05-03 14:19
Referrer.php	14.72 KB	-rwxr-x---	2018-05-03 14:19
RequestSql.php	15.4 KB	-rwxr-x---	2018-05-03 14:19
Risk.php	2.16 KB	-rwxr-x---	2018-05-03 14:19
Scene.php	8.28 KB	-rwxr-x---	2018-05-03 14:19
Search.php	30.58 KB	-rwxr-x---	2018-05-03 14:19
SearchEngine.php	2.25 KB	-rwxr-x---	2018-05-03 14:19
SpecificPrice.php	16.21 KB	-rwxr-x---	2018-05-03 14:19
SpecificPriceRule.php	10.71 KB	-rwxr-x---	2018-05-03 14:19
State.php	5.91 KB	-rwxr-x---	2018-05-03 14:19
Store.php	4.34 KB	-rwxr-x---	2018-05-03 14:19
Supplier.php	12.48 KB	-rwxr-x---	2018-05-03 14:19
Tab.php	16.66 KB	-rwxr-x---	2018-05-03 14:19
Tag.php	6.85 KB	-rwxr-x---	2018-05-03 14:19
Theme.php	8.01 KB	-rwxr-x---	2018-05-03 14:19
Tools.php	93.71 KB	-rwxr-x---	2018-05-03 14:19
Translate.php	8.54 KB	-rwxr-x---	2018-05-03 14:19
TranslatedConfiguration.php	3.59 KB	-rwxr-x---	2018-05-03 14:19
Upgrader.php	9.07 KB	-rwxr-x---	2018-05-03 14:19
Uploader.php	6.49 KB	-rwxr-x---	2018-05-03 14:19
Validate.php	27.13 KB	-rwxr-x---	2018-05-03 14:19
Zone.php	2.98 KB	-rwxr-x---	2018-05-03 14:19
index.php	1.24 KB	-rwxr-x---	2018-05-03 14:19

Rename

<?php
/*
* 2007-2014 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2014 PrestaShop SA
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

class RequestSqlCore extends ObjectModel
{
	public $name;
	public $sql;

/**
	 * @see ObjectModel::$definition
	 */
	public static $definition = array(
		'table' => 'request_sql',
		'primary' => 'id_request_sql',
		'fields' => array(
			'name' => 	array('type' => self::TYPE_STRING, 'validate' => 'isString', 'required' => true, 'size' => 200),
			'sql' => 	array('type' => self::TYPE_STRING, 'validate' => 'isString', 'required' => true),
		),
	);

/** @var array : List of params to tested */
	public $tested = array(
		'required' => array('SELECT', 'FROM'),
		'option' => array('WHERE', 'ORDER', 'LIMIT', 'HAVING', 'GROUP', 'UNION'),
		'operator' => array(
			'AND', '&&', 'BETWEEN', 'AND', 'BINARY', '&', '~', '|', '^', 'CASE', 'WHEN', 'END', 'DIV', '/', '<=>', '=', '>=',
			'>', 'IS', 'NOT', 'NULL', '<<', '<=', '<', 'LIKE', '-', '%', '!=', '<>', 'REGEXP', '!', '||', 'OR', '+', '>>', 'RLIKE', 'SOUNDS', '*',
			'-', 'XOR', 'IN'
		),
		'function' => array(
			'AVG', 'SUM', 'COUNT', 'MIN', 'MAX', 'STDDEV', 'STDDEV_SAMP', 'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP',
			'GROUP_CONCAT', 'BIT_AND', 'BIT_OR', 'BIT_XOR'
		),
		'unauthorized' => array(
			'DELETE', 'ALTER', 'INSERT', 'REPLACE', 'CREATE', 'TRUNCATE', 'OPTIMIZE', 'GRANT', 'REVOKE', 'SHOW', 'HANDLER',
			'LOAD', 'ROLLBACK', 'SAVEPOINT', 'UNLOCK', 'INSTALL', 'UNINSTALL', 'ANALZYE', 'BACKUP', 'CHECK', 'CHECKSUM', 'REPAIR', 'RESTORE', 'CACHE',
			'DESCRIBE', 'EXPLAIN', 'USE', 'HELP', 'SET', 'DUPLICATE', 'VALUES',  'INTO', 'RENAME', 'CALL', 'PROCEDURE',  'FUNCTION', 'DATABASE', 'SERVER',
			'LOGFILE', 'DEFINER', 'RETURNS', 'EVENT', 'TABLESPACE', 'VIEW', 'TRIGGER', 'DATA', 'DO', 'PASSWORD', 'USER', 'PLUGIN', 'FLUSH', 'KILL',
			'RESET', 'START', 'STOP', 'PURGE', 'EXECUTE', 'PREPARE', 'DEALLOCATE', 'LOCK', 'USING', 'DROP', 'FOR', 'UPDATE', 'BEGIN', 'BY', 'ALL', 'SHARE',
			'MODE', 'TO','KEY', 'DISTINCTROW', 'DISTINCT',  'HIGH_PRIORITY', 'LOW_PRIORITY', 'DELAYED', 'IGNORE', 'FORCE', 'STRAIGHT_JOIN',
			'SQL_SMALL_RESULT', 'SQL_BIG_RESULT', 'QUICK', 'SQL_BUFFER_RESULT', 'SQL_CACHE', 'SQL_NO_CACHE', 'SQL_CALC_FOUND_ROWS', 'WITH'
		)
	);

public $attributes = array(
		'passwd' => '*******************',
		'secure_key' => '*******************'
	);

/** @var array : list of errors */
	public $error_sql = array();

/**
	 * Get list of request SQL
	 *
	 * @static
	 * @return array|bool
	 */
	public static function getRequestSql()
	{
		if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('SELECT * FROM `'._DB_PREFIX_.'request_sql` ORDER BY `id_request_sql`'))
			return false;

$request_sql = array();
		foreach ($result as $row)
			$request_sql[] = $row['sql'];

return $request_sql;
	}

/**
	 * Get list of request SQL by id request
	 *
	 * @static
	 * @param $id
	 * @return array
	 */
	public static function getRequestSqlById($id)
	{
		return Db::getInstance()->executeS('SELECT `sql` FROM `'._DB_PREFIX_.'request_sql` WHERE `id_request_sql` = '.(int)$id);
	}

/**
	 * Call the parserSQL() method in Tools class
	 * Cut the request in table for check it
	 *
	 * @param $sql
	 * @return bool
	 */
	public function parsingSql($sql)
	{
		return Tools::parserSQL($sql);
	}

/**
	 * Check if the parsing of the SQL request is good or not
	 *
	 * @param $tab
	 * @param bool $in
	 * @param $sql
	 * @return bool
	 */
	public function validateParser($tab, $in = false, $sql)
	{
		if (!$tab)
			return false;
		else if (isset($tab['UNION']))
		{
			$union = $tab['UNION'];
			foreach ($union as $tab)
			{
				if (!$this->validateSql($tab, $in, $sql))
					return false;
			}
			return true;
		}
		else
			return $this->validateSql($tab, $in, $sql);
	}

/**
	 * Cut the request for check each cutting
	 *
	 * @param $tab
	 * @param $in
	 * @param $sql
	 * @return bool
	 */
	public function validateSql($tab, $in, $sql)
	{
		if (!$this->testedRequired($tab))
			return false;
		else if (!$this->testedUnauthorized($tab))
			return false;
		else if (!$this->checkedFrom($tab['FROM']))
			return false;
		else if (!$this->checkedSelect($tab['SELECT'], $tab['FROM'], $in))
			return false;
		else if (isset($tab['WHERE']))
		{
			if (!$this->checkedWhere($tab['WHERE'], $tab['FROM'], $sql))
				return false;
		}
		else if (isset($tab['HAVING']))
		{
			if (!$this->checkedHaving($tab['HAVING'], $tab['FROM']))
				return false;
		}
		else if (isset($tab['ORDER']))
		{
			if (!$this->checkedOrder($tab['ORDER'], $tab['FROM']))
				return false;
		}
		else if (isset($tab['GROUP']))
		{
			if (!$this->checkedGroupBy($tab['GROUP'], $tab['FROM']))
				return false;
		}
		else if (isset($tab['LIMIT']))
		{
			if (!$this->checkedLimit($tab['LIMIT']))
				return false;
		}
		if (empty($this->_errors))
			if (!Db::getInstance()->executeS($sql))
				return false;

return true;
	}

/**
	 * Get list of all tables
	 *
	 * @return array
	 */
	public function getTables()
	{
		$results = Db::getInstance()->executeS('SHOW TABLES');
		foreach ($results as $result)
		{
			$key = array_keys($result);
			$tables[] = $result[$key[0]];
		}
		return $tables;
	}

/**
	 * Get list of all attributes by an table
	 *
	 * @param $table
	 * @return array
	 */
	public function getAttributesByTable($table)
	{
		return Db::getInstance()->executeS('DESCRIBE '.pSQL($table));
	}

/**
	 * Cut an join sentence
	 *
	 * @param $attrs
	 * @param $from
	 * @return array|bool
	 */
	public function cutJoin($attrs, $from)
	{
		$attrs = explode('=', str_replace(' ', '', $attrs));
		foreach ($attrs as $attr)
		{
			if ($attribut = $this->cutAttribute(trim($attr), $from))
				$tab[] = $attribut;
		}
		return $tab;
	}

/**
	 * Cut an attribute with or without the alias
	 *
	 * @param $attr
	 * @param $from
	 * @return array|bool
	 */
	public function cutAttribute($attr, $from)
	{
		if (preg_match('#^((`($)?([a-z0-9_])+`($)?)|(($)?([a-z0-9_])+($)?))\.((`($)?([a-z0-9_])+`($)?)|(($)?([a-z0-9_])+($)?))$#i', $attr))
		{
			$tab = explode('.', str_replace(array('`', '(', ')'), '', $attr));
			if (!$table = $this->returnNameTable($tab[0], $from))
				return false;
			else
				return array ('table' => $table,
							'alias' => $tab[0],
							'attribut' => $tab[1],
							'string' => $attr);
		}
		elseif (preg_match('#^((`($)?([a-z0-9_])+`($)?)|(($)?([a-z0-9_])+($)?))$#i', $attr))
		{
			$attribut = str_replace(array('`', '(', ')'), '', $attr);
			if (!$table = $this->returnNameTable(false, $from))
				return false;
			else
				return array('table' => $table,
							'attribut' => $attribut,
							'string' => $attr);
		}
		else
			return false;
	}

/**
	 * Get name of table by alias
	 *
	 * @param bool $alias
	 * @param $tables
	 * @return array|bool
	 */
	public function returnNameTable($alias = false, $tables)
	{
		if ($alias)
		{
			foreach ($tables as $table)
			{
				if ($table['alias'] == $alias)
					return array($table['table']);
			}
		}
		else if (!$alias && (count($tables) > 1))
		{
			$this->error_sql['returnNameTable'] = false;
			return false;
		}
		else
		{
			foreach ($tables as $table)
				$tab[] = $table['table'];
			return $tab;
		}
	}

/**
	 * Check if an attributes existe in an table
	 *
	 * @param $attr
	 * @param $table
	 * @return bool
	 */
	public function attributExistInTable($attr, $table)
	{
		if (is_array($table) && (count($table) == 1))
			$table = $table[0];
		$attributs = $this->getAttributesByTable($table);
		foreach ($attributs as $attribut)
			if ($attribut['Field'] == trim($attr))
				return true;
		return false;
	}

/**
	 * Check if all required sentence existing
	 *
	 * @param $tab
	 * @return bool
	 */
	public function testedRequired($tab)
	{
		foreach ($this->tested['required'] as $key)
			if (!array_key_exists($key, $tab))
			{
				$this->error_sql['testedRequired'] = $key;
				return false;
			}
		return true;
	}

/**
	 * Check if an unauthorized existing in an array
	 *
	 * @param $tab
	 * @return bool
	 */
	public function testedUnauthorized($tab)
	{
		foreach ($this->tested['unauthorized'] as $key)
			if (array_key_exists($key, $tab))
			{
				$this->error_sql['testedUnauthorized'] = $key;
				return false;
			}
		return true;
	}

/**
	 * Check a "FROM" sentence
	 *
	 * @param $from
	 * @return bool
	 */
	public function checkedFrom($from)
	{
		$nb = count($from);
		for ($i = 0; $i < $nb; $i++)
		{
			$table = $from[$i];
			if (!in_array(str_replace('`', '', $table['table']), $this->getTables()))
			{
				$this->error_sql['checkedFrom']['table'] = $table['table'];
				return false;
			}
			if ($table['ref_type'] == 'ON' && (trim($table['join_type']) == 'LEFT' || trim($table['join_type']) == 'JOIN'))
			{
				if ($attrs = $this->cutJoin($table['ref_clause'], $from))
				{
					foreach ($attrs as $attr)
					{
						if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
						{
							$this->error_sql['checkedFrom']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
							return false;
						}
					}
				}
				else
				{
					if (isset($this->error_sql['returnNameTable']))
					{
						$this->error_sql['checkedFrom'] = $this->error_sql['returnNameTable'];
						return false;
					}
					else
					{
						$this->error_sql['checkedFrom'] = false;
						return false;
					}
				}
			}
		}
		return true;
	}

/**
	 * Check a "SELECT" sentence
	 *
	 * @param $select
	 * @param $from
	 * @param bool $in
	 * @return bool
	 */
	public function checkedSelect($select, $from, $in = false)
	{
		$nb = count($select);
		for ($i = 0; $i < $nb; $i++)
		{
			$attribut = $select[$i];
			if ($attribut['base_expr'] != '*')
			{
				if ($attribut['expr_type'] == 'colref' || $attribut['expr_type'] == 'reserved')
				{
					if ($attr = $this->cutAttribute(trim($attribut['base_expr']), $from))
					{
						if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
						{
							$this->error_sql['checkedSelect']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
							return false;
						}
					}
					else
					{
						if (isset($this->error_sql['returnNameTable']))
						{
							$this->error_sql['checkedSelect'] = $this->error_sql['returnNameTable'];
							return false;
						}
						else
						{
							$this->error_sql['checkedSelect'] = false;
							return false;
						}
					}
				}
			}
			else
			{
				if ($in)
				{
					$this->error_sql['checkedSelect']['*'] = false;
					return false;
				}
			}
		}
		return true;
	}

/**
	 * Check a "WHERE" sentence
	 *
	 * @param $where
	 * @param $from
	 * @param $sql
	 * @return bool
	 */
	public function checkedWhere($where, $from, $sql)
	{
		$nb = count($where);
		for ($i = 0; $i < $nb; $i++)
		{
			$attribut = $where[$i];
			if ($attribut['expr_type'] == 'colref' || $attribut['expr_type'] == 'reserved')
			{
				if ($attr = $this->cutAttribute(trim($attribut['base_expr']), $from))
				{
					if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
					{
						$this->error_sql['checkedWhere']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
						return false;
					}
				}
				else
				{
					if (isset($this->error_sql['returnNameTable']))
					{
						$this->error_sql['checkedWhere'] = $this->error_sql['returnNameTable'];
						return false;
					}
					else
					{
						$this->error_sql['checkedWhere'] = false;
						return false;
					}
				}
			}
			else if ($attribut['expr_type'] == 'operator')
			{
				if (!in_array(strtoupper($attribut['base_expr']), $this->tested['operator']))
				{
					$this->error_sql['checkedWhere']['operator'] = array($attribut['base_expr']);
					return false;
				}
			}
			else if ($attribut['expr_type'] == 'subquery')
			{
				$tab = $attribut['sub_tree'];
				return $this->validateParser($tab, true, $sql);
			}
		}
		return true;
	}

/**
	 * Check a "HAVING" sentence
	 *
	 * @param $having
	 * @param $from
	 * @return bool
	 */
	public function checkedHaving($having, $from)
	{
		$nb = count($having);
		for ($i = 0; $i < $nb; $i++)
		{
			$attribut = $having[$i];
			if ($attribut['expr_type'] == 'colref')
			{
				if ($attr = $this->cutAttribute(trim($attribut['base_expr']), $from))
				{
					if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
					{
						$this->error_sql['checkedHaving']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
						return false;
					}
				}
				else
				{
					if (isset($this->error_sql['returnNameTable']))
					{
						$this->error_sql['checkedHaving'] = $this->error_sql['returnNameTable'];
						return false;
					}
					else
					{
						$this->error_sql['checkedHaving'] = false;
						return false;
					}
				}
			}

if ($attribut['expr_type'] == 'operator')
			{
				if (!in_array(strtoupper($attribut['base_expr']), $this->tested['operator']))
				{
					$this->error_sql['checkedHaving']['operator'] = array($attribut['base_expr']);
					return false;
				}
			}
		}
		return true;
	}

/**
	 * Check a "ORDER" sentence
	 *
	 * @param $order
	 * @param $from
	 * @return bool
	 */
	public function checkedOrder($order, $from)
	{
		$order = $order[0];
		if ($order['type'] == 'expression')
		{
			if ($attr = $this->cutAttribute(trim($order['base_expr']), $from))
			{
				if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
				{
					$this->error_sql['checkedOrder']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
					return false;
				}
			}
			else
			{
				if (isset($this->error_sql['returnNameTable']))
				{
					$this->error_sql['checkedOrder'] = $this->error_sql['returnNameTable'];
					return false;
				}
				else
				{
					$this->error_sql['checkedOrder'] = false;
					return false;
				}
			}
		}
		return true;
	}

/**
	 * Check a "GROUP BY" sentence
	 *
	 * @param $group
	 * @param $from
	 * @return bool
	 */
	public function checkedGroupBy($group, $from)
	{
		$group = $group[0];
		if ($group['type'] == 'expression')
		{
			if ($attr = $this->cutAttribute(trim($group['base_expr']), $from))
			{
				if (!$this->attributExistInTable($attr['attribut'], $attr['table']))
				{
					$this->error_sql['checkedGroupBy']['attribut'] = array($attr['attribut'], implode(', ', $attr['table']));
					return false;
				}
			}
			else
			{
				if (isset($this->error_sql['returnNameTable']))
				{
					$this->error_sql['checkedGroupBy'] = $this->error_sql['returnNameTable'];
					return false;
				}
				else
				{
					$this->error_sql['checkedGroupBy'] = false;
					return false;
				}
			}
		}
		return true;
	}

/**
	 * Check a "LIMIT" sentence
	 *
	 * @param $limit
	 * @return bool
	 */
	public function checkedLimit($limit)
	{
		if (!preg_match('#^[0-9]+$#', trim($limit['start'])) || !preg_match('#^[0-9]+$#', trim($limit['end'])))
		{
			$this->error_sql['checkedLimit'] = false;
			return false;
		}
		return true;
	}
}