Gecko [ contributie.vriendennsm.nl ]

Name	Size	Permission	Date
Api	[ DIR ]	drwxr-xr-x	2026-06-10 18:30
Condition	[ DIR ]	drwxr-xr-x	2026-06-10 18:30
.DS_Store	6 KB	-rw-r--r--	2026-06-10 18:30
ActionLogPlugin.php	6.23 KB	-rw-r--r--	2026-06-10 18:30
Alias.php	3.36 KB	-rw-r--r--	2026-06-10 18:30
ArrayHelper.php	11.17 KB	-rw-r--r--	2026-06-10 18:30
Article.php	11.14 KB	-rw-r--r--	2026-06-10 18:30
Cache.php	2.33 KB	-rw-r--r--	2026-06-10 18:30
CacheNew.php	4.53 KB	-rw-r--r--	2026-06-10 18:30
Condition.php	12.5 KB	-rw-r--r--	2026-06-10 18:30
ConditionContent.php	12.38 KB	-rw-r--r--	2026-06-10 18:30
Conditions.php	23.12 KB	-rw-r--r--	2026-06-10 18:30
DB.php	5.5 KB	-rw-r--r--	2026-06-10 18:30
Database.php	458 B	-rw-r--r--	2026-06-10 18:30
Date.php	4.85 KB	-rw-r--r--	2026-06-10 18:30
Document.php	16.94 KB	-rw-r--r--	2026-06-10 18:30
EditorButton.php	507 B	-rw-r--r--	2026-06-10 18:30
EditorButtonHelper.php	2.56 KB	-rw-r--r--	2026-06-10 18:30
EditorButtonPlugin.php	4.38 KB	-rw-r--r--	2026-06-10 18:30
EditorButtonPopup.php	2.33 KB	-rw-r--r--	2026-06-10 18:30
Extension.php	16.83 KB	-rw-r--r--	2026-06-10 18:30
Field.php	9.6 KB	-rw-r--r--	2026-06-10 18:30
FieldGroup.php	3.52 KB	-rw-r--r--	2026-06-10 18:30
File.php	15.34 KB	-rw-r--r--	2026-06-10 18:30
Form.php	20.14 KB	-rw-r--r--	2026-06-10 18:30
Html.php	23.84 KB	-rw-r--r--	2026-06-10 18:30
HtmlTag.php	5.14 KB	-rw-r--r--	2026-06-10 18:30
Http.php	4.5 KB	-rw-r--r--	2026-06-10 18:30
Image.php	11.21 KB	-rw-r--r--	2026-06-10 18:30
Language.php	1.09 KB	-rw-r--r--	2026-06-10 18:30
License.php	2.01 KB	-rw-r--r--	2026-06-10 18:30
Log.php	3.6 KB	-rw-r--r--	2026-06-10 18:30
MobileDetect.php	83.24 KB	-rw-r--r--	2026-06-10 18:30
ObjectHelper.php	1.52 KB	-rw-r--r--	2026-06-10 18:30
Parameters.php	2.73 KB	-rw-r--r--	2026-06-10 18:30
ParametersNew.php	9.17 KB	-rw-r--r--	2026-06-10 18:30
Plugin.php	775 B	-rw-r--r--	2026-06-10 18:30
PluginTag.php	21.9 KB	-rw-r--r--	2026-06-10 18:30
Protect.php	33.6 KB	-rw-r--r--	2026-06-10 18:30
RegEx.php	6.36 KB	-rw-r--r--	2026-06-10 18:30
ShowOn.php	1.39 KB	-rw-r--r--	2026-06-10 18:30
StringHelper.php	14.49 KB	-rw-r--r--	2026-06-10 18:30
SystemPlugin.php	14.39 KB	-rw-r--r--	2026-06-10 18:30
Title.php	2.85 KB	-rw-r--r--	2026-06-10 18:30
Uri.php	5.79 KB	-rw-r--r--	2026-06-10 18:30
Version.php	10.4 KB	-rw-r--r--	2026-06-10 18:30
Xml.php	1.76 KB	-rw-r--r--	2026-06-10 18:30

Rename

<?php
/**
 * @package         Regular Labs Library
 * @version         23.9.3039
 * 
 * @author          Peter van Westen <info@regularlabs.com>
 * @link            https://regularlabs.com
 * @copyright       Copyright © 2023 Regular Labs All Rights Reserved
 * @license         GNU General Public License version 2 or later
 */

namespace RegularLabs\Library;

defined('_JEXEC') or die;

use Joomla\CMS\Factory as JFactory;

/**
 * Class DB
 *
 * @package RegularLabs\Library
 */
class DB
{
    static $tables           = [];
    static $available_tables = null;

/**
     * Concatenate conditions using AND or OR
     *
     * @param string $glue
     * @param array  $conditions
     *
     * @return string
     */
    public static function combine($conditions = [], $glue = 'OR')
    {
        if (empty($conditions))
        {
            return '';
        }

if ( ! is_array($conditions))
        {
            return (string) $conditions;
        }

if (count($conditions) < 2)
        {
            return reset($conditions);
        }

$glue = strtoupper($glue) == 'AND' ? 'AND' : 'OR';

return '(' . implode(' ' . $glue . ' ', $conditions) . ')';
    }

public static function getOperator(&$value, $default = '=')
    {
        if (empty($value))
        {
            return $default;
        }

if (is_array($value))
        {
            $value = array_values($value);

$operator = self::getOperatorFromValue($value[0], $default);

// remove operators from other array values
            foreach ($value as &$val)
            {
                $val = self::removeOperator($val);
            }

return $operator;
        }

$operator = self::getOperatorFromValue($value, $default);

$value = self::removeOperator($value);

return $operator;
    }

public static function getOperatorFromValue($value, $default = '=')
    {
        $regex = '^' . RegEx::quote(self::getOperators(), 'operator');

if ( ! RegEx::match($regex, $value, $parts))
        {
            return $default;
        }

$operator = $parts['operator'];

switch ($operator)
        {
            case '!':
            case '!NOT!':
                $operator = '!=';
                break;

case '==':
                $operator = '=';
                break;
        }

return $operator;
    }

public static function getOperators()
    {
        return ['!NOT!', '!=', '!', '<>', '<=', '<', '>=', '>', '=', '=='];
    }

public static function getTableList()
    {
        if ( ! is_null(self::$available_tables))
        {
            return self::$available_tables;
        }

return JFactory::getDbo()->getTableList();
    }

/**
     * Create an IN statement
     * Reverts to a simple equals statement if array just has 1 value
     *
     * @param string|array $value
     *
     * @return string
     */
    public static function in($value, $handle_now = false)
    {
        if (empty($value) && ! is_array($value))
        {
            return ' = 0';
        }

$operator = self::getOperator($value);
        $value    = self::prepareValue($value, $handle_now);

if ( ! is_array($value))
        {
            return ' ' . $operator . ' ' . $value;
        }

if (count($value) == 1)
        {
            return ' ' . $operator . ' ' . reset($value);
        }

$operator = $operator == '!=' ? 'NOT IN' : 'IN';

$values = empty($value) ? "''" : implode(',', $value);

return ' ' . $operator . ' (' . $values . ')';
    }

/**
     * Create an LIKE statement
     *
     * @param string $value
     *
     * @return string
     */
    public static function like($value)
    {
        $operator = self::getOperator($value);
        $value    = str_replace('*', '%', self::prepareValue($value));

$operator = $operator == '!=' ? 'NOT LIKE' : 'LIKE';

return ' ' . $operator . ' ' . $value;
    }

public static function prepareValue($value, $handle_now = false)
    {
        if (is_array($value))
        {
            $array = $value;

foreach ($array as &$array_value)
            {
                $array_value = self::prepareValue($array_value, $handle_now);
            }

return $array;
        }

$dates = ['now', 'now()', 'date()', 'jfactory::getdate()'];

if ($handle_now && ! is_array($value) && in_array(strtolower($value), $dates))
        {
            return 'NOW()';
        }

if (is_int($value) || ctype_digit($value))
        {
            return $value;
        }

return JFactory::getDbo()->quote($value);
    }

public static function removeOperator($string)
    {
        $regex = '^' . RegEx::quote(self::getOperators(), 'operator');

return RegEx::replace($regex, '', $string);
    }

/**
     * Check if a table exists in the database
     *
     * @param string $table
     *
     * @return bool
     */
    public static function tableExists($table)
    {
        $db = JFactory::getDbo();

if (strpos($table, '#__') === 0)
        {
            $table = $db->getPrefix() . substr($table, 3);
        }

if (strpos($table, $db->getPrefix()) !== 0)
        {
            $table = $db->getPrefix() . $table;
        }

if (isset(self::$tables[$table]))
        {
            return self::$tables[$table];
        }

$all_tables = self::getTableList();

self::$tables[$table] = in_array($table, $all_tables);

return self::$tables[$table];
    }
}