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;
}
