//Work out worst case throttle time if ($this_limit != 0) { $throt_time = (int) (900 / $this_limit) + 1; } else { $throt_time = 1; } $cron->set_throttle_time($throt_time, $this_op); } //End of foreach op type } //Set table flags $cron->clear_table_flags(); $c1 = $cron->store_fw_fr_list('fw'); $c2 = $cron->store_fw_fr_list('fr'); if ($cron->get_fr_fw_issue() == 1) { $cron->store_cron_log(1, $cron_txts[1], ''); $cron->set_first_pass_done(666); } } else { //Can't connect to this account so set flag to skip stages below $cron->set_first_pass_done(666); } //Log number of followers on first pass if ($cron->get_first_pass_done() == 0) { //Correct text - don't just add s to help multi language support later if ($c1 == 1) { $f_txt1 = $cron_txts[2]; } else { $f_txt1 = $cron_txts[3]; } if ($c2 == 1) {
} if (!is_connected()) { //internet connection seems broken exit; } $db->output_error = 1; //Set cron status $cron->set_cron_state('bot_tweets', 1); $cron->set_log(1); $ap_creds = $db->get_ap_creds(); $configs = $db->query("\n SELECT *\n FROM " . DB_PREFIX . "users_config\n WHERE tweet_bot_status=1;\n"); while ($userConfig = mysql_fetch_array($configs, MYSQL_ASSOC)) { $cron->set_user_id($userConfig['user_id']); $tweetRate = $userConfig['tweeting_rate']; $authUserData = $db->get_user_data($userConfig['user_id']); $connection = new TwitterOAuth($ap_creds['consumer_key'], $ap_creds['consumer_secret'], $authUserData['oauth_token'], $authUserData['oauth_token_secret']); $tweetsToSend = $db->query("\n SELECT id, tweet_content\n FROM " . DB_PREFIX . "tweets_queue\n WHERE datetime_tweeted IS NULL\n AND user_id='{$userConfig['user_id']}'\n LIMIT {$tweetRate};\n "); while ($tweet = mysql_fetch_array($tweetsToSend, MYSQL_ASSOC)) { $connection->post('statuses/update', array('status' => $tweet['tweet_content'])); //Log result - reasons for a non 200 include duplicate tweets, too many tweets //posted in a period of time, etc etc. if ($connection->http_code == 200) { $cron->store_cron_log(7, $cron_txts[18] . $tweet['tweet_content'] . $cron_txts[19], ''); } else { $cron->store_cron_log(7, $cron_txts[18] . $tweet['tweet_content'] . $cron_txts[20], ''); } $postedDateTime = date('Y-m-d H:i:s'); $db->query("\n UPDATE " . DB_PREFIX . "tweets_queue\n SET datetime_tweeted='{$postedDateTime}'\n WHERE id={$tweet['id']};\n "); } } $cron->set_cron_state('bot_tweets', 0);
if (!is_connected()) { //internet connection seems broken $cron->set_cron_state('upd_info', 0); exit; } $users_info = $connection->post('users/lookup', array('user_id' => implode(',', $user_ids))); $usersRequestsRemaining--; foreach ($users_info as $user_info) { updateUserInfo($user_info); unset($user_ids[array_search($user_info->id_str, $user_ids)]); } //delete users that was not found foreach ($user_ids as $id) { $db->query("DELETE FROM " . DB_PREFIX . "extracted_user_data WHERE user_id='" . $db->prep($id) . "'"); } $cron->store_cron_log(5, 'Successfuly updated ' . count((array) $users_info) . ' records', ''); } $cron->set_cron_state('upd_info', 0); function getIds() { global $db; return $db->query("\n SELECT user_id\n FROM " . DB_PREFIX . "extracted_user_data\n WHERE datetime_updated IS NULL\n ORDER BY datetime_created ASC LIMIT " . 100 . "\n "); } function updateUserInfo($userInfo) { global $db; $updateDateTime = date('Y-m-d H:i:s'); $followers_count = intval($userInfo->followers_count); $following_count = intval($userInfo->friends_count); $follow_ratio = !empty($following_count) ? round(floatval($followers_count / $following_count), 4) : 0; $account_age_days = intval((time() - strtotime($userInfo->created_at)) / (3600 * 24));
$configs = $db->query("\n SELECT *\n FROM " . DB_PREFIX . "users_config\n WHERE tweet_bot_status=1;\n"); while ($userConfig = mysql_fetch_array($configs, MYSQL_ASSOC)) { $cron->set_user_id($userConfig['user_id']); $queryLimit = $userConfig['tweet_generation_rate'] ? $userConfig['tweet_generation_rate'] : 0; $queryOffset = $userConfig['tweet_generation_offset'] ? $userConfig['tweet_generation_offset'] : 0; $tweetsCount = 0; if (!empty($userConfig['tweet_template']) && !empty($userConfig['tweet_query'])) { $tweetsData = $db->query($userConfig['tweet_query'] . " LIMIT {$queryLimit} OFFSET {$queryOffset};"); while ($data = mysql_fetch_array($tweetsData, MYSQL_ASSOC)) { $tweet_content = bind_to_template($data, $userConfig['tweet_template']); addTweetToQueue($tweet_content, $userConfig['user_id']); $tweetsCount++; } } $newOffset = $queryOffset + $queryLimit; $db->query("UPDATE " . DB_PREFIX . "users_config\n SET tweet_generation_offset={$newOffset}\n WHERE user_id='{$userConfig['user_id']}';"); $cron->store_cron_log(6, "Generated {$tweetsCount} new tweets for user {$userConfig['user_id']}", ''); } $cron->set_cron_state('gen_tweets', 0); function bind_to_template($replacements, $template) { $GLOBALS['replacements'] = $replacements; $callback = create_function('$matches', 'return $GLOBALS["replacements"][$matches[1]];'); return preg_replace_callback('/{{(.+?)}}/', $callback, $template); } function addTweetToQueue($tweet_content, $user_id) { global $db; $createDateTime = date('Y-m-d H:i:s'); $db->query("\n INSERT INTO " . DB_PREFIX . "tweets_queue\n (user_id, datetime_created, tweet_content)\n VALUES ('{$db->prep($user_id)}', '{$db->prep($createDateTime)}', '{$db->prep($tweet_content)}');\n "); }
//search by user $followersRequestsRemaining--; $followersList = $connection->get('followers/ids', array('screen_name' => $search_queue_record['search_key'], 'cursor' => $this_cursor, 'stringify_ids' => 'true', 'count' => TWITTER_API_LIST_FW)); if (!is_object($followersList) or $connection->http_code != 200) { if (!is_connected()) { //internet connection seems broken $cron->set_cron_state('search', 0); exit; } if (in_array($connection->http_code, array(500, 502, 503, 504))) { $cron->set_cron_state('search', 0); exit; } //if Internet connection is up and Twitter servers are ok - then it probably // something wrong with our data. Let's skip it. $cron->store_cron_log(4, 'Error occured while processing ' . $search_queue_record['search_key'] . ' (http return code: ' . $connection->http_code . ') skipping..', ''); searchRecordUpdateCursor($search_queue_record['id'], '0'); continue; } foreach ($followersList->ids as $id) { createUserDataRecord($id, $search_queue_record['related_user_id'], $search_queue_record['search_key']); } $cron->store_cron_log(4, 'Successfuly extracted ' . count((array) $followersList->ids) . ' records for search_key ' . $search_queue_record['search_key'], ''); searchRecordUpdateCursor($search_queue_record['id'], $followersList->next_cursor_str); } elseif ($search_type == 'search_by_keyword') { //search by keyword $tweetsRequestsRemaining--; if ($this_cursor > 0) { $content = $connection->get('search/tweets', array('q' => $search_queue_record['search_key'], 'count' => TWITTER_TWEET_SEARCH_PP, 'include_entities' => false, 'max_id' => $this_cursor)); } else { $content = $connection->get('search/tweets', array('q' => $search_queue_record['search_key'], 'count' => TWITTER_TWEET_SEARCH_PP, 'include_entities' => false));
//Defines $connection = new TwitterOAuth($ap_creds['consumer_key'], $ap_creds['consumer_secret'], $q1a['oauth_token'], $q1a['oauth_token_secret']); $cron->set_user_id($q1a['id']); $cron->set_log($q1a['log_data']); //Time can vary between PHP and server if server timezone doesn't match PHP timezone. //All scripts use PHP time rather than NOW() to avoid issues. $current_time = date("Y-m-d H:i:s"); //Get scheduled tweets for this user older than or equal to current time $q2 = $db->query("SELECT * FROM " . DB_PREFIX . "scheduled_tweets WHERE owner_id = '" . $db->prep($q1a['id']) . "' AND time_to_post != '0000-00-00 00:00:00' AND time_to_post <= '" . $db->prep($current_time) . "' ORDER BY time_to_post ASC"); while ($q2a = $db->fetch_array($q2)) { //Post the tweet $connection->post('statuses/update', array('status' => $q2a['tweet_content'])); //Log result - reasons for a non 200 include duplicate tweets, too many tweets //posted in a period of time, etc etc. if ($connection->http_code == 200) { $cron->store_cron_log(2, $cron_txts[18] . $q2a['tweet_content'] . $cron_txts[19], ''); } else { $cron->store_cron_log(2, $cron_txts[18] . $q2a['tweet_content'] . $cron_txts[20], ''); } //Delete the tweet $db->query("DELETE FROM " . DB_PREFIX . "scheduled_tweets WHERE owner_id = '" . $db->prep($q1a['id']) . "' AND id = '" . $q2a['id'] . "'"); } //End of db loop } //Optimize tweet table $db->query("OPTIMIZE TABLE " . DB_PREFIX . "scheduled_tweets"); //Set cron status $cron->set_cron_state('tweet', 0); echo mainFuncs::push_response(32); //End of run cron }
$db->output_error = 1; //Set cron status $cron->set_cron_state('robot_fw', 1); $cron->set_log(1); //Get credentials $ap_creds = $db->get_ap_creds(); $configs = $db->query("\n SELECT *\n FROM " . DB_PREFIX . "users_config\n WHERE follow_bot_status=1;\n"); while ($userConfig = mysql_fetch_array($configs, MYSQL_ASSOC)) { $counter = $userConfig['follow_rate']; $cron->set_user_id($userConfig['user_id']); $result = $db->query("\n SELECT user_id, related_user_id, screen_name\n FROM " . DB_PREFIX . "extracted_user_data\n WHERE datetime_robot_follow_{$userConfig['user_id']} IS NULL\n AND datetime_updated IS NOT NULL\n {$userConfig['follow_rule']}\n LIMIT {$counter}\n "); $friendshipCounter = array(); $protected_accs = 0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($db->is_on_fr_list($userConfig['user_id'], $row['user_id'])) { $cron->store_cron_log(3, 'Already in friend list ' . $row['screen_name'] . '.', ''); $followDateTime = date('Y-m-d H:i:s'); $db->query("UPDATE " . DB_PREFIX . "extracted_user_data\n SET datetime_robot_follow_{$userConfig['user_id']} = '{$followDateTime}'\n WHERE user_id='" . $row['user_id'] . "'"); continue; } $authUserData = $db->get_user_data($userConfig['user_id']); $connection = new TwitterOAuth($ap_creds['consumer_key'], $ap_creds['consumer_secret'], $authUserData['oauth_token'], $authUserData['oauth_token_secret']); $response = $connection->post('friendships/create', array('user_id' => $row['user_id'])); if (!$connection->http_code == 200) { $db->query("DELETE FROM " . DB_PREFIX . "extracted_user_data WHERE user_id='" . $row['user_id'] . "'"); } else { $followDateTime = date('Y-m-d H:i:s'); $db->query("UPDATE " . DB_PREFIX . "extracted_user_data\n SET datetime_robot_follow_{$userConfig['user_id']} = '{$followDateTime}'\n WHERE user_id='" . $row['user_id'] . "'"); if ($response->protected) { $protected_accs++; } else {