Re: [Banshee-List] Scoring question

[Isaac Witmer <isaaclw gmail com>]

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)