]>
git.sesse.net Git - pr0n/log
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.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:53:45 +0000 (01:53 +0200)]
IE tweak for the CSS.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:51:36 +0000 (01:51 +0200)]
Remove the non-fullscreen selection mode; it's rather obsolete with the
fullscreen mode existing.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:49:12 +0000 (01:49 +0200)]
Tweak the CSS and stuff beyond repair.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:34:16 +0000 (01:34 +0200)]
Remove the "font-size: smaller;", it's an abomination.
Steinar H. Gunderson [Wed, 11 Apr 2007 23:33:57 +0000 (01:33 +0200)]
Add a "fullscreen from here" button.
Steinar H. Gunderson [Mon, 26 Mar 2007 20:33:08 +0000 (22:33 +0200)]
Trim the EXIF values; seems like the Pentax K10D sometimes adds extra spaces
after its model.
Steinar H. Gunderson [Mon, 26 Mar 2007 20:14:02 +0000 (22:14 +0200)]
Add two missing templates.
Steinar H. Gunderson [Mon, 26 Mar 2007 20:11:59 +0000 (22:11 +0200)]
Add a counter for how much each equipment combination is used.
Steinar H. Gunderson [Mon, 26 Mar 2007 19:57:46 +0000 (21:57 +0200)]
Add an “equipment used” header on top of all image listings.
Steinar H. Gunderson [Mon, 26 Mar 2007 19:04:53 +0000 (21:04 +0200)]
Update the EXIF stuff in a transaction, speeding it up a bit and making
it all a bit more sane.
Steinar H. Gunderson [Mon, 26 Mar 2007 19:03:23 +0000 (21:03 +0200)]
Delete EXIF information when deleting an image.
Steinar H. Gunderson [Mon, 26 Mar 2007 19:02:27 +0000 (21:02 +0200)]
Add a script which adds EXIF information for all images lacking it.
Steinar H. Gunderson [Mon, 26 Mar 2007 18:36:43 +0000 (20:36 +0200)]
Allow latin1 in EXIF info.
Steinar H. Gunderson [Mon, 26 Mar 2007 18:24:44 +0000 (20:24 +0200)]
Check ExposureCompensation for exposure bias values; I don't know if this
has something to do with my camera or with the change to Image::ExifTool,
but at least it should work properly now.
Steinar H. Gunderson [Mon, 26 Mar 2007 18:15:28 +0000 (20:15 +0200)]
Add a new table "exif_info" which contains all the EXIF tags for all images.
Steinar H. Gunderson [Tue, 20 Mar 2007 17:15:17 +0000 (18:15 +0100)]
Eh. Maxiumum? Fix. :-)
Steinar H. Gunderson [Sun, 18 Mar 2007 19:08:41 +0000 (20:08 +0100)]
Bla bla. :-P
Steinar H. Gunderson [Mon, 22 Jan 2007 23:07:13 +0000 (00:07 +0100)]
Escape titles and dates on their way out of the HTML. It _shouldn't_ be
possible under the current regime to get illegal characters into the database,
but we had one such event, so just do it to be safe; it doesn't harm.
(One might actually also want to fix WebDAV; should be checked, but hey...)
Steinar H. Gunderson [Thu, 11 Jan 2007 13:46:23 +0000 (14:46 +0100)]
Bump version number.
Steinar H. Gunderson [Thu, 11 Jan 2007 13:45:51 +0000 (14:45 +0100)]
Use progressive JPEG for larger images -- not because it makes them load so much
prettier (hopefully the precaching will take that anyhow), but because we gain
about 4% file size for free.
Steinar H. Gunderson [Wed, 10 Jan 2007 17:34:04 +0000 (18:34 +0100)]
Update the SVURR header.
Steinar H. Gunderson [Fri, 5 Jan 2007 21:19:41 +0000 (22:19 +0100)]
Make sure rotation and selection invalidate the listing cache.
Steinar H. Gunderson [Tue, 2 Jan 2007 23:02:25 +0000 (00:02 +0100)]
Bump the version number, bump the copyright, and update the FAQ.
Steinar H. Gunderson [Tue, 2 Jan 2007 22:59:49 +0000 (23:59 +0100)]
Add wizard specialization for skoyen.bilder.knatten.com too.