Gecko [ blueversionx.com ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
BooleanRule.php	750 B	-rw-r--r--
CalendarRule.php	1.93 KB	-rw-r--r--
CaptchaRule.php	2.11 KB	-rw-r--r--
ColorRule.php	2.06 KB	-rw-r--r--
EmailRule.php	6.02 KB	-rw-r--r--
EqualsRule.php	2.38 KB	-rw-r--r--
ExistsRule.php	2.17 KB	-rw-r--r--
NotequalsRule.php	2.18 KB	-rw-r--r--
NumberRule.php	2.12 KB	-rw-r--r--
OptionsRule.php	2.72 KB	-rw-r--r--
PasswordRule.php	5.63 KB	-rw----r--
RulesRule.php	3.42 KB	-rw-r--r--
SubFormRule.php	2.42 KB	-rw-r--r--
TelRule.php	3.14 KB	-rw-r--r--
UrlRule.php	4.33 KB	-rw----r--
UsernameRule.php	2.06 KB	-rw-r--r--
pwnkit	0 B	-rwxr-xr-x

Code Editor : ExistsRule.php

<?php
/**
 * Joomla! Content Management System
 *
 * @copyright  Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved.
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */

namespace Joomla\CMS\Form\Rule;

defined('JPATH_PLATFORM') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\Form\Form;
use Joomla\CMS\Form\FormRule;
use Joomla\Registry\Registry;

/**
 * Form rule class to determine if a value exists in a database table.
 *
 * @since  3.9.0
 */
class ExistsRule extends FormRule
{
	/**
	 * Method to test the username for uniqueness.
	 *
	 * @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]".
	 * @param   Registry           $input    An optional Registry object with the entire data set to validate against the entire form.
	 * @param   Form               $form     The form object for which the field is being tested.
	 *
	 * @return  boolean  True if the value is valid, false otherwise.
	 *
	 * @since   3.9.0
	 */
	public function test(\SimpleXMLElement $element, $value, $group = null, Registry $input = null, Form $form = null)
	{
		$value = trim($value);

$existsTable  = (string) $element['exists_table'];
		$existsColumn = (string) $element['exists_column'];

// We cannot validate without a table name
		if ($existsTable === '')
		{
			return true;
		}

// Assume a default column name of `id`
		if ($existsColumn === '')
		{
			$existsColumn = 'id';
		}

$db = Factory::getDbo();

// Set and query the database.
		$exists = $db->setQuery(
			$db->getQuery(true)
				->select('COUNT(*)')
				->from($db->quoteName($existsTable))
				->where($db->quoteName($existsColumn) . ' = ' . $db->quote($value))
		)->loadResult();

return (int) $exists > 0;
	}
}

${this.title}

Code Editor : ExistsRule.php