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/>';