function getCrecimientoMobile($days, $idCountry, $total_user)
{
$crecimiento = '';
$sql = "SELECT ((rc1.category_18 + rc1.category_19 + rc1.category_20 + rc1.category_21 + rc1.category_22 + rc1.category_23) - (\n\t\t\t\t\t\t\tSELECT (rc2.category_18 + rc2.category_19 + rc2.category_20 + rc2.category_21 + rc2.category_22 + rc2.category_23) \n\t\t\t\t\t\t\tFROM record_country_for_user_preference rc2 \n\t\t\t\t\t\t\tWHERE date = (\n\t\t\t\t\t\t\t\t\tSELECT date \n\t\t\t\t\t\t\t\t\tFROM record_country_for_user_preference \n\t\t\t\t\t\t\t\t\tWHERE DATE_SUB('" . get_last_date_for_user_preference() . "',INTERVAL " . $days . " DAY) <= date \n\t\t\t\t\t\t\t\t\tGROUP BY date \n\t\t\t\t\t\t\t\t\tORDER BY 1 ASC \n\t\t\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\tAND rc2.id_country = " . $idCountry . "\n\t\t\t\t\t\t )) cambio \n\t\t\t\tFROM record_country_for_user_preference rc1 \n\t\t\t\tWHERE date = '" . get_last_date_for_user_preference() . "'\n\t\t\t\t\tAND rc1.id_country = " . $idCountry . ";\n\t\t\t\t";
$que = mysql_query($sql) or die(mysql_error());
if ($fila = mysql_fetch_assoc($que)) {
if ($fila['cambio'] > 0) {
$crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_up">' . owloo_number_format($fila['cambio']) . '</span>';
$crecimiento['porcentaje'] = '<span class="owloo_arrow_up_porcent">' . owlooFormatPorcent($fila['cambio'], $total_user) . '%</span>';
} else {
if ($fila['cambio'] == 0) {
$crecimiento['value'] = '<span class="owloo_not_change_audition"><em>sin cambio</em></span>';
$crecimiento['porcentaje'] = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
} else {
$crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_down">' . owloo_number_format($fila['cambio'] * -1) . '</span>';
$crecimiento['porcentaje'] = '<span class="owloo_arrow_down_porcent">' . owlooFormatPorcent($fila['cambio'] * -1, $total_user) . '%</span>';
}
}
}
return $crecimiento;
}
" title="" alt="" />
</span>
<a href="<?php
echo URL_ROOT;
?>
twitter-stats/userpage/<?php
echo $fetchdata["owloo_screen_name"];
?>
" title="Datos y estadísticas de <?php
echo $fetchdata["owloo_user_name"];
?>
en Twitter">@<?php
echo $fetchdata["owloo_screen_name"];
?>
</a>
</div>
<div class="owloo_description">
<?php
echo $fetchdata["owloo_user_name"];
?>
tiene <strong><?php
echo owloo_number_format($fetchdata["count"]);
?>
de menciones</strong> entre todas las cuentas registradas en el owloo.
</div>
</div>
</div>
<?php
}
?>
<script>window.setTimeout(function(){ load_twitter_avatar() }, 1000);</script>
function getCrecimientoFacebookLocalFansPage($id_page, $id_country, $last_update, $days)
{
$crecimiento = array();
$sql = "SELECT likes, (likes - (\n SELECT likes \n FROM facebook_page_local_fans_country \n WHERE id_page = {$id_page}\n AND id_country = {$id_country}\n AND date = (\n SELECT date \n FROM facebook_page_local_fans_country \n WHERE DATE_SUB('{$last_update}',INTERVAL {$days} DAY) <= date\n AND id_page = {$id_page}\n ORDER BY 1 ASC \n LIMIT 1\n ) \n )) cambio \n FROM facebook_page_local_fans_country\n WHERE id_page = {$id_page} \n AND id_country = {$id_country}\n AND date = '{$last_update}';\n ";
$que = mysql_query($sql) or die(mysql_error());
if ($fila = mysql_fetch_assoc($que)) {
if ($fila['cambio'] > 0) {
$crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_up">' . owloo_number_format($fila['cambio']) . '</span>';
$crecimiento['porcentaje'] = '<span class="owloo_arrow_up_porcent">' . owlooFormatPorcent($fila['cambio'], $fila['likes']) . '%</span>';
} else {
if ($fila['cambio'] == 0) {
$crecimiento['value'] = '<span class="owloo_not_change_audition"><em>sin cambio</em></span>';
$crecimiento['porcentaje'] = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
} else {
$crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_down">' . owloo_number_format($fila['cambio'] * -1) . '</span>';
$crecimiento['porcentaje'] = '<span class="owloo_arrow_down_porcent">' . owlooFormatPorcent($fila['cambio'] * -1, $fila['likes']) . '%</span>';
}
}
}
return $crecimiento;
}
echo URL_ROOT;
?>
twitter-stats/userpage/<?php
echo $fetchdata["owloo_screen_name"];
?>
" title="Datos y estadísticas de <?php
echo $fetchdata["owloo_user_name"];
?>
en Twitter">@<?php
echo $fetchdata["owloo_screen_name"];
?>
</a>
</div>
<div class="owloo_description">
<?php
echo $fetchdata["owloo_user_name"];
?>
actualmente tiene <strong><?php
echo owloo_number_format($fetchdata["owloo_followers_count"]);
?>
seguidores</strong> y está <strong>siguiendo a <?php
echo owloo_number_format($fetchdata["owloo_following_count"]);
?>
perfiles</strong>.
</div>
</div>
</div>
<?php
}
?>
<script>window.setTimeout(function(){ load_twitter_avatar() }, 1000);</script>
//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>';
}
echo $temp_3_local_fans[0]['country'];
?>
es el país con mayor cantidad de fans que siguen a <?php
echo $page_data['name'];
?>
en Facebook, seguido por <?php
echo $temp_3_local_fans[1]['country'];
?>
con <?php
echo owloo_number_format($temp_3_local_fans[1]['fans']);
?>
y <?php
echo $temp_3_local_fans[2]['country'];
?>
con <?php
echo owloo_number_format($temp_3_local_fans[2]['fans']);
?>
.
</p>
<div class="owloo_ads_content_468x60">
<div class="owloo_ads_468x60 owloo_ads_box"><?php
echo get_owloo_ads('468x60');
?>
</div>
</div>
</div>
</div>
</div>
<div id="owloo_section_fb_local_fans" class="owloo_country_section owloo_country_content_tw_chart">
<h2>
Crecimiento de fans en
/"><?php
echo $fila['name'];
?>
</a>
</div>
<div class="owloo_fb_ranking_item">
<div class="owloo_title owloo_fb_pta_td">PTA</div>
<div class="owloo_fb_num_green"><?php
echo owlooFormatPorcent($fila['talking_about'], $fila['total_likes']);
?>
%</div>
</div>
<div class="owloo_fb_ranking_item">
<div class="owloo_title">Fans totales</div>
<div class="owloo_fb_num_green"><?php
echo owloo_number_format($fila['total_likes']);
?>
</div>
</div>
<div class="owloo_fb_ranking_item owloo_fb_ranking_item_change_audition">
<div class="owloo_title">Semana</div>
<div class="owloo_change_audition"><?php
echo $crecimiento_fans['semana']['value'];
?>
</div>
</div>
<?php
if ($fila['is_verified']) {
?>
<div class="owloo_fb_ranking_item owloo_no_border">
<span class="owloo_fb_page_verified"></span>
<?php
$qry = "";
$qry = $qry . " SELECT owloo_user_id, owloo_hashword, count(owloo_hashword) AS count";
$qry = $qry . " FROM owloo_hashtag";
$qry = $qry . " WHERE owloo_user_id = '" . $update_id . "'";
$qry = $qry . " GROUP BY owloo_hashword, owloo_user_id";
$qry = $qry . " ORDER BY count DESC";
$qry = $qry . " LIMIT 0 , 5";
$qrydata = mysql_query($qry);
$_hashtag = '<table><thead><tr><th>Hashtag</th><th class="owloo_country_table_3">Cantidad</th></tr></thead><tbody>';
while ($fetchdata = mysql_fetch_array($qrydata)) {
$_hashtag .= '<tr><td>#' . $fetchdata["owloo_hashword"] . '</td><td>' . owloo_number_format($fetchdata["count"]) . '</td></tr>';
}
$_hashtag .= '</tbody></table>';
?>
$(document).ready(function(){
$("#owloo_tw_chart_5").html('<?php
echo $_hashtag;
?>
');
$("#owloo_tw_chart_desc_5").html('Los cinco hashtags más utilizados por @<?php
echo $_GET['screenname'];
?>
desde que esta cuenta se encuentra registrada en Owloo.');
});
% de usuarios tienen BlackBerry y el <?php
echo owlooFormatPorcent($total_intereses_others_mobile_windows, $crecimiento['total_user']);
?>
% prefieren Windows.
</p>
<div class="owloo_ads_content_468x60">
<div class="owloo_ads_468x60 owloo_ads_box"></div>
</div>
</div>
<div class="owloo_right owloo_country_width_34">
<table>
<thead>
<tr>
<th class="owloo_country_table_th" colspan="2">Dispositivos móviles</th>
<th class="owloo_country_table_th"><?php
echo owloo_number_format($intereses_total_mobile_os);
?>
</th>
</tr>
</thead>
<tbody>
<tr>
<td>Día</td>
<td><?php
echo $crecimientoMobileUSers['dia']['value'];
?>
</td>
<td><?php
echo $crecimientoMobileUSers['dia']['porcentaje'];
?>
</td>
function get_instagram_last_post($id_profile, $count, $followed_by_count, $data_type = 'last_post')
{
$media = array();
$where = '';
$order_by = '';
/*if($data_type == 'last_post'){*/
$order_by = 'created_time DESC';
/*}elseif($data_type == 'engagement_rate'){
$where = ' AND created_time >= '.strtotime(date('Y-m-d').' -1 months');
$order_by = 'engagement DESC';
}*/
$qry = ' SELECT id_media, caption_text, type, images_standard_resolution, videos_standard_resolution, filter, comments_count, likes_count, (comments_count + likes_count) engagement, location_latitude, location_longitude, location_name, link, FROM_UNIXTIME(created_time) created_time
FROM ' . DB_INSTAGRAM_PREFIX . 'media
WHERE id_profile = $1 AND active = 1 ' . $where . '
ORDER BY ' . $order_by . '
LIMIT 0 , $2;';
$que = db_query($qry, array($id_profile, $count));
$index = 0;
while ($fila = mysql_fetch_assoc($que)) {
$media[$index]['type'] = $fila['type'];
$media[$index]['images_standard_resolution'] = $fila['images_standard_resolution'];
$media[$index]['videos_standard_resolution'] = $fila['videos_standard_resolution'];
if ($data_type == 'engagement_rate') {
$media[$index]['caption_text'] = $fila['caption_text'];
$media[$index]['filter'] = $fila['filter'];
$media[$index]['comments_count'] = owloo_number_format($fila['comments_count']);
$media[$index]['likes_count'] = owloo_number_format($fila['likes_count']);
$media[$index]['engagement_rate'] = $followed_by_count > 0 ? owlooFormatPorcent(($fila['likes_count'] + $fila['comments_count']) / $followed_by_count * 100) : 0;
$media[$index]['location'] = array();
if (!empty($fila['location_latitude'])) {
$media[$index]['location'] = array('latitude' => $fila['location_latitude'], 'longitude' => $fila['location_longitude'], 'name' => $fila['location_name']);
}
$media[$index]['link'] = $fila['link'];
$media[$index]['created_time'] = $fila['created_time'];
//$media[$index]['comments'] = get_instagram_medio_comments($fila['id_media'], 5);
}
$index++;
}
return $media;
}
?>
facebook-stats/pages/<?php
echo strtolower($fila['username']);
?>
/" title="Estadísticas de <?php
echo $fila['name'];
?>
en Facebook"><?php
echo $fila['name'];
?>
</a>
</div>
<div class="owloo_fb_ranking_item">
<div class="owloo_title">Fans totales</div>
<div class="owloo_fb_num_green"><?php
echo owloo_number_format($fila['likes']);
?>
</div>
</div>
<div class="owloo_fb_ranking_item">
<div class="owloo_title owloo_fb_pta_td">PTA</div>
<div class="owloo_fb_num_green"><?php
echo owlooFormatPorcent($fila['talking_about'], $fila['likes']);
?>
%</div>
</div>
<div class="owloo_fb_ranking_item owloo_fb_ranking_item_change_audition">
<div class="owloo_title">Semana</div>
<div class="owloo_change_audition"><?php
echo $crecimiento_fans['semana']['value'];
?>
</div>
<h1 class="owloo_main_title_h1 owloo_align_center owloo_fb_engagement_title">
Datos de <?php
echo $country_data['nombre'];
?>
en Facebook
</h1>
<div class="owloo_fb_fan_page_country_description">
<?php
$country_data_num = getCountryData($country_data['code']);
?>
<?php
echo $country_data['nombre'];
?>
cuenta con <?php
echo owloo_number_format($country_data_num['total_user']);
?>
usuarios, de los cuáles el <?php
echo owlooFormatPorcent($country_data_num['total_female'], $country_data_num['total_user']);
?>
% son mujeres y <?php
echo owlooFormatPorcent($country_data_num['total_male'], $country_data_num['total_user']);
?>
son hombres.<br/>
Actualmente se encuentra en la posición <?php
echo getRanking($country_data['id_country']);
?>
en el ranking mundial de Facebook.
<hr>
<a href="<?php
echo URL_ROOT;
echo owloo_number_format($followers_count);
?>
</td>
</tr>
<tr>
<td>Siguiendo</td>
<td><?php
echo owloo_number_format($following_count);
?>
</td>
</tr>
<tr>
<td>Tweets</td>
<td><?php
echo owloo_number_format($tweetcount);
?>
</td>
</tr>
<tr>
<td>Cuenta verificada</td>
<td><?php
if ($verified == 1) {
$verimg = '<img src="' . URL_IMAGES . 'owloo_user_verified_account.png" class="owloo_tooltip" title="Cuenta verificada" alt="Si"/>';
} else {
$verimg = '<img src="' . URL_IMAGES . 'owloo_tw_not_verified.png" class="owloo_tooltip" title="Cuenta no verificada" alt="No"/>';
}
echo $verimg;
?>
</td>
</tr>
<div class="owloo_title">
<span class="owloo_country_flag" style="background-position:0 <?php
echo -20 * ($fila['id_country'] - 1);
?>
px"></span>
<strong><?php
echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
?>
</strong>
</div>
<div class="owloo_description">
<?php
echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
?>
cuenta con <strong><?php
echo owloo_number_format($fila['total_user']);
?>
usuarios</strong> de los cuales el <?php
echo round($fila['total_female'] * 100 / $fila['total_user'], 2);
?>
% son mujeres y <?php
echo round($fila['total_male'] * 100 / $fila['total_user'], 2);
?>
% son hombres.
</div>
</div>
</div>
<?php
}
?>
</div>
<?php
$qry = "";
$qry = $qry . " SELECT owloo_user_id, owloo_screenanme , count( owloo_screenanme ) AS count";
$qry = $qry . " FROM owloo_mentions";
$qry = $qry . " WHERE owloo_user_id = '" . $update_id . "'";
$qry = $qry . " GROUP BY owloo_screenanme, owloo_user_id";
$qry = $qry . " ORDER BY count DESC";
$qry = $qry . " LIMIT 0 , 5";
$qrydata = mysql_query($qry);
$_menciones = '<table><thead><tr><th>Menciones</th><th class="owloo_country_table_3">Cantidad</th></tr></thead><tbody>';
while ($fetchdata = mysql_fetch_array($qrydata)) {
$_menciones .= '<tr><td>@' . $fetchdata["owloo_screenanme"] . '</td><td>' . owloo_number_format($fetchdata["count"]) . '</td></tr>';
}
$_menciones .= '</tbody></table>';
?>
$(document).ready(function(){
$("#owloo_tw_chart_4").html('<?php
echo $_menciones;
?>
');
$("#owloo_tw_chart_desc_4").html('Los cinco perfiles más mencionados de @<?php
echo $_GET['screenname'];
?>
desde que esta cuenta se encuentra registrada en Owloo.');
});
?>
.
</div>
</p>
<p>
<strong><?php
echo $twitter_name;
?>
</strong> cuenta con <strong><?php
echo owloo_number_format($followers_count);
?>
seguidores</strong> en todo el mundo, con <strong><?php
echo owloo_number_format($tweetcount);
?>
tweets</strong> publicados. Actualmente le está <strong>siguiendo a <?php
echo owloo_number_format($following_count);
?>
perfiles</strong>.
</p>
</div>
</div>
</div>
<input type="hidden" id="votcnt" value="0"/>
<input type="hidden" id="hfuidid" value="<?php
echo $update_id;
?>
"/>
<input type="hidden" id="hfflag" value="<?php
echo $hfflag;
?>
symbol: 'circle',
radius: 2,
states: {
hover: {
enabled: true
}
}
}
}
},
series: [
{
name: "Crecimiento diario de <?php
echo $screen_name;
?>
",
data: [<?php
echo $seriesData;
?>
],
lineWidth: 0
},
]
});
});
$(document).ready(function(){
$("#owloo_tw_chart_desc_1").html('Se mide el crecimiento de seguidores por día durante el período de 1 mes. El promedio de nuevos seguidores diarios es de <?php
echo $_count_suma_crecimiento > 0 ? owloo_number_format(round($_suma_crecimiento / $_count_suma_crecimiento, 0)) : 'n/a';
?>
.');
});
