Page 108 of 170
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Thu Mar 10, 2011 12:23 pm
by 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)>
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Thu Mar 10, 2011 5:08 pm
by ZvezdanD
Milagro wrote: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?
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Fri Mar 11, 2011 8:09 am
by 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)>
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Fri Mar 11, 2011 5:38 pm
by ZvezdanD
Milagro wrote: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.
Milagro wrote: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)>
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Sat Mar 12, 2011 6:04 am
by Milagro
Thanks man looks good, real nice extension
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Sun Mar 13, 2011 2:46 am
by 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.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Tue Mar 15, 2011 11:31 am
by 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!
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Wed Mar 16, 2011 3:44 am
by ZvezdanD
fizzjob wrote: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))
fizzjob wrote: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>
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Wed Mar 16, 2011 9:50 am
by fizzjob
Thanks, ZvezdanD - the filtering out of single-track artists is a start.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Wed Mar 16, 2011 12:46 pm
by 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.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Wed Mar 16, 2011 2:50 pm
by ZvezdanD
rrfpacker wrote: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.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Thu Mar 17, 2011 1:40 pm
by fizzjob
ZvezdanD wrote: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.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Thu Mar 17, 2011 5:07 pm
by 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.
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Tue Mar 22, 2011 5:22 am
by 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
Re: Magic Nodes 4.1.2 w/ 370 masks & real GUI (2011-03-07)[M
Posted: Tue Mar 22, 2011 7:34 am
by ZvezdanD
vacilar wrote: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.