Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by nynaevelan » Wed Jan 13, 2010 6:13 am

The easiest way would be to create a filter that filters out compilation albums, at least that is the way that I do it. :wink:
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

rrfpacker
Posts: 1043
Joined: Sat Jul 12, 2008 5:47 pm

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by rrfpacker » Wed Jan 13, 2010 4:10 pm

Do you mean a filter in the MN mask or a MM filter? I'd rather not use an MM filter. I tried to create a filter in MN but the filter section doesn't let me do anything.

I created the modified mask by copy/pasting another one into the mask field at the bottom and changing one character. Is this the problem? Do I need to create the mask from scratch for the filter section to work?

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by nynaevelan » Wed Jan 13, 2010 5:49 pm

Yeah I was talking about a MM filter, which you can use in the MN mask.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

phuzz
Posts: 11
Joined: Sat May 31, 2008 1:50 pm
Location: Canada

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by phuzz » Sun Jan 17, 2010 9:15 pm

Hello all..

I apologize ahead of time if that has already been answered elsewhere in this thread.

What I would like to know is if it is possible to generate masks using playcount information for a specific period of time...

for examples if I wanted to query all tracks that have had 5 or more plays in the last 30 days

Any guidance would be greatly appreciated!

Vyper
Posts: 845
Joined: Tue May 23, 2006 5:53 pm

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Vyper » Sun Jan 17, 2010 10:13 pm

phuzz wrote:Hello all..

I apologize ahead of time if that has already been answered elsewhere in this thread.

What I would like to know is if it is possible to generate masks using playcount information for a specific period of time...

for examples if I wanted to query all tracks that have had 5 or more plays in the last 30 days

Any guidance would be greatly appreciated!
Wouldn't an autoplaylist do what you want? For example, I created a test playlist with the following parameters and it seems to do exactly what you want:


Image


I may be misunderstanding what 'timestamp' does, though.
Stop Button Freak

phuzz
Posts: 11
Joined: Sat May 31, 2008 1:50 pm
Location: Canada

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by phuzz » Sun Jan 17, 2010 10:31 pm

Yeah I don't think that's giving me quite what I am trying to achieve, although I had not thought of using autoplaylists (that certainly would be an option).

It appears what the example you gave above generates a list of tracks with more than 5 plays AND timestamped in the last 30 days. The timestamp value however appears to be a value generated when the file is modified and as such isn't useful for what I am trying to achieve.

To clarify I would like to query tracks played 5 times IN the last 30 days, so a track that was played 20 times but all over a month ago would not be part of the results.

Weatherman
Posts: 151
Joined: Sun Nov 19, 2006 11:08 am

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Weatherman » Tue Jan 19, 2010 10:56 pm

Sticking with the autoplaylist format, instead of selecting "Timestamp", select "Last Played" and give it a value of less than 6 days. You should receive a list of songs which have been played more than 5 times within the last 5 days
Jim

Guest

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Guest » Wed Jan 20, 2010 4:35 am

Weatherman wrote:Sticking with the autoplaylist format, instead of selecting "Timestamp", select "Last Played" and give it a value of less than 6 days. You should receive a list of songs which have been played more than 5 times within the last 5 days
Jim
I don't think so. With the autoplaylist you could receive a list of songs which have been played more than 5 times anytime, but only the last song played within the last 5 days. For example, you would get a track played 1000 times, but played only once within the last 5 days.

You could try this instead:

Code: Select all

Played at least 5 times within last 30 days|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs LEFT JOIN Played ON Songs.ID = Played.IDSong WHERE CAST(julianday(date('now', 'localtime')) - julianday(date(Played.PlayDate + julianday('1899-12-30'))) AS integer) <= 30 GROUP BY Songs.ID HAVING Count(*) >= 5)\<Title>

Weatherman
Posts: 151
Joined: Sun Nov 19, 2006 11:08 am

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Weatherman » Wed Jan 20, 2010 1:37 pm

I think you're right. Sorry for raising hopes...I'm crap at creating these things too....it is really great there are so many pre-made nodes and Reg Exp - thanks to all you people who actually know this stuff.
Jim

phuzz
Posts: 11
Joined: Sat May 31, 2008 1:50 pm
Location: Canada

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by phuzz » Thu Jan 21, 2010 10:12 pm

Yes this is exactly what I was looking for. I figured it had to be possible I just wasn't up on my sql queries. Thanks all for you assistance!

declan
Posts: 85
Joined: Wed Sep 20, 2006 3:55 pm

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by declan » Sat Jan 23, 2010 5:46 am

Hi

I asked this some time ago, but didn't get an answer...
declan wrote:Is there a way to display an artist by "span"? ie the difference between the oldest and newest recording.

The best I can do is -

Code: Select all

Most Years|Show tracks:yes|icon: top level|Child of:Year|Filter:<Year> Between 1870 And 2070\<album artist|Sort by:Count(Year) Desc|Show rank:Yes|Top:100|Show sort key:0|Statistic:Min(Year), Max(Year), Count(Year)>\<Year>


Which shows the artists that I have music from that was recorded in the greatest number of years. But I want to be able to list someone whose career spanned 50 years (even if there are only tracks in 1959 and 2009 and nothing in between) ahead of artists who've I got tracks by from every year between 1960 and 2009.
I reckon there might be a SQL expression that'll do the job, but I'm damned if I can figure it out.

Cheers.

Guest

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Guest » Sat Jan 23, 2010 11:06 am

declan wrote:Is there a way to display an artist by "span"?
Not exactly, but you could try:

Code: Select all

Artists with 50 or more years between oldest and newest song|Filter:Songs.Artist IN (SELECT Artist FROM Songs WHERE Year > 19000000 GROUP BY Artist HAVING Max(Year) - Min(Year) >= 500000)\<Artist|Statistic:Min(Year), Max(Year)>\<Year>

Code: Select all

Artists with 40 to 50 years between oldest and newest song|Filter:Songs.Artist IN (SELECT Artist FROM Songs WHERE Year > 19000000 GROUP BY Artist HAVING Max(Year) - Min(Year) Between 400000 And 499999)\<Artist|Statistic:Min(Year), Max(Year)>\<Year>
and so on.

declan
Posts: 85
Joined: Wed Sep 20, 2006 3:55 pm

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by declan » Sat Jan 23, 2010 12:58 pm

Thank you Guest that (or a series of nodes based on that) does the job.

declan
Posts: 85
Joined: Wed Sep 20, 2006 3:55 pm

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by declan » Sat Jan 23, 2010 6:52 pm

Although how do I amend the Sql bit to work on the Album Artist field instead?

Stasis096

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Post by Stasis096 » Tue Jan 26, 2010 12:15 pm

I just downloaded MagicNodes script and am trying to create my own customized node. I want to create a "AlbumArtist does not equal Composer" node (it would be similar to the "Artist does not equal AlbumArtist" node). Any help would be appreciated.

Thanks

Post Reply