function fetchFilesForProjectAllRevisions($id, $offset = 0, $rowsPerPage = 0) { $query = "SELECT * FROM projekat_file WHERE projekat='{$id}' AND file=0 ORDER BY vrijeme DESC "; if ($offset == 0 && $rowsPerPage == 0) { } else { $query .= "LIMIT {$offset}, {$rowsPerPage}"; } $result = myquery($query); $list = array(); while ($row = mysql_fetch_assoc($result)) { $list[] = $row; } mysql_free_result($result); $files = array(); foreach ($list as $item) { $files[] = fetchAllRevisionsForFile($item[id]); } return $files; }
function deleteFile($id) { global $conf_files_path; $list = fetchAllRevisionsForFile($id); foreach ($list as $item) { $query = sprintf("DELETE FROM projekat_file WHERE id='%d' LIMIT 1", intval($item[id])); $result = myquery($query); if (mysql_affected_rows() == 0) { return false; } $lokacijarevizije = "{$conf_files_path}/projekti/fajlovi/" . $item['projekat'] . '/' . $item['osoba'] . '/' . $item['filename'] . '/v' . $item['revizija']; if (!unlink($lokacijarevizije . '/' . $item[filename])) { return false; } if (!rmdir($lokacijarevizije)) { return false; } //remove any diffs for this file myquery("DELETE FROM projekat_file_diff WHERE file='" . $item[id] . "' LIMIT 1"); } $lokacijafajlova = "{$conf_files_path}/projekti/fajlovi/" . $list[0]['projekat'] . '/' . $list[0]['osoba'] . '/' . $list[0]['filename']; if (!rmdir($lokacijafajlova)) { return false; } return true; }