Mass / Batch VN vote incrementing?

Posted in

#1 by monocrome
2020-01-14 at 01:19
It would be handy to have a feature on the "My Visual Novel List" & "My Votes" table which would increment/decrement all VN votes by 1.

This would help to save time, as in my case I have 10 VNs listed at "10", to address this I want to decrease all my votes by 1, and reserve a top 3/5 for "10"s.

Call me lazy, but I don't want to sieve through 150+ VN's manually. *Although I will, when I find the time.*

Sorry if this is already a feature and I can't seem to find it.
I even tried using query.vndb.org: UPDATE ulist_vns SET vote = vote - 10 where uid = '142095' and vote > '0'
but obviously, permission to edit values is denied.Last modified on 2020-01-14 at 01:19
#2 by fuukanou
2020-01-14 at 01:31
With the new lists you can do it pretty fast from that (even if it is manual), especially because you don't have decimal votes. Turn off all columns apart from vote, sort by vote, use left hand on keypad and right hand on mouse. Shouldn't take more than 10 minutes.Last modified on 2020-01-14 at 01:32
#3 by monocrome
2020-01-14 at 01:55
@fuukanou Yeah, that works, it's a bit wonky, sometimes the vote changes to "error" but overall, the keypad was much quicker than just mouse > dropdown list.

Great, now I feel like I'm doing a disservice putting all my 8's at 7. lol
#4 by fuukanou
2020-01-14 at 01:56
#3, I know the feeling very well. I wanted to split some of my votes more finely but I always felt like there was something arbitrary about my new selection and kinda felt bad I wasn't promoting more.

Reply

You must be logged in to reply to this thread.