$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;";
$values = array($code, $name, $name_en, $abbreviation, $slug, $idiom, $id_continent, $supports_region, $supports_city, $audience['total_user'], $audience['total_female'], $audience['total_male'], $audience_history, $audience_grow_90, $audience_grow_180, $audience_grow_270, $audience_grow_360, $audience_down_360, $audience_female_grow_30, $audience_male_grow_30, $id_country);
$countries = array();
$query = 'SELECT * 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 ($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';
$idiom = $country['habla_hispana'] == 1 ? 'es' : '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);
$audience_history = json_encode(get_audience_history($id_country, $country_date_last_update, 180));
$audience_grow_1 = getCrecimiento($id_country, $country_date_last_update, 1);
$audience_grow_7 = getCrecimiento($id_country, $country_date_last_update, 7);
$audience_grow_30 = getCrecimiento($id_country, $country_date_last_update, 30);
$audience_grow_60 = getCrecimiento($id_country, $country_date_last_update, 60);
$audience_grow_90 = getCrecimiento($id_country, $country_date_last_update, 90);
$audience_grow_180 = getCrecimiento($id_country, $country_date_last_update, 180);
$general_ranking = 'NULL';
$query = 'SELECT id_country FROM 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 facebook_countries SET \n code = '\$10',\n name = '\$11',\n name_en = '\$12',\n abbreviation = " . ($abbreviation != "NULL" ? "'\$13'" : "\$13") . ",\n idiom = " . ($idiom != "NULL" ? "'\$14'" : "\$14") . ",\n id_continent = \$15,\n supports_region = \$16,\n supports_city = \$17,\n total_user = \$18,\n total_female = \$19,\n total_male = \$20,\n audience_history = '\$21',\n audience_grow_1 = \$22,\n audience_grow_7 = \$23,\n audience_grow_30 = \$24,\n audience_grow_60 = \$25,\n audience_grow_90 = \$26,\n audience_grow_180 = \$27,\n updated_at = NOW()\n \n WHERE id_country = \$28;";
$values = array($code, $name, $name_en, $abbreviation, $idiom, $id_continent, $supports_region, $supports_city, $audience['total_user'], $audience['total_female'], $audience['total_male'], $audience_history, $audience_grow_1, $audience_grow_7, $audience_grow_30, $audience_grow_60, $audience_grow_90, $audience_grow_180, $id_country);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO facebook_countries VALUES(\$10, '\$11', '\$12', '\$13', " . ($abbreviation != "NULL" ? "'\$14'" : "\$14") . ", " . ($idiom != "NULL" ? "'\$15'" : "\$15") . ", \$16, \$17, \$18, \$19, \$20, \$21, '\$22', \$23, \$24, \$25, \$26, \$27, \$28, \$29, NOW());";
