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