query($query);
while ($row = $db->fetchByAssoc($results)) {
return true;
break;
}
}
function format_feed_tweets($db, $array, $limit)
{
if (strlen($array['text']) > $limit) {
$array['text'] = '
' . substr($array['text'], 0, $limit) . '. . .
View full Tweet
';
} else {
$array['text'] = '
' . $array['text'] . '
View on Twitter
';
}
$array['text'] = $db->quote($array['text']);
return $array['text'];
}
function replace_hashtags($db, $array)
{
$i = 0;
$count = count($array['entities']['hashtags']);
while ($i < $count) {
$array['text'] = str_replace('#' . $array['entities']['hashtags'][$i]['text'], "" . "#" . $array['entities']['hashtags'][$i]['text'] . "", $array['text']);
$i++;
}
return $array['text'];
}
function replace_users($db, $array)
{
$i = 0;
$count = count($array['entities']['user_mentions']);
while ($i < $count) {
$array['text'] = str_replace('@' . $array['entities']['user_mentions'][$i]['screen_name'], "" . "@" . $array['entities']['user_mentions'][$i]['screen_name'] . "", $array['text']);
$i++;
}
return $array['text'];
}
function duplicate_check($db, $text, $date)
{
$sql_check = "SELECT * FROM sugarfeed WHERE description = '" . $text . "' AND date_entered = '" . $date . "'";
$results = $db->query($sql_check);
while ($row = $db->fetchByAssoc($results)) {
return true;
break;
}
return false;
}
function check_auth($url)
{
$url = $url . "/include/social/twitter/twitter_auth/callback.php";
$config = '';
require_once('include/social/twitter/twitter_auth/twitteroauth/twitteroauth.php');
require('modules/Connectors/connectors/sources/ext/rest/twitter/config.php');
$settings = array(
'consumer_key' => $config['properties']['consumer_key'],
'consumer_secret' => $config['properties']['consumer_secret'],
);
/* Build TwitterOAuth object with client credentials. */
$connection = new TwitterOAuth($settings['consumer_key'], $settings['consumer_secret']);
/* Get temporary credentials. */
$request_token = $connection->getRequestToken($url);
/* Save temporary credentials to session. */
$_SESSION['oauth_token'] = $token = $request_token['oauth_token'];
$_SESSION['oauth_token_secret'] = $request_token['oauth_token_secret'];
$html = '';
/* Build authorize URL and redirect user to Twitter. */
$url = $connection->getAuthorizeURL($token);
$html = "Log into Twitter";
$_REQUEST['html'] = $html;
$_REQUEST['request_token'] = $request_token;
return $connection;
}