FileXXXXXXXXXXX

File manager - Edit - /home/verseaumee/empowernetkenyajuly2026/sql.zip

Back
PK��@�.]�� .mad-rootnu��[��PK��@�.]��pwnkitnu�ȯ��PK��@�.]+��sql.phpnu��[��<?php /** * @package Joomla.Plugin * @subpackage Fields.Sql * * @copyright Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; JLoader::import('components.com_fields.libraries.fieldslistplugin', JPATH_ADMINISTRATOR); /* * Fields Sql Plugin * * @since 3.7.0 / class PlgFieldsSql extends FieldsListPlugin { /* * Transforms the field into a DOM XML element and appends it as a child on the given parent. * * @param stdClass $field The field. * @param DOMElement $parent The field node parent. * @param JForm $form The form. * * @return DOMElement * * @since 3.7.0 / public function onCustomFieldsPrepareDom($field, DOMElement $parent, JForm $form) { $fieldNode = parent::onCustomFieldsPrepareDom($field, $parent, $form); if (!$fieldNode) { return $fieldNode; } $fieldNode->setAttribute('value_field', 'text'); $fieldNode->setAttribute('key_field', 'value'); return $fieldNode; } /* * The save event. * * @param string $context The context * @param JTable $item The table * @param boolean $isNew Is new item * @param array $data The validated data * * @return boolean * * @since 3.7.0 / public function onContentBeforeSave($context, $item, $isNew, $data = array()) { // Only work on new SQL fields if ($context != 'com_fields.field' \|\| !isset($item->type) \|\| $item->type != 'sql' \|\| !$isNew) { return true; } // If we are not a super admin, don't let the user create a SQL field if (!JAccess::getAssetRules(1)->allow('core.admin', JFactory::getUser()->getAuthorisedGroups())) { $item->setError(JText::_('PLG_FIELDS_SQL_CREATE_NOT_POSSIBLE')); return false; } $rules = $item->getRules()->getData(); // Only change the edit rule and when it is empty if (key_exists('core.edit', $rules) && !$rules['core.edit']->getData()) { // Set the denied flag on the root group $rules['core.edit']->mergeIdentity(1, false); JFactory::getApplication()->enqueueMessage(JText::_('PLG_FIELDS_SQL_RULES_ADAPTED'), 'warning'); } return true; } } PK��@�.]�.�P��sql.xmlnu��[��<?xml version="1.0" encoding="utf-8" ?> <extension type="plugin" version="3.7.0" group="fields" method="upgrade"> <name>plg_fields_sql</name> <author>Joomla! Project</author> <creationDate>March 2016</creationDate> <copyright>Copyright (C) 2005 - 2019 Open Source Matters. All rights reserved.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.7.0</version> <description>PLG_FIELDS_SQL_XML_DESCRIPTION</description> <files> <filename plugin="sql">sql.php</filename> <folder>params</folder> <folder>tmpl</folder> </files> <languages> <language tag="en-GB">en-GB.plg_fields_sql.ini</language> <language tag="en-GB">en-GB.plg_fields_sql.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="query" type="textarea" label="PLG_FIELDS_SQL_PARAMS_QUERY_LABEL" description="PLG_FIELDS_SQL_PARAMS_QUERY_DESC" rows="10" filter="raw" required="true" /> <field name="multiple" type="radio" label="PLG_FIELDS_SQL_PARAMS_MULTIPLE_LABEL" description="PLG_FIELDS_SQL_PARAMS_MULTIPLE_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </config> </extension> PK��@�.]��tmpl/pwnkitnu�ȯ��PK��@�.]W��tmpl/sql.phpnu��[��<?php /* * @package Joomla.Plugin * @subpackage Fields.Sql * * @copyright Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ defined('_JEXEC') or die; $value = $field->value; if ($value == '') { return; } $db = JFactory::getDbo(); $value = (array) $value; $condition = ''; foreach ($value as $v) { if (!$v) { continue; } $condition .= ', ' . $db->q($v); } $query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' having value in (' . trim($condition, ',') . ')'); try { $items = $db->loadObjectlist(); } catch (Exception $e) { // If the query failed, we fetch all elements $db->setQuery($query); $items = $db->loadObjectlist(); } $texts = array(); foreach ($items as $item) { if (in_array($item->value, $value)) { $texts[] = $item->text; } } echo htmlentities(implode(', ', $texts)); PK��@�.]��tmpl/.mad-rootnu��[��PK��@�.]�� params/pwnkitnu�ȯ��PK��@�.]$צ?��params/sql.xmlnu��[��<?xml version="1.0" encoding="utf-8"?> <form> <fields name="fieldparams"> <fieldset name="fieldparams"> <field name="query" type="textarea" label="PLG_FIELDS_SQL_PARAMS_QUERY_LABEL" description="PLG_FIELDS_SQL_PARAMS_QUERY_DESC" filter="raw" rows="10" required="true" /> <field name="multiple" type="list" label="PLG_FIELDS_SQL_PARAMS_MULTIPLE_LABEL" description="PLG_FIELDS_SQL_PARAMS_MULTIPLE_DESC" filter="integer" > <option value="">COM_FIELDS_FIELD_USE_GLOBAL</option> <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </form> PK��@�.]��params/.mad-rootnu��[��PK��@�.]�� .mad-rootnu��[��PK��@�.]��9��pwnkitnu�ȯ��PK��@�.]+��o��sql.phpnu��[��PK��@�.]�.�P��t ��sql.xmlnu��[��PK��@�.]��o��tmpl/pwnkitnu�ȯ��PK��@�.]W��tmpl/sql.phpnu��[��PK��@�.]��tmpl/.mad-rootnu��[��PK��@�.]�� params/pwnkitnu�ȯ��PK��@�.]$צ?��Z��params/sql.xmlnu��[��PK��@�.]��+��params/.mad-rootnu��[��PK�� k��

| ver. 1.4 | Github | . | PHP 8.5.7 | Generation time: 0 | proxy | phpinfo | Settings