popsu-d7/sites/all/modules/publishcontent/publishcontent.install

<?php

function publishcontent_update_6001() {
  $ret = $node_types = array();
  $query = 'SELECT pid, perm FROM {permission}';
  $result = db_query($query);
  $update_sql = 'UPDATE {permission} SET perm = "%s" WHERE pid = %d';
  while ($row = db_fetch_array($result)) {
    $old_perm = $row['perm'];
    $subjects = array('*all*');
    $replacements = array('any');
    foreach (node_get_types() as $type) {
      $subjects[] = 'publish ' . check_plain($type->type) . ' content';
      $subjects[] = 'unpublish ' . check_plain($type->type) . ' content';
      $replacements[] = 'publish any ' . check_plain($type->type) . ' content';
      $replacements[] = 'unpublish any '. check_plain($type->type) . ' content';
    }
    $new_perm = str_replace($subjects, $replacements, $row['perm']);
    $ret[] = array('success' => db_query($update_sql, $new_perm, $row['pid']), 'query' => t('Updated permission set @set', array('@set' => $row['pid'])));
  }
  variable_set('menu_rebuild_needed', TRUE);
  return $ret;
}