/**
* @param $action
* @param $arFields
* @return bool
*/
protected function checkFields($action, &$arFields)
{
global $DB;
if (($action == 'ADD' || isset($arFields["DOC_TYPE"])) && strlen($arFields["DOC_TYPE"]) <= 0 && !isset(self::$types[$arFields["DOC_TYPE"]])) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("CAT_DOC_WRONG_TYPE"));
return false;
}
if (($action == 'ADD' || isset($arFields["SITE_ID"])) && strlen($arFields["SITE_ID"]) <= 0) {
return false;
}
if (isset($arFields["STATUS"]) && $arFields["STATUS"] === 'Y') {
$arFields['~DATE_STATUS'] = $DB->GetNowFunction();
}
if (isset($arFields["DATE_DOCUMENT"]) && !CDataBase::IsDate($arFields["DATE_DOCUMENT"])) {
unset($arFields["DATE_DOCUMENT"]);
$arFields['~DATE_DOCUMENT'] = $DB->GetNowFunction();
}
return true;
}
$result = $dbh->query("SELECT * FROM `shares` WHERE `shares_id`=0 AND `name` like '{$name}' ORDER by name");
$id_arr = $dbh->fetch_array($result);
return $id_arr['conversations_id'];
}
function echo_foldernames($dbh)
{
$result = $dbh->query("SELECT * FROM `shares` WHERE `shares_id` !=0 AND `conversations_id` !=0 ORDER by name");
while ($row = $dbh->fetch_array($result)) {
echo $row['conversations_id'] . "_" . $row['shares_id'] . "_" . trim($row['name'], "_") . "<br/>";
}
}
function str_replace_assoc(array $replace, $subject)
{
return str_replace(array_keys($replace), array_values($replace), $subject);
}
$dbh = new CDataBase("skladchik", "localhost", "ypbase", "golosneba");
$table = 'shares';
$query = "SELECT * FROM {$table} WHERE 1 ORDER by name";
// Выполняем запрос к БД
$result = $dbh->query($query);
// предварительная обработка
while ($row = $dbh->fetch_array($result)) {
$replace = array('"' => '', "'" => "", ':' => '', '+' => '_', '-' => '', '«' => '', '»' => '', '“' => '', '”' => '', '/' => '', '?' => '', '#' => '', '$' => '', '%' => '', '–' => '-', ',' => '_', '(' => '', ')' => '');
//$new_name = str_replace_assoc($replace,$row['name']);
$row['name'] = iconv('UTF-8', 'cp1251', $row['name']);
//$new_name = preg_replace('/([.+{},®!-]+)/', '_', $row['name']);
$new_name = preg_replace('/([-.+{},®!-"?:^~|@№$–=*&%;<>()—«»#\\/\']+)/', '_', $row['name']);
$new_name = preg_replace('/\\s\\s+/', ' ', $new_name);
$new_name = preg_replace('/\\ /', '_', $new_name);
$new_name = preg_replace('/__+/', '_', $new_name);
$new_name = rtrim($new_name, "...");
/**
* @param $action
* @param $arFields
* @return bool
*/
protected function checkFields($action, &$arFields)
{
global $DB;
global $APPLICATION;
if (($action == 'ADD' || isset($arFields["DOC_TYPE"])) && strlen($arFields["DOC_TYPE"]) <= 0 && !isset(self::$types[$arFields["DOC_TYPE"]])) {
$APPLICATION->ThrowException(GetMessage("CAT_DOC_WRONG_TYPE"));
return false;
}
if (($action == 'ADD' || isset($arFields["SITE_ID"])) && strlen($arFields["SITE_ID"]) <= 0) {
$APPLICATION->ThrowException(GetMessage("CAT_DOC_WRONG_SITE_ID"));
return false;
}
if ($action == 'ADD' || array_key_exists('STATUS', $arFields)) {
$arFields['STATUS'] = 'Y' == $arFields['STATUS'] ? 'Y' : 'N';
}
if (isset($arFields["STATUS"])) {
$arFields['~DATE_STATUS'] = $DB->GetNowFunction();
}
if (isset($arFields["DATE_DOCUMENT"]) && !CDataBase::IsDate($arFields["DATE_DOCUMENT"])) {
unset($arFields["DATE_DOCUMENT"]);
$arFields['~DATE_DOCUMENT'] = $DB->GetNowFunction();
}
return true;
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . '/local/header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/vendor/autoload.php';
$loader = new Twig_Loader_Filesystem($_SERVER['DOCUMENT_ROOT'] . '/admin/templates/');
$twig = new Twig_Environment($loader, $arTwigConfig);
$twig->addExtension(new Twig_Extension_Debug());
/** @var CDataBase Объект подключения к базе данных */
$db = new CDataBase($arConnect);
/** @var string Тип материала */
$type = ClearValueString($_GET['type'], 50, true);
/** @var string Числовой идентификатор материала */
$id_item = ClearValueIntval($_GET['id']);
if (!empty($type)) {
switch ($type) {
case 'article':
/** @var string Название шаблона */
$tpl = 'edit-article.html';
if ($id_item > 0) {
if (isset($_POST)) {
$isUpdate = $db->Update('articles', $_POST, array('ID' => $id_item));
}
$query = $db->Query('SELECT * FROM `articles` WHERE `ID` = ' . $id_item);
if ($query->num_rows == 1) {
if ($result = $query->fetch_assoc()) {
$content['article']['detail'] = $result;
}
}
} else {
if (isset($_POST)) {
$db->Insert('articles', $_POST);
<?php
require_once __DIR__ . '/local/header.php';
require_once __DIR__ . '/vendor/autoload.php';
$loader = new Twig_Loader_Filesystem(__DIR__ . '/templates/compress/');
$twig = new Twig_Environment($loader, $arTwigConfig);
$twig->addExtension(new Twig_Extension_Debug());
$pageProperty = new CPageProperty('index');
/** @var CDataBase Объект подключения к базе данных */
$db = new CDataBase($arConnect);
if (isset($_GET['param'])) {
/** @var string Символьный код статьи */
$param = ClearValueString($_GET['param'], 50, true);
if (!is_null($param)) {
$query = $db->Query('SELECT * FROM `articles` WHERE `CODE` = ' . $db->escape($param));
if ($query->num_rows == 1) {
if ($result = $query->fetch_assoc()) {
$content['article']['detail'] = $result;
$pageProperty->Replace($result);
}
} else {
PageNotFound();
}
}
} else {
$query = $db->Query('SELECT `CODE`, `HEADER`, `PREVIEW` FROM `articles` WHERE `PUBLISH` = 1 ORDER BY `DATE_CREATE` DESC');
while ($result = $query->fetch_assoc()) {
$content['article']['list'][] = $result;
}
}
TwigKeysStrtolower($content);
private static function search_mssql($sSQL)
{
$oBD = CDataBase::get_instance();
$oBD->connect();
if ($isConnected) {
$arTabla = array();
try {
$oQuery = mssql_query($sSQL, $oBD->get_link_id());
while ($arFila = mssql_fetch_array($oQuery, MSSQL_ASSOC)) {
$arTabla[] = $arFila;
}
return $arTabla;
} catch (Exception $e) {
die("ERROR 0010: No se pudo ejecutar la función search. {$e}");
}
} else {
die("ERROR 0009: No se pudo conectar");
}
}
