//Estadísticas de Habla Hispana
//Por mes
if ($hh_city_mayor_crec_mes['ciudad'] != '') {
$hh_city_mayor_crec_mes['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_crec_mes['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_crec_mes['pais'] . '">' . $hh_city_mayor_crec_mes['ciudad'] . '</a>';
$hh_city_mayor_crec_mes['cambio'] = owloo_number_format($hh_city_mayor_crec_mes['cambio']);
} else {
$hh_city_mayor_crec_mes['ciudad'] = '<span>sin cambio</span>';
$hh_city_mayor_crec_mes['cambio'] = '<span>0</span>';
}
if ($hh_city_mayor_decrec_mes['ciudad'] != '') {
$hh_city_mayor_decrec_mes['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_decrec_mes['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_decrec_mes['pais'] . '">' . $hh_city_mayor_decrec_mes['ciudad'] . '</a>';
$hh_city_mayor_decrec_mes['cambio'] = owloo_number_format($hh_city_mayor_decrec_mes['cambio']);
} else {
$hh_city_mayor_decrec_mes['ciudad'] = '<span>sin cambio</span>';
$hh_city_mayor_decrec_mes['cambio'] = '<span>0</span>';
}
//Por 3 meses
if ($hh_city_mayor_crec_3_meses['ciudad'] != '') {
$hh_city_mayor_crec_3_meses['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_crec_3_meses['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_crec_3_meses['pais'] . '">' . $hh_city_mayor_crec_3_meses['ciudad'] . '</a>';
$hh_city_mayor_crec_3_meses['cambio'] = owloo_number_format($hh_city_mayor_crec_3_meses['cambio']);
} else {
$hh_city_mayor_crec_3_meses['ciudad'] = '<span>sin cambio</span>';
$hh_city_mayor_crec_3_meses['cambio'] = '<span>0</span>';
}
if ($hh_city_mayor_decrec_3_meses['ciudad'] != '') {
$hh_city_mayor_decrec_3_meses['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_decrec_3_meses['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_decrec_3_meses['pais'] . '">' . $hh_city_mayor_decrec_3_meses['ciudad'] . '</a>';
$hh_city_mayor_decrec_3_meses['cambio'] = owloo_number_format($hh_city_mayor_decrec_3_meses['cambio']);
} else {
$hh_city_mayor_decrec_3_meses['ciudad'] = '<span>sin cambio</span>';
$hh_city_mayor_decrec_3_meses['cambio'] = '<span>0</span>';
}
$query = "SELECT nombre, code, name \n\t\t\tFROM country \n\t\t\tORDER BY 1 ASC;\n\t\t\t";
$que = mysql_query($query) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
$xml .= "\n<url>\n <loc>http://www.owloo.com/facebook-stats/cities/" . convert_to_url_string($fila['name']) . "/</loc>\n <changefreq>daily</changefreq>\n</url>";
}
//Countries page
$query = "SELECT nombre, code, name \n\t\t\tFROM country \n\t\t\tORDER BY 1 ASC;\n\t\t\t";
$que = mysql_query($query) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
$xml .= "\n<url>\n <loc>http://www.owloo.com/facebook-stats/pages/country/" . convert_to_url_string($fila['code']) . "/</loc>\n <changefreq>daily</changefreq>\n</url>";
}
//Facebook page
$query = "SELECT id_page, username \n\t\t\tFROM facebook_page\n\t\t\tWHERE active = 1 \n\t\t\tORDER BY 1 ASC;\n\t\t\t";
$que = mysql_query($query) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
$xml .= "\n<url>\n <loc>http://www.owloo.com/facebook-stats/pages/" . convert_to_url_string($fila['username']) . "/</loc>\n <changefreq>daily</changefreq>\n</url>";
}
//Twitter's profiles
reconnect_db('owloo_twitter');
$qry = "";
$qry = " SELECT owloo_screen_name FROM owloo_user_master";
$qry = $qry . " Order By owloo_followers_count DESC";
$qrydata = mysql_query($qry);
while ($fetchdata = mysql_fetch_array($qrydata)) {
$xml .= "\n<url>\n <loc>http://www.owloo.com/twitter-stats/userpage/" . $fetchdata['owloo_screen_name'] . "</loc>\n <changefreq>daily</changefreq>\n</url>";
}
$xml .= "\n</urlset>";
$f = fopen(__DIR__ . '/sitemap.xml', 'w+');
fwrite($f, $xml);
fclose($f);
echo '<p>Sitemap generado!</p>';
?>
<h1 class="owloo_main_title_h1">
Últimas páginas de Facebook agregadas a Owloo
</h1>
<div class="owloo_fb_add_last_page_content">
<?php
require_once 'ranking_fb_page/list_last_add_acounts.php';
?>
</div>
<div class="owloo_tw_search_content">
<?php
include FOLDER_INCLUDE . 'owloo_fb_search.php';
?>
</div>
<div class="owloo_social_plugin" data="facebook-page/<?php
echo convert_to_url_string($page_data['username']);
?>
">
<h3>La plataforma en español más completa para el análisis de Facebook</h3>
<div class="owloo_social_plugin_content">
<img alt="Cargando" title="Cargando" src="<?php
echo URL_IMAGES;
?>
loader-24x24.gif" />
</div>
</div>
</div>
<?php
require_once FOLDER_INCLUDE . 'footer.php';
?>
<?php
">
<?php
echo $crecimiento != 0 ? owloo_number_format($crecimiento) : '<em>sin cambio</em>';
?>
</span>
<div class="owloo_text">
<div class="owloo_title">
<span class="owloo_country_flag" style="background-position:0 <?php
echo -20 * ($fila['id_country'] - 1);
?>
px"></span>
<a href="<?php
echo URL_ROOT;
?>
facebook-stats/cities/<?php
echo convert_to_url_string($fila['name']);
?>
/" title="Estadísticas de Facebook en <?php
echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
?>
"><?php
echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
?>
</a>
</div>
<div class="owloo_description">
<strong><?php
echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
?>
</strong> cuenta con <strong><?php
echo owloo_number_format($fila['total_user']);
if (false) {
?>
<script type="text/javascript" src="<?php
echo URL_JS;
?>
owloo_growth_charts.js?v=2.1"></script><?php
}
?>
<?php
if (get_current_page() == 'country') {
?>
<script type="text/javascript" src="<?php
echo URL_JS;
?>
owloo_country_charts.js?v=2.1&country=<?php
echo convert_to_url_string(COUNTRY_DATA_NAME_EN);
?>
"></script><?php
}
?>
<?php
if (get_current_page() == 'twitter' || get_current_page() == 'twitter_profile') {
?>
<script type="text/javascript" src="<?php
echo URL_JS;
?>
jquery.ui.custom.min.js?v1.10.3"></script><?php
}
?>
<?php
if (get_current_page() == 'twitter' || get_current_page() == 'twitter_profile') {
<div class="owloo_ranking<?php
echo !$site->loggedin ? ' owloo_hide_data' : '';
?>
">
<?php
if (!$site->loggedin) {
include FOLDER_INCLUDE . 'owloo_require_login.php';
}
?>
<?php
include 'ranking_city/list_city_country_part2.php';
?>
</div>
</div>
<div class="owloo_social_plugin" data="facebook-country-cities-ranking/<?php
echo convert_to_url_string($countryNameEn);
?>
">
<h3>¡Comparte los datos de <?php
echo $countryName;
?>
en las redes sociales!</h3>
<div class="owloo_social_plugin_content">
<img alt="Cargando" title="Cargando" src="<?php
echo URL_IMAGES;
?>
loader-24x24.gif" />
</div>
</div>
</div>
<?php
$res_insert = db_query($query_insert, array($slug, $row_country['id_country']), 1);
}*/
//City
$query_city = 'SELECT id_city, fc.name name, code FROM facebook_city_3_1 fc JOIN facebook_country_3_1 c ON fc.id_country = c.id_country ORDER BY 1;';
$que_city = db_query($query_city, array());
while ($row_city = mysql_fetch_assoc($que_city)) {
$row_city['name'] = explode(',', $row_city['name']);
if (count($row_city['name']) > 1) {
unset($row_city['name'][count($row_city['name']) - 1]);
}
$row_city['name'] = implode(',', $row_city['name']);
$slug = convert_to_url_string($row_city['name']);
$slug .= '-' . strtolower($row_city['code']);
$query_insert = "UPDATE facebook_city_3_1 SET slug = '\$1' WHERE id_city = \$2;";
$res_insert = db_query($query_insert, array($slug, $row_city['id_city']), 1);
}
//Region
$query_region = 'SELECT id_region, fr.name name, code FROM facebook_region_3_1 fr JOIN facebook_country_3_1 c ON fr.id_country = c.id_country ORDER BY 1;';
$que_region = db_query($query_region, array());
while ($row_region = mysql_fetch_assoc($que_region)) {
$row_region['name'] = explode(',', $row_region['name']);
if (count($row_region['name']) > 1) {
unset($row_region['name'][count($row_region['name']) - 1]);
}
$row_region['name'] = implode(',', $row_region['name']);
$slug = convert_to_url_string($row_region['name']);
$slug .= '-' . strtolower($row_region['code']);
$query_insert = "UPDATE facebook_region_3_1 SET slug = '\$1' WHERE id_region = \$2;";
$res_insert = db_query($query_insert, array($slug, $row_region['id_region']), 1);
}
onselect:function(i){ window.location = i.v; }, // onselect handler
items:[
<?php
$sql = "SELECT nombre, code, name, id_country\n FROM country\n ORDER BY 1 ASC;\n ";
$res = mysql_query($sql) or die(mysql_error());
$first = true;
while ($fila = mysql_fetch_assoc($res)) {
?>
<?php
echo !$first ? ',' : ($first = false);
?>
{v:'<?php
echo URL_ROOT;
?>
facebook-stats/pages/country/<?php
echo convert_to_url_string($fila['code']);
?>
/',h:'<?php
echo $fila["nombre"];
?>
',i:{x:0,y:<?php
echo -16 * ($fila['id_country'] - 1);
?>
}}
<?php
}
?>
]
});
}
});
<div class="owloo_title">Semana</div>
<div class="owloo_change_audition"><?php
echo $crecimiento_fans['semana']['value'];
?>
</div>
</div>
<div class="owloo_fb_ranking_item">
<div class="owloo_fb_flag">
<?php
if (!empty($fila['location']) || !empty($fila['first_local_fans_country'])) {
?>
<a href="<?php
echo URL_ROOT;
?>
facebook-stats/pages/country/<?php
echo convert_to_url_string(get_country_data(!empty($fila['location']) ? $fila['location'] : $fila['first_local_fans_country'], 'code'));
?>
/" title="Páginas más populares de Facebook en <?php
echo get_country_data(!empty($fila['location']) ? $fila['location'] : $fila['first_local_fans_country'], 'nombre');
?>
">
<span class="owloo_country_flag" style="background-position:0 <?php
echo -20 * ((!empty($fila['location']) ? $fila['location'] : $fila['first_local_fans_country']) - 1);
?>
px"></span>
</a>
<?php
}
?>
</div>
</div>
$url = DOMAIN . 'facebook-stats/pages/' . $_GET['value'] . '/';
$tw_description = 'Estadísticas de ' . $page['name'] . ' en Facebook, fans PTA y crecimiento en http://' . str_replace('www.', '', $url);
break;
case 'ranking-pages':
$url = DOMAIN . 'facebook-stats/pages/hispanic/';
$tw_description = 'Las páginas de Facebook más populares, estadísticas gratuitas en http://' . str_replace('www.', '', $url);
break;
case 'facebook-page-country':
if (!isset($_GET['value'])) {
exit;
}
$country = get_country_data_sp($_GET['value']);
if (empty($country)) {
exit;
}
$url = DOMAIN . 'facebook-stats/pages/country/' . convert_to_url_string($country['code']) . '/';
$tw_description = 'Páginas de Facebook más populares en ' . $country['nombre'] . ', estadísticas gratuitas en http://' . str_replace('www.', '', $url);
break;
default:
break;
}
?>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "https://connect.facebook.net/es_LA/all.js#xfbml=1&appId=314006765369588";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<div class="owloo_social_plugin_item owloo_social_plugin_fb">
<div class="fb-like" data-href="http://<?php
<div class="owloo_social_plugin" data="facebook-page-country/<?php
echo convert_to_url_string($country_data['name']);
?>
">
<h3>La plataforma en español más completa para el análisis de Facebook</h3>
<div class="owloo_social_plugin_content">
<img alt="Cargando" title="Cargando" src="<?php
echo URL_IMAGES;
?>
loader-24x24.gif" />
</div>
</div>
</div>
<?php
require_once FOLDER_INCLUDE . 'footer.php';
?>
<?php
require_once FOLDER_INCLUDE . 'include_in_footer.php';
?>
<script>if(location.hash){var page = location.hash.replace('#stats-', '');next(page, <?php
echo $page_total_count;
?>
, <?php
echo PAGER_PP;
?>
);load_page(page, 'country_page', true, '<?php
echo convert_to_url_string($country_data['name']);
?>
');}</script>
</body>
</html>
facebook-stats/<?php
echo convert_to_url_string($value['name']);
?>
/" target="_blank"><img src="<?php
echo URL_IMAGES;
?>
flags/64/<?php
echo $value['image'];
?>
.png" align="" /></a>
<div>
<a href="<?php
echo URL_ROOT;
?>
facebook-stats/<?php
echo convert_to_url_string($value['name']);
?>
/" target="_blank"><?php
echo $value['nombre'];
?>
</a>
<span class="owloo_delete_favorite" type="country" element="<?php
echo $value['id'];
?>
">Eliminar</span>
</div>
</div>
<?php
}
?>
</div>
<?php
set_time_limit(0);
require_once __DIR__ . '/../config.php';
function convert_to_url_string($text)
{
$caracteresEspeciales = array('á', 'é', 'í', 'ó', 'ú', 'ñ', ' ', '?', ',', '.', '(', ')', 'Å', 'ç');
$caracteresReemplazo = array('a', 'e', 'i', 'o', 'u', 'n', '-', '', '', '', '', '', 'a', 'c');
return str_ireplace($caracteresEspeciales, $caracteresReemplazo, strtolower($text));
}
$query_country = 'SELECT id_country, name FROM facebook_country_3_1 ORDER BY 1;';
$que_country = db_query($query_country, array());
while ($row_country = mysql_fetch_assoc($que_country)) {
$slug = convert_to_url_string($row_country['name']);
$query_insert = "UPDATE facebook_country_3_1 SET slug = '\$1' WHERE id_country = \$2;";
$res_insert = db_query($query_insert, array($slug, $row_country['id_country']), 1);
}
