executeQuery('SELECT id, username, oauth_token, oauth_token_secret FROM twitter_user WHERE username = ?', array($user))->fetch(); $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 ($dbConnection->executeUpdate('UPDATE twitter_user SET oauth_token = ?, oauth_token_secret = ?, username = ? WHERE id = ?', array($oauth_token, $oauth_token_secret, $username, $id))) return true; return false; } ?>