$sql = "SELECT DISTINCT(t.from_user_id), t.from_user_name, k.kloutid FROM " . $esc['mysql']['dataset'] . "_tweets t ";
$sql .= "LEFT JOIN " . $esc['mysql']['dataset'] . "_klout k ON t.from_user_id = k.from_user_id ";
$sql .= "WHERE (k.from_user_id IS NULL OR k.last_updated <= '" . strftime("%Y-%m-%d %H:%M:%S", date('U') - 86400 * 31) . "')";
// @todo and http_code != 404 (spam acounts)
//print $sql; die;
$rec = mysql_query($sql);
if (mysql_num_rows($rec) > 0) {
print "Doing {$dataset}:\n";
while ($res = mysql_fetch_assoc($rec)) {
$kloutid = $kloutScore = $kloutDayChanges = $kloutWeekChanges = $kloutMonthChanges = $http_code = 0;
$kloutTopics = array();
$from_user_id = $res['from_user_id'];
$from_user_name = $res['from_user_name'];
$kloutid = $res['kloutid'];
// klout score
$klout = new KloutAPIv2($kloutapi_key);
// http://klout.com/s/developers/v2
$network = "twitter";
if (empty($kloutid)) {
$kloutid = $klout->KloutIDLookupByID("tw", $from_user_id);
}
/*
* var_export($klout);
* print "\n";
* var_export($kloutid);
* print "\n";
*/
$http_code = $klout->info['http_code'];
print strftime("%Y-%m-%d %H:%M:%S", date('U')) . " - " . $from_user_name . " - " . var_export($kloutid, 1) . " - " . $http_code . "\n";
if ($http_code != 200) {
if ($http_code == 403 || $http_code == 503 || $http_code == 504) {
<?php
require_once "KloutAPIv2.class.php";
// Set your client key and secret
$kloutapi_key = "ENTER YOUR KEY";
// Load the Klout API library
$klout = new KloutAPIv2($kloutapi_key);
// Get Klout ID
// Get Variables
$network = $_GET['NetworkPlatform'];
$screenname = $_GET['NetworkScreenName'];
$userid = $_GET['NetworkUserID'];
$kloutid = $_GET['KloutID'];
?>
<!doctype html>
<html xmlns="http://www.w3.org/1999/xhtml"
xmlns:og="http://ogp.me/ns#"
xmlns:fb="http://www.facebook.com/2008/fbml">
<head profile="http://www.w3.org/2005/10/profile"
prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb# klout__: http://ogp.me/ns/fb/klout__#">
<title>Klout Code Library | KloutAPIv2-PHP</title>
<style type="text/css">
@import url("http://kcdn3.klout.com/static/css/gz-boilerplate-MjAxMjA1MTExODA5Mjc.css?v=2");
@import url("http://klout.com/css/fonts.css");
@import url("http://kcdn3.klout.com/static/css/gz-styles-MjAxMjA1MTExODA5Mjc.css");
.rb-column { float: left; width: 50%; }
.clear { clear: both; }
</style>
</head>
<body>
<div id="header-wrapper" class="public developers">
