summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2010-11-09Added human confirmation question to the registration pageYorhel3-3/+34
Just a simple question.
2010-11-07DB::Misc: Optimized dbRevisionGet()Yorhel2-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-07Optimized random VN fetching queryYorhel2-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-07Optimized random screenshot fetching queryYorhel2-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-07d11: Tiny documentation fixYorhel1-1/+1
2010-11-06Synchronised sql/schema.sql with the actual DBYorhel1-1/+2
Looks like I forgot to add vn.c_search
2010-11-06Bugfix: delete/update all references when deleting a userYorhel2-0/+6
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/logoutYorhel3-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-06Fixed cross-site request forgery vulnerabilitiesYorhel14-21/+125
2010-11-03ChangeLog update for 2.122.12Yorhel1-1/+4
2010-11-03Lowered minimum search query word to 2 charactersYorhel1-1/+1
Searching for "ef" isn't really fun with all those results, this makes it slightly less broad.
2010-11-03Merge commit '086d6554714e29866fa14e5c9514f0af38826e04' into betaYorhel7-46/+55
2010-11-03Merge branch 'master' into betaYorhel6-48/+50
Conflicts: lib/VNDB/DB/VN.pm lib/VNDB/Func.pm
2010-11-03L10N-RU: Email change of dsp2003Dmitri Poguliayev1-1/+1
2010-11-03L10N-CS: Translation updates and fixesNya-chan Production6-42/+51
2010-11-03Automatically remove duplicate aliases on /v+/editYorhel2-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-03Use newlines to separate VN aliasesYorhel4-6/+13
2010-11-03Handler::Discussions: Increased thread number display at /t for db and vYorhel1-1/+1
Those boards are most active.
2010-11-03Handler::Discussions: Only display board names different from the filterYorhel1-5/+6
Looks cleaner now.
2010-11-03Compressed the thread listing into one row per threadYorhel3-19/+17
2010-11-02Automatically read L10N keys from script.jsYorhel3-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-02Prefix all cookies with a configurable cookie_prefixYorhel7-8/+11
This replaces the "cookie_auth" setting, and applies to all cookies in use by VNDB.
2010-11-02Updated README to reflect the removal of the sitemapYorhel1-3/+0
2010-11-02Handler::(Misc|VNPage): Added HTML width/height to screenshot thumbnailsYorhel4-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-02Multi::Image: Abstracted image dimension calculation into VNDBUtilYorhel3-31/+30
Which may also be useful for other scripts.
2010-11-02Multi::Image: Moved image size configuration to global.plYorhel2-4/+4
As those may also be useful for other scripts.
2010-11-02Removed XML sitemapYorhel4-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-01Properly order the relations listed on producer pagesYorhel3-7/+8
And changed the order a bit, as suggested by ImmLff.
2010-11-01Added Apple iProduct platformYorhel6-1/+11
2010-11-01Added vim modeline to lang.txtYorhel1-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-01L10N: Marked _vnedit_scrnorel as unsynchronisedYorhel1-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-01Handler::Users: Added note about automatic deletion to notifications pageYorhel2-0/+8
2010-11-01Multi::Maintenance: Automatically remove read notifications after a monthYorhel2-2/+10
2010-10-31Added more comparison VNs for the length fieldYorhel3-26/+27
2010-10-31Added 1024x576 and 1280x800 screen resolutionsYorhel3-0/+8
2010-10-31Multi::Anime: Remove useless statementYorhel1-1/+0
2010-10-31Multi::Anime: don't crash when anidb returns an invalid or empty yearYorhel2-1/+2
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 knownYorhel4-3/+13
2010-10-31Remove duplicate votes when merging tags (fixes a 500)Yorhel2-0/+5
2010-10-31Bugfix: only redirect VN search to VN page if page=1Yorhel2-1/+2
2010-10-31VNDBUtil::normalize: Added search alias for 'fandisk'Yorhel1-0/+2
2010-10-31ChangeLog + d11 updatesYorhel2-0/+15
2010-10-31Fixed minor issues on d4 and d5Yorhel2-2/+2
2010-05-11L10N-NL: Some TL improvementsYorhel1-3/+3
2010-03-14Made name of the auth cookie configurableYorhel2-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-14Handler::Users: Added noindex to user pagesYorhel1-1/+1
I could swear the user pages have always been noindex'ed... hmm.
2010-03-13Multi::IRC: Changed !vn command to use the new search functionYorhel1-16/+15
2010-03-13Multi::API: Fixed a Perl warning on 'get vn' with the platforms array filterYorhel1-2/+2
2010-03-13Multi::API: Make use of the new search function for 'get vn'Yorhel1-4/+13
This required a new 'split' option to consider a string as an array.
2010-03-13Improved VN searchYorhel8-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.