summaryrefslogtreecommitdiff
path: root/data
AgeCommit message (Collapse)AuthorFilesLines
2016-02-12Minor fixes / behaviour reverts related to the removal of L10NYorhel1-4/+4
- Fix mouse-over text of language flag on homepage - Capitalize release types in edit form - Use plural form of character roles on VN page listing
2016-01-29Multi::API: added 'screens' flag to 'get vn'Yorhel1-0/+14
2016-01-26d2: VN guideline changeYorhel1-18/+45
2016-01-23L10N: Remove all remaining traces of the interface translation featureYorhel1-3617/+0
...unless I missed something.
2016-01-23L10N: Intern all VNDB::Handler::* stuffYorhel1-1/+0
Most of these replacements were automated. This ended up being less work than I had anticipated. I also fixed a few minor bugs along the way, but probably introduced more than I fixed.
2016-01-20L10N: Intern all VNDB::Util::* stuffYorhel1-255/+0
With some related edits in other parts of the code, mostly due to interface changes to htmlRevision() and htmlFormError(). Trivial replacements were automated by a super awesome script.
2016-01-19Move some VNDB::L10N stuff to VNDB::Func + intern VNDB::FuncYorhel1-35/+0
2016-01-19global.pl: Fix incorrect naming of producer relation typesYorhel1-6/+6
2016-01-18Fix display of spoiler in chartraits.js + warning in Handler/Chars.pmYorhel1-1/+1
2016-01-17L10N: Intern all Javascript strings and rename main JS fileYorhel20-240/+217
This has been mostly automated.
2016-01-17L10N: Intern blood_types/genders/(char|staff)_roles/discussion_boardsYorhel3-110/+31
I definitely needed the Tie::IxHash thing for these.
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-34/+43
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2016-01-17L10N: Intern VN/producer relations + update relation graphsYorhel3-92/+19
Now that graphviz knows the actual strings, it has a better opportunity to create better graphs. (Most of them still look messy tho)
2016-01-17L10N: Intern tag_cats/voiced/animated/*_statusYorhel2-90/+11
2016-01-16L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlengthYorhel2-339/+115
2016-01-16L10N: Remove all translationsYorhel74-18384/+0
TODO: Intern strings again to simplify the code. The immediate effect of this commit is that starting the util/vndb.pl script and generating the JS file is much faster now and that vndb.pl uses less memory. Translations have already been disabled on the main VNDB for a week now.
2016-01-10Add 'more'/'less' buttons to staff/character boxes on VN pagesYorhel2-1/+34
2016-01-10Require current password on /u+/edit + only hash password once on /u+/setpassYorhel1-10/+34
2016-01-10Support zopfli/zopflipng for all static asset generatorsYorhel2-3/+14
Compresses a little better. I reduced the number of iterations required to find the optimal image size in spritegen.pl, but generating the icons.png is *incredibly slow* when combining zopflipng with the 'slow' option. It's possible to parallelize the calculation and use multiple cores to speed it up, but that seems overkill. Some icons.png compression stats: METHOD SIZE RUNTIME default 18103 <1sec slow 17941 few secs pngcrush 15385 <1sec pngcrush+slow 15148 few mins zopflipng 14986 few secs zopflipng+slow 14898 ~1 hour
2016-01-03CSS: Add overflow property to <pre> and fix the thread layoutsYorhel1-1/+2
https://vndb.org/t2520.185
2016-01-02js/filter: Fix passing null to selectCat() in IEYorhel1-1/+3
Apparently IE doesn't like it when you put a HTMLCollection object inside a DOM value.
2015-12-30Combine some tabs in release filters to avoid line wrapYorhel3-35/+35
2015-12-30Add release filters to VN browserYorhel2-137/+209
2015-12-29Multi::API: Add support for TLSYorhel1-3/+9
2015-11-28doc: Minor d7 staff updateYorhel1-1/+1
2015-11-28VNPage: Generalize seiyuu listing to character summary listingYorhel2-14/+10
The comment already suggested this: I wonder whether it's better to just ask database for character list instead of doing this manual group/sort So yeah, let's just do that.
2015-11-26Modified cast block layout.morkt1-0/+17
2015-11-26Handler::VNPage: Move staff tab into main VN page + some styling changesYorhel2-50/+6
The styling of the staff info can be a bit awkward at times, but it looks slightly better than a table, IMO. I didn't really know what to do with the the seiyuu info - it wastes a lot of screen space in its current implementation, but I can't think of anything better at the moment.
2015-11-11Misc poll improvementsYorhel2-27/+181
- Merged polls table into threads table. Not much of a storage/performance difference, and it's a bit simpler this way. - Merged DB::Polls into DB::Discussions. Mainly because of the above change in DB structure. - Add option to remove an existing poll. - Allow preview and recast to be changed without deleting the votes - Set preview option by default. Because personal preferences. :) - Minor form validation differences
2015-11-10Merge branch 'poll' of https://github.com/morkt/vndb into pollsYorhel5-0/+103
2015-11-10added poll error message.morkt1-0/+3
2015-11-10Show full date/time at edit history and thread listingsYorhel1-2/+2
Having the time display is quite useful. It does make the listings look more cluttered, but meh.
2015-11-10Merge branch 'master' into pollmorkt28-99/+109
2015-11-10Add 'has screenshots' filter to VN browserYorhel2-1/+38
2015-11-10Add language filter to staff browserYorhel2-1/+14
2015-11-01Remove 'you need to be logged in to edit this page' messageYorhel1-12/+0
While helpful, it's also rather dominant. We're not that desperate for new contributes anymore.
2015-11-01Use HTML5 'placeholder' attribute for main search boxYorhel2-16/+1
Instead of the JS hack.
2015-11-01dropdownsearch.js: Perform search when copy-pasting or dragging textYorhel1-9/+19
https://vndb.org/t950.103
2015-11-01Image viewer: Use HTML5 data- attribute instead of 'rel' for dataYorhel3-13/+13
The possible values of the rel attribute is fixed, it's not supposed to be a free-form field.
2015-11-01Switch to HTML5 doctype + s/acronym/abbr/ + s/&nbsp;/&#xa0;/eYorhel2-7/+7
I'd have preferred to stick with XHTML 1.0, but unfortunately browsers won't allow you to use modern Javascript APIs with an older doctype. Note that most pages don't actually validate correctly as HTML5, I'm relying on browsers to be lenient. In either case, I'd like VNDB to stay valid XML (XHTML5, then), and luckily that shouldn't be a problem.
2015-11-01Removed support for sha256-hashed passwordsYorhel2-5/+3
They had to be deleted from the database at some point, otherwise we still have thousands of easily-cracked password hashes in the database. Note that I could have opted to use scrypt on top of the sha256 hashes so the passwords would remain secure without needing to reset everything, but doing that after one year of switching to scrypt is likely not worth it. Everyone who still actively uses his account has already been converted to scrypt, everyone else should just reset their password whevener they decide to come back.
2015-11-01Remove deprecated 'staffedit' permission flagYorhel1-2/+2
2015-10-28Some doc improvementsYorhel19-35/+52
2015-10-25Staff: Add error msg when removing used alias + fix bug in alias editingYorhel1-0/+12
The new database schema doesn't allow an alias to be removed when it is still linked to a VN.
2015-10-18discussion board polls.morkt4-0/+74
2015-10-18discussion board polls.morkt1-0/+26
2015-10-03js: Minor fixesYorhel2-2/+2
2015-10-03Rewrote screenshot uploader to support multiple files + use jsonYorhel3-161/+145
This might have broken the screenshot uploader on some crappy browsers, but it's much cleaner than the old iframe hack. The ability to upload multiple files in one go is also very convenient.
2015-10-01VNEdit: Give error on duplicate alias + improved msg on id/page errorYorhel1-0/+12
2015-09-20formValidate: Add json template and remove json_validate() functionYorhel1-2/+2
This is less convenient than I had expected, because all the form handling code is designed to work with plain strings rather than any scalar. This means the json data has to be encoded again to get into $frm (not doing this means that, if the form didn't validate, the field won't be filled out correctly). And then decoded for validation, and then encoded again for comparison. I suspect the better solution is to fix the form handling code to handle arbitrary data structures: comparison can be done by deep comparison rather than a simple string compare, and the form generator can auto-encode-to-json if it sees a complex object. Another advantage of this solution is that the comparison function can be less strict with respect to number formatting. In the current scheme you have to be very careful that numbers are not automatically coerced into string format, otherwise the comparison will fail. Either way, that's an idea for the future...