The NEW Build Your Own Arcade Controls

Software Support => DOS/WinCab => Topic started by: gabypotter on June 21, 2006, 03:28:54 pm

Title: Add or Remove Songs from "Popular" list
Post by: gabypotter on June 21, 2006, 03:28:54 pm
Hi!
Is there a way to add or remove songs
from the "Popular" List?
which file is the one that saves that list?
Thanks!
Title: Re: Add or Remove Songs from "Popular" list
Post by: Chris on June 21, 2006, 04:47:49 pm
This information is stored in jukebox.db in the DATA folder.  The Popular list is based on the number of times a file has been played; the play count is written back to the database every time you close the jukebox.

If you edit this file with a text editor, you'll see the records for individual songs.  A song record looks like this:
{614313IWIL}{I Will Remember You}{Sarah McLachlan}{Singles}{0}{1145561514}{287}{0}{}{12}{1}{5}

I've highlighted the field that represents the play count.  This song has been played 12 times.  Each time a song is played, it's playcount (in memory) is incremented and the Popular table re-sorted.

Does this help?

--Chris
Title: Re: Add or Remove Songs from "Popular" list
Post by: gabypotter on June 21, 2006, 06:51:08 pm
thank you!!!
very very very much!!!
Title: Re: Add or Remove Songs from "Popular" list
Post by: Chris on June 21, 2006, 10:06:34 pm
For those curious about all the fields, here they are from left to right:

// Database fields:
#define DB_ID           0   //    Normalized file ID
#define DB_TITLE        1   //    Title
#define DB_ARTIST       2   //    Artist
#define DB_ALBUM        3   //    Album
#define DB_TRACKNO      4   //    Track Number
#define DB_DATE         5   //    Date last updated
#define DB_LENGTH       6   //    Song length in seconds
#define DB_PLAYCOUNT    7   //    Playcount
#define DB_GENRE        8   //    Genre
#define DB_YEAR         9   //    Year of release
#define DB_TITLESTRIP   10  //    Reverse index to titlestrip
#define DB_FOLDERID     11  //    Integer pointer to folder, used to match "special case" albums