getRow( sprintf('SELECT id, username, oauth_token, oauth_token_secret FROM twitter_user WHERE username="%s"', mysqli_real_escape_string($mtdb->link, $user))); $username = $row->username; $oauth_token = $row->oauth_token; $oauth_token_secret = $row->oauth_token_secret; $connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $oauth_token, $oauth_token_secret); $parameters = array('status' => $message ); $status = $connection->post('statuses/update', $parameters); switch( $connection->http_code ) { case 200: adminlog("Twitter post succeeded for user $username!", MTS_TWITTER, MTA_ADD); return true; default: adminlog("Twitter post failed for user $username!", MTS_TWITTER, MTA_ADD); return false; } } } function setOAuthTokens($userid,$oauth_token,$oauth_token_secret, $username) { global $mtdb; $id = (int)$userid; if( $mtdb->query( sprintf('UPDATE twitter_user SET oauth_token="%s", oauth_token_secret="%s", username="%s" WHERE id=%d', mysql_real_escape_string($oauth_token), mysql_real_escape_string($oauth_token_secret), mysql_real_escape_string($username), $id )) ) return true; return false; } ?>