/** * @version $Id:sql.php 6961 2007-03-15 16:06:53Z tcp $ * @package Joomla.Framework * @subpackage Parameter * @copyright Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved. * @license GNU/GPL, see LICENSE.php * Joomla! is free software. This version may have been modified pursuant * to 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 COPYRIGHT.php for copyright notices and details. */ // Check to ensure this file is within the rest of the framework defined('JPATH_BASE') or die(); /** * Renders a SQL element * * @package Joomla.Framework * @subpackage Parameter * @since 1.5 */ class JElementSQL extends JElement { /** * Element name * * @access protected * @var string */ var $_name = 'SQL'; function fetchElement($name, $value, &$node, $control_name) { $db = & JFactory::getDBO(); $db->setQuery($node->attributes('query')); $key = ($node->attributes('key_field') ? $node->attributes('key_field') : 'value'); $val = ($node->attributes('value_field') ? $node->attributes('value_field') : $name); return JHTML::_('select.genericlist', $db->loadObjectList(), ''.$control_name.'['.$name.']', 'class="inputbox"', $key, $val, $value, $control_name.$name); } }
