Gecko [ blueversionx.com ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
accesslevel.php	1.02 KB	-rw----r--
field.php	928 B	-rw----r--
fielddate.php	3.14 KB	-rw----r--
fieldfilterable.php	2.74 KB	-rw----r--
fieldsearchable.php	2.74 KB	-rw----r--
fieldselectable.php	3.27 KB	-rw----r--
fieldsql.php	1.66 KB	-rw----r--
filterdate.php	623 B	-rw----r--
filterfilterable.php	634 B	-rw----r--
filtersearchable.php	634 B	-rw----r--
filterselectable.php	630 B	-rw----r--
filtersql.php	612 B	-rw----r--
language.php	1.02 KB	-rw----r--
model.php	2.85 KB	-rw----r--
ordering.php	1.8 KB	-rw----r--
published.php	1.28 KB	-rw----r--
pwnkit	0 B	-rwxr-xr-x
rowselect.php	723 B	-rw----r--

Code Editor : fieldsql.php

<?php
/**
 * @package    FrameworkOnFramework
 * @subpackage form
 * @copyright   Copyright (C) 2010-2016 Nicholas K. Dionysopoulos / Akeeba Ltd. All rights reserved.
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */
// Protect from unauthorized access
defined('F0F_INCLUDED') or die;

/**
 * Generic field header, with drop down filters based on a SQL query
 *
 * @package  FrameworkOnFramework
 * @since    2.0
 */
class F0FFormHeaderFieldsql extends F0FFormHeaderFieldselectable
{
	/**
	 * Create objects for the options
	 *
	 * @return  array  The array of option objects
	 */
	protected function getOptions()
	{
		$options = array();

// Initialize some field attributes.
		$key       = $this->element['key_field'] ? (string) $this->element['key_field'] : 'value';
		$value     = $this->element['value_field'] ? (string) $this->element['value_field'] : (string) $this->element['name'];
		$translate = $this->element['translate'] ? (string) $this->element['translate'] : false;
		$query     = (string) $this->element['query'];

// Get the database object.
		$db = F0FPlatform::getInstance()->getDbo();

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

// Build the field options.
		if (!empty($items))
		{
			foreach ($items as $item)
			{
				if ($translate == true)
				{
					$options[] = JHtml::_('select.option', $item->$key, JText::_($item->$value));
				}
				else
				{
					$options[] = JHtml::_('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 : fieldsql.php