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); }