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']; } }
<?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; } }
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; }
$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'));