function gallery_assist_update_6108 in Gallery Assist 6

Implementation of hook_update_N().

File

./gallery_assist.install, line 931

Install, update and uninstall functions and DB tables for the Gallery Assist module.

Code

function gallery_assist_update_6108() {
  $ret = array();
  $result = db_query("SELECT gref FROM {gallery_assist} WHERE gref = gid");
  while ($r = db_fetch_array($result)) {
    $count = db_result(db_query("SELECT COUNT(pid) FROM {gallery_assist_item} WHERE gref = %d", $r['gref']));
    db_query("UPDATE {gallery_assist} SET items = %d WHERE gref = %d", $count, $r['gref']);
  }
  update_sql("ALTER TABLE {gallery_assist_item} ADD INDEX ix_gref ( gref )");
  update_sql("ALTER TABLE {gallery_assist_item} ADD INDEX ix_nid ( nid )");
  return $ret;
}