$next_id = $_SERVER['argv'][1];
$next_code = $_SERVER['argv'][2];
$total_language = $_SERVER['argv'][3];
$id_language = $_SERVER['argv'][4];
$key_language = $_SERVER['argv'][5];
if (!empty($next_id)) {
$query = 'SELECT id_country FROM facebook_record_country_language_3_1 WHERE id_country = $1 AND id_language = $2 AND date = DATE_FORMAT(NOW(), \'%Y-%m-%d\');';
$result = db_query($query, array($next_id, $id_language));
if (!($row = $result->fetch(PDO::FETCH_ASSOC))) {
$ban = 0;
while ($ban == 0) {
//Audiencia total
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($next_code, $key_language, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudience) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience)) {
$query = 'INSERT INTO facebook_record_country_language_3_1 VALUES($1, $2, $3, NOW());';
$values = array($next_id, $id_language, $numAudience);
$res = db_query($query, $values, 1);
if ($res) {
$ban = 1;
}
} else {
send_email('country_language_3_1', 'Owloo ERROR - Pais LANGUAGE - ' . $next_id . ' - 3.1', 'ERROR en la captura de datos.', true, 'Captura de datos - Pais LANGUAGE - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience);
//Trata de obtener un nuevo access_token
}
}
return $numAudience;
}
/***************************************** GET POR ACTIVIDADES ********************************************************/
echo '<br>Pea hae: ' . ($accessToken = getAccessToken());
$query = "SELECT id_country, code FROM country WHERE id_country >= 181 AND id_country <= 200 ORDER BY 1 LIMIT 1;";
$que = mysql_query($query, $conexion) or die(mysql_error());
$sql_value = "";
while ($fila = mysql_fetch_assoc($que)) {
$ban = 0;
while ($ban == 0) {
$sql_value = "";
for ($i = 0; $i < count($actividades); $i++) {
$sql_value .= ',' . getNumAudience($fila["code"], $actividades[$i]['actividad'], $accessToken);
}
//Insertamos los datos
$sql = "INSERT INTO record_country_for_user_preference VALUES(null, " . $fila['id_country'] . ", now() " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
//VERIFICA SI SE HA INSERTADO CORRECTAMENTE
$query = "SELECT id_user_preference FROM record_country_for_user_preference WHERE id_user_preference = " . $ultimoRegistro . " AND category_1 is not null AND category_2 is not null AND category_3 is not null AND category_4 is not null AND category_5 is not null AND category_6 is not null AND category_7 is not null AND category_8 is not null AND category_9 is not null AND category_10 is not null AND category_11 is not null AND category_12 is not null AND category_13 is not null AND category_14 is not null AND category_15 is not null AND category_16 is not null AND category_17 is not null AND category_18 is not null AND category_19 is not null AND category_20 is not null AND category_21 is not null AND category_22 is not null AND category_23 is not null AND category_24 is not null AND category_25 is not null AND category_26 is not null AND category_27 is not null AND category_28 is not null AND category_29 is not null AND category_30 is not null AND category_31 is not null AND category_32 is not null AND category_33 is not null;";
$que2 = mysql_query($query, $conexion) or die(mysql_error());
if ($fila2 = mysql_fetch_assoc($que2)) {
$ban = 1;
} else {
$sql = "DELETE FROM record_country_for_user_preference WHERE id = " . $ultimoRegistro . ";";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
}
}
//Audiencia total mujeres
$check_audience = false;
$numAudienceFemale = NULL;
while (!$check_audience) {
$numAudienceFemale = getNumAudience($next_code, $age_min, $age_max, "2", $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceFemale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
//Audiencia total hombres
$check_audience = false;
$numAudienceMale = NULL;
while (!$check_audience) {
$numAudienceMale = getNumAudience($next_code, $age_min, $age_max, "1", $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceMale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience) && is_numeric($numAudienceMale) && is_numeric($numAudienceFemale)) {
$query = 'INSERT INTO facebook_record_country_age_3_1 VALUES($1, $2, $3, $4, $5, NOW());';
$values = array($next_id, $age_id, $numAudience, $numAudienceFemale, $numAudienceMale);
$res = db_query($query, $values, 1);
if ($res) {
$ban = 1;
}
} else {
send_email('country_age_3_1', 'Owloo ERROR - Pais AGE - ' . $next_id . ' - 3.1', 'ERROR en la captura de datos.', true, 'Captura de datos - Pais AGE - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience . ' - ' . $numAudienceFemale . ' - ' . $numAudienceMale);
}
}
return $numAudience;
}
/***************************************** GET TOTALES ********************************************************/
$accessToken = getAccessToken();
$query = "SELECT id_country, code FROM country ORDER BY 1;";
$que = mysql_query($query, $conexion) or die(mysql_error());
$sql_value = "";
while ($fila = mysql_fetch_assoc($que)) {
$ban = 0;
while ($ban == 0) {
$sql_value = "";
$sql_value .= getNumAudience($fila["code"], "", $accessToken);
$sql_value .= ',' . getNumAudience($fila["code"], "2", $accessToken);
$sql_value .= ',' . getNumAudience($fila["code"], "1", $accessToken);
//Insertamos los datos
$sql = "INSERT INTO record_country(id_country, date, total_user, total_female, total_male) VALUES (" . $fila['id_country'] . ", DATE_FORMAT(now(),'%Y-%m-%d'), " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
//VERIFICA SI SE HA INSERTADO CORRECTAMENTE
$query = "SELECT id_country FROM record_country WHERE id_historial_pais = " . $ultimoRegistro . " AND total_user is not null AND total_female is not null AND total_male is not null;";
$que2 = mysql_query($query, $conexion) or die(mysql_error());
if ($fila2 = mysql_fetch_assoc($que2)) {
$ban = 1;
} else {
$sql = "DELETE FROM record_country WHERE id_historial_pais = " . $ultimoRegistro . ";";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
}
}
}
//Audiencia total mujeres
$check_audience = false;
$numAudienceFemale = NULL;
while (!$check_audience) {
$numAudienceFemale = getNumAudience($next_code, "2", $key_relationship, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceFemale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
//Audiencia total hombres
$check_audience = false;
$numAudienceMale = NULL;
while (!$check_audience) {
$numAudienceMale = getNumAudience($next_code, "1", $key_relationship, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceMale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience) && is_numeric($numAudienceMale) && is_numeric($numAudienceFemale)) {
$query = 'INSERT INTO facebook_record_country_relationship_3_1 VALUES($1, $2, $3, $4, $5, NOW());';
$values = array($next_id, $id_relationship, $numAudience, $numAudienceFemale, $numAudienceMale);
$res = db_query($query, $values, 1);
if ($res) {
$ban = 1;
}
} else {
send_email('country_relationship_3_1', 'Owloo ERROR - Pais RELATIONSHIP - ' . $next_id . ' - 3.1', 'ERROR en la captura de datos.', true, 'Captura de datos - Pais RELATIONSHIP - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience . ' - ' . $numAudienceFemale . ' - ' . $numAudienceMale);
$sql_value = "";
while ($fila = mysql_fetch_assoc($que)) {
$ban = 0;
while ($ban == 0) {
$sql_value = "";
//Edades
for ($i = 0; $i < count($rangoEdades); $i++) {
$sql_value .= getNumAudience($fila["code"], "", $rangoEdades[$i]['min'], $rangoEdades[$i]['max'], 'null', '', 'false', $accessToken) . ',';
}
//Lenguajes
for ($i = 0; $i < count($idiomas); $i++) {
$sql_value .= getNumAudience($fila["code"], "", '13', '65', 'null', $idiomas[$i]['code'], 'true', $accessToken) . ',';
}
//Relaciones
for ($i = 0; $i < count($relaciones); $i++) {
$sql_value .= getNumAudience($fila["code"], "", '13', '65', $relaciones[$i]['code'], '', 'true', $accessToken) . ',';
}
//Insertamos los datos
$sql = "INSERT INTO record_country_for_age_language VALUES(null, " . $fila['id_country'] . ", " . $sql_value . " now());";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
$query = "SELECT id FROM record_country_for_age_language WHERE id = " . $ultimoRegistro . " AND rango_13_15 is not null AND rango_16_17 is not null AND rango_18_28 is not null AND rango_29_34 is not null AND rango_35_44 is not null AND rango_45_54 is not null AND rango_55_64 is not null AND rango_65_65 is not null AND language_spanish is not null AND language_english is not null AND language_chinese is not null AND language_portuguese is not null AND language_hindi is not null AND relationship_single is not null AND relationship_has_a_relationship is not null AND relationship_married is not null;";
$que2 = mysql_query($query, $conexion) or die(mysql_error());
if ($fila2 = mysql_fetch_assoc($que2)) {
$ban = 1;
} else {
$sql = "DELETE FROM record_country_for_age_language WHERE id = " . $ultimoRegistro . ";";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
}
}
}
$numAudienceFemale = NULL;
while (!$check_audience) {
$numAudienceFemale = getNumAudience($fila["code"], "2", $accessToken, $accountId);
if (!$numAudienceFemale) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
//Audiencia total hombres
$check_audience = false;
$numAudienceMale = NULL;
while (!$check_audience) {
$numAudienceMale = getNumAudience($fila["code"], "1", $accessToken, $accountId);
if (!$numAudienceMale) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value = "";
$sql_value .= $numAudience;
$sql_value .= ',' . $numAudienceFemale;
$sql_value .= ',' . $numAudienceMale;
//Insertamos los datos
$sql = "INSERT INTO record_country(id_country, date, total_user, total_female, total_male) VALUES (" . $fila['id_country'] . ", DATE_FORMAT(now(),'%Y-%m-%d'), " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
if (!$numAudience) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value .= $numAudience . ',';
}
//Educación
for ($i = 0; $i < count($educacion); $i++) {
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($fila["code"], "", '13', '65', 'null', '', 'true', $educacion[$i]['code'], $accessToken, $accountId);
if (!$numAudience) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value .= $numAudience . ',';
}
//Insertamos los datos
$sql = "INSERT INTO record_country_for_age_language VALUES(null, " . $fila['id_country'] . ", " . $sql_value . " now());";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
$query = "SELECT id FROM record_country_for_age_language WHERE id = " . $ultimoRegistro . "\n\t\t AND rango_13_15 is not null\n\t\t AND rango_16_17 is not null\n\t\t AND rango_18_28 is not null\n\t\t AND rango_29_34 is not null\n\t\t AND rango_35_44 is not null\n\t\t AND rango_45_54 is not null\n\t\t AND rango_55_64 is not null\n\t\t AND rango_65_65 is not null\n\t\t AND language_spanish is not null\n\t\t AND language_english is not null\n\t\t AND language_chinese is not null\n\t\t AND language_portuguese is not null\n\t\t AND language_hindi is not null\n\t\t AND language_frances is not null\n\t\t AND language_aleman is not null\n\t\t AND language_italiano is not null\n\t\t AND language_ruso is not null\n\t\t AND language_japones is not null\n\t\t AND language_coreano is not null\n\t\t AND language_holandes is not null\n\t\t AND language_arabe is not null\n\t\t AND language_bengali is not null\n\t\t AND language_turco is not null\n\t\t AND language_malayo is not null\n\t\t AND language_polaco is not null\n\t\t AND language_indonesio is not null\n\t\t AND language_filipino is not null\n\t\t AND language_tailandes is not null\n\t\t AND language_vietnamita is not null\n\t\t AND relationship_single is not null\n\t\t AND relationship_has_a_relationship is not null\n\t\t AND relationship_married is not null\n\t\t AND relationship_comprometido is not null\n\t\t AND education_en_la_escuela_secundaria is not null\n\t\t AND education_en_la_universidad is not null\n\t\t AND education_con_estudios_universitarios is not null;";
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($fila["code"], "2", $fila["key_city"], str_replace(' ', '%20', $fila["name"]), $accessToken, $accountId);
if (!$numAudience) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value .= ',' . $numAudience;
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($fila["code"], "1", $fila["key_city"], str_replace(' ', '%20', $fila["name"]), $accessToken, $accountId);
if (!$numAudience) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value .= ',' . $numAudience;
//Insertamos los datos
$sql = "INSERT INTO record_city(id_city, date, total_user, total_female, total_male) VALUES (" . $fila['id_city'] . ", DATE_FORMAT(" . $date_insert . ",'%Y-%m-%d'), " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
//VERIFICA SI SE HA INSERTADO CORRECTAMENTE
/*$query = "SELECT id_city FROM record_city WHERE id_historial_city = ".$ultimoRegistro." AND total_user is not null AND total_female is not null AND total_male is not null;";
/***************************************** GET POR ACTIVIDADES ********************************************************/
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
$query = "SELECT id_country, code FROM country WHERE id_country >= 101 AND id_country <= 120 ORDER BY 1;";
$que = mysql_query($query, $conexion) or die(mysql_error());
$sql_value = "";
while ($fila = mysql_fetch_assoc($que)) {
$ban = 0;
while ($ban == 0) {
$sql_value = "";
for ($i = 0; $i < count($actividades); $i++) {
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($fila["code"], $actividades[$i]['actividad'], $accessToken, $accountId);
if (!$numAudience) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value .= ',' . $numAudience;
}
//Insertamos los datos
$sql = "INSERT INTO record_country_for_user_preference VALUES(null, " . $fila['id_country'] . ", now() " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
$ultimoRegistro = mysql_insert_id();
//VERIFICA SI SE HA INSERTADO CORRECTAMENTE
if (!empty($next_id)) {
if ($check_if_exist) {
$query = 'SELECT id_country FROM facebook_record_country_generation_3_1 WHERE id_country = $1 AND id_generation = $2 AND date = DATE_FORMAT(NOW(), \'%Y-%m-%d\');';
$que = db_query($query, array($next_id, $id_generation));
if ($row = mysql_fetch_assoc($que)) {
die;
}
}
$cont = 0;
$ban = 0;
while ($ban == 0 && $cont < 5) {
//Audiencia total
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($next_code, $key_generation, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudience) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience)) {
$query = 'INSERT INTO facebook_record_country_generation_3_1 VALUES($1, $2, $3, NOW());';
$values = array($next_id, $id_generation, $numAudience);
$res = db_query($query, $values, 1);
if ($res) {
$ban = 1;
}
} else {
send_email('country_generation_3_1', 'Owloo ERROR - Pais GENERATION - ' . $next_id . ' - 3.1', 'ERROR en la captura de datos.', true, 'Captura de datos - Pais GENERATION - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience);
//Audiencia total mujeres
$check_audience = false;
$numAudienceFemale = NULL;
while (!$check_audience) {
$numAudienceFemale = getNumAudience($next_code, "2", $key_comportamiento, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceFemale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
//Audiencia total hombres
$check_audience = false;
$numAudienceMale = NULL;
while (!$check_audience) {
$numAudienceMale = getNumAudience($next_code, "1", $key_comportamiento, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceMale) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience) && is_numeric($numAudienceMale) && is_numeric($numAudienceFemale)) {
//Insertamos los datos
$query = 'INSERT INTO facebook_record_country_comportamiento_3_1 VALUES($1, $2, $3, $4, $5, NOW());';
$values = array($next_id, $id_comportamiento, $numAudience, $numAudienceFemale, $numAudienceMale);
$res = db_query($query, $values, 1);
if ($res) {
$ban = 1;
}
} else {
$total_interest = $_SERVER['argv'][3];
$id_interest = $_SERVER['argv'][4];
$key_interest = $_SERVER['argv'][5];
if (!empty($next_id)) {
/*$query = 'SELECT id_city FROM facebook_record_city_interest_3_1 WHERE id_city = $1 AND id_interest = $2 AND date = DATE_FORMAT(NOW(), \'%Y-%m-%d\');';
$que = db_query($query, array($next_id, $id_interest));
if(!$row = mysql_fetch_assoc($que)){*/
$cont = 0;
$ban = 0;
while ($ban == 0 && $cont < 5) {
//Audiencia total
$check_audience = false;
$numAudience = NULL;
while (!$check_audience) {
$numAudience = getNumAudience($next_code, "", $key_interest, $accessToken, $accountId, $pageId, $pageName);
if (!$numAudience) {
nextAccessToken();
} else {
$check_audience = true;
}
}
if (is_numeric($numAudience)) {
$query = 'INSERT INTO facebook_record_city_interest_3_1 VALUES($1, $2, $3, NOW());';
$values = array($next_id, $id_interest, $numAudience);
$res = db_query($query, $values, 1);
$ban = 1;
} else {
send_email('city_interest_3_1', 'Owloo ERROR - Ciudad INTEREST - ' . $next_id . ' - 3.1', 'ERROR en la captura de datos.', true, 'Captura de datos - Ciudad INTEREST - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience);
}
$cont++;
}
if ($ban == 0) {
$sql = "UPDATE record_country SET total_female = NULL WHERE date = DATE_FORMAT(now(),'%Y-%m-%d');";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
}
}
/***************************************** FIN GET MUJERES ********************************************************/
sleep(5);
/***************************************** GET HOMBRES ********************************************************/
$ban = 0;
while ($ban == 0) {
$accessToken = getAccessToken();
$query = "SELECT id_country, code FROM country;";
$que = mysql_query($query, $conexion) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
$num = getNumAudience($fila["code"], "1", $accessToken);
$sql = "UPDATE record_country SET total_male = " . $num . " WHERE id_country = " . $fila['id_country'] . " AND date = DATE_FORMAT(now(),'%Y-%m-%d');";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
}
//VERIFICA
$num_register = 0;
$num_country = 0;
$query = "SELECT count(*) num_register FROM record_country WHERE date = DATE_FORMAT(now(),'%Y-%m-%d') AND total_male is not null;";
$que = mysql_query($query, $conexion) or die(mysql_error());
if ($fila = mysql_fetch_assoc($que)) {
$num_register = $fila['num_register'];
} else {
$ban = 0;
}
$query = "SELECT count(*) num_country FROM country;";
$que = mysql_query($query, $conexion) or die(mysql_error());
$numAudienceFemale = NULL;
while (!$check_audience) {
$numAudienceFemale = getNumAudience($fila["code"], "2", $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceFemale) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
//Audiencia total hombres
$check_audience = false;
$numAudienceMale = NULL;
while (!$check_audience) {
$numAudienceMale = getNumAudience($fila["code"], "1", $accessToken, $accountId, $pageId, $pageName);
if (!$numAudienceMale) {
nextAccessToken();
$conexion = mysql_connect("localhost", "owloo_admin", "fblatamx244") or die(mysql_error());
mysql_select_db("owloo_owloo", $conexion) or die(mysql_error());
} else {
$check_audience = true;
}
}
$sql_value = "";
$sql_value .= $numAudience;
$sql_value .= ',' . $numAudienceFemale;
$sql_value .= ',' . $numAudienceMale;
//Insertamos los datos
$sql = "INSERT INTO record_country(id_country, date, total_user, total_female, total_male) VALUES (" . $fila['id_country'] . ", DATE_FORMAT(now(),'%Y-%m-%d'), " . $sql_value . ");";
$res2 = mysql_query($sql, $conexion) or die(mysql_error());
