summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2016-01-10Use atomic replace when writing .gz assetsYorhel3-2/+9
2016-01-10DB::Users: Perform case-insensitive email matchingYorhel1-1/+1
This fixes two things: - It's not possible to create two accounts with the same mail address with different case (although the user+xyz@domain trick still works). - The password reset form is now case-insensitive as well. Some people had problems with the case-sensitive behavior in the past.
2016-01-10Require current password on /u+/edit + only hash password once on /u+/setpassYorhel3-24/+65
2016-01-10Multi::IRC: Make sure we keep our nickYorhel1-0/+18
2016-01-10Support zopfli/zopflipng for all static asset generatorsYorhel5-25/+39
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-10Multi::Anime: Regularly resolve the AniDB API DNSYorhel1-15/+26
The API IP address doesn't change often, but we don't want months of downtime when it does.
2016-01-10DB::(VN|Producers): Don't decode_utf8() xml valuesYorhel2-4/+0
Newer versions of DBD::Pg do this automatically.
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-31DB::Releases: Don't match non-patch fields for patch releasesYorhel1-6/+6
Fixes https://vndb.org/t950.210
2015-12-30Combine some tabs in release filters to avoid line wrapYorhel3-35/+35
2015-12-30Add release filters to VN browserYorhel11-170/+280
2015-12-29Multi::API: Add support for TLSYorhel2-11/+32
2015-11-28doc: Minor d7 staff updateYorhel1-1/+1
2015-11-28VNPage: Generalize seiyuu listing to character summary listingYorhel5-88/+90
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.morkt2-18/+41
2015-11-26Handler::VNPage: Fix character listing tabYorhel1-1/+1
2015-11-26Handler::Discussions: Fix display of username when editing postYorhel1-1/+1
2015-11-26Handler::VNPage: Move staff tab into main VN page + some styling changesYorhel4-101/+30
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-26Handler::Releases: Fix bug when editing release with lots of VNsYorhel1-1/+1
2015-11-26Multi::IRC: Fix auth bypass bug + make !quote admin-onlyYorhel1-2/+2
2015-11-14DB::VN: Fix undeterministic ordering on tag score in VN listingsYorhel1-1/+1
2015-11-11Misc poll improvementsYorhel9-262/+400
- 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 pollsYorhel10-1/+386
2015-11-10added poll error message.morkt1-0/+3
2015-11-10various fixes.morkt1-45/+46
2015-11-10Show full date/time at edit history and thread listingsYorhel3-4/+4
Having the time display is quite useful. It does make the listings look more cluttered, but meh.
2015-11-10Merge branch 'master' into pollmorkt68-1685/+2031
2015-11-10Add 'has screenshots' filter to VN browserYorhel3-2/+39
2015-11-10Add language filter to staff browserYorhel4-2/+16
2015-11-02DB::VN: Fix dbVNHasStaff() query when VN has only seiyuu and no staffYorhel1-1/+1
2015-11-01Util::LayoutHTML: Suppress warning when $o{search} isn't definedYorhel1-1/+1
2015-11-01Remove 'you need to be logged in to edit this page' messageYorhel2-17/+1
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 boxYorhel3-17/+2
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 dataYorhel4-15/+15
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;/eYorhel9-27/+26
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-01DB::(Producers|VN): Convert svg column to perl encoding when fetchingYorhel2-0/+3
DBD::Pg doesn't recognize the 'xml' data type as textual data, and thus doesn't decode it for us. This fixes the display of non-ASCII characters.
2015-11-01Removed support for sha256-hashed passwordsYorhel6-34/+9
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 flagYorhel4-6/+6
2015-11-01Handler::VNEdit: Also increase size of title fields in VN add formYorhel1-2/+2
2015-10-28Handler::(Releases|VNEdit): Increase width of title/orig input fieldsYorhel2-4/+4
2015-10-28Handler::Users: Don't hide list stats from own user or usermodsYorhel1-3/+4
2015-10-28Some doc improvementsYorhel19-35/+52
2015-10-25DB::Discussions: Fix bug in 'notusers' queryYorhel1-1/+1
'<> ANY' doesn't work that way. NOT EXISTS() is also pretty fast and does what we want.
2015-10-25Multi::Anime: Avoid dead state when trying to fetch anime infoYorhel1-2/+2
Turns out the anime data hasn't been updated in a few months. Oops.
2015-10-25DB::ULists: Revert change from 'numeric' to 'float' to fix vote graphsYorhel1-2/+2
Broken in bbe989de364ddc654bfc6385e22f1eaff23faad1. I forgot that floats can't accurately represent some .5 numbers.
2015-10-25DB::Discussions: Minor improvement to post <-> board filter query2.25Yorhel1-1/+1
I don't know why I didn't apply this one before, I did make this change when benchmarking the fulltext search queries and with the introduction of the bb_tsvector() function this change pretty much always improves performance.
2015-10-25Staff: Add error msg when removing used alias + fix bug in alias editingYorhel4-5/+23
The new database schema doesn't allow an alias to be removed when it is still linked to a VN.
2015-10-24DB::Staff: Fix 'aid' filter, used when editing VN staff infoYorhel1-1/+1
This broken filter would cause all staff info to be deleted from a VN upon edit. Not so nice.