$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'];
