echo 'username: '******'username'].'<br/>';
echo 'name: '.$datos['name'].'<br/>';
echo 'about: '.$datos['about'].'<br/>';
echo 'description: '.$datos['description'].'<br/>';
echo 'link: '.$datos['link'].'<br/>';
echo 'picture: '.$datos['picture']['data']['url'].'<br/>';
echo 'cover: '.$datos['cover']['source'].'<br/>';
echo 'location: '.$datos['location']['country'].'<br/>';
echo 'is_verified: '.$datos['is_verified'].'<br/>';
echo 'likes: '.$datos['likes'].'<br/>';
echo 'talking_about_count: '.$datos['talking_about_count'].'<br/>';
echo 'category: '.$datos['category'].'<br/>';
*/
$datos['username'] = !empty($datos['username']) ? $datos['username'] : $datos['id'];
$_fb_username = $datos['username'];
if (!is_exist_fb_page($datos['id'])) {
$id_page = add_fb_page($datos['id'], $datos['username'], $datos['name'], $datos['about'], $datos['description'], $datos['link'], $datos['picture']['data']['url'], $datos['cover']['source'], $datos['location']['country'], $datos['is_verified'], $datos['likes'], $datos['talking_about_count'], $datos['category']);
/*if(!empty($id_page)){
echo $__cont++.'<br/>';
/***** Add likes and talking_about *****
if(!is_exist_today_fb_page_likes_talking_about($id_page)){
add_fb_page_likes_talking_about($id_page, $datos['likes'], $datos['talking_about_count']);
}
/***** END - Add likes and talking_about *****
$access_token = get_fb_page_access_token();
$until = date('U');
$since = $until - (90 * 24 * 60 * 60);
$local_fans_country = file_get_contents('https://graph.facebook.com/'.$datos['id'].'/insights/page_fans_country?since='.$since.'&until='.$until.'&locale=es_LA&access_token='.$access_token);
return false;
}
function get_local_fans_last_date($page_id)
{
$sql = 'SELECT date FROM ' . DB_FACEBOOK_PREFIX . 'page_local_fans_country
WHERE id_page = $1
ORDER BY 1 DESC
LIMIT 1;';
$res = db_query($sql, array($page_id));
if ($fila = mysql_fetch_assoc($res)) {
return $fila['date'];
}
return NULL;
}
//Verificamos si existe la página
if (!is_exist_fb_page($page_id)) {
die;
}
$data_return = array('has_local_fans' => false);
$local_fans_last_date = get_local_fans_last_date($page_id);
$date_last_month = date('Y-m-d', strtotime($local_fans_last_date . ' -' . $days . ' day'));
if (!empty($local_fans_last_date)) {
$query = 'SELECT * FROM ' . DB_FACEBOOK_PREFIX . 'page_local_fans_country
WHERE id_page = $1
AND id_country = $2
AND date >= \'$3\';';
$que_pages = db_query($query, array($page_id, $country_id, $date_last_month));
if (mysql_num_rows($que_pages) > 0) {
$data_return['has_local_fans'] = true;
$data_return['items'] = array();
while ($local_fans = mysql_fetch_assoc($que_pages)) {
require_once __DIR__ . '/../../owloo_config_3_1.php';
function generate_data_results($page_id)
{
error_log(' Generate Page (i): ' . date('d m Y H:i:s'));
$json_data_page = get_url_content('http://www.owloo.com/wservice/table_results/facebook_pages.php?generate_new_page=true&generate_new_page_id=' . $page_id);
error_log(' Generate Page (f): ' . date('d m Y H:i:s'));
echo $json_data_page;
error_log(' Generate Results (f): ' . date('d m Y H:i:s'));
die;
}
if (isset($_GET['username']) && !empty($_GET['username'])) {
//Obtenemos su ID page en FB
$fb_page_id = get_fb_page_id_from_url($_GET['username']);
if (!empty($fb_page_id) && is_numeric($fb_page_id)) {
//Verificamos si ya existe
if (is_exist_fb_page($fb_page_id)) {
$_id_page = get_owloo_fb_page_id_from_fb_id($fb_page_id);
if (!empty($_id_page)) {
//Generamos y enviamos los datos
error_log(' Generate Results (i): ' . date('d m Y H:i:s'));
generate_data_results($_id_page);
}
}
$datos = get_url_content('https://graph.facebook.com/' . $fb_page_id . '?fields=id,username,name,about,description,link,picture,cover,location,is_verified,likes,talking_about_count,were_here_count,category&locale=es_LA');
$datos = json_decode($datos, true);
//print_r($datos);
if (isset($datos['id']) && isset($datos['name'])) {
/*
echo '<br/><br/>';
echo 'id: '.$datos['id'].'<br/>';
echo 'username: '******'username'].'<br/>';
