VNDB Suggestions!

Posted in

#426 by batoo
2018-04-03 at 12:44
It's possible to have a page on our profile where we can list our favorites characters ? With a rating system ?
#427 by thewayfarer
2018-04-12 at 22:45
When checking the history of a page's contribution, can we have the ability to select multiple revisions and view all the changes combined at once? It helps minimize viewing minor contributions one at a time and summarize all selected revisions into one page. And seeing there there could be some minor or negligible edits in the history as it fills up, would it help revision reviews by having the ability to summarize all those minor contribution and view them into one page?

FANDOM has this feature which makes it valuable in comparing one point in time up to another point in the future. It could help us spot suspicious edits/traits without like flipping through one contribution at a time to spot those errors. Takes minutes.
#428 by eacil
2018-04-13 at 04:57
Also, when searching for VN with variety of tags, it would be greate to specify the diapason of rating points that these tags should have. For example, if I wanna find the VN with 'Dark Skinned Heroine' and 'Anal sex', this implies that I wanna these two tags to have at least score 2.0 or higher. I won't be satisfied with one of the tags with a rating of 0.1, even if another tag will have a rating of 3.0. Now our search engine returns any combinations of score, and this is not the right thing, imo.
I totally second this. Enough of those lists where you search for full fledge bestiality and you get spoiled any 1.0 VN using bestiality as shock factor even if it looks like a moege but in fact the imouto got rekted by a bunch of hobo's dogs in one route.
I was thinking that a patch would be to filter the final result but the filtering would be screwed the moment you have minor tags that make the average drop under the filter level...
#429 by leery
2018-04-18 at 08:07
If you're sending a 'private' message, the interface should automatically add yourself to the boards. So you get notified of any replies.

And you wouldn't have to look up your UID each time either.

(If you look at the users board, it seems yorhel is the only one who remembers his UID...)
#430 by buffalocat
2018-04-18 at 22:58
The option to revoke a vote should have a warning on it like 10 and 1 do, just because it's so easy to press it when it's next to "Other" (I've "reset" the finished date on VNs this way before...)
#431 by leery
2018-05-20 at 18:21
Would it be possible to get a notification when characters get newly linked to a VN you have edited?
#432 by thewayfarer
2018-05-24 at 06:49
Could you fix the search engine when searching the name of characters in their original names, with *no spaces*? I tried searching "稲生滸" for Inou Hotori upon seeing this tweet from August, but the search fails to return result of the character.

(PS: As much as I see Japanese names around the Japanese web, names are usually mashed together with no spaces...)
#433 by yorhel
2018-05-24 at 16:53
@432: Fixed.

(@431: Don't worry, I'm not ignoring you, but rather than implement all kinds of specific notifications I'd like to create a good overview of the different kinds of notifications to add, the kind of preferences that'd need, and how to integrate that nicely. That takes time and is not a priority for me at the moment, but I do want to extend the notifications in the future.)
#434 by wakaranai
2018-06-01 at 20:20
i think it might be useful to have some general indication of the user mod status next to the username, because it's not the first time is see morons, sorry, "newcomers" start a edit war with db mods calling them names -- link. and how about some punishment for that matter, because such behavior fosters unhealthy attitude.
#435 by beliar
2018-06-01 at 20:33
I have admittedly been too harsh in my language regarding the aforementioned exchange, so half the fault is mine. However, my mood got fouled by seeing obvious spoilers being revealed by an editor for all the world to see and I got a bit too trigger happy, even reverting an edit which could be fixed, as a few added traits did apply.
#436 by wakaranai
2018-06-01 at 22:47
maybe if a discussion thread could be started right at particular database revision, it might somewhat alleviate temptation to start an edit war. currently it's much easier to just revert an edit and add a comment in revision edit description, rather than bothering with opening a new forum thread.

maybe it's my confirmation bias, but i feel like there has been an influx of autistic feuds over database entries in the last couple of months.
#437 by rockleevk
2018-06-02 at 09:42
I wanted to suggest, tell me if i'm blind and didn't see it...

Is there any way to make VN lists, aside from checking them as 'played', or make release own lists instead of checking them as 'Obtained', 'Pending', 'Unknown' ?

If not, would like to suggest if it will be possible to add this in any way, as I keep track of my purchases and the things I play and digital releases as separate 'lists' and it's getting quite messy lately depending on a spreadsheet.

If not, is there any software that connects with VNDB API that anyone can recommend?

Thanks for your time, tried to keep it short.
#438 by yorhel
2018-06-03 at 05:46
@rockleevk: Custom labels is something I've been wanting as well. It's on my to-do list, but there's so many other things to improve as well. :(
#439 by leery
2018-06-12 at 15:13
This is only tested inasmuch as I could visually spot obvious errors in them. I have no idea what Docker is or how to operate it, and I reckon learning about it would take longer than producing these patches. Would hopefully pass 'perl -c' if I had installed.

t2520.262 and t2520.244:
Do not delete users' votes for the tag when a tag is deleted.
Hide deleted tags from tag cloud.

diff --git a/lib/VNDB/DB/ b/lib/VNDB/DB/
index 8c27e55f..7d550c99 100644
--- a/lib/VNDB/DB/
+++ b/lib/VNDB/DB/
@@ -139,7 +139,7 @@ sub dbTagEdit {
$self->dbExec('DELETE FROM tags_parents WHERE tag = ?', $id);
$self->dbExec('INSERT INTO tags_parents (tag, parent) VALUES (?, ?)', $id, $_) for(@{$o{parents}});
- $self->dbExec('DELETE FROM tags_vn WHERE tag = ?', $id) if $o{meta} || ($o{state} && $o{state} == 1);
+ $self->dbExec('DELETE FROM tags_vn WHERE tag = ?', $id) if $o{meta};

@@ -242,7 +242,7 @@ sub dbTagLinkEdit {

# Fetch all tags related to a VN
-# Argument: %options->{ vid minrating results what page sort reverse }
+# Argument: %options->{ vid minrating results what page sort reverse onlyvisible }
# sort: name, rating
sub dbTagStats {
my($self, %o) = @_;
@@ -262,10 +262,13 @@ sub dbTagStats {
FROM tags t
JOIN tags_vn tv ON tv.tag =
WHERE tv.vid = ?
+ !s
- $o{vid}, defined $o{minrating} ? "HAVING $rating > $o{minrating}" : '', $order
+ $o{vid},
+ $o{onlyvisible} ? 'AND t.state <> 1' : '',
+ defined $o{minrating} ? "HAVING $rating > $o{minrating}" : '', $order

return wantarray ? ($r, $np) : $r;
diff --git a/lib/VNDB/Handler/ b/lib/VNDB/Handler/
index e9a5ee03..24cd84de 100644
--- a/lib/VNDB/Handler/
+++ b/lib/VNDB/Handler/
@@ -449,7 +449,7 @@ sub page {
div class => 'clearfloat', style => 'height: 5px', ''; # otherwise the tabs below aren't positioned correctly

# tags
- my $t = $self->dbTagStats(vid => $v->{id}, sort => 'rating', reverse => 1, minrating => 0, results => 999);
+ my $t = $self->dbTagStats(vid => $v->{id}, sort => 'rating', reverse => 1, minrating => 0, results => 999, onlyvisible => 1);
if(@$t) {
div id => 'tagops';
# NOTE: order of these links is hardcoded in JS

Idea from t10735.5. If the tag's average vote is zero or less, hide the tag on the voting page. Users would have to specifically search for the tag to vote on it. Of course, the tag is shown if the user has voted on it. Not sure it's a great idea, but it's something worth thinking about:

diff --git a/lib/VNDB/Handler/ b/lib/VNDB/Handler/
index 141c75aa..b99afb1b 100644
--- a/lib/VNDB/Handler/
+++ b/lib/VNDB/Handler/
@@ -600,6 +600,10 @@ sub _tagmod_list {
for my $t (@tags) {
my $m = $my{$t->{id}};
+ # hide tags with zero or negative avg vote unless user has voted on them
+ next if $t->{rating} <= 0 and not $m;
Tr id => "tgl_$t->{id}";
td class => 'tc_tagname'; a href => "/g$t->{id}", $t->{name}; end;
td class => 'tc_myvote', $m->{vote}||0;

Also, yorhel, I thought you were a tab person. I am disappoint.Last modified on 2018-06-12 at 15:14
#440 by yorhel
2018-06-13 at 16:28
I see my efforts to ease setting up a development environment didn't really help...

Do not delete users' votes for the tag when a tag is deleted.
Let me figure out the implications of this one for a bit. My assumption in writing code was that deleted tags have no votes, so I need to revisit the relevant code to see how/if that changes anything.

Hide deleted tags from tag cloud.
...this is one such a case where that assumption was baked in. I'll go over the code to find other ones and see if I'll go with the "ensure votes are actually deleted" (because clearly the assumption doesn't always hold right now) or with the "just keep them and handle it" approach.

If the tag's average vote is zero or less, hide the tag on the voting page.
I'm also not sure this is a good idea. I'd say hiding these might be unintuitive (the list of tags would vary depending on the user, could cause confusion).
#441 by leery
2018-06-13 at 17:36
The one implication I can come up with is that the deleted tag is still visible on a VN's tagmod page if someone has voted on it.

I do recognise the first patch is a bit marginal, and an alternative way to approach this would be to train the mods to not hit 'deny' without a tiny bit of public discussion. Unless the tag is indeed truly terrible.

(Incidentally, I'm still waiting for the tag moderation queue to be cleared. Three out of the five remaining 'old' ones are mine...)

The second patch... Hm, well, I'm not sure what to say about it. It's supposed to be a way to quickly nullify bad votes and prevent future 'yeah, I guess this fits, sort of' votes. (The pessimist in me says that this 'maybe' vote will be represented by a '3'.)

If you have better ideas on how to achieve something like that, I'd like to hear them, but I do understand that the end goal might not be terribly important, too.

I see my efforts to ease setting up a development environment didn't really help...

It's just that web applications that indeed deserve to be called applications do take a good amount of effort to set up. I do have an apache and a postgres and even a... I forgot what that shim was called, that 'new FastCGI' for Perl. It shouldn't take much time, but I know it will.Last modified on 2018-06-13 at 17:40
#442 by yorhel
2018-06-13 at 17:51
The one implication I can come up with is that the deleted tag is still visible on a VN's tagmod page if someone has voted on it.
I'll need to check if this affects tag_vn_calc(). And there's this message. I'm too tired to figure out if more is affected at the moment.

I do have an apache and a postgres and even a... I forgot what that shim was called, that 'new FastCGI' for Perl
You don't really need apache or FastCGI anymore; TUWF has its own internal dev server. The biggest annoyances with setting up VNDB are the PostgreSQL setup and the Perl dependencies (some modules are typically provided by your OS, some need to be installed from cpan, and cpan is source-based and there's 10 different ways to install and manage modules...). (On the upside, you don't need TUWF from git if you're just running v2, you can just get the version from cpan. Only v3 requires the git version. Hmm I could make it a git submodule, but submodules aren't exactly user-friendly either)
#443 by [deleted]
2018-06-24 at 10:37
Could we have an option to sort by non-Bayesian averages?
#444 by yorhel
2018-06-24 at 11:16
Could we have an option to sort by non-Bayesian averages?
This requires maintaining an additional cached column to keep it performant, complicates UI considerations, and would need a "minimum votes" filter to be useful. I don't think that's worth it.
#445 by micah686
2018-06-26 at 04:24
Could we have a preview box when adding replies on threads, so that we can see what the formatting looks like before we submit it?
#446 by tw1sted
2018-06-26 at 05:19
This might have been asked before, but would it be possible to add visual novel filters to the character search? Like for example, say I want to search for characters with white hair but filter out those in nukige. There's no way to do that currently.
#447 by periah250
2018-06-26 at 06:47
A way to filter out trash?
the site has become swelled by games like these
In other words complete trash, Can we make a filter option for games with actual budget or something because yes we can filter through commercial releases but then the fan translation are skipped. Can we have a filter option for trash? Also some indie games aren't too bad and can be actually really nice Like
linkLast modified on 2018-06-26 at 06:49
#448 by thewayfarer
2018-06-26 at 11:13
There's the 'blacklist' function. You could exclude all entries from appearing on the home page and from the randomizer by blacklisting VNs - that you *don't* like.
#449 by [deleted]
2018-06-26 at 13:54
#447 That is some awfully abstract criteria. Give an actual measure of “actual budget” and maybe we can discuss this.

Those first two games are probably better than DDLC anyway.Last modified on 2018-06-26 at 13:54
#450 by 707
2018-06-26 at 14:16
Is it possible to add "Freemium" or "Free to Play" or something to the Releases


You must be logged in to reply to this thread.