summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/VNPage.pm
AgeCommit message (Collapse)AuthorFilesLines
2011-01-27TUWF: Added tag name to several end() callsYorhel1-12/+12
Haven't found any bugs this way, yet. I doubt there'll be any problems, but it's a nice new feature that could help quite a bit. :-D
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-8/+10
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2011-01-01Added saving notes to filter selector and applied filFetchDB()Yorhel1-1/+1
This finalizes the permanent filters feature.
2010-12-23Converted the show_nsfw preference to use the users_prefs tableYorhel1-5/+5
2010-12-19RFC-01: Code/DB cleanup and renamed some stuff for consistencyYorhel1-3/+3
2010-12-19RFC-01: Added VN list selection box to VN pagesYorhel1-0/+11
2010-12-19RFC-01: Fixed release list updating dropdown on VN pagesYorhel1-4/+3
2010-12-17Don't allow NULL for rr.minage and use -1 for unknownYorhel1-1/+1
This can be seen as a partial revert of 0a4f97f0186d6941a4cab2e3bd05201f1fed1441. I used to think using NULL for special values is more "correct" in database terms. But in the end I guess I should be aiming for whatever solution is easier. Both are "correct" in a sense anyway.
2010-11-26Use word-level (instead of character-level) diff for large fieldsYorhel1-2/+2
Primary reason for this change is because Algorithm::Diff::Fast isn't all that fast for character-level diffs. :-/
2010-11-10Handler::VNPage: display "official" relation statusYorhel1-0/+1
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-1/+2
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-06Fixed cross-site request forgery vulnerabilitiesYorhel1-2/+3
2010-11-03Use newlines to separate VN aliasesYorhel1-0/+1
2010-11-02Handler::(Misc|VNPage): Added HTML width/height to screenshot thumbnailsYorhel1-1/+3
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-02-06Handler::VNPage: Don't show delete option when not on wishlistYorhel1-1/+1
...rather useless option to have.
2010-01-23Handler::VNPage: Centered the thumbnails in the screenshot viewerYorhel1-24/+18
And greatly simplified the HTML of the screenshot viewer and fixed a HTML bug (colspan when it wasn't needed) in the process.
2010-01-09L10N: Extracted/fixed some more strings on revision pagesYorhel1-10/+11
2009-12-28Highlight opened VN/producer in relation graphsYorhel1-0/+1
The warnbg and warnborder colors from the skins are used for highlighting.
2009-11-28v+: Allow hiding of NSFW cover even if NSFW warning is disabledYorhel1-9/+11
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-2/+2
The ORDER BY was previously specified using an 'order' argument, which would then be directly inserted into the query. The new method is the same as what I used for the public API: two 'sort' and 'reverse' arguments. This should be less error-prone and more readable. This changes quite a lot of code, so I hope I haven't forgotten to update something along the way.
2009-11-14Added bayesian rating info to VN pagesYorhel1-1/+1
This adds about 100ms (sometimes more) to the page generation time of VN pages... maybe I should cache the ratings after all.
2009-11-14Made external links on VN pages translatableYorhel1-4/+4
2009-11-14SQL/L10N: Allow NULL for releases_rev.minage and make the values translatableYorhel1-1/+1
2009-10-21Added relation graphs for producersYorhel1-31/+1
TODO: - document the relations - emit a relgraph notify when needed
2009-10-19Use 'no spoilers' as default spoiler level for tagsYorhel1-3/+3
2009-10-10Updated Producer and VN pages with developer/publisher informationYorhel1-15/+30
2009-10-03JS: Rewrote VN tagspoil & JS tabs and merged addClass and removeClassYorhel1-0/+1
2009-10-02JS: Rewrote release list dropdownYorhel1-1/+1
Abstacted a simple set of reusable functions for generating dropdown lists, as I'm likely going to need that more often.
2009-09-27Converted anime.type to ENUM and made them translatableYorhel1-1/+1
Again, two separate but related things.
2009-09-26Properly handle UTF-8 in relation graph SVGsYorhel1-1/+1
This is a workaround for a bug in DBD::Pg: http://rt.cpan.org/Public/Bug/Display.html?id=40199 Also added a charset to the content type header of the relation graph pages, though this wasn't really necessary for my Firefox to work.
2009-09-26Converted VN relations to ENUM data type and made them translatableYorhel1-2/+4
OK, these are actually two separate things: to make the relations translatable they didn't necessarily have to be stored as enum, and I could've also converted them to enum but not have it translatable. Nevertheless, it was easier to just do both at the same time. Also note how I used the string "$____vnrel_<rel>____$" as identifier in the relation graphs while I could have used something a lot shorter ("$<rel>$" would have been fine, for example). This is done so that graphviz can make some space for those relations - the long identifier gives a slightly more realistic representation of the actual length of the relation titles.
2009-09-25Handler::VNPage: Added simple browser detection for XHTMLYorhel1-2/+14
If a browser does support the application/xhtml+xml mime, let's assume it also supports SVG (to my knowledge, this is the case in any recent browser). OTOH, browsers not supporting that mime type are sure to not support SVG, either.
2009-09-25Use inline SVG for relation graphsYorhel1-3/+20
The graphs are now stored in the DB in SVG format, the static/rg/ directory can be removed (not used anymore). SVG data is stored using the xml data type, so now I can say for sure you'd need at least PostgreSQL 8.3. This feature still needs some tweaking, though. Current state isn't perfect.
2009-09-24Handler::VNPage: Display '-' for empty VN descriptionsYorhel1-1/+1
2009-09-13Removed visual-novels.net link from the interfaceYorhel1-4/+0
As they would soon be dead links, anyway.
2009-09-10L10N: Extracted VN lenghtsYorhel1-2/+2
2009-09-08Added random VN link in menuYorhel1-0/+7
2009-09-06L10N: Converted wishlist_status in global.plYorhel1-2/+2
This is one of the last easy-to-extract unextracted texts... the rest is slightly harder to extract. Either because it's in JS, used in Multi, or used in some creative way that doesn't work well together with extraction... :/
2009-09-06L10N: Converted 'voiced', 'animated' and 'votes' in global.plYorhel1-1/+1
2009-09-06Util::htmlRevision: Removed obsolete name argumentYorhel1-14/+14
2009-09-06L10N: Converted Handler::VNPageYorhel1-53/+52
This is the last Handler module. There are still some other things left in Util:: and global.pl, though. But at least we're nearing the end!
2009-08-17L10N: Moved some functions from Func.pm to L10N.pm and added Russian quant() ↵Yorhel1-1/+1
and age()
2009-08-17L10N: Converted producer and release typesYorhel1-1/+1
And replaced the ugly release type cssicon class hack. The class is now 'tr'.$type_numer, instead of the first three characters of their English representation in lowercase. No idea why I haven't done it this way in the first place...
2009-08-17L10N: Converted platform namesYorhel1-1/+1
2009-08-17L10N: Converted user ranks and language namesYorhel1-4/+4
User ranks are easy... but the language names are used everywhere!
2009-08-12Added global user votes ignore listYorhel1-1/+1
2009-08-08Removed last traces of the category systemYorhel1-46/+2
2009-07-18Modified definition of the anime tableYorhel1-4/+4
Removed most NOT NULL constraints, and converted lastfetch to a timestamp data type. The site has been updated to handle this, but Multi::Anime won't work.
2009-07-04Implemented support for multilingual releasesYorhel1-11/+7
The 'language' column in releases_rev has been replaced with a releases_lang table. As this is quite a big change, there may still be bugs floating around somewhere.
2009-06-15Don't show NSFW images on diff pages by defaultYorhel1-1/+6