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

[Milagro]

Hello I have made a mask Multi Genre, but the list also displays single and unknown Genres.
Is it possible to have a filer so that only the multi genre are displayed?

Code: Select all

Multi Genre|Child of:Library|Position:Before\<Multi genre|Sort by:Count(Tracks)|Sort order:desc|Statistic:Count(Tracks)>

[ZvezdanD]

Is it possible to have a filer so that only the multi genre are displayed?

Do you want to display only tracks which have two or more genres? Did you try the "Multi-item Genre" node from the "Multi-item fields" folder?

[Milagro]

I can not find the Multi-item genre node, wen I ad the mask I get a error.
I am running the latest version

Code: Select all

Multi Genre|Child of:Library|Position:Before\<Multi-item genre|Sort by:Count(Tracks)|Sort order:desc|Statistic:Count(Tracks)>

I also have a mask that count the genres' is it possible to start with the name of the genre instead of the number of tracks?
Rock - 50 tracks and order them by Count(Tracks)?

Code: Select all

Genre|Child of:Library|Position:Before\<Genre|Sort by:Count(Tracks)|Sort order:desc|Statistic:Count(Tracks)>

[ZvezdanD]

I can not find the Multi-item genre node

Have you installed the predefined masks supplied with the add-on? Within the "Magic Nodes" folder of the Media Tree panel you should have the "Multi-item fields" sub-folder and within it you should have the "Multi-item Genre" node.

I also have a mask that count the genres' is it possible to start with the name of the genre instead of the number of tracks?
Rock - 50 tracks and order them by Count(Tracks)?

You should turn off the "Show sort key" option, so you would get:

Code: Select all

Genre|Child of:Library|Position:Before\<Genre|Sort by:Count(Tracks)|Sort order:desc|Show sort key:0|Statistic:Count(Tracks)>

[Milagro]

Thanks man looks good, real nice extension

[dypsis]

It has been a long time since I have used this script. How do I bring up the main menu?

Edit: I think I found it...
Under the "Edit" menu.

[fizzjob]

ZvezdanD, I see that you have some masks that will grab X number of songs from each artist (in this case, 2 songs):

Code: Select all

<Group|Name:Random|Show tracks:No>\2 Random Tracks from each Artist|Icon:0|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT DISTINCT ArtistsSongs.IDArtist AS IDArtist FROM ArtistsSongs WHERE (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL)) AS T1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = T1.IDArtist ORDER BY Random() LIMIT 2))

How would I go about modifying that so that:

1) Artists in the library with fewer than 2 songs get filtered out
2) The songs are presented "shuffled" by artist? For example, 2 songs by Led Zeppelen, 2 songs by The Beatles, then 2 songs by The Rolling Stones, instead of it being Beatles/Led Zeppelin/Rolling Stones.

Any help would be appreciated - thanks!

[ZvezdanD]

1) Artists in the library with fewer than 2 songs get filtered out

Code: Select all

<Group|Name:Random|Show tracks:No>\2 Random Tracks from each Artist having 2 or more tracks|Icon:0|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT IDArtist FROM ArtistsSongs WHERE (PersonType = 1 OR PersonType IS NULL) GROUP BY IDArtist HAVING Count(*) >= 2) AS T1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = T1.IDArtist ORDER BY Random() LIMIT 2))

2) The songs are presented "shuffled" by artist?

This is not currently possible, but you could get all tracks shuffled by adding one "invisible" sub-node with the Random sort order:

Code: Select all

<Group|Name:Random|Show tracks:No>\2 Random Tracks from each Artist having 2 or more tracks (shuffled tracks)|Icon:0|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT IDArtist FROM ArtistsSongs WHERE (PersonType = 1 OR PersonType IS NULL) GROUP BY IDArtist HAVING Count(*) >= 2) AS T1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = T1.IDArtist ORDER BY Random() LIMIT 2))\<Artist|Sort order:Random|Show nodes:No>

[fizzjob]

Thanks, ZvezdanD - the filtering out of single-track artists is a start.

[rrfpacker]

rrfpacker wrote:
Seems to me I just need to change >= 70 to Between 60 and 69 but that doesn't work.

Yes, that would be the right syntax. How that it is not working?

I get a script error when clicking on the node. The mask I modified looks like this;

<Group|Name:Random|Show tracks:No>\20 random complete Album with average rating = 3 to 3.5 stars|Icon:16|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE IDAlbum > 0 AND Rating >= 0 GROUP BY IDAlbum HAVING Count(TrackNumber) = Max(Cast(TrackNumber As integer)) AND Count(TrackNumber) > 3 AND Avg(Rating)= Between 60 and 69\<Album with album artist|Sort order:Random|Top:20|Show nodes:No>

I'm trying to get 20 (I can change the 20 to get other numbers) random albums with an average rating of 3.0 - 3.5. I modified another node you created a couple of pages back.

Also, thank you for answering my other question a couple of pages back about deleting the Sort Random filter. Works beautifully.

[ZvezdanD]

rrfpacker wrote:
Seems to me I just need to change >= 70 to Between 60 and 69 but that doesn't work.

Yes, that would be the right syntax. How that it is not working?

I get a script error when clicking on the node.

You haven't replaced ">= 70" with "Between 60 and 69", but with "= Between 60 and 69". "Between" is the valid operator, but "= Between" is not (http://www.sqlite.org/lang_expr.html), i.e. you have "=" in excess there.

[fizzjob]

This is not currently possible, but you could get all tracks shuffled by adding one "invisible" sub-node with the Random sort order:

Code: Select all

<Group|Name:Random|Show tracks:No>\2 Random Tracks from each Artist having 2 or more tracks (shuffled tracks)|Icon:0|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT IDArtist FROM ArtistsSongs WHERE (PersonType = 1 OR PersonType IS NULL) GROUP BY IDArtist HAVING Count(*) >= 2) AS T1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = T1.IDArtist ORDER BY Random() LIMIT 2))\<Artist|Sort order:Random|Show nodes:No>

I kind of have it working, the trick was adding an additional Order by Random() clause. It still seems a bit spotty, however, in that the artists' tracks aren't always grouped together.

Code: Select all

<Group|Name:Random|Show tracks:No>\2 Random Tracks from each Artist having 2 or more tracks|Icon:0|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs,(SELECT IDArtist FROM ArtistsSongs WHERE (PersonType = 1 OR PersonType IS NULL) GROUP BY IDArtist HAVING Count(*) >= 2 Order by Random()) AS T1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = T1.IDArtist ORDER BY Random() LIMIT 2))

Then again, the more I think of it, the more it seems to make sense as an AutoDJ script rather than a magic node.

[rrfpacker]

Thanks for showing me not to use =. I had tried it with and without the = and still got an error. I found I was missing the ")" after Between 60 and 69. Working nicely now. Thank you.

[vacilar]

I created a node which will crash MM every time i open or try to delete the node. How can i delete it now?

Ich habe einen Node erstellt der bei jedem öffnen oder Versuch den Node mit dem Rechtsklick-Menü zu löschen meinen MM-Player zum Absturz bringt?
Wie kann ich den nun entfernen ohne MM zu deinstallieren (meine anderen Nodes habe ich noch nicht gesichert!)
Bin für jede Hilfe dankbar

[ZvezdanD]

I created a node which will crash MM every time i open or try to delete the node. How can i delete it now?

There are 4 different methods of deleting Magic Nodes' masks, 3 of them are built-in:
1. open Edit > Magic Nodes Settings dialog box, select mask in Caption list and click on Delete button;
2. open Edit > Magic Nodes Export/Import dialog box, select mask in table and click on Del button;
3. select Magic Nodes' node in the Tree panel, right-click on it and choose Delete Magic Node;
4. open MediaMonkey.ini file in Notepad, find mask in CustomNodeMasks section, remove that line, save file and restart MediaMonkey.