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> <div class="owloo_fb_username"> <div class="owloo_fb_avatar"> <a href="<?php echo URL_ROOT; ?> facebook-stats/pages/<?php
$query = 'SELECT * FROM facebook_page WHERE active = 1 ORDER BY id_page;'; $que_pages = db_query($query, array()); while ($pages = mysql_fetch_assoc($que_pages)) { $id_page = $pages['id_page']; $parent = !empty($pages['parent']) ? $pages['parent'] : "0"; $fb_id = $pages['fb_id']; $username = $pages['username']; $name = $pages['name']; $about = $pages['about']; $description = !empty($pages['description']) ? $pages['description'] : "NULL"; $link = $pages['link']; $picture = $pages['picture']; $cover = $pages['cover']; $is_verified = $pages['is_verified']; $fb_page_likes_last_update = get_fb_page_likes_last_update($id_page); $fb_page_likes_nun_dates = get_fb_page_likes_nun_dates($id_page); $history = getHistory30Array($id_page, $fb_page_likes_last_update); $likes = $pages['likes']; $likes_history_30 = json_encode($history['likes']); $likes_grow_1 = "NULL"; $likes_grow_7 = "NULL"; $likes_grow_15 = "NULL"; $likes_grow_30 = "NULL"; $likes_grow_60 = "NULL"; $talking_about = $pages['talking_about']; $talking_about_history_30 = json_encode($history['talking_about']); $talking_about_grow_1 = "NULL"; $talking_about_grow_7 = "NULL"; $talking_about_grow_15 = "NULL"; $talking_about_grow_30 = "NULL"; $talking_about_grow_60 = "NULL";