function insert_rightscale_data($server_cfg, $game_cfg, $time_slots = '*') { // TODO take the names from config and expand table as and when new machine class is added to config $machine_class_default = array('web_count' => 0, 'mb_count' => 0, 'mc_count' => 0, 'db_count' => 0, 'queue_count' => 0, 'proxy_count' => 0, 'admin_count' => 0); $game_name = $game_cfg["name"]; $table = $game_cfg['db_stats_table']; $gid = $game_cfg['gameid']; // to query for the dau_5min table and to insert into stats_30min; $snid = $game_cfg['snid'] ? $game_cfg['snid'] : null; $cid = $game_cfg['cid'] ? $game_cfg['cid'] : null; $deploy_array = $game_cfg['deployIDs']; $deploy_id = $deploy_array[0]; // // get the max value of the supplied timeslots // expects that time_slots are given as follows // {ts1,ts2} // preg_match("/\\{(.*)\\}/", $time_slots, $m); $timeslot = max(explode(",", $m[1])); if (empty($timeslot)) { $game_cfg['logger']->log("insert_bd_metric", "null is given as timeslot", Logger::ERR); error_log("null is given as timeslots", 3, sprintf($server_cfg['log_file'], $game_cfg['name'])); return; } $timestamp = $timeslot * 1800; $dauObj = new DAUAdapter(); $dau = $dauObj->get_timed_dau($timestamp, $gid, $snid, $cid); $rsObj = new RightScale($server_cfg, $game_cfg); $web_count = null; if (isset($game_cfg['id'])) { $web_count = $rsObj->get_host_count_per_pool($game_cfg['id'], $deploy_id); $game_name = $game_cfg['parent']; // to query other machine counts } $machine_counts = $rsObj->get_host_count_per_class($deploy_id, $game_name); $counts_array = get_counts($machine_class_default, $machine_counts, $web_count); $query = create_query($table, $timestamp, $dau, $counts_array, $gid); $queries = array($query); $query_res = execute_queries($server_cfg, $game_cfg, $queries); if ($query_res == 0) { $game_cfg['logger']->log("insert_bd_metrics", "bd_metrics metrics for " . $game_cfg['name'] . " successfully inserted", Logger::INFO); error_log("bd_metrics metrics for {$game_cfg['name']} successfully inserted", 3, sprintf($server_cfg['log_file'], $game_cfg['name'])); } else { $game_cfg['logger']->log("insert_bd_metrics", "bd_metrics metrics for " . $game_cfg['name'] . " not inserted", Logger::ERR); error_log("bd_metrics metrics for {$game_cfg['name']} successfully inserted", 3, sprintf($server_cfg['log_file'], $game_cfg['name'])); } }
// Get the selected panel ID, or use events and narratives if none is specified and // we're not filtering on a specific post. In that situation, we want all content types. if ($_GET['panelId']) { $panel_ids[] = $_GET['panelId']; } else { if (!$filtered_by_post_id) { $panel_ids[] = array_search('Events', $write_panels); $panel_ids[] = array_search('Narratives', $write_panels); } } $jump_to_id = $_GET['jumpTo']; $has_more = false; $query_args = array('cat_id' => $category_id, 'panel_id' => $panel_ids, 'linked_post_id' => $_GET['linkedPostId'], 'importance' => $_GET['importance'], 'chronological' => $_GET['order']); // If there's an ID we want to jump to, we return all query results and loop through // them. Otherwise, we just return one page worth of results. $pageposts = $wpdb->get_results(create_query($query_args, $jump_to_id ? null : 0)); if ($pageposts) { $foundJumpToPost = !isset($jump_to_id); $result_count = POSTS_PER_PAGE; foreach ($pageposts as $post) { if ($result_count == 0) { if ($foundJumpToPost) { // We've shown this page of results but we still have more in $pageposts. $has_more = true; break; } else { // We've finished showing a page but haven't found our jump-to post yet. // Display another page. $result_count = POSTS_PER_PAGE; } }
foreach (glob("../{$key}/sql/*.zip") as $filename) { $zip = new ZipArchive(); //var_dump($zip); //if ($zip->open("../$key/sql/taxons.zip") === TRUE) { if ($zip->open("{$filename}") === TRUE) { $zip->extractTo("../{$key}/sql/"); $zip->close(); //echo 'ok <br>'; } else { // echo 'échec <br>'; } //echo "$filename <br>"; } /*creation du schema de la rubrique $key et du squelette de ses tables*/ $archi = "../{$key}/sql/archi.sql"; $query = create_query($archi, $user_codex); $result = pg_query($conn_codex, $query); /*import des données en base à partir des fichiers sql (sauf fichier archi.sql)*/ $query = ""; foreach (glob("../{$key}/sql/*.sql") as $filename) { if (strpos($filename, 'archi') === false) { //$query .= create_query($data,$user_codex); //cette requête faisait planter l'installation car remplacer sur un fichier trop lourd est gourmand en mémoire $query .= file_get_contents($filename); //pour tous les fichiers .sql sauf archi.sql } } /*import des données en base à partir des fichiers .csv avec COPY FROM*/ //on peut tester si on est sous windows ou linux pour respecter slash et antislash mais a priori avec realpath ça fonctionne set_time_limit(0); foreach (glob("../{$key}/sql/*.csv") as $filename) { //renvoit le chemin relatif des fichiers csv du dossier
// Check if this page is being filtered by a linked post id. // This will change the behavior of some parts (e.g. don't get linked content) $filtered_by_post_id = isset($_GET['linkedPostId']); // Get the selected panel ID, or use events and narratives if none is specified and // we're not filtering on a specific post. In that situation, we want all content types. if ($_GET['panelId']) { $panel_ids[] = $_GET['panelId']; } else { if (!$filtered_by_post_id) { $panel_ids[] = array_search('Events', $write_panels); $panel_ids[] = array_search('Narratives', $write_panels); } } $has_more = false; $query_args = array('cat_id' => $_GET['cat'], 'panel_id' => $panel_ids, 'linked_post_id' => $_GET['linkedPostId'], 'importance' => $_GET['importance'], 'chronological' => $_GET['order']); $pageposts = $wpdb->get_results(create_query($query_args, $_GET['page'])); if ($pageposts) { // If we don't specify a page, we want to return everything. $result_count = $_GET['page'] ? POSTS_PER_PAGE : -1; foreach ($pageposts as $post) { if ($result_count == 0) { $has_more = true; break; } setup_postdata($post); $content_items[] = create_content_item($all_linked_items); $result_count--; } } // Then get all the linked elements. We need to explicitly check // if $all_linked_items is empty; query_posts doesn't do the right
$m_axes->y_axis = $y_axis; //End: Y-axis set up. //X-axis set up. $p1 = new stdClass(); $p2 = new stdClass(); $p1->value = 'time'; $p1->text = 'Time'; $p2->value = 'tap'; $p2->text = 'Tap'; $field = 'time'; $param = array($p1, $p2); $x_axis->field = $field; $x_axis->param = $param; $x_axis->round_factor = null; $m_axes->x_axis = $x_axis; //End: X-axis set up. //Main filter set up. $filter_main->year_min = '15'; $filter_main->date_min = '12/1/2015'; $filter_main->date_max = null; $filter_main->tap_grade = null; $m_axes->filter_main = $filter_main; //End: Main filter set up. $query = create_query($m_axes); echo nl2br(spaceToNbsp($query)); ?> </div> </html>
$result = pg_query($conn_appli, "SELECT 1 FROM pg_roles WHERE rolname='{$user_appli}';"); $user_test = pg_fetch_row($result); if ($user_test[0] == null) { $result = pg_query($conn_appli, "CREATE USER {$user_appli} PASSWORD '{$pass_appli}';"); echo "L'utilisateur {$user_appli} a été créé<BR>"; } else { echo "L'utilisateur {$user_appli} existait déjà<BR>"; } /*-------------------*/ /*Structure de la BDD*/ $result = pg_query($conn_appli, "SELECT 1 FROM information_schema.tables WHERE table_name='carte_indigenat';"); $table = pg_fetch_row($result); if ($table[0] == null) { $conn_user = connexion($host, $port, $user_appli, $pass_appli, $bdd); $archi = "./sql/archi_prod_carte.sql"; $query = create_query($archi, $user_appli); $result = pg_query($conn_user, $query); echo "L'architecture de la base a été implémentée<BR>"; } else { echo "L'architecture de la base existait déjà<BR>"; } /*------------------------------------------*/ /*parametrage du ficher de conf sql_connect*/ if (!file_exists("./_INCLUDE/.sql_config.inc.php")) { $sql_file = file_get_contents("./_INCLUDE/.sql_config.inc.example.php"); $sql_file = str_replace("localhost", $_POST["host"], $sql_file); $sql_file = str_replace("5432", $_POST["port"], $sql_file); $sql_file = str_replace("user_prod", $_POST["user_appli"], $sql_file); $sql_file = str_replace("pass_prod", $_POST["pass_appli"], $sql_file); $sql_file = str_replace("postgres", $_POST["user"], $sql_file); $sql_file = str_replace("test", $_POST["dbpass"], $sql_file);