summaryrefslogtreecommitdiff
path: root/data
AgeCommit message (Collapse)AuthorFilesLines
2010-11-28Release filter selector: Added original language filterYorhel2-5/+13
I'm surprised I haven't been able to find a combination of filters that would generate an SQL query that would run more than 300ms or so. PostgreSQL is amazing!
2010-11-28VN Filter Selector: Added "original language" filterYorhel2-0/+8
The original language is the language of the first release of the VN, and is cached in vn.c_olang. (Geez, the vn table has more caching columns than actual information >.>)
2010-11-27Filter system: Fixed IE8 compatibility and an HTML bugYorhel1-4/+6
IE7 still doesn't work, however. Not going to fix it either.
2010-11-27VN Filter Selector: Fixed tiny bug with selecting spoiler levelYorhel1-1/+1
Another one of those '' == 0 JS logic errors. Gotta be careful with that.
2010-11-27VN Filter Selector: Added "has anime" filterYorhel2-2/+24
Also requested several times before.
2010-11-27VN Filter Selector: Added length field filterYorhel2-0/+20
Has been requested quite often, now finally implemented.
2010-11-27VN Filter Selector: get/set the tagspoil cookie with the tag filtersYorhel1-14/+6
2010-11-27Filter selector: Replaced some dropdown boxes with JS linksYorhel2-5/+31
This looks better (at least, when there aren't too many of those selection fields present, otherwise it looks chaotic, like on the release filters -> general...) and it works faster/more intuitive.
2010-11-27Replaced old VN advanced options with the new filter selection systemYorhel3-99/+87
Had to fix some bugs here and there and add some new functionality to the abstractions at some places, but it appears to be working now. There are still a few TODOs left, I'll get to those in a bit.
2010-11-27Re-added producer role to collapsed view on producer pagesYorhel2-11/+7
And rewrote the expand/collapse JS/CSS code so that the difference between expanded and collapsed view is merely the class of the containing table. This way the JS code doesn't have to pass through the table rows and is thus noticeably faster for larger tables (i.e. /p65).
2010-11-26Added voiced field release filterYorhel2-0/+11
The release filters are now pretty much complete. Save, perhaps, for some improved styling and grouping in the filter selector; but I'm too lazy for that at the moment.
2010-11-26Added animation field release filterYorhel2-1/+29
Surprisingly enough, the SQL queries are still quite fast even when matching on the animation columns. And thanks to the new filter system, adding this filter was incredibly easy.
2010-11-25JS: Split script.js into a separate file for each languageYorhel1-3/+7
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-24vndb.pl: Use the Makefile to auto-update static filesYorhel1-0/+1
Rather than trying to figure out what to update in the Perl code, duplicating the logic that's already present in the Makefile. This is only enabled when 'regen_static' is set to true in data/config.pl.
2010-11-22Reverted to the old selection box date selectorYorhel2-77/+20
This effectively reverts 799c9e44b1a1a7776609273733f67887a74e33bf.
2010-11-21Re-added the 'boolean or' message to the filtersYorhel3-5/+9
Doesn't look very nice; but serves its purpose.
2010-11-21Added 'close' link to the filter selector boxYorhel3-0/+9
2010-11-21Use ~ as value separator in the filter string, rather than a commaYorhel1-3/+3
It seems a comma has to be escaped in query string values. A ~ doesn't and thus makes the URIs significantly shorter.
2010-11-21Implemented the server side of the new release filter selectorYorhel1-2/+5
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-21Implemented the client side of the new release filter systemYorhel3-98/+394
This isn't entirely functional yet, the server side will need to be rewritten as well. And after that new filters should be added and this system should also be used for VN/producer search. script.js is getting quite large with all those new translation strings, it may be an idea to generate a separate .js file for each language and only load the one being used. I won't have a valid reason to feel bored anytime soon, at least...
2010-11-14Handler::Misc: Added title attribute to the feed cssiconsYorhel1-0/+8
This also gets rid of three perl warnings.
2010-11-13Homepage: Added feed iconsYorhel1-0/+3
2010-11-13Added <link> elements for the related atom feeds to some pagesYorhel1-0/+5
2010-11-13Multi::Feed: Added Atom feedsYorhel1-0/+1
TODO: add links to these feeds from the site
2010-11-11Producer release listing: added dev/pub info and expand/collapse linkYorhel2-25/+34
It's an awesome feature now. :-)
2010-11-11Display releases grouped by VNs on producer pagesYorhel2-15/+28
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-11d2: Updated VN relations guidelines with the official flagYorhel1-0/+6
2010-11-10Handler::VNPage: display "official" relation statusYorhel1-0/+7
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel3-10/+37
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-12/+12
Not very useful, anyway.
2010-11-09L10N-EN: Fixed tiny mistakeYorhel1-1/+1
2010-11-09Added human confirmation question to the registration pageYorhel1-0/+21
Just a simple question.
2010-11-07d11: Tiny documentation fixYorhel1-1/+1
2010-11-06Fixed cross-site request forgery vulnerabilitiesYorhel3-5/+24
2010-11-03Merge commit '086d6554714e29866fa14e5c9514f0af38826e04' into betaYorhel7-46/+55
2010-11-03Merge branch 'master' into betaYorhel3-42/+43
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-03Use newlines to separate VN aliasesYorhel1-6/+6
2010-11-03Compressed the thread listing into one row per threadYorhel1-5/+5
2010-11-02Automatically read L10N keys from script.jsYorhel1-6/+26
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_prefixYorhel2-2/+3
This replaces the "cookie_auth" setting, and applies to all cookies in use by VNDB.
2010-11-02Multi::Image: Moved image size configuration to global.plYorhel1-0/+2
As those may also be useful for other scripts.
2010-11-02Removed XML sitemapYorhel1-1/+0
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-6/+6
And changed the order a bit, as suggested by ImmLff.
2010-11-01Added Apple iProduct platformYorhel3-1/+9
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 pageYorhel1-0/+7
2010-10-31Added more comparison VNs for the length fieldYorhel1-25/+25