| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/11584/cwd/html/old/libraries/kunena/database/ |
Upload File : |
<?php
/**
* Kunena Component
* @package Kunena.Framework
*
* @copyright (C) 2008 - 2014 Kunena Team. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* @link http://www.kunena.org
*
* Derived from Joomla 1.6
* @copyright Copyright (C) 2005 - 2010 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined ( '_JEXEC' ) or die ();
/**
* Query Element Class.
*/
class KunenaDatabaseQueryElement
{
/**
* @var string The name of the element.
* @since 1.6
*/
protected $_name = null;
/**
* @var array An array of elements.
* @since 1.6
*/
protected $_elements = null;
/**
* @var string Glue piece.
* @since 1.6
*/
protected $_glue = null;
/**
* Constructor.
*
* @param string $name The name of the element.
* @param mixed $elements String or array.
* @param string $glue The glue for elements.
*
* @return KunenaDatabaseQueryElement
* @since 1.6
*/
public function __construct($name, $elements, $glue = ',')
{
$this->_elements = array();
$this->_name = $name;
$this->_glue = $glue;
$this->append($elements);
}
/**
* Magic function to convert the query element to a string.
*
* @return string
* @since 1.6
*/
public function __toString()
{
return PHP_EOL.$this->_name.' '.implode($this->_glue, $this->_elements);
}
/**
* Appends element parts to the internal list.
*
* @param mixed String or array.
*
* @return void
* @since 1.6
*/
public function append($elements)
{
if (is_array($elements)) {
$this->_elements = array_unique(array_merge($this->_elements, $elements));
}
else {
$this->_elements = array_unique(array_merge($this->_elements, array($elements)));
}
}
}
/**
* Query Building Class.
*/
class KunenaDatabaseQuery
{
/**
* @var string The query type.
* @since 1.6
*/
protected $_type = '';
/**
* @var object The select element.
* @since 1.6
*/
protected $_select = null;
/**
* @var object The delete element.
* @since 1.6
*/
protected $_delete = null;
/**
* @var object The update element.
* @since 1.6
*/
protected $_update = null;
/**
* @var object The insert element.
* @since 1.6
*/
protected $_insert = null;
/**
* @var object The from element.
* @since 1.6
*/
protected $_from = null;
/**
* @var object The join element.
* @since 1.6
*/
protected $_join = null;
/**
* @var object The set element.
* @since 1.6
*/
protected $_set = null;
/**
* @var object The where element.
* @since 1.6
*/
protected $_where = null;
/**
* @var object The group by element.
* @since 1.6
*/
protected $_group = null;
/**
* @var object The having element.
* @since 1.6
*/
protected $_having = null;
/**
* @var object The order element.
* @since 1.6
*/
protected $_order = null;
/**
* Clear data from the query or a specific clause of the query.
*
* @param string $clause Optionally, the name of the clause to clear, or nothing to clear the whole query.
*
* @return void
* @since 1.6
*/
public function clear($clause = null)
{
switch ($clause)
{
case 'select':
$this->_select = null;
$this->_type = null;
break;
case 'delete':
$this->_delete = null;
$this->_type = null;
break;
case 'update':
$this->_update = null;
$this->_type = null;
break;
case 'insert':
$this->_insert = null;
$this->_type = null;
break;
case 'from':
$this->_from = null;
break;
case 'join':
$this->_join = null;
break;
case 'set':
$this->_set = null;
break;
case 'where':
$this->_where = null;
break;
case 'group':
$this->_group = null;
break;
case 'having':
$this->_having = null;
break;
case 'order':
$this->_order = null;
break;
default:
$this->_type = null;
$this->_select = null;
$this->_delete = null;
$this->_udpate = null;
$this->_insert = null;
$this->_from = null;
$this->_join = null;
$this->_set = null;
$this->_where = null;
$this->_group = null;
$this->_having = null;
$this->_order = null;
break;
}
return $this;
}
/**
* @param mixed $columns A string or an array of field names.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function select($columns)
{
$this->_type = 'select';
if (is_null($this->_select)) {
$this->_select = new KunenaDatabaseQueryElement('SELECT', $columns);
}
else {
$this->_select->append($columns);
}
return $this;
}
/**
* @param string $tables The name of the table to delete from.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function delete($tables)
{
$this->_type = 'delete';
$this->_delete = new KunenaDatabaseQueryElement('DELETE', $tables);
return $this;
}
/**
* @param mixed $tables A string or array of table names.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function insert($tables)
{
$this->_type = 'insert';
$this->_insert = new KunenaDatabaseQueryElement('INSERT INTO', $tables);
return $this;
}
/**
* @param mixed $tables A string or array of table names.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function update($tables = null)
{
$this->_type = 'update';
$this->_update = new KunenaDatabaseQueryElement('UPDATE', $tables);
return $this;
}
/**
* @param mixed $tables A string or array of table names.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function from($tables)
{
if (is_null($this->_from)) {
$this->_from = new KunenaDatabaseQueryElement('FROM', $tables);
}
else {
$this->_from->append($tables);
}
return $this;
}
/**
* @param string $type
* @param string $conditions
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function join($type, $conditions)
{
if (is_null($this->_join)) {
$this->_join = array();
}
$this->_join[] = new KunenaDatabaseQueryElement(strtoupper($type) . ' JOIN', $conditions);
return $this;
}
/**
* @param string $conditions
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function innerJoin($conditions)
{
$this->join('INNER', $conditions);
return $this;
}
/**
* @param string $conditions
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function outerJoin($conditions)
{
$this->join('OUTER', $conditions);
return $this;
}
/**
* @param string $conditions
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function leftJoin($conditions)
{
$this->join('LEFT', $conditions);
return $this;
}
/**
* @param string $conditions
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function rightJoin($conditions)
{
$this->join('RIGHT', $conditions);
return $this;
}
/**
* @param mixed $conditions A string or array of conditions.
* @param string $glue
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function set($conditions, $glue=',')
{
if (is_null($this->_set)) {
$glue = strtoupper($glue);
$this->_set = new KunenaDatabaseQueryElement('SET', $conditions, "\n\t$glue ");
}
else {
$this->_set->append($conditions);
}
return $this;
}
/**
* @param mixed $conditions A string or array of where conditions.
* @param string $glue
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function where($conditions, $glue='AND')
{
if (is_null($this->_where)) {
$glue = strtoupper($glue);
$this->_where = new KunenaDatabaseQueryElement('WHERE', $conditions, " $glue ");
}
else {
$this->_where->append($conditions);
}
return $this;
}
/**
* @param mixed $columns A string or array of ordering columns.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function group($columns)
{
if (is_null($this->_group)) {
$this->_group = new KunenaDatabaseQueryElement('GROUP BY', $columns);
}
else {
$this->_group->append($columns);
}
return $this;
}
/**
* @param mixed $conditions A string or array of columns.
* @param string $glue
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function having($conditions, $glue='AND')
{
if (is_null($this->_having)) {
$glue = strtoupper($glue);
$this->_having = new KunenaDatabaseQueryElement('HAVING', $conditions, " $glue ");
}
else {
$this->_having->append($conditions);
}
return $this;
}
/**
* @param mixed $columns A string or array of ordering columns.
*
* @return KunenaDatabaseQuery Returns this object to allow chaining.
* @since 1.6
*/
public function order($columns)
{
if (is_null($this->_order)) {
$this->_order = new KunenaDatabaseQueryElement('ORDER BY', $columns);
}
else {
$this->_order->append($columns);
}
return $this;
}
/**
* Legacy function to return a string representation of the query element.
*
* @return string The query element.
* @since 1.0
*/
public function toString()
{
return (string) $this;
}
/**
* Magic function to convert the query to a string.
*
* @return string The completed query.
* @since 1.6
*/
public function __toString()
{
$query = '';
switch ($this->_type)
{
case 'select':
$query .= (string) $this->_select;
$query .= (string) $this->_from;
if ($this->_join) {
// special case for joins
foreach ($this->_join as $join) {
$query .= (string) $join;
}
}
if ($this->_where) {
$query .= (string) $this->_where;
}
if ($this->_group) {
$query .= (string) $this->_group;
}
if ($this->_having) {
$query .= (string) $this->_having;
}
if ($this->_order) {
$query .= (string) $this->_order;
}
break;
case 'delete':
$query .= (string) $this->_delete;
$query .= (string) $this->_from;
if ($this->_join) {
// special case for joins
foreach ($this->_join as $join) {
$query .= (string) $join;
}
}
if ($this->_where) {
$query .= (string) $this->_where;
}
break;
case 'update':
$query .= (string) $this->_update;
if ($this->_join) {
// special case for joins
foreach ($this->_join as $join) {
$query .= (string) $join;
}
}
$query .= (string) $this->_set;
if ($this->_where) {
$query .= (string) $this->_where;
}
break;
case 'insert':
$query .= (string) $this->_insert;
$query .= (string) $this->_set;
if ($this->_where) {
$query .= (string) $this->_where;
}
break;
}
return $query;
}
}