Gecko [ blueversionx.com ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
AccessiblemediaField.php	4.58 KB	-rw----r--
AccesslevelField.php	900 B	-rw----r--
AliastagField.php	1.71 KB	-rw----r--
AuthorField.php	1.66 KB	-rw----r--
CachehandlerField.php	1.1 KB	-rw----r--
CalendarField.php	10.72 KB	-rw----r--
CaptchaField.php	4.15 KB	-rw----r--
CategoryField.php	2.9 KB	-rw----r--
CheckboxField.php	3.51 KB	-rw----r--
CheckboxesField.php	3.95 KB	-rw----r--
ChromestyleField.php	5.57 KB	-rw----r--
ColorField.php	8.14 KB	-rw----r--
ComboField.php	1.4 KB	-rw----r--
ComponentlayoutField.php	7.54 KB	-rw----r--
ComponentsField.php	1.73 KB	-rw----r--
ContenthistoryField.php	1.72 KB	-rw----r--
ContentlanguageField.php	908 B	-rw----r--
ContenttypeField.php	2.3 KB	-rw----r--
DatabaseconnectionField.php	2.05 KB	-rw----r--
EditorField.php	7.37 KB	-rw----r--
EmailField.php	1.45 KB	-rw----r--
FileField.php	3.41 KB	-rw----r--
FilelistField.php	5.6 KB	-rw----r--
FolderlistField.php	5.48 KB	-rw----r--
FrontendlanguageField.php	1.89 KB	-rw----r--
GroupedlistField.php	3.89 KB	-rw----r--
HeadertagField.php	970 B	-rw----r--
HiddenField.php	1.26 KB	-rw----r--
ImagelistField.php	926 B	-rw----r--
IntegerField.php	1.75 KB	-rw----r--
LanguageField.php	2.12 KB	-rw----r--
LastvisitdaterangeField.php	1.39 KB	-rw----r--
LimitboxField.php	2.19 KB	-rw----r--
ListField.php	5.98 KB	-rw----r--
MediaField.php	10.56 KB	-rw----r--
MenuField.php	3.06 KB	-rw----r--
MenuitemField.php	5.9 KB	-rw----r--
MeterField.php	4.53 KB	-rw----r--
ModulelayoutField.php	6.24 KB	-rw----r--
ModuleorderField.php	3.28 KB	-rw----r--
ModulepositionField.php	4.42 KB	-rw----r--
ModuletagField.php	1011 B	-rw----r--
NoteField.php	2.38 KB	-rw----r--
NumberField.php	5.08 KB	-rw----r--
OrderingField.php	4.89 KB	-rw----r--
PasswordField.php	6.12 KB	-rw----r--
PluginsField.php	4.4 KB	-rw----r--
PluginstatusField.php	649 B	-rw----r--
PredefinedlistField.php	3 KB	-rw----r--
RadioField.php	1.1 KB	-rw----r--
RadiobasicField.php	1.29 KB	-rw----r--
RangeField.php	1.38 KB	-rw----r--
RedirectStatusField.php	724 B	-rw----r--
RegistrationdaterangeField.php	1.39 KB	-rw----r--
RulesField.php	7.3 KB	-rw----r--
SessionhandlerField.php	1.2 KB	-rw----r--
SpacerField.php	3.39 KB	-rw----r--
SqlField.php	7.28 KB	-rw----r--
StatusField.php	714 B	-rw----r--
SubformField.php	10.79 KB	-rw----r--
TagField.php	8.24 KB	-rw----r--
TelephoneField.php	1.61 KB	-rw----r--
TemplatestyleField.php	4.84 KB	-rw----r--
TextField.php	7.17 KB	-rw----r--
TextareaField.php	4.57 KB	-rw----r--
TimeField.php	3.8 KB	-rw----r--
TimezoneField.php	3.83 KB	-rw----r--
TransitionField.php	4.48 KB	-rw----r--
UrlField.php	1.78 KB	-rw----r--
UserField.php	3.87 KB	-rw----r--
UseractiveField.php	1.08 KB	-rw----r--
UsergrouplistField.php	2.53 KB	-rw----r--
UserstateField.php	672 B	-rw----r--
WorkflowComponentSectionsField...	1.47 KB	-rw----r--
WorkflowconditionField.php	3.23 KB	-rw----r--
WorkflowstageField.php	4.08 KB	-rw----r--
pwnkit	0 B	-rwxr-xr-x

Code Editor : SqlField.php

<?php
/**
 * Joomla! Content Management System
 *
 * @copyright  (C) 2010 Open Source Matters, Inc. <https://www.joomla.org>
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */

namespace Joomla\CMS\Form\Field;

\defined('JPATH_PLATFORM') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;
use Joomla\CMS\Language\Text;
use Joomla\Database\DatabaseQuery;
use Joomla\Database\Exception\ExecutionFailureException;

/**
 * Supports a custom SQL select list
 *
 * @since  1.7.0
 */
class SqlField extends ListField
{
	/**
	 * The form field type.
	 *
	 * @var    string
	 * @since  1.7.0
	 */
	public $type = 'SQL';

/**
	 * The keyField.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $keyField;

/**
	 * The valueField.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $valueField;

/**
	 * The translate.
	 *
	 * @var    boolean
	 * @since  3.2
	 */
	protected $translate = false;

/**
	 * The query.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $query;

/**
	 * Method to get certain otherwise inaccessible properties from the form field object.
	 *
	 * @param   string  $name  The property name for which to get the value.
	 *
	 * @return  mixed  The property value or null.
	 *
	 * @since   3.2
	 */
	public function __get($name)
	{
		switch ($name)
		{
			case 'keyField':
			case 'valueField':
			case 'translate':
			case 'query':
				return $this->$name;
		}

return parent::__get($name);
	}

/**
	 * Method to set certain otherwise inaccessible properties of the form field object.
	 *
	 * @param   string  $name   The property name for which to set the value.
	 * @param   mixed   $value  The value of the property.
	 *
	 * @return  void
	 *
	 * @since   3.2
	 */
	public function __set($name, $value)
	{
		switch ($name)
		{
			case 'keyField':
			case 'valueField':
			case 'translate':
			case 'query':
				$this->$name = (string) $value;
				break;

default:
				parent::__set($name, $value);
		}
	}

/**
	 * Method to attach a Form object to the field.
	 *
	 * @param   \SimpleXMLElement  $element  The SimpleXMLElement object representing the `<field>` tag for the form field object.
	 * @param   mixed              $value    The form field value to validate.
	 * @param   string             $group    The field name group control value. This acts as an array container for the field.
	 *                                       For example if the field has name="foo" and the group value is set to "bar" then the
	 *                                       full field name would end up being "bar[foo]".
	 *
	 * @return  boolean  True on success.
	 *
	 * @see     FormField::setup()
	 * @since   3.2
	 */
	public function setup(\SimpleXMLElement $element, $value, $group = null)
	{
		$return = parent::setup($element, $value, $group);

if ($return)
		{
			// Check if its using the old way
			$this->query = (string) $this->element['query'];

if (empty($this->query))
			{
				// Get the query from the form
				$query    = array();
				$defaults = array();

$sql_select = (string) $this->element['sql_select'];
				$sql_from   = (string) $this->element['sql_from'];

if ($sql_select && $sql_from)
				{
					$query['select'] = $sql_select;
					$query['from']   = $sql_from;
					$query['join']   = (string) $this->element['sql_join'];
					$query['where']  = (string) $this->element['sql_where'];
					$query['group']  = (string) $this->element['sql_group'];
					$query['order']  = (string) $this->element['sql_order'];

// Get the filters
					$filters = isset($this->element['sql_filter']) ? explode(',', $this->element['sql_filter']) : '';

// Get the default value for query if empty
					if (\is_array($filters))
					{
						foreach ($filters as $filter)
						{
							$name   = "sql_default_{$filter}";
							$attrib = (string) $this->element[$name];

if (!empty($attrib))
							{
								$defaults[$filter] = $attrib;
							}
						}
					}

// Process the query
					$this->query = $this->processQuery($query, $filters, $defaults);
				}
			}

$this->keyField   = (string) $this->element['key_field'] ?: 'value';
			$this->valueField = (string) $this->element['value_field'] ?: (string) $this->element['name'];
			$this->translate  = (string) $this->element['translate'] ?: false;
			$this->header     = (string) $this->element['header'] ?: false;
		}

return $return;
	}

/**
	 * Method to process the query from form.
	 *
	 * @param   array   $conditions  The conditions from the form.
	 * @param   string  $filters     The columns to filter.
	 * @param   array   $defaults    The defaults value to set if condition is empty.
	 *
	 * @return  DatabaseQuery  The query object.
	 *
	 * @since   3.5
	 */
	protected function processQuery($conditions, $filters, $defaults)
	{
		// Get the database object.
		$db = Factory::getDbo();

// Get the query object
		$query = $db->getQuery(true);

// Select fields
		$query->select($conditions['select']);

// From selected table
		$query->from($conditions['from']);

// Join over the groups
		if (!empty($conditions['join']))
		{
			$query->join('LEFT', $conditions['join']);
		}

// Where condition
		if (!empty($conditions['where']))
		{
			$query->where($conditions['where']);
		}

// Group by
		if (!empty($conditions['group']))
		{
			$query->group($conditions['group']);
		}

// Process the filters
		if (\is_array($filters))
		{
			$html_filters = Factory::getApplication()->getUserStateFromRequest($this->context . '.filter', 'filter', array(), 'array');

foreach ($filters as $k => $value)
			{
				if (!empty($html_filters[$value]))
				{
					$escape = $db->quote($db->escape($html_filters[$value]), false);

$query->where("{$value} = {$escape}");
				}
				elseif (!empty($defaults[$value]))
				{
					$escape = $db->quote($db->escape($defaults[$value]), false);

$query->where("{$value} = {$escape}");
				}
			}
		}

// Add order to query
		if (!empty($conditions['order']))
		{
			$query->order($conditions['order']);
		}

return $query;
	}

/**
	 * Method to get the custom field options.
	 * Use the query attribute to supply a query to generate the list.
	 *
	 * @return  array  The field option objects.
	 *
	 * @since   1.7.0
	 */
	protected function getOptions()
	{
		$options = array();

// Initialize some field attributes.
		$key   = $this->keyField;
		$value = $this->valueField;
		$header = $this->header;

if ($this->query)
		{
			// Get the database object.
			$db = Factory::getDbo();

// Set the query and get the result list.
			$db->setQuery($this->query);

try
			{
				$items = $db->loadObjectList();
			}
			catch (ExecutionFailureException $e)
			{
				Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
			}
		}

// Add header.
		if (!empty($header))
		{
			$header_title = Text::_($header);
			$options[] = HTMLHelper::_('select.option', '', $header_title);
		}

// Build the field options.
		if (!empty($items))
		{
			foreach ($items as $item)
			{
				if ($this->translate == true)
				{
					$options[] = HTMLHelper::_('select.option', $item->$key, Text::_($item->$value));
				}
				else
				{
					$options[] = HTMLHelper::_('select.option', $item->$key, $item->$value);
				}
			}
		}

// Merge any additional options in the XML definition.
		$options = array_merge(parent::getOptions(), $options);

return $options;
	}
}

${this.title}

Code Editor : SqlField.php