vpx_beheer_update_90

Versions

mediamosa-174

vpx_beheer_update_90()

Fix owner-update of an asset See MM issue 172

Code

vpx_beheer/vpx_beheer.install, line 1497

<?php
function vpx_beheer_update_90() {
  $ret = array();

  db_set_active('data');
  $rs = db_query("
    SELECT a.asset_id, a.owner_id
    FROM asset AS a
    INNER JOIN mediafile AS m ON a.asset_id = m.asset_id_root
    WHERE a.owner_id <> m.owner_id
    GROUP BY a.asset_id
    ");
  while ($rso = db_fetch_object($rs)) {
    db_query("UPDATE {mediafile} SET owner_id = '%s' WHERE asset_id_root = '%s'", $rso->owner_id, $rso->asset_id);
    db_query("UPDATE {job} SET owner = '%s' WHERE asset_id = '%s'", $rso->owner_id, $rso->asset_id);
  }
  db_set_active();

  db_set_active('data');
  $rs = db_query("
    SELECT a.asset_id, a.group_id
    FROM asset AS a
    INNER JOIN mediafile AS m ON a.asset_id = m.asset_id_root
    WHERE a.group_id <> m.group_id
    GROUP BY a.asset_id
    ");
  while ($rso = db_fetch_object($rs)) {
    db_query("UPDATE {mediafile} SET group_id = '%s' WHERE asset_id_root = '%s'", $rso->group_id, $rso->asset_id);
  }
  db_set_active();

  return $ret;
}
?>