shuffle($code_app);
$uid = $update_id;
$is_new_insert = 0;
// 1 for new 0 for update
$since_id = "";
$since_tweet = "";
$qry = "";
$qry = "Select owloo_id_str, owloo_tweet_count From twitter_last_id_str";
$qry = $qry . " Where owloo_user_id = '" . mysql_real_escape_string($uid) . "'";
$dataarr = mysql_query($qry) or die(mysql_error());
$fetch_cntr = mysql_fetch_assoc($dataarr);
if ($fetch_cntr) {
$since_id = $fetch_cntr['owloo_id_str'];
$since_tweet = $fetch_cntr['owloo_tweet_count'];
}
if (!$since_id) {
$is_new_insert = 1;
}
include 'get_tweets.php';
}
//ALL acounts
$qry = "";
$qry .= " SELECT owloo_user_id, owloo_user_twitter_id, owloo_screen_name, owloo_tweetcount FROM twitter_user_master";
$qry .= " WHERE owloo_user_status = 1 ";
$qry .= " Order By 1";
//$qry .= " LIMIT 1";
$qrydata = mysql_query($qry) or die(mysql_error());
while ($fetch_cntr = mysql_fetch_assoc($qrydata)) {
update_tweets($fetch_cntr['owloo_user_id'], $fetch_cntr['owloo_screen_name'], $fetch_cntr['owloo_user_twitter_id'], $fetch_cntr['owloo_tweetcount']);
}
error_log(' Twitter tweets (f): ' . date('d m Y H:i:s'));
function update_datos($screenname, $update_id)
{
global $code_app, $cont_access_token;
shuffle($code_app);
echo '<br>Twitter user: '******'user'];
//include("../config/config_cronjob.php");
//Fetch Data From Twitter
$url = "https://api.twitter.com/1.1/users/lookup.json";
$parameters1 = "screen_name=" . $screenname;
$retdata = getdata($url, $parameters1);
if ($retdata) {
$twdatas = json_decode($retdata, true);
foreach ($twdatas as $twdata) {
if ($twdata[0]["message"]) {
} else {
$hfflag = 0;
$twitter_id = $twdata["id"];
$twitter_name = $twdata["name"];
$screen_name = $twdata["screen_name"];
$profile_image_url = mysql_real_escape_string($twdata["profile_image_url"]);
$description = mysql_real_escape_string($twdata["description"]);
$location = mysql_real_escape_string($twdata["location"]);
$timezone = mysql_real_escape_string($twdata["time_zone"]);
$creationdate = $twdata["created_at"];
$lang = mysql_real_escape_string($twdata["lang"]);
$verified = $twdata["verified"];
$followers_count = $twdata["followers_count"];
$following_count = $twdata["friends_count"];
$tweetcount = $twdata["statuses_count"];
$listedcount = $twdata["listed_count"];
$qry = "";
$qry = "Update owloo_user_master Set ";
$qry = $qry . " owloo_user_twitter_id = '" . $twitter_id . "',";
$qry = $qry . " owloo_user_name = '" . $twitter_name . "',";
$qry = $qry . " owloo_screen_name = '" . $screen_name . "',";
$qry = $qry . " owloo_user_photo = '" . $profile_image_url . "',";
$qry = $qry . " owloo_user_description = '" . $description . "',";
$qry = $qry . " owloo_user_location = '" . $location . "',";
$qry = $qry . " owloo_user_language = '" . $lang . "',";
$qry = $qry . " owloo_user_verified_account = '" . $verified . "',";
$qry = $qry . " owloo_user_timezone = '" . $timezone . "',";
$qry = $qry . " owloo_user_created_on = '" . $creationdate . "',";
$qry = $qry . " owloo_followers_count = '" . $followers_count . "',";
$qry = $qry . " owloo_following_count = '" . $following_count . "',";
$qry = $qry . " owloo_tweetcount = '" . $tweetcount . "',";
$qry = $qry . " owloo_listed_count = '" . $listedcount . "',";
$qry = $qry . " owloo_updated_on = '" . Date("Y-m-d") . "'";
$qry = $qry . " Where owloo_user_twitter_id = '" . $twitter_id . "'";
$qry = $qry . " AND owloo_screen_name = '" . $screen_name . "'";
echo '<br>SQL 3: ' . $qry . '<br>';
mysql_query($qry);
update_tweets($update_id, $screen_name, $tweetcount);
}
}
}
}
