function _uc_file_prune_db in Ubercart 6.2
Same name and namespace in other branches
- 8.4 uc_file/uc_file.module \_uc_file_prune_db()
- 7.3 uc_file/uc_file.module \_uc_file_prune_db()
Removes all db entries associated with a given $fid.
3 calls to _uc_file_prune_db()
- uc_file_empty in uc_file/
uc_file.module - Removes all downloadable files, as well as their associations.
- uc_file_remove_by_id in uc_file/
uc_file.module - Deletes files (or directories).
- _uc_file_prune_files in uc_file/
uc_file.module - Removes non-existent files.
File
- uc_file/
uc_file.module, line 1261
Code
function _uc_file_prune_db($fid) {
$pfids = db_query("SELECT pfid FROM {uc_file_products} WHERE fid = %d", $fid);
while ($pfid = db_fetch_object($pfids)) {
db_query("DELETE FROM {uc_product_features} WHERE pfid = %d AND fid = 'file'", $pfid->pfid);
db_query("DELETE FROM {uc_file_products} WHERE pfid = %d", $pfid->pfid);
}
db_query("DELETE FROM {uc_file_users} WHERE fid = %d", $fid);
db_query("DELETE FROM {uc_files} WHERE fid = %d", $fid);
}