check_media_records

Versions

mediamosa-21 – mediamosa-174

check_media_records()

Code

integrity_check/integrity_check.php, line 73

<?php
function check_media_records() {

  $resource = db_query("SELECT m.mediafile_id, m.created, m.changed, asset_id_root, app_id, owner_id, filesize, mime_type FROM {mediafile} m LEFT JOIN {mediafile_metadata} using (mediafile_id) WHERE m.is_still = 'FALSE'");
  while ($mediafile = db_fetch_array($resource)) {
    // check if file exists
    $file = SAN_NAS_BASE_PATH. DS . DATA_LOCATION . DS . $mediafile['mediafile_id']{0} . DS . $mediafile['mediafile_id'];
    if (!file_exists($file)) {
      db_query("INSERT INTO {log_integrity_check} (type, object_id, app_id, owner_id, created, changed, details) VALUES " .
               "('missing mediafile', '%s', %d, '%s', '%s', '%s', '%s')",
               $mediafile['mediafile_id'], $mediafile['app_id'], $mediafile['owner_id'],
               $mediafile['created'], $mediafile['changed'],
               ($mediafile['filesize'] == '') ? 'Never succesfully analysed...' : 'Mime-type: ' . $mediafile['mime_type']);
    }
    usleep(10000); //sleep 0.01 seconds *100.000 mediafiles= 17 minuten
  }
}
?>