function flashnode_delete in Flash Node 6.3

Same name and namespace in other branches

1. 5.6 flashnode.module \flashnode_delete()
2. 5.2 flashnode.module \flashnode_delete()
3. 5.3 flashnode.module \flashnode_delete()
4. 6.2 flashnode.module \flashnode_delete()

Implementation of hook_delete.

File

./flashnode.module, line 493

Code

function flashnode_delete($node) {

  // Get all files currently used by this node
  $result = db_query("SELECT DISTINCT {files}.* FROM {flashnode} INNER JOIN {files} ON {flashnode}.fid = {files}.fid WHERE {flashnode}.nid = %d", $node->nid);

  // Iterate through results and delete file and entry in {files}
  while ($file = db_fetch_object($result)) {

    // Delete all files associated with the node
    db_query("DELETE FROM {files} WHERE fid = %d", $file->fid);
    file_delete($file->filepath);
  }

  // Delete the entry from {flashnode}
  db_query("DELETE FROM {flashnode} WHERE nid = %d", $node->nid);
}