当前位置: 首页>>代码示例>>PHP>>正文


PHP l_mysql_query函数代码示例

本文整理汇总了PHP中l_mysql_query函数的典型用法代码示例。如果您正苦于以下问题:PHP l_mysql_query函数的具体用法?PHP l_mysql_query怎么用?PHP l_mysql_query使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了l_mysql_query函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: loadValue

 protected function loadValue()
 {
     $v9b207167e5381c47682c6b4f58a623fb = array();
     $v3aabf39f2d943fa886d86dcbbee4d910 = $this->field_id;
     if ($v8d777f385d3dfec8815d20f7496026dc = $this->getPropData()) {
         foreach ($v8d777f385d3dfec8815d20f7496026dc['text_val'] as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
             if (is_null($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
                 continue;
             }
             if (str_replace(" ", "", trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) == "") {
                 continue;
             }
             $v9b207167e5381c47682c6b4f58a623fb[] = self::filterOutputString((string) $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
         }
         return $v9b207167e5381c47682c6b4f58a623fb;
     }
     $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT text_val FROM {$this->tableName} WHERE obj_id = '{$this->object_id}' AND field_id = '{$v3aabf39f2d943fa886d86dcbbee4d910}' LIMIT 1";
     $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
     while (list($v3a6d0284e743dc4a9b86f97d6dd1a3bf) = mysql_fetch_row($result)) {
         if (is_null($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
             continue;
         }
         if (str_replace(" ", "", trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) == "") {
             continue;
         }
         $v9b207167e5381c47682c6b4f58a623fb[] = self::filterOutputString((string) $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
     }
     return $v9b207167e5381c47682c6b4f58a623fb;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:29,代码来源:umiObjectPropertyWYSIWYG.php

示例2: save

 protected function save()
 {
     $v67b3dba8bc6778101892eb77249db32e = self::filterInputString($this->host);
     $vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_domain_mirrows SET host = '{$v67b3dba8bc6778101892eb77249db32e}' WHERE id = '{$this->id}'";
     $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
     return true;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:7,代码来源:domainMirrow.php

示例3: get

 /**
  * Метод получения отчёта
  *
  * @return array
  */
 public function get()
 {
     $sHostSQL = $this->getHostSQL("p");
     l_mysql_query("SET @all = (SELECT COUNT(*) AS `cnt` FROM `cms_stat_paths` `p`\r\n                      WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $sHostSQL . ")");
     $result['detail'] = $this->simpleQuery("(SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'sites' AS `type`, `d`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                 INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                  INNER JOIN `cms_stat_sources_sites` `ss` ON `s`.`concrete_src_id` = `ss`.`id`\r\n                                                   INNER JOIN `cms_stat_sources_sites_domains` `d` ON `d`.`id` = `ss`.`domain`\r\n                                                    WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQLd . " AND `s`.`src_type` = 1\r\n                                                     GROUP BY `d`.`id`)\r\n\r\n                                                     UNION\r\n                                                (\r\n                                                SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'search' AS `type`, `sse`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                 INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_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`\r\n                                                    WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 2\r\n                                                     GROUP BY `sse`.`id`)\r\n\r\n                                                     UNION\r\n                                                (\r\n                                                SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'pr' AS `type`, `pr`.`name` AS `name`  FROM `cms_stat_paths` `p`\r\n                                                 INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                  INNER JOIN `cms_stat_sources_pr` `pr` ON `pr`.`id` = `s`.`concrete_src_id`\r\n                                                   WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 3\r\n                                                    GROUP BY `pr`.`id`)\r\n\r\n                                                    UNION\r\n                                                (\r\n                                                SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'ticket' AS `type`, `t`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                 INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                  INNER JOIN `cms_stat_sources_ticket` `t` ON `t`.`id` = `s`.`concrete_src_id`\r\n                                                   WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 4\r\n                                                    GROUP BY `t`.`id`)\r\n\r\n                                                    UNION\r\n                                                (\r\n                                                SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'coupon' AS `type`, `c`.`descript` AS `name` FROM `cms_stat_paths` `p`\r\n                                                 INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                  INNER JOIN `cms_stat_sources_coupon` `c` ON `c`.`id` = `s`.`concrete_src_id`\r\n                                                   WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 5\r\n                                                    GROUP BY `c`.`id`)\r\n\r\n                                                    UNION\r\n                                                (\r\n                                                SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'direct' AS `type`, 'direct' AS `name` FROM `cms_stat_paths` `p`\r\n                                                   WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `p`.`source_id` = 0)\r\n\r\n                                                ORDER BY `cnt` DESC\r\n                                                 LIMIT " . $this->offset . ", " . $this->limit);
     $result['segments'] = $this->simpleQuery("SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `cnt`, `type` FROM (\r\n                                                    (SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'sites' AS `type`, `d`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                     INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                      INNER JOIN `cms_stat_sources_sites` `ss` ON `s`.`concrete_src_id` = `ss`.`id`\r\n                                                       INNER JOIN `cms_stat_sources_sites_domains` `d` ON `d`.`id` = `ss`.`domain`\r\n                                                        WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 1\r\n                                                         GROUP BY `d`.`id`)\r\n\r\n                                                         UNION\r\n                                                    (\r\n                                                    SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'search' AS `type`, `sse`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                     INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_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`\r\n                                                        WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . "  " . $sHostSQL . " AND `s`.`src_type` = 2\r\n                                                         GROUP BY `sse`.`id`)\r\n\r\n                                                         UNION\r\n                                                    (\r\n                                                    SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'pr' AS `type`, `pr`.`name` AS `name`  FROM `cms_stat_paths` `p`\r\n                                                     INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                      INNER JOIN `cms_stat_sources_pr` `pr` ON `pr`.`id` = `s`.`concrete_src_id`\r\n                                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 3\r\n                                                        GROUP BY `pr`.`id`)\r\n\r\n                                                        UNION\r\n                                                    (\r\n                                                    SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'ticket' AS `type`, `t`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n                                                     INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                      INNER JOIN `cms_stat_sources_ticket` `t` ON `t`.`id` = `s`.`concrete_src_id`\r\n                                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 4\r\n                                                        GROUP BY `t`.`id`)\r\n\r\n                                                        UNION\r\n                                                    (\r\n                                                    SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'coupon' AS `type`, `c`.`descript` AS `name` FROM `cms_stat_paths` `p`\r\n                                                     INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n                                                      INNER JOIN `cms_stat_sources_coupon` `c` ON `c`.`id` = `s`.`concrete_src_id`\r\n                                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . "  " . $sHostSQL . " AND `s`.`src_type` = 5\r\n                                                        GROUP BY `c`.`id`)\r\n\r\n                                                        UNION\r\n                                                    (\r\n                                                    SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'direct' AS `type`, 'direct' AS `name` FROM `cms_stat_paths` `p`\r\n                                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . "  " . $sHostSQL . " AND `p`.`source_id` = 0)\r\n                                                    ) `tmp`\r\n                                                    GROUP BY `tmp`.`type`\r\n                                                     ORDER BY `cnt` DESC\r\n                                                      LIMIT " . $this->offset . ", " . $this->limit);
     /*
     l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_pages_refuse`");
     l_mysql_query("CREATE TEMPORARY TABLE `tmp_pages_refuse` (`path_id` INT, `level` INT, KEY `path_id_level` (`path_id`, `level`)) ENGINE = MEMORY");
     
     l_mysql_query("INSERT INTO `tmp_pages_refuse` SELECT `path_id`, MAX(`number_in_path`) AS `mnum` FROM `cms_stat_hits` `h`
     INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`
     WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `p`.`host_id` = " . $this->host_id . "
     GROUP BY `path_id`
     HAVING `mnum` = 1");
     l_mysql_query("SET @all_refuses = (SELECT COUNT(*) FROM tmp_pages_refuse)");
     
     l_mysql_query("SET @all_visits = (SELECT COUNT(*) FROM `cms_stat_paths` `p`
     WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " AND `p`.`host_id` = " . $this->host_id . " )");
     
     return $this->simpleQuery("SELECT COUNT(DISTINCT(`h`.`path_id`)) AS `refuse`, COUNT(*) AS `entry`, COUNT(DISTINCT(`h`.`path_id`)) / COUNT(*) * 100 AS `refuse_percent`, COUNT(DISTINCT(`h`.`path_id`)) / @all_refuses * 100 AS `all_refuses_percent`, COUNT(DISTINCT(`h`.`path_id`)) /  @all_visits * 100 AS `traffic_lost`, `p`.`uri`, `p`.`id` FROM `tmp_pages_refuse` `t`
     INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `t`.`path_id` AND `h`.`number_in_path` = `t`.`level`
     INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`
     INNER JOIN `cms_stat_hits` `h2` ON `h2`.`page_id` = `p`.`id` AND `h2`.`number_in_path` = 1
     WHERE `p`.`host_id` = " . $this->host_id . "
     GROUP BY `h`.`page_id`
     LIMIT 10");
     */
     return $result;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:35,代码来源:sourcesSummary.php

示例4: saveValue

 protected function saveValue()
 {
     $this->deleteCurrentRows();
     if (sizeof($this->value) == 1) {
         $v2063c1608d6e0baf80249c42e2be5804 = trim($this->value[0], ",");
         $v2063c1608d6e0baf80249c42e2be5804 = preg_replace("/[^A-Za-z0-9А-Яа-яЁё'\\-\$%_,\\s]/u", "", $v2063c1608d6e0baf80249c42e2be5804);
         $v2063c1608d6e0baf80249c42e2be5804 = explode(",", $v2063c1608d6e0baf80249c42e2be5804);
     } else {
         $v2063c1608d6e0baf80249c42e2be5804 = array_map(create_function('$a', " return preg_replace(\"/[^A-Za-z0-9А-Яа-яЁё'\\-\\\$%_,\\s]?/u\", \"\", \$a); "), $this->value);
     }
     $v2817f701d5e1a1181e657251363295fd = 0;
     foreach ($v2063c1608d6e0baf80249c42e2be5804 as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
         $v3a6d0284e743dc4a9b86f97d6dd1a3bf = trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
         if (strlen($v3a6d0284e743dc4a9b86f97d6dd1a3bf) == 0) {
             continue;
         }
         $v3a6d0284e743dc4a9b86f97d6dd1a3bf = self::filterInputString($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
         $vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, varchar_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')";
         l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
         ++$v2817f701d5e1a1181e657251363295fd;
     }
     if (!$v2817f701d5e1a1181e657251363295fd) {
         $this->fillNull();
     }
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:25,代码来源:umiObjectPropertyTags.php

示例5: getDetail

 private function getDetail()
 {
     l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_visit_time`");
     l_mysql_query("CREATE TEMPORARY TABLE `tmp_visit_time` (`mins` FLOAT) ENGINE = MEMORY");
     l_mysql_query("INSERT INTO `tmp_visit_time` SELECT (UNIX_TIMESTAMP(MAX(`h`.`date`)) - UNIX_TIMESTAMP(MIN(`h`.`date`))) / 60 AS `minutes` FROM `cms_stat_hits` `h`\r\n                        INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n                         WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " \r\n                          GROUP BY `h`.`path_id`");
     return $this->simpleQuery("SELECT COUNT(*) AS `cnt`, IF(`mins` > 10, IF(`mins` > 20, IF(`mins` > 30, IF(`mins` > 40, IF(`mins` > 50, 51, 41), 31), 21), 11), ROUND(`mins`)) `minutes`\r\n                                     FROM `tmp_visit_time`\r\n                                      GROUP BY `minutes` ORDER BY `cnt` DESC");
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:7,代码来源:visitTime.php

示例6: addField

 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;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:25,代码来源:umiFieldsCollection.php

示例7: saveValue

 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();
     }
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:28,代码来源:umiObjectPropertyImgFile.php

示例8: get

    public function get()
    {
	$sQr = "SET @cnt := (SELECT COUNT(*) FROM `cms_stat_sources_openstat` `os`
                                     INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ")";

        l_mysql_query($sQr);

	$result = $this->simpleQuery("SELECT COUNT(*) AS `total` FROM `cms_stat_sources_openstat` `os`
                                     INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                      INNER JOIN `cms_stat_sources_openstat_source` `s` ON `s`.`id` = `os`.`source_id`
                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p'));
        $i_total = (int) $result[0]['total'];

	$sQr = "SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @cnt * 100 AS `rel`, `s`.`name` AS 'name', `s`.`id` AS `source_id` FROM `cms_stat_sources_openstat` `os`
                                     INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                      INNER JOIN `cms_stat_sources_openstat_source` `s` ON `s`.`id` = `os`.`source_id`
                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "
                                        GROUP BY `s`.`id`
                                         ORDER BY `abs` DESC
                                          LIMIT " . $this->offset . ", " . $this->limit;

        $res = $this->simpleQuery($sQr, true);

	return array("all"=>$res['result'], "summ"=>$i_total, "total"=>$res['FOUND_ROWS']);
    }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:26,代码来源:openstatSources.php

示例9: loadTypes

 private function loadTypes()
 {
     $vb99eb979e6f6efabc396f777b503f7e7 = cacheFrontend::getInstance();
     $vda80b9ab86c2d00b85de0cf003cb3e6e = $vb99eb979e6f6efabc396f777b503f7e7->loadData('hierarchy_types');
     if (!is_array($vda80b9ab86c2d00b85de0cf003cb3e6e)) {
         $vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT  `id`, `name`, `title`, `ext` FROM `cms3_hierarchy_types` ORDER BY `name`, `ext`";
         $result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
         $vda80b9ab86c2d00b85de0cf003cb3e6e = array();
         while (list($vb80bb7740288fda1f201890375a60c8f) = $vf1965a857bc285d26fe22023aa5ab50d = mysql_fetch_row($result)) {
             $vda80b9ab86c2d00b85de0cf003cb3e6e[$vb80bb7740288fda1f201890375a60c8f] = $vf1965a857bc285d26fe22023aa5ab50d;
         }
         $vb99eb979e6f6efabc396f777b503f7e7->saveData('hierarchy_types', $vda80b9ab86c2d00b85de0cf003cb3e6e, 3600);
     }
     foreach ($vda80b9ab86c2d00b85de0cf003cb3e6e as $vb80bb7740288fda1f201890375a60c8f => $vf1965a857bc285d26fe22023aa5ab50d) {
         $v599dcce2998a6b40b1e38e8c6006cb0a = $vb99eb979e6f6efabc396f777b503f7e7->load($vb80bb7740288fda1f201890375a60c8f, 'element_type');
         if ($v599dcce2998a6b40b1e38e8c6006cb0a instanceof iUmiHierarchyType == false) {
             try {
                 $v599dcce2998a6b40b1e38e8c6006cb0a = new umiHierarchyType($vb80bb7740288fda1f201890375a60c8f, $vf1965a857bc285d26fe22023aa5ab50d);
             } catch (privateException $ve1671797c52e15f763380b45e841ec32) {
                 continue;
             }
             $vb99eb979e6f6efabc396f777b503f7e7->save($v599dcce2998a6b40b1e38e8c6006cb0a, 'element_type');
         }
         $this->types[$vb80bb7740288fda1f201890375a60c8f] = $v599dcce2998a6b40b1e38e8c6006cb0a;
     }
     return true;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:27,代码来源:umiHierarchyTypesCollection.php

示例10: getPath

    public function getPath()
    {
        $path = explode('/', $this->params['path']);
        $str = '';
        foreach ($path as $val) {
            $str .= (int)$val . ', ';
        }
        $str = substr($str, 0, -2);
        $qry = "SELECT `id`, `uri` FROM `cms_stat_pages` WHERE `id` IN (" . $str . ")";
        $res = l_mysql_query($qry);

        $result = array();
        while ($row = mysql_fetch_assoc($res)) {
            $result[$row['id']] = $row['uri'];
        }

        reset($path);

        $return = array();
        foreach ($path as $val) {
            if (isset($result[$val])) {
                $return[] = $result[$val];
            }
        }

        return $return;
    }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:27,代码来源:paths.php

示例11: getDynamic

 public function getDynamic()
 {
     l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_activity`");
     l_mysql_query("CREATE TEMPORARY TABLE `tmp_activity` (`days` INT, `" . $this->groupby . "` INT, `year` INT, `date` DATETIME) ENGINE = MEMORY");
     l_mysql_query("INSERT INTO `tmp_activity` SELECT FLOOR( ( UNIX_TIMESTAMP(MAX(`date`)) - UNIX_TIMESTAMP(MIN(`date`)) ) / (COUNT(*) - 1) / 3600 / 24 ) AS `days`, DATE_FORMAT(`date`, '%" . $this->groupby_key . "') AS `" . $this->groupby . "`, DATE_FORMAT(`date`, '%Y') AS `year`, `date` FROM `cms_stat_paths`\r\n                     WHERE `date` BETWEEN '" . $this->formatDate($this->start) . "' AND '" . $this->formatDate($this->finish) . "' " . $this->getHostSQL() . $this->getUserFilterWhere() . "\r\n                      GROUP BY `user_id`");
     return $this->simpleQuery("SELECT AVG(`days`) AS `avg`, `" . $this->groupby . "` AS `period`, UNIX_TIMESTAMP(`date`) AS `ts` FROM `tmp_activity`\r\n                                     GROUP BY `" . $this->groupby . "`, `year` ORDER BY `date`");
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:7,代码来源:auditoryActivity.php

示例12: saveBranchedTablesRelations

 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;
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:33,代码来源:umiBranch.php

示例13: get

    public function get()
    {
        $cond = array();
        foreach (array('source_id', 'campaign_id') as $val) {
            if ((int)$this->params[$val] > 0) {
                $cond[] = '`os`.`' . $val . '` = ' . (int)$this->params[$val];
            }
        }
        $cond_str = '';
        if (sizeof($cond)) {
            $cond_str = ' AND ' . implode(' AND ', $cond);
        }

        l_mysql_query("SET @cnt := (SELECT COUNT(*) FROM `cms_stat_sources_openstat` `os`
                                     INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                       WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str . ")");

	$result = $this->simpleQuery("SELECT COUNT(*) AS `abs` FROM `cms_stat_sources_openstat` `os`
                                    INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                     INNER JOIN `cms_stat_sources_openstat_service` `s` ON `s`.`id` = `os`.`service_id`
                                      WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . "  " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str);
        $i_total = (isset($result[0]['total'])) ? (int) $result[0]['total'] : 0;

        $res = $this->simpleQuery("SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @cnt * 100 AS `rel`, `s`.`name`, `s`.`id` AS 'service_id' FROM `cms_stat_sources_openstat` `os`
                                    INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
                                     INNER JOIN `cms_stat_sources_openstat_service` `s` ON `s`.`id` = `os`.`service_id`
                                      WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str . "
                                       GROUP BY `s`.`id`
                                        ORDER BY `abs` DESC
                                         LIMIT " . $this->offset . ", " . $this->limit, true);

	return array("all"=>$res['result'], "summ"=>$i_total, "total"=>$res['FOUND_ROWS']);
    }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:33,代码来源:openstatServices.php

示例14: getAvg

    /**
     * метод получения почасовой информации за выходные и будни
     *
     * @return array
     */
    private function getAvg()
    {
        $this->setUpVars();

        $qry = "(SELECT 'routine' AS `type`, COUNT(*) / " . $this->routine_count . ".0 AS `avg`, `h`.`hour` FROM `cms_stat_paths` `p`
                 INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1
                  INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`
                   INNER JOIN `cms_stat_sources_sites` `ss` ON `ss`.`id` = `s`.`concrete_src_id`
                    LEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`
                     WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " AND `s`.`src_type` = 1
                      AND `day_of_week` BETWEEN 1 AND 5 AND `holidays`.`id` IS NULL
                       GROUP BY `h`.`hour`)
                UNION
                (SELECT 'weekend' AS `type`, COUNT(*) / " . $this->holidays_count . ".0 AS `avg`, `h`.`hour` FROM `cms_stat_paths` `p`
                 INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1
                  INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`
                   INNER JOIN `cms_stat_sources_sites` `ss` ON `ss`.`id` = `s`.`concrete_src_id`
                    LEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`
                     WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " AND `s`.`src_type` = 1
                      AND (`day_of_week` NOT BETWEEN 1 AND 5 OR `holidays`.`id` IS NOT NULL)
                       GROUP BY `h`.`hour`)";

        $res = l_mysql_query($qry);

        $result = array();

        while ($row = mysql_fetch_assoc($res)) {
            $result[$row['type']][$row['hour']] = $row['avg'];

        }

        return $result;
    }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:38,代码来源:hostsCommonHours.php

示例15: saveValue

 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();
     }
 }
开发者ID:BGCX261,项目名称:zimmerli-svn-to-git,代码行数:27,代码来源:umiObjectPropertyPrice.php


注:本文中的l_mysql_query函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。