Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2010-11-09 | Added human confirmation question to the registration page | Yorhel | 3 | -3/+34 | |
Just a simple question. | |||||
2010-11-07 | DB::Misc: Optimized dbRevisionGet() | Yorhel | 2 | -18/+23 | |
The code is a bit more complicated now, and it's not a lot faster, but at least this helps a bit. | |||||
2010-11-07 | Optimized random VN fetching query | Yorhel | 2 | -2/+8 | |
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-07 | Optimized random screenshot fetching query | Yorhel | 2 | -8/+13 | |
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-07 | d11: Tiny documentation fix | Yorhel | 1 | -1/+1 | |
2010-11-06 | Synchronised sql/schema.sql with the actual DB | Yorhel | 1 | -1/+2 | |
Looks like I forgot to add vn.c_search | |||||
2010-11-06 | Bugfix: delete/update all references when deleting a user | Yorhel | 2 | -0/+6 | |
Really need a cleaner solution for that. PostgreSQL actually provides a better solution, need to change to that. | |||||
2010-11-06 | URL change: /u/logout => /u$id/logout | Yorhel | 3 | -4/+8 | |
Also fixes a cross-site request forgery vulnerability. Not as strong as the others but it's not very crucial anyway. | |||||
2010-11-06 | Fixed cross-site request forgery vulnerabilities | Yorhel | 14 | -21/+125 | |
2010-11-03 | ChangeLog update for 2.122.12 | Yorhel | 1 | -1/+4 | |
2010-11-03 | Lowered minimum search query word to 2 characters | Yorhel | 1 | -1/+1 | |
Searching for "ef" isn't really fun with all those results, this makes it slightly less broad. | |||||
2010-11-03 | Merge commit '086d6554714e29866fa14e5c9514f0af38826e04' into beta | Yorhel | 7 | -46/+55 | |
2010-11-03 | Merge branch 'master' into beta | Yorhel | 6 | -48/+50 | |
Conflicts: lib/VNDB/DB/VN.pm lib/VNDB/Func.pm | |||||
2010-11-03 | L10N-RU: Email change of dsp2003 | Dmitri Poguliayev | 1 | -1/+1 | |
2010-11-03 | L10N-CS: Translation updates and fixes | Nya-chan Production | 6 | -42/+51 | |
2010-11-03 | Automatically remove duplicate aliases on /v+/edit | Yorhel | 2 | -3/+13 | |
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-03 | Use newlines to separate VN aliases | Yorhel | 4 | -6/+13 | |
2010-11-03 | Handler::Discussions: Increased thread number display at /t for db and v | Yorhel | 1 | -1/+1 | |
Those boards are most active. | |||||
2010-11-03 | Handler::Discussions: Only display board names different from the filter | Yorhel | 1 | -5/+6 | |
Looks cleaner now. | |||||
2010-11-03 | Compressed the thread listing into one row per thread | Yorhel | 3 | -19/+17 | |
2010-11-02 | Automatically read L10N keys from script.js | Yorhel | 3 | -52/+71 | |
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-02 | Prefix all cookies with a configurable cookie_prefix | Yorhel | 7 | -8/+11 | |
This replaces the "cookie_auth" setting, and applies to all cookies in use by VNDB. | |||||
2010-11-02 | Updated README to reflect the removal of the sitemap | Yorhel | 1 | -3/+0 | |
2010-11-02 | Handler::(Misc|VNPage): Added HTML width/height to screenshot thumbnails | Yorhel | 4 | -3/+8 | |
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-02 | Multi::Image: Abstracted image dimension calculation into VNDBUtil | Yorhel | 3 | -31/+30 | |
Which may also be useful for other scripts. | |||||
2010-11-02 | Multi::Image: Moved image size configuration to global.pl | Yorhel | 2 | -4/+4 | |
As those may also be useful for other scripts. | |||||
2010-11-02 | Removed XML sitemap | Yorhel | 4 | -155/+2 | |
Was growing too large and isn't really necessary anymore, now that VNDB is indexed quite well in most search engines. | |||||
2010-11-01 | Properly order the relations listed on producer pages | Yorhel | 3 | -7/+8 | |
And changed the order a bit, as suggested by ImmLff. | |||||
2010-11-01 | Added Apple iProduct platform | Yorhel | 6 | -1/+11 | |
2010-11-01 | Added vim modeline to lang.txt | Yorhel | 1 | -0/+2 | |
This prevents vim from using syntax highlighting on the file, which you really don't want for two reasons: - There are no syntax files for lang.txt - The file is huge and syntax highlighting is slow (vim thought it was an asciidoc file...) | |||||
2010-11-01 | L10N: Marked _vnedit_scrnorel as unsynchronised | Yorhel | 1 | -3/+3 | |
Should have done this in 25aa82f5e15115e58d91ecb09d5f0da75ccba354 but I'm not used to working on VNDB anymore after such a long period of non-VNDB. >.> | |||||
2010-11-01 | Handler::Users: Added note about automatic deletion to notifications page | Yorhel | 2 | -0/+8 | |
2010-11-01 | Multi::Maintenance: Automatically remove read notifications after a month | Yorhel | 2 | -2/+10 | |
2010-10-31 | Added more comparison VNs for the length field | Yorhel | 3 | -26/+27 | |
2010-10-31 | Added 1024x576 and 1280x800 screen resolutions | Yorhel | 3 | -0/+8 | |
2010-10-31 | Multi::Anime: Remove useless statement | Yorhel | 1 | -1/+0 | |
2010-10-31 | Multi::Anime: don't crash when anidb returns an invalid or empty year | Yorhel | 2 | -1/+2 | |
Like as with Steins;Gate, where the year isn't known. | |||||
2010-10-31 | Display friendly message in the VN edit scr tab when no release is known | Yorhel | 4 | -3/+13 | |
2010-10-31 | Remove duplicate votes when merging tags (fixes a 500) | Yorhel | 2 | -0/+5 | |
2010-10-31 | Bugfix: only redirect VN search to VN page if page=1 | Yorhel | 2 | -1/+2 | |
2010-10-31 | VNDBUtil::normalize: Added search alias for 'fandisk' | Yorhel | 1 | -0/+2 | |
2010-10-31 | ChangeLog + d11 updates | Yorhel | 2 | -0/+15 | |
2010-10-31 | Fixed minor issues on d4 and d5 | Yorhel | 2 | -2/+2 | |
2010-05-11 | L10N-NL: Some TL improvements | Yorhel | 1 | -3/+3 | |
2010-03-14 | Made name of the auth cookie configurable | Yorhel | 2 | -4/+5 | |
Now it's finally possible to run multiple VNDB's with different databases on the same domain without constantly getting logged out. | |||||
2010-03-14 | Handler::Users: Added noindex to user pages | Yorhel | 1 | -1/+1 | |
I could swear the user pages have always been noindex'ed... hmm. | |||||
2010-03-13 | Multi::IRC: Changed !vn command to use the new search function | Yorhel | 1 | -16/+15 | |
2010-03-13 | Multi::API: Fixed a Perl warning on 'get vn' with the platforms array filter | Yorhel | 1 | -2/+2 | |
2010-03-13 | Multi::API: Make use of the new search function for 'get vn' | Yorhel | 1 | -4/+13 | |
This required a new 'split' option to consider a string as an array. | |||||
2010-03-13 | Improved VN search | Yorhel | 8 | -178/+325 | |
This adds a new column to the vn table: c_search, which holds the normalized titles for speedy search results using LIKE. Also split some functions from VNDB::Func that didn't require YAWF into a VNDBUtil module, so Multi can also make use of them. The normalization functions are the same for Multi and VNDB, after all. The API and Multi::IRC still use the old search, these should be updated as well. |