summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-10-31 16:15:30 +0100
committerYorhel <git@yorhel.nl>2010-10-31 16:15:30 +0100
commitb4b9284ddd4d5e4b1829b87612fbb77e8e6c5d7c (patch)
treeaab2f6608f5b1a194f50f787fdf87ec46a07edfa
parentf386ea11c7f7e7250ee68f0e2271d9c2eaa10605 (diff)
Added 1024x576 and 1280x800 screen resolutions
-rw-r--r--ChangeLog1
-rw-r--r--data/global.pl2
-rw-r--r--util/updates/update_2.12.sql5
3 files changed, 8 insertions, 0 deletions
diff --git a/ChangeLog b/ChangeLog
index 3f9cb586..021878cb 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -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;
+