--- twitter.inc 17 Jan 2009 20:01:05 -0000 1.3.2.6 +++ twitter.inc 14 Mar 2009 01:31:18 -0000 @@ -396,9 +396,9 @@ */ function twitter_get_user_accounts($uid, $only_with_passwords = FALSE) { - $sql = "SELECT ta.*, tu.uid, tu.password, tu.import FROM {twitter_user} tu LEFT JOIN {twitter_account} ta ON (tu.screen_name = ta.screen_name) WHERE tu.uid = %d"; + $sql = "SELECT ta.*, tu.uid, tu.screen_name, tu.password, tu.import FROM {twitter_user} tu LEFT JOIN {twitter_account} ta ON (tu.screen_name = ta.screen_name) WHERE tu.uid = %d"; if ($only_with_passwords) { - $sql .= " AND tu.password IS NOT NULL"; + $sql .= " AND tu.password != ''"; } $args = array($uid); $results = db_query($sql, $args); Index: twitter.module =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/twitter/twitter.module,v retrieving revision 1.3.2.5 diff -u -r1.3.2.5 twitter.module --- twitter.module 10 Feb 2009 19:33:00 -0000 1.3.2.5 +++ twitter.module 14 Mar 2009 01:31:18 -0000 @@ -93,8 +93,9 @@ '!tinyurl' => twitter_shorten_url(url('node/'. $node->nid, array('absolute' => TRUE))), '!user' => $node->name); $status = strtr($node->twitter['status'], $replacements); - $pass = $twitter_accounts[$node->twitter['account']]['password']; - twitter_set_status($node->twitter['account'], $pass, $status); + foreach($twitter_accounts as $twitter_account) { + twitter_set_status($twitter_account['screen_name'], $twitter_account['password'], $status); + } drupal_set_message(t('Successfully posted to Twitter')); } break;