function getAccessToken_function() { $access_token = array(); $accounts = cassandra_query('SELECT email, pass, accountid, pageid, pagename FROM facebook_access_token_account;'); foreach ($accounts as $fila) { $accounts_tokens = cassandra_query("SELECT access_token, accountid, date_out FROM facebook_access_token WHERE accountid = '" . $fila['accountid'] . "';"); foreach ($accounts_tokens as $fila2) { if ($fila2['date_out'] - date('U') > 0) { $access_token[] = array('access_token' => $fila2['access_token'], 'accountId' => $fila2['accountid'], 'pageId' => $fila['pageid'], 'pageName' => $fila['pagename']); } } } if (count($access_token) > 0) { return $access_token; } return false; }
<?php set_time_limit(0); if (!is_numeric($_SERVER['argv'][1]) || strlen($_SERVER['argv'][2]) != 2 || !is_numeric($_SERVER['argv'][3]) || $_SERVER['argv'][4] != 'c45a5f3b2cfa74ac94bd5bbfb2c5d6a5') { die; } require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; //Audiencia por edad $ages = cassandra_query('SELECT id_age, min, max FROM facebook_age WHERE active_fb_get_data = 1;'); $total_age = count($ages); foreach ($ages as $fila) { exec('php-cli ' . $folder_path . 'record_country_age.php ' . $_SERVER['argv'][1] . ' ' . $_SERVER['argv'][2] . ' ' . $_SERVER['argv'][3] * $total_age . ' ' . $fila['id_age'] . ' ' . $fila['min'] . ' ' . $fila['max'] . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'record_country_age.log 2>&1 &'); }
<?php set_time_limit(0); if (!is_numeric($_SERVER['argv'][1]) || strlen($_SERVER['argv'][2]) != 2 || !is_numeric($_SERVER['argv'][3]) || $_SERVER['argv'][4] != 'c45a5f3b2cfa74ac94bd5bbfb2c5d6a5') { die; } require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; //Audiencia por situación sentimental $relationships = cassandra_query('SELECT id_relationship, key_relationship FROM facebook_relationship WHERE active_fb_get_data = 1;'); $total_relationship = count($relationships); foreach ($relationships as $fila) { exec('php-cli ' . $folder_path . 'record_country_relationship.php ' . $_SERVER['argv'][1] . ' ' . $_SERVER['argv'][2] . ' ' . $_SERVER['argv'][3] * $total_relationship . ' ' . $fila['id_relationship'] . ' ' . $fila['key_relationship'] . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'record_country_relationship.log 2>&1 &'); }
<?php set_time_limit(0); if (!is_numeric($_SERVER['argv'][1]) || strlen($_SERVER['argv'][2]) != 2 || !is_numeric($_SERVER['argv'][3]) || $_SERVER['argv'][4] != 'c45a5f3b2cfa74ac94bd5bbfb2c5d6a5') { die; } require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; //Audiencia por generación $generations = cassandra_query('SELECT id_generation, key_generation FROM facebook_generation WHERE active_fb_get_data = 1;'); $total_generation = count($generations); foreach ($generations as $fila) { exec('php-cli ' . $folder_path . 'record_country_generation.php ' . $_SERVER['argv'][1] . ' ' . $_SERVER['argv'][2] . ' ' . $_SERVER['argv'][2] * $total_generation . ' ' . $fila['id_generation'] . ' ' . $fila['key_generation'] . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'record_country_generation.log 2>&1 &'); }
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)) { cassandra_insert("INSERT INTO facebook_record_country_language(id_country,id_language,total_user,date,date_time) VALUES({$next_id}, {$id_language}, {$numAudience}, {$date}, dateof(NOW()));"); $ban = 1; } else { send_email('country_language', 'Owloo ERROR - Pais LANGUAGE - ' . $fila['id_country'], 'ERROR en la captura de datos.', true, 'Captura de datos - Pais LANGUAGE - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience); } } /***************************************** FIN GET TOTALES ********************************************************/ /********************************** Verificación de finalización *************************************************/ //Cantidad de filas insertadas $inserts = cassandra_query("SELECT COUNT(*) FROM facebook_record_country_language WHERE date = {$date};"); if (count($inserts) > 0) { if ($inserts[0]['count'] == $total_language) { send_email('country_language', 'Owloo EXITO - Pais LANGUAGE', 'EXITO en la captura de datos.'); } } /******************************* FIN - Verificación de finalización **********************************************/ } }
while ($ban == 0) { //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)) { cassandra_insert("INSERT INTO facebook_record_country_generation(id_country,id_generation,total_user,date,date_time) VALUES({$next_id}, {$id_generation}, {$numAudience}, {$date}, dateof(NOW()));"); $ban = 1; } else { send_email('country_generation', 'Owloo ERROR - Pais GENERATION - ' . $next_id, 'ERROR en la captura de datos.', true, 'Captura de datos - Pais GENERATION - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience); } } /***************************************** FIN GET TOTALES ********************************************************/ /********************************** Verificación de finalización *************************************************/ //Cantidad de filas insertadas $inserts = cassandra_query("SELECT COUNT(*) FROM facebook_record_country_generation WHERE date = {$date};"); if (count($inserts) > 0) { if ($inserts[0]['count'] == $total_generation) { send_email('country_generation', 'Owloo EXITO - Pais GENERATION', 'EXITO en la captura de datos.'); } } /******************************* FIN - Verificación de finalización **********************************************/ } }
function is_sent_today_error($type) { global $cassandra_db; $date = date('Ymd'); $sent = cassandra_query("SELECT * FROM owloo_cron_error_info WHERE type = '{$type}' AND date = {$date};"); if (count($sent) > 0) { return true; } return false; }
function setAccessToken() { $accounts = cassandra_query('SELECT email, accountid, pass FROM facebook_access_token_account;'); $ban = false; foreach ($accounts as $fila) { if (file_exists('/home/owloo/public_html/wservice/access_token_cassandra/cookie/cookies.txt')) { unlink('/home/owloo/public_html/wservice/access_token_cassandra/cookie/cookies.txt'); } $f = fopen('/home/owloo/public_html/wservice/access_token_cassandra/cookie/cookies.txt', 'w'); $access_token = getAccessToken_code($fila['email'], $fila['pass']); if (!$access_token) { $access_token = getAccessToken_code($fila['email'], $fila['pass']); } if ($access_token) { /*if(file_exists('/home/owloo/public_html/wservice/access_token/cookie/cook.txt')) unlink('/home/owloo/public_html/wservice/access_token/cookie/cook.txt'); $f = fopen('/home/owloo/public_html/wservice/access_token/cookie/cook.txt', 'w'); $access_token_expire = getAccessTokenExpireDate($access_token); if(!$access_token_expire) $access_token_expire = getAccessTokenExpireDate($access_token);*/ //$sql = "INSERT INTO access_token VALUES (NULL , '".$access_token."', '".$fila['accountId']."', ".date('U').", ".$access_token_expire.");"; cassandra_insert("INSERT INTO facebook_access_token(access_token,accountid,date_in,date_out,date_add) VALUES('{$access_token}', '" . $fila['accountid'] . "', " . date('U') . ", " . (date('U') + 36000) . ", dateof(now()));"); $ban = true; } } /*if(!$ban) informarError();*/ }
<?php set_time_limit(0); require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; $countries = cassandra_query('SELECT id_country, code FROM facebook_country WHERE active_fb_get_data = 1;'); $total_country = count($countries); /*foreach ($countries as $country) { //Audiencia total (8 seg) exec('php-cli '.$folder_path.'record_country.php '.$country['id_country'].' '.$country['code'].' '.$total_country.' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > '.$log_path.'record_country.log 2>&1 &'); } sleep(30); $count = 1; foreach ($countries as $country) { //Audiencia por edad (1:02 min) exec('php-cli '.$folder_path.'call_record_country_age.php '.$country['id_country'].' '.$country['code'].' '.$total_country.' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > '.$log_path.'call_record_country_age.log 2>&1 &'); if ($count++ % 125 == 0) sleep(40); } sleep(40);*/ $count = 1; foreach ($countries as $country) { //Audiencia por idioma (<3 min) exec('php-cli ' . $folder_path . 'call_record_country_language.php ' . $country['id_country'] . ' ' . $country['code'] . ' ' . $total_country . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'call_record_country_language.log 2>&1 &'); if ($count++ % 20 == 0) {
<?php set_time_limit(0); if (!is_numeric($_SERVER['argv'][1]) || strlen($_SERVER['argv'][2]) != 2 || !is_numeric($_SERVER['argv'][3]) || $_SERVER['argv'][4] != 'c45a5f3b2cfa74ac94bd5bbfb2c5d6a5') { die; } require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; //Audiencia por idioma $languages = cassandra_query('SELECT id_language, key_language FROM facebook_language WHERE active_fb_get_data = 1;'); $total_language = count($languages); foreach ($languages as $fila) { exec('php-cli ' . $folder_path . 'record_country_language.php ' . $_SERVER['argv'][1] . ' ' . $_SERVER['argv'][2] . ' ' . $_SERVER['argv'][3] * $total_language . ' ' . $fila['id_language'] . ' ' . $fila['key_language'] . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'record_country_language.log 2>&1 &'); }
<?php set_time_limit(0); if (!is_numeric($_SERVER['argv'][1]) || strlen($_SERVER['argv'][2]) != 2 || !is_numeric($_SERVER['argv'][3]) || $_SERVER['argv'][4] != 'c45a5f3b2cfa74ac94bd5bbfb2c5d6a5') { die; } require_once '../config.php'; $folder_path = __DIR__ . '/'; $log_path = $folder_path . 'logs/'; //Audiencia por interes $generations = cassandra_query('SELECT id_interest, key_interest FROM facebook_interest WHERE active_fb_get_data = 1;'); $total_interest = count($interests); foreach ($interests as $fila) { exec('php-cli ' . $folder_path . 'record_country_interest.php ' . $_SERVER['argv'][1] . ' ' . $_SERVER['argv'][2] . ' ' . $_SERVER['argv'][2] * $total_interest . ' ' . $fila['id_interest'] . ' ' . $fila['key_interest'] . ' c45a5f3b2cfa74ac94bd5bbfb2c5d6a5 > ' . $log_path . 'record_country_interest.log 2>&1 &'); }
} //Audiencia total hombres $check_audience = false; $numAudienceMale = NULL; while (!$check_audience) { $numAudienceMale = getNumAudience($next_code, "1", $accessToken, $accountId, $pageId, $pageName); if (!$numAudienceMale) { nextAccessToken(); } else { $check_audience = true; } } if (is_numeric($numAudience) && is_numeric($numAudienceMale) && is_numeric($numAudienceFemale)) { cassandra_insert("INSERT INTO facebook_record_country(id_country,total_user,total_female,total_male,date,date_time) VALUES({$next_id}, {$numAudience}, {$numAudienceFemale}, {$numAudienceMale}, {$date}, dateof(NOW()));"); $ban = 1; } else { send_email('country', 'Owloo ERROR - Pais - ' . $next_id, 'ERROR en la captura de datos.', true, 'Captura de datos - Pais - ID = ' . $_SERVER['argv'][1] . ' => ' . $numAudience . ' - ' . $numAudienceFemale . ' - ' . $numAudienceMale); } } } /***************************************** FIN GET TOTALES ********************************************************/ /********************************** Verificación de finalización *************************************************/ //Cantidad de filas insertadas $inserts = cassandra_query("SELECT COUNT(*) FROM facebook_record_country WHERE date = {$date} ALLOW FILTERING;"); if (count($inserts) > 0) { if ($inserts[0]['count'] == $total_country) { send_email('country', 'Owloo EXITO - Pais', 'EXITO en la captura de datos.'); } } /******************************* FIN - Verificación de finalización **********************************************/ }