$step_1 = 2; } if ($cont - 1 > 21) { $step_1 = 3; } $likes = array('series_data' => $seriesData, 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => $xAxisCategories, 'step' => $step_1); $talking_about = array('series_data' => $seriesData_talking_about, 'series_data_min' => $seriesDataMin_talking_about, 'series_data_max' => $seriesDataMax_talking_about, 'x_axis' => $xAxisCategories, 'step' => $step_1); return array('likes' => $likes, 'talking_about' => $talking_about); } //Países $countries = array(); $query = 'SELECT id_country, code, nombre, name FROM facebook_country_3_1 ORDER BY 1;'; $que = db_query($query, array()); $country_date_last_update = get_country_date_last_update(mysql_num_rows($que)); while ($fila = mysql_fetch_assoc($que)) { $countries[$fila['id_country']] = array('id' => $fila['id_country'], 'code' => $fila['code'], 'name' => $fila['nombre'], 'name_en' => $fila['name'], 'audience' => get_country_audience($fila['id_country'], $country_date_last_update)); } $id_country_uses = array(); $query = 'SELECT * FROM facebook_page WHERE active = 1 ORDER BY id_page;'; $que_pages = db_query($query, array()); while ($pages = mysql_fetch_assoc($que_pages)) { $id_page = $pages['id_page']; $parent = !empty($pages['parent']) ? $pages['parent'] : "0"; $fb_id = $pages['fb_id']; $username = $pages['username']; $name = $pages['name']; $about = $pages['about']; $description = !empty($pages['description']) ? $pages['description'] : "NULL"; $link = $pages['link']; $picture = $pages['picture']; $cover = $pages['cover'];
$countries = array(); $query = 'SELECT * FROM ' . DB_FACEBOOK_PREFIX . 'country_3_1 ORDER BY 1;'; $que = db_query($query, array()); $country_date_last_update = get_country_date_last_update(mysql_num_rows($que)); while ($country = mysql_fetch_assoc($que)) { $id_country = $country['id_country']; $code = $country['code']; $name = $country['nombre']; $name_en = $country['name']; $abbreviation = !empty($country['abbreviation']) ? $country['abbreviation'] : 'NULL'; $slug = $country['slug']; $idiom = !empty($country['idiom']) ? $country['idiom'] : 'NULL'; $id_continent = $country['id_continent']; $supports_region = $country['supports_region']; $supports_city = $country['supports_city']; $audience = get_country_audience($id_country, $country_date_last_update); $aux_audience_history = get_audience_history($id_country, $country_date_last_update, 380); $audience_down_360 = $aux_audience_history['accumulate_down_360']; unset($aux_audience_history['accumulate_down_360']); $audience_history = json_encode($aux_audience_history); $audience_grow_90 = getCrecimiento($id_country, 'user', $country_date_last_update, 90); $audience_grow_180 = getCrecimiento($id_country, 'user', $country_date_last_update, 180); $audience_grow_270 = getCrecimiento($id_country, 'user', $country_date_last_update, 270); $audience_grow_360 = getCrecimiento($id_country, 'user', $country_date_last_update, 360); $audience_female_grow_30 = getCrecimiento($id_country, 'female', $country_date_last_update, 30); $audience_male_grow_30 = getCrecimiento($id_country, 'male', $country_date_last_update, 30); $general_ranking = 'NULL'; $query = 'SELECT id_country FROM ' . DB_RESULTS_PREFIX . 'facebook_countries WHERE id_country = $10;'; $que_country = db_query_table_results($query, array($id_country)); if ($row = mysql_fetch_assoc($que_country)) { $query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_countries SET \n code = '\$10',\n name = '\$11',\n name_en = '\$12',\n abbreviation = " . ($abbreviation != "NULL" ? "'\$13'" : "\$13") . ",\n slug = '\$14',\n idiom = " . ($idiom != "NULL" ? "'\$15'" : "\$15") . ",\n id_continent = \$16,\n supports_region = \$17,\n supports_city = \$18,\n total_user = \$19,\n total_female = \$20,\n total_male = \$21,\n audience_history = '\$22',\n audience_grow_90 = \$23,\n audience_grow_180 = \$24,\n audience_grow_270 = \$25,\n audience_grow_360 = \$26,\n audience_down_360 = \$27,\n audience_female_grow_30 = \$28,\n audience_male_grow_30 = \$29,\n updated_at = NOW()\n \n WHERE id_country = \$30;";
$average_growth_likes = NULL; if ($_count_suma_crecimiento > 0) { $average_growth_likes = owlooFormatPorcent($_likes_suma_crecimiento / $_count_suma_crecimiento, NULL, 2); } $likes = array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories), 'accumulate_down' => $accumulate_down, 'step' => $step_1); $daily_likes_grow = array('series_data' => implode(',', $daily_likes_grow_seriesData), 'x_axis' => implode(',', $daily_likes_grow_xAxisCategories), 'series_data_min' => $daily_likes_grow_seriesDataMin, 'series_data_max' => $daily_likes_grow_seriesDataMax, 'avg_change_per_day' => $average_growth_likes); $talking_about = array('series_data' => implode(',', $seriesData_talking_about), 'series_data_min' => $seriesDataMin_talking_about, 'series_data_max' => $seriesDataMax_talking_about, 'avg_change_per_day' => count($seriesData_talking_about) > 0 ? owlooFormatPorcent(array_sum($seriesData_talking_about) / count($seriesData_talking_about), NULL, 2) : 0, 'x_axis' => implode(',', $xAxisCategories), 'step' => $step_1); return array('likes' => $likes, 'daily_likes_grow' => $daily_likes_grow, 'talking_about' => $talking_about); } //Países $countries = array(); $query = 'SELECT id_country, code, nombre, name, idiom FROM ' . DB_FACEBOOK_PREFIX . 'country_3_1 ORDER BY 1;'; $que = db_query($query, array()); $country_date_last_update = get_country_date_last_update(mysql_num_rows($que)); while ($fila = mysql_fetch_assoc($que)) { $countries[$fila['id_country']] = array('id' => $fila['id_country'], 'code' => $fila['code'], 'name' => $fila['nombre'], 'slug' => strtolower($fila['name']), 'idiom' => $fila['idiom'], 'audience' => get_country_audience($fila['id_country'], $country_date_last_update)); } $id_country_uses = array(); if (!$generate_new_page) { $query = 'SELECT * FROM ' . DB_FACEBOOK_PREFIX . 'page WHERE active = 1 ORDER BY id_page;'; $que_pages = db_query($query, array()); } else { $query = 'SELECT * FROM ' . DB_FACEBOOK_PREFIX . 'page WHERE id_page = $1 AND active = 1 ORDER BY id_page;'; $que_pages = db_query($query, array($generate_new_page_id)); } while ($pages = mysql_fetch_assoc($que_pages)) { $id_page = $pages['id_page']; $parent = !empty($pages['parent']) ? $pages['parent'] : "0"; $fb_id = $pages['fb_id']; $username = $pages['username']; $name = $pages['name'];