summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2010-11-11d2: Updated VN relations guidelines with the official flagYorhel1-0/+6
2010-11-10Multi::RG: Use dotted line to indicate unofficial status in VN relationsYorhel2-16/+17
Also fixed a minor bug with no change notification being sent to Multi when only the official flag has been changed.
2010-11-10Handler::VNPage: display "official" relation statusYorhel2-0/+8
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel11-28/+73
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 informationYorhel2-12/+13
Not very useful, anyway.
2010-11-09L10N-EN: Fixed tiny mistakeYorhel1-1/+1
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