/** * Unregister file: delete record from table and remove file */ function unregister_for_recid2($recid, $needDelete) { if ($needDelete) { // find all files associated with this record $query = "select dtl_UploadedFileID from recDetails where dtl_RecID=" . $recid; $res = mysql_query($query); while ($row = mysql_fetch_array($res)) { deleteUploadedFiles($row[0]); } } //remove from database mysql_query('SET foreign_key_checks = 0'); mysql_query('delete from recUploadedFiles where ulf_ID in (select dtl_UploadedFileID from recDetails where dtl_RecID="' . $recid . '")'); mysql_query('SET foreign_key_checks = 1'); if (mysql_error()) { return mysql_error(); } else { return null; } }
if (@$_REQUEST['data']) { $data = json_decode(urldecode(@$_REQUEST['data']), true); } else { $rv['error'] = "Data not defined! Wrong request."; print json_format($rv); return; } //1. to remove from recUploadedFiles and delete file $files = $data['orphaned']; $ids = array(); foreach ($files as $file) { $ulf_ID = $file[0]; $isfound = $file[1]; //if true - find and delete file if in db root or uploaded files if ($isfound == 1) { deleteUploadedFiles($ulf_ID); } $ids[] = $ulf_ID; } if (count($ids) > 0) { mysql_query('delete from recUploadedFiles where ulf_ID in (' . implode(',', $ids) . ')'); if (mysql_error()) { $rv['error'] = "Cannot delete entries from recUploadedFiles. mySQL error: " . mysql_error(); print json_format($rv); return; } } //2. to remove from recUploadedFiles, recDetails $file_ids = $data['notfound']; if (count($file_ids) > 0) { mysql_query('delete from recDetails where dtl_UploadedFileID in (' . implode(',', $file_ids) . ')');