need a script for top 50 lists

Guest · Post by **Guest** » Sat Mar 04, 2006 10:14 pm

i know there is one in monkey but it does not do what i want it to do.

i am using the free version you all know that.

what i want to do is make the top 50 list clear it's self every sunday morning so it will only list the top songs for that week on the next saturday when i play it.

but the default top 50 list gets all the songs from all the play counts and it does not care when it was last played. so it will toss in christmas songs that have not been played since december.

thats not good as it makes out of season songs get played.

so i was trying to figure out how to code the list to just pick the top songs from the last seven days and clear itself every morning on the 8th day.

but i can not figure out how so i am asking for a new script. maybe it can be added to the monkey as a weekly count down list.?

roving cowboy / keith hall

just stopping by the fence again.

Spazz · Post by **Spazz** » Sun Mar 05, 2006 5:03 am

As far as I know you can't. I wish there would be an option that would record every time a song is played as I'd love to have a playlist that showed the most played songs of the last week or two.

Steegy · Post by **Steegy** » Sun Mar 05, 2006 7:46 am

Hello

To do it very easy, add this to the table Playlists in the database, as an AutoPlaylist:

Code: Select all

[Common]
QueryVersion=1
QueryType=2

[Basic]
SongTitle=
Artist=
Album=
Genre=
Comment=
Lyrics=
AnyField=
YearFrom=-1
YearTo=-1
SortOrder1=
SortOrder2=
SortOrder3=

[Adv]
ConditionsCount=1
OrdersCount=1
LimitTop=1
Top=50
LimitMB=0
MaxMB=650
LimitLen=0
MaxLen=74

[AdvCond1]
DBField=Songs.LastTimePlayed
Condition=401
Value=8

[AdvSO1]
Order=Songs.Rating
Asc=0

It gives the top 50 tracks, sorted on rating (good > less good) that have been played the last 7 (or is it 8?) days.
It doesn't clear anything, it just gives the last 7 (or

days.

I tried MagicNodes but that gave some sql errors, probably because I was doing it wrong.
A script is certainly possible, if these things don't work.

Cheers
Steegy

rovingcowboy · Post by **rovingcowboy** » Sun Mar 05, 2006 10:44 am

where do i put that?

Steegy · Post by **Steegy** » Sun Mar 05, 2006 1:06 pm

MediaMonkey.mdb ----> Tables:

In table "Playlists", add a new record (row) and use:
PlaylistName = TheNameYouWantForYourAutoPlaylist
ParentPlaylist = 0 (if you want the playlist to be on the top level)
IsAutoPlaylist = 1
QueryData = <<<TheCodeThatIPostedAbove>>>

Save & Close the database.
Start MediaMonkey... and have a new auto-playlist !

tarasis · Post by **tarasis** » Sun Mar 05, 2006 4:23 pm

Steegy wrote:MediaMonkey.mdb ----> Tables:

In table "Playlists", add a new record (row) and use:
PlaylistName = TheNameYouWantForYourAutoPlaylist
ParentPlaylist = 0 (if you want the playlist to be on the top level)
IsAutoPlaylist = 1
QueryData = <<<TheCodeThatIPostedAbove>>>

Save & Close the database.
Start MediaMonkey... and have a new auto-playlist !

Thanks thats quite useful but ouch on how you have to use it! I presume you have to have Access to be able to do this.

rovingcowboy · Post by **rovingcowboy** » Sun Mar 05, 2006 6:50 pm

so it is not a script but a database add in?

i can not open the database i don't have the acess program.

which is why i need to use scripts.

maybe jiri or rusty can add that in to the database for us.

Post by **Peke** » Sun Mar 05, 2006 8:51 pm

@tarasis,
Hmmmm.... Interesting. As I remember someone here on forum has manages to change Tables within MM or I'm wrong, maybe it could be used to produce rovingcowboy a help. Very interesting.

agentsmart · Post by **agentsmart** » Tue Mar 07, 2006 12:19 pm

hay this is a good idea.

are you going to put it in the main monkey database.
or is anyone making a script for it, i for one will add my
wish for this too.

psyXonova · Post by **psyXonova** » Wed Mar 08, 2006 5:28 am

Too much trouble for nothing... kk here it is

Right click the Top 50 - Favorites playlist --> Save as AutoPlaylist.
Select a meaningful name (eg Last Weeks Chart)
Ok, now right click that Playlist --> Edit Auto Playlist
Click Add search criteria, select Property Last Played, Condition < (days ago), value 7 and click OK.

Save the playlist, there you are. This playlist shows all the Top played Track for the past seven days. It is offcourse updated automatically everytime you view/play it.

Thats it. I think that Steegy was too bored to describe that procedure and thats why he suggested adding it manually inside the Playlist tables.

Steegy · Post by **Steegy** » Wed Mar 08, 2006 12:56 pm

Steegy wasn't bored. Steegy read the following:

i am using the free version you all know that.

So Steegy assumed that it was impossible to add or edit auto-playlists, but existing auto-playlists can be used so I proposed to add one through a more obscure "work-around" way (directly into the database).

Anyway, it should be possible using Magic Nodes, but I think there's an error in the MN script and that's why I can't get it to work.

There are free, light and simple alternatives for MSAccess, to open mdb databases, aren't there?

Cheers
Steegy

Bex · Post by **Bex** » Wed Mar 08, 2006 1:45 pm

Actually guys, this is not possible to achieve. The playcount consists of lifetime plays. It doesnt tell you in what period the play ocurred. So it's not possible to create a playlist or MN that consists of most played last week. What you get is "Of my highest playcount songs, give me those I have played last week".

But that is perhaps enough?

/Bex

rovingcowboy · Post by **rovingcowboy** » Wed Mar 08, 2006 5:24 pm

psyxonova wrote:Too much trouble for nothing... kk here it is

Right click the Top 50 - Favorites playlist --> Save as AutoPlaylist.
Select a meaningful name (eg Last Weeks Chart)
Ok, now right click that Playlist --> Edit Auto Playlist
Click Add search criteria, select Property Last Played, Condition < (days ago), value 7 and click OK.

Save the playlist, there you are. This playlist shows all the Top played Track for the past seven days. It is offcourse updated automatically everytime you view/play it.

Thats it. I think that Steegy was too bored to describe that procedure and thats why he suggested adding it manually inside the Playlist tables.

I'll try that but i was wanting to list all the songs played the most in the last week, i notice you typed that the list would show only the most played track.? is that typo and should it be "tracks.".

not steegy's right i can not do that in the free version.

bex

if i can get a list to show only the songs played in the last week. then they will show the play count and i can order them in the list by playcount that will give me the thing i want.

is that possible?

Teknojnky · Post by **Teknojnky** » Wed Mar 08, 2006 6:07 pm

Psyxonova's instructions work only for songs on a rolling 7 day window, not a weekly generated Sunday thru Saturday Top 50.

I don't think its possible via auto-playlists, however I would think thats its possible via script.

I would seem to need to be weekly calendar based and generate static playlists similar to the recently added playlist node.

rovingcowboy · Post by **rovingcowboy** » Thu Mar 09, 2006 5:29 pm

i don't know i was hoping it was easy to do with scripts but it looks like nobody can do it with scripts i hope they add in steegys code to the database?