public static function saveBranchedTablesRelations() { $v47826cacc65c665212b821e6ff80b9b0 = self::getRelationsFilePath(); $v9b81909fd0da3add2602a8d0ede0e4e7 = umiObjectTypesCollection::getInstance(); self::$branchedObjectTypes = array(); clearstatcache(); if (file_exists($v47826cacc65c665212b821e6ff80b9b0)) { unlink($v47826cacc65c665212b821e6ff80b9b0); } $vac5c74b64b4b8352ef2f181affb5ac2a = "SHOW TABLES LIKE 'cms3_object_content%'"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } $v8587774de94e7ee1616350d82cc72317 = array(); while (list($v80071f37861c360a27b7327e132c911a) = mysql_fetch_row($result)) { if (preg_match("/cms3_object_content_([0-9]+)/", $v80071f37861c360a27b7327e132c911a, $vc68271a63ddbc431c307beb7d2918275)) { $v8587774de94e7ee1616350d82cc72317[] = (int) $vc68271a63ddbc431c307beb7d2918275[1]; } } $vf9ecb86fe4446d46abf44c1f55be3d43 = array(); foreach ($v8587774de94e7ee1616350d82cc72317 as $vacf567c9c3d6cf7c6e2cc0ce108e0631) { $v0e8133eb006c0f85ed9444ae07a60842 = array_keys($v9b81909fd0da3add2602a8d0ede0e4e7->getTypesByHierarchyTypeId($vacf567c9c3d6cf7c6e2cc0ce108e0631)); if (is_array($v0e8133eb006c0f85ed9444ae07a60842)) { foreach ($v0e8133eb006c0f85ed9444ae07a60842 as $v6301cee35ea764a1e241978f93f01069) { $vf9ecb86fe4446d46abf44c1f55be3d43[$v6301cee35ea764a1e241978f93f01069] = $vacf567c9c3d6cf7c6e2cc0ce108e0631; } } } file_put_contents($v47826cacc65c665212b821e6ff80b9b0, serialize($vf9ecb86fe4446d46abf44c1f55be3d43)); chmod($v47826cacc65c665212b821e6ff80b9b0, 0777); return self::$branchedObjectTypes = $vf9ecb86fe4446d46abf44c1f55be3d43; }
protected function saveValue() { $this->deleteCurrentRows(); $v2817f701d5e1a1181e657251363295fd = 0; foreach ($this->value as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) { if ($v3a6d0284e743dc4a9b86f97d6dd1a3bf === false || $v3a6d0284e743dc4a9b86f97d6dd1a3bf === "") { continue; } if (strpos(".", $v3a6d0284e743dc4a9b86f97d6dd1a3bf) === false) { $v3a6d0284e743dc4a9b86f97d6dd1a3bf = str_replace(",", ".", $v3a6d0284e743dc4a9b86f97d6dd1a3bf); } $v3a6d0284e743dc4a9b86f97d6dd1a3bf = abs((double) $v3a6d0284e743dc4a9b86f97d6dd1a3bf); if ($v3a6d0284e743dc4a9b86f97d6dd1a3bf > 999999999.99) { $v3a6d0284e743dc4a9b86f97d6dd1a3bf = 999999999.99; } $vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, float_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } ++$v2817f701d5e1a1181e657251363295fd; } $this->dbValue = $this->value; if (!$v2817f701d5e1a1181e657251363295fd) { $this->fillNull(); } }
public function addField($vb068931cc450442b63f5b3d276ea4297, $vd5d3db1765287eef77d7927cc956f50a, $v1e3f04102267eaf5e8d0ca424fd5c561, $ve1c6c9ef2fcbe75f26f815c4ef2e60b4 = true, $v1945c9a2a5e2ba6133f1db6757a35fcb = false, $vd5752333adc3a004f826f2ea2a41273a = false) { $this->disableCache(); $vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_object_fields VALUES()"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); return false; } $v3aabf39f2d943fa886d86dcbbee4d910 = l_mysql_insert_id(); $v06e3d36fa30cea095545139854ad1fb9 = new umiField($v3aabf39f2d943fa886d86dcbbee4d910); $v06e3d36fa30cea095545139854ad1fb9->setName($vb068931cc450442b63f5b3d276ea4297); $v06e3d36fa30cea095545139854ad1fb9->setTitle($vd5d3db1765287eef77d7927cc956f50a); if (!$v06e3d36fa30cea095545139854ad1fb9->setFieldTypeId($v1e3f04102267eaf5e8d0ca424fd5c561)) { return false; } $v06e3d36fa30cea095545139854ad1fb9->setIsVisible($ve1c6c9ef2fcbe75f26f815c4ef2e60b4); $v06e3d36fa30cea095545139854ad1fb9->setIsLocked($v1945c9a2a5e2ba6133f1db6757a35fcb); $v06e3d36fa30cea095545139854ad1fb9->setIsInheritable($vd5752333adc3a004f826f2ea2a41273a); if (!$v06e3d36fa30cea095545139854ad1fb9->commit()) { return false; } $this->fields[$v3aabf39f2d943fa886d86dcbbee4d910] = $v06e3d36fa30cea095545139854ad1fb9; return $v3aabf39f2d943fa886d86dcbbee4d910; }
public static function objectsByValue($v0f728ec6147eaec54f5f45e37bce8ddd, $v2ef4385ee1f18f02679161fef2b094d9 = NULL, $v95fc2db4375309c569794b723adc3972 = false, $vf80384e7987156531edaa3afd549957d = true, $v8ef57923ab3049b18fb75541ff476ff7 = NULL) { $v30a7d3f52b5af853f2a7bba352210a34 = array(); if (!(is_null($v2ef4385ee1f18f02679161fef2b094d9) || is_array($v2ef4385ee1f18f02679161fef2b094d9) || intval($v2ef4385ee1f18f02679161fef2b094d9) === -1 || strval($v2ef4385ee1f18f02679161fef2b094d9) === 'all' || strval($v2ef4385ee1f18f02679161fef2b094d9) == 'Все')) { $v2ef4385ee1f18f02679161fef2b094d9 = array($v2ef4385ee1f18f02679161fef2b094d9); } $v9effabcdaed14aab9cb00acddfa00fc9 = NULL; if ($v95fc2db4375309c569794b723adc3972) { if (is_null($v8ef57923ab3049b18fb75541ff476ff7)) { $v9effabcdaed14aab9cb00acddfa00fc9 = array(cmsController::getInstance()->getCurrentDomain()->getId()); } elseif (intval($v8ef57923ab3049b18fb75541ff476ff7) === -1 || strval($v8ef57923ab3049b18fb75541ff476ff7) === 'all' || strval($v8ef57923ab3049b18fb75541ff476ff7) == 'Все') { $v9effabcdaed14aab9cb00acddfa00fc9 = array(); } elseif (is_array($v8ef57923ab3049b18fb75541ff476ff7)) { $v9effabcdaed14aab9cb00acddfa00fc9 = array_map('intval', $v8ef57923ab3049b18fb75541ff476ff7); } else { $v9effabcdaed14aab9cb00acddfa00fc9 = array(intval($v8ef57923ab3049b18fb75541ff476ff7)); } } $v06e3d36fa30cea095545139854ad1fb9 = umiFieldsCollection::getInstance()->getField($v0f728ec6147eaec54f5f45e37bce8ddd); if ($v06e3d36fa30cea095545139854ad1fb9 instanceof umiField) { $v5fd6df40d7c4dd7f503475344d8c145c = $v06e3d36fa30cea095545139854ad1fb9->getFieldType()->getDataType(); $v8ae9391858dfdc11dbd8f15cf9b04a26 = umiFieldType::getDataTypeDB($v5fd6df40d7c4dd7f503475344d8c145c); } else { throw new coreException("Field #{$v945100186b119048837b9859c2c46410} not found"); } $v6301cee35ea764a1e241978f93f01069 = umiSelectionsParser::getObjectTypeByFieldId($v0f728ec6147eaec54f5f45e37bce8ddd); $v80071f37861c360a27b7327e132c911a = umiBranch::getBranchedTableByTypeId($v6301cee35ea764a1e241978f93f01069); $v01b41e749613a642fc384ed8af3245fc = "{$v80071f37861c360a27b7327e132c911a} `o`"; if ($v95fc2db4375309c569794b723adc3972) { $v01b41e749613a642fc384ed8af3245fc .= ", cms3_hierarchy `h`"; } if ($v95fc2db4375309c569794b723adc3972) { $v7dd0d06edf4c4299ce1a5978eb469fd8 = "h.id"; } else { $v7dd0d06edf4c4299ce1a5978eb469fd8 = "o.obj_id"; } $vc3a74cf64b6ccb62fa49a21123cbc72f = $v95fc2db4375309c569794b723adc3972 ? " AND h.obj_id = o.obj_id AND h.is_active=1 AND h.is_deleted=0" : ""; if ($v95fc2db4375309c569794b723adc3972 && is_array($v9effabcdaed14aab9cb00acddfa00fc9) && count($v9effabcdaed14aab9cb00acddfa00fc9)) { $vc3a74cf64b6ccb62fa49a21123cbc72f .= " AND h.domain_id IN ('" . implode("', '", $v9effabcdaed14aab9cb00acddfa00fc9) . "')"; } $v86f6d00b1c7dbb44f4cd5edf49c29aa0 = ""; if (!(intval($v2ef4385ee1f18f02679161fef2b094d9) === -1 || strval($v2ef4385ee1f18f02679161fef2b094d9) === 'all' || strval($v2ef4385ee1f18f02679161fef2b094d9) === 'Âñå')) { $v86f6d00b1c7dbb44f4cd5edf49c29aa0 = " AND o.{$v8ae9391858dfdc11dbd8f15cf9b04a26} " . (is_null($v2ef4385ee1f18f02679161fef2b094d9) ? "IS NULL" : "IN ('" . implode("', '", $v2ef4385ee1f18f02679161fef2b094d9) . "')"); } if ($vf80384e7987156531edaa3afd549957d) { $vf3e7552257b4e44beacffb073506f43d = "SELECT o." . $v8ae9391858dfdc11dbd8f15cf9b04a26 . " as `value`, COUNT(" . $v7dd0d06edf4c4299ce1a5978eb469fd8 . ") as `items` FROM " . $v01b41e749613a642fc384ed8af3245fc . " WHERE o.field_id = " . $v0f728ec6147eaec54f5f45e37bce8ddd . $v86f6d00b1c7dbb44f4cd5edf49c29aa0 . $vc3a74cf64b6ccb62fa49a21123cbc72f . " GROUP BY o." . $v8ae9391858dfdc11dbd8f15cf9b04a26 . " ORDER BY `items`"; } else { $vf3e7552257b4e44beacffb073506f43d = "SELECT DISTINCT " . $v7dd0d06edf4c4299ce1a5978eb469fd8 . " as `item` FROM " . $v01b41e749613a642fc384ed8af3245fc . " WHERE o.field_id = " . $v0f728ec6147eaec54f5f45e37bce8ddd . $v86f6d00b1c7dbb44f4cd5edf49c29aa0 . $vc3a74cf64b6ccb62fa49a21123cbc72f; } $ve7d010371cfd5717d3d0b7d8e4c87803 = array(); $v98291d7af1e21c41194125137e4f90ec = l_mysql_query($vf3e7552257b4e44beacffb073506f43d); $ved05f7aecf3d274bef532a3ade31ad02 = mysql_errno(); $v89d8e64b77430ce4f0fe8ead989285bd = l_mysql_error(); if ($v98291d7af1e21c41194125137e4f90ec === false || $ved05f7aecf3d274bef532a3ade31ad02) { throw new coreException("Error executing db query (errno " . $ved05f7aecf3d274bef532a3ade31ad02 . ", error " . $v89d8e64b77430ce4f0fe8ead989285bd . ", query " . $vf3e7552257b4e44beacffb073506f43d . ")"); } else { while ($v7b93a31f8c7688c32c5a551b0e4937ee = mysql_fetch_assoc($v98291d7af1e21c41194125137e4f90ec)) { $ve7d010371cfd5717d3d0b7d8e4c87803[] = $v7b93a31f8c7688c32c5a551b0e4937ee; } } if ($vf80384e7987156531edaa3afd549957d) { $v30a7d3f52b5af853f2a7bba352210a34['values'] = array(); $vae886317ab0305e3e6a1638659ea03fa = 0; $v663ccf380acaf3f549f1612654dc109d = 0; foreach ($ve7d010371cfd5717d3d0b7d8e4c87803 as $vabd12a9143f26fa85e562e69c01c48db) { $v97023380f9705264978115e6ce880ca5 = intval($vabd12a9143f26fa85e562e69c01c48db['items']); $v30a7d3f52b5af853f2a7bba352210a34['values'][] = array('value' => $vabd12a9143f26fa85e562e69c01c48db['value'], 'cnt' => $v97023380f9705264978115e6ce880ca5); if ($v97023380f9705264978115e6ce880ca5 > $vae886317ab0305e3e6a1638659ea03fa) { $vae886317ab0305e3e6a1638659ea03fa = $v97023380f9705264978115e6ce880ca5; } $v663ccf380acaf3f549f1612654dc109d += $v97023380f9705264978115e6ce880ca5; } $v30a7d3f52b5af853f2a7bba352210a34['max'] = $vae886317ab0305e3e6a1638659ea03fa; $v30a7d3f52b5af853f2a7bba352210a34['sum'] = $v663ccf380acaf3f549f1612654dc109d; } else { foreach ($ve7d010371cfd5717d3d0b7d8e4c87803 as $vabd12a9143f26fa85e562e69c01c48db) { $v30a7d3f52b5af853f2a7bba352210a34[] = $vabd12a9143f26fa85e562e69c01c48db['item']; } } return $v30a7d3f52b5af853f2a7bba352210a34; }
public function moveFieldAfter($v3aabf39f2d943fa886d86dcbbee4d910, $vfcd4b86e12c95a57c24239e8a4125360, $v0e939a4ffd3aacd724dd3b50147b4353, $v3f84b203eef48e9862ac1ffbe344dffe) { if ($vfcd4b86e12c95a57c24239e8a4125360 == 0) { $vf2400bf3c8b70283e04af07d6d67fe6a = 0; } else { $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT ord FROM cms3_fields_controller WHERE group_id = '{$v0e939a4ffd3aacd724dd3b50147b4353}' AND field_id = '{$vfcd4b86e12c95a57c24239e8a4125360}'"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); return false; } else { list($vf2400bf3c8b70283e04af07d6d67fe6a) = mysql_fetch_row($result); } } if ($v3f84b203eef48e9862ac1ffbe344dffe) { $vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_fields_controller SET ord = (ord + 1) WHERE group_id = '{$this->id}' AND ord >= '{$vf2400bf3c8b70283e04af07d6d67fe6a}'"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); return false; } } else { $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT MAX(ord) FROM cms3_fields_controller WHERE group_id = '{$v0e939a4ffd3aacd724dd3b50147b4353}'"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); return false; } list($vf2400bf3c8b70283e04af07d6d67fe6a) = mysql_fetch_row($result); ++$vf2400bf3c8b70283e04af07d6d67fe6a; } $vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_fields_controller SET ord = '{$vf2400bf3c8b70283e04af07d6d67fe6a}', group_id = '{$v0e939a4ffd3aacd724dd3b50147b4353}' WHERE group_id = '{$this->id}' AND field_id = '{$v3aabf39f2d943fa886d86dcbbee4d910}'"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); cacheFrontend::getInstance()->flush(); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); return false; } else { 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; } }
public function setFieldGroupOrd($v0e939a4ffd3aacd724dd3b50147b4353, $vf2400bf3c8b70283e04af07d6d67fe6a, $v3f84b203eef48e9862ac1ffbe344dffe) { $vf2400bf3c8b70283e04af07d6d67fe6a = (int) $vf2400bf3c8b70283e04af07d6d67fe6a; $v0e939a4ffd3aacd724dd3b50147b4353 = (int) $v0e939a4ffd3aacd724dd3b50147b4353; if (!$v3f84b203eef48e9862ac1ffbe344dffe) { $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT type_id FROM cms3_object_field_groups WHERE id = '{$v0e939a4ffd3aacd724dd3b50147b4353}'"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } if (!(list($v94757cae63fd3e398c0811a976dd6bbe) = mysql_fetch_row($result))) { return false; } $vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_object_field_groups SET ord = (ord + 1) WHERE type_id = '{$v94757cae63fd3e398c0811a976dd6bbe}' AND ord >= '{$vf2400bf3c8b70283e04af07d6d67fe6a}'"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } } $vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_object_field_groups SET ord = '{$vf2400bf3c8b70283e04af07d6d67fe6a}' WHERE id = '{$v0e939a4ffd3aacd724dd3b50147b4353}'"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); cacheFrontend::getInstance()->flush(); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } return true; }
public function doQuery($index) { if ($index == 'visitersCount' || $index == 'refusesCount') { $pre = 'SELECT `p`.`id` FROM `cms_stat_paths` `p`'; } else { $pre = 'SELECT `h`.`id` FROM `cms_stat_paths` `p` INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id`'; } if (empty($this->filters)) { $tmp_table = 'tmp_filtered0'; l_mysql_query($qry1 = "DROP TEMPORARY TABLE IF EXISTS `" . $tmp_table . "`"); l_mysql_query($qry2 = "CREATE TEMPORARY TABLE `" . $tmp_table . "` (`id` INT, KEY `id` (`id`)) ENGINE = MEMORY"); l_mysql_query($qry3 = "INSERT INTO `" . $tmp_table . "` " . $pre . " WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . ""); //echo $qry2 . "\r\n" . $qry3; } foreach ($this->filters as $key => $val) { $key = (int) $key; $tmp_table = 'tmp_filtered' . $key; $values = ''; if (is_array($val['value'])) { foreach ($val['value'] as $v) { $values .= "'" . mysql_real_escape_string($v) . "', "; } $values = substr($values, 0, -2); } else { $values = "'" . mysql_real_escape_string($val['value']) . "'"; } l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `" . $tmp_table . "`"); l_mysql_query("CREATE TEMPORARY TABLE `" . $tmp_table . "` (`id` INT, KEY `id` (`id`)) ENGINE = MEMORY"); if ($val['name'] == 'searchEngine') { $qry = 'INSERT INTO `' . $tmp_table . '` ' . $pre . " INNER JOIN `cms_stat_sources` `s` ON `p`.`source_id` = `s`.`id`\r\n INNER JOIN `cms_stat_sources_search` `ss` ON `ss`.`id` = `s`.`concrete_src_id`\r\n INNER JOIN `cms_stat_sources_search_engines` `sse` ON `sse`.`id` = `ss`.`engine_id` " . ($key > 0 ? ' INNER JOIN `tmp_filtered' . ($key - 1) . '` `t` ON `t`.`id` = `p`.`id`' : '') . "WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . " AND `s`.`src_type` = 2 AND `sse`.`name` IN (" . $values . ")"; } elseif ($val['name'] == 'searchQuery') { $qry = 'INSERT INTO `' . $tmp_table . '` ' . $pre . " INNER JOIN `cms_stat_sources` `s` ON `p`.`source_id` = `s`.`id`\r\n INNER JOIN `cms_stat_sources_search` `ss` ON `ss`.`id` = `s`.`concrete_src_id`\r\n INNER JOIN `cms_stat_sources_search_queries` `ssq` ON `ssq`.`id` = `ss`.`text_id` " . ($key > 0 ? ' INNER JOIN `tmp_filtered' . ($key - 1) . '` `t` ON `t`.`id` = `p`.`id`' : '') . "WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . " AND `s`.`src_type` = 2 AND `ssq`.`text` IN (" . $values . ")"; } elseif ($val['name'] == 'linkedSites') { $qry = "INSERT INTO `' . {$tmp_table} . '` " . $pre . " INNER JOIN `cms_stat_sources` `s` ON `p`.`source_id` = `s`.`id`\r\n INNER JOIN `cms_stat_sources_sites` `ss` ON `ss`.`id` = `s`.`concrete_src_id`\r\n INNER JOIN `cms_stat_sources_sites_domains` `ssd` ON `ssd`.`id` = `ss`.`domain`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . " AND `s`.`src_type` = 1 AND `ssd`.`name` IN (" . $values . ")"; } elseif ($val['name'] == 'goals') { $qry = 'INSERT INTO `' . $tmp_table . '` ' . $pre . " INNER JOIN `cms_stat_hits` `h2` ON `h2`.`path_id` = `p`.`id`\r\n INNER JOIN `cms_stat_events_collected` `ec` ON `ec`.`hit_id` = `h2`.`id`\r\n INNER JOIN `cms_stat_events` `e` ON `e`.`id` = `ec`.`event_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . " AND `e`.`name` = (" . $values . ") AND `e`.`type` = 1"; } //echo $qry, '<br>'; l_mysql_query($qry) or die(l_mysql_error()); } //$onerow = false; if ($this->graphType != 'histogramVertical') { if ($index == 'visitersCount') { $qry = "SELECT COUNT(*) AS `cnt`, UNIX_TIMESTAMP(`date`) AS `ts`, DATE_FORMAT(`date`, '%d') AS `day`, DATE_FORMAT(`date`, '%c') AS `month`, DATE_FORMAT(`date`, '%Y') AS `year`, DATE_FORMAT(`date`, '%u') AS `week`, DATE_FORMAT(`date`, '" . $this->getGroupBySign() . "') AS `period`\r\n FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_paths` `p` ON `tmp`.`id` = `p`.`id`\r\n GROUP BY " . $this->calcGroupby() . ", `year`\r\n ORDER BY " . $this->getOrderByField(); } elseif ($index == 'refusesCount') { $qry = "SELECT COUNT(*) AS `cnt`, `ts`, `period` FROM (\r\n SELECT MAX(`number_in_path`) AS `level`, `h`.`day`, `h`.`month`, `h`.`year`, `h`.`week`, UNIX_TIMESTAMP(`h`.`date`) AS `ts`, `h`." . $this->calcGroupby() . " AS `period` FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `tmp`.`id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . "\r\n GROUP BY `tmp`.`id`\r\n HAVING `level` = 1\r\n ) AS `h`\r\n GROUP BY " . $this->calcGroupby() . ", `year`\r\n ORDER BY " . $this->getOrderByField(); } elseif ($index == 'events') { $qry = "SELECT COUNT(*) AS `cnt`, UNIX_TIMESTAMP(`h`.`date`) AS `ts`, `h`." . $this->calcGroupby() . " AS `period` FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`id` = `tmp`.`id`\r\n INNER JOIN `cms_stat_events_collected` `ec` ON `ec`.`hit_id` = `tmp`.`id`\r\n INNER JOIN `cms_stat_events` `e` ON `e`.`id` = `ec`.`event_id`\r\n GROUP BY " . $this->calcGroupby() . ", `year`\r\n ORDER BY " . $this->getOrderByField(); } elseif ($index == 'profit') { $qry = "SELECT SUM(`profit`) AS `cnt`, UNIX_TIMESTAMP(`h`.`date`) AS `ts`, `h`." . $this->calcGroupby() . " AS `period` FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`id` = `tmp`.`id`\r\n INNER JOIN `cms_stat_events_collected` `ec` ON `ec`.`hit_id` = `tmp`.`id`\r\n INNER JOIN `cms_stat_events` `e` ON `e`.`id` = `ec`.`event_id`\r\n GROUP BY " . $this->calcGroupby() . ", `year`\r\n ORDER BY " . $this->getOrderByField(); } else { throw new Exception('Недопустимый параметр'); } } else { if ($index == 'visitersCount') { $qry = "SELECT COUNT(*) AS `cnt`, IF(`count` > 10, IF(`count` > 20, IF(`count` > 30, IF(`count` > 40, IF(`count` > 50, 51, 41), 31), 21), 11), `count`) AS `count`, DATE_FORMAT(`date`, '" . $this->getGroupBySign() . "') AS `period`\r\n FROM\r\n\r\n (SELECT COUNT(*) AS `count`, `date` FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `tmp`.`id`\r\n GROUP BY `user_id`) `x`\r\n\r\n GROUP BY `x`.`count`"; } elseif ($index == 'refusesCount') { $qry = "SELECT COUNT(*) AS `cnt`, IF(`count` > 10, IF(`count` > 20, IF(`count` > 30, IF(`count` > 40, IF(`count` > 50, 51, 41), 31), 21), 11), `count`) AS `count`, DATE_FORMAT(`date`, '" . $this->getGroupBySign() . "') AS `period`\r\n FROM\r\n (\r\n SELECT COUNT(*) AS `count`, `date` FROM\r\n\r\n (\r\n SELECT MAX(`h`.`number_in_path`) AS `level`, `p`.`id`, `p`.`user_id`, `p`.`date` FROM `" . $tmp_table . "` `tmp`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `tmp`.`id`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id`\r\n GROUP BY `p`.`id`\r\n HAVING `level` = 1\r\n ) `inn`\r\n GROUP BY `inn`.`user_id`\r\n ) `out`\r\n GROUP BY `out`.`count`"; } } //var_dump($qry); $res = l_mysql_query($qry); /* if ($onerow) { $result = mysql_fetch_assoc($res); } else {*/ $result = array(); while ($row = mysql_fetch_assoc($res)) { $result[] = $row; } // } return $result; }
protected function mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a) { $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { l_mysql_query("ROLLBACK"); throw new Exception("Query \"{$vac5c74b64b4b8352ef2f181affb5ac2a}\" raised error \"{$v56bd7107802ebe56c6918992f0608ec6}\""); } else { return $result; } }
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); } } }
public function getAllTypes() { static $v0fea6a13c52b4d4725368f24b045ca84 = array(); if (!empty($v0fea6a13c52b4d4725368f24b045ca84)) { return $v0fea6a13c52b4d4725368f24b045ca84; } $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id, name, guid, is_locked, parent_id, is_guidable, is_public, hierarchy_type_id, sortable FROM cms3_object_types"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } $v9b207167e5381c47682c6b4f58a623fb = array(); while ($vf1965a857bc285d26fe22023aa5ab50d = mysql_fetch_assoc($result)) { $vf1965a857bc285d26fe22023aa5ab50d['name'] = $this->translateLabel($vf1965a857bc285d26fe22023aa5ab50d['name']); $v9b207167e5381c47682c6b4f58a623fb[$vf1965a857bc285d26fe22023aa5ab50d['id']] = $vf1965a857bc285d26fe22023aa5ab50d; } $v0fea6a13c52b4d4725368f24b045ca84 = $v9b207167e5381c47682c6b4f58a623fb; return $v9b207167e5381c47682c6b4f58a623fb; }
public function checkSelf() { static $v9b207167e5381c47682c6b4f58a623fb; if ($v9b207167e5381c47682c6b4f58a623fb !== null) { return $v9b207167e5381c47682c6b4f58a623fb; } if (!cacheFrontend::getInstance()->getIsConnected()) { return $v9b207167e5381c47682c6b4f58a623fb = true; } $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT id FROM cms3_objects WHERE id = '{$this->id}'"; $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } $v9b207167e5381c47682c6b4f58a623fb = (bool) mysql_num_rows($result); if (!$v9b207167e5381c47682c6b4f58a623fb) { cacheFrontend::getInstance()->flush(); } return $v9b207167e5381c47682c6b4f58a623fb; }
<?php if (!defined("DB_DRIVER")) { l_mysql_query("SELECT tf FROM cms3_search_index LIMIT 1"); if (l_mysql_error()) { l_mysql_query("TRUNCATE TABLE cms3_search_index"); l_mysql_query("TRUNCATE TABLE cms3_search_index_words"); l_mysql_query("TRUNCATE TABLE cms3_search"); l_mysql_query("ALTER TABLE cms3_search_index ADD tf float default null"); l_mysql_query("ALTER TABLE cms3_search_index ADD INDEX(tf)"); } }
protected function resetObjectProperties($vaf31437ce61345f416579830a98c91e5) { $vaf31437ce61345f416579830a98c91e5 = (int) $vaf31437ce61345f416579830a98c91e5; $va8cfde6331bd59eb2ac96f8911c4b666 = $this->getObject($vaf31437ce61345f416579830a98c91e5); $v87306dd4235ed712ebc07fe169b76f83 = $va8cfde6331bd59eb2ac96f8911c4b666->getTypeId(); $v7ae7003da59ae71dcc9f8638ef50593d = umiObjectTypesCollection::getInstance()->getType($v87306dd4235ed712ebc07fe169b76f83); $v80071f37861c360a27b7327e132c911a = umiBranch::getBranchedTableByTypeId($v87306dd4235ed712ebc07fe169b76f83); $v1b1cc7f086b3f074da452bc3129981eb = "INSERT INTO {$v80071f37861c360a27b7327e132c911a} (obj_id, field_id, int_val, varchar_val, text_val, rel_val, tree_val, float_val) VALUES "; $v37c0c66b0de38f0adb05826f136d75f7 = $v7ae7003da59ae71dcc9f8638ef50593d->getAllFields(); $vb2021c4149dfd5dc85c88823b7df34bd = array(); foreach ($v37c0c66b0de38f0adb05826f136d75f7 as $vb8b49ef6bc7c1cfa510520b8a17b9f69) { $vb2021c4149dfd5dc85c88823b7df34bd[] = "('{$vaf31437ce61345f416579830a98c91e5}', '{$vb8b49ef6bc7c1cfa510520b8a17b9f69->getId()}', NULL, NULL, NULL, NULL, NULL, NULL)"; } if (sizeof($v37c0c66b0de38f0adb05826f136d75f7) != 0) { l_mysql_query($v1b1cc7f086b3f074da452bc3129981eb . implode($vb2021c4149dfd5dc85c88823b7df34bd, ", ")); } else { $vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$v80071f37861c360a27b7327e132c911a} (obj_id, field_id) VALUES ('{$vaf31437ce61345f416579830a98c91e5}', NULL)"; l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a); if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) { throw new coreException($v56bd7107802ebe56c6918992f0608ec6); } } }