<?php
$n_a = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
$local_fans_last_date = get_fb_page_local_fans_general_last_date();
$page_total_count = get_fb_page_country_total_rows_count($id_country, $local_fans_last_date);
$page = 1;
if (isset($_POST['page']) && is_numeric($_POST['page'])) {
if ($_POST['page'] < 1) {
$page = 1;
} elseif ($_POST['page'] > ceil($page_total_count / PAGER_PP)) {
$page = ceil($page_total_count / PAGER_PP);
} else {
$page = $_POST['page'];
}
}
$sql = "SELECT p.id_page, username, name, picture, location, is_verified, p.likes total_likes, plf.likes local_likes, talking_about, first_local_fans_country \n\t FROM facebook_page p JOIN facebook_page_local_fans_country plf ON p.id_page = plf.id_page \n\t WHERE id_country = " . mysql_real_escape_string($id_country) . " \n\t AND plf.date = '" . $local_fans_last_date . "' \n\t AND active = 1 \n\t ORDER BY local_likes DESC, total_likes DESC, talking_about DESC \n\t LIMIT " . PAGER_PP * ($page - 1) . ", " . PAGER_PP . ";";
$res = mysql_query($sql) or die(mysql_error());
$cont = 1 + PAGER_PP * ($page - 1);
while ($fila = mysql_fetch_assoc($res)) {
$crecimiento_fans = array('semana' => array('value' => $n_a, 'porcentaje' => $n_a));
$fb_page_likes_last_update = get_fb_page_likes_last_update($fila['id_page']);
$fb_page_likes_nun_dates = get_fb_page_likes_nun_dates($fila['id_page']);
if ($fb_page_likes_nun_dates > 7) {
$crecimiento_fans['semana'] = getCrecimientoFacebookFansPage($fila['id_page'], $fb_page_likes_last_update, 7);
}
?>
<div class="owloo_ranking_item">
<div class="owloo_rank"><?php
echo str_pad($cont++, 2, '0', STR_PAD_LEFT);
?>
</div>
<?php
$n_a = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
$page_total_count = get_fb_page_country_total_rows_count($country_data['id_country'], $local_fans_last_date);
?>
<div id="owloo_ranking">
<?php
$datos = '[{"id_page":"12","username":"******","name":"ABC Digital","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-prn2\\/v\\/t1.0-1\\/c14.14.172.172\\/s50x50\\/945433_10152867160865323_1643448278_n.jpg?oh=dff0df6a08cebf7fc5a84e7b14e192dd&oe=54A055CD&__gda__=1422932086_bf88e873ee8befe6feff1de4428c41bf","location":"80","is_verified":"0","total_likes":"599771","local_likes":"469624","talking_about":"68616","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">5.112<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,85%<\\/span>"}},{"id_page":"3","username":"******","name":"Tigo Paraguay","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xap1\\/v\\/t1.0-1\\/p50x50\\/10614190_10153328032905260_5358400835432226322_n.png?oh=fc9fa5fc150f40bb791ebc3480d0a0cf&oe=54CEA15F&__gda__=1418784858_aec6c6b3ce6c78c61dd5dfc786f9ea7f","location":"80","is_verified":"1","total_likes":"498717","local_likes":"442954","talking_about":"16367","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"106","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">1.107<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,22%<\\/span>"}},{"id_page":"2087","username":"******","name":"Romeo Santos","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xaf1\\/v\\/t1.0-1\\/c0.0.50.50\\/p50x50\\/10687052_734200466657249_4083338967647382976_n.jpg?oh=0241c127d3a968513a3e52ab47b44f31&oe=54A4B96B&__gda__=1419740728_f4dcd687c8f5f4ad8cbe28573fea9fdf","location":null,"is_verified":"1","total_likes":"25448290","local_likes":"339462","talking_about":"886173","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"21","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">288.715<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">1,13%<\\/span>"}},{"id_page":"1959","username":"******","name":"Prince Royce","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/10565107_10152474163879003_5931435466976509699_n.jpg?oh=cc82c8ea0456a2583bd49720d379d9c1&oe=549A4422&__gda__=1419135817_1500f36c16bc03184810fdf28bf3d00e","location":null,"is_verified":"1","total_likes":"26865608","local_likes":"331796","talking_about":"308474","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"25","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">206.916<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,77%<\\/span>"}},{"id_page":"27","username":"******","name":"Club Olimpia Oficial","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/10342814_735816393126645_2759488093102105078_n.jpg?oh=4f6e586e5c057971259e62c6e3135e2b&oe=54882362&__gda__=1418126596_988e5da7972df3f1e75ee0ea44c0c174","location":"80","is_verified":"0","total_likes":"384182","local_likes":"314827","talking_about":"20342","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">3.143<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,82%<\\/span>"}},{"id_page":"211","username":"******","name":"Yo Amo los Zapatos","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xaf1\\/v\\/t1.0-1\\/c0.13.50.50\\/p50x50\\/27213_113622315320412_6341366_n.jpg?oh=d22206112b8d72129eefce8b2d781526&oe=54844CE3&__gda__=1422953031_327fe19811e9b66b89a3bd4d653bdd23","location":null,"is_verified":"1","total_likes":"22845861","local_likes":"308638","talking_about":"7942312","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">406.645<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">1,78%<\\/span>"}},{"id_page":"2234","username":"******","name":"ESTACION 40","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xaf1\\/v\\/t1.0-1\\/p50x50\\/1005552_682473825139847_5402831190266509637_n.png?oh=4a56aa9b2f36f1536258dfcb8d3d5bd0&oe=548DD6CF&__gda__=1418231429_1f685ab1cda1003ad32ff5176b116890","location":null,"is_verified":"1","total_likes":"366511","local_likes":"307667","talking_about":"5035","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"16","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">1.876<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,51%<\\/span>"}},{"id_page":"1552","username":"******","name":"Marco Antonio Solis","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-frc3\\/v\\/t1.0-1\\/p50x50\\/1044450_10152989398060297_812677109_n.jpg?oh=159798d814416297177ddeeb2f69c4e0&oe=54A22EAC&__gda__=1419039981_1ac4138a8d5bc935c2281ad98d0f3f65","location":null,"is_verified":"1","total_likes":"12661323","local_likes":"299914","talking_about":"830229","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"26","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">102.350<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,81%<\\/span>"}},{"id_page":"2760","username":"******","name":"HOY","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xap1\\/v\\/t1.0-1\\/c27.27.341.341\\/s50x50\\/1184888_424138087694545_1298333129_n.jpg?oh=be5ed8b80767bb0188bac41579abba4f&oe=548B3CE4&__gda__=1418211286_93805d2cf91510295e515f23308b5397","location":"80","is_verified":"0","total_likes":"343879","local_likes":"288657","talking_about":"84157","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"2"},{"id_page":"1166","username":"******","name":"Daddy Yankee","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/c126.3.526.526\\/s50x50\\/10386831_10152717606692490_8833953004115549676_n.jpg?oh=e661342f1eec2c3a931c9a0628b046c0&oe=54885F59&__gda__=1418342185_d6af3b879f6b8897e1a7c2cfa3ce9eb8","location":null,"is_verified":"1","total_likes":"25564754","local_likes":"258165","talking_about":"767850","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"26","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">88.718<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,35%<\\/span>"}},{"id_page":"1206","username":"******","name":"Zez\\u00e9 Di Camargo e Luciano","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xap1\\/v\\/t1.0-1\\/p50x50\\/10414477_10152429759781001_4096317729498678118_n.png?oh=88aa4eca6a14ceef30392a3506016ee6&oe=54CD27F1&__gda__=1418527988_2ec49ccf620dfd70f6a27d65283c29fa","location":null,"is_verified":"1","total_likes":"7594649","local_likes":"255973","talking_about":"456836","first_local_fans_country":"8","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"26","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">92.087<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">1,21%<\\/span>"}},{"id_page":"179","username":"******","name":"Dios Es Bueno!","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xpf1\\/v\\/t1.0-1\\/c0.0.50.50\\/p50x50\\/10349008_1252715071442620_8686748850027709102_n.jpg?oh=27f84e894654c08d0f183e5d74d7f8d6&oe=54923C47&__gda__=1419565750_39b64cbadcc736bf1c46c17d733c18d6","location":"1","is_verified":"0","total_likes":"13214912","local_likes":"252895","talking_about":"140338","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">11.747<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,088892%<\\/span>"}},{"id_page":"160","username":"******","name":"Det\\u00e9n el abuso!","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xaf1\\/v\\/t1.0-1\\/p50x50\\/216752_228713557166981_3627907_n.jpg?oh=c585908738d66e4504fc5f124afe2cc2&oe=54934F0A&__gda__=1418675088_c6a1d8e9de05a23fdc46d0492124abd5","location":null,"is_verified":"0","total_likes":"11523728","local_likes":"251011","talking_about":"38603","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">25.311<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,22%<\\/span>"}},{"id_page":"944","username":"******","name":"Copa Libertadores de Am\\u00e9rica","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xpa1\\/v\\/t1.0-1\\/c10.0.50.50\\/p50x50\\/10636114_10152656227827710_7782957458472103265_n.jpg?oh=cafb368d45c87e3eb8ec0425a49048ec&oe=54A05C15&__gda__=1419246512_c766c1ffc965c9ff8cdabbc6452ad820","location":null,"is_verified":"0","total_likes":"6369175","local_likes":"241281","talking_about":"477575","first_local_fans_country":"8","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"51","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">59.821<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,94%<\\/span>"}},{"id_page":"28","username":"******","name":"Yingo Paraguay","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xap1\\/v\\/t1.0-1\\/p50x50\\/1378767_633777850006759_407128859_n.jpg?oh=644b1e331decfc1419a8e8dffe24ac15&oe=548990CA&__gda__=1419740225_7dda74d47cdd1b8599f257e8f76d7a89","location":null,"is_verified":"1","total_likes":"270864","local_likes":"237316","talking_about":"5811","first_local_fans_country":"80","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"101","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">818<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,30%<\\/span>"}},{"id_page":"1210","username":"******","name":"Ricardo Arjona","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/10411357_10152226551757085_1443668355037244137_n.jpg?oh=2900d79bbacabd0b30dac79bd3c58bb9&oe=54A4B126&__gda__=1420106061_f91475cc9e4e18b8258718528323035f","location":null,"is_verified":"1","total_likes":"15335301","local_likes":"229667","talking_about":"271834","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"26","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">81.153<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,53%<\\/span>"}},{"id_page":"1167","username":"******","name":"Enrique Iglesias","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/1925339_10152030428563124_1726870578_n.png?oh=046fe0054d488239c81b82650f9f7538&oe=5495676F&__gda__=1419004447_cc11f8e49b6b6b109d5d0831a870ca52","location":null,"is_verified":"1","total_likes":"48650148","local_likes":"208869","talking_about":"1099669","first_local_fans_country":"21","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"26","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">247.753<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,51%<\\/span>"}},{"id_page":"2088","username":"******","name":"Man\\u00e1","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/10251949_10154221059220188_7143802869670342108_n.jpg?oh=c374a5a13737bd4eed07f1ee7e40b87b&oe=54A1FC45&__gda__=1422989614_78a651dbd65dcb17fd1dc96e71630897","location":null,"is_verified":"1","total_likes":"15379242","local_likes":"207792","talking_about":"930262","first_local_fans_country":"31","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"21","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">76.443<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,50%<\\/span>"}},{"id_page":"2680","username":"******","name":"Neymar Jr.","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xfp1\\/v\\/t1.0-1\\/p50x50\\/10563051_733644193337933_6920223947809052816_n.jpg?oh=fe6ae4ee77af4e62eb0c401ba9729d1b&oe=5489E7B5&__gda__=1422872275_2bcaad1a6bff57f4a082e629473b281c","location":null,"is_verified":"1","total_likes":"45338081","local_likes":"199686","talking_about":"3827165","first_local_fans_country":"8","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"3"},{"id_page":"778","username":"******","name":"Pepsi","picture":"https:\\/\\/fbcdn-profile-a.akamaihd.net\\/hprofile-ak-xap1\\/v\\/t1.0-1\\/p50x50\\/10172726_663967120307599_7241102538245272313_n.png?oh=5e0ac952500898b562ed596e7145f7db&oe=549A4D78&__gda__=1419747150_5d3435a75d681a4e04d003e214d025c9","location":null,"is_verified":"1","total_likes":"33295430","local_likes":"195502","talking_about":"250752","first_local_fans_country":"1","fb_page_likes_last_update":"2014-09-10","fb_page_likes_nun_dates":"83","crecimiento_fans_semana":{"value":"<span class=\\"owloo_change_audition owloo_arrow_up\\">41.198<\\/span>","porcentaje":"<span class=\\"owloo_arrow_up_porcent\\">0,12%<\\/span>"}}]';
$datos = json_decode($datos, true);
$cont = 1;
foreach ($datos as $fila) {
$crecimiento_fans = array('semana' => array('value' => $n_a, 'porcentaje' => $n_a));
$fb_page_likes_last_update = $fila['fb_page_likes_last_update'];
$fb_page_likes_nun_dates = $fila['fb_page_likes_nun_dates'];
if ($fb_page_likes_nun_dates > 7) {
$crecimiento_fans['semana'] = $fila['crecimiento_fans_semana'];
}
?>
<div class="owloo_ranking_item">
<div class="owloo_rank"><?php
echo str_pad($cont++, 2, '0', STR_PAD_LEFT);
?>
</div>
<div class="owloo_fb_username">
<div class="owloo_fb_avatar">
<a href="<?php
echo URL_ROOT;
?>
facebook-stats/pages/<?php
echo strtolower($fila['username']);
?>
