]>
git.sesse.net Git - pr0n/log
Steinar H. Gunderson [Sun, 2 Sep 2007 15:36:29 +0000 (17:36 +0200)]
Handle files ending in .NEF, not just .nef.
Steinar H. Gunderson [Sun, 2 Sep 2007 13:44:12 +0000 (15:44 +0200)]
Rework the infobox code. (Not 100% satisfied with the vertical placement,
perhaps, but should work OK.) The biggest user-visible change is that shutter
time or f-number is bolded if the picture was taken using the respective
priority program mode.
Steinar H. Gunderson [Mon, 27 Aug 2007 07:49:00 +0000 (09:49 +0200)]
Push v2.51 -- too many bugfixes to let the version number stay.
Steinar H. Gunderson [Mon, 27 Aug 2007 07:46:34 +0000 (09:46 +0200)]
Fix a bug where the fullscreen code would ask for "1600x1087" etc. due to
the cropping code modifying fixed_sizes when it shouldn't.
Steinar H. Gunderson [Sat, 25 Aug 2007 01:02:17 +0000 (03:02 +0200)]
In fullscreen mode, crop the image div to the screen. This makes sure the
new "oversized"-image code doesn't make a div that is too high and allows
the user to scroll by accident.
Steinar H. Gunderson [Sat, 25 Aug 2007 00:34:49 +0000 (02:34 +0200)]
Yet more issues with the -1 width/height transformation -- this time, fix
so WebDAV uploads get cached at upload time again.
Steinar H. Gunderson [Wed, 22 Aug 2007 06:24:48 +0000 (08:24 +0200)]
We want the human-readable values for the EXIF stuff, not the machine-readable
ones.
Steinar H. Gunderson [Wed, 22 Aug 2007 06:06:49 +0000 (08:06 +0200)]
Fix a double-correction that would mess up images where width=NULL/height=NULL.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:25:33 +0000 (07:25 +0200)]
Bump the version number to 2.50, and update the FAQ.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:23:44 +0000 (07:23 +0200)]
Add a no less true, but slightly more encouraging comment.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:22:43 +0000 (07:22 +0200)]
Add a sad but true warning.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:22:26 +0000 (07:22 +0200)]
Make upgrade SQL for the empty-is-NULL change as well.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:18:29 +0000 (07:18 +0200)]
Treat empty lens/model as NULL. Doesn't actually appear to happen much in
practice.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:16:56 +0000 (07:16 +0200)]
Don't forget deleted_images, again. Grmf.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:15:46 +0000 (07:15 +0200)]
Query against the new model/lens fields instead of the exif_info table.
Significantly less complex queries.
Steinar H. Gunderson [Tue, 21 Aug 2007 05:12:06 +0000 (07:12 +0200)]
Add model/lens fields to the images table, and make upgrade code to populate
the fields. Also make update_image_info() populate them on new uploads etc.
The idea is to get rid of all SELECTs against exif_info, as EAV is quite evil
and is not needed in this case.
Steinar H. Gunderson [Tue, 21 Aug 2007 04:49:25 +0000 (06:49 +0200)]
Remember to do the width/height -1 => NULL change in the actual original schema
as well. Also remember to do deleted_images, not just images.
Steinar H. Gunderson [Tue, 21 Aug 2007 04:28:51 +0000 (06:28 +0200)]
Remove some really long-standing silliness: If we have no idea about width
or height, we used to have -1 as a default, and have the field NOT NULL.
SQL has a perfectly good value for "unknown data" -- it's called NULL. Make
upgrade SQL, and clean up the few code places that was used to the field being
-1.
Steinar H. Gunderson [Tue, 21 Aug 2007 04:19:21 +0000 (06:19 +0200)]
Update the fullscreen mode to handle non-4:3 images and non-4:3 screen
areas a lot better. This should overall select the largest image available
(from the list of fixed maximum sizes) that will fit in the client area,
without rounding down to nearest 4:3 size twice. (IOW, it can show a
640x320 image in a 640x320 client area, even though 640x320 isn't large
enough for a generic 640x480 image.)
Steinar H. Gunderson [Mon, 20 Aug 2007 18:36:45 +0000 (20:36 +0200)]
Resolution boost!
Steinar H. Gunderson [Sun, 5 Aug 2007 13:21:29 +0000 (15:21 +0200)]
Fix yet more grouping bugs.
Steinar H. Gunderson [Sun, 5 Aug 2007 08:58:23 +0000 (10:58 +0200)]
Fix a warning.
Steinar H. Gunderson [Sun, 29 Jul 2007 16:50:00 +0000 (18:50 +0200)]
Fix a bug that was introduced by the previous bug :-)
Steinar H. Gunderson [Sun, 29 Jul 2007 16:48:32 +0000 (18:48 +0200)]
Fix an over-grouping bug.
Steinar H. Gunderson [Thu, 26 Jul 2007 13:53:30 +0000 (15:53 +0200)]
Change default to 250.
Steinar H. Gunderson [Thu, 26 Jul 2007 12:41:01 +0000 (14:41 +0200)]
Bump version number.
Steinar H. Gunderson [Thu, 26 Jul 2007 12:39:31 +0000 (14:39 +0200)]
Add a link from the front page to the tag cloud (and back) if there are any
tags.
Steinar H. Gunderson [Thu, 26 Jul 2007 00:14:04 +0000 (02:14 +0200)]
Yes, () in uploaded files too.
Steinar H. Gunderson [Thu, 26 Jul 2007 00:13:38 +0000 (02:13 +0200)]
Allow () in filenames.
Steinar H. Gunderson [Thu, 26 Jul 2007 00:09:30 +0000 (02:09 +0200)]
Remove the "single" debugging code that has probably been there for ages and
allowed free access to all pictures. Ouch! =)
Steinar H. Gunderson [Thu, 26 Jul 2007 00:03:45 +0000 (02:03 +0200)]
Fiddle a bit with the pretty-escaping.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:57:36 +0000 (01:57 +0200)]
When filtering/unfiltering, start at 1.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:55:14 +0000 (01:55 +0200)]
Move the filter link to a slightly more logical, but uglier place.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:49:46 +0000 (01:49 +0200)]
Fix a validation bug.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:48:21 +0000 (01:48 +0200)]
Implement author filtering.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:43:31 +0000 (01:43 +0200)]
Fuse rot=1 and rot=0 arms into a single loop, reducing the amount of identical
code.
Steinar H. Gunderson [Wed, 25 Jul 2007 23:17:03 +0000 (01:17 +0200)]
Micro-modularization.
Steinar H. Gunderson [Wed, 25 Jul 2007 18:39:17 +0000 (20:39 +0200)]
Add support for /+tags/foo.
Steinar H. Gunderson [Wed, 25 Jul 2007 17:55:35 +0000 (19:55 +0200)]
Add a redirect for /+tags -> /+tags/.
Steinar H. Gunderson [Wed, 25 Jul 2007 16:15:41 +0000 (18:15 +0200)]
Fix tons of JSLint issues.
Steinar H. Gunderson [Wed, 25 Jul 2007 14:43:53 +0000 (16:43 +0200)]
Update the module list.
Steinar H. Gunderson [Wed, 25 Jul 2007 14:42:51 +0000 (16:42 +0200)]
Document that we need HTML::TagCloud.
Steinar H. Gunderson [Wed, 25 Jul 2007 14:41:50 +0000 (16:41 +0200)]
Add a tag cloud.
Steinar H. Gunderson [Wed, 25 Jul 2007 13:48:34 +0000 (15:48 +0200)]
Insert tags into the tags table on upload/other update.
Steinar H. Gunderson [Wed, 25 Jul 2007 13:37:31 +0000 (15:37 +0200)]
Create a tag table.
Steinar H. Gunderson [Wed, 25 Jul 2007 13:16:37 +0000 (15:16 +0200)]
Allow more work_mem when upgrading.
Steinar H. Gunderson [Wed, 25 Jul 2007 13:15:44 +0000 (15:15 +0200)]
Rename "tag" to "key" in exif_info table, and make a small SQL script to do
just that.
Steinar H. Gunderson [Wed, 25 Jul 2007 13:11:10 +0000 (15:11 +0200)]
Cluster exif_info on the tag field; it seems to help quite a lot for the
equipment query.
Steinar H. Gunderson [Wed, 25 Jul 2007 12:53:13 +0000 (14:53 +0200)]
Syntax highlighting woes.
Steinar H. Gunderson [Wed, 25 Jul 2007 11:18:31 +0000 (13:18 +0200)]
Fix the "filter" link to keep the right settings.
Steinar H. Gunderson [Wed, 25 Jul 2007 11:12:22 +0000 (13:12 +0200)]
Fix a few XSS-ish issues.
Steinar H. Gunderson [Wed, 25 Jul 2007 10:41:12 +0000 (12:41 +0200)]
Fix language a bit.
Steinar H. Gunderson [Wed, 25 Jul 2007 10:35:02 +0000 (12:35 +0200)]
Implement unfiltering.
Steinar H. Gunderson [Wed, 25 Jul 2007 10:28:35 +0000 (12:28 +0200)]
Actually implement filtering.
Steinar H. Gunderson [Wed, 25 Jul 2007 10:12:28 +0000 (12:12 +0200)]
Start adding the filter links for the equipment list.
Steinar H. Gunderson [Wed, 25 Jul 2007 10:00:37 +0000 (12:00 +0200)]
Add the equipment list back into +all for now.
Steinar H. Gunderson [Wed, 25 Jul 2007 09:48:47 +0000 (11:48 +0200)]
Create an index that is sometimes helpful in speeding up the equipment
queries.
Steinar H. Gunderson [Tue, 24 Jul 2007 23:03:11 +0000 (01:03 +0200)]
Add templated versions of the all-event-title template.
Steinar H. Gunderson [Tue, 24 Jul 2007 22:47:19 +0000 (00:47 +0200)]
Fix the fullscreen mode for +all. Probably fixes some infobox+select bugs while
we're at it.
Steinar H. Gunderson [Tue, 24 Jul 2007 22:13:58 +0000 (00:13 +0200)]
Order so NULLs get last.
Steinar H. Gunderson [Tue, 24 Jul 2007 21:36:14 +0000 (23:36 +0200)]
Remove an unneeded ORDER BY.
Steinar H. Gunderson [Tue, 24 Jul 2007 21:34:19 +0000 (23:34 +0200)]
Fuse $evselect into $where.
Steinar H. Gunderson [Tue, 24 Jul 2007 21:24:46 +0000 (23:24 +0200)]
Start implementing the +all option.
Steinar H. Gunderson [Tue, 24 Jul 2007 21:08:59 +0000 (23:08 +0200)]
Make an “all images” pseudo-event in the menu.
Steinar H. Gunderson [Tue, 24 Jul 2007 20:50:23 +0000 (22:50 +0200)]
Kill the limit in the equipment list.
Steinar H. Gunderson [Tue, 24 Jul 2007 20:45:44 +0000 (22:45 +0200)]
Fix a typo that would prevent sampling factor changes.
Steinar H. Gunderson [Tue, 24 Jul 2007 20:18:57 +0000 (22:18 +0200)]
Bump version number to 2.41.
Steinar H. Gunderson [Mon, 23 Jul 2007 09:26:55 +0000 (11:26 +0200)]
Up the quality of the thumbnails again, but now also with larger scaling
factors.
Steinar H. Gunderson [Mon, 23 Jul 2007 09:23:05 +0000 (11:23 +0200)]
Do dcraw delegation stuff ourselves, which should hopefully finally fix the
NEF-and-threading bugs.
Steinar H. Gunderson [Sun, 22 Jul 2007 19:29:11 +0000 (21:29 +0200)]
Make the foreign key from image to exif_info cascade on delete.
Steinar H. Gunderson [Fri, 20 Jul 2007 23:53:01 +0000 (01:53 +0200)]
Oops, the unique_filenames index should really be unique.
Steinar H. Gunderson [Tue, 3 Jul 2007 11:50:35 +0000 (13:50 +0200)]
Add a new internal vhost. (Gee.)
Steinar H. Gunderson [Tue, 3 Jul 2007 11:46:41 +0000 (13:46 +0200)]
Fix the wizard for the new SQL structure.
Steinar H. Gunderson [Fri, 29 Jun 2007 15:04:37 +0000 (17:04 +0200)]
Make the front page cacheable.
Steinar H. Gunderson [Sun, 24 Jun 2007 18:51:23 +0000 (20:51 +0200)]
Allow parenthesises in the file name.
Steinar H. Gunderson [Sun, 24 Jun 2007 18:48:46 +0000 (20:48 +0200)]
Unbreak WebDAV listing with the new database structure.
Steinar H. Gunderson [Fri, 22 Jun 2007 21:35:41 +0000 (23:35 +0200)]
Revert r147, as planned.
Steinar H. Gunderson [Fri, 22 Jun 2007 21:11:45 +0000 (23:11 +0200)]
Try to use XML::TemplateSAX. Not too happy with it in this case, though,
so I'll revert in the next commit.
Steinar H. Gunderson [Fri, 22 Jun 2007 20:30:18 +0000 (22:30 +0200)]
Update the FAQ version.
Steinar H. Gunderson [Tue, 19 Jun 2007 13:15:53 +0000 (15:15 +0200)]
Make some sorely needed changes to the SQL schema, and update the code
accordingly (I really hope I fixed everything; I've done some testing, and
it seems largely OK). The biggest change is that the event primary key is
now (vhost,event) and not just (event), which is rippling through all the
tables; this means the vhosts are finally truly independent. Also clean up
to remove some old length restrictions from the MySQL days.
Steinar H. Gunderson [Sun, 13 May 2007 23:51:06 +0000 (01:51 +0200)]
Support >1 sec exposure times in EXIF.
Steinar H. Gunderson [Mon, 30 Apr 2007 17:26:02 +0000 (19:26 +0200)]
Merged SQL-fixes from Tollef.
Tollef Fog Heen [Mon, 30 Apr 2007 17:23:23 +0000 (19:23 +0200)]
Grant permissions to last_picture_cache too
Tollef Fog Heen [Mon, 30 Apr 2007 17:23:06 +0000 (19:23 +0200)]
it is images_id_seq, not imageid_seq, fix in GRANT statement
Steinar H. Gunderson [Sat, 28 Apr 2007 15:36:11 +0000 (17:36 +0200)]
Drop an unneeded $r->subprocess_env.
root [Thu, 26 Apr 2007 23:06:47 +0000 (01:06 +0200)]
Fix UTF-8 issues in quotes.
root [Thu, 26 Apr 2007 23:05:59 +0000 (01:05 +0200)]
Update ITK templates.
Steinar H. Gunderson [Fri, 13 Apr 2007 14:06:32 +0000 (16:06 +0200)]
Dashify.
Steinar H. Gunderson [Fri, 13 Apr 2007 14:04:50 +0000 (16:04 +0200)]
FAQ update.
root [Fri, 13 Apr 2007 13:37:41 +0000 (15:37 +0200)]
Feh.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:17:18 +0000 (02:17 +0200)]
Update the FAQ date.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:14:37 +0000 (02:14 +0200)]
Off-by-one. Fix.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:13:12 +0000 (02:13 +0200)]
Make sure $img_num always starts a reasonable place, even if returning from
fullscreen.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:08:45 +0000 (02:08 +0200)]
Version number bump.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:07:35 +0000 (02:07 +0200)]
Make the next/prev right when all=0.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:06:11 +0000 (02:06 +0200)]
Make the next/previous stuff a bit more accessible.
Steinar H. Gunderson [Thu, 12 Apr 2007 00:04:01 +0000 (02:04 +0200)]
Make the equipment list mirror the current selection.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:57:36 +0000 (01:57 +0200)]
Minor code cleanup.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:55:33 +0000 (01:55 +0200)]
Ignore the Webalizer directory.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:55:06 +0000 (01:55 +0200)]
Update the numbers in the FAQ.