$query = 'SELECT id_country, code, nombre, name, idiom FROM ' . DB_FACEBOOK_PREFIX . 'country_3_1 ORDER BY 1;';
$que = db_query($query, array());
while ($fila = mysql_fetch_assoc($que)) {
$countries[$fila['id_country']] = array('code' => $fila['code'], 'name' => $fila['nombre'], 'name_en' => $fila['name'], 'idiom' => $fila['idiom']);
}
$query = "SELECT id_city, name, slug, id_country FROM " . DB_FACEBOOK_PREFIX . "city_3_1 WHERE active_fb_get_data = 1 AND active = 1;";
$que_cities = db_query($query, array());
$cities_last_update = get_city_date_last_update(mysql_num_rows($que_cities));
while ($city = mysql_fetch_assoc($que_cities)) {
$id_city = $city['id_city'];
$name = $city['name'];
$slug = $city['slug'];
$country_code = $countries[$city['id_country']]['code'];
$idiom = !empty($countries[$city['id_country']]['idiom']) ? $countries[$city['id_country']]['idiom'] : 'NULL';
$country_code = $countries[$city['id_country']]['code'];
$grow_90 = getCrecimiento($id_city, $cities_last_update, 90);
$query = "SELECT total_user, total_female, total_male FROM " . DB_FACEBOOK_PREFIX . "record_city_3_1 WHERE id_city = \$1 AND date = '\$2';";
$que_audience = db_query($query, array($city['id_city'], $cities_last_update));
if ($audience = mysql_fetch_assoc($que_audience)) {
$total_user = $audience['total_user'];
$total_female = $audience['total_female'];
$total_male = $audience['total_male'];
}
$chart_history = get_city_history($id_city, $cities_last_update, 30);
$chart_history = json_encode($chart_history);
$query = 'SELECT id_city FROM ' . DB_RESULTS_PREFIX . 'facebook_cities WHERE id_city = $10;';
$que_city = db_query_table_results($query, array($id_city));
if ($row = mysql_fetch_assoc($que_city)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_cities SET \n name = '\$10',\n slug = '\$11',\n country_code = '\$12',\n idiom = " . ($idiom != "NULL" ? "'\$13'" : "\$13") . ",\n total_user = \$14,\n total_female = \$15,\n total_male = \$16,\n grow_90 = \$17,\n chart_history = '\$18',\n updated_at = NOW()\n \n WHERE id_city = \$19;";
$values = array($name, $slug, $country_code, $idiom, $total_user, $total_female, $total_male, $grow_90, $chart_history, $id_city);
$res = db_query_table_results($query, $values, 1);
$country_code = $country['code'];
$query = 'SELECT id_interest, total_user, total_female, total_male FROM ' . DB_FACEBOOK_PREFIX . 'record_country_interest_3_1 WHERE id_country = $1 AND date = \'$2\';';
$que_audience = db_query($query, array($country['id_country'], $country_interests_last_update));
while ($audience = mysql_fetch_assoc($que_audience)) {
$id_interest = $audience['id_interest'];
$name = $interests[$id_interest]['name'];
$nivel = $interests[$id_interest]['nivel'];
$nivel_superior = !empty($interests[$id_interest]['nivel_superior']) ? $interests[$id_interest]['nivel_superior'] : 0;
$total_user = $audience['total_user'];
$total_female = $audience['total_female'];
$total_male = $audience['total_male'];
$grow_1 = getCrecimiento($country['id_country'], $id_interest, $country_interests_last_update, 1);
$grow_3 = getCrecimiento($country['id_country'], $id_interest, $country_interests_last_update, 3);
$grow_7 = getCrecimiento($country['id_country'], $id_interest, $country_interests_last_update, 7);
$grow_15 = getCrecimiento($country['id_country'], $id_interest, $country_interests_last_update, 15);
$grow_30 = getCrecimiento($country['id_country'], $id_interest, $country_interests_last_update, 30);
$chart_history = '';
if ($nivel == 1) {
$chart_history = get_an_column_history($id_interest, $country['id_country'], $country_interests_last_update, 30);
$chart_history = json_encode($chart_history);
}
$query = 'SELECT id_interest, country_code FROM ' . DB_RESULTS_PREFIX . 'facebook_countries_interests WHERE country_code = \'$10\' AND id_interest = $11;';
$que_interest = db_query_table_results($query, array($country_code, $id_interest));
if ($row = mysql_fetch_assoc($que_interest)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_countries_interests SET \n name = '\$10',\n nivel = \$11,\n nivel_superior = \$12,\n total_user = \$13,\n total_female = \$14,\n total_male = \$15,\n grow_1 = \$16,\n grow_3 = \$17,\n grow_7 = \$18,\n grow_15 = \$19,\n grow_30 = \$20,\n chart_history = '\$21',\n updated_at = NOW()\n \n WHERE country_code = '\$22' AND id_interest = \$23;";
$values = array($name, $nivel, $nivel_superior, $total_user, $total_female, $total_male, $grow_1, $grow_3, $grow_7, $grow_15, $grow_30, $chart_history, $country_code, $id_interest);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_countries_interests VALUES(NULL, \$10, '\$11', \$12, \$13, '\$14', \$15, \$16, \$17, \$18, \$19, \$20, \$21, \$22, '\$23', NOW());";
$values = array($id_interest, $name, $nivel, $nivel_superior, $country_code, $total_user, $total_female, $total_male, $grow_1, $grow_3, $grow_7, $grow_15, $grow_30, $chart_history);
$res = db_query_table_results($query, $values, 1);
$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);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_countries VALUES(\$10, '\$11', '\$12', '\$13', " . ($abbreviation != "NULL" ? "'\$14'" : "\$14") . ", '\$15', " . ($idiom != "NULL" ? "'\$16'" : "\$16") . ", \$17, \$18, \$19, \$20, \$21, \$22, '\$23', \$24, \$25, \$26, \$27, \$28, \$29, \$30, \$31, NOW());";
$values = array($id_country, $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, $general_ranking);
$res = db_query_table_results($query, $values, 1);
}
}
//General ranking
$query = 'SELECT id_country FROM ' . DB_RESULTS_PREFIX . 'facebook_countries ORDER BY total_user DESC, audience_grow_90 DESC;';
//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());
while ($fila = mysql_fetch_assoc($que)) {
$countries[$fila['id_country']] = array('code' => $fila['code'], 'name' => $fila['nombre'], 'name_en' => $fila['name'], 'idiom' => $fila['idiom']);
}
$query = 'SELECT id_region, name, id_country FROM ' . DB_FACEBOOK_PREFIX . 'region_3_1 WHERE active_fb_get_data = 1 AND active = 1;';
$que_regions = db_query($query, array());
$regions_last_update = get_region_date_last_update(mysql_num_rows($que_regions));
while ($region = mysql_fetch_assoc($que_regions)) {
$id_region = $region['id_region'];
$name = $region['name'];
$country_code = $countries[$region['id_country']]['code'];
$idiom = !empty($countries[$region['id_country']]['idiom']) ? $countries[$region['id_country']]['idiom'] : 'NULL';
$grow_90 = getCrecimiento($id_region, $regions_last_update, 90);
$query = 'SELECT total_user, total_female, total_male FROM ' . DB_FACEBOOK_PREFIX . 'record_region_3_1 WHERE id_region = $1 AND date = \'$2\';';
$que_audience = db_query($query, array($region['id_region'], $regions_last_update));
if ($audience = mysql_fetch_assoc($que_audience)) {
$total_user = $audience['total_user'];
$total_female = $audience['total_female'];
$total_male = $audience['total_male'];
}
$chart_history = get_region_history($id_region, $regions_last_update, 30);
$chart_history = json_encode($chart_history);
$query = 'SELECT id_region FROM ' . DB_RESULTS_PREFIX . 'facebook_regions WHERE id_region = $10;';
$que_region = db_query_table_results($query, array($id_region));
if ($row = mysql_fetch_assoc($que_region)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_regions SET \n name = '\$10',\n country_code = '\$11',\n idiom = " . ($idiom != "NULL" ? "'\$12'" : "\$12") . ",\n total_user = \$13,\n total_female = \$14,\n total_male = \$15,\n grow_90 = \$16,\n chart_history = '\$17',\n updated_at = NOW()\n \n WHERE id_region = \$18;";
$values = array($name, $country_code, $idiom, $total_user, $total_female, $total_male, $grow_90, $chart_history, $id_region);
$res = db_query_table_results($query, $values, 1);
if ($fila = mysql_fetch_assoc($que)) {
$count_region = $fila['cantidad'];
}
$interests = array();
$query = 'SELECT id_interest, nombre FROM ' . DB_FACEBOOK_PREFIX . 'interest_3_1 WHERE active_fb_get_data = 1 AND active = 1;';
$que_interests = db_query($query, array());
while ($fila = mysql_fetch_assoc($que_interests)) {
$interests[$fila['id_interest']] = array('name' => $fila['nombre']);
}
$region_interests_last_update = get_region_interests_date_last_update($count_region * 5);
$query = 'SELECT id_region, id_interest, total_user FROM ' . DB_FACEBOOK_PREFIX . 'record_region_interest_3_1 WHERE date = \'$1\';';
$que = db_query($query, array($region_interests_last_update));
while ($region = mysql_fetch_assoc($que)) {
$id_interest = $region['id_interest'];
$name = $interests[$region['id_interest']]['name'];
$id_region = $region['id_region'];
$total_user = $region['total_user'];
$grow_30 = getCrecimiento($id_region, $id_interest, $region_interests_last_update, 30);
$query = 'SELECT id_interest, id_region FROM ' . DB_RESULTS_PREFIX . 'facebook_regions_interests WHERE id_region = $10 AND id_interest = $11;';
$que_interest = db_query_table_results($query, array($id_region, $id_interest));
if ($row = mysql_fetch_assoc($que_interest)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_regions_interests SET \n name = '\$10',\n total_user = \$11,\n grow_30 = \$12,\n updated_at = NOW()\n \n WHERE id_region = \$13 AND id_interest = \$14;";
$values = array($name, $total_user, $grow_30, $id_region, $id_interest);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_regions_interests VALUES(NULL, \$10, '\$11', \$12, \$13, \$14, NOW());";
$values = array($id_interest, $name, $id_region, $total_user, $grow_30);
$res = db_query_table_results($query, $values, 1);
}
}
error_log(' Facebook Region Interest (f): ' . date('d m Y H:i:s'));
$relationships[$fila['id_relationship']] = array('name' => $fila['nombre']);
}
$country_relationships_last_update = get_country_relationships_date_last_update(count($countries) * count($relationships));
foreach ($countries as $country) {
$country_code = $country['code'];
$query = 'SELECT id_relationship, total_user, total_female, total_male FROM ' . DB_FACEBOOK_PREFIX . 'record_country_relationship_3_1 WHERE id_country = $1 AND date = \'$2\';';
$que_audience = db_query($query, array($country['id_country'], $country_relationships_last_update));
while ($audience = mysql_fetch_assoc($que_audience)) {
$id_relationship = $audience['id_relationship'];
$name = $relationships[$id_relationship]['name'];
$total_user = $audience['total_user'];
$total_female = $audience['total_female'];
$total_male = $audience['total_male'];
$total_user_grow_30 = getCrecimiento($country['id_country'], $id_relationship, $country_relationships_last_update, 'user', 30);
$total_female_grow_30 = getCrecimiento($country['id_country'], $id_relationship, $country_relationships_last_update, 'female', 30);
$total_male_grow_30 = getCrecimiento($country['id_country'], $id_relationship, $country_relationships_last_update, 'male', 30);
$query = 'SELECT id_relationship, country_code FROM ' . DB_RESULTS_PREFIX . 'facebook_countries_relationships WHERE country_code = \'$10\' AND id_relationship = $11;';
$que_relationship = db_query_table_results($query, array($country_code, $id_relationship));
if ($row = mysql_fetch_assoc($que_relationship)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_countries_relationships SET \n name = '\$10',\n total_user = \$11,\n total_female = \$12,\n total_male = \$13,\n total_user_grow_30 = \$14,\n total_female_grow_30 = \$15,\n total_male_grow_30 = \$16,\n updated_at = NOW()\n \n WHERE country_code = '\$17' AND id_relationship = \$18;";
$values = array($name, $total_user, $total_female, $total_male, $total_user_grow_30, $total_female_grow_30, $total_male_grow_30, $country_code, $id_relationship);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_countries_relationships VALUES(NULL, \$10, '\$11', '\$12', \$13, \$14, \$15, \$16, \$17, \$18, NOW());";
$values = array($id_relationship, $name, $country_code, $total_user, $total_female, $total_male, $total_user_grow_30, $total_female_grow_30, $total_male_grow_30);
$res = db_query_table_results($query, $values, 1);
}
}
}
set_time_limit(0);
error_log(' Facebook Country Relationship (f): ' . date('d m Y H:i:s'));
$countries[] = array('id_country' => $fila['id_country'], 'code' => $fila['code'], 'name' => $fila['nombre'], 'name_en' => $fila['name']);
}
$languages = array();
$query = "SELECT id_language, nombre FROM facebook_language_3_1 WHERE active_fb_get_data = 1 AND active = 1;";
$que_languages = db_query($query, array());
while ($fila = mysql_fetch_assoc($que_languages)) {
$languages[$fila['id_language']] = array('name' => $fila['nombre']);
}
$country_languages_last_update = get_country_languages_date_last_update(count($countries) * count($languages));
foreach ($countries as $country) {
$country_code = $country['code'];
$query = "SELECT id_language, total_user FROM facebook_record_country_language_3_1 WHERE id_country = \$1 AND date = '\$2';";
$que_audience = db_query($query, array($country['id_country'], $country_languages_last_update));
while ($audience = mysql_fetch_assoc($que_audience)) {
$id_language = $audience['id_language'];
$name = $languages[$id_language]['name'];
$total_user = $audience['total_user'];
$grow_30 = getCrecimiento($country['id_country'], $id_language, $country_languages_last_update, 30);
$query = 'SELECT id_language, country_code FROM facebook_countries_languages WHERE country_code = \'$10\' AND id_language = $11;';
$que_language = db_query_table_results($query, array($country_code, $id_language));
if ($row = mysql_fetch_assoc($que_language)) {
$query = "UPDATE facebook_countries_languages SET \n name = '\$10',\n total_user = \$11,\n grow_30 = \$12,\n updated_at = NOW()\n \n WHERE country_code = '\$13' AND id_language = \$14;";
$values = array($name, $total_user, $grow_30, $country_code, $id_language);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO facebook_countries_languages VALUES(NULL, \$10, '\$11', '\$12', \$13, \$14, NOW());";
$values = array($id_language, $name, $country_code, $total_user, $grow_30);
$res = db_query_table_results($query, $values, 1);
}
}
}
if ($fila = mysql_fetch_assoc($que)) {
$count_city = $fila['cantidad'];
}
$interests = array();
$query = 'SELECT id_interest, nombre FROM ' . DB_FACEBOOK_PREFIX . 'interest_3_1 WHERE active_fb_get_data = 1 AND active = 1;';
$que_interests = db_query($query, array());
while ($fila = mysql_fetch_assoc($que_interests)) {
$interests[$fila['id_interest']] = array('name' => $fila['nombre']);
}
$city_interests_last_update = get_city_interests_date_last_update($count_city * 5);
$query = 'SELECT id_city, id_interest, total_user FROM ' . DB_FACEBOOK_PREFIX . 'record_city_interest_3_1 WHERE date = \'$1\';';
$que = db_query($query, array($city_interests_last_update));
while ($city = mysql_fetch_assoc($que)) {
$id_interest = $city['id_interest'];
$name = $interests[$city['id_interest']]['name'];
$id_city = $city['id_city'];
$total_user = $city['total_user'];
$grow_30 = getCrecimiento($id_city, $id_interest, $city_interests_last_update, 30);
$query = 'SELECT id_interest, id_city FROM ' . DB_RESULTS_PREFIX . 'facebook_cities_interests WHERE id_city = $10 AND id_interest = $11;';
$que_interest = db_query_table_results($query, array($id_city, $id_interest));
if ($row = mysql_fetch_assoc($que_interest)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_cities_interests SET \n name = '\$10',\n total_user = \$11,\n grow_30 = \$12,\n updated_at = NOW()\n \n WHERE id_city = \$13 AND id_interest = \$14;";
$values = array($name, $total_user, $grow_30, $id_city, $id_interest);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_cities_interests VALUES(NULL, \$10, '\$11', \$12, \$13, \$14, NOW());";
$values = array($id_interest, $name, $id_city, $total_user, $grow_30);
$res = db_query_table_results($query, $values, 1);
}
}
error_log(' Facebook City Interest (f): ' . date('d m Y H:i:s'));
$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());";
$values = array($id_country, $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, $general_ranking);
$res = db_query_table_results($query, $values, 1);
}
}
//General ranking
$query = 'SELECT id_country FROM facebook_countries ORDER BY total_user DESC, audience_grow_30 DESC;';
$que_audience = db_query($query, array($country['id_country'], $country_comportamientos_last_update));
while ($audience = mysql_fetch_assoc($que_audience)) {
$id_comportamiento = $audience['id_comportamiento'];
$name = $comportamientos[$id_comportamiento]['name'];
$nivel = $comportamientos[$id_comportamiento]['nivel'];
$nivel_superior = !empty($comportamientos[$id_comportamiento]['nivel_superior']) ? $comportamientos[$id_comportamiento]['nivel_superior'] : 0;
$mobile_device = $comportamientos[$id_comportamiento]['mobile_device'];
$mobile_os = $comportamientos[$id_comportamiento]['mobile_os'];
$total_user = $audience['total_user'];
$total_female = $audience['total_female'];
$total_male = $audience['total_male'];
$grow_1 = getCrecimiento($country['id_country'], $id_comportamiento, $country_comportamientos_last_update, 1);
$grow_3 = getCrecimiento($country['id_country'], $id_comportamiento, $country_comportamientos_last_update, 3);
$grow_7 = getCrecimiento($country['id_country'], $id_comportamiento, $country_comportamientos_last_update, 7);
$grow_15 = getCrecimiento($country['id_country'], $id_comportamiento, $country_comportamientos_last_update, 15);
$grow_30 = getCrecimiento($country['id_country'], $id_comportamiento, $country_comportamientos_last_update, 30);
$chart_history = '';
if ($id_comportamiento == 92 || $id_comportamiento == 93 || $id_comportamiento == 94 || $comportamientos[$id_comportamiento]['nivel'] == 3 && mobile_device_has_more_device($id_comportamiento)) {
$chart_history = get_an_column_history($id_comportamiento, $country['id_country'], $country_comportamientos_last_update, 30);
$chart_history = json_encode($chart_history);
}
$query = 'SELECT id_comportamiento, country_code FROM ' . DB_RESULTS_PREFIX . 'facebook_countries_comportamientos WHERE country_code = \'$10\' AND id_comportamiento = $11;';
$que_comportamiento = db_query_table_results($query, array($country_code, $id_comportamiento));
if ($row = mysql_fetch_assoc($que_comportamiento)) {
$query = "UPDATE " . DB_RESULTS_PREFIX . "facebook_countries_comportamientos SET \n name = '\$10',\n nivel = \$11,\n nivel_superior = \$12,\n mobile_device = \$13,\n mobile_os = '\$14',\n total_user = \$15,\n total_female = \$16,\n total_male = \$17,\n grow_1 = \$18,\n grow_3 = \$19,\n grow_7 = \$20,\n grow_15 = \$21,\n grow_30 = \$22,\n chart_history = '\$23',\n updated_at = NOW()\n \n WHERE country_code = '\$24' AND id_comportamiento = \$25;";
$values = array($name, $nivel, $nivel_superior, $mobile_device, $mobile_os, $total_user, $total_female, $total_male, $grow_1, $grow_3, $grow_7, $grow_15, $grow_30, $chart_history, $country_code, $id_comportamiento);
$res = db_query_table_results($query, $values, 1);
} else {
$query = "INSERT INTO " . DB_RESULTS_PREFIX . "facebook_countries_comportamientos VALUES(NULL, \$10, '\$11', \$12, \$13, \$14, '\$15', '\$16', \$17, \$18, \$19, \$20, \$21, \$22, \$23, \$24, '\$25', NOW());";
$values = array($id_comportamiento, $name, $nivel, $nivel_superior, $mobile_device, $mobile_os, $country_code, $total_user, $total_female, $total_male, $grow_1, $grow_3, $grow_7, $grow_15, $grow_30, $chart_history);
$res = db_query_table_results($query, $values, 1);
$_crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_down">' . owloo_number_format($fila['cambio'] * -1) . '</span>';
$_crecimiento['porcentaje'] = '<span class="owloo_arrow_down_porcent">' . owlooFormatPorcent($fila['cambio'] * -1, $fila['total_user']) . '%</span>';
}
}
$crecimiento['dia'] = $_crecimiento;
}
//Estadística de cambio de usuarios en los ulimos 7 dias
$crecimiento['semana'] = getCrecimiento(6, COUNTRY_DATA_CODE);
//Estadística de cambio de usuarios en los ulimos 30 dias
$crecimiento['mes'] = getCrecimiento(29, COUNTRY_DATA_CODE);
//Estadística de cambio de usuarios en los ulimos 60 dias
$crecimiento['dos_meses'] = getCrecimiento(59, COUNTRY_DATA_CODE);
//Estadística de cambio de usuarios en los ulimos 90 dias
$crecimiento['tres_meses'] = getCrecimiento(89, COUNTRY_DATA_CODE);
//Estadística de cambio de usuarios en los ulimos 180 dias
$crecimiento['seis_meses'] = getCrecimiento(180, COUNTRY_DATA_CODE);
/********************************* FIN - Estadísticas de cambio de usuarios en las ultimas 24 horas, ultimos 7 y 30 dias ***************************************/
/********************************* CHART: Historial de total de usuarios en los ultimos 90 dias ***************************************/
$sql = "SELECT total_user, date, nombre, code \n\t\t\t\tFROM record_country r \n\t\t\t\t\tJOIN country c \n\t\t\t\t\t\tON r.id_country = c.id_country \n\t\t\t\tWHERE c.id_country = " . COUNTRY_DATA_ID . " \n\t\t\t\t\tAND DATE_SUB(STR_TO_DATE('" . COUNTRY_DATE_LAST_UPDATE . "', '%Y-%m-%d'),INTERVAL 90 DAY) <= date\n\t\t\t\tORDER BY 2 ASC;\n\t\t\t\t";
$que = mysql_query($sql) or die(mysql_error());
$seriesData = "";
//Estadística vertical. Cantidad de usuarios que posee en Facebook
$seriesDataMin = 0;
//Número mínimo de usuarios
$seriesDataMax = 0;
//Número máximo de usuarios
$xAxisCategories = "";
//Estadística horizontal. Fechas de los datos
$ban = 1;
//Bandera
$cont = 1;
