summaryrefslogtreecommitdiff
path: root/ChangeLog
AgeCommit message (Collapse)AuthorFilesLines
2010-11-25JS: Split script.js into a separate file for each languageYorhel1-1/+2
This greatly reduces the size of the Javascript file. The compressed size has been reduced with about 9kB, and is now a total of 14kB for en.js. A nice property of this is that more translations can be added without increasing the JS size. While I was at it, I made jsgen.pl also replace mt() function calls in cases where an exact TL string was requested without any additional arguments and/or formatting codes. This helped reduce the compressed size by about 1kB. My aim is to keep *all* the JS code of VNDB smaller than the jQuery core library, as a general "fuck you" towards users of large and bloated JS libraries. We must keep the VNDB page loading times lower than that of other sites, after all!
2010-11-22Reverted to the old selection box date selectorYorhel1-0/+1
This effectively reverts 799c9e44b1a1a7776609273733f67887a74e33bf.
2010-11-21Implemented the server side of the new release filter selectorYorhel1-0/+1
There's no validation of the filter string yet, and somehow I don't feel like adding that; it's a lot of code and there's nothing to protect - the values are inserted using parameters into a SELECT query, the worst thing that could happen is the user receiving a 500. Also, I've started using the perl '//=' operator, which was added in 5.10. This removes support for older perls.
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-0/+1
This makes deleting user accounts less error prone. It also seems I forgot to git add update_2.14.sql in an earlier commit, sorry about that.
2010-11-14SQL: Added WHEN clause to all TRIGGERs for which it was usefulYorhel1-0/+2
This effectively removes compatibility with all PostgreSQL versions below 9.0. The use of the WHEN clause has two major advantages: 1. Performance: Trigger functions aren't executed when they don't need to. 2. Easier and more general trigger functions; as some of the logic has been placed in the trigger definitions now.
2010-11-14Improved performance of update_vnpopularity() on PostgreSQL 9.0Yorhel1-0/+1
Back from 180s to ~5 or ~6 seconds. It used to be quite fast on PostgreSQL 8.4, but somehow the planner failed to generate a proper execution plan for that query after the upgrade. This query is fast 9.0.
2010-11-13Multi::Feed: Added Atom feedsYorhel1-0/+4
TODO: add links to these feeds from the site
2010-11-11ChangeLog version 2.13 bump2.13Yorhel1-1/+1
2010-11-11Bugfix: reverting a VN image now worksYorhel1-0/+1
This is a very old bug. Never fixed it before because I couldn't think of a clean/easy solution and it wasn't important to waste my time on.
2010-11-11Display releases grouped by VNs on producer pagesYorhel1-0/+1
A nice expanded view. It also happens to be faster than the old view in terms of SQL queries. (In most cases at least) Can be improved a little more by: - Adding an 'expand/collapse' feature to list only the VNs - Adding a column indicating the role of the producer (dev/pub)
2010-11-11Replaced Algorithm::Diff::XS with Algorithm::Diff::FastYorhel1-0/+1
This module is cleaner, faster and has less dependencies. (didn't exist yet at the time I first implemented the revision diffs)
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-0/+1
This is the first part. The flag is stored in the database, can be edited through the usual VN edit form, and is displayed in the diff viewer. Things to do to make this feature fully functional: - display "official" status on VN page at the relation listing - update relation graphs to display unofficial relations differently - update guidelines
2010-11-10Removed (p###) from release resolution informationYorhel1-0/+1
Not very useful, anyway.
2010-11-09Added human confirmation question to the registration pageYorhel1-1/+2
Just a simple question.
2010-11-07DB::Misc: Optimized dbRevisionGet()Yorhel1-1/+4
The code is a bit more complicated now, and it's not a lot faster, but at least this helps a bit.
2010-11-07Optimized random VN fetching queryYorhel1-1/+1
Similar to ab64b573846da39622b8d430b079d7e8806a35d3, but with a few more constraints as dbVNGet() is a more generic function. This and the other commit greatly improve the page generation time of the homepage. From ~250ms to ~110ms in my tests.
2010-11-07Optimized random screenshot fetching queryYorhel1-0/+1
By rewriting the query and using the trick documented here: http://blog.rhodiumtoad.org.uk/2009/03/08/selecting-random-rows-from-a-table/ Can be further optimized by putting an index on vn_screenshots.scr
2010-11-06Bugfix: delete/update all references when deleting a userYorhel1-0/+1
Really need a cleaner solution for that. PostgreSQL actually provides a better solution, need to change to that.
2010-11-06URL change: /u/logout => /u$id/logoutYorhel1-1/+2
Also fixes a cross-site request forgery vulnerability. Not as strong as the others but it's not very crucial anyway.
2010-11-06Fixed cross-site request forgery vulnerabilitiesYorhel1-0/+4
2010-11-03ChangeLog update for 2.122.12Yorhel1-1/+4
2010-11-03Automatically remove duplicate aliases on /v+/editYorhel1-0/+1
And clean up the alias field before it gets inserted into the DB. Does not provide any feedback to the user, let's just hope our users are clever enough to figure out what happened.
2010-11-03Use newlines to separate VN aliasesYorhel1-0/+1
2010-11-03Compressed the thread listing into one row per threadYorhel1-0/+1
2010-11-02Automatically read L10N keys from script.jsYorhel1-0/+1
This makes jsgen.pl a bit easier to maintain, as there's not one reliable source to get the keys from (namely, the JS code itself). Also cleaned up the l10n() function in jsgen.pl to be more readable. I had expected the new .js file to be smaller because this trick may remove some keys that were previously present but unused. Unfortunately it seems the file only grew a bit larger and compression seems to be less effective now. No idea why this happened. :-(
2010-11-02Prefix all cookies with a configurable cookie_prefixYorhel1-0/+1
This replaces the "cookie_auth" setting, and applies to all cookies in use by VNDB.
2010-11-02Handler::(Misc|VNPage): Added HTML width/height to screenshot thumbnailsYorhel1-0/+1
And made sure the dimensions are truncated in VNDBUtil::imgsize(). Setting the width/height attributes makes sure that the browser can reserve space for the image when it hasn't been loaded yet, which prevents the overall page layout from changing while the images are loading. (which is annoying if your connection isn't all that fast)
2010-11-02Removed XML sitemapYorhel1-0/+1
Was growing too large and isn't really necessary anymore, now that VNDB is indexed quite well in most search engines.
2010-11-01Properly order the relations listed on producer pagesYorhel1-0/+1
And changed the order a bit, as suggested by ImmLff.
2010-11-01Added Apple iProduct platformYorhel1-0/+1
2010-11-01Multi::Maintenance: Automatically remove read notifications after a monthYorhel1-0/+1
2010-10-31Added more comparison VNs for the length fieldYorhel1-0/+1
2010-10-31Added 1024x576 and 1280x800 screen resolutionsYorhel1-0/+1
2010-10-31Multi::Anime: don't crash when anidb returns an invalid or empty yearYorhel1-0/+1
Like as with Steins;Gate, where the year isn't known.
2010-10-31Display friendly message in the VN edit scr tab when no release is knownYorhel1-0/+1
2010-10-31Remove duplicate votes when merging tags (fixes a 500)Yorhel1-0/+1
2010-10-31Bugfix: only redirect VN search to VN page if page=1Yorhel1-0/+1
2010-10-31ChangeLog + d11 updatesYorhel1-0/+3
2010-03-05API: Added image field to 'get vn'Yorhel1-0/+1
2010-02-17Multi::IRC: Added !scr command for reverse screenshot lookupYorhel1-0/+3
2010-02-06Version bump2.11Yorhel1-1/+1
2010-02-06L10N-NL: Added Dutch interface translationYorhel1-0/+1
I may do the docs later as well, when I'm terribly bored again.
2010-02-05Notifications: Added 'announce' notificationYorhel1-0/+1
This one is also configurable, but mainly because I want to avoid generating several thousands of notifications for a single action...
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-0/+1
And added a settings window where you can disable this notification, which is something you really want to do if you're an active contributor...
2010-02-04Notifications: Added notify for deletion of entries in (wish)listYorhel1-0/+1
2010-02-02Differentiate between pt-PT and pt-BR in the languagesYorhel1-0/+1
As requested, http://vndb.org/t423
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-0/+1
And changed vn.c_languages to an array type while I was at it. This required some changes in the Perl code, and I found a bug in DBD::Pg while I was at it: https://rt.cpan.org/Ticket/Display.html?id=54224 Luckily, there's an easy workaround for that.
2010-02-01Added notification for database deletions to users who contributedYorhel1-1/+3
Complex queries...
2010-02-01Properly copy over search string on switching with the searchtabsYorhel1-0/+1
2010-01-26Automatically remove sessions that haven't been used for a monthYorhel1-1/+1