Re: [Banshee-List] Scoring question
- From: Isaac Witmer <isaaclw gmail com>
- To: banshee-list gnome org
- Subject: Re: [Banshee-List] Scoring question
- Date: Mon, 9 May 2011 17:30:30 +0300
A friend of mine helped me fix it:
1) install sqlitebrowser
2) close banshee and copy/backup ~/.config/banshee-1/banshee.db
3) open up the browser, and open up ~/.config/banshee-1/banshee.db
4) run this code:
--------------------------------------------
UPDATE CoreTracks
SET Score = CAST(ROUND(100.00 * PlayCount / (PlayCount + SkipCount)) AS
INTEGER)
WHERE PlayCount + SkipCount > 0
--------------------------------------------
(it sets the score based on the stored play and skip counts)
5) save the database.
Origin:
https://bugzilla.gnome.org/show_bug.cgi?id=594568#c15
On Mon, May 9, 2011 at 4:38 PM, isaaclw <
isaaclw gmail com> wrote:
>
> Is there a way to do this, but only for songs with a certain number of plays?
> I want to set all songs with >=1 play and a score of 0, to 100.
>
> (I have zero score for many songs with a high count of plays, which is
> screwing things up)
>
>
> Freddy-N wrote:
> >
> > At first close Banshee and make a copy of your database
> > ~/.config/banshee-1/banshee.db
> >
> > Then make sure you have 'sqlite3 command line tool' installed. In a
> > terminal you can reset rating, score and other values with the 'sqlite3'
> > command.
> >
> >
> > Reset rating: sqlite3 ~/.config/banshee-1/banshee.db "update CoreTracks
> > set Rating=0"
> > Reset score: sqlite3 ~/.config/banshee-1/banshee.db "update CoreTracks
> > set Score=0"
> >
> > Command line is case sensitive and quotes and are mandatory!
> >
> >
> > Other values are: PlayCount=0 ; SkipCount=0
> >
>
>
> --
> View this message in context:
http://banshee-media-player.2283330.n4.nabble.com/Scoring-question-tp3497316p3509281.html
> Sent from the Banshee Media Player mailing list archive at Nabble.com.
> _______________________________________________
> banshee-list mailing list
>
banshee-list gnome org
>
http://mail.gnome.org/mailman/listinfo/banshee-list (unsubscribe here)
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]