Skipped {} around pm_index

function privatemsg_filter_get_author_data($account) {
 static $author_data;

  if (is_array($author_data)) {
    return $author_data;
  }
-  $sql = 'SELECT DISTINCT pm.author, u.name FROM {pm_message} pm INNER JOIN pm_index pmi ON pm.mid = pmi.mid INNER JOIN {users} u ON pm.author = u.uid WHERE pmi.uid = %d AND u.uid > 0 ORDER BY u.name';
+  $sql = 'SELECT DISTINCT pm.author, u.name FROM {pm_message} pm INNER JOIN {pm_index} pmi ON pm.mid = pmi.mid INNER JOIN {users} u ON pm.author = u.uid WHERE pmi.uid = %d AND u.uid > 0 ORDER BY u.name';
  $query = db_query($sql, $account->uid);

  $author_data = array();
  while ($result = db_fetch_object($query)) {
    $author_data[$result->author] = $result->name;
  }
  return $author_data;
}
CommentFileSizeAuthor
#1 pmf_d6.patch1.04 KBandypost

Comments

andypost’s picture

StatusFileSize
new1.04 KB

Forget about patch ...

berdir’s picture

Status: Needs review » Reviewed & tested by the community

Looks good, should be commited asap.

litwol’s picture

Version: » 6.x-1.x-dev
Status: Reviewed & tested by the community » Fixed

Committed to d6-dev

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.