コード例 #1
0
ファイル: check.php プロジェクト: newbacknew/owloo.com
function get_count_twitter_klout_score()
{
    $query = 'SELECT count(*) cantidad FROM `' . DB_TWITTER_PREFIX . 'klout_tw_data_record` WHERE `date` = date_format(NOW(), \'%Y-%m-%d\');';
    $que = db_query_tw($query, array());
    if ($fila = mysql_fetch_assoc($que)) {
        return $fila['cantidad'];
    }
}
コード例 #2
0
<?php

require_once __DIR__ . '/../config.php';
$query = 'SELECT owloo_user_id, owloo_screen_name FROM `twitter_user_master` WHERE owloo_user_twitter_id = \'0\' ORDER BY 1;';
$que = db_query_tw($query, array());
while ($fila = mysql_fetch_assoc($que)) {
    /***** 1 *****/
    /*$data = get_url_content('http://mytwitterid.com/api/?screen_name='.$fila['owloo_screen_name']);
      $data = json_decode($data, true);
      
      if(isset($data[0]['id_str'])){
          
          if(strtolower($data[0]['screen_name']) == strtolower($fila['owloo_screen_name'])){
              $query = 'UPDATE `twitter_user_master` SET owloo_user_twitter_id = \'$1\' WHERE owloo_user_id = $2;'; 
              $result = db_query_tw($query, array($data[0]['id_str'], $fila['owloo_user_id']), true);
          }
          
      }*/
    /***** 2 *****/
    $data = get_url_content('http://www.idfromuser.com/getID.php?service=twitter&username='******'owloo_screen_name']);
    if (!empty($data)) {
        $query = 'UPDATE `twitter_user_master` SET owloo_user_twitter_id = \'$1\' WHERE owloo_user_id = $2;';
        $result = db_query_tw($query, array($data, $fila['owloo_user_id']), true);
    } else {
        echo 'Die: ' . $fila['owloo_screen_name'];
        die;
    }
}
コード例 #3
0
function getHashtagsArray($id_profile, $count = 10)
{
    $hastags = array();
    $qry = ' SELECT hashtags AS name, count(*) AS count
                    FROM ' . DB_TWITTER_PREFIX . 'hashtag
                    WHERE owloo_user_id = $1 AND type_tweet = 1
                    GROUP BY hashtags
                    ORDER BY count DESC
                    LIMIT 0 , $2;';
    $que = db_query_tw($qry, array($id_profile, $count));
    while ($fila = mysql_fetch_assoc($que)) {
        $hastags[] = $fila;
    }
    return $hastags;
}
コード例 #4
0
            $qry = "";
            $qry = " INSERT INTO twitter_klout_tw_data VALUES (";
            $qry = $qry . " \$1,";
            $qry = $qry . " \$2)";
            db_query_tw($qry, array($fetch_cntr['owloo_user_id'], $data['id']), true);
        } else {
            continue;
        }
    } else {
        $klout_id = $fetch_user['klout_id'];
    }
    $klout_data = get_url_content('http://api.klout.com/v2/user.json/' . $klout_id . '/score?key=' . $klout_api_key);
    $klout_data = json_decode($klout_data, true);
    if (isset($klout_data['score'])) {
        $qry = "";
        $qry = " INSERT INTO twitter_klout_tw_data_record VALUES (";
        $qry = $qry . " \$1,";
        $qry = $qry . " \$2,";
        $qry = $qry . " \$3,";
        $qry = $qry . " \$4,";
        $qry = $qry . " \$5,";
        $qry = $qry . " '\$6',";
        $qry = $qry . " '\$7')";
        db_query_tw($qry, array($fetch_cntr['owloo_user_id'], $klout_data['score'], $klout_data['scoreDelta']['dayChange'], $klout_data['scoreDelta']['weekChange'], $klout_data['scoreDelta']['monthChange'], $klout_data['bucket'], Date("Y-m-d")), true);
    }
    if ($count % 8 == 0) {
        sleep(2);
    }
    $count++;
}
error_log('   Twitter Klout (f): ' . date('d m Y H:i:s'));