<?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>
echo convert_to_url_string(get_country_data(!empty($page_data['location']) ? $page_data['location'] : $page_data['first_local_fans_country'], 'code'));
?>
/" title="Páginas más populares de Facebook en <?php
echo get_country_data(!empty($page_data['location']) ? $page_data['location'] : $page_data['first_local_fans_country'], 'nombre');
?>
">
<span class="owloo_country_flag_fb_page owloo_country_flag" style="background-position:0 <?php
echo -20 * ((!empty($page_data['location']) ? $page_data['location'] : $page_data['first_local_fans_country']) - 1);
?>
px"></span>
</a>
</td>
</tr>
<tr>
<?php
$ranking_position = get_fb_page_ranking($page_data['id_page'], !empty($page_data['location']) ? $page_data['location'] : $page_data['first_local_fans_country'], get_fb_page_local_fans_general_last_date());
?>
<td>Posición en el ranking de <?php
echo get_country_data(!empty($page_data['location']) ? $page_data['location'] : $page_data['first_local_fans_country'], 'nombre');
?>
</td>
<td><?php
echo $ranking_position;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
