function guestbook_update_5200 in Guestbook 5.2

Rename permission "administer all guestbooks" to "moderate all guestbooks".

File

./guestbook.install, line 55

Code

function guestbook_update_5200() {
  $ret = array();
  $result = db_query("SELECT rid, perm FROM {permission} ORDER BY rid");
  while ($role = db_fetch_object($result)) {
    $renamed_permission = strtr($role->perm, array(
      'administer all guestbooks' => 'moderate all guestbooks',
    ));
    if ($renamed_permission != $role->perm) {
      $ret[] = update_sql("UPDATE {permission} SET perm = '{$renamed_permission}' WHERE rid = " . $role->rid);
    }
  }
  return $ret;
}