protected function deleteBrokenForeignRelations($v4d3f0fefb6805c1ec6f97b3bc9458bc6, $v4955407e3442306fd4b6dfb686ae7c15, $v307b2810524c158bf4698c4582f50a61, $v1503560471ee6995d52307ced65b703c)
{
$v4d3f0fefb6805c1ec6f97b3bc9458bc6 = l_mysql_real_escape_string($v4d3f0fefb6805c1ec6f97b3bc9458bc6);
$v4955407e3442306fd4b6dfb686ae7c15 = l_mysql_real_escape_string($v4955407e3442306fd4b6dfb686ae7c15);
$v307b2810524c158bf4698c4582f50a61 = l_mysql_real_escape_string($v307b2810524c158bf4698c4582f50a61);
$v1503560471ee6995d52307ced65b703c = l_mysql_real_escape_string($v1503560471ee6995d52307ced65b703c);
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT `id`, `{$v4955407e3442306fd4b6dfb686ae7c15}` FROM `{$v4d3f0fefb6805c1ec6f97b3bc9458bc6}`";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
while (list($vb80bb7740288fda1f201890375a60c8f, $v8b93e238b2f356a070d51c99fb681a0e) = mysql_fetch_row($result)) {
$this->checkMaxIterations();
if (!$v8b93e238b2f356a070d51c99fb681a0e) {
continue;
}
$v63d2929cb7bcee804ab8720960e91195 = "SELECT COUNT(*) FROM `{$v307b2810524c158bf4698c4582f50a61}` WHERE `{$v1503560471ee6995d52307ced65b703c}` = '{$v8b93e238b2f356a070d51c99fb681a0e}'";
$v1804956abd21cd701c0e7931d7ebf5df = l_mysql_query($v63d2929cb7bcee804ab8720960e91195, true);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
if (list($ve2942a04780e223b215eb8b663cf5353) = mysql_fetch_row($v1804956abd21cd701c0e7931d7ebf5df)) {
if ($ve2942a04780e223b215eb8b663cf5353 > 0) {
continue;
}
}
$v63d2929cb7bcee804ab8720960e91195 = "DELETE FROM `{$v4d3f0fefb6805c1ec6f97b3bc9458bc6}` WHERE `id` = '{$vb80bb7740288fda1f201890375a60c8f}'";
l_mysql_query($v63d2929cb7bcee804ab8720960e91195);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
}
}
protected function saveValue()
{
$this->deleteCurrentRows();
if (is_null($this->value)) {
return;
}
$v2817f701d5e1a1181e657251363295fd = 0;
foreach ($this->value as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
if (!$v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
continue;
}
if (is_object($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
if (!@is_file($v3a6d0284e743dc4a9b86f97d6dd1a3bf->getFilePath())) {
continue;
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = l_mysql_real_escape_string($v3a6d0284e743dc4a9b86f97d6dd1a3bf->getFilePath());
} else {
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = l_mysql_real_escape_string($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = self::unescapeFilePath($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, text_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
++$v2817f701d5e1a1181e657251363295fd;
}
if (!$v2817f701d5e1a1181e657251363295fd) {
$this->fillNull();
}
}
public static final function add($v6f65638723a69dfa99474478b83b7b17, $vd5d3db1765287eef77d7927cc956f50a, $ve2aeb4e882d60b1eb4b7c8cd97986a28)
{
$v6f65638723a69dfa99474478b83b7b17 = l_mysql_real_escape_string($v6f65638723a69dfa99474478b83b7b17);
$vd5d3db1765287eef77d7927cc956f50a = l_mysql_real_escape_string($vd5d3db1765287eef77d7927cc956f50a);
$ve2aeb4e882d60b1eb4b7c8cd97986a28 = (int) $ve2aeb4e882d60b1eb4b7c8cd97986a28;
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
INSERT INTO `cms3_object_fields_restrictions`
\t(`class_prefix`, `title`, `field_type_id`)
\tVALUES ('{$v6f65638723a69dfa99474478b83b7b17}', '{$vd5d3db1765287eef77d7927cc956f50a}', '{$ve2aeb4e882d60b1eb4b7c8cd97986a28}')
SQL;
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
return l_mysql_insert_id();
}
private function appendData($data, $type)
{
$type = l_mysql_real_escape_string($type);
$qry = "SELECT `id` FROM `cms_stat_sources_openstat_" . $type . "` WHERE `name` = '" . l_mysql_real_escape_string($data) . "'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if (isset($row['id'])) {
$this->data[$type . '_id'] = $row['id'];
} else {
$qry = "INSERT INTO `cms_stat_sources_openstat_" . $type . "` (`name`) VALUES ('" . l_mysql_real_escape_string($data) . "')";
l_mysql_query($qry);
$this->data[$type . '_id'] = l_mysql_insert_id();
}
}
public function addType($v6be379826b20cc58475f636e33f4606b, $vb068931cc450442b63f5b3d276ea4297, $v1945c9a2a5e2ba6133f1db6757a35fcb = false, $vfd2a8ab94cb104d2f8e25a402c260ae4 = false)
{
$this->disableCache();
$v6be379826b20cc58475f636e33f4606b = (int) $v6be379826b20cc58475f636e33f4606b;
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_object_types (parent_id) VALUES('{$v6be379826b20cc58475f636e33f4606b}')";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
$v94757cae63fd3e398c0811a976dd6bbe = l_mysql_insert_id();
if (!$vfd2a8ab94cb104d2f8e25a402c260ae4) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT * FROM cms3_object_field_groups WHERE type_id = '{$v6be379826b20cc58475f636e33f4606b}'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
while ($vf1965a857bc285d26fe22023aa5ab50d = mysql_fetch_assoc($result)) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_object_field_groups (name, title, type_id, is_active, is_visible, ord, is_locked) VALUES ('" . l_mysql_real_escape_string($vf1965a857bc285d26fe22023aa5ab50d['name']) . "', '" . l_mysql_real_escape_string($vf1965a857bc285d26fe22023aa5ab50d['title']) . "', '{$v94757cae63fd3e398c0811a976dd6bbe}', '{$vf1965a857bc285d26fe22023aa5ab50d['is_active']}', '{$vf1965a857bc285d26fe22023aa5ab50d['is_visible']}', '{$vf1965a857bc285d26fe22023aa5ab50d['ord']}', '{$vf1965a857bc285d26fe22023aa5ab50d['is_locked']}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
$v159ce805831f9f42598564e0fbd06f83 = $vf1965a857bc285d26fe22023aa5ab50d['id'];
$v5f2444d49c5d43b9cf7a3d7174b983f1 = l_mysql_insert_id();
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_fields_controller SELECT ord, field_id, '{$v5f2444d49c5d43b9cf7a3d7174b983f1}' FROM cms3_fields_controller WHERE group_id = '{$v159ce805831f9f42598564e0fbd06f83}'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
}
}
$vee085e556579b9a69e64e3eddc559b89 = false;
if ($v6be379826b20cc58475f636e33f4606b) {
$v328a21868fce2b3f8569db40f1aa8a89 = $this->getType($v6be379826b20cc58475f636e33f4606b);
if ($v328a21868fce2b3f8569db40f1aa8a89) {
$vee085e556579b9a69e64e3eddc559b89 = $v328a21868fce2b3f8569db40f1aa8a89->getHierarchyTypeId();
}
}
$v599dcce2998a6b40b1e38e8c6006cb0a = new umiObjectType($v94757cae63fd3e398c0811a976dd6bbe);
$v599dcce2998a6b40b1e38e8c6006cb0a->setName($vb068931cc450442b63f5b3d276ea4297);
$v599dcce2998a6b40b1e38e8c6006cb0a->setIsLocked($v1945c9a2a5e2ba6133f1db6757a35fcb);
if ($vee085e556579b9a69e64e3eddc559b89) {
$v599dcce2998a6b40b1e38e8c6006cb0a->setHierarchyTypeId($vee085e556579b9a69e64e3eddc559b89);
}
$v599dcce2998a6b40b1e38e8c6006cb0a->commit();
$this->types[$v94757cae63fd3e398c0811a976dd6bbe] = $v599dcce2998a6b40b1e38e8c6006cb0a;
umiBranch::saveBranchedTablesRelations();
return $v94757cae63fd3e398c0811a976dd6bbe;
}
public function addType($vb068931cc450442b63f5b3d276ea4297, $vd5d3db1765287eef77d7927cc956f50a, $vabf77184f55403d75b9d51d79162a7ca = "")
{
$this->disableCache();
cacheFrontend::getInstance()->flush();
if ($vb946c44d711ade3b061653732977d043 = $this->getTypeByName($vb068931cc450442b63f5b3d276ea4297, $vabf77184f55403d75b9d51d79162a7ca)) {
$vb946c44d711ade3b061653732977d043->setTitle($vd5d3db1765287eef77d7927cc956f50a);
return $vb946c44d711ade3b061653732977d043->getId();
}
$v32409b63878fa9d5541998646b533159 = l_mysql_real_escape_string($vb068931cc450442b63f5b3d276ea4297);
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_hierarchy_types (name) VALUES('{$v32409b63878fa9d5541998646b533159}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$v94757cae63fd3e398c0811a976dd6bbe = l_mysql_insert_id();
$v599dcce2998a6b40b1e38e8c6006cb0a = new umiHierarchyType($v94757cae63fd3e398c0811a976dd6bbe);
$v599dcce2998a6b40b1e38e8c6006cb0a->setName($vb068931cc450442b63f5b3d276ea4297);
$v599dcce2998a6b40b1e38e8c6006cb0a->setTitle($vd5d3db1765287eef77d7927cc956f50a);
$v599dcce2998a6b40b1e38e8c6006cb0a->setExt($vabf77184f55403d75b9d51d79162a7ca);
$v599dcce2998a6b40b1e38e8c6006cb0a->commit();
$this->types[$v94757cae63fd3e398c0811a976dd6bbe] = $v599dcce2998a6b40b1e38e8c6006cb0a;
return $v94757cae63fd3e398c0811a976dd6bbe;
}
public static function filterInputString($vb45cffe084dd3d20d928bee85e7b0f21)
{
$vb45cffe084dd3d20d928bee85e7b0f21 = l_mysql_real_escape_string($vb45cffe084dd3d20d928bee85e7b0f21);
return $vb45cffe084dd3d20d928bee85e7b0f21;
}
public function redirectIfRequired($vf0183130c6c478a364b95e4325786eb9)
{
$vf0183130c6c478a364b95e4325786eb9 = l_mysql_real_escape_string($this->parseUri($vf0183130c6c478a364b95e4325786eb9));
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
SELECT `target`, `status` FROM `cms3_redirects`
\tWHERE `source` = '{$vf0183130c6c478a364b95e4325786eb9}'
\tORDER BY `id` DESC LIMIT 1
SQL;
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if (mysql_num_rows($result)) {
list($v42aefbae01d2dfd981f7da7d823d689e, $v9acb44549b41563697bb490144ec6258) = mysql_fetch_row($result);
return $this->redirect("/" . $v42aefbae01d2dfd981f7da7d823d689e, (int) $v9acb44549b41563697bb490144ec6258);
}
$v8401668c4e8a4292331d5d46ddd1f649 = explode("/", trim($vf0183130c6c478a364b95e4325786eb9, "/"));
do {
array_pop($v8401668c4e8a4292331d5d46ddd1f649);
$vf93632f2f958d47116bf0ad6ae7e6509 = implode("/", $v8401668c4e8a4292331d5d46ddd1f649) . "/";
$v059db73d368bc8964f075448480bb487 = l_mysql_real_escape_string($this->parseUri($vf93632f2f958d47116bf0ad6ae7e6509));
if (!strlen($v059db73d368bc8964f075448480bb487)) {
if (count($v8401668c4e8a4292331d5d46ddd1f649)) {
continue;
} else {
break;
}
}
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
SELECT `source`, `target`, `status` FROM `cms3_redirects`
\tWHERE `source` = '{$v059db73d368bc8964f075448480bb487}'
\tORDER BY `id` DESC LIMIT 1
SQL;
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if (mysql_num_rows($result)) {
list($v36cd38f49b9afa08222c0dc9ebfe35eb, $v42aefbae01d2dfd981f7da7d823d689e, $v9acb44549b41563697bb490144ec6258) = mysql_fetch_row($result);
$v4cb75ae8da8b4b486d9a2eb6220d78f2 = substr($vf0183130c6c478a364b95e4325786eb9, strlen($v36cd38f49b9afa08222c0dc9ebfe35eb));
$v42aefbae01d2dfd981f7da7d823d689e .= $v4cb75ae8da8b4b486d9a2eb6220d78f2;
$this->redirect("/" . $v42aefbae01d2dfd981f7da7d823d689e, $v9acb44549b41563697bb490144ec6258);
}
} while (sizeof($v8401668c4e8a4292331d5d46ddd1f649) > 1);
}
protected function createKey($vd6fe1d0be6347b8ef2427fa629c04485)
{
$vd6fe1d0be6347b8ef2427fa629c04485 = trim($vd6fe1d0be6347b8ef2427fa629c04485, "/");
$vf961aedab905271a350c4e6eb6d7b6b9 = "//";
$va722790b49e8eb1f37a1c672326ec501 = 0;
foreach (explode("/", $vd6fe1d0be6347b8ef2427fa629c04485) as $v3c6e0b8a9c15224a8228b9a98ca1531d) {
$v3c6e0b8a9c15224a8228b9a98ca1531d = l_mysql_real_escape_string($v3c6e0b8a9c15224a8228b9a98ca1531d);
$vf961aedab905271a350c4e6eb6d7b6b9 .= $v3c6e0b8a9c15224a8228b9a98ca1531d . "/";
if ($vbb90bf734107ea3b2f4c14a5d4bc4f91 = $this->getKey($vf961aedab905271a350c4e6eb6d7b6b9)) {
$va722790b49e8eb1f37a1c672326ec501 = $vbb90bf734107ea3b2f4c14a5d4bc4f91;
} else {
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms_reg (rel, var, val) VALUES ('{$va722790b49e8eb1f37a1c672326ec501}', '{$v3c6e0b8a9c15224a8228b9a98ca1531d}', '')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
$va722790b49e8eb1f37a1c672326ec501 = $vbb90bf734107ea3b2f4c14a5d4bc4f91 = (int) l_mysql_insert_id();
}
}
return $vbb90bf734107ea3b2f4c14a5d4bc4f91;
}
protected function escapeValue($v2063c1608d6e0baf80249c42e2be5804)
{
if (is_array($v2063c1608d6e0baf80249c42e2be5804)) {
foreach ($v2063c1608d6e0baf80249c42e2be5804 as $v865c0c0b4ab0e063e5caa3387c1a8741 => $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
$v2063c1608d6e0baf80249c42e2be5804[$v865c0c0b4ab0e063e5caa3387c1a8741] = $this->escapeValue($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
return $v2063c1608d6e0baf80249c42e2be5804;
}
if ($v2063c1608d6e0baf80249c42e2be5804 instanceof selector) {
return $this->escapeValue($v2063c1608d6e0baf80249c42e2be5804->result());
}
if ($v2063c1608d6e0baf80249c42e2be5804 instanceof iUmiObject || $v2063c1608d6e0baf80249c42e2be5804 instanceof iUmiHierarchyElement) {
return $v2063c1608d6e0baf80249c42e2be5804->id;
} else {
return "'" . l_mysql_real_escape_string($v2063c1608d6e0baf80249c42e2be5804) . "'";
}
}
protected function save()
{
$vb068931cc450442b63f5b3d276ea4297 = l_mysql_real_escape_string($this->name);
$vd5d3db1765287eef77d7927cc956f50a = l_mysql_real_escape_string($this->title);
$v1945c9a2a5e2ba6133f1db6757a35fcb = (int) $this->is_locked;
$vd5752333adc3a004f826f2ea2a41273a = (int) $this->is_inheritable;
$ve1c6c9ef2fcbe75f26f815c4ef2e60b4 = (int) $this->is_visible;
$v1e3f04102267eaf5e8d0ca424fd5c561 = (int) $this->field_type_id;
$v051369818a8073bba5feeb0e957eb308 = $this->guide_id ? (int) $this->guide_id : 'NULL';
$v5fa2ecd1dc485ead330e65903d19650a = (int) $this->is_in_search;
$ve4a2ed2dde6e8354ae6f321744843084 = (int) $this->is_in_filter;
$v6a2139364f96787c8ce1bbb0070b898c = l_mysql_real_escape_string($this->tip);
$v2a9d32d17ad47ac15c87d2e7c96d0e69 = (int) $this->isRequired;
$v23aec26e2b521c0e5f1061b3d04983a5 = (int) $this->sortable;
$v6b1a57fa235477758817df3c91158006 = (int) $this->restrictionId;
$vc9409711ebff9250bd075037d3d18263 = (int) $this->is_system;
$v2c4fe296b3cbdd86fd5aba8ebcad6d36 = $v6b1a57fa235477758817df3c91158006 ? ", restriction_id = '{$v6b1a57fa235477758817df3c91158006}'" : ", restriction_id = NULL";
$vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_object_fields SET name = '{$vb068931cc450442b63f5b3d276ea4297}', title = '{$vd5d3db1765287eef77d7927cc956f50a}', is_locked = '{$v1945c9a2a5e2ba6133f1db6757a35fcb}', is_inheritable = '{$vd5752333adc3a004f826f2ea2a41273a}', is_visible = '{$ve1c6c9ef2fcbe75f26f815c4ef2e60b4}', field_type_id = '{$v1e3f04102267eaf5e8d0ca424fd5c561}', guide_id = {$v051369818a8073bba5feeb0e957eb308}, in_search = '{$v5fa2ecd1dc485ead330e65903d19650a}', in_filter = '{$ve4a2ed2dde6e8354ae6f321744843084}', tip = '{$v6a2139364f96787c8ce1bbb0070b898c}', is_required = '{$v2a9d32d17ad47ac15c87d2e7c96d0e69}', sortable = '{$v23aec26e2b521c0e5f1061b3d04983a5}', is_system = '{$vc9409711ebff9250bd075037d3d18263}' {$v2c4fe296b3cbdd86fd5aba8ebcad6d36} WHERE id = '{$this->id}'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
cacheFrontend::getInstance()->flush();
return true;
}
public static function filterInputString($vb45cffe084dd3d20d928bee85e7b0f21)
{
$vb45cffe084dd3d20d928bee85e7b0f21 = umiObjectProperty::filterCDATA($vb45cffe084dd3d20d928bee85e7b0f21);
$vb45cffe084dd3d20d928bee85e7b0f21 = l_mysql_real_escape_string($vb45cffe084dd3d20d928bee85e7b0f21);
if (isset($_SERVER['DOCUMENT_ROOT']) && cmsController::getInstance()->getCurrentMode() != "admin" && !umiObjectProperty::$IGNORE_FILTER_INPUT_STRING && !(defined("CRON") && CRON)) {
$vb45cffe084dd3d20d928bee85e7b0f21 = str_replace(array("%", "%"), "%", $vb45cffe084dd3d20d928bee85e7b0f21);
$vb45cffe084dd3d20d928bee85e7b0f21 = htmlspecialchars(htmlspecialchars_decode($vb45cffe084dd3d20d928bee85e7b0f21), ENT_NOQUOTES);
$vb45cffe084dd3d20d928bee85e7b0f21 = str_replace("%", "%", $vb45cffe084dd3d20d928bee85e7b0f21);
}
return $vb45cffe084dd3d20d928bee85e7b0f21;
}
/**
* @desc Deprecated methods. Leave for backward compatibility. Not for a long time
* @deprecated
*/
public function insert($who = "", $template = "default")
{
$who = trim($who);
if (!$template) {
$template = "default";
}
list($template_block, $template_to_block, $template_to_line) = def_module::loadTemplates("webforms/" . $template, "webforms_block", "webforms_to_block", "webforms_to_line");
if (!defined("DB_DRIVER") || DB_DRIVER != "xml") {
$sql = "SELECT `id`, `descr` FROM cms_webforms";
$result = l_mysql_query($sql);
$lines = "";
$items = array();
while ($row = mysql_fetch_assoc($result)) {
$from = array("%text%", "%id%");
$to = array($row['descr'], $row['id']);
$lines .= str_replace($from, $to, $template_to_line);
$block = array();
$block['attribute:id'] = $row['id'];
$block['node:descr'] = $row['descr'];
$items[] = $block;
}
}
$oObjects = umiObjectsCollection::getInstance();
$oSelection = new umiSelection();
$oSelection->addObjectType(umiObjectTypesCollection::getInstance()->getBaseType('webforms', 'address'));
$aOIDs = umiSelectionsParser::runSelection($oSelection);
foreach ($aOIDs as $iID) {
$sTitle = $oObjects->getObject($iID)->getValue('address_description');
$from = array("%text%", "%id%");
$to = array($sTitle, $iID);
$lines .= str_replace($from, $to, $template_to_line);
$block = array();
$block['attribute:id'] = $iID;
$block['node:descr'] = $sTitle;
$items[] = $block;
}
$res_to = str_replace("%lines%", $lines, $template_to_block);
if ($who) {
if (is_numeric($who)) {
$res_to = "<input type='hidden' name='email_to' value='" . $who . "' />";
} else {
$iAddrID = $this->guessAddressId($who);
if (strval($iAddrID) != $who) {
$res_to = "<input type='hidden' name='email_to' value='" . $iAddrID . "' />";
} else {
$who = l_mysql_real_escape_string($who);
$sql = "SELECT id FROM cms_webforms WHERE email='{$who}'";
$result = l_mysql_query($sql);
if ($row = mysql_fetch_assoc($result)) {
$res_to = "<input type='hidden' name='email_to' value='" . $row['id'] . "' />";
} else {
$res_to = "<input type='hidden' name='email_to' value='" . $who . "' />";
}
}
}
}
$block_arr = array();
$block_arr['to_block'] = $res_to;
$block_arr['template'] = $template;
$block_arr['subnodes:items'] = $items;
return self::parseTemplate($template_block, $block_arr);
}
public function getGuidedItems($v051369818a8073bba5feeb0e957eb308)
{
$v9b207167e5381c47682c6b4f58a623fb = array();
if (is_int($v051369818a8073bba5feeb0e957eb308)) {
$v051369818a8073bba5feeb0e957eb308 = (int) $v051369818a8073bba5feeb0e957eb308;
} else {
$v051369818a8073bba5feeb0e957eb308 = l_mysql_real_escape_string($v051369818a8073bba5feeb0e957eb308);
$v1b1cc7f086b3f074da452bc3129981eb = "SELECT `id` FROM `cms3_object_types` WHERE `guid`='" . $v051369818a8073bba5feeb0e957eb308 . "' LIMIT 1";
$result = l_mysql_query($v1b1cc7f086b3f074da452bc3129981eb);
if (0 < mysql_numrows($result)) {
$v051369818a8073bba5feeb0e957eb308 = mysql_result($result, 0);
} else {
$v051369818a8073bba5feeb0e957eb308 = (int) $v051369818a8073bba5feeb0e957eb308;
}
}
$v47474f16bc8e08736ec6d8eece4f8c96 = intval(regedit::getInstance()->getVal("//settings/ignore_guides_sort")) ? true : false;
if ($v47474f16bc8e08736ec6d8eece4f8c96) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id, name FROM cms3_objects WHERE type_id = '{$v051369818a8073bba5feeb0e957eb308}' ORDER BY id ASC";
} else {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id, name FROM cms3_objects WHERE type_id = '{$v051369818a8073bba5feeb0e957eb308}' ORDER BY name ASC";
}
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
return false;
}
while (list($vb80bb7740288fda1f201890375a60c8f, $vb068931cc450442b63f5b3d276ea4297) = mysql_fetch_row($result)) {
$v9b207167e5381c47682c6b4f58a623fb[$vb80bb7740288fda1f201890375a60c8f] = $this->translateLabel($vb068931cc450442b63f5b3d276ea4297);
}
if (!$v47474f16bc8e08736ec6d8eece4f8c96) {
natsort($v9b207167e5381c47682c6b4f58a623fb);
}
return $v9b207167e5381c47682c6b4f58a623fb;
}
public function getOldRestrictionIdRelation($v0afd9202ba86aa11ce63ad7007e7990b, $ve1ecb99e7d44ff958e8773995f930c0c)
{
$v0afd9202ba86aa11ce63ad7007e7990b = l_mysql_real_escape_string($v0afd9202ba86aa11ce63ad7007e7990b);
$ve1ecb99e7d44ff958e8773995f930c0c = l_mysql_real_escape_string($ve1ecb99e7d44ff958e8773995f930c0c);
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT old_id FROM cms3_import_restrictions WHERE new_id = '{$ve1ecb99e7d44ff958e8773995f930c0c}' AND source_id = '{$v0afd9202ba86aa11ce63ad7007e7990b}'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
if (list($v61ce6a78cb3c8547fed20990c92edfe3) = mysql_fetch_row($result)) {
return (string) $v61ce6a78cb3c8547fed20990c92edfe3;
} else {
return false;
}
}
protected function loadNodeId()
{
$va2a378958abe1e16d9a95dd3ad727378 = l_mysql_real_escape_string($_SERVER['SERVER_ADDR']);
$result = l_mysql_query("SELECT `id` FROM `cms3_cluster_nodes` WHERE `node_ip` = '{$va2a378958abe1e16d9a95dd3ad727378}'");
if (mysql_num_rows($result)) {
list($vd515995b533ca9885d38f38535debc73) = mysql_fetch_row($result);
$this->nodeId = $vd515995b533ca9885d38f38535debc73;
return true;
} else {
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO `cms3_cluster_nodes` (`node_ip`) VALUES ('{$va2a378958abe1e16d9a95dd3ad727378}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$this->nodeId = l_mysql_insert_id();
return true;
}
}
public function suggestions($vb45cffe084dd3d20d928bee85e7b0f21, $vaa9f73eea60a006820d0f8768bc8a3fc = 10)
{
$vb45cffe084dd3d20d928bee85e7b0f21 = trim($vb45cffe084dd3d20d928bee85e7b0f21);
if (!$vb45cffe084dd3d20d928bee85e7b0f21) {
return false;
}
$vb45cffe084dd3d20d928bee85e7b0f21 = wa_strtolower($vb45cffe084dd3d20d928bee85e7b0f21);
$va04202c712aa415f47dbacb817a60397 = str_split('йцукенгшщзхъфывапролджэячсмитьбю');
$v74e6a8b111ea7da1a7d0a596f4c35208 = str_split('qwertyuiop[]asdfghjkl;\'zxcvbnm,.');
$v9c1b200500ea38c658ac7c81b10e85d2 = iconv("UTF-8", "CP1251", $vb45cffe084dd3d20d928bee85e7b0f21);
$ve39cf8a95dc90270161317376387b25a = iconv("CP1251", "UTF-8", str_replace($va04202c712aa415f47dbacb817a60397, $v74e6a8b111ea7da1a7d0a596f4c35208, $v9c1b200500ea38c658ac7c81b10e85d2));
$v67ae3d093b55e92227d0861222db0c6d = iconv("CP1251", "UTF-8", str_replace($v74e6a8b111ea7da1a7d0a596f4c35208, $va04202c712aa415f47dbacb817a60397, $v9c1b200500ea38c658ac7c81b10e85d2));
$vd0c03a4c136b717b6ebc603966e26755 = $ve39cf8a95dc90270161317376387b25a != $vb45cffe084dd3d20d928bee85e7b0f21 ? $ve39cf8a95dc90270161317376387b25a : $v67ae3d093b55e92227d0861222db0c6d;
$vb45cffe084dd3d20d928bee85e7b0f21 = l_mysql_real_escape_string($vb45cffe084dd3d20d928bee85e7b0f21);
$vd0c03a4c136b717b6ebc603966e26755 = l_mysql_real_escape_string($vd0c03a4c136b717b6ebc603966e26755);
$vaa9f73eea60a006820d0f8768bc8a3fc = (int) $vaa9f73eea60a006820d0f8768bc8a3fc;
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
SELECT `siw`.`word` as `word`, COUNT(`si`.`word_id`) AS `cnt`
\tFROM
\t\t`cms3_search_index_words` `siw`,
\t\t`cms3_search_index` `si`
\tWHERE
\t\t(
\t\t\t`siw`.`word` LIKE '{$vb45cffe084dd3d20d928bee85e7b0f21}%' OR
\t\t\t`siw`.`word` LIKE '{$vd0c03a4c136b717b6ebc603966e26755}%'
\t\t) AND
\t\t`si`.`word_id` = `siw`.`id`
\tGROUP BY
\t\t`siw`.`id`
\tORDER BY SUM(`si`.`tf`) DESC
\tLIMIT {$vaa9f73eea60a006820d0f8768bc8a3fc}
SQL;
$v4717d53ebfdfea8477f780ec66151dcb = ConnectionPool::getInstance()->getConnection('search');
return $v4717d53ebfdfea8477f780ec66151dcb->queryResult($vac5c74b64b4b8352ef2f181affb5ac2a);
}
public function getPrivileged($perms)
{
if (!sizeof($perms)) {
return array();
}
$sql = 'SELECT owner_id FROM cms_permissions WHERE ';
$sqls = array();
foreach ($perms as $perm) {
$module = l_mysql_real_escape_string(getArrayKey($perm, 0));
$method = l_mysql_real_escape_string($this->getBaseMethodName($module, getArrayKey($perm, 1)));
$sqls[] = "(module = '{$module}' AND method = '{$method}')";
}
$sql .= implode(' OR ', $sqls);
$result = l_mysql_query($sql);
$owners = array();
while (list($ownerId) = mysql_fetch_row($result)) {
$owners[] = $ownerId;
}
$owners = array_unique($owners);
return $owners;
}
public function getIdByPath($v84d8c2148d233e7430fceb3f20ae3314, $vda936bf93b2dd512e0554fd9eb7b4120 = false, &$v3dbd53d892aaea70c9f5fefc18fc7e4c = 0, $v662cbf1253ac7d8750ed9190c52163e5 = false, $v78e6dd7a49f5b0cb2106a3a434dd5c86 = false)
{
$v78e6dd7a49f5b0cb2106a3a434dd5c86 = (int) $v78e6dd7a49f5b0cb2106a3a434dd5c86;
$v662cbf1253ac7d8750ed9190c52163e5 = (int) $v662cbf1253ac7d8750ed9190c52163e5;
if ($v5f44c555cfb3ecb28f624fa95617f277 = mainConfiguration::getInstance()->get('seo', 'url-suffix')) {
$v5e0bdcbddccca4d66d74ba8c1cee1a68 = strrpos($v84d8c2148d233e7430fceb3f20ae3314, $v5f44c555cfb3ecb28f624fa95617f277);
if ($v5e0bdcbddccca4d66d74ba8c1cee1a68 && $v5e0bdcbddccca4d66d74ba8c1cee1a68 + strlen($v5f44c555cfb3ecb28f624fa95617f277) == strlen($v84d8c2148d233e7430fceb3f20ae3314)) {
$v84d8c2148d233e7430fceb3f20ae3314 = substr($v84d8c2148d233e7430fceb3f20ae3314, 0, $v5e0bdcbddccca4d66d74ba8c1cee1a68);
}
}
$v84d8c2148d233e7430fceb3f20ae3314 = trim($v84d8c2148d233e7430fceb3f20ae3314, "\\/ \n");
$v8b1dc169bf460ee884fceef66c6607d6 = cmsController::getInstance();
if (empty($v78e6dd7a49f5b0cb2106a3a434dd5c86)) {
$v78e6dd7a49f5b0cb2106a3a434dd5c86 = $v8b1dc169bf460ee884fceef66c6607d6->getCurrentLang()->getId();
}
if (empty($v662cbf1253ac7d8750ed9190c52163e5)) {
$v662cbf1253ac7d8750ed9190c52163e5 = $v8b1dc169bf460ee884fceef66c6607d6->getCurrentDomain()->getId();
}
$v143e21b64126735544d3142d33aa4bbe = md5($v662cbf1253ac7d8750ed9190c52163e5 . ":" . $v78e6dd7a49f5b0cb2106a3a434dd5c86 . ":" . $v84d8c2148d233e7430fceb3f20ae3314);
if (isset($this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe])) {
return $this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe];
}
$vb99eb979e6f6efabc396f777b503f7e7 = cacheFrontend::getInstance();
if ($vb80bb7740288fda1f201890375a60c8f = $vb99eb979e6f6efabc396f777b503f7e7->loadSql($v143e21b64126735544d3142d33aa4bbe . "_path")) {
return $vb80bb7740288fda1f201890375a60c8f;
}
if ($v84d8c2148d233e7430fceb3f20ae3314 == "") {
return $this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe] = $this->getDefaultElementId($v78e6dd7a49f5b0cb2106a3a434dd5c86, $v662cbf1253ac7d8750ed9190c52163e5);
}
$ve4e46deb7f9cc58c7abfb32e5570b6f3 = domainsCollection::getInstance();
$v13872c0118a4316afd1e99295017d654 = explode("/", $v84d8c2148d233e7430fceb3f20ae3314);
$v7dabf5c198b0bab2eaa42bb03a113e55 = sizeof($v13872c0118a4316afd1e99295017d654);
$vb80bb7740288fda1f201890375a60c8f = 0;
for ($v865c0c0b4ab0e063e5caa3387c1a8741 = 0; $v865c0c0b4ab0e063e5caa3387c1a8741 < $v7dabf5c198b0bab2eaa42bb03a113e55; $v865c0c0b4ab0e063e5caa3387c1a8741++) {
$vd84ff935144e00c3e1d395c2379aca47 = $v13872c0118a4316afd1e99295017d654[$v865c0c0b4ab0e063e5caa3387c1a8741];
$vd84ff935144e00c3e1d395c2379aca47 = l_mysql_real_escape_string($vd84ff935144e00c3e1d395c2379aca47);
if ($v865c0c0b4ab0e063e5caa3387c1a8741 == 0) {
if ($v3c2d776e82f7716166c1c2183822a04b = $ve4e46deb7f9cc58c7abfb32e5570b6f3->getDomainId($vd84ff935144e00c3e1d395c2379aca47)) {
$v662cbf1253ac7d8750ed9190c52163e5 = $v3c2d776e82f7716166c1c2183822a04b;
continue;
}
}
if ($vda936bf93b2dd512e0554fd9eb7b4120) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id FROM cms3_hierarchy WHERE rel = '{$vb80bb7740288fda1f201890375a60c8f}' AND alt_name = '{$vd84ff935144e00c3e1d395c2379aca47}' AND lang_id = '{$v78e6dd7a49f5b0cb2106a3a434dd5c86}' AND domain_id = '{$v662cbf1253ac7d8750ed9190c52163e5}'";
} else {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id FROM cms3_hierarchy WHERE rel = '{$vb80bb7740288fda1f201890375a60c8f}' AND alt_name = '{$vd84ff935144e00c3e1d395c2379aca47}' AND is_active='1' AND is_deleted = '0' AND lang_id = '{$v78e6dd7a49f5b0cb2106a3a434dd5c86}' AND domain_id = '{$v662cbf1253ac7d8750ed9190c52163e5}'";
}
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if (!mysql_num_rows($result)) {
if ($vda936bf93b2dd512e0554fd9eb7b4120) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id, alt_name FROM cms3_hierarchy WHERE rel = '{$vb80bb7740288fda1f201890375a60c8f}' AND lang_id = '{$v78e6dd7a49f5b0cb2106a3a434dd5c86}' AND domain_id = '{$v662cbf1253ac7d8750ed9190c52163e5}'";
} else {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id, alt_name FROM cms3_hierarchy WHERE rel = '{$vb80bb7740288fda1f201890375a60c8f}' AND is_active = '1' AND is_deleted = '0' AND lang_id = '{$v78e6dd7a49f5b0cb2106a3a434dd5c86}' AND domain_id = '{$v662cbf1253ac7d8750ed9190c52163e5}'";
}
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$v2ffe4e77325d9a7152f7086ea7aa5114 = 0;
$vb6b6e66c9db093b3c4c8800ac9365830 = 0;
$v1a1cc17b4341344c0ceec516de628da3 = 0;
while (list($vb6b6e66c9db093b3c4c8800ac9365830, $v423b21e5932f11b123a1ddb35654b51b) = mysql_fetch_row($result)) {
if ($this->autocorrectionDisabled) {
if ($vd84ff935144e00c3e1d395c2379aca47 == $v423b21e5932f11b123a1ddb35654b51b) {
$v1a1cc17b4341344c0ceec516de628da3 = $vb6b6e66c9db093b3c4c8800ac9365830;
}
} else {
$v3d801aa532c1cec3ee82d87a99fdf63f = umiHierarchy::compareStrings($vd84ff935144e00c3e1d395c2379aca47, $v423b21e5932f11b123a1ddb35654b51b);
if ($v3d801aa532c1cec3ee82d87a99fdf63f > $v2ffe4e77325d9a7152f7086ea7aa5114) {
$v2ffe4e77325d9a7152f7086ea7aa5114 = $v3d801aa532c1cec3ee82d87a99fdf63f;
$v1a1cc17b4341344c0ceec516de628da3 = $vb6b6e66c9db093b3c4c8800ac9365830;
++$v3dbd53d892aaea70c9f5fefc18fc7e4c;
}
}
}
if ($v2ffe4e77325d9a7152f7086ea7aa5114 > 75) {
$vb80bb7740288fda1f201890375a60c8f = $v1a1cc17b4341344c0ceec516de628da3;
} else {
return $this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe] = false;
}
} else {
if (!(list($vb80bb7740288fda1f201890375a60c8f) = mysql_fetch_row($result))) {
return $this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe] = false;
}
}
}
$vb99eb979e6f6efabc396f777b503f7e7->saveSql($v143e21b64126735544d3142d33aa4bbe . "_path", $vb80bb7740288fda1f201890375a60c8f, 3600);
return $this->idByPathCache[$v143e21b64126735544d3142d33aa4bbe] = $vb80bb7740288fda1f201890375a60c8f;
}
public function save($vf33a4e939ffe21234596860b7249c246 = "", $vad0c3358f1a712601256bfc6e9ee9830 = "", $v05dd82e678780573a4af462d35d7f06d = "")
{
if (!regedit::getInstance()->getVal("//modules/backup/enabled")) {
return false;
}
if (getRequest('rollbacked')) {
return false;
}
$this->restoreIncrement();
$v8b1dc169bf460ee884fceef66c6607d6 = cmsController::getInstance();
if (!$vad0c3358f1a712601256bfc6e9ee9830) {
$vad0c3358f1a712601256bfc6e9ee9830 = $v8b1dc169bf460ee884fceef66c6607d6->getCurrentModule();
}
$v05dd82e678780573a4af462d35d7f06d = $v8b1dc169bf460ee884fceef66c6607d6->getCurrentMethod();
$v1d0c3e03c46ba6aa6adb5394fecfc396 = $v8b1dc169bf460ee884fceef66c6607d6->getModule('users') ? $v1d0c3e03c46ba6aa6adb5394fecfc396 = $v8b1dc169bf460ee884fceef66c6607d6->getModule('users')->user_id : 0;
$v8c1eddb947fad440954f3c703d4df808 = time();
if (!$vad0c3358f1a712601256bfc6e9ee9830) {
$vad0c3358f1a712601256bfc6e9ee9830 = getRequest('module');
}
if (!$v05dd82e678780573a4af462d35d7f06d) {
$v05dd82e678780573a4af462d35d7f06d = getRequest('method');
}
foreach ($_REQUEST as $v7efdfc94655a25dcea3ec85e9bb703fa => $vde3ec0aa2234aa1e3ee275bbc715c6c9) {
if ($v7efdfc94655a25dcea3ec85e9bb703fa == "save-mode") {
continue;
}
$_temp[$v7efdfc94655a25dcea3ec85e9bb703fa] = !is_array($vde3ec0aa2234aa1e3ee275bbc715c6c9) ? base64_encode($vde3ec0aa2234aa1e3ee275bbc715c6c9) : $vde3ec0aa2234aa1e3ee275bbc715c6c9;
}
if (isset($_temp['data']['new'])) {
$v8e2dcfd7e7e24b1ca76c1193f645902b = umiHierarchy::getInstance()->getElement($vf33a4e939ffe21234596860b7249c246);
if ($v8e2dcfd7e7e24b1ca76c1193f645902b instanceof umiHierarchyElement) {
$_temp['data'][$v8e2dcfd7e7e24b1ca76c1193f645902b->getObjectId()] = $_temp['data']['new'];
unset($_temp['data']['new']);
}
}
$vab4d0a658aef644a039b90c2067b45c0 = serialize($_temp);
$vab4d0a658aef644a039b90c2067b45c0 = l_mysql_real_escape_string($vab4d0a658aef644a039b90c2067b45c0);
$vf33a4e939ffe21234596860b7249c246 = l_mysql_real_escape_string($vf33a4e939ffe21234596860b7249c246);
$vad0c3358f1a712601256bfc6e9ee9830 = l_mysql_real_escape_string($vad0c3358f1a712601256bfc6e9ee9830);
$v05dd82e678780573a4af462d35d7f06d = l_mysql_real_escape_string($v05dd82e678780573a4af462d35d7f06d);
$vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms_backup SET is_active='0' WHERE param='" . $vf33a4e939ffe21234596860b7249c246 . "'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
INSERT INTO cms_backup (ctime, changed_module, changed_method, param, param0, user_id, is_active)
\t\t\t\tVALUES('{$v8c1eddb947fad440954f3c703d4df808}', '{$vad0c3358f1a712601256bfc6e9ee9830}', '{$v05dd82e678780573a4af462d35d7f06d}', '{$vf33a4e939ffe21234596860b7249c246}', '{$vab4d0a658aef644a039b90c2067b45c0}', '{$v1d0c3e03c46ba6aa6adb5394fecfc396}', '1')
SQL;
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$vaa9f73eea60a006820d0f8768bc8a3fc = regedit::getInstance()->getVal("//modules/backup/max_save_actions");
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT COUNT(*) FROM cms_backup WHERE param='" . $vf33a4e939ffe21234596860b7249c246 . "' ORDER BY ctime DESC";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
list($vaacd38cfef1bec4d335a62835fda0839) = mysql_fetch_row($result);
$v626726e60bd1215f36719a308a25b798 = $vaacd38cfef1bec4d335a62835fda0839 - $vaa9f73eea60a006820d0f8768bc8a3fc;
if ($v626726e60bd1215f36719a308a25b798 < 0) {
$v626726e60bd1215f36719a308a25b798 = 0;
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id FROM cms_backup WHERE param='" . $vf33a4e939ffe21234596860b7249c246 . "' ORDER BY ctime DESC LIMIT 2";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$v975736d9abdba70140122f735ae3078e = array();
while (list($v6854af81e6aa52bea3d9bd1afbff5cab) = mysql_fetch_row($result)) {
$v975736d9abdba70140122f735ae3078e[] = $v6854af81e6aa52bea3d9bd1afbff5cab;
}
$v0b951629e3502f9eedc07d60d307de11 = "";
if (count($v975736d9abdba70140122f735ae3078e)) {
$v0b951629e3502f9eedc07d60d307de11 = "AND id NOT IN (" . implode(", ", $v975736d9abdba70140122f735ae3078e) . ")";
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "DELETE FROM cms_backup WHERE param='" . $vf33a4e939ffe21234596860b7249c246 . "' {$v0b951629e3502f9eedc07d60d307de11} ORDER BY ctime ASC LIMIT " . $v626726e60bd1215f36719a308a25b798;
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$vb37057aff71d268f8b562c7dd23453a6 = regedit::getInstance()->getVal("//modules/backup/max_timelimit");
$v305d28898e362717b3ad3d0181c15636 = $vb37057aff71d268f8b562c7dd23453a6 * 3600 * 24;
$vac5c74b64b4b8352ef2f181affb5ac2a = "DELETE FROM cms_backup WHERE param='" . $vf33a4e939ffe21234596860b7249c246 . "' AND (" . time() . "-ctime)>" . $v305d28898e362717b3ad3d0181c15636 . " {$v0b951629e3502f9eedc07d60d307de11} ORDER BY ctime ASC";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
return true;
}
protected function save()
{
$vb068931cc450442b63f5b3d276ea4297 = l_mysql_real_escape_string($this->name);
$v17f71d965fe9589ddbd11caf7182243e = l_mysql_real_escape_string($this->data_type);
$v96a76ec43956dac431b643cbd544dd08 = (int) $this->is_multiple;
$vf089d93c2ef0d088edadddb0028d548d = (int) $this->is_unsigned;
$vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_object_field_types SET name = '{$vb068931cc450442b63f5b3d276ea4297}', data_type = '{$v17f71d965fe9589ddbd11caf7182243e}', is_multiple = '{$v96a76ec43956dac431b643cbd544dd08}', is_unsigned = '{$vf089d93c2ef0d088edadddb0028d548d}' WHERE id = '{$this->id}'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
cacheFrontend::getInstance()->flush();
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
return false;
} else {
return true;
}
}
/**
* Метод для поиска Id домена по его имени
*
* @param string $hostname
* @return integer
*/
protected function searchHostIdByHostname($hostname)
{
$name = l_mysql_real_escape_string($hostname);
$qry = "SELECT `rel` FROM `cms3_domain_mirrows` WHERE `host` = '".$name."'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if (isset($row['rel']) && ($row['rel'] > 0)) {
$qry = "SELECT `host` FROM `cms3_domains` WHERE `id`='". $row['rel'] ."'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if(isset($row['host']) && ($row['host']!='')) $name = $row['host'];
} else {
$qry = "SELECT `id` FROM `cms3_domains` WHERE `host`='". $name ."'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if(!isset($row['id']) || ($row['id']==0)) {
$qry = "SELECT `host` FROM `cms3_domains` WHERE `is_default`='1'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if(isset($row['host']) && ($row['host']!='')) $name = $row['host'];
}
}
$qry = "SELECT `group_id` FROM `cms_stat_sites` WHERE `name` = '" . $name . "'";
$res = l_mysql_query($qry);
$row = mysql_fetch_assoc($res);
if (isset($row['group_id'])) {
return $row['group_id'];
}
$qry = "INSERT INTO `cms_stat_sites_groups` (`name`) VALUES ('" . $name . "')";
l_mysql_query($qry);
$id = l_mysql_insert_id();
$qry = "INSERT INTO `cms_stat_sites` (`name`, `group_id`) VALUES ('" . $name . "', " . $id . ")";
l_mysql_query($qry);
return $id;
}
public static function getAllGroupsByName($vb068931cc450442b63f5b3d276ea4297)
{
if ($vb068931cc450442b63f5b3d276ea4297) {
$vb068931cc450442b63f5b3d276ea4297 = l_mysql_real_escape_string($vb068931cc450442b63f5b3d276ea4297);
} else {
return false;
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT `id` FROM `cms3_object_field_groups` WHERE `name` = '{$vb068931cc450442b63f5b3d276ea4297}'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$v1471e4e05a4db95d353cc867fe317314 = array();
while (list($v47db2588331bbe530c80dd001fc60aed) = mysql_fetch_row($result)) {
$vdb0f6f37ebeb6ea09489124345af2a45 = new umiFieldsGroup($v47db2588331bbe530c80dd001fc60aed);
if ($vdb0f6f37ebeb6ea09489124345af2a45 instanceof umiFieldsGroup) {
$v1471e4e05a4db95d353cc867fe317314[] = $vdb0f6f37ebeb6ea09489124345af2a45;
}
}
return $v1471e4e05a4db95d353cc867fe317314;
}
private static function makeNamesPart(umiSelection $vef5714e0519bfaa645cdff7d28843b70)
{
$v932238d827b73f9a5329f0ee492a6175 = array();
if (($v44c20123a4be1d9cc98c2f1c2470598d = $vef5714e0519bfaa645cdff7d28843b70->getNameConds()) && count($v44c20123a4be1d9cc98c2f1c2470598d)) {
foreach ($v44c20123a4be1d9cc98c2f1c2470598d as $ve0f38ebd960676b35b7fda2446bff541) {
$v056301054c43f8bbea2090debfec16b1 = $ve0f38ebd960676b35b7fda2446bff541['value'];
$vb6c8416e95a754076b10d65d1afd3fa9 = true;
if (substr($v056301054c43f8bbea2090debfec16b1, 0, 1) === '%' || substr($v056301054c43f8bbea2090debfec16b1, -1) === '%') {
$vb6c8416e95a754076b10d65d1afd3fa9 = false;
}
$v056301054c43f8bbea2090debfec16b1 = l_mysql_real_escape_string($v056301054c43f8bbea2090debfec16b1);
if ($ve0f38ebd960676b35b7fda2446bff541['type'] == 'exact') {
$v932238d827b73f9a5329f0ee492a6175[] = "o.name = '" . $v056301054c43f8bbea2090debfec16b1 . "'";
} else {
$v932238d827b73f9a5329f0ee492a6175[] = "o.name LIKE '" . ($vb6c8416e95a754076b10d65d1afd3fa9 ? "%" : "") . $v056301054c43f8bbea2090debfec16b1 . ($vb6c8416e95a754076b10d65d1afd3fa9 ? "%" : "") . "'";
}
$vef5714e0519bfaa645cdff7d28843b70->objectTableIsRequired = true;
}
}
if (count($v932238d827b73f9a5329f0ee492a6175)) {
$vef5714e0519bfaa645cdff7d28843b70->sql_arr_for_and_or_part['where'][] = "(" . implode(' OR ', $v932238d827b73f9a5329f0ee492a6175) . ")";
}
}
public function getOldFieldName($v0afd9202ba86aa11ce63ad7007e7990b, $v94757cae63fd3e398c0811a976dd6bbe, $v32efe3ba69eb769cff89b115a9760c26)
{
$v0afd9202ba86aa11ce63ad7007e7990b = l_mysql_real_escape_string($v42514bacd9653bd1b2281f3643c722c8);
$v94757cae63fd3e398c0811a976dd6bbe = l_mysql_real_escape_string($v94757cae63fd3e398c0811a976dd6bbe);
$v32efe3ba69eb769cff89b115a9760c26 = l_mysql_real_escape_string($v32efe3ba69eb769cff89b115a9760c26);
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT field_name FROM cms3_import_fields WHERE source_id = '{$v0afd9202ba86aa11ce63ad7007e7990b}' AND type_id = '{$v94757cae63fd3e398c0811a976dd6bbe}' AND new_id = '{$v32efe3ba69eb769cff89b115a9760c26}'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if (list($v6adb6b0ad1941d569b23e089910c5e74) = mysql_fetch_row($result)) {
return (string) $v6adb6b0ad1941d569b23e089910c5e74;
} else {
return false;
}
}
protected function save()
{
$vd5d3db1765287eef77d7927cc956f50a = l_mysql_real_escape_string($this->title);
$v9a0364b9e99bb480dd25e1f0284c8555 = l_mysql_real_escape_string($this->content);
$v3b8cb51bd8c4ef331893ce61e3f3bc39 = $this->senderId ? $this->senderId : 'NULL';
$v1ed2e1b19b6e55d52d2473be17a4afd9 = $this->createTime->getDateTimeStamp();
$vb988295c268025b49dfb3df26171ddc3 = (int) $this->priority;
$v599dcce2998a6b40b1e38e8c6006cb0a = $this->type;
$v9c014ff3d8d453a6273a3384feca7414 = (int) $this->isSended;
$vb80bb7740288fda1f201890375a60c8f = (int) $this->id;
$vac5c74b64b4b8352ef2f181affb5ac2a = <<<SQL
UPDATE `cms3_messages`
\tSET `title` = '{$vd5d3db1765287eef77d7927cc956f50a}', `content` = '{$v9a0364b9e99bb480dd25e1f0284c8555}',
\t\t`create_time` = '{$v1ed2e1b19b6e55d52d2473be17a4afd9}', `priority` = '{$vb988295c268025b49dfb3df26171ddc3}',
\t\t`type` = '{$v599dcce2998a6b40b1e38e8c6006cb0a}', `sender_id` = {$v3b8cb51bd8c4ef331893ce61e3f3bc39}, `is_sended` = '{$v9c014ff3d8d453a6273a3384feca7414}'
\t\t\tWHERE `id` = '{$vb80bb7740288fda1f201890375a60c8f}'
SQL;
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
}
