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); } } } }