From e60b5468afe0a0d6aa9dab2e6dcf9d186dd168fd Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sat, 8 Nov 2014 17:25:31 +0100 Subject: WIP Signed-off-by: Florian Pritz --- application/controllers/file.php | 59 ++++++++++++++++++++++------------------ 1 file changed, 33 insertions(+), 26 deletions(-) (limited to 'application/controllers') diff --git a/application/controllers/file.php b/application/controllers/file.php index 2617d4840..25fbd27e3 100644 --- a/application/controllers/file.php +++ b/application/controllers/file.php @@ -90,7 +90,7 @@ class File extends MY_Controller { $etag = ""; foreach ($files as $filedata) { - $etag = sha1($etag.$filedata["hash"]); + $etag = sha1($etag.$filedata["data_id"]); } // handle some common "lexers" here @@ -128,7 +128,7 @@ class File extends MY_Controller { handle_etag($etag); $filedata = $files[0]; - $filepath = $this->mfile->file($filedata["hash"]); + $filepath = $this->mfile->file($filedata["data_id"]); $this->ddownload->serveFile($filepath, $filedata["filename"], "text/plain"); exit(); } @@ -136,7 +136,7 @@ class File extends MY_Controller { $this->load->library("output_cache"); foreach ($files as $key => $filedata) { - $file = $this->mfile->file($filedata['hash']); + $file = $this->mfile->file($filedata['data_id']); // autodetect the lexer for highlighting if the URL contains a / after the ID (/ID/) // /ID/lexer disables autodetection @@ -272,9 +272,9 @@ class File extends MY_Controller { { // highlight the file and cache the result, fall back to plain text if $lexer fails foreach (array($lexer, "text") as $lexer) { - $highlit = cache_function($filedata['hash'].'_'.$lexer, 100, + $highlit = cache_function($filedata['data_id'].'_'.$lexer, 100, function() use ($filedata, $lexer, $is_multipaste) { - $file = $this->mfile->file($filedata['hash']); + $file = $this->mfile->file($filedata['data_id']); if ($lexer == "rmd") { ob_start(); @@ -323,7 +323,7 @@ class File extends MY_Controller { private function _tooltip_for_image($filedata) { $filesize = format_bytes($filedata["filesize"]); - list($width, $height) = getimagesize($this->mfile->file($filedata["hash"])); + list($width, $height) = getimagesize($this->mfile->file($filedata["data_id"])); $upload_date = date("r", $filedata["date"]); $tooltip = "${filedata["id"]} - $filesize
"; @@ -405,7 +405,7 @@ class File extends MY_Controller { $filename = $filedata["id"]."-".$filedata["filename"]; } assert(!isset($seen[$filename])); - $a->addFile($this->mfile->file($filedata["hash"]), $filename); + $a->addFile($this->mfile->file($filedata["data_id"]), $filename); $seen[$filename] = true; } $archive->gzip_compress(); @@ -457,7 +457,7 @@ class File extends MY_Controller { if (count($ids) == 1) { $filedata = $this->mfile->get_filedata($id); - $file = $this->mfile->file($filedata['hash']); + $file = $this->mfile->file($filedata['data_id']); $type = $filedata['mimetype']; $lexer = $this->mfile->should_highlight($type); @@ -531,7 +531,7 @@ class File extends MY_Controller { $filedata = $this->mfile->get_filedata($repaste_id); if ($filedata !== false && $this->mfile->can_highlight($filedata["mimetype"])) { - $this->data["textarea_content"] = file_get_contents($this->mfile->file($filedata["hash"])); + $this->data["textarea_content"] = file_get_contents($this->mfile->file($filedata["data_id"])); } } @@ -568,11 +568,11 @@ class File extends MY_Controller { show_error("Failed to get file data"); } - $cache_key = $filedata['hash'].'_thumb_'.$thumb_size; + $cache_key = $filedata['data_id'].'_thumb_'.$thumb_size; $thumb = cache_function($cache_key, 100, function() use ($filedata, $thumb_size){ $CI =& get_instance(); - $img = new libraries\Image($this->mfile->file($filedata["hash"])); + $img = new libraries\Image($this->mfile->file($filedata["data_id"])); $img->makeThumb($thumb_size, $thumb_size); $thumb = $img->get(IMAGETYPE_JPEG); @@ -596,8 +596,9 @@ class File extends MY_Controller { $user = $this->muser->get_userid(); $query = $this->db - ->select('id, filename, mimetype, date, hash, filesize') + ->select('files.id, filename, mimetype, date, hash, hash_collision_counter, filesize') ->from('files') + ->join('file_storage', 'file_storage.id = files.file_storage_id') ->where('user', $user) ->where_in('mimetype', array('image/jpeg', 'image/png', 'image/gif')) ->order_by('date', 'desc') @@ -609,7 +610,7 @@ class File extends MY_Controller { continue; } $query[$key]["tooltip"] = $this->_tooltip_for_image($item); - $query[$key]["orientation"] = libraries\Image::get_exif_orientation($this->mfile->file($item["hash"])); + $query[$key]["orientation"] = libraries\Image::get_exif_orientation($this->mfile->file($item["data_id"])); } $this->data["items"] = $query; @@ -630,7 +631,7 @@ class File extends MY_Controller { // key: database field name; value: display name $fields = array( - "id" => "ID", + "files.id" => "ID", "filename" => "Filename", "mimetype" => "Mimetype", "date" => "Date", @@ -647,14 +648,16 @@ class File extends MY_Controller { $items = $this->db->select(implode(',', array_keys($fields))) ->from('files') + ->join('file_storage', 'file_storage.id = files.file_storage_id') ->where('user', $user) ->get()->result_array(); $query = $this->db->query(" - SELECT m.url_id id, sum(f.filesize) filesize, m.date, '' hash, '' mimetype, concat(count(*), ' file(s)') filename + SELECT m.url_id id, sum(fs.filesize) filesize, m.date, '' hash, '' mimetype, concat(count(*), ' file(s)') filename FROM multipaste m JOIN multipaste_file_map mfm ON m.multipaste_id = mfm.multipaste_id JOIN files f ON f.id = mfm.file_url_id + JOIN file_storage fs ON f.file_storage_id = fs.id WHERE m.user_id = ? GROUP BY m.url_id ", array($user))->result_array(); @@ -688,8 +691,9 @@ class File extends MY_Controller { $total_size = $this->db->query(" SELECT sum(filesize) sum FROM ( - SELECT DISTINCT hash, filesize + SELECT DISTINCT hash, hash_collision_counter, filesize FROM files + JOIN file_storage ON file_storage.id = files.file_storage_id WHERE user = ? ) sub ", array($user))->row_array(); @@ -950,6 +954,9 @@ class File extends MY_Controller { } foreach ($files as $key => $file) { + // FIXME: use refactored code from api-rework branch here + // FIXME: remove hash_collision_counter from db and simply use the + // ID (so we can atomically insert and the get the last_insert_id $limits = $this->muser->get_upload_id_limits(); $id = $this->mfile->new_id($limits[0], $limits[1]); $hash = md5_file($file['tmp_name']); @@ -1078,7 +1085,7 @@ class File extends MY_Controller { $small_upload_size = $this->config->item('small_upload_size'); - $query = $this->db->select('hash, id, user') + $query = $this->db->select('hash, hash_collision_counter, id, user') ->from('files') ->where('date <', $oldest_time) ->or_where('('.$this->db->_protect_identifiers('user').' = 0 AND ' @@ -1086,7 +1093,7 @@ class File extends MY_Controller { ->get()->result_array(); foreach($query as $row) { - $file = $this->mfile->file($row['hash']); + $file = $this->mfile->file($row['data_id']); if (!file_exists($file)) { $this->mfile->delete_id($row["id"]); continue; @@ -1095,10 +1102,10 @@ class File extends MY_Controller { if ($row["user"] == 0 || filesize($file) > $small_upload_size) { if (filemtime($file) < $oldest_time) { unlink($file); - $this->mfile->delete_hash($row["hash"]); + $this->mfile->delete_data_id($row["data_id"]); } else { $this->mfile->delete_id($row["id"]); - if ($this->mfile->stale_hash($row["hash"])) { + if ($this->mfile->stale_data_id($row["data_id"])) { unlink($file); } } @@ -1166,9 +1173,9 @@ class File extends MY_Controller { return; } - $hash = $file_data["hash"]; - $this->mfile->delete_hash($hash); - echo "removed hash \"$hash\"\n"; + $data_id = $file_data["data_id"]; + $this->mfile->delete_data_id($data_id); + echo "removed data_id \"$data_id\"\n"; } function update_file_metadata() @@ -1187,9 +1194,9 @@ class File extends MY_Controller { ->get()->result_array(); foreach ($query as $key => $item) { - $hash = $item["hash"]; - $filesize = intval(filesize($this->mfile->file($hash))); - $mimetype = $this->mfile->mimetype($this->mfile->file($hash)); + $data_id = $item["data_id"]; + $filesize = intval(filesize($this->mfile->file($data_id))); + $mimetype = $this->mfile->mimetype($this->mfile->file($data_id)); $this->db->where('hash', $hash) ->set(array( -- cgit v1.2.3-24-g4f1b