function fb_user_update_6006 in Drupal for Facebook 6.2

Same name and namespace in other branches

1. 6.3 fb_user.install \fb_user_update_6006()

Originally, we wrote authmap entries like 'NNNNN@facebook.com'. This was necessary in D5. In D6 we can make queries more efficient using just the fbu ('NNNNN') as the authname, and 'fb_user' as the module.

File

./fb_user.install, line 142

Install file for fb_user.module.

Code

function fb_user_update_6006() {
  $ret = array();

  // Update authmap entries.  We no longer use '@facebook...'.
  $ret[] = update_sql("UPDATE {authmap} SET authname=SUBSTRING(authname, 1, LOCATE('@facebook.com', authname)-1) WHERE module='fb_user' AND LOCATE('@facebook.com', authname) > 1");
  return $ret;
}