diff options
author | Yorhel <git@yorhel.nl> | 2010-10-31 16:15:30 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-10-31 16:15:30 +0100 |
commit | b4b9284ddd4d5e4b1829b87612fbb77e8e6c5d7c (patch) | |
tree | aab2f6608f5b1a194f50f787fdf87ec46a07edfa | |
parent | f386ea11c7f7e7250ee68f0e2271d9c2eaa10605 (diff) |
Added 1024x576 and 1280x800 screen resolutions
-rw-r--r-- | ChangeLog | 1 | ||||
-rw-r--r-- | data/global.pl | 2 | ||||
-rw-r--r-- | util/updates/update_2.12.sql | 5 |
3 files changed, 8 insertions, 0 deletions
@@ -5,6 +5,7 @@ - Re-added /g/debug (for moderators) - Improved search - Display friendly message in the VN edit scr tab when no release is known + - Added 1024x576 and 1280x800 screen resolutions - Bugfix: only redirect VN search to VN page if page=1 - Bugfix: remove duplicate votes when merging tags (fixes a 500) - Bugfix: Multi::Anime: don't crash when anidb returns an invalid or empty year diff --git a/data/global.pl b/data/global.pl index 865a4432..3092e82f 100644 --- a/data/global.pl +++ b/data/global.pl @@ -86,9 +86,11 @@ our %S = (%S, [ '1024x768', '4:3' ], [ '1600x1200', '4:3' ], [ '640x400', 'widescreen' ], + [ '1024x576', 'widescreen' ], [ '1024x600', 'widescreen' ], [ '1024x640', 'widescreen' ], [ '1280x720 (720p)', 'widescreen' ], + [ '1280x800', 'widescreen' ], [ '1920x1080 (1080p)', 'widescreen' ], ], voiced => [ 0..4 ], diff --git a/util/updates/update_2.12.sql b/util/updates/update_2.12.sql index 4d3dc4a4..febb508b 100644 --- a/util/updates/update_2.12.sql +++ b/util/updates/update_2.12.sql @@ -7,3 +7,8 @@ ALTER TABLE vn ADD COLUMN c_search text; CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON vn FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify(); CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify(); + +-- two new resolutions have been added, array indexes have changed +UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 7; +UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 11; + |