function ProcessRequest($server_cfg, $game_cfg) { $columns = $_GET["columns"]; //echo $columns; $wrapped_column_names = wrap_escape(explode(",", $columns), "`"); //print_r($wrapped_column_names); $query = $_GET["query"]; $xhprofModelObject = new XhProfModel($server_cfg, $game_cfg); date_default_timezone_set('UTC'); $end_time = time(); $start_time = $end_time - 12 * 7 * 24 * 60 * 60; # 12 weeks ago $implode_columns = implode(",", $wrapped_column_names); if (!$query || $query == "cto_get_top_pages_avg_load_time") { $chart_result = $xhprofModelObject->generic_execute_get_query_detail($query, array('table' => "apache_stats_flip_avg", 'end_time' => $end_time, 'start_time' => $start_time, 'columns' => $implode_columns)); } else { if ($query == "cto_get_tracked_functions_by_column") { $page = $_GET['page']; $chart_result = $xhprofModelObject->generic_execute_get_query_detail($query, array('table' => "tracked_functions_flip_incl_time", 'end_time' => $end_time, 'start_time' => $start_time, 'page' => $page, 'columns' => $implode_columns)); } else { echo json_encode("Illegal Query!"); return; } } $tags = $xhprofModelObject->generic_execute_get_query("get_tag_range", array('table' => "events", 'end_time' => $end_time, 'start_time' => $start_time, 'extra_params' => "")); $chart_result["tags"] = $tags; echo json_encode($chart_result); }
function ProcessRequest($server_cfg, $game_cfg, $params) { $query = $_GET["query"]; if (!$query) { $query = 'eu_web_chart_range'; } if (!$query) { return json_encode("Illegal query."); } $xhprofModelObject = new XhProfModel($server_cfg, $game_cfg); date_default_timezone_set('UTC'); $end_time = time(); $start_time = time() - 12 * 7 * 24 * 60 * 60; # 12 weeks ago $chart_result = $xhprofModelObject->generic_execute_get_query_detail($query, array('table' => "vertica_stats_30min", 'end_time' => $end_time, 'start_time' => $start_time, 'prefix' => str_replace("-", "_", $params['hostgroup']))); $tags = $xhprofModelObject->generic_execute_get_query("get_tag_range", array('table' => "events", 'end_time' => $end_time, 'start_time' => $start_time, 'extra_params' => "")); $chart_result["tags"] = $tags; echo json_encode($chart_result); }
function ProcessRequest($server_cfg, $game_cfg) { $query = $_GET["query"]; if (!$query) { $query = 'bd_chart_range'; } if (!$query) { return json_encode("Illegal query."); } $xhprofModelObject = new XhProfModel($server_cfg, $game_cfg); date_default_timezone_set('UTC'); $end_time = time(); $start_time = $end_time - 12 * 7 * 24 * 60 * 60; # 12 weeks ago $chart_result = $xhprofModelObject->generic_execute_get_query_detail($query, array('table' => $game_cfg["db_stats_table"], 'end_time' => $end_time, 'start_time' => $start_time, 'extra_params' => "")); $tags = $xhprofModelObject->generic_execute_get_query("get_tag_range", array('table' => "events", 'end_time' => $end_time, 'start_time' => $start_time, 'extra_params' => "")); $chart_result["tags"] = $tags; echo json_encode($chart_result); }
# http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # require_once 'setup_page.php'; include_once 'XhProfModel.php'; include_once 'spyc.php'; include_once 'yml_conf.inc.php'; include_once 'game_config.php'; include_once 'server.cfg'; $xhProfModelObject = new XhProfModel($server_cfg, $game_cfg); $result = $xhProfModelObject->generic_execute_get_query_detail('get_last_event', null); $type = (string) $result['rows'][0][0]; $text = (string) $result['rows'][0][1]; # $event = "$type:$text"; $event = "{$text}"; $event = str_replace('"', '', $event); if (!isset($arrayid)) { $arrayid = 'all'; } ?> <html> <head> <title> Administrator </title> <link rel="stylesheet" href="/zperfmon/css/jquery.autocomplete.css" /> <script src="/zperfmon/js/jquery-1.5.2.min.js"></script>