function getMentionsArray($id_profile, $count = 10)
{
$mentions = array();
$qry = ' SELECT screen_name AS name, count(*) AS count
FROM ' . DB_TWITTER_PREFIX . 'mentions
WHERE owloo_user_id = $1 AND type_tweet = 1
GROUP BY screen_name
ORDER BY count DESC
LIMIT 0 , $2;';
$que = db_query_tw($qry, array($id_profile, $count));
while ($fila = mysql_fetch_assoc($que)) {
$fila['picture'] = get_current_picture_profile($fila['name']);
$mentions[] = $fila;
}
return $mentions;
}
function get_url_content($url)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
$data = curl_exec($ch);
curl_close($ch);
return $data;
}
function microtime_float()
{
list($usec, $sec) = explode(" ", microtime());
return (double) $usec + (double) $sec;
}
function get_current_picture_profile($username)
{
$html = get_url_content('http://instagram.com/' . $username);
$doc = new DOMDocument();
$doc->loadHTML($html);
foreach ($doc->getElementsByTagName('meta') as $meta) {
if ($meta->getAttribute('property') == 'og:image') {
if ($meta->getAttribute('content') != '') {
return $meta->getAttribute('content');
}
}
}
return 'http://a0.twimg.com/sticky/default_profile_images/default_profile_5_200x200.png';
}
$time_start = microtime_float();
get_current_picture_profile('cristiano');
echo 'Time: ' . (microtime_float() - $time_start);
function getMentionsArray($id_profile, $count = 10)
{
$mentions = array();
$qry = ' SELECT mention name, count(*) AS count
FROM ' . DB_INSTAGRAM_PREFIX . 'media_mentions
WHERE id_profile = $1
GROUP BY mention
ORDER BY count DESC
LIMIT 0 , $2;';
$que = db_query($qry, array($id_profile, $count));
while ($fila = mysql_fetch_assoc($que)) {
$fila['picture'] = get_current_picture_profile($fila['name']);
$mentions[] = $fila;
}
return $mentions;
}
