Age | Commit message (Collapse) | Author | Files | Lines |
|
|
|
|
|
- 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
|
|
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.
|
|
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.
|
|
|
|
I definitely needed the Tie::IxHash thing for these.
|
|
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.
|
|
Now that graphviz knows the actual strings, it has a better opportunity
to create better graphs.
(Most of them still look messy tho)
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
The possible values of the rel attribute is fixed, it's not supposed to
be a free-form field.
|
|
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.
|
|
This basically makes VNDB browsable again, but editing entries is still
broken.
I split off the get-old-revision functionality from the db*Get() methods
into db*GetRev(). This split makes sense even with the old SQL schema:
db*Get() had to special-case some joins/filters when fetching an older
revision, and none of the other filters would work in that case. This
split does cause some code duplication in that all db*GetRev() methods
look very much alike, and that the columns they fetch is almost
identical to the db*Get() methods. Not sure yet how to avoid the
duplication elegantly.
I didn't do a whole lot of query optimization yet (most issues require
extra indices, I'll investigate later which indices will make a big
difference), but I did fix some low hanging fruit whenever I encountered
something.
I don't think I've worsened anything, performance-wise.
|
|
From 50 to 200. https://vndb.org/t6892
|
|
- Individual blocks don't leak variables into the parent scope anymore.
Previously some blocks would re-use variables from other blocks,
creating (almost invisible) dependencies between te blocks.
- More consistent code for ulist-change-dropdowns, and all of them have
a ref= argument now.
- Use 'hidden' class instead of style.display wherever that makes sense.
- Remove dead 'advselect' code. Hasn't been used since the addition of
search filters.
- lang_select doesn't rely on the position of the language class in
className anymore (seriously that stuff is fragile...)
|
|
It's not a preference yet and the sexual traits are still visible by
default. I'll fix that later.
|
|
- Remove the obsolete 'use's
- Re-add max-width style when requested
- Fix comparison in displaying media
- Fix sorting on animation column
|
|
The previous code was using experimental perl features (switch /
smartmatch) that weren't really needed, and the information about
individual columns was spread around in multiple functions. This rewrite
makes the code consistent with the rest of VNDB, and has *all* of the
column-specific information in one data structure.
I did not replicate the similar-cell-merging feature, partly because the
code for it is definitely not trivial and partly because it doesn't make
the table look any less cluttered. In fact, I feel that it only makes
the table harder to interpret because it looks messy. This is a matter
opinion, of course, so I might reimplement the feature if people who
actually use this comparison page want to.
Overall, I'm still undecided on whether this comparison page should
exist at all in its current form - it's not very user-friendly and often
looks cluttered. I'm keeping it because it does have some use-cases
where it avoids opening every release page to do a manual comparison,
but I'd love a more friendly-looking alternative.
|
|
This fixes the unexpected behaviour that changing the spoiler setting on
one page will change it for all pages. All manual spoiler changing
options are temporary now.
|
|
|
|
The name of the profile setting isn't very clear. Not sure what to do
with it.
|
|
|
|
Used /v+/chars, other occurrences just use singular.
|
|
Broken in commit 887607bb3744c727ec617508c17b2b7df46c2287
|
|
|
|
|
|
The revision is supposed to display all changes, so a change to any part
of the notes should be visible.
|
|
To fix an issue mentioned in <https://vndb.org/t6138.15>. Yay for
writing patches on the live site.
|
|
Conflicts:
lib/VNDB/DB/VN.pm
lib/VNDB/Handler/VNPage.pm
|
|
Only recent perl versions need it, on older versions the 'no warnings'
line would cause an error.
|
|
|
|
|
|
|
|
|
|
- Moves staff<->vn linking form to the main VN edit form
- Fixes a bug with linking staff aliases to VNs
- Adds staff changes to the VN revisions
- And some misc. improvements
|
|
|
|
I really want to rewrite that code to not use the very unperlish switch
statement, but the code is rather... complex and hairy. :(
|
|
|
|
|
|
mtvnlen() can't be used as serialize function, since it also reads the
second argument and interprets it as a number.
|
|
A generic '_unknown' is more easily usable.
|
|
I used to do this to avoid loading Image::Magick in each TUWF process,
decreasing memory usage, and lowering the blocking time by avoiding too
much processing. Memory isn't much of a problem nowadays, and processing
images is fast enough, too, so this complexity isn't necessary anymore.
(Character images and screenshots pending)
|
|
|
|
This fixes another (obscure) Perl warning when $rel->{patch} is undef.
Perl similar to C when it comes to booleans: Comparing them with == is a
recipe for disaster. (Unless you use the C99 'bool' type, but Perl
doesn't have such an equivalent)
|