<?php
/**
*
* @ This file is created by http://DeZender.Net
* @ deZender (PHP7 Decoder for ionCube Encoder)
*
* @ Version			:	4.0.9.0
* @ Author			:	DeZender
* @ Release on		:	08.08.2019
* @ Official site	:	http://DeZender.Net
*
*/

function appLang($lang)
{
	global $mysqli;
	global $sm;
	$result = [];
	$lang = secureEncode($lang);
	$query = $mysqli->query('SELECT * FROM app_lang where lang_id = \'' . $lang . '\' ORDER BY id ASC');

	while ($row = $query->fetch_assoc()) {
		$result[$row['id']] = ['id' => $row['id'], 'text' => $row['text']];
	}

	return $result;
}

function themeSetting($theme)
{
	global $mysqli;
	global $sm;
	$result = [];
	$query = $mysqli->query('SELECT * FROM theme_settings where theme = \'' . $theme . '\'');

	while ($row = $query->fetch_assoc()) {
		$result[$row['setting']] = ['val' => $row['setting_val']];
	}

	return $result;
}

function sitePlugins()
{
	global $mysqli;
	global $sm;
	$result = [];
	$query = $mysqli->query('SELECT * FROM plugins_settings');

	while ($row = $query->fetch_assoc()) {
		$filter = 'where setting = "' . $row['setting'] . '" and plugin = "' . $row['plugin'] . '"';
		$clientSetting = getData('plugins_settings_values', 'setting_val', $filter);

		if ($clientSetting == 'noData') {
			$row['setting_val'] = $row['setting_val'];
		}
		else {
			$row['setting_val'] = $clientSetting;
		}

		if (isset($result[$row['plugin']])) {
			$result[$row['plugin']][$row['setting']] = $row['setting_val'];
			continue;
		}

		$result[$row['plugin']] = [$row['setting'] => $row['setting_val']];
	}

	return $result;
}

function sitePlugin()
{
	global $mysqli;
	global $sm;
	$result = [];
	$query = $mysqli->query('SELECT * FROM plugins');

	while ($row = $query->fetch_assoc()) {
		$result[] = $row;
	}

	return $result;
}

function siteSettings()
{
	global $mysqli;
	global $sm;
	$result = [];
	$query = $mysqli->query('SELECT * FROM settings');

	while ($row = $query->fetch_assoc()) {
		$result[$row['setting']] = $row['setting_val'];
	}

	return $result;
}

function emailLang($lang)
{
	global $mysqli;
	global $sm;
	$result = [];
	$lang = secureEncode($lang);
	$query = $mysqli->query('SELECT * FROM email_lang where lang_id = \'' . $lang . '\' ORDER BY id ASC');

	while ($row = $query->fetch_assoc()) {
		$result[$row['id']] = ['id' => $row['id'], 'text' => $row['text']];
	}

	return $result;
}

function seoLang($lang)
{
	global $mysqli;
	global $sm;
	$result = [];
	$lang = secureEncode($lang);
	$query = $mysqli->query('SELECT * FROM seo_lang where lang_id = \'' . $lang . '\' ORDER BY page ASC');

	while ($row = $query->fetch_assoc()) {
		$result[$row['page']][$row['id']] = ['text' => $row['text']];
................................................................................
...................................................
.......................